https://bugs.freedesktop.org/show_bug.cgi?id=39872
Lionel Elie Mamane <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |RESOLVED Resolution| |NOTOURBUG --- Comment #14 from Lionel Elie Mamane <[email protected]> 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 [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
