Closed scottmarlow closed 2 months ago
@LanceAndersen (lead of the JDBC Specification) asked if we tried to modify the Decimal_Tab_Insert
in the derby.dml.sql
file to a value that works with both Java versions (e.g. 21 + 17/11). If there is such a value, we could change to that value. If there is no value that works with both, we should exclude the tests.
Note that the TCK dml/ddl files are intended to be modified as needed for the backend/platform.
grep -ri Decimal_Tab_Insert --include=*.sql sql/db2/db2.dml.sql:Decimal_Tab_Insert= insert into Decimal_Tab values(99999,0.000000000000001, null) sql/derby/derby.dml.sql:Decimal_Tab_Insert= insert into Decimal_Tab values(999999999999999,0.000000000000001, null) sql/mssqlserver/mssqlserver.dml.sql:Decimal_Tab_Insert= insert into Decimal_Tab values(999999999999999,0.000000000000001, null) sql/mysql/mysql.dml.sql:#Decimal_Tab_Insert= insert into Decimal_Tab values(999999999999999,0.000000000000001, null) sql/mysql/mysql.dml.sql:Decimal_Tab_Insert= insert into Decimal_Tab values(9999999999,0.0000000001, null) sql/oracle/oracle.dml.sql:Decimal_Tab_Insert= insert into Decimal_Tab values(999999999999999,0.000000000000001, null) sql/pointbase/pointbase.dml.sql:Decimal_Tab_Insert= insert into Decimal_Tab values(999999999999999,0.000000000000000, null) sql/postgresql/postgresql.dml.sql:#Decimal_Tab_Insert= insert into Decimal_Tab values(999999999999999,0.0000000001, null) sql/postgresql/postgresql.dml.sql:Decimal_Tab_Insert= insert into Decimal_Tab values(9999999999,0.0000000001, null) sql/sybase/sybase.dml.sql:Decimal_Tab_Insert= insert into Decimal_Tab values(999999999999999,0.000000000000001, null)
I think that we will soon have another EE 10 Platform TCK release to address TCK challenges like this one. I haven't had time to research test changes related to this challenge and I likely will be heads down on EE 11 TCK test refactoring until that is further along (along with others).
So this is looking like something that we will need to exclude the tests for instead of correcting for EE 10. Perhaps the test correction could be made for EE 11 as we will soon hit the same issues there.
Thanks to some investigatory work by @mswatosh, we think that a value of 9999999999
should work with all of the relevant levels of Java. I'll be trying it out locally with Open Liberty at some point today or tomorrow.
@LanceAndersen as per ^ we are trying to test with a change from 999999999999999
to instead use 9999999999
which I think meets the criteria that you mentioned as we think that value would work on different versions of Java. Any concerns with a change like that?
For easier reading, the problematic value is 999,999,999,999,999
and we will instead try using 9,999,999,999
.
For the record, both Decimal_Tab (for test 177) and Numeric_Tab (for test 179) need to be updated, but this does seem to work for me with Open Liberty.
Assuming we get agreement from Lance, I can make that change. Both the 10.0.x and the tckrefactor branches?
For the record, both Decimal_Tab (for test 177) and Numeric_Tab (for test 179) need to be updated, but this does seem to work for me with Open Liberty.
Assuming we get agreement from Lance, I can make that change. Both the 10.0.x and the tckrefactor branches?
@brideck
I think it is a Platform concern to deal with at this point based on the feedback that we have already received. Please do create (10.0.x
+ tckrefactor
) pull requests when you have time for changing to 9999999999
(e.g. 9,999,999,999) to address this issue. I think that we will soon have other 10.0.x
updates for Java 21 for the jstl
tests so would be good to release a new EE 10 platform tck service release that addresses as many of these Java 21 problems as possible, including this TCK challenge. Thank you!
@brideck I'll create a pull request for the JDBC change.
This will be closed when an EE 10 Platform TCK release contains the merged fix.
https://issues.redhat.com/browse/WFLY-18896 reported the following TCK test failures:
Which led to issue https://issues.apache.org/jira/browse/DERBY-7160 to be opened and https://wildfly.zulipchat.com/#narrow/stream/174184-wildfly-developers/topic/Pass.20Platform.20TCK.20jdbc.2Eee.2EcallStmt.20tests.20on.20Java.2021 chat discussion in which Ladislav Thon pointed to the https://bugs.openjdk.org/browse/JDK-4511638 issue that was fixed for Java 19 which looks like the likely change.
Echoing discussion from https://issues.apache.org/jira/browse/DERBY-7160: