https://bugs.documentfoundation.org/show_bug.cgi?id=96516
--- Comment #8 from [email protected] ---
(In reply to Alex Thurgood from comment #5)
> @Tim : I get the following error when I try and run the query "test" from
> your test ODB on Linux Mint 17.3 with
>
> Version: 5.0.3.2
> Build ID: 1:5.0.3~rc2-0ubuntu1~trusty2
> Locale : fr-FR (fr_FR.UTF-8)
>
> Error message :
>
> Statut SQL: HY000
> Code d'erreur: 1
>
> [unixODBC][SQLite]RIGHT and FULL OUTER JOINs are not currently supported (1)
>
> Is this the problem you are seeing ? If so, I will confirm.
Yes, sqlite3 doesn't support RIGHT JOINS, Only LEFT JOINS
But BASE doesn't allow LEFT JOINS with sqlite3 and odbc. If you use Direct SQL
then you bypass the BASE error and it works, but using Direct SQL creates other
problems and limitations in what you can do.
--
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
