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 t2
(f1
) tree
;
9 echo create index idx3 on t2
(f2
) tree
;
11 echo insert into t1 values
(101,100);
12 Statement Executed
: Rows Affected
= 1
13 echo insert into t1 values
(303,333);
14 Statement Executed
: Rows Affected
= 1
15 echo insert into t1 values
(505,555);
16 Statement Executed
: Rows Affected
= 1
17 echo insert into t2 values
(505,100);
18 Statement Executed
: Rows Affected
= 1
19 echo insert into t2 values
(100,101);
20 Statement Executed
: Rows Affected
= 1
21 echo insert into t2 values
(404,444);
22 Statement Executed
: Rows Affected
= 1
23 echo insert into t2 values
(303,333);
24 Statement Executed
: Rows Affected
= 1
25 echo insert into t2 values
(101,100);
26 Statement Executed
: Rows Affected
= 1
27 echo select * from t1
;
28 ---------------------------------------------------------
30 ---------------------------------------------------------
35 echo select * from t2
;
36 ---------------------------------------------------------
38 ---------------------------------------------------------
45 echo select * from t1
,t2
;
46 ---------------------------------------------------------
47 t1.f1 t1.f2 t2.f1 t2.f2
48 ---------------------------------------------------------
65 echo select * from t1
,t2 where t1.f1
=t2.f1 and t1.f2
=t2.f2
;
66 ---------------------------------------------------------
67 t1.f1 t1.f2 t2.f1 t2.f2
68 ---------------------------------------------------------
72 echo select * from t1
,t2 where t1.f2
=t2.f2 and t1.f1
=t2.f1
;
73 ---------------------------------------------------------
74 t1.f1 t1.f2 t2.f1 t2.f2
75 ---------------------------------------------------------
79 echo select * from t1
,t2 where t1.f1
>t2.f1 and t1.f2
>t2.f2
;
80 ---------------------------------------------------------
81 t1.f1 t1.f2 t2.f1 t2.f2
82 ---------------------------------------------------------
90 echo select * from t1
,t2 where t1.f2
<t2.f2 and t1.f1
<=t2.f1
;
91 ---------------------------------------------------------
92 t1.f1 t1.f2 t2.f1 t2.f2
93 ---------------------------------------------------------
98 echo select * from t1
,t2 where t1.f1
=t2.f1 or t1.f2
=t2.f2
;
99 ---------------------------------------------------------
100 t1.f1 t1.f2 t2.f1 t2.f2
101 ---------------------------------------------------------
107 echo select * from t1
,t2 where t1.f2
=t2.f2 or t1.f1
=t2.f1
;
108 ---------------------------------------------------------
109 t1.f1 t1.f2 t2.f1 t2.f2
110 ---------------------------------------------------------
116 echo select * from t1
,t2 where t1.f1
>t2.f1 or t1.f2
>=t2.f2
;
117 ---------------------------------------------------------
118 t1.f1 t1.f2 t2.f1 t2.f2
119 ---------------------------------------------------------
133 echo select * from t1
,t2 where t1.f2
<t2.f2 or t1.f1
<t2.f1
;
134 ---------------------------------------------------------
135 t1.f1 t1.f2 t2.f1 t2.f2
136 ---------------------------------------------------------
144 echo select * from t1
,t2 where t1.f1
>t2.f1 or t1.f2
>t2.f2
;
145 ---------------------------------------------------------
146 t1.f1 t1.f2 t2.f1 t2.f2
147 ---------------------------------------------------------
158 echo select * from t1
,t2 where t1.f1
=t2.f1 and not
(t1.f2
=t2.f2
);
159 ---------------------------------------------------------
160 t1.f1 t1.f2 t2.f1 t2.f2
161 ---------------------------------------------------------
164 echo select * from t1
,t2 where t1.f2
=t2.f2 and not
(t1.f1
=t2.f1
);
165 ---------------------------------------------------------
166 t1.f1 t1.f2 t2.f1 t2.f2
167 ---------------------------------------------------------
170 echo select * from t1
,t2 where not
(t1.f1
>t2.f1
) and t1.f2
>t2.f2
;
171 ---------------------------------------------------------
172 t1.f1 t1.f2 t2.f1 t2.f2
173 ---------------------------------------------------------
177 echo select * from t1
,t2 where not
(t1.f2
<t2.f2
) and not
(t1.f1
<t2.f1
);
178 ---------------------------------------------------------
179 t1.f1 t1.f2 t2.f1 t2.f2
180 ---------------------------------------------------------
191 echo select * from t1
,t2 where not
(t1.f1
=t2.f1
) or not
(t1.f2
=t2.f2
);
192 ---------------------------------------------------------
193 t1.f1 t1.f2 t2.f1 t2.f2
194 ---------------------------------------------------------