To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=53278
Issue #:|53278
Summary:|Right Outer Join generates error
Component:|Database access
Version:|680m123
Platform:|All
URL:|
OS/Version:|Windows XP
Status:|UNCONFIRMED
Status whiteboard:|
Keywords:|
Resolution:|
Issue type:|DEFECT
Priority:|P3
Subcomponent:|none
Assigned to:|dbaneedsconfirm
Reported by:|atjensen
------- Additional comments from [EMAIL PROTECTED] Sat Aug 13 09:51:01 -0700
2005 -------
when a query is constructed using a Right Outer Join such as
SELECT "COURSES"."NAME", "COURSES"."STARTDATE", "COURSES"."FINISHDATE",
"STUDENTS"."FirstName", "STUDENTS"."LastName", "STUDENTS"."email" FROM { OJ
"STUDENTS" "STUDENTS" RIGHT OUTER JOIN "COURSES" "COURSES" ON
"STUDENTS"."COURSEID" = "COURSES"."ID" }
An error is generated when the query is activated.
"Column not found COURSE.NAME......"
The same error is generated for any query made with the Right Outer Join
contstuct, and it is always the first column that is reported not found.
The same error is being generated for HSQL and MySQL data connections.
---------------------------------------------------------------------
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
