https://bugs.freedesktop.org/show_bug.cgi?id=81336
Priority: medium
Bug ID: 81336
Assignee: libreoffice-bugs@lists.freedesktop.org
Summary: Base Query with IS NULL statement gives "... too
complex"
Severity: normal
Classification: Unclassified
OS: Mac OS X (All)
Reporter: juergen.deisenr...@nurfuerspam.de
Hardware: Other
Status: UNCONFIRMED
Version: 4.2.5.2 release
Component: Database
Product: LibreOffice
Created attachment 102760
--> https://bugs.freedesktop.org/attachment.cgi?id=102760&action=edit
Simple ods and odb file for testing sql statements with IS NULL query
Switching from version 4.6.0.2 to 4.2.5.2 (and LibreOfficeDev 4.3.1.0.0) some
of my queries stop working with the message:
"The data content could not be loaded. The query can not be executed. It is too
complex."
This happens to all sql statements with NULL queries like:
SELECT * FROM "Tabelle1" WHERE "Flag" IS NULL
I tried to work with different statement like
SELECT * FROM "Tabelle1" WHERE "Flag" = ''
but this doesn't give the correct result.
Switching back to 4.6.0.2 all queries works fine.
Juergen
--
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
