https://bugs.documentfoundation.org/show_bug.cgi?id=96516
Lionel Elie Mamane <[email protected]> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |ASSIGNED
Assignee|[email protected] |[email protected]
|desktop.org |
--- Comment #10 from Lionel Elie Mamane <[email protected]> ---
LibreOffice doesn't know it is connecting to SQLite, so it is not taking any
SQLite-specific measure. It relies on what the ODBC driver is telling. It seems
that the ODBC driver says it supports NONE of full, left, right, nested, inner,
... join. So LibreOffice tries to disable *all* outer joins, *both* left and
right. The way this is done is buggy and leads to only left being disabled.
I'm fixing that, but you won't like the result either, since it will disable
both left and right join. The ODBC driver needs to be fixed and to return at
least SQL_OJ_LEFT when SQLGetInf(..., SQL_OJ_CAPABILITIES, ...) is called.
Since the LibreOffice API (SDBC which is basically JDBC), contrary to ODBC,
doesn't have the granularity to test left vs right support, this will reenable
*both* left *and* right joins in the LibreOffice UI query editor.
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
