mirror of
https://github.com/tursodatabase/libsql.git
synced 2024-12-12 15:33:44 +00:00
ad79ef48a2
* add tests * add bench
33 lines
818 B
Plaintext
33 lines
818 B
Plaintext
|
|
WITH data(v) AS (
|
|
SELECT value FROM generate_series(1,35,3)
|
|
UNION ALL
|
|
SELECT value FROM generate_series(10,30,4)
|
|
UNION ALL
|
|
SELECT value FROM generate_series(20,50,5)
|
|
UNION ALL
|
|
SELECT value FROM generate_series(30,60,6)
|
|
UNION ALL
|
|
SELECT value FROM generate_series(1,50,7)
|
|
UNION ALL
|
|
SELECT value FROM generate_series(10,80,8)
|
|
)
|
|
SELECT v FROM data ORDER BY v;
|
|
|
|
|
|
WITH data(v) AS (
|
|
SELECT value FROM generate_series(1,35,3)
|
|
UNION ALL
|
|
SELECT value FROM generate_series(10,30,4)
|
|
UNION ALL
|
|
SELECT value FROM generate_series(20,50,5)
|
|
UNION ALL
|
|
SELECT value FROM generate_series(30,60,6)
|
|
UNION ALL
|
|
SELECT value FROM generate_series(1,50,7)
|
|
UNION ALL
|
|
SELECT value FROM generate_series(10,80,8)
|
|
)
|
|
SELECT v FROM data ORDER BY v;
|
|
|