github.com/matrixorigin/matrixone@v0.7.0/test/distributed/cases/prepare/prepare_autoincrement.sql (about)

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