Issue 14296 - parse error with left/right join using postgresql jdbc
Summary: parse error with left/right join using postgresql jdbc
Status: CLOSED FIXED
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOo 1.1 Beta
Hardware: PC All
: P3 Trivial (vote)
Target Milestone: OOo 2.0
Assignee: marc.neumann
QA Contact: issues@dba
URL:
Keywords:
: 22355 (view as issue list)
Depends on:
Blocks:
 
Reported: 2003-05-09 15:43 UTC by Unknown
Modified: 2006-05-31 14:29 UTC (History)
1 user (show)

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

Attachments
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 Unknown 2003-05-09 15:43:18 UTC 
I get the following error when doing a left or right join with query builder
using postgresql jdbc. I have confirmed this error on Linux and Windows2000.

ERROR:  parser: parse error at or near "{"



This is the SQL that is generated by :

SELECT "invoice"."name" FROM { OJ "invoice_pos" "invoice_pos" LEFT OUTER JOIN
"invoice" "invoice" ON "invoice_pos"."inv_id" = "invoice"."id" }
Comment 1 Frank Schönheit 2003-05-13 09:16:29 UTC 
assigning to QA
Comment 2 christoph.lukasiak 2003-11-12 16:19:28 UTC 
i can repro that

CLU: keyword OJ (Outer Join) is not supported from most of JDBC driver
(no JDBC standard) - that is why you get this message - the bug us,
that we try it this way
Comment 3 christoph.lukasiak 2003-11-12 16:20:35 UTC 
CLU->OJ: your turn
Comment 4 Frank Schönheit 2003-11-14 15:43:13 UTC 
related: issue 22355
Comment 5 ocke.janssen 2004-01-28 12:42:36 UTC 
Fixed in cws oj08
Comment 6 ocke.janssen 2004-01-28 12:44:16 UTC 
Forgot to set to feature.
Comment 7 ocke.janssen 2004-01-29 12:18:03 UTC 
*** Issue 22355 has been marked as a duplicate of this issue. ***
Comment 8 hans_werner67 2004-02-02 13:00:44 UTC 
change subcomponent to 'none'
Comment 9 ocke.janssen 2004-02-02 13:44:04 UTC 
fixed.
Comment 10 marc.neumann 2004-03-02 09:47:26 UTC 
Hi,

you have to turn off the OuterJoinSequence via

http://dba.openoffice.org/howto/OuterJoinSequence.html

set to fixed

Bye Marc
Comment 11 marc.neumann 2004-03-02 09:47:45 UTC 
verify in CWS oj08
Comment 12 marc.neumann 2005-01-05 10:47:52 UTC 
close issue
Comment 13 marc.neumann 2005-01-05 10:48:13 UTC 
Hi,

fixed in current developer build -> close.
The current developer build can be found at
http://download.openoffice.org/680/index.html
Feel free to reopen if this issue is not fixed in the developer build.

Bye Marc