RE: [firebird-support] Firebird 2.5 - Alter table - drop default - bug or feature

['Leyne, Sean' s...@broadviewsoftware.com [firebird-support]]

> 3. Alter the table
> ALTER TABLE "SCHEMA_AUTHOR" ADD "SURNAME" varchar(15) DEFAULT
> 'surname default' NOT NULL
> 
> After step 3, I have a record with a new column with 'surname default' value
> into SURNAME field.
> 
> 4. Drop default definition
> ALTER TABLE "SCHEMA_AUTHOR" ALTER COLUMN "SURNAME" DROP
> DEFAULT
> 
> After step 4, the SURNAME field value is setting to empty string ('')
> 
> Is that the correct behavior ?

You dropped the "DEFAULT", what would you expect the system to assign?


Sean