Hi time_lord,

--- In firebird-support@yahoogroups.com, "phil_hhn" <time_lord@...>
wrote:

>

...

> This really does seem to be a problem in the automatic optimisation,
> we are mainly surprised that there'd be any difference at all between
> platforms.
>

i don't think there are platform specific conditional coding and
compiling in FB optimiser.
Optimisers is not HW or OS specific part of RDBMS.
They are pure transportable C/C++ syntax i think.
Also, you didn't give us guarantee about FB build numbers for both
platform. did you?
please don't hard comment about something that couldnt proof.
Historically broken FB optimiser improving build by build.
your release build is not the last version of FB optimiser.
I have same problems too even with v1.5.3,
optimiser sometimes wrong choice join relations.
I can easly detect and by pass the optimiser holes because of my large
tables.

Also, i tested and saw they are fixed and work perfect on FB2.

Regards.
Ali