You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@openoffice.apache.org by bu...@apache.org on 2011/11/24 19:55:39 UTC
DO NOT REPLY [Bug 118638] New: Query with left or right join fails
in 3.3 but worked in 3.2
https://issues.apache.org/ooo/show_bug.cgi?id=118638
Bug #: 118638
Issue Type: DEFECT
Summary: Query with left or right join fails in 3.3 but worked
in 3.2
Classification: Application
Product: Database access
Version: OOo 3.3
Platform: PC
OS/Version: Windows Vista
Status: UNCONFIRMED
Severity: normal
Priority: P5
Component: none
AssignedTo: dbaneedsconfirm@openoffice.org
ReportedBy: bill@dornbush.net
CC: ooo-issues@incubator.apache.org
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"
--
Configure bugmail: https://issues.apache.org/ooo/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are on the CC list for the bug.
DO NOT REPLY [Bug 118638] Query with left or right join fails in 3.3
but worked in 3.2
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=118638
r4zoli <r4...@apache.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |r4zoli@apache.org
--- Comment #1 from r4zoli <r4...@apache.org> 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.
--
Configure bugmail: https://issues.apache.org/ooo/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are on the CC list for the bug.