Re: wrong query result

On Mar 16, 10:46 am, "Obnoxio The Clown" <obno...@serendipita.com> wrote: > SaltTan said: > > > On Mar 16, 10:14 am, "Obnoxio The Clown" <obno...@serendipita.com> > > wrote: > >> SaltTan said: > > >> > 10.00xC5, 10.00xC6 > >> > A query with left join and "in" subquery was prepared and executed > >> > with a bind variable. The query returns some rows. > >> > Then the same query was executed with another bind variable. At this > >> > time the query returns no rows. > >> > If I change "left join" to "outer", the query works. > >> > If I change "in" to "exists", the query works too. > > >> Have you logged a case with technical support? It sounds like a bug. > > > Yes we do. > > And what did they say? > Nothing. My PMR was created 2 days ago. I'm still waiting... We have encountered this bug working with BAAN IV (it generates queries with ANSI syntax) after upgrade from 10.00.FC4 to 10.00.FC6