Subject Re: [firebird-support] Re: for select c from t where :p = initial-value-of-p
Author Adriano dos Santos Fernandes
woodsmailbox escreveu:
> --- In firebird-support@yahoogroups.com, Adriano dos Santos Fernandes
> <adrianosf@...> wrote:
>> woodsmailbox escreveu:
>>>> Also note that if you had where field = :p (and :p changes) you are
>>>> going to have different results depending if an index is used or
> not...
>>> Semantics of code depending on wherever you have indexes or not?
>>> Scary, to say the least.
>>>
>> I done a test in Oracle and result was identical to Firebird.
>>
>>
>> Adriano
>>
>
> Can you please post the oracle version of the test?
>
I do not have it saved. But I may have done something wrong, cause I
can't reproduce what I see yesterday.


Adriano