Issue 115918

Summary:	[cws hsqldb19] Interval types gives assertions in query in external server connected file
Product:	Base	Reporter:	r4zoli <r4zoli>
Component:	code	Assignee:	AOO issues mailing list <issues>
Status:	CONFIRMED ---	QA Contact:
Severity:	Trivial
Priority:	P3	CC:	issues
Version:	DEV300m89
Target Milestone:	---
Hardware:	Unknown
OS:	Windows 7
Issue Type:	DEFECT	Latest Confirmation in:	---
Developer Difficulty:	---

Description r4zoli 2010-12-04 12:08:44 UTC

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.