|
|
Output
|
MariaDB [test]> create table t1 (i int, j int) partition by list columns(i,j) (partition p1 values in ((10,10)), partition p2 default);
|
Query OK, 0 rows affected (0.65 sec)
|
|
MariaDB [test]> insert into t1 values (10,1);
|
Query OK, 1 row affected (0.06 sec)
|
|
MariaDB [test]> select * from t1 where i = 10;
|
Empty set (0.00 sec)
|
MariaDB [test]> explain partitions select * from t1 where i = 10;
|
+------+-------------+-------+------------+------+---------------+------+---------+------+------+-------------+
|
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | Extra |
|
+------+-------------+-------+------------+------+---------------+------+---------+------+------+-------------+
|
| 1 | SIMPLE | t1 | p1 | ALL | NULL | NULL | NULL | NULL | 2 | Using where |
|
+------+-------------+-------+------------+------+---------------+------+---------+------+------+-------------+
|
1 row in set (0.00 sec)
|
|
Test case
|
drop table if exists t1;
|
create table t1 (i int, j int) partition by list columns(i,j) (partition p1 values in ((10,10)), partition p2 default);
|
insert into t1 values (10,1);
|
select * from t1 where i = 10;
|
|