?  search:
summary | log | graphiclog1 | graphiclog2 | commit | commitdiff | tree | refs | edit | fork
blame | history | raw | HEAD
adding test scripts
[csql.git] / test / sql / OuterJoin / exp.test004.ksh
blob4998555e4abdef39fece9db3068b030c61f3ebd8
1 Statement Executed
2 Statement Executed: Rows Affected = 1
3 Statement Executed: Rows Affected = 1
4 Statement Executed: Rows Affected = 1
5 Statement Executed: Rows Affected = 1
6 Statement Executed: Rows Affected = 1
7 Statement Executed
8 Statement Executed: Rows Affected = 1
9 Statement Executed: Rows Affected = 1
10 Statement Executed: Rows Affected = 1
11 Statement Executed: Rows Affected = 1
12 Statement Executed: Rows Affected = 1
13 Statement Executed
14 Statement Executed: Rows Affected = 1
15 Statement Executed: Rows Affected = 1
16 Statement Executed: Rows Affected = 1
17 Statement Executed: Rows Affected = 1
18 Statement Executed: Rows Affected = 1
19 echo select * from t1;
20 ---------------------------------------------------------
21 t1.f1 t1.f2 t1.f3 t1.f4 t1.f5 t1.f6 t1.f7 t1.f8 t1.f9
22 ---------------------------------------------------------
23 10 100 1000 Bijay 1000.000000 100000.000000 2009/3/1 11:59:59.0 2009/3/1 11:59:59.0
24 11 110 1100 Jitendr 2000.000000 200000.000000 2009/3/2 11:59:58.0 2009/3/2 11:59:59.0
25 12 120 1000 Nihar 3000.000000 300000.000000 2009/3/3 11:59:57.0 2009/3/3 11:59:59.0
26 13 130 1500 Kishor 4000.000000 400000.000000 2009/3/4 11:59:59.0 2009/3/4 11:59:59.0
27 14 100 1000 Praba 5000.000000 500000.000000 2009/3/1 11:59:58.0 2009/3/1 11:59:59.0
28
29 echo select * from t2;
30 ---------------------------------------------------------
31 t2.f1 t2.f2 t2.f3 t2.f4 t2.f5 t2.f6 t2.f7 t2.f8 t2.f9
32 ---------------------------------------------------------
33 13 110 1100 Sanjit 6000.000000 600000.000000 2009/3/2 11:59:57.0 2009/3/2 11:59:59.0
34 16 120 1000 Sanjay 6500.000000 700000.000000 2009/3/3 11:59:59.0 2009/3/3 11:59:59.0
35 17 130 1100 Arindam 8000.000000 800000.000000 2009/3/4 11:59:58.0 2009/3/4 11:59:59.0
36 10 100 1000 Bijay 9000.000000 900000.000000 2009/3/1 11:59:57.0 2009/3/1 11:59:59.0
37 11 110 1100 Jitendr 1000.000000 100000.000000 2009/3/2 11:59:58.0 2009/3/2 11:59:59.0
38
39 echo select * from t3;
40 ---------------------------------------------------------
41 t3.f1 t3.f2 t3.f3 t3.f4 t3.f5 t3.f6 t3.f7 t3.f8 t3.f9
42 ---------------------------------------------------------
43 12 120 1000 Nihar 2000.000000 200000.000000 2009/3/3 11:59:56.0 2009/3/3 11:59:59.0
44 13 130 1100 Kishor 3000.000000 300000.000000 2009/3/5 11:59:56.0 2009/3/5 11:59:59.0
45 14 100 1000 Praba 4000.000000 400000.000000 2009/3/1 11:59:55.0 2009/3/4 11:59:59.0
46 15 110 1100 Sanjit 5000.000000 500000.000000 2009/3/2 11:59:56.0 2009/3/1 11:59:59.0
47 16 120 1000 Sanjay 6000.000000 600000.000000 2009/3/3 11:59:55.0 2009/3/3 11:59:59.0
48
49 echo select t1.f1, t1.f2, t2.f1, t2.f2, t3.f1, t3.f2 from t1 left join t2 on t1.f1 = t2.f1 left join t3 on t2.f1 = t3.f1;
50 ---------------------------------------------------------
51 t1.f1 t1.f2 t2.f1 t2.f2 t3.f1 t3.f2
52 ---------------------------------------------------------
53 10 100 10 100 NULL NULL
54 11 110 11 110 NULL NULL
55 12 120 NULL NULL NULL NULL
56 13 130 13 110 13 130
57 14 100 NULL NULL NULL NULL
58
59 echo select t1.f1, t1.f2, t2.f1, t2.f2, t3.f1, t3.f2 from t1 left join t2 on t1.f2 = t2.f2 left join t3 on t2.f2 = t3.f2;
60 ---------------------------------------------------------
61 t1.f1 t1.f2 t2.f1 t2.f2 t3.f1 t3.f2
62 ---------------------------------------------------------
63 10 100 10 100 14 100
64 11 110 13 110 15 110
65 11 110 11 110 15 110
66 12 120 16 120 12 120
67 12 120 16 120 16 120
68 13 130 17 130 13 130
69 14 100 10 100 14 100
70
71 echo select t1.f1, t1.f3, t2.f1, t2.f3, t3.f1, t3.f3 from t1 left join t2 on t1.f3 = t2.f3 left join t3 on t2.f3 = t3.f3;
72 ---------------------------------------------------------
73 t1.f1 t1.f3 t2.f1 t2.f3 t3.f1 t3.f3
74 ---------------------------------------------------------
75 10 1000 16 1000 12 1000
76 10 1000 16 1000 14 1000
77 10 1000 16 1000 16 1000
78 10 1000 10 1000 12 1000
79 10 1000 10 1000 14 1000
80 10 1000 10 1000 16 1000
81 11 1100 13 1100 13 1100
82 11 1100 13 1100 15 1100
83 11 1100 17 1100 13 1100
84 11 1100 17 1100 15 1100
85 11 1100 11 1100 13 1100
86 11 1100 11 1100 15 1100
87 12 1000 16 1000 12 1000
88 12 1000 16 1000 14 1000
89 12 1000 16 1000 16 1000
90 12 1000 10 1000 12 1000
91 12 1000 10 1000 14 1000
92 12 1000 10 1000 16 1000
93 13 1500 NULL NULL NULL NULL
94 14 1000 16 1000 12 1000
95 14 1000 16 1000 14 1000
96 14 1000 16 1000 16 1000
97 14 1000 10 1000 12 1000
98 14 1000 10 1000 14 1000
99 14 1000 10 1000 16 1000
100
101 echo select t1.f1, t1.f4, t2.f1, t2.f4, t3.f1, t3.f4 from t1 left join t2 on t1.f4 = t2.f4 left join t3 on t2.f4 = t3.f4;
102 ---------------------------------------------------------
103 t1.f1 t1.f4 t2.f1 t2.f4 t3.f1 t3.f4
104 ---------------------------------------------------------
105 10 Bijay 10 Bijay NULL NULL
106 11 Jitendr 11 Jitendr NULL NULL
107 12 Nihar NULL NULL NULL NULL
108 13 Kishor NULL NULL NULL NULL
109 14 Praba NULL NULL NULL NULL
110
111 echo select t1.f1, t1.f5, t2.f1, t2.f5, t3.f1, t3.f5 from t1 left join t2 on t1.f5 = t2.f5 left join t3 on t2.f5 = t3.f5;
112 ---------------------------------------------------------
113 t1.f1 t1.f5 t2.f1 t2.f5 t3.f1 t3.f5
114 ---------------------------------------------------------
115 10 1000.000000 11 1000.000000 NULL NULL
116 11 2000.000000 NULL NULL NULL NULL
117 12 3000.000000 NULL NULL NULL NULL
118 13 4000.000000 NULL NULL NULL NULL
119 14 5000.000000 NULL NULL NULL NULL
120
121 echo select t1.f1, t1.f6, t2.f1, t2.f6, t3.f1, t3.f6 from t1 left join t2 on t1.f6 = t2.f6 left join t3 on t2.f6 = t3.f6;
122 ---------------------------------------------------------
123 t1.f1 t1.f6 t2.f1 t2.f6 t3.f1 t3.f6
124 ---------------------------------------------------------
125 10 100000.000000 11 100000.000000 NULL NULL
126 11 200000.000000 NULL NULL NULL NULL
127 12 300000.000000 NULL NULL NULL NULL
128 13 400000.000000 NULL NULL NULL NULL
129 14 500000.000000 NULL NULL NULL NULL
130
131 echo select t1.f1, t1.f7, t2.f1, t2.f7, t3.f1, t3.f7 from t1 left join t2 on t1.f7 = t2.f7 left join t3 on t2.f7 = t3.f7;
132 ---------------------------------------------------------
133 t1.f1 t1.f7 t2.f1 t2.f7 t3.f1 t3.f7
134 ---------------------------------------------------------
135 10 2009/3/1 10 2009/3/1 14 2009/3/1
136 11 2009/3/2 13 2009/3/2 15 2009/3/2
137 11 2009/3/2 11 2009/3/2 15 2009/3/2
138 12 2009/3/3 16 2009/3/3 12 2009/3/3
139 12 2009/3/3 16 2009/3/3 16 2009/3/3
140 13 2009/3/4 17 2009/3/4 NULL NULL
141 14 2009/3/1 10 2009/3/1 14 2009/3/1
142
143 echo select t1.f1, t1.f8, t2.f1, t2.f8, t3.f1, t3.f8 from t1 left join t2 on t1.f8 = t2.f8 left join t3 on t2.f8 = t3.f8;
144 ---------------------------------------------------------
145 t1.f1 t1.f8 t2.f1 t2.f8 t3.f1 t3.f8
146 ---------------------------------------------------------
147 10 11:59:59.0 16 11:59:59.0 NULL NULL
148 11 11:59:58.0 17 11:59:58.0 NULL NULL
149 11 11:59:58.0 11 11:59:58.0 NULL NULL
150 12 11:59:57.0 13 11:59:57.0 NULL NULL
151 12 11:59:57.0 10 11:59:57.0 NULL NULL
152 13 11:59:59.0 16 11:59:59.0 NULL NULL
153 14 11:59:58.0 17 11:59:58.0 NULL NULL
154 14 11:59:58.0 11 11:59:58.0 NULL NULL
155
156 echo select t1.f1, t1.f9, t2.f1, t2.f9, t3.f1, t3.f9 from t1 left join t2 on t1.f9 = t2.f9 left join t3 on t2.f9 = t3.f9;
157 ---------------------------------------------------------
158 t1.f1 t1.f9 t2.f1 t2.f9 t3.f1 t3.f9
159 ---------------------------------------------------------
160 10 2009/3/1 11:59:59.0 10 2009/3/1 11:59:59.0 15 2009/3/1 11:59:59.0
161 11 2009/3/2 11:59:59.0 13 2009/3/2 11:59:59.0 NULL NULL
162 11 2009/3/2 11:59:59.0 11 2009/3/2 11:59:59.0 NULL NULL
163 12 2009/3/3 11:59:59.0 16 2009/3/3 11:59:59.0 12 2009/3/3 11:59:59.0
164 12 2009/3/3 11:59:59.0 16 2009/3/3 11:59:59.0 16 2009/3/3 11:59:59.0
165 13 2009/3/4 11:59:59.0 17 2009/3/4 11:59:59.0 14 2009/3/4 11:59:59.0
166 14 2009/3/1 11:59:59.0 10 2009/3/1 11:59:59.0 15 2009/3/1 11:59:59.0
167
168 Statement Executed
169 Statement Executed
170 Statement Executed
Main memory database SQL engine (cvs import)