Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Fixed
-
1.1.3
-
None
-
None
-
Server-Linux, Client-MacOS
Description
Simple to reproduce:
DatabaseMetaData dbMeta = con.getMetaData();
System.out.println("dbMeta.storesMixedCaseQuotedIdentifiers() = " + dbMeta.storesMixedCaseQuotedIdentifiers());
System.out.println("dbMeta.storesUpperCaseQuotedIdentifiers() = " + dbMeta.storesUpperCaseQuotedIdentifiers());
System.out.println("dbMeta.storesLowerCaseQuotedIdentifiers() = " + dbMeta.storesLowerCaseQuotedIdentifiers());
But depending on the JDBC driver used, the results are different:
Talking to MariaDB with a MySQL 5.1.18 JDBC Driver:
dbMeta.storesMixedCaseQuotedIdentifiers() = true
dbMeta.storesUpperCaseQuotedIdentifiers() = true
dbMeta.storesLowerCaseQuotedIdentifiers() = false
Talking to MariaDB with the MariaDB 1.1.3 JDBC Driver:
dbMeta.storesMixedCaseQuotedIdentifiers() = false
dbMeta.storesUpperCaseQuotedIdentifiers() = true
dbMeta.storesLowerCaseQuotedIdentifiers() = false
Talking to MySQL with the MySQL JDBC Driver:
dbMeta.storesMixedCaseQuotedIdentifiers() = false
dbMeta.storesUpperCaseQuotedIdentifiers() = true
dbMeta.storesLowerCaseQuotedIdentifiers() = true
Talking to MySQL with the MariaDB JDBC Driver:
dbMeta.storesMixedCaseQuotedIdentifiers() = false
dbMeta.storesUpperCaseQuotedIdentifiers() = true
dbMeta.storesLowerCaseQuotedIdentifiers() = false
I would have expected the return results to be the same regardless which JDBC driver implementation was used.