Hi,
I like to report an error in FB2-beta (see below) to firebird-develop.
But i can not find this group in Yahoo, and also sending a new thread
from Outlook Express to news.atkin.com/sourceforge.firebird-develop
has no effect.
Thanks,
Robert



Hi,
I'm testing WI-T2.0.0.11675 Firebird 2.0 Beta 1 on Windows XP.
It looks to me that the new DROP DEFAULT clause for ALTER TABLE does
not
work correct in all situations.

For next sequence DROP DEFAULT have no effect. Afterwards, the
default of
Field1 is still 1.

ALTER TABLE Table1
ADD IntegerField INTEGER DEFAULT 1;

ALTER TABLE Table1
ALTER IntegerField DROP DEFAULT;


And for next sequence DROP DEFAULT works correctly.

ALTER TABLE Table1
ADD IntegerField INTEGER;

ALTER TABLE Table1
ALTER IntegerField SET DEFAULT 1;

ALTER TABLE Table1
ALTER IntegerField DROP DEFAULT;

Robert.