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:
None 
Category:Connector / J Severity:S3 (Non-critical)
Version:8.0.12 OS:Any
Assigned to: CPU Architecture:Any

[5 Sep 2018 14:46] fea Feature
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
[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.