WalterWj
(王军 - PingCAP)
17
(root@127.0.0.1) [test]>CREATE TABLE t1 (
-> id BIGINT PRIMARY KEY AUTO_INCREMENT,
-> name VARCHAR(32)
-> );
Query OK, 0 rows affected (0.07 sec)
(root@127.0.0.1) [test]>SPLIT TABLE t1 BETWEEN (0) AND (18446744073709551615) REGIONS 12;
ERROR 1690 (22003): constant 18446744073709551615 overflows bigint
(root@127.0.0.1) [test]>SPLIT TABLE t1 BETWEEN (0) AND (1844674) REGIONS 12;
+--------------------+----------------------+
| TOTAL_SPLIT_REGION | SCATTER_FINISH_RATIO |
+--------------------+----------------------+
| 11 | 1 |
+--------------------+----------------------+
1 row in set (1.14 sec)