|
|
|
It was not possible to set a default field value to SYSDATE (and others) using alter table. For example, the following failed with a c-treeDB invalid date error when the table contained records:
alter table mytbl add mycol date default SYSDATE;
The alter table logic considered SYSDATE to be a literal value for the field. c-treeDB tried to set the new field value to the default using the SYSDATE literal, which was not a valid date.
Alter table logic has been modified to allow this.
