[Firebird-devel] [FB-Tracker] Created: (CORE-3889) Please add support for -? in firebird.exe

2012-07-13 Thread Carlos H. Cantu (JIRA)
Please add support for -? in firebird.exe - Key: CORE-3889 URL: http://tracker.firebirdsql.org/browse/CORE-3889 Project: Firebird Core Issue Type: Improvement Affects Versions: 3.0 Alpha 1

Re: [Firebird-devel] Evaluation of derived tables and CTE's

2012-07-13 Thread Mark Rotteveel
On 12-7-2012 22:14, Leyne, Sean wrote: > Bad example, I should have said that: > > SELECT ... FROM ... WHERE ColumnA = COS( ColumnB) > > Doesn't use an index when it should be able to, just as the engine is able to > use an index for this query > > SELECT ... FROM ... WHERE ColumnA =

Re: [Firebird-devel] Evaluation of derived tables and CTE's

2012-07-13 Thread Dmitry Yemanov
13.07.2012 0:14, Leyne, Sean wrote: > > Bad example, I should have said that: > > SELECT ... FROM ... WHERE ColumnA = COS( ColumnB) > > Doesn't use an index when it should be able to, just as the engine is able to > use an index for this query > > SELECT ... FROM ... WHERE ColumnA = Co

Re: [Firebird-devel] Evaluation of derived tables and CTE's - Email found in subject

2012-07-13 Thread Leyne, Sean
Mark, > On 12-7-2012 22:14, Leyne, Sean wrote: > > Bad example, I should have said that: > > > > SELECT ... FROM ... WHERE ColumnA = COS( ColumnB) > > > > Doesn't use an index when it should be able to, just as the engine is > > able to use an index for this query > > > > SELECT ... FROM