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

SELECT executed after EXPLAIN returns ER_INTERNAL_ERROR

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Fixed
    • 1.4.2
    • Icebox
    • PrimProc
    • None

    Description

      drop table if exists t1;
      create table t1 (a int) engine=Columnstore;
      explain select * from t1;
      select * from t1;
      

      MariaDB f93bfb9288d020b190f5c73a31223fff6439687d

      MariaDB [db]> drop table if exists t1;
      Query OK, 0 rows affected (0.403 sec)
       
      MariaDB [db]> create table t1 (a int) engine=Columnstore;
      Query OK, 0 rows affected (0.443 sec)
       
      MariaDB [db]> explain select * from t1;
      +------+---------------+-------+------+---------------+------+---------+------+------+-------+
      | id   | select_type   | table | type | possible_keys | key  | key_len | ref  | rows | Extra |
      +------+---------------+-------+------+---------------+------+---------+------+------+-------+
      |    1 | PUSHED SELECT | NULL  | NULL | NULL          | NULL | NULL    | NULL | NULL | NULL  |
      +------+---------------+-------+------+---------------+------+---------+------+------+-------+
      1 row in set (0.045 sec)
       
      MariaDB [db]> select * from t1;
      ERROR 1815 (HY000): Internal error: Unknown error
      

      Reproducible reliably for me on a local build from the indicated revision, on empty and non-empty tables.
      EXPLAIN can be replaced with ANALYZE or ANALYZE FORMAT=JSON without changing the outcome.
      Next SELECT returns the expected result.
      Columnstore support report is attached.

      Attachments

        Issue Links

          Activity

            People

              drrtuy Roman
              elenst Elena Stepanova
              Votes:
              1 Vote for this issue
              Watchers:
              7 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.