RE: [firebird-support] Upgrade Firebird 1.5.3 to 2.5.4 - Existence Predicates NOT IN Question

2015-07-24 Thread 'stwizard' stwiz...@att.net [firebird-support]
1.5.3 to 2.5.4 - Existence Predicates NOT IN Question On 24-7-2015 13:25, 'stwizard' stwiz...@att.net [firebird-support] wrote: > Greetings All, > > In the Firebird 2 Migration & Installation guide > http://www.firebirdsql.org/file/documentation/release_notes/Fireb

RE: [firebird-support] Upgrade Firebird 1.5.3 to 2.5.4 - Existence Predicates NOT IN Question

2015-07-24 Thread 'stwizard' stwiz...@att.net [firebird-support]
1.5.3 to 2.5.4 - Existence Predicates NOT IN Question >Existence Predicates NOT IN and ALL May Be Slow > >Firebird and, before that, InterBase, have produced incorrect results for the logical existence predicates ALL and NOT IN for many years. >That problem has been corrected

Re: [firebird-support] Upgrade Firebird 1.5.3 to 2.5.4 - Existence Predicates NOT IN Question

2015-07-24 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 24-7-2015 13:25, 'stwizard' stwiz...@att.net [firebird-support] wrote: > Greetings All, > > In the Firebird 2 Migration & Installation guide > http://www.firebirdsql.org/file/documentation/release_notes/Firebird-2_1_6-Installation.pdf > on page 8 under the performance section it states the follo

Rif: Re: [firebird-support] Upgrade Firebird 1.5.3 to 2.5.4 - Existence Predicates NOT IN Question

2015-07-24 Thread 'Raffaele Confalone' r.confal...@libero.it [firebird-support]
ggetto: Re: [firebird-support] Upgrade Firebird 1.5.3 to 2.5.4 - Existence Predicates NOT IN Question >Existence Predicates NOT IN and ALL May Be Slow > >Firebird and, before that, InterBase, have produced incorrect results for the logical existence predicates ALL and NOT IN for many y

Re: [firebird-support] Upgrade Firebird 1.5.3 to 2.5.4 - Existence Predicates NOT IN Question

2015-07-24 Thread setysvar setys...@gmail.com [firebird-support]
>Existence Predicates NOT IN and ALL May Be Slow > >Firebird and, before that, InterBase, have produced incorrect results for the logical existence predicates ALL and NOT IN for many years. >That problem has been corrected in Firebird 2.0, but the change means that indexes on the inner tables

[firebird-support] Upgrade Firebird 1.5.3 to 2.5.4 - Existence Predicates NOT IN Question

2015-07-24 Thread 'stwizard' stwiz...@att.net [firebird-support]
Greetings All, In the Firebird 2 Migration & Installation guide http://www.firebirdsql.org/file/documentation/release_notes/Firebird-2_1_6-Installation.pdf on page 8 under the performance section i