Router result is not accurate when condition is "between ... and "

[yanhuqing666]

for example:
now the router result is that:

mysql> explain select * from sharding_four_node where id between 0 and 2;
+-----------+----------+---------------------------------------------------------------------+
| DATA_NODE | TYPE     | SQL/REF                                                             |
+-----------+----------+---------------------------------------------------------------------+
| dn1       | BASE SQL | SELECT * FROM sharding_four_node WHERE id BETWEEN 0 AND 2 LIMIT 100 |
| dn2       | BASE SQL | SELECT * FROM sharding_four_node WHERE id BETWEEN 0 AND 2 LIMIT 100 |
| dn3       | BASE SQL | SELECT * FROM sharding_four_node WHERE id BETWEEN 0 AND 2 LIMIT 100 |
| dn4       | BASE SQL | SELECT * FROM sharding_four_node WHERE id BETWEEN 0 AND 2 LIMIT 100 |
+-----------+----------+---------------------------------------------------------------------+

but we expected is

+-----------+----------+---------------------------------------------------------------------+
| DATA_NODE | TYPE     | SQL/REF                                                             |
+-----------+----------+---------------------------------------------------------------------+
| dn1       | BASE SQL | SELECT * FROM sharding_four_node WHERE id BETWEEN 0 AND 2 LIMIT 100 |
| dn2       | BASE SQL | SELECT * FROM sharding_four_node WHERE id BETWEEN 0 AND 2 LIMIT 100 |
| dn3       | BASE SQL | SELECT * FROM sharding_four_node WHERE id BETWEEN 0 AND 2 LIMIT 100 |
+-----------+----------+---------------------------------------------------------------------+
3 rows in set (0.00 sec)

[yanhuqing666]

There is an special case in "test between begin and end" is that begin or end is an expression