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 insert into t1 values
(101,100);
8 Statement Executed
: Rows Affected
= 1
9 echo insert into t1 values
(303,333);
10 Statement Executed
: Rows Affected
= 1
11 echo insert into t1 values
(505,555);
12 Statement Executed
: Rows Affected
= 1
13 echo insert into t2 values
(505,100);
14 Statement Executed
: Rows Affected
= 1
15 echo insert into t2 values
(100,101);
16 Statement Executed
: Rows Affected
= 1
17 echo insert into t2 values
(404,444);
18 Statement Executed
: Rows Affected
= 1
19 echo insert into t2 values
(303,333);
20 Statement Executed
: Rows Affected
= 1
21 echo insert into t2 values
(101,100);
22 Statement Executed
: Rows Affected
= 1
23 echo select * from t1
;
24 ---------------------------------------------------------
26 ---------------------------------------------------------
31 echo select * from t2
;
32 ---------------------------------------------------------
34 ---------------------------------------------------------
41 echo select * from t1
,t2
;
42 ---------------------------------------------------------
43 t1.f1 t1.f2 t2.f1 t2.f2
44 ---------------------------------------------------------
61 echo select * from t1
,t2 where t1.f1
=t2.f1 and t1.f2
=t2.f2
;
62 ---------------------------------------------------------
63 t1.f1 t1.f2 t2.f1 t2.f2
64 ---------------------------------------------------------
68 echo select * from t1
,t2 where t1.f2
=t2.f2 and t1.f1
=t2.f1
;
69 ---------------------------------------------------------
70 t1.f1 t1.f2 t2.f1 t2.f2
71 ---------------------------------------------------------
75 echo select * from t1
,t2 where t1.f1
>t2.f1 and t1.f2
>t2.f2
;
76 ---------------------------------------------------------
77 t1.f1 t1.f2 t2.f1 t2.f2
78 ---------------------------------------------------------
86 echo select * from t1
,t2 where t1.f2
<t2.f2 and t1.f1
<=t2.f1
;
87 ---------------------------------------------------------
88 t1.f1 t1.f2 t2.f1 t2.f2
89 ---------------------------------------------------------
94 echo select * from t1
,t2 where t1.f1
=t2.f1 or t1.f2
=t2.f2
;
95 ---------------------------------------------------------
96 t1.f1 t1.f2 t2.f1 t2.f2
97 ---------------------------------------------------------
103 echo select * from t1
,t2 where t1.f2
=t2.f2 or t1.f1
=t2.f1
;
104 ---------------------------------------------------------
105 t1.f1 t1.f2 t2.f1 t2.f2
106 ---------------------------------------------------------
112 echo select * from t1
,t2 where t1.f1
>t2.f1 or t1.f2
>=t2.f2
;
113 ---------------------------------------------------------
114 t1.f1 t1.f2 t2.f1 t2.f2
115 ---------------------------------------------------------
129 echo select * from t1
,t2 where t1.f2
<t2.f2 or t1.f1
<t2.f1
;
130 ---------------------------------------------------------
131 t1.f1 t1.f2 t2.f1 t2.f2
132 ---------------------------------------------------------
140 echo select * from t1
,t2 where t1.f1
>t2.f1 or t1.f2
>t2.f2
;
141 ---------------------------------------------------------
142 t1.f1 t1.f2 t2.f1 t2.f2
143 ---------------------------------------------------------
154 echo select * from t1
,t2 where t1.f1
=t2.f1 and not
(t1.f2
=t2.f2
);
155 ---------------------------------------------------------
156 t1.f1 t1.f2 t2.f1 t2.f2
157 ---------------------------------------------------------
160 echo select * from t1
,t2 where t1.f2
=t2.f2 and not
(t1.f1
=t2.f1
);
161 ---------------------------------------------------------
162 t1.f1 t1.f2 t2.f1 t2.f2
163 ---------------------------------------------------------
166 echo select * from t1
,t2 where not
(t1.f1
>t2.f1
) and t1.f2
>t2.f2
;
167 ---------------------------------------------------------
168 t1.f1 t1.f2 t2.f1 t2.f2
169 ---------------------------------------------------------
173 echo select * from t1
,t2 where not
(t1.f2
<t2.f2
) and not
(t1.f1
<t2.f1
);
174 ---------------------------------------------------------
175 t1.f1 t1.f2 t2.f1 t2.f2
176 ---------------------------------------------------------
187 echo select * from t1
,t2 where not
(t1.f1
=t2.f1
) or not
(t1.f2
=t2.f2
);
188 ---------------------------------------------------------
189 t1.f1 t1.f2 t2.f1 t2.f2
190 ---------------------------------------------------------