*** empty log message ***
[csql.git] / test / tools / csql / exp.test092.ksh
blob0f272c1e6742e012b21d201ab19d9439be6001a4
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
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
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