To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=105757 Issue #|105757 Summary|filter sql generation error for table view of postgres | dba accessed using jdbc Component|Database access Version|OOo 3.1.1 RC2 Platform|Opteron/x86_64 URL| OS/Version|Linux Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P1 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|dercol
------- Additional comments from der...@openoffice.org Fri Oct 9 11:03:37 +0000 2009 ------- Context: OpenSuSe 11.1 (patchlevel 2009/10/8) x86_64 OpenOffice_org-base-3.1.1.2-1.1 postgresql jdbc driver postgresql-8.3-604.jdbc3.jar postgresql-server-8.3.7-0.1.1 >From user point of view: Clicking on table name, openoffice opens the table view. On this table view is possible to add filter, in my example the standard filter. For example in a table containing a single char status column I setup the standard filter query: status = E Openoffice translates this query in the syntax: SELECT * FROM "db"."table" WHERE ( "db.table"."status" = 'E' ) that is not correct to postgresql: the error is: ERROR: missing FROM-clause entry for table "db.table" I can get the same error issuing the same query interactively in the psql console. while the query: select * from table where table.status = 'E'; (as expected) returns the correct correspondacies. Probably this is an issue related to the sql syntax generation. --------------------------------------------------------------------- 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...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org --------------------------------------------------------------------- To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
