*** empty log message ***
[csql.git] / test / tools / csqldump / exp.test006.ksh
blob0e3939d82c0976623ed4549e928154369e11a61e
1 CREATE TABLE t1 (f1 INT NOT NULL , f2 INT DEFAULT '10' );
2 CREATE INDEX indx1 on t1 ( f1 ) HASH ;
3 CREATE INDEX indx2 on t1 ( f2 ) HASH ;
4 INSERT INTO t1 VALUES(131,10);
5 INSERT INTO t1 VALUES(141,10);
6 INSERT INTO t1 VALUES(13,41);
7 INSERT INTO t1 VALUES(143,41);
8 INSERT INTO t1 VALUES(153,41);
9 INSERT INTO t1 VALUES(163,41);
10 INSERT INTO t1 VALUES(151,10);
11 INSERT INTO t1 VALUES(1631,10);
12 INSERT INTO t1 VALUES(163,41);
13 INSERT INTO t1 VALUES(13,41);
14 INSERT INTO t1 VALUES(23,41);
15 INSERT INTO t1 VALUES(551,10);
16 INSERT INTO t1 VALUES(631,10);
17 INSERT INTO t1 VALUES(43,41);
18 INSERT INTO t1 VALUES(3,41);
19 INSERT INTO t1 VALUES(3,41);
20 INSERT INTO t1 VALUES(33,41);
21 INSERT INTO t1 VALUES(31,10);
22 INSERT INTO t1 VALUES(31,10);
23 INSERT INTO t1 VALUES(4,41);
24 INSERT INTO t1 VALUES(31,10);
25 INSERT INTO t1 VALUES(31,10);
26 INSERT INTO t1 VALUES(31,10);
27 INSERT INTO t1 VALUES(31,10);
28 INSERT INTO t1 VALUES(31,10);
29 INSERT INTO t1 VALUES(41,10);
30 INSERT INTO t1 VALUES(3,41);
31 INSERT INTO t1 VALUES(43,41);
32 INSERT INTO t1 VALUES(53,41);
33 INSERT INTO t1 VALUES(63,41);
34 INSERT INTO t1 VALUES(51,10);
35 INSERT INTO t1 VALUES(631,10);
36 INSERT INTO t1 VALUES(63,41);
37 INSERT INTO t1 VALUES(3,41);
38 INSERT INTO t1 VALUES(3,41);
39 INSERT INTO t1 VALUES(51,10);
40 INSERT INTO t1 VALUES(631,10);
41 INSERT INTO t1 VALUES(3,41);
42 INSERT INTO t1 VALUES(3,41);
43 INSERT INTO t1 VALUES(3,41);
44 INSERT INTO t1 VALUES(3,41);
45 INSERT INTO t1 VALUES(31,10);
46 INSERT INTO t1 VALUES(31,10);
47 INSERT INTO t1 VALUES(4,41);
48 INSERT INTO t1 VALUES(41,10);
49 INSERT INTO t1 VALUES(3,41);
50 INSERT INTO t1 VALUES(43,41);
51 INSERT INTO t1 VALUES(53,41);
52 INSERT INTO t1 VALUES(63,41);
53 INSERT INTO t1 VALUES(51,10);
54 INSERT INTO t1 VALUES(631,10);
55 INSERT INTO t1 VALUES(63,41);
56 INSERT INTO t1 VALUES(3,41);
57 INSERT INTO t1 VALUES(3,41);
58 INSERT INTO t1 VALUES(51,10);
59 INSERT INTO t1 VALUES(631,10);
60 INSERT INTO t1 VALUES(3,41);
61 INSERT INTO t1 VALUES(3,41);
62 INSERT INTO t1 VALUES(3,41);
63 INSERT INTO t1 VALUES(3,41);
64 INSERT INTO t1 VALUES(31,10);
65 INSERT INTO t1 VALUES(31,10);
66 INSERT INTO t1 VALUES(4,41);
67 INSERT INTO t1 VALUES(41,10);
68 INSERT INTO t1 VALUES(3,41);
69 INSERT INTO t1 VALUES(43,41);
70 INSERT INTO t1 VALUES(53,41);
71 INSERT INTO t1 VALUES(63,41);
72 INSERT INTO t1 VALUES(51,10);
73 INSERT INTO t1 VALUES(631,10);
74 INSERT INTO t1 VALUES(63,41);
75 INSERT INTO t1 VALUES(3,41);
76 INSERT INTO t1 VALUES(3,41);
77 INSERT INTO t1 VALUES(51,10);
78 INSERT INTO t1 VALUES(631,10);
79 INSERT INTO t1 VALUES(3,41);
80 INSERT INTO t1 VALUES(3,41);
81 INSERT INTO t1 VALUES(3,41);
82 INSERT INTO t1 VALUES(3,41);
83 INSERT INTO t1 VALUES(31,10);
84 INSERT INTO t1 VALUES(31,10);
85 INSERT INTO t1 VALUES(4,41);
86 INSERT INTO t1 VALUES(3,41);
87 INSERT INTO t1 VALUES(43,41);
88 INSERT INTO t1 VALUES(53,41);
89 INSERT INTO t1 VALUES(63,41);
90 INSERT INTO t1 VALUES(51,10);
91 INSERT INTO t1 VALUES(631,10);
92 INSERT INTO t1 VALUES(63,41);
93 INSERT INTO t1 VALUES(3,41);
94 INSERT INTO t1 VALUES(3,41);
95 INSERT INTO t1 VALUES(51,10);
96 INSERT INTO t1 VALUES(6317,10);
97 INSERT INTO t1 VALUES(3,41);
98 INSERT INTO t1 VALUES(3,413);
99 INSERT INTO t1 VALUES(3,431);
100 INSERT INTO t1 VALUES(3,941);
101 INSERT INTO t1 VALUES(631,10);
102 INSERT INTO t1 VALUES(431,10);
103 INSERT INTO t1 VALUES(14,41);