[
https://issues.apache.org/jira/browse/OPENJPA-3063?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Maxim Solodovnik resolved OPENJPA-3063.
---------------------------------------
Resolution: Fixed
> 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
> Priority: Major
> 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)
