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

On 25-4-2017 18:21, Lester Caine les...@lsces.co.uk [firebird-support] wrote: > On 25/04/17 16:50, Mark Rotteveel m...@lawinegevaar.nl > [firebird-support] wrote: >> The SQL standard is quite clear at what needs to happen: adding a new >> column with a default should behave as if that column has

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

On 25/04/17 16:50, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote: > The SQL standard is quite clear at what needs to happen: adding a new > column with a default should behave as if that column has existed from > the original create table (btw: irrespective of the NOT NULL

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

On 25-4-2017 17:43, Lester Caine les...@lsces.co.uk [firebird-support] wrote: > On 25/04/17 12:51, Maxi maxiroba...@gmail.com [firebird-support] wrote: >> I expect the value assigned by DEFAULT when I add the new field is >> still there. > > There has been various discussions on this area ... >

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

On 25/04/17 12:51, Maxi maxiroba...@gmail.com [firebird-support] wrote: > I expect the value assigned by DEFAULT when I add the new field is > still there. There has been various discussions on this area ... If you add 'NOT NULL' to an existing field, then you need to populate the existing

Re: [firebird-support] Immediate Detection of Disconnected Clients on Classic

---In firebird-support@yahoogroups.com, wrote : On 24.04.2017 o 10:41, atunccekic@... mailto:atunccekic@... [firebird-support] wrote: > We have some desktop applications which are connecting to firebird, started > crashing for a while. > These applications are mostly on

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

---In firebird-support@yahoogroups.com, wrote : 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

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

On 24-4-2017 20:50, Maxi maxiroba...@gmail.com [firebird-support] wrote: > > > 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) > > >

Re: [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

Re: [firebird-support] Immediate Detection of Disconnected Clients on Classic

On 24.04.2017 o 10:41, atuncce...@duzen.com.tr [firebird-support] wrote: > We have some desktop applications which are connecting to firebird, started > crashing for a while. > These applications are mostly on our wireless link connected building so > I'm suspicious about the network. >

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