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

For UUID column, the type name in metadata should not be CHAR

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Duplicate
    • 3.0.7
    • N/A
    • metadata
    • Server: Win2019 + mariadb-10.7.5-winx64, Client: MacOS + mariadb-java-client 3.0.7

    Description

      Consider the following code:

      SQL

      create table uuid_test (id uuid);
      

      Java

      var rs = stmt.executeQuery("select * from uuid_test");
      var md = rs.getMetaData();
      var s = md.getColumnTypeName(1) + ", " + md.getColumnType(1) + ", " + md.getColumnClassName(1);
      

      For MariaDB, the result of s is "CHAR, 1, java.lang.String".
      For PostgreSQL, the result of s is "uuid, 1111, java.util.UUID".

      The latter is more reasonable. For the former, we does not know it's a UUID column or a CHAR column with size = 36.

      Attachments

        Issue Links

          Activity

            People

              diego dupin Diego Dupin
              Minglei Minglei Lee
              Votes:
              0 Vote for this issue
              Watchers:
              2 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.