1 CREATE TABLE t1
(f1 INT NOT NULL
, f2 INT
);
2 CREATE INDEX indx on t1
( f1
) HASH UNIQUE
;
3 INSERT INTO t1 VALUES
(0,5);
4 INSERT INTO t1 VALUES
(1,5);
5 INSERT INTO t1 VALUES
(2,5);
6 INSERT INTO t1 VALUES
(3,5);
7 INSERT INTO t1 VALUES
(4,5);
8 INSERT INTO t1 VALUES
(5,5);
9 INSERT INTO t1 VALUES
(6,5);
10 INSERT INTO t1 VALUES
(7,5);
11 INSERT INTO t1 VALUES
(8,5);
12 INSERT INTO t1 VALUES
(9,5);
13 INSERT INTO t1 VALUES
(10,5);
14 INSERT INTO t1 VALUES
(999990,5);
15 INSERT INTO t1 VALUES
(999991,5);
16 INSERT INTO t1 VALUES
(999992,5);
17 INSERT INTO t1 VALUES
(999993,5);
18 INSERT INTO t1 VALUES
(999994,5);
19 INSERT INTO t1 VALUES
(999995,5);
20 INSERT INTO t1 VALUES
(999996,5);
21 INSERT INTO t1 VALUES
(999997,5);
22 INSERT INTO t1 VALUES
(999998,5);
23 INSERT INTO t1 VALUES
(999999,5);