?  search:
summary | log | graphiclog1 | graphiclog2 | commit | commitdiff | tree | refs | edit | fork
blame | history | raw | HEAD
adding test scripts
[csql.git] / test / tools / TableGT32Field / exp.test001.ksh
blobb53840658c7d977c6dbdd6cd58283a90858288af
1 echo CREATE TABLE t1 (f1 INT , f2 INT , f3 INT , f4 INT , f5 INT , f6 INT , f7 INT , f8 INT , f9 INT , f10 INT , f11 INT , f12 INT , f13 INT , f14 INT , f15 INT , f16 INT , f17 INT , f18 INT , f19 INT , f20 INT , f21 INT , f22 INT , f23 INT , f24 INT , f25 INT , f26 INT , f27 INT , f28 INT , f29 INT , f30 INT , f31 INT , f32 INT , f33 INT , f34 INT , f35 INT , f36 INT , f37 INT );
2 Statement Executed
3 echo insert into t1 values(1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37);
4 Statement Executed: Rows Affected = 1
5 echo insert into t1 values(2,2,3,4,5,6,7,8,9,10,NULL,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37);
6 Statement Executed: Rows Affected = 1
7 echo insert into t1 values(3,2,3,4,5,6,7,8,9,10,11,NULL,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37);
8 Statement Executed: Rows Affected = 1
9 echo insert into t1 values(4,2,3,4,5,6,7,8,9,10,11,12,NULL,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37);
10 Statement Executed: Rows Affected = 1
11 echo insert into t1 values(5,2,3,4,5,6,7,8,9,10,11,12,13,NULL,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37);
12 Statement Executed: Rows Affected = 1
13 echo insert into t1 values(6,2,3,4,5,6,7,8,9,10,11,12,13,14,NULL,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37);
14 Statement Executed: Rows Affected = 1
15 echo select * from t1;
16 ---------------------------------------------------------
17 t1.f1 t1.f2 t1.f3 t1.f4 t1.f5 t1.f6 t1.f7 t1.f8 t1.f9 t1.f10 t1.f11 t1.f12 t1.f13 t1.f14 t1.f15 t1.f16 t1.f17 t1.f18 t1.f19 t1.f20 t1.f21 t1.f22 t1.f23 t1.f24 t1.f25 t1.f26 t1.f27 t1.f28 t1.f29 t1.f30 t1.f31 t1.f32 t1.f33 t1.f34 t1.f35 t1.f36 t1.f37
18 ---------------------------------------------------------
19 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37
20 2 2 3 4 5 6 7 8 9 10 NULL 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37
21 3 2 3 4 5 6 7 8 9 10 11 NULL 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37
22 4 2 3 4 5 6 7 8 9 10 11 12 NULL 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37
23 5 2 3 4 5 6 7 8 9 10 11 12 13 NULL 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37
24 6 2 3 4 5 6 7 8 9 10 11 12 13 14 NULL 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37
25
26 echo select * from t1 where f11 is NOT NULL;
27 ---------------------------------------------------------
28 t1.f1 t1.f2 t1.f3 t1.f4 t1.f5 t1.f6 t1.f7 t1.f8 t1.f9 t1.f10 t1.f11 t1.f12 t1.f13 t1.f14 t1.f15 t1.f16 t1.f17 t1.f18 t1.f19 t1.f20 t1.f21 t1.f22 t1.f23 t1.f24 t1.f25 t1.f26 t1.f27 t1.f28 t1.f29 t1.f30 t1.f31 t1.f32 t1.f33 t1.f34 t1.f35 t1.f36 t1.f37
29 ---------------------------------------------------------
30 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37
31 3 2 3 4 5 6 7 8 9 10 11 NULL 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37
32 4 2 3 4 5 6 7 8 9 10 11 12 NULL 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37
33 5 2 3 4 5 6 7 8 9 10 11 12 13 NULL 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37
34 6 2 3 4 5 6 7 8 9 10 11 12 13 14 NULL 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37
35
36 echo select * from t1 where f13 is NULL;
37 ---------------------------------------------------------
38 t1.f1 t1.f2 t1.f3 t1.f4 t1.f5 t1.f6 t1.f7 t1.f8 t1.f9 t1.f10 t1.f11 t1.f12 t1.f13 t1.f14 t1.f15 t1.f16 t1.f17 t1.f18 t1.f19 t1.f20 t1.f21 t1.f22 t1.f23 t1.f24 t1.f25 t1.f26 t1.f27 t1.f28 t1.f29 t1.f30 t1.f31 t1.f32 t1.f33 t1.f34 t1.f35 t1.f36 t1.f37
39 ---------------------------------------------------------
40 4 2 3 4 5 6 7 8 9 10 11 12 NULL 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37
41
42 echo update t1 set f33=NULL where f14 is NOT NULL;
43 Statement Executed: Rows Affected = 5
44 echo select * from t1;
45 ---------------------------------------------------------
46 t1.f1 t1.f2 t1.f3 t1.f4 t1.f5 t1.f6 t1.f7 t1.f8 t1.f9 t1.f10 t1.f11 t1.f12 t1.f13 t1.f14 t1.f15 t1.f16 t1.f17 t1.f18 t1.f19 t1.f20 t1.f21 t1.f22 t1.f23 t1.f24 t1.f25 t1.f26 t1.f27 t1.f28 t1.f29 t1.f30 t1.f31 t1.f32 t1.f33 t1.f34 t1.f35 t1.f36 t1.f37
47 ---------------------------------------------------------
48 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 NULL 34 35 36 37
49 2 2 3 4 5 6 7 8 9 10 NULL 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 NULL 34 35 36 37
50 3 2 3 4 5 6 7 8 9 10 11 NULL 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 NULL 34 35 36 37
51 4 2 3 4 5 6 7 8 9 10 11 12 NULL 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 NULL 34 35 36 37
52 5 2 3 4 5 6 7 8 9 10 11 12 13 NULL 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37
53 6 2 3 4 5 6 7 8 9 10 11 12 13 14 NULL 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 NULL 34 35 36 37
54
55 echo update t1 set f3=NULL where f13 is NULL;
56 Statement Executed: Rows Affected = 1
57 echo select * from t1;
58 ---------------------------------------------------------
59 t1.f1 t1.f2 t1.f3 t1.f4 t1.f5 t1.f6 t1.f7 t1.f8 t1.f9 t1.f10 t1.f11 t1.f12 t1.f13 t1.f14 t1.f15 t1.f16 t1.f17 t1.f18 t1.f19 t1.f20 t1.f21 t1.f22 t1.f23 t1.f24 t1.f25 t1.f26 t1.f27 t1.f28 t1.f29 t1.f30 t1.f31 t1.f32 t1.f33 t1.f34 t1.f35 t1.f36 t1.f37
60 ---------------------------------------------------------
61 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 NULL 34 35 36 37
62 2 2 3 4 5 6 7 8 9 10 NULL 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 NULL 34 35 36 37
63 3 2 3 4 5 6 7 8 9 10 11 NULL 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 NULL 34 35 36 37
64 4 2 NULL 4 5 6 7 8 9 10 11 12 NULL 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 NULL 34 35 36 37
65 5 2 3 4 5 6 7 8 9 10 11 12 13 NULL 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37
66 6 2 3 4 5 6 7 8 9 10 11 12 13 14 NULL 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 NULL 34 35 36 37
67
68 echo drop table t1;
69 Statement Executed
Main memory database SQL engine (cvs import)