Richard Zowalla created OPENJPA-3063:
----------------------------------------
Summary: HSQLDB: LOB type of converted attributes, decimal scale,
CASE padding and EXTRACT of a parameter fail
Key: OPENJPA-3063
URL: https://issues.apache.org/jira/browse/OPENJPA-3063
Project: OpenJPA
Issue Type: Bug
Components: jdbc
Reporter: Richard Zowalla
Assignee: Richard Zowalla
Fix For: 4.2.0
The test suite on HSQLDB ({{-Dtest-hsqldb}}) has 17 failures and 4 errors (4022
tests), all from recent changes:
* {{TestLobConverted}}, {{TestLobConvertedXml}} (OPENJPA-3020): a converted
attribute whose converter yields a String or byte[] gets a
{{VARCHAR}}/{{VARBINARY}} column instead of {{CLOB}}/{{BLOB}}
({{expected:<2005> but was:<12>}}, {{expected:<2004> but was:<-3>}}).
* {{TestDecimalScale}}, {{TestUnarySign}}, {{TestArithmeticResultType}}:
decimal values are stored rounded to integers ({{25.5 <> 25}}, {{1234.5678 <>
1235}}). Same cause as OPENJPA-3051 (H2) and OPENJPA-3062 (MySQL, MariaDB): a
decimal column without a precision has scale 0.
* {{TestSelectionParameters.testParameterInCaseOfSelect}} (OPENJPA-3040):
{{expected:<[young, old]> but was:<[young, old ]>}}, the CASE result is padded
to the length of the longest branch.
* {{TestEJBQLFunction.testExtractSecondKeepsFractionFromTime/Timestamp}},
{{TestExtractDateTimeField.testExtractFromParameter/testCriteriaExtractFromLiteral}}:
{{EXTRACT(... FROM ?)}} fails with "data type cast needed for parameter or
null literal" ({{code=-5567, state=42567}}).
--
This message was sent by Atlassian Jira
(v10.3.26#10030026)
