Thanks a million Richard! I'll re-run and will add logs to correspondent issues
from mobile (sorry for typos ;) On Tue, Oct 27, 2026, 23:36 Richard Zowalla <[email protected]> wrote: > 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 > > > >
