[dba-issues] [Issue 80901] bad SQL for left-outer-joi n
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=80901 --- Additional comments from [EMAIL PROTECTED] Wed Aug 22 07:26:48 + 2007 --- Thanks for the tip, it works indeed. Is it possible to resolve the issue when OJ syntax is enabled with SDBC for postgres? Or is it possible to uncheck this option if this driver is used, by default? - 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]
[dba-issues] [Issue 80901] bad SQL for left-outer-joi n
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=80901 User regina changed the following: What|Old value |New value Status|UNCONFIRMED |RESOLVED Resolution| |WORKSFORME --- Additional comments from [EMAIL PROTECTED] Wed Aug 22 12:29:28 + 2007 --- I don't know. Please use the mailinglist [EMAIL PROTECTED] for further discussion, as mentioned on http://dba.openoffice.org/drivers/postgresql/index.html I'll close this issue as work for me. For changing defaults and requests for enhancement a new issue is necessary anyway. - 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]
[dba-issues] [Issue 80901] bad SQL for left-outer-joi n
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=80901 User regina changed the following: What|Old value |New value Status|RESOLVED |CLOSED --- Additional comments from [EMAIL PROTECTED] Wed Aug 22 12:30:21 + 2007 --- closing, because it works with that setting. - 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]
[dba-issues] [Issue 80901] bad SQL for left-outer-joi n
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=80901
Issue #|80901
Summary|bad SQL for left-outer-join
Component|Database access
Version|OOo 2.2.1
Platform|All
URL|
OS/Version|All
Status|UNCONFIRMED
Status whiteboard|
Keywords|
Resolution|
Issue type|DEFECT
Priority|P3
Subcomponent|none
Assigned to|jbu
Reported by|viandor
--- Additional comments from [EMAIL PROTECTED] Tue Aug 21 13:00:59 +
2007 ---
I am using postgresql-sdbc-driver 0.7.4.
When i build a request with a different link between two tables than the default
link (i.e. a left-outer-join), the generated SQL is wrong and i get an error.
The generated SQL is :
SELECT intrant_intervention.volume, intervention.description FROM { OJ
public.intrant_intervention LEFT OUTER JOIN public.intervention ON
intrant_intervention.id_intervention = intervention.id_intervention }
It should be :
SELECT intrant_intervention.volume, intervention.description FROM
public.intrant_intervention LEFT OUTER JOIN public.intervention ON
intrant_intervention.id_intervention = intervention.id_intervention
-
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]
[dba-issues] [Issue 80901] bad SQL for left-outer-joi n
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=80901 --- Additional comments from [EMAIL PROTECTED] Tue Aug 21 13:01:54 + 2007 --- Created an attachment (id=47679) Bad SQL with a left-outer-join - 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]
[dba-issues] [Issue 80901] bad SQL for left-outer-joi n
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=80901 User regina changed the following: What|Old value |New value CC|''|'regina' Keywords| |oooqa --- Additional comments from [EMAIL PROTECTED] Tue Aug 21 14:22:45 + 2007 --- Please look at Edit Database Advanced Settings Special Settings, whether you can disable the OJ sytax there. (I havn't got a postgresql driver; for ODBC it is possible there.) - 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]
[dba-issues] [Issue 80901] bad SQL for left-outer-joi n
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=80901 --- Additional comments from [EMAIL PROTECTED] Tue Aug 21 15:49:52 + 2007 --- Yes, it works when the OJ syntax is disabled! But it should work anyway, with or without the option, no? - 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]
