github.com/pingcap/tiflow@v0.0.0-20240520035814-5bf52d54e205/tests/integration_tests/tidb_mysql_test/r/mysql_replace.result (about)

     1  drop table if exists t1;
     2  CREATE TABLE t1 (
     3  gesuchnr int(11) DEFAULT '0' NOT NULL,
     4  benutzer_id int(11) DEFAULT '0' NOT NULL,
     5  PRIMARY KEY (gesuchnr,benutzer_id)
     6  );
     7  replace into t1 (gesuchnr,benutzer_id) values (2,1);
     8  replace into t1 (gesuchnr,benutzer_id) values (1,1);
     9  replace into t1 (gesuchnr,benutzer_id) values (1,1);
    10  alter table t1 engine=heap;
    11  replace into t1 (gesuchnr,benutzer_id) values (1,1);
    12  SET sql_mode = 'NO_ENGINE_SUBSTITUTION';
    13  create table t2 (a tinyint not null auto_increment primary key, b char(20) default "default_value");
    14  insert into t2 values (126,"first"),(63, "middle"),(0,"last");
    15  insert into t2 values (0,"error");
    16  Error 1467: Failed to read auto-increment value from storage engine
    17  replace into t2 values (0,"last updated");
    18  Error 1467: Failed to read auto-increment value from storage engine
    19  replace into t2 values (126,"first updated");
    20  replace into t2 values (63,default);
    21  select * from t2;
    22  a	b
    23  63	default_value
    24  126	first updated
    25  127	last
    26  SET sql_mode = default;