Issue 118638

Summary:	Query with left or right join fails in 3.3 but worked in 3.2
Product:	Base	Reporter:	Bill Dornbush <bill>
Component:	code	Assignee:	AOO issues mailing list <issues>
Status:	UNCONFIRMED ---	QA Contact:
Severity:	Normal
Priority:	P5 (lowest)	CC:	bill, issues, r4zoli
Version:	OOo 3.3
Target Milestone:	---
Hardware:	PC
OS:	Windows Vista
Issue Type:	DEFECT	Latest Confirmation in:	---
Developer Difficulty:	---

Description Bill Dornbush 2011-11-24 18:55:39 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"

Comment 1 r4zoli 2011-11-25 08:45:35 UTC

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.