https://bugs.freedesktop.org/show_bug.cgi?id=83171
--- Comment #3 from [email protected] --- Try the following: Make a view of "Query1". Link "Query2" to the view. It could be edited in the GUI without any problem. The GUI tries to handle the following query, when you link Query2 to Query1: SELECT "key", "text", "dt", "nodata" FROM ( SELECT "key", "text", "dt", CASE WHEN "Table1"."key" = 1 THEN NULL ELSE 'not1' END AS "nodata" FROM "Table1" WHERE CASE WHEN "Table1"."key" = 1 THEN NULL ELSE 'not1' END IS NULL ) AS "Q1" WHERE "nodata" IS NULL I wouldn't call this a simple code. When I try this directly and want to open it with the GUI a dialog appears: "The query is based on an SQL-command which could not be parsed. The query will be opened in SQL-view." The code could be executed well in the query. It could also be executed without direct SQL-mode. When Query2 is linked to a view, the data were prepared by the database like a table. Then the code in Query2 is simple. -- 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
