TDSQL版本:8.0.24-v24-txsql-22.3.0-20230614
JDBC驱动版本:MySQL Connector/J 8.0.19
测试终端:Yunqu QueryX、DBeaver、MySQL命令行终端
测试表DDL:
CREATE TABLE `t_hash_range44` (
`id` bigint NOT NULL,
`price` bigint NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci shardkey=id PARTITION BY RANGE ( (price) ) ( PARTITION s1 VALUES LESS THAN (300), PARTITION s2 VALUES LESS THAN (8008))
表真实行数为 1302
测试用例:select count(*) from t_hash_range44
相似问题