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

Be able to filter system tables and views

Details

    Description

      To list the tables and views offered by a connection, LibreOffice and / or OpenOffice Base uses the method DatabaseMetaData.getTables().

      This method offers a fourth parameter that allows you to filter the tables according to their type.
      The documentation says about it: a list of table types, which must be from the list of table types returned from getTableTypes(),to include; null returns all types.

      The values returned by the getTableTypes() method are not precise enough (or numerous) to be able to filter the system tables and views (tables and views contained in information_schema, mysql, performance_schema and sys) from the tables and views of the user.

      This does not allow to list or not the system tables and views to the user, according to his choice, in the graphic interface of LibreOffice / OpenOffice Base.

      Attachments

        Issue Links

          is caused by

          Bug - A problem which impairs or prevents the functions of the product. MDEV-33910 Tables residing in catalogs mysql, performance_schema and sys are not SYSTEM TABLE

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

          New Feature - A new feature of the product, which has yet to be developed. CONJ-1172 Tables residing in catalogs mysql, performance_schema and sys are not SYSTEM TABLE

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

          Activity

            Ascending order - Click to sort in descending order
            prrvchr prrvchr created issue -
            prrvchr prrvchr added a comment - - edited

            It turns out that all the views contained in the information_schema catalog are easily filterable since they are all of the type: SYSTEM VIEW
            So I well able to display or not the information_schema catalog. I updated the extension jdbcDriverOOo to fix this error.

            So I'm not sure that the sys, mysql and performance_schema catalogs should be considered as system tables or views?

            prrvchr prrvchr added a comment - - edited It turns out that all the views contained in the information_schema catalog are easily filterable since they are all of the type: SYSTEM VIEW So I well able to display or not the information_schema catalog. I updated the extension jdbcDriverOOo to fix this error. So I'm not sure that the sys , mysql and performance_schema catalogs should be considered as system tables or views?
            diego dupin Diego Dupin made changes -
            Field Original Value New Value
            diego dupin Diego Dupin made changes -
            diego dupin Diego Dupin made changes -
            Fix Version/s 3.4.0 [ 29821 ]
            diego dupin Diego Dupin added a comment -

            MDEV-33910 is created, in order to solve that server side, but a connector will handle sys, mysql and performance_schema as system tables/views

            diego dupin Diego Dupin added a comment - MDEV-33910 is created, in order to solve that server side, but a connector will handle sys, mysql and performance_schema as system tables/views
            diego dupin Diego Dupin made changes -
            Resolution Fixed [ 1 ]
            Status Open [ 1 ] Closed [ 6 ]
            diego dupin Diego Dupin made changes -
            Issue Type New Feature [ 2 ] Bug [ 1 ]

            People

              diego dupin Diego Dupin
              prrvchr prrvchr
              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.