Hello, Is my problem the same as in http://lists.mysql.com/maxdb/21965 ?
I'd like to do a select statement with lots of outer joins: SELECT t1.ent_name FROM ifc_entities T1 ,ifc_attributes T10 ,rep_labels T11 ,ifc_attributes T6 ,rep_labels T7 ,rep_labels T4 WHERE (T4.lbl_oid = T1.ent_lbl_oid) AND (T6.atr_oid (+) = T1.ent_atr_oid) AND (T7.lbl_oid (+) = T6.atr_lbl_oid) AND (T10.atr_oid (+) = T1.ent_search_atr_oid) AND (T11.lbl_oid (+) = T10.atr_lbl_oid) On Oracle this works fine and on a database with the same contents it returns 205 results. Funny thing about it is that on MaxDB it only returns one. Does this belong to the bug described in http://lists.mysql.com/maxdb/21965 ? > As a workaround you could enable new outer join handling > via command "diagnose optimize join outer on". I tried this and it hadn't made any effect to the statement results. I also tried to set the Parameter JOIN_OPERATOR_IMPLEMENTATION to YES in Database Manager, but I wasn't able to do this because if I typed in YES still NO appears for the new Value. Greets, Mathias -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
