[Libreoffice-bugs] [Bug 39872] OUTER JOIN does not seem to work
https://bugs.freedesktop.org/show_bug.cgi?id=39872 Michael Stahl mst...@redhat.com changed: What|Removed |Added Attachment #54777|application/octet-stream|application/vnd.oasis.opend mime type||ocument.base -- 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 39872] OUTER JOIN does not seem to work
https://bugs.freedesktop.org/show_bug.cgi?id=39872 Lionel Elie Mamane lio...@mamane.lu changed: What|Removed |Added Status|NEW |RESOLVED Resolution||NOTOURBUG --- Comment #14 from Lionel Elie Mamane lio...@mamane.lu 2012-01-17 03:07:53 PST --- LibreOffice is not a database engine in itself; as such you can use only the joins (and SQL syntax) supported by the database engine you connect to. Unless you enable Run SQL command directly (in a query) or disable Analyze SQL command (in a report), the SQL syntax is also constrained by what LibreOffice supports. I understand you run your rests against the built-in-LibreOffice HSQLDB 1.8. As you can see on http://www.hsqldb.org/doc/1.8/guide/ch09.html#select-section, HSQLDB 1.8 has rather limited join support, and has a particularly perverse syntax for cross joins: SELECT foo FROM bar CROSS JOIN qux ON TRUE. Yes, the ON clause is mandatory... And it seems no sensible WHERE clause will work. But that's HSQLDB's bug. We should upgrade to HSQLDB 2.x, which has far better support for all kinds of things... http://hsqldb.org/doc/2.0/guide/dataaccess-chapt.html#dac_joined_table If you run the same tests against a SQLite DB, you'll find that RIGHT [OUTER] JOIN is not supported, and neither is the FULL keyword (but the same feature is available with ,). See http://www.sqlite.org/syntaxdiagrams.html#join-op . If you run the same tests against a PostgreSQL, MySQL/MariaDB/..., Microsoft SQL Server, ... database, I expect you'll find all your examples work correctly. So I'm closing this bug as not our bug. If you find some SQL syntax that you'd like to be supported but is not supported by LibreOffice, or more generally something that is supported by the database, but does not work when used through LibreOffice, please file that as a separate bug. In this case, typically the query will work with Run SQL command directly, but not without it. You can assign the bug directly to me so that I take a look at it, but do not put it in the assigned state (leave it as UNCONFIRMED or NEW). Alternatively, you can also put me in the CC list. -- Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email --- 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 39872] OUTER JOIN does not seem to work
https://bugs.freedesktop.org/show_bug.cgi?id=39872 --- Comment #15 from Pat Willener pwille...@gmail.com 2012-01-17 16:53:45 PST --- (In reply to comment #14) We should upgrade to HSQLDB 2.x, which has far better support for all kinds of things... http://hsqldb.org/doc/2.0/guide/dataaccess-chapt.html#dac_joined_table Will that ever happen, or will users need to install a 3rd-party database engine to perform joins? Anyway, thank you for your explanation. -- Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email --- 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 39872] OUTER JOIN does not seem to work
https://bugs.freedesktop.org/show_bug.cgi?id=39872 --- Comment #16 from Lionel Elie Mamane lio...@mamane.lu 2012-01-17 23:49:10 PST --- (In reply to comment #15) (In reply to comment #14) We should upgrade to HSQLDB 2.x, which has far better support for all kinds of things... http://hsqldb.org/doc/2.0/guide/dataaccess-chapt.html#dac_joined_table Will that ever happen, I expect it will happen, but I don't have a precise time estimate. I filed bug 44854 to track the progress of that. -- Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email --- 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 39872] OUTER JOIN does not seem to work
https://bugs.freedesktop.org/show_bug.cgi?id=39872 --- Comment #12 from Pat Willener pwille...@gmail.com 2012-01-16 20:35:38 PST --- LibO-Dev Beta3: exactly the same results as above. -- Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email --- 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 39872] OUTER JOIN does not seem to work
https://bugs.freedesktop.org/show_bug.cgi?id=39872 Pat Willener pwille...@gmail.com changed: What|Removed |Added Version|LibO 3.5.0 Beta2|LibO 3.5.0 Beta3 --- Comment #13 from Pat Willener pwille...@gmail.com 2012-01-16 20:37:00 PST --- Changed version to LibO 3.5.0 Beta 3. -- Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email --- 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 39872] OUTER JOIN does not seem to work
https://bugs.freedesktop.org/show_bug.cgi?id=39872 Pat Willener pwille...@gmail.com changed: What|Removed |Added AssignedTo|pwille...@gmail.com |libreoffice-b...@lists.free ||desktop.org -- Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email --- 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 39872] OUTER JOIN does not seem to work
https://bugs.freedesktop.org/show_bug.cgi?id=39872 Pat Willener pwille...@gmail.com changed: What|Removed |Added Status|NEEDINFO|NEW AssignedTo|libreoffice-b...@lists.free |pwille...@gmail.com |desktop.org | --- Comment #10 from Pat Willener pwille...@gmail.com 2011-12-24 00:02:15 PST --- Created attachment 54777 -- https://bugs.freedesktop.org/attachment.cgi?id=54777 Outer Join tests for bug 39872 File test-39872.odb was created with LibO-Dev 3.5.0 Beta2. It contains the two tables with data used for the test, as well as the original 8 queries. -- Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email --- 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 39872] OUTER JOIN does not seem to work
https://bugs.freedesktop.org/show_bug.cgi?id=39872 Björn Michaelsen bjoern.michael...@canonical.com changed: What|Removed |Added Status|NEW |NEEDINFO --- Comment #8 from Björn Michaelsen bjoern.michael...@canonical.com 2011-12-23 12:22:31 PST --- [This is an automated message.] This bug was filed before the changes to Bugzilla on 2011-10-16. Thus it started right out as NEW without ever being explicitly confirmed. The bug is changed to state NEEDINFO for this reason. To move this bug from NEEDINFO back to NEW please check if the bug still persists with the 3.5.0 beta1 or beta2 prereleases. Details on how to test the 3.5.0 beta1 can be found at: http://wiki.documentfoundation.org/QA/BugHunting_Session_3.5.0.-1 more detail on this bulk operation: http://nabble.documentfoundation.org/RFC-Operation-Spamzilla-tp3607474p3607474.html -- Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email --- 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 39872] OUTER JOIN does not seem to work
https://bugs.freedesktop.org/show_bug.cgi?id=39872 Björn Michaelsen bjoern.michael...@canonical.com changed: What|Removed |Added Keywords|NEEDINFO| --- Comment #9 from Björn Michaelsen bjoern.michael...@canonical.com 2011-12-23 17:02:20 PST --- needinfo keyword redundant by needinfo status. -- Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email --- 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 39872] OUTER JOIN does not seem to work
https://bugs.freedesktop.org/show_bug.cgi?id=39872 --- Comment #7 from Julien Nabet serval2...@yahoo.fr 2011-12-04 13:25:57 PST --- (In reply to comment #3) (In reply to comment #1) ... only have your test results to go, which I presume were made with HSQLDB 1.8 ?? Alex I don't know if it's ok now, your last comment seems to say so but for my information, how can we know the HSQLDB version we use ? -- Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email --- 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 39872] OUTER JOIN does not seem to work
https://bugs.freedesktop.org/show_bug.cgi?id=39872 --- Comment #4 from Alex Thurgood alex.thurg...@gmail.com 2011-11-20 01:19:13 PST --- (In reply to comment #3) As the OP, _*hasn't*_ said what the backend db was, or how he was connecting to it, -- Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email --- 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 39872] OUTER JOIN does not seem to work
https://bugs.freedesktop.org/show_bug.cgi?id=39872 --- Comment #2 from Pat Willener pwille...@gmail.com 2011-11-19 17:54:02 PST --- Pat: could you please attach the database, so tests can quickly be done ? Sorry, I don't have LibreOffice any more; I have moved the project to Microsoft SQL Server. -- Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email --- 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 39872] OUTER JOIN does not seem to work
https://bugs.freedesktop.org/show_bug.cgi?id=39872 Julien Nabet serval2...@yahoo.fr changed: What|Removed |Added Keywords||NEEDINFO --- Comment #1 from Julien Nabet serval2...@yahoo.fr 2011-10-31 07:47:56 PDT --- I tried to reproduce the pb with master (future 3.5) on Debian x86-32 + on 3.4.3 (Debian pacakges) and i reproduced some of the errors. LEFT OUTER JOIN, LEFT JOIN, RIGHT OUTER JOIN and RIGHT JOIN worked for me. FULL JOIN and FULL OUTER JOIN failed for me with the same errors (no error messages in console). Precision : I haven't put all the data but it should be the same. Pat: could you please attach the database, so tests can quickly be done ? could you please test again on 3.4.3 to confirm the results I had ? -- Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email --- 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
