linghengqian commented on PR #29982: URL: https://github.com/apache/shardingsphere/pull/29982#issuecomment-1980427851
> - Using MySQL Server 8.0 creates new problems. > - Refer to https://github.com/apache/shardingsphere/actions/runs/8131265106/job/22220447080?pr=29982 . > ```shell > Error: 2024-03-03 15:47:18.332 [main] o.a.s.t.e2e.framework.E2EExtension - Error case: proxy: tbl -> MySQL -> Placeholder -> SELECT * FROM information_schema.innodb_sys_virtual limit 1, message: java.sql.SQLSyntaxErrorException: Unknown table 'INNODB_SYS_VIRTUAL' in information_schema > at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120) > > Error: 2024-03-03 15:47:18.362 [main] o.a.s.t.e2e.framework.E2EExtension - Error case: proxy: tbl -> MySQL -> Placeholder -> SELECT * FROM information_schema.innodb_trx limit 1, message: java.sql.SQLException: java.lang.ArrayIndexOutOfBoundsException: Index 24 out of bounds for length 24 > at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129) > > Error: 2024-03-03 15:47:18.556 [main] o.a.s.t.e2e.framework.E2EExtension - Error case: proxy: tbl -> MySQL -> Placeholder -> SELECT * FROM information_schema.statistics limit 1, message: java.sql.SQLException: java.lang.ArrayIndexOutOfBoundsException: Index 16 out of bounds for length 16 > ``` > - There is no easy way to dynamically specify the version of MySQL Server in a specific instance of E2E because the cases for these unit tests are executed in batches. The MySQL Server version can only be changed by setting a system property when executing a Maven command. - @FlyingZC What do you think of the current PR? -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
