Richard Zowalla created OPENJPA-3062:
----------------------------------------
Summary: MySQL and MariaDB: a decimal column without a precision
rounds values to integers
Key: OPENJPA-3062
URL: https://issues.apache.org/jira/browse/OPENJPA-3062
Project: OpenJPA
Issue Type: Bug
Components: jdbc
Reporter: Richard Zowalla
Assignee: Richard Zowalla
Fix For: 4.2.0
The Databases workflow fails on MySQL 8.4/9.7 and MariaDB 10.11/12.3 (run
https://github.com/apache/openjpa/actions/runs/41567325486):
* {{TestDecimalScale}}, {{TestUnarySign}}, {{TestArithmeticResultType}}: a
decimal value is stored rounded to an integer, e.g. {{25.5 <> 26}}, {{1234.5678
<> 1235}}. MySQL and MariaDB create a decimal column without a precision as
{{DECIMAL}}, which they read as {{DECIMAL(10, 0)}}. This is the same problem
OPENJPA-3051 fixed for H2; the tests use fractional values since then.
* {{TestInMemoryJDBCEscapeLiterals.testCaseAndNullIfInMemory}} (MySQL only):
{{NULLIF(e.sqlTimestampField, \{ts ...\})}} returns {{2022-06-15
18:30:00.000000}} from the database and {{2022-06-15 18:30:00.0}} in memory.
The test compares the results as strings (OPENJPA-3048).
--
This message was sent by Atlassian Jira
(v10.3.26#10030026)
