To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=110117
------- Additional comments from ia...@openoffice.org Tue Mar 16 09:02:23 +0000 2010 ------- Hi Thanks for checking out this issue. Some databases do not support aliasing table names in queries to the same name as the table. Hence the query in examples 1 and 2 fail. Example 1. SELECT "@ID", "CHEQUE", "BANK", "AMOUNT", "PERIOD" FROM "CHEQUES" AS "CHEQUES" Example 2 SELECT "@ID", "CHEQUE", "BANK", "AMOUNT", "PERIOD" FROM "CHEQUES" "CHEQUES" In the above example 2, the "AS" keyword is not included because it has been "unchecked" in the advanced settings and saved. However neither of these queries return any results because the table is still aliased ( "CHEQUES" AS "CHEQUES" - "CHEQUES" "CHEQUES") even though the Advanced settings have been modified to not append aliases. Example 3 - query modified manually to remove AS "CHEQUES" alias SELECT "@ID", "CHEQUE", "BANK", "AMOUNT", "PERIOD" FROM "CHEQUES" Example 3 query does return a result set because there is no alias appended to the query. So, to answer your question : The first 2 examples do not return a result set, the second example returns exactly what is expected. It seems that the GUI interface is not saving the advanced settings related to appending aliases - at least not when I create a new database connection, connect to it, change advance settings and file the database. When reconnecting to the database the Advanced setting Append the table alias name on SELECT statements remains "checked". Hope this clarifies the issue a bit better. Rgds Ian --------------------------------------------------------------------- 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
