?  search:
summary | log | graphiclog1 | graphiclog2 | commit | commitdiff | tree | refs | edit | fork
blame | history | raw | HEAD
core reorg
[csql.git] / test / sql / OuterJoin / exp.test003.ksh
blobbef788551329b018af4dd49fc8defa7b1106c626
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.f3, t1.f6, t1.f9, t2.f1, t2.f3, t2.f6, t2.f9 from t1 left join t2 on t1.f1 = t2.f1;
50 ---------------------------------------------------------
51 t1.f1 t1.f3 t1.f6 t1.f9 t2.f1 t2.f3 t2.f6 t2.f9
52 ---------------------------------------------------------
53 10 1000 100000.000000 2009/3/1 11:59:59.0 10 1000 900000.000000 2009/3/1 11:59:59.0
54 11 1100 200000.000000 2009/3/2 11:59:59.0 11 1100 100000.000000 2009/3/2 11:59:59.0
55 12 1000 300000.000000 2009/3/3 11:59:59.0 NULL NULL NULL NULL
56 13 1500 400000.000000 2009/3/4 11:59:59.0 13 1100 600000.000000 2009/3/2 11:59:59.0
57 14 1000 500000.000000 2009/3/1 11:59:59.0 NULL NULL NULL NULL
58
59 echo select t1.f1, t1.f3, t1.f6, t1.f9, t2.f1, t2.f3, t2.f6, t2.f9 from t1 left join t2 on t1.f2 = t2.f2;
60 ---------------------------------------------------------
61 t1.f1 t1.f3 t1.f6 t1.f9 t2.f1 t2.f3 t2.f6 t2.f9
62 ---------------------------------------------------------
63 10 1000 100000.000000 2009/3/1 11:59:59.0 10 1000 900000.000000 2009/3/1 11:59:59.0
64 11 1100 200000.000000 2009/3/2 11:59:59.0 13 1100 600000.000000 2009/3/2 11:59:59.0
65 11 1100 200000.000000 2009/3/2 11:59:59.0 11 1100 100000.000000 2009/3/2 11:59:59.0
66 12 1000 300000.000000 2009/3/3 11:59:59.0 16 1000 700000.000000 2009/3/3 11:59:59.0
67 13 1500 400000.000000 2009/3/4 11:59:59.0 17 1100 800000.000000 2009/3/4 11:59:59.0
68 14 1000 500000.000000 2009/3/1 11:59:59.0 10 1000 900000.000000 2009/3/1 11:59:59.0
69
70 echo select t1.f1, t1.f3, t1.f6, t1.f9, t2.f1, t2.f3, t2.f6, t2.f9 from t1 left join t2 on t1.f3 = t2.f3;
71 ---------------------------------------------------------
72 t1.f1 t1.f3 t1.f6 t1.f9 t2.f1 t2.f3 t2.f6 t2.f9
73 ---------------------------------------------------------
74 10 1000 100000.000000 2009/3/1 11:59:59.0 16 1000 700000.000000 2009/3/3 11:59:59.0
75 10 1000 100000.000000 2009/3/1 11:59:59.0 10 1000 900000.000000 2009/3/1 11:59:59.0
76 11 1100 200000.000000 2009/3/2 11:59:59.0 13 1100 600000.000000 2009/3/2 11:59:59.0
77 11 1100 200000.000000 2009/3/2 11:59:59.0 17 1100 800000.000000 2009/3/4 11:59:59.0
78 11 1100 200000.000000 2009/3/2 11:59:59.0 11 1100 100000.000000 2009/3/2 11:59:59.0
79 12 1000 300000.000000 2009/3/3 11:59:59.0 16 1000 700000.000000 2009/3/3 11:59:59.0
80 12 1000 300000.000000 2009/3/3 11:59:59.0 10 1000 900000.000000 2009/3/1 11:59:59.0
81 13 1500 400000.000000 2009/3/4 11:59:59.0 NULL NULL NULL NULL
82 14 1000 500000.000000 2009/3/1 11:59:59.0 16 1000 700000.000000 2009/3/3 11:59:59.0
83 14 1000 500000.000000 2009/3/1 11:59:59.0 10 1000 900000.000000 2009/3/1 11:59:59.0
84
85 echo select t1.f1, t1.f3, t1.f6, t1.f9, t2.f1, t2.f3, t2.f6, t2.f9 from t1 left join t2 on t1.f4 = t2.f4;
86 ---------------------------------------------------------
87 t1.f1 t1.f3 t1.f6 t1.f9 t2.f1 t2.f3 t2.f6 t2.f9
88 ---------------------------------------------------------
89 10 1000 100000.000000 2009/3/1 11:59:59.0 10 1000 900000.000000 2009/3/1 11:59:59.0
90 11 1100 200000.000000 2009/3/2 11:59:59.0 11 1100 100000.000000 2009/3/2 11:59:59.0
91 12 1000 300000.000000 2009/3/3 11:59:59.0 NULL NULL NULL NULL
92 13 1500 400000.000000 2009/3/4 11:59:59.0 NULL NULL NULL NULL
93 14 1000 500000.000000 2009/3/1 11:59:59.0 NULL NULL NULL NULL
94
95 echo select t1.f1, t1.f3, t1.f6, t1.f9, t2.f1, t2.f3, t2.f6, t2.f9 from t1 left join t2 on t1.f5 = t2.f5;
96 ---------------------------------------------------------
97 t1.f1 t1.f3 t1.f6 t1.f9 t2.f1 t2.f3 t2.f6 t2.f9
98 ---------------------------------------------------------
99 10 1000 100000.000000 2009/3/1 11:59:59.0 11 1100 100000.000000 2009/3/2 11:59:59.0
100 11 1100 200000.000000 2009/3/2 11:59:59.0 NULL NULL NULL NULL
101 12 1000 300000.000000 2009/3/3 11:59:59.0 NULL NULL NULL NULL
102 13 1500 400000.000000 2009/3/4 11:59:59.0 NULL NULL NULL NULL
103 14 1000 500000.000000 2009/3/1 11:59:59.0 NULL NULL NULL NULL
104
105 echo select t1.f1, t1.f3, t1.f6, t1.f9, t2.f1, t2.f3, t2.f6, t2.f9 from t1 left join t2 on t1.f6 = t2.f6;
106 ---------------------------------------------------------
107 t1.f1 t1.f3 t1.f6 t1.f9 t2.f1 t2.f3 t2.f6 t2.f9
108 ---------------------------------------------------------
109 10 1000 100000.000000 2009/3/1 11:59:59.0 11 1100 100000.000000 2009/3/2 11:59:59.0
110 11 1100 200000.000000 2009/3/2 11:59:59.0 NULL NULL NULL NULL
111 12 1000 300000.000000 2009/3/3 11:59:59.0 NULL NULL NULL NULL
112 13 1500 400000.000000 2009/3/4 11:59:59.0 NULL NULL NULL NULL
113 14 1000 500000.000000 2009/3/1 11:59:59.0 NULL NULL NULL NULL
114
115 echo select t1.f1, t1.f3, t1.f6, t1.f9, t2.f1, t2.f3, t2.f6, t2.f9 from t1 left join t2 on t1.f7 = t2.f7;
116 ---------------------------------------------------------
117 t1.f1 t1.f3 t1.f6 t1.f9 t2.f1 t2.f3 t2.f6 t2.f9
118 ---------------------------------------------------------
119 10 1000 100000.000000 2009/3/1 11:59:59.0 10 1000 900000.000000 2009/3/1 11:59:59.0
120 11 1100 200000.000000 2009/3/2 11:59:59.0 13 1100 600000.000000 2009/3/2 11:59:59.0
121 11 1100 200000.000000 2009/3/2 11:59:59.0 11 1100 100000.000000 2009/3/2 11:59:59.0
122 12 1000 300000.000000 2009/3/3 11:59:59.0 16 1000 700000.000000 2009/3/3 11:59:59.0
123 13 1500 400000.000000 2009/3/4 11:59:59.0 17 1100 800000.000000 2009/3/4 11:59:59.0
124 14 1000 500000.000000 2009/3/1 11:59:59.0 10 1000 900000.000000 2009/3/1 11:59:59.0
125
126 echo select t1.f1, t1.f3, t1.f6, t1.f9, t2.f1, t2.f3, t2.f6, t2.f9 from t1 left join t2 on t1.f8 = t2.f8;
127 ---------------------------------------------------------
128 t1.f1 t1.f3 t1.f6 t1.f9 t2.f1 t2.f3 t2.f6 t2.f9
129 ---------------------------------------------------------
130 10 1000 100000.000000 2009/3/1 11:59:59.0 16 1000 700000.000000 2009/3/3 11:59:59.0
131 11 1100 200000.000000 2009/3/2 11:59:59.0 17 1100 800000.000000 2009/3/4 11:59:59.0
132 11 1100 200000.000000 2009/3/2 11:59:59.0 11 1100 100000.000000 2009/3/2 11:59:59.0
133 12 1000 300000.000000 2009/3/3 11:59:59.0 13 1100 600000.000000 2009/3/2 11:59:59.0
134 12 1000 300000.000000 2009/3/3 11:59:59.0 10 1000 900000.000000 2009/3/1 11:59:59.0
135 13 1500 400000.000000 2009/3/4 11:59:59.0 16 1000 700000.000000 2009/3/3 11:59:59.0
136 14 1000 500000.000000 2009/3/1 11:59:59.0 17 1100 800000.000000 2009/3/4 11:59:59.0
137 14 1000 500000.000000 2009/3/1 11:59:59.0 11 1100 100000.000000 2009/3/2 11:59:59.0
138
139 echo select t1.f1, t1.f3, t1.f6, t1.f9, t2.f1, t2.f3, t2.f6, t2.f9 from t1 left join t2 on t1.f9 = t2.f9;
140 ---------------------------------------------------------
141 t1.f1 t1.f3 t1.f6 t1.f9 t2.f1 t2.f3 t2.f6 t2.f9
142 ---------------------------------------------------------
143 10 1000 100000.000000 2009/3/1 11:59:59.0 10 1000 900000.000000 2009/3/1 11:59:59.0
144 11 1100 200000.000000 2009/3/2 11:59:59.0 13 1100 600000.000000 2009/3/2 11:59:59.0
145 11 1100 200000.000000 2009/3/2 11:59:59.0 11 1100 100000.000000 2009/3/2 11:59:59.0
146 12 1000 300000.000000 2009/3/3 11:59:59.0 16 1000 700000.000000 2009/3/3 11:59:59.0
147 13 1500 400000.000000 2009/3/4 11:59:59.0 17 1100 800000.000000 2009/3/4 11:59:59.0
148 14 1000 500000.000000 2009/3/1 11:59:59.0 10 1000 900000.000000 2009/3/1 11:59:59.0
149
150 Statement Executed
151 Statement Executed
152 Statement Executed
Main memory database SQL engine (cvs import)