Subject Re: NOT IN + sub-select + null value + inner join + index = bug ?
Author olivier_lucaes
Ann,
As long as there are "work arounds" (other select "design" or
additional "where... (no field_x is null)"), it is just a question
of... knowledge about these "work around".
Thanks for the detail about technical issues you have faced... by
the way, when is expected the first 2.0 RC ?
Best regards
Olivier



--- In firebird-support@yahoogroups.com, "Ann W. Harrison"
<aharrison@i...> wrote:
> Olivier,
>
> My additional guess is that the fix requires a change to the
physical
> organization of the index, which is why it was not back ported to
1.5.
> We've been very careful not to change the stored format of data -
or
> indexes - before Version 2. That means you'll find the same bug
in
> versions of InterBase prior to 6.5 - and possibly afterward...
>
> Regards,
>
>
> Ann