2022-11-29 stonedb-主键索引-自增方式与INNODB不一致-追踪

摘要:

mysql列存储引擎-主键索引-追踪

关联ISSUE: https://github.com/stoneatom/stonedb/issues/988

DDL:

表结构:

DROP TABLE IF EXISTS t1;
CREATE TABLE t1 (
	id  VARCHAR(255) NOT NULL PRIMARY KEY,
	col VARCHAR(255) NOT NULL
);

CREATE TABLE t1 (id BIGINT NOT NULL PRIMARY KEY auto_increment, pad1 BLOB, pad2 BLOB, pad3 BLOB, int_col INT NOT NULL DEFAULT 0) ENGINE=TIANMU;

插入数据:

INSERT INTO t1 VALUES('1','100');
INSERT INTO t1 VALUES('2','100');