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 [email protected] Tue Oct 20 19:10:35
+0000 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: [email protected]
For additional commands, e-mail: [email protected]
