To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=87398 Issue #|87398 Summary|Syntax error in SQL Expression when no where clause Component|Database access Version|DEV300m4 Platform|Macintosh URL| OS/Version|Mac OS X Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|dyrcona
------- Additional comments from [EMAIL PROTECTED] Tue Mar 25 02:19:54 +0000 2008 ------- Whenever you try to access a table with a method that has an underlying SQL representation of "select * from tablename" you get an error dialog which says: "The data content could not be loaded. Syntax error in SQL expression." Clicking the "More" button in the error dialogs leads through the following: SQL Status: HY000 Error Code: 1000 Syntax error in SQL expression select * from "people" syntax error, unexpected INVALIDSYMBOL, expecting $end, Invalid symbol NOTE: people was the name of a table I created in a database to test this. The error occurs reproducibly under a number of circumstances. The easiest way to cause it to happen is to open an existing database, going to the table editor, and then double-clicking on any given table to see/edit the data. It happens with forms or queries that load an entire table, i.e. that have no where clause. If you edit a query in SQL view, you can see the error with select * from tablename. However, if you type select * from tablename where 1=1, you get the results that you expected for the previous query. This error occurs for me in an existing hsqldb, a brand new hsqldb created just to test this, and a MySQL database accessed via JDBC and mysql-connector 5.0. --------------------------------------------------------------------- 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
