>Hello Ann
>
>Can you please explain better that phrase?
>
>"With outer joins, a condition in the WHERE clause that affects the right side
>of a left outer join (the one that doesn't have to exist) effectively
>turns off the outerness of the join (unless it includes OR IS NULL)."
I think this i
Thank you very much Set for your answer.
Greetings.
Walter.
On Thu, May 29, 2014 at 6:28 AM, Svein Erling Tysvær
svein.erling.tysv...@kreftregisteret.no [firebird-support] <
firebird-support@yahoogroups.com> wrote:
>
>
> >Hello Ann
> >
> >Can you please explain better that phrase?
> >
> >"Wit
We recently upgraded our database server from Win server 2003 to Win 2008
server. We upgraded hardware as well.
The new hardware (IBM x3550 M4) is way more advanced than the old one. 4 times
the RAM and CPU speed.
We ran some tests on the new hardware(a few select/update queries), the
performa
I have a problem whereby Firebird 2.5.2 (CS / Windows) is not using the
expected index. I have confirmed that the index stats are up to date. Here is
the reproducible test case:
-- CREATE TABLES
CREATE TABLE TABLE1
(
TABLE1ID INTEGER,
SOMEVALUE INTEGER,
CONSTRAINT PK_TABLE1 PRIMARY KEY (T
Halim,
It is out of context. Recent 2.5.2 has no such problem.
Where did you read it?
Regards,
Alexey Kovyazin
IBSurgeon
30.05.2014 4:41 пользователь "halim1...@hotmail.com [firebird-support]" <
firebird-support@yahoogroups.com> написал:
>
>
> We recently upgraded our database server from Win se
30.05.2014 06:11, s3057...@yahoo.com wrote:
> CREATE INDEX IX_TA BLE2_EXPECTED ON TABLE2 (TABLE1ID, VALIDFROM, VALIDTO);
> COMMIT;
>
> -- SIMPLE QUERY
>
> SELECT *
> FROM TABLE2 T
> WHERE T.TABLE1ID BETWEEN 1000 AND 1999
> AND T.VALIDFROM <= CURRENT_DATE
> AND T.VALIDTO >= CURRENT_DATE
>
> The sim
Follow-up on this issue...
The problem was that an old copy of gdb32.dll was sitting in
C:\Windows\SysWOW64. That was loaded before IBAnalyst tried to use
fbclient.dll, and it was not suitable. The solution was to copying the
recent 32-bit fbclient.dll to gds32.dll in the same folder as IBAnal