Issue 50912

Summary:	Linking tables with {LEFT \| RIGHT \| FULL} OUTER JOIN does not work with JDBC connection to Oracle8.1.7
Product:	Base	Reporter:	hansmeister <meister>
Component:	code	Assignee:	dbaneedsconfirm <needsconfirm>
Status:	CLOSED NOT_AN_OOO_ISSUE	QA Contact:	issues@dba <issues>
Severity:	Trivial
Priority:	P3	CC:	issues
Version:	680m104	Keywords:	needhelp, needmoreinfo
Target Milestone:	---
Hardware:	Sun
OS:	Solaris
Issue Type:	DEFECT	Latest Confirmation in:	---
Developer Difficulty:	---

Description hansmeister 2005-06-17 14:09:03 UTC

I am using OOo Base to connect to an Oracle 8.1.7 database using JDBC.
When linking two tables with an OUTER JOIN (it is the same for either RIGHT,
LEFT or FULL OUTER JOIN), I get the error message:

   SQL Status: 42000
   Error code: 933

   ORA-00933: SQL command not properly ended

Regards,
Hans

Comment 1 christoph.lukasiak 2006-06-12 16:25:58 UTC

does this problem still occure in current version
(http://download.openoffice.org/680/index.html)? please acknowledge

thx

Comment 2 christoph.lukasiak 2006-06-12 16:37:07 UTC

set keyword 'needmoreinfo'

Comment 3 hansmeister 2006-06-27 16:15:01 UTC

Sorry for the late response - I was on a business trip...

Unfortunately I do not have the rights to install the new version in the Solaris
environment. The tests using the latest version on my Linux box revealed another
error message: unrecognized SQL92 token: OJ

Does this help?

Comment 4 christoph.lukasiak 2006-11-20 16:35:05 UTC

change owner

Comment 5 christoph.lukasiak 2007-04-17 16:29:15 UTC

clu->all: can anybody confirm that

Comment 6 christoph.lukasiak 2007-04-17 16:30:12 UTC

Comment 7 christoph.lukasiak 2007-06-26 14:08:24 UTC

set to invalid

Comment 8 christoph.lukasiak 2007-06-26 14:09:43 UTC

close -> do not hesitate if this issue still exist in a current version and you
have anything to add

thx