linghengqian commented on issue #27955: URL: https://github.com/apache/shardingsphere/issues/27955#issuecomment-1695559043
- @zhaojinchao95 Hi, I fixed this Example in https://github.com/linghengqian/shardingsphere-v540-readwrite-splitting-test/commit/a1203203db1d421452b8b465b58003224a936836 and confirmed that the key to issue is that jdbcUrl contains `DATABASE_TO_LOWER=TRUE`. - When the `jdbcUrl` of h2database does not contain `DATABASE_TO_LOWER=TRUE`, the class name involved in `algorithm-expression` is forced to be capitalized, otherwise column name matching fails when SQL is executed. So I did another test in https://github.com/linghengqian/shardingsphere-v540-readwrite-splitting-test/pull/1 and after adding `DATABASE_TO_LOWER=TRUE` to `jdbcUrl`, `NoSuchTableException` will reappear. - I don't seem to see any special handling of `DATABASE_TO_LOWER=TRUE` in the master branch, so I don't understand why this parameter causes ShardingSphere's Metadata to be broken. -- 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]
