3 Statement Executed
: Rows Affected
= 1
4 Statement Executed
: Rows Affected
= 1
5 Statement Executed
: Rows Affected
= 1
6 Statement execute failed with error
-21
7 Statement Executed
: Rows Affected
= 1
8 Statement Executed
: Rows Affected
= 1
9 Statement Executed
: Rows Affected
= 1
10 echo select count
(f1
) from t1
;
11 ---------------------------------------------------------
13 ---------------------------------------------------------
16 echo select * from t1 where f1
=1 and f2
=1;
17 ---------------------------------------------------------
19 ---------------------------------------------------------
22 echo select * from t1 where f1
=5 and f2
=1;
23 ---------------------------------------------------------
25 ---------------------------------------------------------
27 echo select * from t1 where f1
=5;
28 ---------------------------------------------------------
30 ---------------------------------------------------------
33 echo select * from t1 where f1
=7;
34 ---------------------------------------------------------
36 ---------------------------------------------------------
38 echo select * from t1 where f1
=10 and f2
=2 and f3
=10;
39 ---------------------------------------------------------
41 ---------------------------------------------------------
44 echo select * from t1 where f1
=10 and f2
=6 and f3
=10;
45 ---------------------------------------------------------
47 ---------------------------------------------------------
49 CREATE TABLE t1
(f1 INT NOT NULL
, f2 INT NOT NULL
, f3 INT
);
50 CREATE INDEX t1_idx1_Primary on t1
( f1
,f2
) HASH UNIQUE
;
51 INSERT INTO t1 VALUES
(1,1,1);
52 INSERT INTO t1 VALUES
(2,1,2);
53 INSERT INTO t1 VALUES
(3,1,3);
54 INSERT INTO t1 VALUES
(5,2,5);
55 INSERT INTO t1 VALUES
(10,2,10);
56 INSERT INTO t1 VALUES
(100,3,100);