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

2017-04-25 11:24 GMT-03:00 Svein Erling Tysvær setys...@gmail.com [firebird-support] : > > > Hi everyone, >> >> I encountered strange behavior droping a column definition with default >> value. >> >> The environment is Ubuntu 16.04 LTS 64 bits, Firebird version

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

2017-04-24 16:39 GMT-03:00 '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

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

Hi everyone, I encountered strange behavior droping a column definition with default value. The environment is Ubuntu 16.04 LTS 64 bits, Firebird version LI-V2.5.6.27020 (Firebird 2.5 SuperClassic) I'll try to explain with an example. The statement sequence is: 1. Create the table CREATE

[firebird-support] Case insensitive SIMILAR TO

Hi, Which is the better approach to make a case insensitive SIMILAR TO query ? Example: CREATE TABLE LOOKUP_ARTICLE ( ID INTEGER NOT NULL, HEADLINE VARCHAR(100) NOT NULL, PUB_DATE TIMESTAMP NOT NULL, AUTHOR_ID INTEGER, CONSTRAINT INTEG_354 PRIMARY KEY (ID) ); INSERT INTO