Issue 115918 - [cws hsqldb19] Interval types gives assertions in query in external server connected file
Summary: [cws hsqldb19] Interval types gives assertions in query in external server co...
Status: CONFIRMED
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: DEV300m89
Hardware: Unknown Windows 7
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2010-12-04 12:08 UTC by r4zoli
Modified: 2013-01-29 21:38 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---


Attachments

Note You need to log in before you can comment on or make changes to this issue.
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.