1 echo create table t1
(f1 int
,f2 int
);
3 echo create index idx1 on t1
(f1
,f2
) hash;
5 echo create table t2
(f1 int
,f2 int
);
7 echo create index idx2 on t1
(f2
) tree
;
9 echo insert into t1 values
(101,100);
10 Statement Executed
: Rows Affected
= 1
11 echo insert into t1 values
(303,333);
12 Statement Executed
: Rows Affected
= 1
13 echo insert into t1 values
(505,555);
14 Statement Executed
: Rows Affected
= 1
15 echo insert into t2 values
(505,100);
16 Statement Executed
: Rows Affected
= 1
17 echo insert into t2 values
(100,101);
18 Statement Executed
: Rows Affected
= 1
19 echo insert into t2 values
(404,444);
20 Statement Executed
: Rows Affected
= 1
21 echo insert into t2 values
(303,333);
22 Statement Executed
: Rows Affected
= 1
23 echo insert into t2 values
(101,100);
24 Statement Executed
: Rows Affected
= 1
25 echo select * from t1
;
26 ---------------------------------------------------------
28 ---------------------------------------------------------
33 echo select * from t2
;
34 ---------------------------------------------------------
36 ---------------------------------------------------------
43 echo select * from t1
,t2
;
44 ---------------------------------------------------------
45 t1.f1 t1.f2 t2.f1 t2.f2
46 ---------------------------------------------------------
63 echo select * from t1
,t2 where t1.f1
=t2.f1 and t1.f2
=t2.f2
;
64 ---------------------------------------------------------
65 t1.f1 t1.f2 t2.f1 t2.f2
66 ---------------------------------------------------------
70 echo select * from t1
,t2 where t1.f2
=t2.f2 and t1.f1
=t2.f1
;
71 ---------------------------------------------------------
72 t1.f1 t1.f2 t2.f1 t2.f2
73 ---------------------------------------------------------
77 echo select * from t1
,t2 where t1.f1
>t2.f1 and t1.f2
>t2.f2
;
78 ---------------------------------------------------------
79 t1.f1 t1.f2 t2.f1 t2.f2
80 ---------------------------------------------------------
88 echo select * from t1
,t2 where t1.f2
<t2.f2 and t1.f1
<=t2.f1
;
89 ---------------------------------------------------------
90 t1.f1 t1.f2 t2.f1 t2.f2
91 ---------------------------------------------------------
96 echo select * from t1
,t2 where t1.f1
=t2.f1 or t1.f2
=t2.f2
;
97 ---------------------------------------------------------
98 t1.f1 t1.f2 t2.f1 t2.f2
99 ---------------------------------------------------------
105 echo select * from t1
,t2 where t1.f2
=t2.f2 or t1.f1
=t2.f1
;
106 ---------------------------------------------------------
107 t1.f1 t1.f2 t2.f1 t2.f2
108 ---------------------------------------------------------
114 echo select * from t1
,t2 where t1.f1
>t2.f1 or t1.f2
>=t2.f2
;
115 ---------------------------------------------------------
116 t1.f1 t1.f2 t2.f1 t2.f2
117 ---------------------------------------------------------
131 echo select * from t1
,t2 where t1.f2
<t2.f2 or t1.f1
<t2.f1
;
132 ---------------------------------------------------------
133 t1.f1 t1.f2 t2.f1 t2.f2
134 ---------------------------------------------------------
142 echo select * from t1
,t2 where t1.f1
>t2.f1 or t1.f2
>t2.f2
;
143 ---------------------------------------------------------
144 t1.f1 t1.f2 t2.f1 t2.f2
145 ---------------------------------------------------------
156 echo select * from t1
,t2 where t1.f1
=t2.f1 and not
(t1.f2
=t2.f2
);
157 ---------------------------------------------------------
158 t1.f1 t1.f2 t2.f1 t2.f2
159 ---------------------------------------------------------
162 echo select * from t1
,t2 where t1.f2
=t2.f2 and not
(t1.f1
=t2.f1
);
163 ---------------------------------------------------------
164 t1.f1 t1.f2 t2.f1 t2.f2
165 ---------------------------------------------------------
168 echo select * from t1
,t2 where not
(t1.f1
>t2.f1
) and t1.f2
>t2.f2
;
169 ---------------------------------------------------------
170 t1.f1 t1.f2 t2.f1 t2.f2
171 ---------------------------------------------------------
175 echo select * from t1
,t2 where not
(t1.f2
<t2.f2
) and not
(t1.f1
<t2.f1
);
176 ---------------------------------------------------------
177 t1.f1 t1.f2 t2.f1 t2.f2
178 ---------------------------------------------------------
189 echo select * from t1
,t2 where not
(t1.f1
=t2.f1
) or not
(t1.f2
=t2.f2
);
190 ---------------------------------------------------------
191 t1.f1 t1.f2 t2.f1 t2.f2
192 ---------------------------------------------------------