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.
Attachments
Activity
Field | Original Value | New Value |
---|---|---|
Assignee | Rasmus Johansson [ ratzpo ] | Vladislav Vaintroub [ wlad ] |
Environment | Server-Linux, Client-MacOS |
Fix Version/s | jdbc-1.1.4 [ 13400 ] | |
Resolution | Fixed [ 1 ] | |
Status | Open [ 1 ] | Closed [ 6 ] |
Workflow | defaullt [ 27904 ] | MariaDB v2 [ 47884 ] |
Workflow | MariaDB v2 [ 47884 ] | MariaDB connectors [ 54955 ] |
Workflow | MariaDB connectors [ 54955 ] | MariaDB v3 [ 70215 ] |
Workflow | MariaDB v3 [ 70215 ] | MariaDB v4 [ 134688 ] |