To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=115918 Issue #|115918 Summary|[cws hsqldb19] Interval types gives assertions in quer |y in external server connected file Component|Database access Version|DEV300m89 Platform|Unknown URL| OS/Version|Windows 7 Status|NEW Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|oj Reported by|r4zoli
------- Additional comments from r4z...@openoffice.org Sat Dec 4 12:08:44 +0000 2010 ------- In cws hsqldb19, dated 2010.11.23. Interval types gives assertions in query in external server connected odb file, which works correctly in built in hsqldb. The queries runs without problem in odb file with built in Hsqldb 2.0.1. They gives assertions, and create empty result set, with external server: SELECT (CURRENT_DATE - "Datum_1") YEAR AS AGE FROM "Table111" SELECT CAST ( INTERVAL '145 23:15:19' DAY TO SECOND AS INTERVAL DAY(4) TO HOUR ) FROM "Table111" --------------------------- Debug Output --------------------------- Error: ORowSetValue::fill: unsupported type! >From File e:/src/cws/hsqldb19/ooo/connectivity/source/commontools/FValue.cxx at Line 2163 Abort ? (Yes=abort / No=ignore / Cancel=core dump) --------------------------- Igen Nem Mégse --------------------------- --------------------------- Debug Output --------------------------- Error: ORowSetValue:operator==(): UNSPUPPORTED TYPE! >From File e:/src/cws/hsqldb19/ooo/connectivity/source/commontools/FValue.cxx at Line 262 Abort ? (Yes=abort / No=ignore / Cancel=core dump) --------------------------- Igen Nem Mégse --------------------------- --------------------------- Debug Output --------------------------- Error: ORowSetValue::makeAny(): UNSPUPPORTED TYPE! >From File e:/src/cws/hsqldb19/ooo/connectivity/source/commontools/FValue.cxx at Line 960 Abort ? (Yes=abort / No=ignore / Cancel=core dump) --------------------------- Igen Nem Mégse --------------------------- --------------------------- Debug Output --------------------------- Error: ORowSetValue::operator==(): UNSPUPPORTED TYPE! >From File e:/src/cws/hsqldb19/ooo/connectivity/source/commontools/FValue.cxx at Line 867 Abort ? (Yes=abort / No=ignore / Cancel=core dump) --------------------------- Igen Nem Mégse --------------------------- Where the "Datum_1" is the date field. The hsqldb.jar and sdbc_hsqldb.jar added to classpath. I use same hsqldb version, what is in cws hsqldb19 latest version classes folder, I copied it into server folder. --------------------------------------------------------------------- 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