Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-1553

Filtering of rows (like, in , '>' etc.) does not work for information_schema

    XMLWordPrintable

Details

    Description

      A number of operators in where clause filtering do not work and return wrong results. For example:
      MariaDB [information_schema]> select table_schema, table_name, object_id, column_count from columnstore_tables where table_name in ('t1','t2');
      ---------------------------------------------+

      table_schema table_name object_id column_count

      ---------------------------------------------+

      test t1 24442 1

      ---------------------------------------------+
      1 row in set (0.04 sec)

      MariaDB [information_schema]> select table_schema, table_name, object_id, column_count from columnstore_tables where table_name in ('t2');
      ---------------------------------------------+

      table_schema table_name object_id column_count

      ---------------------------------------------+

      test t2 24446 2
      datos t2 25221 2

      ---------------------------------------------+
      2 rows in set (0.06 sec)

      MariaDB [information_schema]> select table_schema, table_name, object_id, column_count from columnstore_tables where table_name like 't%';
      Empty set (0.01 sec)
      MariaDB [information_schema]> select table_schema, table_name, object_id, column_count from columnstore_tables where table_schema > 't';
      Empty set (0.02 sec)

      This worked:
      MariaDB [information_schema]> select table_schema, table_name, object_id, column_count from columnstore_tables where table_name = 't1';
      ---------------------------------------------+

      table_schema table_name object_id column_count

      ---------------------------------------------+

      test t1 24442 1

      ---------------------------------------------+
      1 row in set (0.04 sec)

      This prevents one from developing "admin" scripts" to do analysis on objects in the database.

      Attachments

        Activity

          People

            Unassigned Unassigned
            rprakash Ravi Prakash (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            4 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.