Inline strategy cannot support range sharding

[ghost]

sharding-jdbc version 4.0.0

sql select * from t_account where f_type = 1 and f_id >= 10000 and f_code in ("500","604","685") group by f_code;

An exception occurred during the query.

[ghost]

Please help me solve this problem, thank you

[KomachiSion]

What's your sharding configuration?

BTW, Inline strategy only support = and in condition for sharding column. If you want to use range sharding, you should use standard strategy.

More detail see documents

[ghost]

config:
shardingColumn: f_id

If you have a query for the range of columns in a separate table, how will it be configured, such as f_id>= XXX

[KomachiSion]

You should code a RangeShardingAlgorithm and configure it as your range algorithm.

example like : https://github.com/apache/incubator-shardingsphere-example/tree/dev/sharding-jdbc-example/sharding-example/sharding-raw-jdbc-example

use sharding-databases-range.yaml

[terrymanu]

No, Inline strategy cannot support range sharding.
More details please reference document and example

[kimmking]

@succeo you can use latest version and turn on this feature like this in server.yaml:

allow.range.query.with.inline.sharding: true

[lishuo5263]

@succeo you can use latest version and turn on this feature like this in server.yaml:

allow.range.query.with.inline.sharding: true

hi, KimmKing, I got same question, I fllow your way to try execute this sql (SELECT * FROM t_order WHERE order_id BETWEEN ? AND ?)

and result is :

Cause: java.lang.IllegalStateException: Inline strategy cannot support this type sharding:RangeRouteValue(columnName=order_id, tableName=t_order, valueRange=[472417022777995264‥482417022777995264])] with root cause

java.lang.IllegalStateException: Inline strategy cannot support this type sharding:RangeRouteValue(columnName=order_id, tableName=t_order, valueRange=[472417022777995264‥482417022777995264])

by the way ,my sharding-shpere jar version update to 4.1.0, How can i fix this problem ?