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

MariaDbDatabaseMetaData wrong TABLE_TYPE values in getTables() method

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 1.3.0, 1.2.3
    • 1.4.5
    • Other
    • None

    Description

      the value of the ResultSet rowTABLE_TYPE is "BASE TABLE" instead of "TABLE".

      Attachments

        Issue Links

          causes

          Bug - A problem which impairs or prevents the functions of the product. CONJ-140 mariadb-java-client-1.1.8 shows no tables in OpenOffice Base

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. CONJ-390 getTableTypes() should be consistent with getTables()

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            diego dupin Diego Dupin added a comment -

            According to my reading of JDBC , possible table type values are listed by DatabaseMetaData.getTableTypes().
            The connector return the values

            • VIEW
            • SYSTEM VIEW
            • BASE TABLE

            so DatabaseMetaData.getTables()
            seems ok.
            I am missreading something ?

            diego dupin Diego Dupin added a comment - According to my reading of JDBC , possible table type values are listed by DatabaseMetaData.getTableTypes() . The connector return the values VIEW SYSTEM VIEW BASE TABLE so DatabaseMetaData.getTables() seems ok. I am missreading something ?
            dreab8 Andrea Boriero added a comment -

            by the Jdbc documentation
            TABLE_TYPE String => table type. Typical types are "TABLE", "VIEW", "SYSTEM TABLE", "GLOBAL TEMPORARY", "LOCAL TEMPORARY", "ALIAS", "SYNONYM".

            but not "BASE TABLE" as the connector returns.

            dreab8 Andrea Boriero added a comment - by the Jdbc documentation TABLE_TYPE String => table type. Typical types are " TABLE ", "VIEW", "SYSTEM TABLE", "GLOBAL TEMPORARY", "LOCAL TEMPORARY", "ALIAS", "SYNONYM". but not "BASE TABLE" as the connector returns.
            diego dupin Diego Dupin added a comment -

            Will be release in version 1.4.5 thanks to leonardlin.
            Commit: https://github.com/MariaDB/mariadb-connector-j/commit/747d265a55a92f2cc1124a8dfe5f94f830d6719b

            diego dupin Diego Dupin added a comment - Will be release in version 1.4.5 thanks to leonardlin. Commit: https://github.com/MariaDB/mariadb-connector-j/commit/747d265a55a92f2cc1124a8dfe5f94f830d6719b

            People

              diego dupin Diego Dupin
              dreab8 Andrea Boriero
              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.