You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@openjpa.apache.org by "ASF subversion and git services (Jira)" <ji...@apache.org> on 2026/10/07 06:11:00 UTC
[jira] [Commented] (OPENJPA-3001) MySQL TCK: char field insert truncated on CHAR column
[ https://issues.apache.org/jira/browse/OPENJPA-3001?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18124274#comment-18124274 ]
ASF subversion and git services commented on OPENJPA-3001:
----------------------------------------------------------
Commit db9c64be252643555803988f3330d8b32a09dd5a in openjpa's branch refs/heads/tck-mysql from Maxim Solodovnik
[ https://gitbox.apache.org/repos/asf?p=openjpa.git;h=db9c64be2 ]
[OPENJPA-3001] investigating test failures
> MySQL TCK: char field insert truncated on CHAR column
> -----------------------------------------------------
>
> Key: OPENJPA-3001
> URL: https://issues.apache.org/jira/browse/OPENJPA-3001
> Project: OpenJPA
> Issue Type: Bug
> Components: jpa
> Affects Versions: 4.2.0
> Reporter: Maxim Solodovnik
> Priority: Major
>
> Discussion thread: https://github.com/apache/openjpa/pull/144#issuecomment-5011202275
> It seems some errors in MySQL TCK tests are caused by:
> {code}
> Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: Data truncation: Data too long for column 'CHARDATA' at row 1 {prepstmnt 2112012700 INSERT INTO DATATYPES (id, BOOLEANDATA, BYTEARRAYDATA, BYTEDATA, CHARARRAYDATA, CHARDATA, DBLDATA, ENUMSDATA, FLOATDATA, INTDATA, INTDATA2, LONGDATA, SHORTDATA) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)} [code=1406, state=22001]
> at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:219)
> at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:195)
> at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeUpdate(LoggingConnectionDecorator.java:1188)
> at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:308)
> at org.apache.openjpa.jdbc.kernel.JDBCStoreManager$CancelPreparedStatement.executeUpdate(JDBCStoreManager.java:1867)
> {code}
> While trying to persist entity with:
> {code}
> @Column(name = "CHARDATA")
> protected char characterData;
> {code}
> Table is create with:
> {code}
> CREATE TABLE DATATYPES (ID INTEGER NOT NULL, BOOLEANDATA SMALLINT NULL, CHARDATA CHAR NULL, SHORTDATA SMALLINT NULL, INTDATA INTEGER NULL, INTDATA2 INTEGER NULL, LONGDATA NUMERIC NULL, DBLDATA DOUBLE PRECISION NULL, FLOATDATA REAL NULL, ENUMODATA INTEGER NULL, ENUMSDATA VARCHAR(25), BYTEDATA SMALLINT NULL, TRANS SMALLINT NULL, BYTEARRAYDATA BLOB, CHARARRAYDATA VARCHAR(448), CONSTRAINT PK_DATATYPES PRIMARY KEY (ID) ) ENGINE=innoDB DEFAULT CHARSET=latin1 !
> {code}
> java oblect is created with:
> {code}
> char[] cArray = { 'a' };
> byte[] bArray = { (byte) 100 };
> d1 = new DataTypes(1, false, (byte) 100, 'a', (short) 100, 300, 600L, 50D, 1.0F, cArray, bArray);
> {code}
> Something weird :(((
--
This message was sent by Atlassian Jira
(v8.20.10#820010)