https://bugs.documentfoundation.org/show_bug.cgi?id=96516
Bug ID: 96516
Summary: Left Join not available with unixodbc and sqlite
Product: LibreOffice
Version: 5.0.3.2 release
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Base
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: t...@tim-passingham.co.uk
Sqlite supports Inner Joins and Left Joins, but not Right Joins.
As I understand it ODBC supports all 3 types.
In BASE, using ODBC, the available joins are Inner and Right Joins, but not
Left Joins.
I wonder if this is an error?
I'd use jdbc if I could get it working with sqlite but so far I haven't found a
version that works (I use jdbc and mysql successfully).
If this is a deliberate design choice it is strange, since it means that only
Inner Joins can be used with BASE, odbc and sqlite.
--
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
