mirror of
https://github.com/tursodatabase/libsql.git
synced 2024-12-15 19:09:41 +00:00
15 lines
294 B
Plaintext
15 lines
294 B
Plaintext
|
|
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;
|
|
|
|
UPDATE t1 SET h = $leader || h;
|