Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Fixed
-
1.4.2
-
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
- relates to
-
MCOL-3766 EXPLAIN gives error every other try
- Closed