How to optimize the sql of select something in (X,X,X)

[13533307446]

For version 4.1.1, shardingsphere not implements the optimizing sql of "SELECT * FROM t_order WHERE order_id IN (1, 2, 3);".
How to do it? I want to optimize that sql to
"SELECT * FROM t_order WHERE order_id IN (1, 3);"
"SELECT * FROM t_order WHERE order_id IN (2);".

Have any suggests or references?

[tristaZero]

Hello, @13533307446 Could you consider using 5.0.0 release fixing this issue?

@strongduanmu Which version of 4.x series do we have this one?

[strongduanmu]

Hi @13533307446 @tristaZero, First of all, it is not a bug that the predicate of the sharding table is not rewritten. Because when the data is inserted, it will be routed according to the shard column, and then the data will be stored on different nodes. Even if the predicate is not rewritten during the query, the result can be guaranteed to be correct.

If we want to achieve this feature, we need to add a PredicateTokenGenerator to handle the rewriting of the predicate. But rewriting also has a certain performance consumption, I am not sure if this is an optimization worth doing.