test/tools/csql/exp.test092.ksh

   1 echo create table t1(f1 int,f2 int auto_increment);
   2 Statement Executed
   3 echo insert into t1 values(12,NULL);
   4 Statement Executed: Rows Affected = 1
   5 echo insert into t1 (f1)values(12);
   6 Statement Executed: Rows Affected = 1
   7 echo insert into t1 values(12,232);
   8 Statement Executed: Rows Affected = 1
   9 echo select * from t1;
  10 ---------------------------------------------------------
  11         t1.f1   t1.f2
  12 ---------------------------------------------------------
  13         12      1
  14         12      2
  15         12      232
  16
  17 echo create table t2(f1 int,f2 int auto_increment);
  18 Statement Executed
  19 echo insert into t2 values(12,200);
  20 Statement Executed: Rows Affected = 1
  21 echo insert into t2 values(12,NULL);
  22 Statement Executed: Rows Affected = 1
  23 echo insert into t2 (f1) values(12);
  24 Statement Executed: Rows Affected = 1
  25 echo select * from t2;
  26 ---------------------------------------------------------
  27         t2.f1   t2.f2
  28 ---------------------------------------------------------
  29         12      200
  30         12      201
  31         12      202
  32
  33 echo drop table t1;
  34 Statement Executed
  35 echo drop table t2;
  36 Statement Executed
  37 echo create table t1(f1 int auto_increment, f2 int auto_increment);
  38 Statement prepare failed with error -19
  39 echo create table t1(f1 int , f2 char(10) auto_increment);
  40 Statement prepare failed with error -19