Uploaded image for project: 'MariaDB Connector/J'
  1. MariaDB Connector/J
  2. CONJ-55

DBMeta stores*QuotedIdentifiers returns inconsistent values between MariaDB and MySQL JDBC drivers.

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 1.1.3
    • Fix Version/s: 1.1.4
    • Component/s: None
    • Labels:
      None
    • Environment:
      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

            People

            • Assignee:
              wlad Vladislav Vaintroub
              Reporter:
              fyrewyld Jody Grassel
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: