adding test scripts
[csql.git] / test / cache / Recovery / exp.test003.ksh
blobe14e833a54e65d276e8960d212f8866be8f52506
1 CREATE TABLE t1 (f1 INT NOT NULL , f2 INT );
2 CREATE INDEX t1_PRIMARY on t1 ( f1 ) HASH UNIQUE SIZE 10007 ;
3 CREATE INDEX t1_idx2 on t1 ( f2 ) HASH SIZE 10007 ;
4 INSERT INTO t1 VALUES(1,11);
5 INSERT INTO t1 VALUES(2,21);
6 INSERT INTO t1 VALUES(3,31);
7 INSERT INTO t1 VALUES(4,41);
8 INSERT INTO t1 VALUES(5,51);
9 INSERT INTO t1 VALUES(6,61);
10 INSERT INTO t1 VALUES(7,71);
11 INSERT INTO t1 VALUES(8,81);
12 INSERT INTO t1 VALUES(9,91);
13 INSERT INTO t1 VALUES(10,101);