OceanBase 数据库 V3.x 版本中全局索引回表不保证记录顺序与索引一致

CREATE TABLE `tb_xx` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `gmt_create` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `gmt_modified` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ONUPDATECURRENT_TIMESTAMP COMMENT '修改时间',
    `data_version` bigint(20) NOT NULL DEFAULT '0' COMMENT '数据版本',
    `is_delete` tinyint(4) NOT NULL DEFAULT '0' COMMENT '是否删除，0-否，1-是',
    `promise_id` varchar(64) NOT NULL COMMENT '履约id',
    `order_id` varchar(64) NOT NULL COMMENT '订单id',
    `consumer_id` varchar(64) NOT NULL COMMENT '主体id，比如店铺id',
    `sku_id` varchar(64) NOT NULL COMMENT '产品skuId',
    `spu_id` varchar(64) NOT NULL COMMENT '产品spuId',
    `buy_id` varchar(64) NOT NULL COMMENT '购买人id:比如店铺ownerId，amap_uid',
    `is_reverse` int(10) NOT NULL DEFAULT '1' COMMENT '1:正向；2:逆向',
    KEY `idx_gmt_modified` (`gmt_modified`) BLOCK_SIZE 16384 GLOBAL,
    KEY `uk_promise_id` (`promise_id`) BLOCK_SIZE 16384 LOCAL
) AUTO_INCREMENT = 2890001 DEFAULT CHARSET = utf8mb4 partition by key(promise_id)(
 partition p0,
  partition p1,
  partition p2,
  partition p3,
  ............
  partition p63);

MySQL > explain SELECT * FROM tb_xx WHERE 1=1 ORDER BY gmt_modified desc limit 0,10;

| Query Plan                                                  
| ==========================================================
|ID|OPERATOR                   |NAME    |EST. ROWS|COST  |
----------------------------------------------------------
|0 |LIMIT                      |        |10       |481641|
|1 | PX COORDINATOR MERGE SORT |        |10       |481641|
|2 |  EXCHANGE OUT DISTR       |:EX10000|10       |481627|
|3 |   LIMIT                   |        |10       |481627|
|4 |    TOP-N SORT             |        |10       |481627|
|5 |     PX PARTITION ITERATOR |        |875052   |346132|
|6 |      TABLE SCAN           |tb_xx   |875052   |346132|
==========================================================