?  search:
summary | log | graphiclog1 | graphiclog2 | commit | commitdiff | tree | refs | edit | fork
blame | history | raw | HEAD
adding test scripts
[csql.git] / test / sql / Order / exp.test010.ksh
blob16f5eb11d4910a4fa1c4d2f59942d8ff2f770fa3
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: Rows Affected = 1
8 Statement Executed: Rows Affected = 1
9 Statement Executed: Rows Affected = 1
10 ---------------------------------------------------------
11 emp.empid emp.ename emp.basic emp.join_date emp.mgrno emp.mgrname emp.allowances emp.mgr_date
12 ---------------------------------------------------------
13 7 SUMAN 7500.000000 2007/2/2 1:1:1.0 7 SUMAN 7500.000000 2007/2/2 1:1:1.0
14 1 JAMES 7000.000000 2007/2/2 1:1:1.0 3 PITER 8000.000000 2007/2/3 1:1:1.0
15 4 HARRY 8500.000000 2007/2/6 1:1:1.0 3 PITER 8000.000000 2007/2/3 1:1:1.0
16 2 LALIT 7500.000000 2007/2/1 1:1:1.0 1 JAMES 7000.000000 2007/2/2 1:1:1.0
17 3 PITER 8000.000000 2007/2/3 1:1:1.0 2 LALIT 7500.000000 2007/2/1 1:1:1.0
18 5 MAHES 6500.000000 2007/2/4 1:1:1.0 4 HARRY 8500.000000 2007/2/6 1:1:1.0
19 8 LATIF 7000.000000 2007/2/1 1:1:1.0 3 PITER 8000.000000 2007/2/3 1:1:1.0
20 6 RAMAN 6000.000000 2007/2/5 1:1:1.0 4 HARRY 8500.000000 2007/2/6 1:1:1.0
21
22 echo SELECT a.empid, a.ename, b.ename FROM emp as a, emp as b WHERE a.empid=b.mgrno;
23 ---------------------------------------------------------
24 a.empid a.ename b.ename
25 ---------------------------------------------------------
26 7 SUMAN SUMAN
27 1 JAMES LALIT
28 4 HARRY MAHES
29 4 HARRY RAMAN
30 2 LALIT PITER
31 3 PITER JAMES
32 3 PITER HARRY
33 3 PITER LATIF
34
35 echo SELECT a.empid, a.ename, b.ename FROM emp as a, emp as b WHERE a.empid=b.mgrno ORDER BY a.empid;
36 ---------------------------------------------------------
37 a.empid a.ename b.ename
38 ---------------------------------------------------------
39 1 JAMES LALIT
40 2 LALIT PITER
41 3 PITER LATIF
42 3 PITER HARRY
43 3 PITER JAMES
44 4 HARRY RAMAN
45 4 HARRY MAHES
46 7 SUMAN SUMAN
47
48 echo SELECT a.empid, a.ename, b.ename FROM emp as a, emp as b WHERE a.empid=b.mgrno ORDER BY a.empid, b.ename DESC;
49 ---------------------------------------------------------
50 a.empid a.ename b.ename
51 ---------------------------------------------------------
52 1 JAMES LALIT
53 2 LALIT PITER
54 3 PITER LATIF
55 3 PITER JAMES
56 3 PITER HARRY
57 4 HARRY RAMAN
58 4 HARRY MAHES
59 7 SUMAN SUMAN
60
61 echo SELECT a.ename, b.ename FROM emp as a, emp as b WHERE a.ename=b.mgrname;
62 ---------------------------------------------------------
63 a.ename b.ename
64 ---------------------------------------------------------
65 SUMAN SUMAN
66 JAMES LALIT
67 HARRY MAHES
68 HARRY RAMAN
69 LALIT PITER
70 PITER JAMES
71 PITER HARRY
72 PITER LATIF
73
74 echo SELECT a.ename, b.ename FROM emp as a, emp as b WHERE a.ename=b.mgrname ORDER BY a.ename;
75 ---------------------------------------------------------
76 a.ename b.ename
77 ---------------------------------------------------------
78 HARRY RAMAN
79 HARRY MAHES
80 JAMES LALIT
81 LALIT PITER
82 PITER LATIF
83 PITER HARRY
84 PITER JAMES
85 SUMAN SUMAN
86
87 echo SELECT a.ename, b.ename FROM emp as a, emp as b WHERE a.ename=b.mgrname ORDER BY a.ename, b.empid DESC;
88 ---------------------------------------------------------
89 a.ename b.ename
90 ---------------------------------------------------------
91 HARRY RAMAN
92 HARRY MAHES
93 JAMES LALIT
94 LALIT PITER
95 PITER LATIF
96 PITER HARRY
97 PITER JAMES
98 SUMAN SUMAN
99
100 echo SELECT a.ename, b.ename, a.basic FROM emp as a, emp as b WHERE a.basic=b.allowances;
101 ---------------------------------------------------------
102 a.ename b.ename a.basic
103 ---------------------------------------------------------
104 SUMAN SUMAN 7500.000000
105 SUMAN PITER 7500.000000
106 JAMES LALIT 7000.000000
107 HARRY MAHES 8500.000000
108 HARRY RAMAN 8500.000000
109 LALIT SUMAN 7500.000000
110 LALIT PITER 7500.000000
111 PITER JAMES 8000.000000
112 PITER HARRY 8000.000000
113 PITER LATIF 8000.000000
114 LATIF LALIT 7000.000000
115
116 echo SELECT a.ename, b.ename, a.basic FROM emp as a, emp as b WHERE a.basic=b.allowances ORDER BY a.basic;
117 ---------------------------------------------------------
118 a.ename b.ename a.basic
119 ---------------------------------------------------------
120 LATIF LALIT 7000.000000
121 JAMES LALIT 7000.000000
122 LALIT PITER 7500.000000
123 LALIT SUMAN 7500.000000
124 SUMAN PITER 7500.000000
125 SUMAN SUMAN 7500.000000
126 PITER LATIF 8000.000000
127 PITER HARRY 8000.000000
128 PITER JAMES 8000.000000
129 HARRY RAMAN 8500.000000
130 HARRY MAHES 8500.000000
131
132 echo SELECT a.ename, b.ename, a.basic FROM emp as a, emp as b WHERE a.basic=b.allowances ORDER BY a.basic DESC, b.ename DESC;
133 ---------------------------------------------------------
134 a.ename b.ename a.basic
135 ---------------------------------------------------------
136 HARRY RAMAN 8500.000000
137 HARRY MAHES 8500.000000
138 PITER LATIF 8000.000000
139 PITER JAMES 8000.000000
140 PITER HARRY 8000.000000
141 LALIT SUMAN 7500.000000
142 SUMAN SUMAN 7500.000000
143 LALIT PITER 7500.000000
144 SUMAN PITER 7500.000000
145 LATIF LALIT 7000.000000
146 JAMES LALIT 7000.000000
147
148 echo SELECT a.ename, b.ename, b.mgr_date FROM emp as a, emp as b WHERE a.mgr_date=b.join_date;
149 ---------------------------------------------------------
150 a.ename b.ename b.mgr_date
151 ---------------------------------------------------------
152 SUMAN SUMAN 2007/2/2 1:1:1.0
153 SUMAN JAMES 2007/2/3 1:1:1.0
154 JAMES PITER 2007/2/1 1:1:1.0
155 HARRY PITER 2007/2/1 1:1:1.0
156 LALIT SUMAN 2007/2/2 1:1:1.0
157 LALIT JAMES 2007/2/3 1:1:1.0
158 PITER LALIT 2007/2/2 1:1:1.0
159 PITER LATIF 2007/2/3 1:1:1.0
160 MAHES HARRY 2007/2/3 1:1:1.0
161 LATIF PITER 2007/2/1 1:1:1.0
162 RAMAN HARRY 2007/2/3 1:1:1.0
163
164 echo SELECT a.ename, b.ename, a.mgr_date FROM emp as a, emp as b WHERE a.mgr_date=b.join_date ORDER BY a.mgr_date;
165 ---------------------------------------------------------
166 a.ename b.ename a.mgr_date
167 ---------------------------------------------------------
168 PITER LATIF 2007/2/1 1:1:1.0
169 PITER LALIT 2007/2/1 1:1:1.0
170 LALIT JAMES 2007/2/2 1:1:1.0
171 LALIT SUMAN 2007/2/2 1:1:1.0
172 SUMAN JAMES 2007/2/2 1:1:1.0
173 SUMAN SUMAN 2007/2/2 1:1:1.0
174 LATIF PITER 2007/2/3 1:1:1.0
175 HARRY PITER 2007/2/3 1:1:1.0
176 JAMES PITER 2007/2/3 1:1:1.0
177 RAMAN HARRY 2007/2/6 1:1:1.0
178 MAHES HARRY 2007/2/6 1:1:1.0
179
180 echo SELECT a.ename, b.ename, a.join_date, b.join_date, a.basic, b.basic, a.empid, b.empid FROM emp as a, emp as b WHERE a.mgr_date=b.join_date ORDER BY a.mgr_date DESC;
181 ---------------------------------------------------------
182 a.ename b.ename a.join_date b.join_date a.basic b.basic a.empid b.empid
183 ---------------------------------------------------------
184 RAMAN HARRY 2007/2/5 1:1:1.0 2007/2/6 1:1:1.0 6000.000000 8500.000000 6 4
185 MAHES HARRY 2007/2/4 1:1:1.0 2007/2/6 1:1:1.0 6500.000000 8500.000000 5 4
186 LATIF PITER 2007/2/1 1:1:1.0 2007/2/3 1:1:1.0 7000.000000 8000.000000 8 3
187 HARRY PITER 2007/2/6 1:1:1.0 2007/2/3 1:1:1.0 8500.000000 8000.000000 4 3
188 JAMES PITER 2007/2/2 1:1:1.0 2007/2/3 1:1:1.0 7000.000000 8000.000000 1 3
189 LALIT JAMES 2007/2/1 1:1:1.0 2007/2/2 1:1:1.0 7500.000000 7000.000000 2 1
190 LALIT SUMAN 2007/2/1 1:1:1.0 2007/2/2 1:1:1.0 7500.000000 7500.000000 2 7
191 SUMAN JAMES 2007/2/2 1:1:1.0 2007/2/2 1:1:1.0 7500.000000 7000.000000 7 1
192 SUMAN SUMAN 2007/2/2 1:1:1.0 2007/2/2 1:1:1.0 7500.000000 7500.000000 7 7
193 PITER LATIF 2007/2/3 1:1:1.0 2007/2/1 1:1:1.0 8000.000000 7000.000000 3 8
194 PITER LALIT 2007/2/3 1:1:1.0 2007/2/1 1:1:1.0 8000.000000 7500.000000 3 2
195
196 Statement Executed
Main memory database SQL engine (cvs import)