| Bug #92296 | mysql-connector-java8.0.12 caused error | ||
|---|---|---|---|
| Submitted: | 5 Sep 2018 14:46 | Modified: | 7 Sep 2018 10:15 |
| Reporter: | fea Feature | Email Updates: | |
| Status: | Duplicate | Impact on me: | |
| Category: | Connector / J | Severity: | S3 (Non-critical) |
| Version: | 8.0.12 | OS: | Any |
| Assigned to: | CPU Architecture: | Any | |
[6 Sep 2018 7:59]
MySQL Verification Team
Hello! Thank you for the report! regards, Umesh
[7 Sep 2018 10:15]
Alexander Soklakov
This is a duplicate of Bug#90887.
Description: mysql-connector-java 8.0.12 class:com.mysql.cj.jdbc.DatabaseMetaDataUsingInfoSchema.java method:getTables(String catalog, String schemaPattern, String tableNamePattern, String[] types) throws SQLException line:803 code:sqlBuf.append("NULL AS REF_GENERATION FROM INFORMATION_SCHEMA.TABLES WHERE"); keyWord: WHERE i think if you are not agree to use this way (4 null parameter),you should throw an Exception like "not allowed null" will be better isn' it? Now : java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY TABLE_TYPE, TABLE_SCHEMA, TABLE_NAME' at line 1 How to repeat: invoking:getTables(null, null, null, null); there were no errors when using mysql-connector-java 5.X ,caused by mysql-connector-java 8.X