When LibreOffice Base creates query that includes outer join, it builds the query using the syntax " FROM { OJ ... } " This syntax is rejected by connector, Maria DB client java library 1.1.7, although accepted by LO Native and MySQL connectors. MariaDB folks say uppercase "OJ" is deviation from standard, web search suggests that lowercase is more common. See link to bug report there. Suggest syntax " FROM {oj ...} ". Cross listing bug here.
*** Bug 84092 has been marked as a duplicate of this bug. ***
Confirmed thanks to the duplicate, increment the importance too
Lionel: searching about OJ with Opengrok, I found this (perhaps not the right location): http://opengrok.libreoffice.org/xref/core/connectivity/source/parse/sqlflex.l#292 Should we put all this on lowercase or should we lowercase only in Mariadb and jdbc cases?
ODBC also uses lower-case (see http://msdn.microsoft.com/en-us/library/ms714641%28v=vs.85%29.aspx ) So just change it to lower-case unconditionally.
So thanks to the great Lionel's help, fixed with this: http://cgit.freedesktop.org/libreoffice/core/commit/?id=ee12e843c609e747be2f7d5a89ffd889c78378de For 4.3, here's the pending gerrit review: https://gerrit.libreoffice.org/#/c/11885/1
Integrated to -4-3: http://cgit.freedesktop.org/libreoffice/core/commit/?h=libreoffice-4-3&id=9398fe153ae1a7a26d53424b98c2e8190f236890