Apache OpenOffice (AOO) Bugzilla – Issue 118638
Query with left or right join fails in 3.3 but worked in 3.2
Last modified: 2013-01-29 21:47:11 UTC
I upgraded to 3.3 from 3.2. I ran a database report based on a query which returned no data but worked fine in 3.2. The query is: SELECT "Laptop"."Laptop", "Laptop"."CPCN", "Counselor"."Lname" FROM { OJ "Counselor" AS "Counselor" RIGHT OUTER JOIN "Laptop" AS "Laptop" ON "Counselor"."Laptop" = "Laptop"."Laptop" } If the right outer join is removed, then the query runs but of course returns only data where both tables contain "laptop"
Please check in OOo 3.4Beta. Lot of bugs were solved during development. Or can you add an example file to help me check in OOo 3.4Beta.