2 Statement Executed
: Rows Affected
= 1
3 Statement Executed
: Rows Affected
= 1
4 Statement Executed
: Rows Affected
= 1
5 Statement execute failed with error
-21
6 Statement Executed
: Rows Affected
= 1
7 Statement Executed
: Rows Affected
= 1
8 Statement Executed
: Rows Affected
= 1
9 echo select count
(f1
) from t1
;
10 ---------------------------------------------------------
12 ---------------------------------------------------------
15 echo select * from t1 where f1
=1 and f2
=1;
16 ---------------------------------------------------------
18 ---------------------------------------------------------
21 echo select * from t1 where f1
=5 and f2
=1;
22 ---------------------------------------------------------
24 ---------------------------------------------------------
26 echo select * from t1 where f1
=5;
27 ---------------------------------------------------------
29 ---------------------------------------------------------
32 echo select * from t1 where f1
=7;
33 ---------------------------------------------------------
35 ---------------------------------------------------------
37 echo select * from t1 where f1
=10 and f2
=2 and f3
=10;
38 ---------------------------------------------------------
40 ---------------------------------------------------------
43 echo select * from t1 where f1
=10 and f2
=6 and f3
=10;
44 ---------------------------------------------------------
46 ---------------------------------------------------------
48 CREATE TABLE t1
(f1 INT NOT NULL
, f2 INT NOT NULL
, f3 INT
);
49 CREATE INDEX t1_idx1_Primary on t1
( f1
,f2
) HASH UNIQUE
;
50 INSERT INTO t1 VALUES
(1,1,1);
51 INSERT INTO t1 VALUES
(2,1,2);
52 INSERT INTO t1 VALUES
(3,1,3);
53 INSERT INTO t1 VALUES
(5,2,5);
54 INSERT INTO t1 VALUES
(10,2,10);
55 INSERT INTO t1 VALUES
(100,3,100);