1 2 3 4 5 6 7 8 9 10 11 12 13
SELECT int2hex(0), int2hex(100), int2hex(255) CREATE TABLE t1(i, h); CREATE INDEX i1 ON t1(h); WITH data(a, b) AS ( SELECT 1, int2hex(1) UNION ALL SELECT a+1, int2hex(a+1) FROM data WHERE a<40 ) INSERT INTO t1 SELECT * FROM data;