MariaDB [test]> create table cs1 (a int, b int)engine=columnstore;
|
Query OK, 0 rows affected (0.449 sec)
|
|
MariaDB [test]> insert into cs1 values (1234, 1233);
|
Query OK, 1 row affected (0.165 sec)
|
|
MariaDB [test]> select calshowpartitions('cs1', 'a');
|
+--------------------------------------------------------------------------------------------------------------------------------------------------------------+
|
| calshowpartitions('cs1', 'a') |
|
+--------------------------------------------------------------------------------------------------------------------------------------------------------------+
|
| Part# Min Max Status
|
0.0.1 N/A N/A Enabled |
|
+--------------------------------------------------------------------------------------------------------------------------------------------------------------+
|
1 row in set (0.015 sec)
|
|
MariaDB [test]> select calshowpartitions('cs1', 'b');
|
+--------------------------------------------------------------------------------------------------------------------------------------------------------------+
|
| calshowpartitions('cs1', 'b') |
|
+--------------------------------------------------------------------------------------------------------------------------------------------------------------+
|
| Part# Min Max Status
|
0.0.1 N/A N/A Enabled |
|
+--------------------------------------------------------------------------------------------------------------------------------------------------------------+
|
1 row in set (0.018 sec)
|
|
MariaDB [test]> select a, b from cs1;
|
+------+------+
|
| a | b |
|
+------+------+
|
| 1234 | 1233 |
|
+------+------+
|
1 row in set, 1 warning (0.051 sec)
|
|
MariaDB [test]> select calshowpartitions('cs1', 'a');
|
+--------------------------------------------------------------------------------------------------------------------------------------------------------------+
|
| calshowpartitions('cs1', 'a') |
|
+--------------------------------------------------------------------------------------------------------------------------------------------------------------+
|
| Part# Min Max Status
|
0.0.1 1234 1234 Enabled |
|
+--------------------------------------------------------------------------------------------------------------------------------------------------------------+
|
1 row in set (0.001 sec)
|
|
MariaDB [test]> select calshowpartitions('cs1', 'b');
|
+--------------------------------------------------------------------------------------------------------------------------------------------------------------+
|
| calshowpartitions('cs1', 'b') |
|
+--------------------------------------------------------------------------------------------------------------------------------------------------------------+
|
| Part# Min Max Status
|
0.0.1 N/A N/A Enabled |
|
+--------------------------------------------------------------------------------------------------------------------------------------------------------------+
|
1 row in set (0.001 sec)
|
|
MariaDB [test]> select b, a from cs1;
|
+------+------+
|
| b | a |
|
+------+------+
|
| 1233 | 1234 |
|
+------+------+
|
1 row in set, 1 warning (0.010 sec)
|
|
MariaDB [test]> select calshowpartitions('cs1', 'b');
|
+--------------------------------------------------------------------------------------------------------------------------------------------------------------+
|
| calshowpartitions('cs1', 'b') |
|
+--------------------------------------------------------------------------------------------------------------------------------------------------------------+
|
| Part# Min Max Status
|
0.0.1 1233 1233 Enabled |
|
+--------------------------------------------------------------------------------------------------------------------------------------------------------------+
|
1 row in set (0.001 sec)
|
|
MariaDB [test]> select * from cs1 where a < b;
|
Empty set, 1 warning (0.011 sec)
|
|
MariaDB [test]> show warnings;
|
+-------+------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
|
| Level | Code | Message |
|
+-------+------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
|
| Note | 9999 | Query Stats: MaxMemPct-0; NumTempFiles-0; TempFileSpace-0B; ApproxPhyI/O-0; CacheI/O-2; BlocksTouched-2; PartitionBlocksEliminated-0; MsgBytesIn-110B; MsgBytesOut-654B; Mode-Distributed |
|
+-------+------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
|
1 row in set (0.000 sec)
|
|
MariaDB [test]> select calgettrace();
|
+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
|
| calgettrace() |
|
+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
|
|
|
Desc Mode Table TableOID ReferencedColumns PIO LIO PBE Elapsed Rows
|
BPS PM cs1 4040 (a,b) 0 2 0 0.002 0
|
TNS UM - - - - - - 0.000 0
|
|
|
+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
|
1 row in set (0.000 sec)
|