Hi Maxim, thanks for running these. Doesn't look too bad overall, because most of the errors fall into a few groups.
I have created some issues: https://issues.apache.org/jira/browse/OPENJPA-3028 (parent) - OPENJPA-3029 Derby: EXTRACT is not supported - OPENJPA-3030 Derby: LEFT and RIGHT are not supported - OPENJPA-3031 Derby: CAST(? AS VARCHAR) without a length - OPENJPA-3032 StoredProcedureQuery tests fail on Derby and SQL Server - OPENJPA-3033 Derby: basic type, generator and numeric result type tests fail - OPENJPA-3034 Tests failing on several databases: sequence generator, timestamp, scalar expressions, mixed access - OPENJPA-3035 MySQL: numeric operations return Long where Integer is expected - OPENJPA-3036 MySQL: bulk UPDATE with a subquery on the same table - OPENJPA-3037 MySQL: EXTRACT(WEEK) returns a different week - OPENJPA-3038 MySQL: mapping, order column and map key tests fail For the Derby stored procedure errors ("Procedure ... not found") I am not sure yet whether it is OpenJPA or the TCK setup for Derby. For 3033, 3034 and 3038 the output only says "failed". If you still have the TCK logs from these runs, that would help to find the cause. Gruß Richard > Am 27.10.2026 um 16:58 schrieb Maxim Solodovnik <[email protected]>: > > Surprising Derby result: > > [ERROR] Errors: > [ERROR] Client1.executeTest:192 executeTest failed > [ERROR] Client1.executeUpdateOfADeleteTest:1703 > executeUpdateOfADeleteTest failed > [ERROR] Client1.executeUpdateOfAnUpdateTest:1671 > executeUpdateOfAnUpdateTest failed > [ERROR] Client1.executeUpdateTransactionRequiredExceptionTest:1734 > executeUpdateTransactionRequiredExceptionTest failed > [ERROR] Client1.getFirstResultTest:424 getFirstResultTest failed > [ERROR] Client1.getLockModeIllegalStateExceptionTest:862 > getLockModeIllegalStateExceptionTest failed > [ERROR] Client1.getMaxResultsTest:479 getMaxResultsTest failed > [ERROR] Client1.getOutputParameterValueIntIllegalArgumentExceptionTest:369 > getOutputParameterValueIntIllegalArgumentExceptionTest failed > [ERROR] Client1.getOutputParameterValueIntTest:297 > getOutputParameterValueIntTest failed > [ERROR] Client1.getParameterIntIllegalArgumentExceptionTest:1070 > getParameterIntIllegalArgumentExceptionTest failed > [ERROR] Client1.getParameterStringExceptionTest:1015 > getParameterStringExceptionTest failed > [ERROR] Client1.getParameterValueIntIllegalArgumentExceptionTest:2026 > getParameterValueIntIllegalArgumentExceptionTest failed > [ERROR] Client1.getParameterValueIntIllegalStateExceptionTest:2063 > getParameterValueIntIllegalStateExceptionTest failed > [ERROR] Client1.getParameterValueIntTest:1988 getParameterValueIntTest > failed > [ERROR] Client1.getParameterValueParameterIllegalArgumentExceptionTest:1834 > getParameterValueParameterIllegalArgumentExceptionTest failed > [ERROR] Client1.getParameterValueParameterIllegalStateExceptionTest:1882 > getParameterValueParameterIllegalStateExceptionTest failed > [ERROR] Client1.getParameterValueParameterTest:1790 > getParameterValueParameterTest failed > [ERROR] Client1.getParametersTest:1339 getParametersTest failed > [ERROR] Client1.getSingleResultNoResultExceptionTest:664 > getSingleResultNoResultExceptionTest failed > [ERROR] Client1.getSingleResultNonUniqueResultExceptionTest:707 > getSingleResultNonUniqueResultExceptionTest failed > [ERROR] Client1.getSingleResultOrNullWithNullTest:620 > getSingleResultOrNullWithNullTest failed > [ERROR] Client1.getSingleResultOrNullWithValueTest:577 > getSingleResultOrNullWithValueTest failed > [ERROR] Client1.getSingleResultTest:528 getSingleResultTest failed > [ERROR] Client1.setGetParameterIntTest:913 setGetParameterIntTest failed > [ERROR] Client1.setHintStringObjectTest:2094 setHintStringObjectTest failed > [ERROR] Client1.setLockModeIllegalStateExceptionTest:828 > setLockModeIllegalStateExceptionTest failed > [ERROR] > Client1.setParameterIntDateTemporalTypeIllegalArgumentExceptionTest:1477 > setParameterIntDateTemporalTypeIllegalArgumentExceptionTest failed > [ERROR] Client1.setParameterIntDateTemporalTypeTest:1424 > setParameterIntDateTemporalTypeTest failed > [ERROR] Client1.setParameterIntObjectIllegalArgumentExceptionTest:1292 > setParameterIntObjectIllegalArgumentExceptionTest failed > [ERROR] > Client1.setParameterParameterDateTemporalTypeIllegalArgumentExceptionTest:1638 > setParameterParameterDateTemporalTypeIllegalArgumentExceptionTest > failed > [ERROR] Client1.setParameterParameterDateTemporalTypeTest:1579 > setParameterParameterDateTemporalTypeTest failed > [ERROR] Client1.setParameterParameterObjectIllegalArgumentExceptionTest:1207 > setParameterParameterObjectIllegalArgumentExceptionTest failed > [ERROR] Client1.setParameterParameterObjectTest:1160 > setParameterParameterObjectTest failed > [ERROR] Client1.setgetFlushModeTest:794 setgetFlushModeTest failed > [ERROR] Client1.xmlOverridesNamedStoredProcedureQueryTest:2151 > xmlOverridesNamedStoredProcedureQueryTest failed > [ERROR] Client1.xmlOverridesSqlResultSetMappingAnnotationTest:2206 > xmlOverridesSqlResultSetMappingAnnotationTest failed > [ERROR] > Client2.setParameterIntCalendarTemporalTypeIllegalArgumentExceptionTest:325 > setParameterIntCalendarTemporalTypeIllegalArgumentExceptionTest > failed > [ERROR] Client2.setParameterIntCalendarTemporalTypeTest:273 > setParameterIntCalendarTemporalTypeTest failed > [ERROR] > Client2.setParameterParameterCalendarTemporalTypeIllegalArgumentExceptionTest:484 > setParameterParameterCalendarTemporalTypeIllegalArgumentExceptionTest > failed > [ERROR] Client2.setParameterParameterCalendarTemporalTypeTest:424 > setParameterParameterCalendarTemporalTypeTest failed > [ERROR] Client1.fieldTypeTest1:98 fieldTypeTest1 failed > [ERROR] Client1.fieldTypeTest10:574 fieldTypeTest10 failed > [ERROR] Client1.fieldTypeTest11:643 fieldTypeTest11 failed > [ERROR] Client1.fieldTypeTest12:701 fieldTypeTest12 failed > [ERROR] Client1.fieldTypeTest13:757 fieldTypeTest13 failed > [ERROR] Client1.fieldTypeTest14:813 fieldTypeTest14 failed > [ERROR] Client1.fieldTypeTest15:874 fieldTypeTest15 failed > [ERROR] Client1.fieldTypeTest16:934 fieldTypeTest16 failed > [ERROR] Client1.fieldTypeTest17:999 fieldTypeTest17 failed > [ERROR] Client1.fieldTypeTest2:150 fieldTypeTest2 failed > [ERROR] Client1.fieldTypeTest3:201 fieldTypeTest3 failed > [ERROR] Client1.fieldTypeTest4:252 fieldTypeTest4 failed > [ERROR] Client1.fieldTypeTest5:302 fieldTypeTest5 failed > [ERROR] Client1.fieldTypeTest6:353 fieldTypeTest6 failed > [ERROR] Client1.fieldTypeTest7:403 fieldTypeTest7 failed > [ERROR] Client1.fieldTypeTest8:462 fieldTypeTest8 failed > [ERROR] Client1.fieldTypeTest9:519 fieldTypeTest9 failed > [ERROR] Client2.mixedAccessTest:113 mixedAccessTest failed > [ERROR] Client3.transientTest:119 transientTest failed > [ERROR] Client4.testExtractDateDay:141 > <openjpa-4.2.0-SNAPSHOT-ra2e9c6eM fatal general error> > org.apache.openjpa.persistence.PersistenceException: 42X01 : [0] > Encountered "FROM" at line 1, column 20 {SELECT EXTRACT(DAY FROM > t0.DATATYPES2_ID) FROM DATATYPES2 t0 WHERE (t0.DATATYPES2_ID = ?)} > [code=30000, state=42X01] > FailedObject: SELECT EXTRACT(DAY FROM d.id) FROM DataTypes2 d WHERE > d.id = :id [java.lang.String] > [ERROR] Client4.testExtractDateMonth:116 > <openjpa-4.2.0-SNAPSHOT-ra2e9c6eM fatal general error> > org.apache.openjpa.persistence.PersistenceException: 42X01 : [0] > Encountered "FROM" at line 1, column 22 {SELECT EXTRACT(MONTH FROM > t0.DATATYPES2_ID) FROM DATATYPES2 t0 WHERE (t0.DATATYPES2_ID = ?)} > [code=30000, state=42X01] > FailedObject: SELECT EXTRACT(MONTH FROM d.id) FROM DataTypes2 d WHERE > d.id = :id [java.lang.String] > [ERROR] Client4.testExtractDateQuarter:91 > <openjpa-4.2.0-SNAPSHOT-ra2e9c6eM fatal general error> > org.apache.openjpa.persistence.PersistenceException: 42X01 : [0] > Encountered "FROM" at line 1, column 24 {SELECT EXTRACT(QUARTER FROM > t0.DATATYPES2_ID) FROM DATATYPES2 t0 WHERE (t0.DATATYPES2_ID = ?)} > [code=30000, state=42X01] > FailedObject: SELECT EXTRACT(QUARTER FROM d.id) FROM DataTypes2 d > WHERE d.id = :id [java.lang.String] > [ERROR] Client4.testExtractDateTimeDay:316 > <openjpa-4.2.0-SNAPSHOT-ra2e9c6eM fatal general error> > org.apache.openjpa.persistence.PersistenceException: 42X01 : [0] > Encountered "FROM" at line 1, column 20 {SELECT EXTRACT(DAY FROM > t0.TSDATA) FROM DATATYPES2 t0 WHERE (t0.DATATYPES2_ID = ?)} > [code=30000, state=42X01] > FailedObject: SELECT EXTRACT(DAY FROM d.tsData) FROM DataTypes2 d > WHERE d.id = :id [java.lang.String] > [ERROR] Client4.testExtractDateTimeHour:341 > <openjpa-4.2.0-SNAPSHOT-ra2e9c6eM fatal general error> > org.apache.openjpa.persistence.PersistenceException: 42X01 : [0] > Encountered "HOUR" at line 1, column 16 {SELECT EXTRACT(HOUR FROM > t0.TSDATA) FROM DATATYPES2 t0 WHERE (t0.DATATYPES2_ID = ?)} > [code=30000, state=42X01] > FailedObject: SELECT EXTRACT(HOUR FROM d.tsData) FROM DataTypes2 d > WHERE d.id = :id [java.lang.String] > [ERROR] Client4.testExtractDateTimeMinute:366 > <openjpa-4.2.0-SNAPSHOT-ra2e9c6eM fatal general error> > org.apache.openjpa.persistence.PersistenceException: 42X01 : [0] > Encountered "MINUTE" at line 1, column 16 {SELECT EXTRACT(MINUTE FROM > t0.TSDATA) FROM DATATYPES2 t0 WHERE (t0.DATATYPES2_ID = ?)} > [code=30000, state=42X01] > FailedObject: SELECT EXTRACT(MINUTE FROM d.tsData) FROM DataTypes2 d > WHERE d.id = :id [java.lang.String] > [ERROR] Client4.testExtractDateTimeMonth:291 > <openjpa-4.2.0-SNAPSHOT-ra2e9c6eM fatal general error> > org.apache.openjpa.persistence.PersistenceException: 42X01 : [0] > Encountered "FROM" at line 1, column 22 {SELECT EXTRACT(MONTH FROM > t0.TSDATA) FROM DATATYPES2 t0 WHERE (t0.DATATYPES2_ID = ?)} > [code=30000, state=42X01] > FailedObject: SELECT EXTRACT(MONTH FROM d.tsData) FROM DataTypes2 d > WHERE d.id = :id [java.lang.String] > [ERROR] Client4.testExtractDateTimeQuarter:266 > <openjpa-4.2.0-SNAPSHOT-ra2e9c6eM fatal general error> > org.apache.openjpa.persistence.PersistenceException: 42X01 : [0] > Encountered "FROM" at line 1, column 24 {SELECT EXTRACT(QUARTER FROM > t0.TSDATA) FROM DATATYPES2 t0 WHERE (t0.DATATYPES2_ID = ?)} > [code=30000, state=42X01] > FailedObject: SELECT EXTRACT(QUARTER FROM d.tsData) FROM DataTypes2 d > WHERE d.id = :id [java.lang.String] > [ERROR] Client4.testExtractDateTimeSecond:391 > <openjpa-4.2.0-SNAPSHOT-ra2e9c6eM fatal general error> > org.apache.openjpa.persistence.PersistenceException: 42X01 : [0] > Encountered "SECOND" at line 1, column 16 {SELECT EXTRACT(SECOND FROM > t0.TSDATA) FROM DATATYPES2 t0 WHERE (t0.DATATYPES2_ID = ?)} > [code=30000, state=42X01] > FailedObject: SELECT EXTRACT(SECOND FROM d.tsData) FROM DataTypes2 d > WHERE d.id = :id [java.lang.String] > [ERROR] Client4.testExtractDateTimeYear:241 > <openjpa-4.2.0-SNAPSHOT-ra2e9c6eM fatal general error> > org.apache.openjpa.persistence.PersistenceException: 42X01 : [0] > Encountered "YEAR" at line 1, column 16 {SELECT EXTRACT(YEAR FROM > t0.TSDATA) FROM DATATYPES2 t0 WHERE (t0.DATATYPES2_ID = ?)} > [code=30000, state=42X01] > FailedObject: SELECT EXTRACT(YEAR FROM d.tsData) FROM DataTypes2 d > WHERE d.id = :id [java.lang.String] > [ERROR] Client4.testExtractDateYear:66 > <openjpa-4.2.0-SNAPSHOT-ra2e9c6eM fatal general error> > org.apache.openjpa.persistence.PersistenceException: 42X01 : [0] > Encountered "YEAR" at line 1, column 16 {SELECT EXTRACT(YEAR FROM > t0.DATATYPES2_ID) FROM DATATYPES2 t0 WHERE (t0.DATATYPES2_ID = ?)} > [code=30000, state=42X01] > FailedObject: SELECT EXTRACT(YEAR FROM d.id) FROM DataTypes2 d WHERE > d.id = :id [java.lang.String] > [ERROR] Client4.testExtractTimeHour:166 > <openjpa-4.2.0-SNAPSHOT-ra2e9c6eM fatal general error> > org.apache.openjpa.persistence.PersistenceException: 42X01 : [0] > Encountered "HOUR" at line 1, column 16 {SELECT EXTRACT(HOUR FROM > t0.TIMEDATA) FROM DATATYPES2 t0 WHERE (t0.DATATYPES2_ID = ?)} > [code=30000, state=42X01] > FailedObject: SELECT EXTRACT(HOUR FROM d.timeData) FROM DataTypes2 d > WHERE d.id = :id [java.lang.String] > [ERROR] Client4.testExtractTimeMinute:191 > <openjpa-4.2.0-SNAPSHOT-ra2e9c6eM fatal general error> > org.apache.openjpa.persistence.PersistenceException: 42X01 : [0] > Encountered "MINUTE" at line 1, column 16 {SELECT EXTRACT(MINUTE FROM > t0.TIMEDATA) FROM DATATYPES2 t0 WHERE (t0.DATATYPES2_ID = ?)} > [code=30000, state=42X01] > FailedObject: SELECT EXTRACT(MINUTE FROM d.timeData) FROM DataTypes2 d > WHERE d.id = :id [java.lang.String] > [ERROR] Client4.testExtractTimeSecond:216 > <openjpa-4.2.0-SNAPSHOT-ra2e9c6eM fatal general error> > org.apache.openjpa.persistence.PersistenceException: 42X01 : [0] > Encountered "SECOND" at line 1, column 16 {SELECT EXTRACT(SECOND FROM > t0.TIMEDATA) FROM DATATYPES2 t0 WHERE (t0.DATATYPES2_ID = ?)} > [code=30000, state=42X01] > FailedObject: SELECT EXTRACT(SECOND FROM d.timeData) FROM DataTypes2 d > WHERE d.id = :id [java.lang.String] > [ERROR] Client1.propertyTypeTest1:111 propertyTypeTest1 failed > [ERROR] Client1.propertyTypeTest10:611 propertyTypeTest10 failed > [ERROR] Client1.propertyTypeTest11:668 propertyTypeTest11 failed > [ERROR] Client1.propertyTypeTest12:725 propertyTypeTest12 failed > [ERROR] Client1.propertyTypeTest13:776 propertyTypeTest13 failed > [ERROR] Client1.propertyTypeTest2:163 propertyTypeTest2 failed > [ERROR] Client1.propertyTypeTest3:213 propertyTypeTest3 failed > [ERROR] Client1.propertyTypeTest4:264 propertyTypeTest4 failed > [ERROR] Client1.propertyTypeTest5:315 propertyTypeTest5 failed > [ERROR] Client1.propertyTypeTest6:367 propertyTypeTest6 failed > [ERROR] Client1.propertyTypeTest7:428 propertyTypeTest7 failed > [ERROR] Client1.propertyTypeTest8:484 propertyTypeTest8 failed > [ERROR] Client1.propertyTypeTest9:553 propertyTypeTest9 failed > [ERROR] Client2.transientTest:98 transientTest failed > [ERROR] Client1.persistBasicTest2:218 persistBasicTest2 failed > [ERROR] Client1.persistBasicTest3:306 persistBasicTest3 failed > [ERROR] Client1.persistBasicTest4:402 persistBasicTest4 failed > [ERROR] Client2.BigDecimalOperandResultTypeTests:418 > BigDecimalOperandResultTypeTests failed > [ERROR] Client2.BigIntegerOperandResultTypeTests:482 > BigIntegerOperandResultTypeTests failed > [ERROR] Client2.DoubleOperandResultTypeTests:198 > DoubleOperandResultTypeTests failed > [ERROR] Client2.FloatOperandResultTypeTests:339 > FloatOperandResultTypeTests failed > [ERROR] Client2.LongOperandResultTypeTests:593 > LongOperandResultTypeTests failed > [ERROR] Client2.ShortOperandResultTypeTests:704 > ShortOperandResultTypeTests failed > [ERROR] Client9.testExtractDayFromDate:1044 » Persistence 42X01 : > [0] Encountered "FROM" at line 1, column 131 {SELECT t0.id, > t0.DATE_VAL, t0.INT_VAL, t0.STR_VAL_1, t0.STR_VAL_2, t0.TIME_VAL FROM > CRITERIA_TEST_TABLE t0 WHERE (? = EXTRACT(DAY FROM t0.DATE_VAL))} > [code=30000, state=42X01] > [ERROR] Client9.testExtractHourFromTime:813 » Persistence 42X01 : > [0] Encountered "HOUR" at line 1, column 127 {SELECT t0.id, > t0.DATE_VAL, t0.INT_VAL, t0.STR_VAL_1, t0.STR_VAL_2, t0.TIME_VAL FROM > CRITERIA_TEST_TABLE t0 WHERE (? = EXTRACT(HOUR FROM t0.TIME_VAL))} > [code=30000, state=42X01] > [ERROR] Client9.testExtractMinuteFromTime:859 » Persistence 42X01 : > [0] Encountered "MINUTE" at line 1, column 127 {SELECT t0.id, > t0.DATE_VAL, t0.INT_VAL, t0.STR_VAL_1, t0.STR_VAL_2, t0.TIME_VAL FROM > CRITERIA_TEST_TABLE t0 WHERE (? = EXTRACT(MINUTE FROM t0.TIME_VAL))} > [code=30000, state=42X01] > [ERROR] Client9.testExtractMonthFromDate:998 » Persistence 42X01 : > [0] Encountered "FROM" at line 1, column 133 {SELECT t0.id, > t0.DATE_VAL, t0.INT_VAL, t0.STR_VAL_1, t0.STR_VAL_2, t0.TIME_VAL FROM > CRITERIA_TEST_TABLE t0 WHERE (? = EXTRACT(MONTH FROM t0.DATE_VAL))} > [code=30000, state=42X01] > [ERROR] Client9.testExtractQuarterFromDate:1090 » Persistence 42X01 > : [0] Encountered "FROM" at line 1, column 135 {SELECT t0.id, > t0.DATE_VAL, t0.INT_VAL, t0.STR_VAL_1, t0.STR_VAL_2, t0.TIME_VAL FROM > CRITERIA_TEST_TABLE t0 WHERE (? = EXTRACT(QUARTER FROM t0.DATE_VAL))} > [code=30000, state=42X01] > [ERROR] Client9.testExtractSecondFromTime:906 » Persistence 42X01 : > [0] Encountered "SECOND" at line 1, column 146 {SELECT t0.id, > t0.DATE_VAL, t0.INT_VAL, t0.STR_VAL_1, t0.STR_VAL_2, t0.TIME_VAL FROM > CRITERIA_TEST_TABLE t0 WHERE (CAST(? AS REAL) = CAST(EXTRACT(SECOND > FROM t0.TIME_VAL) AS REAL))} [code=30000, state=42X01] > [ERROR] Client9.testExtractWeekFromDate:1138 » Persistence 42X01 : > [0] Encountered "FROM" at line 1, column 132 {SELECT t0.id, > t0.DATE_VAL, t0.INT_VAL, t0.STR_VAL_1, t0.STR_VAL_2, t0.TIME_VAL FROM > CRITERIA_TEST_TABLE t0 WHERE (? = EXTRACT(WEEK FROM t0.DATE_VAL))} > [code=30000, state=42X01] > [ERROR] Client9.testExtractYearFromDate:952 » Persistence 42X01 : > [0] Encountered "YEAR" at line 1, column 127 {SELECT t0.id, > t0.DATE_VAL, t0.INT_VAL, t0.STR_VAL_1, t0.STR_VAL_2, t0.TIME_VAL FROM > CRITERIA_TEST_TABLE t0 WHERE (? = EXTRACT(YEAR FROM t0.DATE_VAL))} > [code=30000, state=42X01] > [ERROR] Client9.testLeftExprLen:493 » Persistence 42X01 : [0] > Encountered "LEFT" at line 1, column 130 {SELECT t0.id, t0.DATE_VAL, > t0.INT_VAL, t0.STR_VAL_1, t0.STR_VAL_2, t0.TIME_VAL FROM > CRITERIA_TEST_TABLE t0 WHERE (t0.STR_VAL_1 = LEFT(?, 4))} [code=30000, > state=42X01] > [ERROR] Client9.testLeftIntLen:448 » Persistence 42X01 : [0] > Encountered "LEFT" at line 1, column 130 {SELECT t0.id, t0.DATE_VAL, > t0.INT_VAL, t0.STR_VAL_1, t0.STR_VAL_2, t0.TIME_VAL FROM > CRITERIA_TEST_TABLE t0 WHERE (t0.STR_VAL_1 = LEFT(?, 4))} [code=30000, > state=42X01] > [ERROR] Client9.testRightExprLen:583 » Persistence 42X01 : [0] > Encountered "RIGHT" at line 1, column 130 {SELECT t0.id, t0.DATE_VAL, > t0.INT_VAL, t0.STR_VAL_1, t0.STR_VAL_2, t0.TIME_VAL FROM > CRITERIA_TEST_TABLE t0 WHERE (t0.STR_VAL_1 = RIGHT(?, 5))} > [code=30000, state=42X01] > [ERROR] Client9.testRightIntLen:538 » Persistence 42X01 : [0] > Encountered "RIGHT" at line 1, column 130 {SELECT t0.id, t0.DATE_VAL, > t0.INT_VAL, t0.STR_VAL_1, t0.STR_VAL_2, t0.TIME_VAL FROM > CRITERIA_TEST_TABLE t0 WHERE (t0.STR_VAL_1 = RIGHT(?, 5))} > [code=30000, state=42X01] > [ERROR] Client5.BigDecimalOperandResultTypeTests:540 > BigDecimalOperandResultTypeTests failed > [ERROR] Client5.BigIntegerOperandResultTypeTests:623 > BigIntegerOperandResultTypeTests failed > [ERROR] Client5.DoubleOperandResultTypeTests:250 > DoubleOperandResultTypeTests failed > [ERROR] Client5.FloatOperandResultTypeTests:436 > FloatOperandResultTypeTests failed > [ERROR] Client5.LongOperandResultTypeTests:769 > LongOperandResultTypeTests failed > [ERROR] Client5.ShortOperandResultTypeTests:915 > ShortOperandResultTypeTests failed > [ERROR] Client2.parameterExpressionInCollectionTest:244 » > Persistence 42X01 : [0] Encountered ")" at line 1, column 107 {SELECT > t0.ID, t0.FIRSTNAME, t0.HIREDATE, t0.LASTNAME, t0.SALARY FROM EMPLOYEE > t0 WHERE ((CAST(? AS VARCHAR) = CAST(? AS VARCHAR) OR CAST(? AS > VARCHAR) = CAST(? AS VARCHAR)) AND 1 = 1)} [code=30000, state=42X01] > [ERROR] Client2.parameterExpressionInExpressionArrayTest:174 » > Persistence 42X01 : [0] Encountered ")" at line 1, column 107 {SELECT > t0.ID, t0.FIRSTNAME, t0.HIREDATE, t0.LASTNAME, t0.SALARY FROM EMPLOYEE > t0 WHERE ((CAST(? AS VARCHAR) = CAST(? AS VARCHAR) OR CAST(? AS > VARCHAR) = CAST(? AS VARCHAR)) AND 1 = 1)} [code=30000, state=42X01] > [ERROR] Client2.parameterExpressionInExpressionTest:312 » > Persistence 42X01 : [0] Encountered ")" at line 1, column 106 {SELECT > t0.ID, t0.FIRSTNAME, t0.HIREDATE, t0.LASTNAME, t0.SALARY FROM EMPLOYEE > t0 WHERE (CAST(? AS VARCHAR) = CAST(? AS VARCHAR) AND 1 = 1)} > [code=30000, state=42X01] > [ERROR] Client3.createNamedStoredProcedureQueryStringTest:406 » > Rollback Procedure [GetEmpIdFNameLNameFromRS] not found > [ERROR] Client3.createStoredProcedureQueryStringClassArrayTest:305 » > Rollback Procedure [GetEmpASCFromRS] not found > [ERROR] Client3.createStoredProcedureQueryStringStringArrayTest:356 > » Rollback Procedure [GetEmpIdFNameLNameFromRS] not found > [ERROR] Client3.createStoredProcedureQueryStringTest:258 » Rollback > Procedure [GetEmpOneFirstNameFromOut] not found > [ERROR] Client.persistBasicTest2:222 persistBasicTest2 failed > [ERROR] Client.persistBasicTest3:310 persistBasicTest3 failed > [ERROR] Client.persistBasicTest4:406 persistBasicTest4 failed > [ERROR] Client.persistBasicTest5:504 persistBasicTest5 failed > [ERROR] Client.persistBasicTest2:222 persistBasicTest2 failed > [ERROR] Client.persistBasicTest3:309 persistBasicTest3 failed > [ERROR] Client.persistBasicTest4:405 persistBasicTest4 failed > [ERROR] Client.persistBasicTest5:503 persistBasicTest5 failed > [ERROR] Client.cascadeAllMX1Test2:200 cascadeAllMX1Test2 failed > [ERROR] Client.persistMX1Test2:205 persistMX1Test2 failed > [ERROR] Client3.test_leftStringExpression:972 > test_leftStringExpression failed > [ERROR] Client3.test_rightStringExpression:1003 > test_rightStringExpression failed > [ERROR] Client.autoTypeTest1:151 autoTypeTest1 failed > [ERROR] Client.autoTypeTest2:212 autoTypeTest2 failed > [ERROR] Client.autoTypeTest3:273 autoTypeTest3 failed > [ERROR] Client.autoTypeTest4:334 autoTypeTest4 failed > [ERROR] Client.autoTypeTest5:395 autoTypeTest5 failed > [ERROR] Client.autoTypeTest6:456 autoTypeTest6 failed > [ERROR] Client.dateTimeTest:242 dateTimeTest (Jakarta Persistence > Java 8 date and time types test) failed > [ERROR] Client.fieldTypeTest1:119 fieldTypeTest1 failed > [ERROR] Client.fieldTypeTest10:592 fieldTypeTest10 failed > [ERROR] Client.fieldTypeTest11:660 fieldTypeTest11 failed > [ERROR] Client.fieldTypeTest12:717 fieldTypeTest12 failed > [ERROR] Client.fieldTypeTest13:773 fieldTypeTest13 failed > [ERROR] Client.fieldTypeTest14:829 fieldTypeTest14 failed > [ERROR] Client.fieldTypeTest15:892 fieldTypeTest15 failed > [ERROR] Client.fieldTypeTest16:955 fieldTypeTest16 failed > [ERROR] Client.fieldTypeTest17:1021 fieldTypeTest17 failed > [ERROR] Client.fieldTypeTest2:170 fieldTypeTest2 failed > [ERROR] Client.fieldTypeTest3:221 fieldTypeTest3 failed > [ERROR] Client.fieldTypeTest4:272 fieldTypeTest4 failed > [ERROR] Client.fieldTypeTest5:322 fieldTypeTest5 failed > [ERROR] Client.fieldTypeTest6:373 fieldTypeTest6 failed > [ERROR] Client.fieldTypeTest7:423 fieldTypeTest7 failed > [ERROR] Client.fieldTypeTest8:480 fieldTypeTest8 failed > [ERROR] Client.fieldTypeTest9:537 fieldTypeTest9 failed > [ERROR] Client.scalarExpressionsTest:1210 scalarExpressionsTest failed > [ERROR] Client1.generatorTypeTest1:147 generatorTypeTest1 failed > [ERROR] Client1.generatorTypeTest2:202 generatorTypeTest2 failed > [ERROR] Client1.generatorTypeTest3:256 generatorTypeTest3 failed > [ERROR] Client1.generatorTypeTest4:312 generatorTypeTest4 failed > [ERROR] Client1.generatorTypeTest5:367 generatorTypeTest5 failed > [ERROR] Client1.generatorTypeTest6:422 generatorTypeTest6 failed > [ERROR] Client2.generatorTypeSequenceTest:142 > generatorTypeSequenceTest failed > [ERROR] Client1.propertyTypeTest1:123 propertyTypeTest1 failed > [ERROR] Client1.propertyTypeTest10:626 propertyTypeTest10 failed > [ERROR] Client1.propertyTypeTest11:683 propertyTypeTest11 failed > [ERROR] Client1.propertyTypeTest12:740 propertyTypeTest12 failed > [ERROR] Client1.propertyTypeTest2:175 propertyTypeTest2 failed > [ERROR] Client1.propertyTypeTest3:226 propertyTypeTest3 failed > [ERROR] Client1.propertyTypeTest4:278 propertyTypeTest4 failed > [ERROR] Client1.propertyTypeTest5:330 propertyTypeTest5 failed > [ERROR] Client1.propertyTypeTest6:383 propertyTypeTest6 failed > [ERROR] Client1.propertyTypeTest7:443 propertyTypeTest7 failed > [ERROR] Client1.propertyTypeTest8:499 propertyTypeTest8 failed > [ERROR] Client1.propertyTypeTest9:568 propertyTypeTest9 failed > [ERROR] Client1.scalarExpressionsTest:893 scalarExpressionsTest failed > [ERROR] Client.createNamedStoredProcedureQueryStringTest:288 » > Rollback Procedure [GetEmpIdFNameLNameFromRS] not found > [ERROR] Client.createStoredProcedureQueryStringClassArrayTest:185 » > Rollback Procedure [GetEmpASCFromRS] not found > [ERROR] Client.createStoredProcedureQueryStringStringArrayTest:238 » > Rollback Procedure [GetEmpIdFNameLNameFromRS] not found > [ERROR] Client.createStoredProcedureQueryStringTest:137 » Rollback > Procedure [GetEmpOneFirstNameFromOut] not found > [ERROR] Client.sequenceGeneratorTest:226 sequenceGeneratorTest failed > [ERROR] Client.sequenceGeneratorTest:229 sequenceGeneratorTest failed > [INFO] > [ERROR] Tests run: 2134, Failures: 0, Errors: 184, Skipped: 4 > > On Tue, 27 Oct 2026 at 21:29, Maxim Solodovnik <[email protected]> wrote: >> >> Here are fresh TCK results: >> >> postgresql:16 - PASSED >> mysql:8.4.8 - FAILED [1] >> mssql:2017-CU12-ubuntu - FAILED [2] >> >> NOTE: TCK build is NOT working with fresh Maven 3.10.0, 3.9.16 works >> as expected :) >> >> ------------------------------------------------------------------- >> [1] mysql:8.4.8 Errors: >> >> [ERROR] Errors: >> [ERROR] Client.associationOverride:109 test2 failed >> [ERROR] Client.mapKeyClass:111 mapKeyClass Failed >> [ERROR] Client.mapKeyJoinColumn:108 mapKeyJoinColumn Failed >> [ERROR] Client1.orderByTest1:156 orderByTest1 failed >> [ERROR] Client1.orderByTest2:237 orderByTest2 failed >> [ERROR] Client1.orderByTest3:315 orderByTest3 failed >> [ERROR] Client1.orderByTest4:391 orderByTest4 failed >> [ERROR] Client1.orderColumn:137 orderColumn test failed >> [ERROR] Client4.timestampFieldTest:112 timestampFieldTest failed >> [ERROR] Client4.timestampPropertyTest:168 timestampPropertyTest failed >> [ERROR] Client5.diffNumberExpTest:1737 ClassCast class >> java.lang.Long cannot be cast to class java.lang.Integer >> (java.lang.Long and java.lang.Integer are in module java.base of >> loader 'bootstrap') >> [ERROR] Client5.neg:1476 ClassCast class java.lang.Long cannot be >> cast to class java.lang.Integer (java.lang.Long and java.lang.Integer >> are in module java.base of loader 'bootstrap') >> [ERROR] Client5.sumNumExpTest:340 ClassCast class java.lang.Long >> cannot be cast to class java.lang.Integer (java.lang.Long and >> java.lang.Integer are in module java.base of loader 'bootstrap') >> [ERROR] Client9.testExtractWeekFromDate:1146 » IndexOutOfBounds >> Index 0 out of bounds for length 0 >> [ERROR] Client.subquery:715 » Persistence You can't specify target >> table 't0' for update in FROM clause {prepstmnt 729429705 UPDATE >> PRODUCT_TABLE t0 INNER JOIN PRODUCT_DETAILS t2 ON t0.ID = t2.ID SET >> t0.QUANTITY = (t0.QUANTITY * ?) WHERE (EXISTS (SELECT t1.ID FROM >> PRODUCT_TABLE t1 WHERE (t0.ID = ?)))} [code=1093, state=HY000] >> [ERROR] Client.DIDTest:124 DIDTest failed >> [ERROR] Client.test1:122 test1 failed >> [ERROR] Client1.setParameterParameterCalendarTemporalTypeTest:2410 >> setParameterParameterCalendarTemporalTypeTest failed >> [ERROR] Client.annotationMappingTest1:142 annotationMappingTest1 failed >> [ERROR] Client.annotationMappingTest3:436 annotationMappingTest3 failed >> [ERROR] Client.annotationMappingTest4:509 annotationMappingTest4 failed >> [ERROR] Client.annotationMappingTest5:589 annotationMappingTest5 failed >> [ERROR] Client.annotationMappingTest6:749 annotationMappingTest6 failed >> [ERROR] Client.annotationMappingTest7:958 annotationMappingTest7 failed >> [ERROR] Client.annotationMappingTest8:1104 annotationMappingTest8 failed >> [ERROR] Client.biDirMXMTest1:172 biDirMXMTest1 failed >> [ERROR] Client.mappingTest1:139 mappingTest1 failed >> [ERROR] Client.mappingTest2:273 mappingTest2 failed >> [ERROR] Client.mappingTest3:366 mappingTest3 failed >> [ERROR] Client.mappingTest4:437 mappingTest4 failed >> [ERROR] Client.mappingTest5:516 mappingTest5 failed >> [ERROR] Client.mappingTest6:669 mappingTest6 failed >> [ERROR] Client.mappingTest7:876 mappingTest7 failed >> [ERROR] Client.mappingTest8:1019 mappingTest8 failed >> [ERROR] Client.test1:118 test1 failed >> [ERROR] Client.didTest:128 DIDTest failed >> [ERROR] Client.mapKeyJoinColumnTest:101 mapKeyJoinColumn Failed >> [ERROR] Client.sequenceGeneratorTest:226 sequenceGeneratorTest failed >> [ERROR] Client.joinTableTest:335 joinTableTest failed >> [ERROR] Client.orderColumnTest:281 orderColumnTest failed >> [ERROR] Client.secondaryTableTest:237 secondaryTableTest failed >> [ERROR] Client.sequenceGeneratorTest:229 sequenceGeneratorTest failed >> [ERROR] Client.uniqueConstraintTest:221 uniqueConstraintTest failed >> [INFO] >> [ERROR] Tests run: 2134, Failures: 0, Errors: 43, Skipped: 4 >> ------------------------------------------------------------------- >> >> ------------------------------------------------------------------- >> [2] mssql:2017-CU12-ubuntu >> >> [ERROR] Errors: >> [ERROR] Client1.executeTest:192 executeTest failed >> [ERROR] Client1.executeUpdateOfADeleteTest:1703 >> executeUpdateOfADeleteTest failed >> [ERROR] Client1.executeUpdateOfAnUpdateTest:1671 >> executeUpdateOfAnUpdateTest failed >> [ERROR] Client1.getFirstResultTest:424 getFirstResultTest failed >> [ERROR] Client1.getMaxResultsTest:479 getMaxResultsTest failed >> [ERROR] Client1.getOutputParameterValueIntIllegalArgumentExceptionTest:369 >> getOutputParameterValueIntIllegalArgumentExceptionTest failed >> [ERROR] Client1.getOutputParameterValueIntTest:297 >> getOutputParameterValueIntTest failed >> [ERROR] Client1.getParameterValueIntTest:1988 getParameterValueIntTest >> failed >> [ERROR] Client1.getParameterValueParameterTest:1790 >> getParameterValueParameterTest failed >> [ERROR] Client1.getParametersTest:1339 getParametersTest failed >> [ERROR] Client1.getSingleResultNoResultExceptionTest:664 >> getSingleResultNoResultExceptionTest failed >> [ERROR] Client1.getSingleResultNonUniqueResultExceptionTest:707 >> getSingleResultNonUniqueResultExceptionTest failed >> [ERROR] Client1.getSingleResultOrNullWithNullTest:620 >> getSingleResultOrNullWithNullTest failed >> [ERROR] Client1.getSingleResultOrNullWithValueTest:577 >> getSingleResultOrNullWithValueTest failed >> [ERROR] Client1.getSingleResultTest:528 getSingleResultTest failed >> [ERROR] Client1.setHintStringObjectTest:2094 setHintStringObjectTest >> failed >> [ERROR] Client1.setParameterIntDateTemporalTypeTest:1424 >> setParameterIntDateTemporalTypeTest failed >> [ERROR] Client1.setParameterParameterDateTemporalTypeTest:1579 >> setParameterParameterDateTemporalTypeTest failed >> [ERROR] Client1.setParameterParameterObjectTest:1160 >> setParameterParameterObjectTest failed >> [ERROR] Client1.xmlOverridesNamedStoredProcedureQueryTest:2151 >> xmlOverridesNamedStoredProcedureQueryTest failed >> [ERROR] Client1.xmlOverridesSqlResultSetMappingAnnotationTest:2206 >> xmlOverridesSqlResultSetMappingAnnotationTest failed >> [ERROR] Client2.setParameterIntCalendarTemporalTypeTest:273 >> setParameterIntCalendarTemporalTypeTest failed >> [ERROR] Client2.setParameterParameterCalendarTemporalTypeTest:424 >> setParameterParameterCalendarTemporalTypeTest failed >> [ERROR] Client2.mixedAccessTest:113 mixedAccessTest failed >> [ERROR] Client3.transientTest:119 transientTest failed >> [ERROR] Client1.propertyTypeTest1:111 propertyTypeTest1 failed >> [ERROR] Client2.transientTest:98 transientTest failed >> [ERROR] Client4.timestampFieldTest:112 timestampFieldTest failed >> [ERROR] Client4.timestampPropertyTest:168 timestampPropertyTest failed >> [ERROR] Client3.createNamedStoredProcedureQueryStringTest:409 >> createNamedStoredProcedureQueryStringTest failed >> [ERROR] Client3.createStoredProcedureQueryStringClassArrayTest:308 >> createStoredProcedureQueryStringClassArrayTest failed >> [ERROR] Client3.createStoredProcedureQueryStringStringArrayTest:359 >> createStoredProcedureQueryStringStringArrayTest failed >> [ERROR] Client3.createStoredProcedureQueryStringTest:261 >> createStoredProcedureQueryStringTest failed >> [ERROR] Client.cascadeAllMX1Test2:200 cascadeAllMX1Test2 failed >> [ERROR] Client.persistMX1Test2:205 persistMX1Test2 failed >> [ERROR] Client1.setParameterParameterCalendarTemporalTypeTest:2410 >> setParameterParameterCalendarTemporalTypeTest failed >> [ERROR] Client.autoTypeTest1:151 autoTypeTest1 failed >> [ERROR] Client.scalarExpressionsTest:1210 scalarExpressionsTest failed >> [ERROR] Client1.scalarExpressionsTest:893 scalarExpressionsTest failed >> [ERROR] Client.createNamedStoredProcedureQueryStringTest:291 >> createNamedStoredProcedureQueryStringTest failed >> [ERROR] Client.createStoredProcedureQueryStringClassArrayTest:188 >> createStoredProcedureQueryStringClassArrayTest failed >> [ERROR] Client.createStoredProcedureQueryStringStringArrayTest:241 >> createStoredProcedureQueryStringStringArrayTest failed >> [ERROR] Client.createStoredProcedureQueryStringTest:140 >> createStoredProcedureQueryStringTest failed >> [ERROR] Client.sequenceGeneratorTest:226 sequenceGeneratorTest failed >> [ERROR] Client.sequenceGeneratorTest:229 sequenceGeneratorTest failed >> [INFO] >> [ERROR] Tests run: 2134, Failures: 0, Errors: 45, Skipped: 4 >> >> ------------------------------------------------------------------- >> >> >> On Tue, 27 Oct 2026 at 09:04, Maxim Solodovnik <[email protected]> wrote: >>> >>> (sorry for double post) >>> >>> I agree TCK shouldn't be green (as it is not green at 4.1.x :))) >>> I would like to check if it can be improved with some minor fixes :) >>> >>> BTW we need to check our site with next build, currently it looks too >>> old-school ... :) >>> Maybe I can add reflow-skin >>> https://devacfr.github.io/reflow-maven-skin/doc/reflow-documentation.html#doc-get-started >>> for ex.? >>> >>> On Tue, 27 Oct 2026 at 07:13, Maxim Solodovnik <[email protected]> wrote: >>>> >>>> OpenMeetings is green :) >>>> The only issue was converted to OpenJPA test and you have fixed it :) >>>> >>>> from mobile (sorry for typos ;) >>>> >>>> >>>> On Tue, Oct 27, 2026, 01:35 Richard Zowalla <[email protected]> wrote: >>>>> >>>>> Hi, >>>>> >>>>> I think we can go with a M0 soonish. I don’t think that we need to clear >>>>> all TCK failures across all rdbms for a milestone release as long as our >>>>> own build and tests are fine / green. >>>>> >>>>> Did you test in your projects (syncope, open meetings) ? That would be >>>>> beneficial to spot any left overs. >>>>> >>>>> For TomEE it would be best to have some sort of stable version to ship in >>>>> a TomEE 11 milestone, but not much to test from a user point of view in >>>>> it. The projects above might be better candidates as demonstrated by >>>>> syncope ;) >>>>> >>>>> We are currently in the process of preparing the next one, but it might >>>>> take some additional time. >>>>> >>>>> Gruß >>>>> Richard >>>>> >>>>> >>>>> >>>>>> Am 26.10.2026 um 14:31 schrieb Francesco Chicchiriccò >>>>>> <[email protected]>: >>>>>> >>>>>> Thank you Maxim, hope at least the first milestone can see the light >>>>>> before end of year. >>>>>> >>>>>> Meanwhile: >>>>>> >>>>>> https://github.com/apache/syncope/pull/1582 >>>>>> >>>>>> Regards. >>>>>> >>>>>> On 26/10/26 11:16, Maxim Solodovnik wrote: >>>>>>> Hello Francesco, >>>>>>> >>>>>>> As I understand Richard going to test Tommee first :) >>>>>>> >>>>>>> I'll try to run TCK >>>>>>> There were ~10 errors/failures if I'm not mistaken >>>>>>> >>>>>>> And our "Databases" weekly job has failed at Postgress .... >>>>>>> >>>>>>> from mobile (sorry for typos ;) >>>>>>> >>>>>>> >>>>>>> On Mon, Oct 26, 2026, 17:06 Francesco Chicchiriccò <[email protected]> >>>>>>> wrote: >>>>>>> >>>>>>>> Hi, >>>>>>>> I was wondering around when we believe we could release out the first >>>>>>>> 4.2 >>>>>>>> artifacts (4.2.0, 4.2.0-M0?) >>>>>>>> >>>>>>>> Regards. >>>>>> >>>>>> -- >>>>>> Francesco Chicchiriccò >>>>>> >>>>>> Tirasa - Open Source Excellence >>>>>> http://www.tirasa.net/ >>>>>> >>>>>> Member at The Apache Software Foundation >>>>>> Syncope, CXF, OpenJPA >>>>>> https://about.me/ilgrosso >>>>>> >>>>> >>> >>> >>> -- >>> Best regards, >>> Maxim >> >> >> >> -- >> Best regards, >> Maxim > > > > -- > Best regards, > Maxim >
