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

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Fixed
    • 1.1.3
    • 1.1.4
    • 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

          fyrewyld Jody Grassel created issue -
          wlad Vladislav Vaintroub made changes -
          Field Original Value New Value
          Assignee Rasmus Johansson [ ratzpo ] Vladislav Vaintroub [ wlad ]
          fyrewyld Jody Grassel made changes -
          Environment Server-Linux, Client-MacOS
          wlad Vladislav Vaintroub made changes -
          Fix Version/s jdbc-1.1.4 [ 13400 ]
          Resolution Fixed [ 1 ]
          Status Open [ 1 ] Closed [ 6 ]
          ratzpo Rasmus Johansson (Inactive) made changes -
          Workflow defaullt [ 27904 ] MariaDB v2 [ 47884 ]
          ratzpo Rasmus Johansson (Inactive) made changes -
          Workflow MariaDB v2 [ 47884 ] MariaDB connectors [ 54955 ]
          ratzpo Rasmus Johansson (Inactive) made changes -
          Workflow MariaDB connectors [ 54955 ] MariaDB v3 [ 70215 ]
          serg Sergei Golubchik made changes -
          Workflow MariaDB v3 [ 70215 ] MariaDB v4 [ 134688 ]

          People

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

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.