[DERBY-4006] ALTER COLUMN ... WITH DEFAULT NULL does not change the default

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 10.2.2.0, 10.3.1.4, 10.3.2.1, 10.3.3.0, 10.4.1.3, 10.4.2.0
• Fix Version/s: 10.4.2.1, 10.5.1.1
• Component/s: SQL
• Bug behavior facts: Regression
• Assignee: Bryan Pendleton
• Reporter: Knut Anders Hatlen
• Created: 08/Jan/09 11:57
• Updated: 30/Jun/09 15:55
• Resolved: 19/Jan/09 18:09

Description

Reported on derby-user.
http://mail-archives.apache.org/mod_mbox/db-derby-user/200901.mbox/[e-mail]%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