Issue 94803 - Query may not contain two LEFT OUTER JOIN
Summary: Query may not contain two LEFT OUTER JOIN
Status: CLOSED FIXED
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOO300m9
Hardware: PC All
: P3 Trivial (vote)
Target Milestone: OOo 3.0.1
Assignee: marc.neumann
QA Contact: issues@dba
URL:
Keywords: oooqa, regression
Depends on:
Blocks:
 
Reported: 2008-10-09 10:24 UTC by Mechtilde
Modified: 2008-12-16 22:06 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
ExampleDB (37.21 KB, application/vnd.sun.xml.base)
2008-10-09 10:25 UTC, Mechtilde 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description Mechtilde 2008-10-09 10:24:15 UTC 
As you can see in the attached database.

There are the queries PrimaNota and PrimaNota1.
In PrimaNota there is one Left Outer Join and this you can open in design view. 
In PrimaNota1 there are two Left Outer Join and this you can only open in SQL
view. You get an error message if you want to open it in design view. 

In earlier version you could open also the second query PrimaNota1 in design view.

The original application is a mysql db via JDBC to OOo.
I only reproduce this queries to shoe the prolem.
Comment 1 Mechtilde 2008-10-09 10:25:28 UTC 
Created attachment 57079 [details]
ExampleDB
Comment 2 Frank Schönheit 2008-10-10 10:52:56 UTC 
fs->oj: mechtilde is right, this is a regression between 2.4.1 and 3.0. Please
fix for 3.0.1.
Comment 3 Frank Schönheit 2008-10-10 10:53:53 UTC 
as much as I regret this, but a bug as this does not affect that much users that
it justifies a P2 ...
Comment 4 ocke.janssen 2008-10-16 14:29:39 UTC 
Fixed in cws dba301a.
As workaround remove the brackets ( and ) around the first left join
Comment 5 ocke.janssen 2008-10-28 08:49:48 UTC 
Please verify. Thanks.
Comment 6 christoph.lukasiak 2008-11-03 11:40:20 UTC 
verified in cws
Comment 7 Mechtilde 2008-12-16 22:06:56 UTC 
verified in OOO300_m13 -> closed