ALTER COLUMN ... WITH DEFAULT NULL does not change the default
--------------------------------------------------------------
Key: DERBY-4006
URL: https://issues.apache.org/jira/browse/DERBY-4006
Project: Derby
Issue Type: Bug
Components: SQL
Affects Versions: 10.4.2.0
Reporter: Knut Anders Hatlen
Reported on derby-user.
http://mail-archives.apache.org/mod_mbox/db-derby-user/200901.mbox/%[email protected]%3e
ij> create table t (x varchar(5) default 'abc');
0 rows inserted/updated/deleted
ij> alter table t alter column x with default null;
0 rows inserted/updated/deleted
ij> insert into t values default;
1 row inserted/updated/deleted
ij> select * from t;
X
-----
abc
1 row selected
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
