adding test scripts
[csql.git] / test / tools / csqldump / exp.test003.ksh
blob4c712bf0522fbc435659062fd67491d1a565248f
1 CREATE TABLE t1 (f1 INT NOT NULL , f2 CHAR (32));
2 CREATE INDEX t1_idx1_Primary on t1 ( f1 ) HASH UNIQUE;
3 SET AUTOCOMMIT OFF;
4 INSERT INTO t1 VALUES(123, 'india');
5 INSERT INTO t1 VALUES(72, 'Lakshya72');
6 INSERT INTO t1 VALUES(73, 'Lakshya73');
7 INSERT INTO t1 VALUES(74, 'Lakshya74');
8 INSERT INTO t1 VALUES(456, 'Lakshya75');
9 INSERT INTO t1 VALUES(76, 'Lakshya76');
10 INSERT INTO t1 VALUES(77, 'Lakshya77');
11 INSERT INTO t1 VALUES(78, 'Lakshya78');
12 INSERT INTO t1 VALUES(79, 'Lakshya79');
13 INSERT INTO t1 VALUES(80, 'Lakshya80');
14 INSERT INTO t1 VALUES(81, 'Lakshya81');
15 INSERT INTO t1 VALUES(82, 'Lakshya82');
16 INSERT INTO t1 VALUES(40, 'Lakshya40');
17 INSERT INTO t1 VALUES(41, 'Lakshya41');
18 INSERT INTO t1 VALUES(42, 'Lakshya42');
19 INSERT INTO t1 VALUES(43, 'Lakshya43');
20 INSERT INTO t1 VALUES(44, 'Lakshya44');
21 INSERT INTO t1 VALUES(45, 'Lakshya45');
22 INSERT INTO t1 VALUES(46, 'Lakshya46');
23 INSERT INTO t1 VALUES(47, 'Lakshya47');
24 COMMIT;
25 INSERT INTO t1 VALUES(18, 'Lakshya18');
26 INSERT INTO t1 VALUES(555, 'Malaysia63');
27 INSERT INTO t1 VALUES(64, 'Lakshya64');
28 INSERT INTO t1 VALUES(65, 'Lakshya65');
29 INSERT INTO t1 VALUES(66, 'Lakshya66');
30 INSERT INTO t1 VALUES(67, 'Lakshya67');
31 INSERT INTO t1 VALUES(68, 'Lakshya68');
32 INSERT INTO t1 VALUES(19, 'Lakshya19');
33 INSERT INTO t1 VALUES(823, 'Lakshya83');
34 INSERT INTO t1 VALUES(84, 'Lakshya84');
35 INSERT INTO t1 VALUES(85, 'Lakshya85');
36 INSERT INTO t1 VALUES(11, 'Lakshya11');
37 INSERT INTO t1 VALUES(12, 'Lakshya12');
38 INSERT INTO t1 VALUES(13, 'Lakshya13');
39 INSERT INTO t1 VALUES(14, 'Lakshya14');
40 INSERT INTO t1 VALUES(15, 'Lakshya15');
41 INSERT INTO t1 VALUES(16, 'Lakshya16');
42 INSERT INTO t1 VALUES(17, 'Lakshya17');
43 INSERT INTO t1 VALUES(530, 'Lakshya30');
44 INSERT INTO t1 VALUES(31, 'Lakshya31');
45 COMMIT;
46 INSERT INTO t1 VALUES(32, 'Lakshya32');
47 INSERT INTO t1 VALUES(33, 'Lakshya33');
48 INSERT INTO t1 VALUES(34, 'Lakshya34');
49 INSERT INTO t1 VALUES(35, 'Lakshya35');
50 INSERT INTO t1 VALUES(36, 'Pakistan');
51 INSERT INTO t1 VALUES(37, 'Lakshya37');
52 INSERT INTO t1 VALUES(777, 'Lakshya38');
53 INSERT INTO t1 VALUES(39, 'Lakshya39');
54 INSERT INTO t1 VALUES(20, 'Lakshya20');
55 INSERT INTO t1 VALUES(21, 'Lakshya21');
56 INSERT INTO t1 VALUES(22, 'Lakshya22');
57 INSERT INTO t1 VALUES(23, 'Lakshya23');
58 INSERT INTO t1 VALUES(24, 'Lakshya24');
59 INSERT INTO t1 VALUES(25, 'Lakshya25');
60 INSERT INTO t1 VALUES(26, 'Lakshya26');
61 INSERT INTO t1 VALUES(27, 'Lakshya27');
62 INSERT INTO t1 VALUES(28, 'Lakshya28');
63 INSERT INTO t1 VALUES(29, 'Lakshya29');
64 INSERT INTO t1 VALUES(48, 'Lakshya48');
65 INSERT INTO t1 VALUES(49, 'Lakshya49');
66 COMMIT;
67 INSERT INTO t1 VALUES(50, 'Lakshya50');
68 INSERT INTO t1 VALUES(51, 'Lakshya51');
69 INSERT INTO t1 VALUES(142, 'Lakshya52');
70 INSERT INTO t1 VALUES(53, 'Lakshya53');
71 INSERT INTO t1 VALUES(54, 'Lakshya54');
72 INSERT INTO t1 VALUES(55, 'Lakshya55');
73 INSERT INTO t1 VALUES(56, 'Lakshya56');
74 INSERT INTO t1 VALUES(90, 'Lakshya90');
75 INSERT INTO t1 VALUES(91, 'Lakshya91');
76 INSERT INTO t1 VALUES(92, 'Lakshya92');
77 INSERT INTO t1 VALUES(93, 'Lakshya93');
78 INSERT INTO t1 VALUES(94, 'Lakshya94');
79 INSERT INTO t1 VALUES(95, 'Lakshya95');
80 INSERT INTO t1 VALUES(96, 'Lakshya96');
81 INSERT INTO t1 VALUES(97, 'Lakshya97');
82 INSERT INTO t1 VALUES(98, 'Lakshya98');
83 INSERT INTO t1 VALUES(99, 'Lakshya99');
84 INSERT INTO t1 VALUES(100, 'Lakshya100');
85 INSERT INTO t1 VALUES(1, 'Lakshya1');
86 INSERT INTO t1 VALUES(2, 'Lakshya2');
87 COMMIT;
88 INSERT INTO t1 VALUES(3, 'Lakshya3');
89 INSERT INTO t1 VALUES(4, 'Lakshya4');
90 INSERT INTO t1 VALUES(5, 'Lakshya5');
91 INSERT INTO t1 VALUES(6, 'Lakshya6');
92 INSERT INTO t1 VALUES(7, 'Lakshya7');
93 INSERT INTO t1 VALUES(8, 'Lakshya8');
94 INSERT INTO t1 VALUES(9, 'Lakshya9');
95 INSERT INTO t1 VALUES(10, 'Lakshya10');
96 INSERT INTO t1 VALUES(57, 'Lakshya57');
97 INSERT INTO t1 VALUES(58, 'Lakshya58');
98 INSERT INTO t1 VALUES(59, 'Lakshya59');
99 INSERT INTO t1 VALUES(60, 'Lakshya60');
100 INSERT INTO t1 VALUES(61, 'Lakshya61');
101 INSERT INTO t1 VALUES(62, 'Lakshya62');
102 INSERT INTO t1 VALUES(69, 'Lakshya69');
103 INSERT INTO t1 VALUES(70, 'Lakshya70');
104 INSERT INTO t1 VALUES(86, 'Lakshya86');
105 INSERT INTO t1 VALUES(87, 'Lakshya87');
106 INSERT INTO t1 VALUES(88, 'Lakshya88');
107 INSERT INTO t1 VALUES(89, 'Lakshya89');
108 COMMIT;