Sven K�hler wrote: > writing > SELECT * FROM t1 > LEFT JOIN t2 ON (t2.c1=t1.c1) > LEFT JOIN t3 ON (t3.c2=t2.c2) > is _not_ equal to > SELECT * FROM table1 > LEFT JOIN t2 ON (t1.c1=t2.c1) > LEFT JOIN t3 ON (t2.c2=t3.c2) > > Well, i'd expect the results to be equal, but the first > results in about > 1200 rows, and the second in about 1300 rows which is more. > As far as i can tell, it only affected the second LEFT JOIN > in my case, > but perhaps this is a problem in general. > > Perhaps the expressions like t2.c2=t3.c2 should be "sorted" to be > t3.c2=t2.c2 which might also get better cache performance. > (i noticed that if i swap t3 and t2 in the ON-clause SAPDB > performs the > query much slower the first time run it although it should > practically > be the same query that i executed before)
It's definite a bug and already reported by Ricardo some days ago on this list. It'll be fixed in one of the next releases. Thanks for reporting it. Kind regards, Holger SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
