MariaDB [test]> create table c1 (a int, b int, c int)engine=columnstore;
|
Query OK, 0 rows affected (0.734 sec)
|
|
MariaDB [test]> insert into c1 values (1, 2, 3), (4, 5, 6);
|
Query OK, 2 rows affected (0.236 sec)
|
Records: 2 Duplicates: 0 Warnings: 0
|
|
MariaDB [test]> select calshowpartitions('c1', 'a');
|
+--------------------------------------------------------------------------------------------------------------------------------------------------------------+
|
| calshowpartitions('c1', 'a') |
|
+--------------------------------------------------------------------------------------------------------------------------------------------------------------+
|
| Part# Min Max Status
|
0.0.1 N/A N/A Enabled |
|
+--------------------------------------------------------------------------------------------------------------------------------------------------------------+
|
1 row in set (0.016 sec)
|
|
MariaDB [test]> select calshowpartitions('c1', 'b');
|
+--------------------------------------------------------------------------------------------------------------------------------------------------------------+
|
| calshowpartitions('c1', 'b') |
|
+--------------------------------------------------------------------------------------------------------------------------------------------------------------+
|
| Part# Min Max Status
|
0.0.1 N/A N/A Enabled |
|
+--------------------------------------------------------------------------------------------------------------------------------------------------------------+
|
1 row in set (0.016 sec)
|
|
MariaDB [test]> select calshowpartitions('c1', 'c');
|
+--------------------------------------------------------------------------------------------------------------------------------------------------------------+
|
| calshowpartitions('c1', 'c') |
|
+--------------------------------------------------------------------------------------------------------------------------------------------------------------+
|
| Part# Min Max Status
|
0.0.1 N/A N/A Enabled |
|
+--------------------------------------------------------------------------------------------------------------------------------------------------------------+
|
1 row in set (0.012 sec)
|
|
MariaDB [test]> select a, b from c1 where c < 5;
|
+------+------+
|
| a | b |
|
+------+------+
|
| 1 | 2 |
|
+------+------+
|
1 row in set (0.038 sec)
|
|
MariaDB [test]> select calshowpartitions('c1', 'a');
|
+--------------------------------------------------------------------------------------------------------------------------------------------------------------+
|
| calshowpartitions('c1', 'a') |
|
+--------------------------------------------------------------------------------------------------------------------------------------------------------------+
|
| Part# Min Max Status
|
0.0.1 N/A N/A Enabled |
|
+--------------------------------------------------------------------------------------------------------------------------------------------------------------+
|
1 row in set (0.002 sec)
|
|
MariaDB [test]> select calshowpartitions('c1', 'b');
|
+--------------------------------------------------------------------------------------------------------------------------------------------------------------+
|
| calshowpartitions('c1', 'b') |
|
+--------------------------------------------------------------------------------------------------------------------------------------------------------------+
|
| Part# Min Max Status
|
0.0.1 N/A N/A Enabled |
|
+--------------------------------------------------------------------------------------------------------------------------------------------------------------+
|
1 row in set (0.001 sec)
|
|
MariaDB [test]> select calshowpartitions('c1', 'c');
|
+--------------------------------------------------------------------------------------------------------------------------------------------------------------+
|
| calshowpartitions('c1', 'c') |
|
+--------------------------------------------------------------------------------------------------------------------------------------------------------------+
|
| Part# Min Max Status
|
0.0.1 3 6 Enabled |
|
+--------------------------------------------------------------------------------------------------------------------------------------------------------------+
|
1 row in set (0.001 sec)
|
|