Re: Partition pruning with composite partitioning keys
Andrii Nikitin Wrote:
-------------------------------------------------------
> Hm, did you try the same , but not quoting numeric
> values?
>
> where nodeid = 4 and cksumtype = 1;
No, but I have now. Same problem:
mysql> explain partitions select * from node_cksum where nodeid = 4 and cksumtype = 1;
+----+-------------+------------+---------------------------------------+------+---------------+---------+---------+-------------+---------+-------+
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | Extra |
+----+-------------+------------+---------------------------------------+------+---------------+---------+---------+-------------+---------+-------+
| 1 | SIMPLE | node_cksum | p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11 | ref | PRIMARY | PRIMARY | 8 | const,const | 1941944 | |
+----+-------------+------------+---------------------------------------+------+---------------+---------+---------+-------------+---------+-------+
1 row in set (0.07 sec)