adding test scripts
[csql.git] / test / jdbc / Statement / exp.test022.ksh
blobf5f83aa64e9147a6b8411d393f6e280fb57b095f
1 SELECT * FROM T1;
2 Tuple value is 0 1 2 0 1000.0 Nihar0 2008-03-21 18:00:00 2008-03-21 18:00:00.0
3 Tuple value is 1 2 3 1 1001.0 Nihar1 2008-03-21 18:00:00 2008-03-21 18:00:00.0
4 Tuple value is 2 3 4 2 1002.0 Nihar2 2008-03-21 18:00:00 2008-03-21 18:00:00.0
5 Tuple value is 3 4 5 3 1003.0 Nihar3 2008-03-21 18:00:00 2008-03-21 18:00:00.0
6 Tuple value is 4 5 6 4 1004.0 Nihar4 2008-03-21 18:00:00 2008-03-21 18:00:00.0
7 Tuple value is 5 6 7 5 1005.0 Nihar5 2008-03-21 18:00:00 2008-03-21 18:00:00.0
8 Tuple value is 6 7 8 6 1006.0 Nihar6 2008-03-21 18:00:00 2008-03-21 18:00:00.0
9 Tuple value is 7 8 9 7 1007.0 Nihar7 2008-03-21 18:00:00 2008-03-21 18:00:00.0
10 Tuple value is 8 9 10 8 1008.0 Nihar8 2008-03-21 18:00:00 2008-03-21 18:00:00.0
11 Tuple value is 9 10 11 9 1009.0 Nihar9 2008-03-21 18:00:00 2008-03-21 18:00:00.0
12 SELECT * FROM T2;
13 Tuple value is 0 1 2 0 1000.0 Nihar0 2008-03-21 18:00:00 2008-03-21 18:00:00.0
14 Tuple value is 2 3 4 2 1002.0 Nihar2 2008-03-21 18:00:00 2008-03-21 18:00:00.0
15 Tuple value is 4 5 6 4 1004.0 Nihar4 2008-03-21 18:00:00 2008-03-21 18:00:00.0
16 Tuple value is 6 7 8 6 1006.0 Nihar6 2008-03-21 18:00:00 2008-03-21 18:00:00.0
17 Tuple value is 8 9 10 8 1008.0 Nihar8 2008-03-21 18:00:00 2008-03-21 18:00:00.0
18 SELECT T1.f1,T2.f1,T1.f2,T2.f2,T1.f3,T2.f3 FROM T1,T2;
19 T1.f1 T2.f1 T1.f2 T2.f2 T1.f3 T2.f3
20 0 0 1 1 2 2
21 0 2 1 3 2 4
22 0 4 1 5 2 6
23 0 6 1 7 2 8
24 0 8 1 9 2 10
25 1 0 2 1 3 2
26 1 2 2 3 3 4
27 1 4 2 5 3 6
28 1 6 2 7 3 8
29 1 8 2 9 3 10
30 2 0 3 1 4 2
31 2 2 3 3 4 4
32 2 4 3 5 4 6
33 2 6 3 7 4 8
34 2 8 3 9 4 10
35 3 0 4 1 5 2
36 3 2 4 3 5 4
37 3 4 4 5 5 6
38 3 6 4 7 5 8
39 3 8 4 9 5 10
40 4 0 5 1 6 2
41 4 2 5 3 6 4
42 4 4 5 5 6 6
43 4 6 5 7 6 8
44 4 8 5 9 6 10
45 5 0 6 1 7 2
46 5 2 6 3 7 4
47 5 4 6 5 7 6
48 5 6 6 7 7 8
49 5 8 6 9 7 10
50 6 0 7 1 8 2
51 6 2 7 3 8 4
52 6 4 7 5 8 6
53 6 6 7 7 8 8
54 6 8 7 9 8 10
55 7 0 8 1 9 2
56 7 2 8 3 9 4
57 7 4 8 5 9 6
58 7 6 8 7 9 8
59 7 8 8 9 9 10
60 8 0 9 1 10 2
61 8 2 9 3 10 4
62 8 4 9 5 10 6
63 8 6 9 7 10 8
64 8 8 9 9 10 10
65 9 0 10 1 11 2
66 9 2 10 3 11 4
67 9 4 10 5 11 6
68 9 6 10 7 11 8
69 9 8 10 9 11 10
70 SELECT T1.f1,T2.f1,T1.f2,T2.f2,T1.f3,T2.f3 FROM T1,T2 WHERE T1.f1>=2 AND T1.f2>=4 AND T2.f3=6
71 T1.f1 T2.f1 T1.f2 T2.f2 T1.f3 T2.f3
72 3 4 4 5 5 6
73 4 4 5 5 6 6
74 5 4 6 5 7 6
75 6 4 7 5 8 6
76 7 4 8 5 9 6
77 8 4 9 5 10 6
78 9 4 10 5 11 6