https://bugs.freedesktop.org/show_bug.cgi?id=69309
Priority: medium
Bug ID: 69309
Assignee: [email protected]
Summary: Other: Outer joins do not work with PostgreSQL
Severity: normal
Classification: Unclassified
OS: Mac OS X (All)
Reporter: [email protected]
Hardware: Other
Whiteboard: BSA
Status: UNCONFIRMED
Version: 4.1.1.2 release
Component: Database
Product: LibreOffice
Problem description:
When creating queries with more than one table and linking them using an outer
join (by clicking on the line in the graphical query editor and setting the
join type to outer join), the query does not work. It reates a syntax error,
because LO inersts a "OJ" token in the query, which PostgreSQL can not handle.
I found no possibility to turn of the "OJ" token inserting.
Steps to reproduce:
1. Create a query with two tables that use an outer join
2. Execute the query
3. Look at the resulting error
Current behavior:
Syntax error
Expected behavior:
A working query and a result set.
This is PostgreSQL 9.2, fwiw
Operating System: Mac OS X
Version: 4.1.1.2 release
--
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
