Hello Malc


i would still vote for a bug and regarding the NULL i was way off here

( that will teach me again to read before being trigger happy...)

the resultset shoud give you all the rows which are in client but not in planrole and clainmrole i guess.

regardless of what is in the selected columnlist the result should always be the same i guess

tryed this on 11.7 and can not reproduce. Are you still on the 9.3?


hope it helps

Superboer




Op maandag 23 november 2015 21:37:26 UTC+1 schreef super...@t-online.de:

Hello Malc,

i would vote for a bug.. (gut feeling)

however compare to NULL is undefined.

May be the difference is due to a different explain.

are the explain output different in both cases ?

if so try to use an optimizer hint to make the explain/ optimizer path equal, may be that way will produce the same results?

sorry not much, may be it helps.

See you

Superboer.

--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)