github.com/matrixorigin/matrixone@v1.2.0/test/distributed/cases/prepare/prepare_autoincrement.result (about)

     1  drop table if exists t1;
     2  create table t1(
     3  a int auto_increment,
     4  b varchar(100)
     5  );
     6  set @a=1;
     7  set @b='a';
     8  prepare s1 from 'insert into t1 values (?,?)';
     9  execute s1 using @a,@b;
    10  select * from t1;
    11  a    b
    12  1    a
    13  deallocate prepare s1;
    14  prepare s2 from 'insert into t1 values ()';
    15  execute s2;
    16  select * from t1;
    17  a    b
    18  1    a
    19  2    null
    20  deallocate prepare s2;
    21  set @a=100;
    22  set @b='a=b';
    23  prepare s3 from 'insert into t1 values (?,?)';
    24  execute s3 using @a,@b;
    25  select * from t1;
    26  a    b
    27  1    a
    28  2    null
    29  100    a=b
    30  deallocate prepare s3;
    31  prepare s4 from 'insert into t1 values ()';
    32  execute s4;
    33  select * from t1;
    34  a    b
    35  1    a
    36  2    null
    37  100    a=b
    38  101    null
    39  deallocate prepare s4;