[dba-issues] [Issue 106104] [cws hsqldb19] SQL statem ent errors generates confusins error messages
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=106104 User oj changed the following: What|Old value |New value Target milestone|OOo 3.3 |OOo 3.4 --- Additional comments from o...@openoffice.org Thu Jul 8 11:33:27 + 2010 --- Change target to 3.4. - 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
[dba-issues] [Issue 106104] [cws hsqldb19] SQL statem ent errors generates confusins error messages
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=106104 User oj changed the following: What|Old value |New value Target milestone|--- |OOo 3.3 --- Additional comments from o...@openoffice.org Wed Oct 28 06:45:53 + 2009 --- Adjust target - 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
[dba-issues] [Issue 106104] [cws hsqldb19] SQL statem ent errors generates confusins error messages
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=106104 --- Additional comments from atjen...@openoffice.org Wed Oct 21 22:01:33 + 2009 --- Created an attachment (id=65523) bug document with example table - 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
[dba-issues] [Issue 106104] [cws hsqldb19] SQL statem ent errors generates confusins error messages
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=106104 User atjensen changed the following: What|Old value |New value Summary|[cws hsqldb19] Select gene|[cws hsqldb19] SQL stateme |rates error |nt errors generates confus | |ins error messages --- Additional comments from atjen...@openoffice.org Tue Oct 20 19:10:35 + 2009 --- This might be more appropriate as an error in the error message. The first statement does have a mistake in the CONCAT funciton. Fix that with: SELECT cu.customer_id AS ID, CONCAT(CONCAT(cu.first_name, ' '), cu.last_name) AS name, a.address AS address, a.postal_code AS zip code, a.phone AS phone, city.city AS city, country.country AS country, IF(cu.active, 'active', '') AS notes, cu.store_id AS SID FROM customer AS cu JOIN address AS a ON cu.address_id = a.address_id JOIN city ON a.city_id = city.city_id JOIN country ON city.country_id = country.country_id So - the IF is wrong for the HSQLdb dialect, but try to run it and the same error as above is generated from the C++ runtime, the OO.o error dialog box however now shows: user lacks privlidges or object not found IF Finally - if I clean it up and just pull out (what seems like a legit IF clause to me) the query runs, and creates the view. SELECT cu.customer_id AS ID, COALESCE(cu.first_name || ' ' || cu.last_name, cu.last_name, cu.first_name, '') AS name, a.address AS address, a.postal_code AS zip code, a.phone AS phone, city.city AS city, country.country AS country, -- IF cu.active FALSE THEN -- 'active' -- ELSE -- '' -- END AS notes, 'active' AS notes, cu.store_id AS SID FROM customer AS cu JOIN address AS a ON cu.address_id = a.address_id JOIN city ON a.city_id = city.city_id JOIN country ON city.country_id = country.country_id - 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
