[Libreoffice-bugs] [Bug 69309] Other: Outer joins do not work with PostgreSQL
https://bugs.freedesktop.org/show_bug.cgi?id=69309 --- Comment #8 from rob...@familiegrosskopf.de --- (In reply to comment #7) You are using a different driver on a different OS. This bug report is for LibreOffice on Mac OS X, using the native SDBC driver. Using the ODBC driver on Linux is a different story. I have first tested with the native SDBC driver, then tested with ODBC. I haven't called it native but direct connection. Only difference is the platform. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 69309] Other: Outer joins do not work with PostgreSQL
https://bugs.freedesktop.org/show_bug.cgi?id=69309 --- Comment #9 from Marc Balmer m...@msys.ch --- On a side note, I noticed that the Advanced settings menu entry is greyed out both on Mac OS X and on Windows. Maybe that should be a separate bug report. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 69309] Other: Outer joins do not work with PostgreSQL
https://bugs.freedesktop.org/show_bug.cgi?id=69309 --- Comment #10 from rob...@familiegrosskopf.de --- (In reply to comment #9) On a side note, I noticed that the Advanced settings menu entry is greyed out both on Mac OS X and on Windows. Maybe that should be a separate bug report. It's the same in Linux on my system with the native driver. I think all the special settings for PostgreSQL were made in the native driver. It doesn't need any advanced settings. So the native driver with greyed out Advanced setting produces the right code for PostgreSQL with OpenSUSE. When it produces the wrong code its a problem of the driver ... -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 69309] Other: Outer joins do not work with PostgreSQL
https://bugs.freedesktop.org/show_bug.cgi?id=69309 --- Comment #11 from Marc Balmer m...@msys.ch --- I can now confirm that the same problem exists on Windows. As soon as the link between two tables is set to outer join, it does not work anymore. Same bug as on OS X, it inserts an OJ token in the SQL command sent to the PostgreSQL server. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 69309] Other: Outer joins do not work with PostgreSQL
https://bugs.freedesktop.org/show_bug.cgi?id=69309 --- Comment #12 from Marc Balmer m...@msys.ch --- The problem also exists on Linux (Debian Squeeze, PostgreSQL 9.2, LibreOffice 4.1.1.2). Setting a join in the graphical editor to right join or full outer join results in an error message. Since I have this now repeated on three platforms, I am pretty sure the problem really exists... -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 69309] Other: Outer joins do not work with PostgreSQL
https://bugs.freedesktop.org/show_bug.cgi?id=69309 --- Comment #13 from Marc Balmer m...@msys.ch --- (In reply to comment #1) Isn't this inherited behaviour from OOo 3 ? Or is this a regression over something that worked in previous versions of LibreOffice ? I don't know. I discovered it in 4.1.1.2 only, but I did not use outer joins in previous versions. We are makers of a point of sale solution that is based on PostgreSQL, and we thought it would be nice if our customers could use LibreOffice to create individual reports and such. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 69309] Other: Outer joins do not work with PostgreSQL
https://bugs.freedesktop.org/show_bug.cgi?id=69309 --- Comment #14 from rob...@familiegrosskopf.de --- So it works only with OpenSUSE 12.3 64bit rpm? Why should the driver for rpm-packeges be not the same than for windows, *.deb or Mac? I have tested it in different versions, dircetly from LO or from OpenSUSE - all the same, works. Where did you get you PostgreSQL-driver from? -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 69309] Other: Outer joins do not work with PostgreSQL
https://bugs.freedesktop.org/show_bug.cgi?id=69309 --- Comment #15 from Marc Balmer m...@msys.ch --- It's the one that comes bundled with LibreOffice, I had not to install a separate driver. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 69309] Other: Outer joins do not work with PostgreSQL
https://bugs.freedesktop.org/show_bug.cgi?id=69309
Lionel Elie Mamane lio...@mamane.lu changed:
What|Removed |Added
Assignee|libreoffice-b...@lists.free |lio...@mamane.lu
|desktop.org |
--- Comment #16 from Lionel Elie Mamane lio...@mamane.lu ---
When using ODBC, need to disable Use Outer Join syntax '{ OJ }' in Advanced
Settings.
When using native / direct connexion, it is forcefully disabled by the driver
always and the UI to reenable it is disabled (because it would not make any
sense, it is guaranteed not to work). If it is not anymore disabled by the
driver, that is a regression bug.
--
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 69309] Other: Outer joins do not work with PostgreSQL
https://bugs.freedesktop.org/show_bug.cgi?id=69309 Marc Balmer m...@msys.ch changed: What|Removed |Added Severity|blocker |normal Priority|high|medium -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 69309] Other: Outer joins do not work with PostgreSQL
https://bugs.freedesktop.org/show_bug.cgi?id=69309 --- Comment #5 from Marc Balmer m...@msys.ch --- I reset the severity to medium/normal. But still this means that not all data can be accessed from LibreOffice yet, so for PostgreSQL users this is actually a blocker if outer joins are needed. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 69309] Other: Outer joins do not work with PostgreSQL
https://bugs.freedesktop.org/show_bug.cgi?id=69309
--- Comment #6 from rob...@familiegrosskopf.de ---
Can't confirm this behavior for OpenSUSE Linux 64bit rpm. When I set the outer
join it works right.
I get, for example, this query without changing anything in the SQL:
SELECT Town.Town, person.name FROM public.person AS person RIGHT
OUTER JOIN public.Town AS Town ON person.ID_Town = Town.ID
LO-version 4.1.1.2, rpm-packages from SuSE-repositories, direct connection to
PostgreSQL.
When I switch to PostgreSQL-ODBC the following query is created and works, too:
SELECT Town.Town, person.name FROM { OJ libretest.public.person
AS person RIGHT OUTER JOIN libretest.public.Town AS Town ON
person.ID_Town = Town.ID }
--
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 69309] Other: Outer joins do not work with PostgreSQL
https://bugs.freedesktop.org/show_bug.cgi?id=69309 --- Comment #7 from Marc Balmer m...@msys.ch --- You are using a different driver on a different OS. This bug report is for LibreOffice on Mac OS X, using the native SDBC driver. Using the ODBC driver on Linux is a different story. But it would be interesting to test the SDBC driver on platforms other than OS X. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 69309] Other: Outer joins do not work with PostgreSQL
https://bugs.freedesktop.org/show_bug.cgi?id=69309 Marc Balmer m...@msys.ch changed: What|Removed |Added Severity|normal |blocker Priority|medium |high -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 69309] Other: Outer joins do not work with PostgreSQL
https://bugs.freedesktop.org/show_bug.cgi?id=69309 Marc Balmer m...@msys.ch changed: What|Removed |Added QA Contact||lio...@mamane.lu -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 69309] Other: Outer joins do not work with PostgreSQL
https://bugs.freedesktop.org/show_bug.cgi?id=69309 --- Comment #1 from Alex Thurgood ipla...@yahoo.co.uk --- Isn't this inherited behaviour from OOo 3 ? Or is this a regression over something that worked in previous versions of LibreOffice ? Alex -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 69309] Other: Outer joins do not work with PostgreSQL
https://bugs.freedesktop.org/show_bug.cgi?id=69309 Alex Thurgood ipla...@yahoo.co.uk changed: What|Removed |Added Severity|blocker |normal Priority|high|medium --- Comment #2 from Alex Thurgood ipla...@yahoo.co.uk --- I have reset the importance to medium/normal because as far as I know this is historic. It would only really be a blocker if it caused data loss or could be considered as a serious regression (e.g. crash, data loss, profile corruption, etc). Alex -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 69309] Other: Outer joins do not work with PostgreSQL
https://bugs.freedesktop.org/show_bug.cgi?id=69309 Alex Thurgood ipla...@yahoo.co.uk changed: What|Removed |Added Status|UNCONFIRMED |RESOLVED Resolution|--- |NOTABUG --- Comment #3 from Alex Thurgood ipla...@yahoo.co.uk --- Well, a quick trawl on the AOO bugzilla produced these reports : https://issues.apache.org/ooo/show_bug.cgi?id=14296 https://issues.apache.org/ooo/show_bug.cgi?id=22355 https://issues.apache.org/ooo/show_bug.cgi?id=107767 See here : http://www.openoffice.org/dba/howto/OuterJoinSequence.html Use the Advanced Settings options in your ODB file to tell LO to work with the ODBC outer join syntax. If that option doesn't work, then it would appear that we have a bug. Alex -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 69309] Other: Outer joins do not work with PostgreSQL
https://bugs.freedesktop.org/show_bug.cgi?id=69309 Marc Balmer m...@msys.ch changed: What|Removed |Added Status|RESOLVED|UNCONFIRMED Resolution|NOTABUG |--- Severity|normal |blocker Priority|medium |high --- Comment #4 from Marc Balmer m...@msys.ch --- Actually the Advanced Settings Dialog is not available, so thetre is no way to disable this OJ fragment. Please try it yourself before changing this bug report to NOT A BUG. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
