To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=106104
Issue #|106104
Summary|[cws hsqldb19] Select generates error
Component|Database access
Version|DEV300m61
Platform|Unknown
URL|
OS/Version|All
Status|NEW
Status whiteboard|
Keywords|
Resolution|
Issue type|DEFECT
Priority|P3
Subcomponent|none
Assigned to|dbaneedsconfirm
Reported by|atjensen
------- Additional comments from atjen...@openoffice.org Tue Oct 20 17:17:36
+0000 2009 -------
Tested on Win 7, OO.o 3.2 CWSHSQLdb 10-16-09, hsqldb.jar 10-20-09
To reproduce:
Open attached Bug Doc
Go to Tables
Select New view
Switch to SQL view
Enable SQL direct
Copy the following stateemnt
SELECT cu.customer_id AS ID, 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
Run the query
---------------------------
Debug Output
---------------------------
Error: ASSERT:
TransactionManager...
"Owner instance not right initialized yet. Call was rejected! Normaly
it's an
algorithm error ... wrong usin of class!"
>From File
d:/src/cws/hsqldb19/ooo/framework/source/threadhelp/transactionmanager.cxx at
Line 385
After selecting ignore OO.o displays an error dialog with error:
user lacks privlidges or object not found CONCAT
---------------------------------------------------------------------
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
