Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Derby Discussion" <derby-user@db.apache.org>
Received-SPF: pass (athena.apache.org: local policy)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
  s=s1024; d=yahoo.com;
  h=Received:X-Mailer:Date:From:Subject:To:MIME-Version:Content-Type:Message-ID;
  b=6CL9gkOJfGXunSylZA9YNpFK71CDmZex9TrWRgFOiIuNo2CsTOn0tCRKDLq9u4o2876G1tiigC8qm1K0KlSkITmqNbv3b9wwD5Y45ZTLAnSoUJMFrtocwWkicFgw6nxL0BKX2ZGPG3g+U6oT/AX6El2SgsHkKswa9GfGip8kQK8=;
Date: Sun, 13 Jul 2008 14:41:25 -0700 (PDT)
From: Geoff hendrey <geoff_hendrey@yahoo.com>
Subject: Re: alter table behavior changed?
To: Derby Discussion <derby-user@db.apache.org>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="0-1536856915-1215985285=:28128"
Message-ID: <807746.28128.qm@web31803.mail.mud.yahoo.com>

--0-1536856915-1215985285=:28128
Content-Type: text/plain; charset=us-ascii

Hi Brian,

Unfortunately, I think I wasted your time. The problem was most likely caused by a bug in my code. Thank you for providing the code.

 -geoff


----- Original Message ----
From: Bryan Pendleton <bpendleton@amberpoint.com>
To: Derby Discussion <derby-user@db.apache.org>
Sent: Thursday, July 10, 2008 6:59:28 AM
Subject: Re: alter table behavior changed?

> Since there is no way to say "NULL" (NOT NULL may be specified), one 
> would assume that the default behavior when one omits "NOT NULL", is to 
> produce a column that allows NULL. But derby 10.4 is acting as if NOT 
> NULL is the default. 

Hi Geoff,

I'm not seeing the behavior you're seeing. Perhaps you are doing something
different than I? Here's a short script:

ij> connect 'jdbc:derby:brydb;create=true';
ij> create table t (c1 int);
0 rows inserted/updated/deleted
ij> describe t;
COLUMN_NAME         |TYPE_NAME|DEC&|NUM&|COLUM&|COLUMN_DEF|CHAR_OCTE&|IS_NULL&
------------------------------------------------------------------------------
C1                  |INTEGER  |0   |10  |10    |NULL      |NULL      |YES

1 row selected
ij> alter table t add column c2 varchar(10);
0 rows inserted/updated/deleted
ij> describe t;
COLUMN_NAME         |TYPE_NAME|DEC&|NUM&|COLUM&|COLUMN_DEF|CHAR_OCTE&|IS_NULL&
------------------------------------------------------------------------------
C1                  |INTEGER  |0   |10  |10    |NULL      |NULL      |YES
C2                  |VARCHAR  |NULL|NULL|10    |NULL      |20        |YES

2 rows selected

ij> insert into t (c1) values (1);
1 row inserted/updated/deleted
ij> select * from t;
C1         |C2
----------------------
1          |NULL

1 row selected

Can you post a more complete script demonstrating the problematic behavior?

thanks,

bryan
--0-1536856915-1215985285=:28128
Content-Type: text/html; charset=us-ascii

<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:arial,helvetica,sans-serif;font-size:12pt">Hi Brian,<br><br>Unfortunately, I think I wasted your time. The problem was most likely caused by a bug in my code. Thank you for providing the code.<br><div>&nbsp;</div>-geoff<br><br><div><br></div><div style="font-family: arial,helvetica,sans-serif; font-size: 12pt;"><br><div style="font-family: arial,helvetica,sans-serif; font-size: 13px;">----- Original Message ----<br>From: Bryan Pendleton &lt;bpendleton@amberpoint.com&gt;<br>To: Derby Discussion &lt;derby-user@db.apache.org&gt;<br>Sent: Thursday, July 10, 2008 6:59:28 AM<br>Subject: Re: alter table behavior changed?<br><br>
&gt; Since there is no way to say "NULL" (NOT NULL may be specified), one <br>&gt; would assume that the default behavior when one omits "NOT NULL", is to <br>&gt; produce a column that allows NULL. But derby 10.4 is acting as if NOT <br>&gt; NULL is the default. <br><br>Hi Geoff,<br><br>I'm not seeing the behavior you're seeing. Perhaps you are doing something<br>different than I? Here's a short script:<br><br>ij&gt; connect 'jdbc:derby:brydb;create=true';<br>ij&gt; create table t (c1 int);<br>0 rows inserted/updated/deleted<br>ij&gt; describe t;<br>COLUMN_NAME&nbsp; &nbsp; &nbsp; &nbsp;  |TYPE_NAME|DEC&amp;|NUM&amp;|COLUM&amp;|COLUMN_DEF|CHAR_OCTE&amp;|IS_NULL&amp;<br>------------------------------------------------------------------------------<br>C1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; |INTEGER&nbsp; |0&nbsp;  |10&nbsp; |10&nbsp; &nbsp; |NULL&nbsp; &nbsp; &nbsp; |NULL&nbsp; &nbsp; &nbsp; |YES<br><br>1 row selected<br>ij&gt;
 alter table t add column c2 varchar(10);<br>0 rows inserted/updated/deleted<br>ij&gt; describe t;<br>COLUMN_NAME&nbsp; &nbsp; &nbsp; &nbsp;  |TYPE_NAME|DEC&amp;|NUM&amp;|COLUM&amp;|COLUMN_DEF|CHAR_OCTE&amp;|IS_NULL&amp;<br>------------------------------------------------------------------------------<br>C1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; |INTEGER&nbsp; |0&nbsp;  |10&nbsp; |10&nbsp; &nbsp; |NULL&nbsp; &nbsp; &nbsp; |NULL&nbsp; &nbsp; &nbsp; |YES<br>C2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; |VARCHAR&nbsp; |NULL|NULL|10&nbsp; &nbsp; |NULL&nbsp; &nbsp; &nbsp; |20&nbsp; &nbsp; &nbsp; &nbsp; |YES<br><br>2 rows selected<br><br>ij&gt; insert into t (c1) values (1);<br>1 row inserted/updated/deleted<br>ij&gt; select * from t;<br>C1&nbsp; &nbsp; &nbsp; &nbsp;  |C2<br>----------------------<br>1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; |NULL<br><br>1 row selected<br><br>Can you post a more complete script demonstrating
 the problematic behavior?<br><br>thanks,<br><br>bryan<br><br></div></div></div></body></html>
--0-1536856915-1215985285=:28128--