-- Pre-Clean up

DROP TABLE if exists t;

CREATE TABLE `t` (

	`id` INT(10) NOT NULL AUTO_INCREMENT,

	`Source` CHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb3_bin',

	`SourceId` CHAR(10) NULL DEFAULT NULL COLLATE 'utf8mb3_bin',

	`DeleteStamp` DATETIME(3) NULL DEFAULT NULL,

	PRIMARY KEY (`id`) USING BTREE,

	INDEX `Full` (`SourceId`, `Source`, `DeleteStamp`) USING BTREE

)

COLLATE='utf8mb3_bin'

ENGINE=Aria

AUTO_INCREMENT=2537655

;

INSERT INTO t (SOURCE, sourceid) VALUES ('abcdefghijklmnopqrstuvxyzABCDEFGHIJKLMNO', '123456');

INSERT INTO t (SOURCE, sourceid) VALUES ('abcdefghijklmnopqrstuvxyzABCDEFGHIJKLMNO', '123456');

INSERT INTO t (SOURCE, sourceid) VALUES ('abcdefghijklmnopqrstuvxyzABCDEFGHIJKLMNO', '123456');

INSERT INTO t (SOURCE, sourceid) VALUES ('abcdefghijklmnopqrstuvxyzABCDEFGHIJKLMNO', '123456');

INSERT INTO t (SOURCE, sourceid) VALUES ('abcdefghijklmnopqrstuvxyzABCDEFGHIJKLMNO', '123456');

INSERT INTO t (SOURCE, sourceid) VALUES ('abcdefghijklmnopqrstuvxyzABCDEFGHIJKLMNO', '123456');

INSERT INTO t (SOURCE, sourceid) VALUES ('abcdefghijklmnopqrstuvxyzABCDEFGHIJKLMNO', '123456');

INSERT INTO t (SOURCE, sourceid) VALUES ('abcdefghijklmnopqrstuvxyzABCDEFGHIJKLMNO', '123456');

INSERT INTO t (SOURCE, sourceid) VALUES ('abcdefghijklmnopqrstuvxyzABCDEFGHIJKLMNO', '123456');

INSERT INTO t (SOURCE, sourceid) VALUES ('abcdefghijklmnopqrstuvxyzABCDEFGHIJKLMNO', '123456');

-- [ERROR] mysqld.exe: Got error '126 "Index is corrupted"' for '.\mydb\t.MAI'

UPDATE t SET DeleteStamp = NOW();

-- Clean up

DROP TABLE t;