To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=84506
------- Additional comments from johanhenselma...@openoffice.org Mon May 11 09:01:52 +0000 2009 ------- I just found out what the culprit is: if you try the command as SELECT * FROM "public"."contacten" WHERE ( "public"."contacten"."achternaam" LIKE '%ensel%' ) instead of SELECT * FROM "public"."contacten" WHERE ( "public.contacten"."achternaam" LIKE '%ensel%' ) it works. The root of the cause is that the schema catalog is not commented separately in the WHERE clause. The workaround is: In the advanced properties of the database settings, turn off "Use schema name in SELECT statements" Then there is no schema definition added to the created in the SQL statements and the error is not thrown. --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@porting.openoffice.org For additional commands, e-mail: issues-h...@porting.openoffice.org --------------------------------------------------------------------- To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
