MariaDB [test]> show status like "columnstore%";
|
+-------------------------+----------+
|
| Variable_name | Value |
|
+-------------------------+----------+
|
| Columnstore_commit_hash | 69255538 |
|
| Columnstore_version | 1.4.4 |
|
+-------------------------+----------+
|
2 rows in set (0.002 sec)
|
|
MariaDB [test]> 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.001 sec)
|
|
MariaDB [test]> select * from t1;
|
Empty set (0.014 sec)
|
|
MariaDB [test]> select * from t1;
|
Empty set (0.012 sec)
|
|
MariaDB [test]> 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.001 sec)
|
|
MariaDB [test]> 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.001 sec)
|
|
MariaDB [test]> 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.001 sec)
|
|
MariaDB [test]> select * from t1;
|
Empty set (0.012 sec)
|
|
MariaDB [test]> show create table t1;
|
+-------+--------------------------------------------------------------------------------------------------------------------+
|
| Table | Create Table |
|
+-------+--------------------------------------------------------------------------------------------------------------------+
|
| t1 | CREATE TABLE `t1` (
|
`a` int(11) NOT NULL,
|
`b` varchar(10) NOT NULL
|
) ENGINE=Columnstore DEFAULT CHARSET=latin1 |
|
+-------+--------------------------------------------------------------------------------------------------------------------+
|
1 row in set (0.000 sec)
|