mirror of
https://github.com/tursodatabase/libsql.git
synced 2024-12-12 14:23:38 +00:00
18 lines
547 B
Plaintext
18 lines
547 B
Plaintext
|
|
CREATE TABLE x1(i INTEGER PRIMARY KEY, x);
|
|
|
|
|
|
PRAGMA encoding=UTF16le;
|
|
WITH separator(x) AS (VALUES(',a,'),(',bc,')),
|
|
value(y) AS (VALUES(1),(x'5585d09013455178cd11ce4a'))
|
|
SELECT group_concat(y,x) OVER (ORDER BY x ROWS BETWEEN 1 PRECEDING AND 1 PRECEDING)
|
|
FROM separator, value;
|
|
|
|
|
|
PRAGMA encoding=UTF16be;
|
|
WITH separator(x) AS (VALUES(',a,'),(',bc,')),
|
|
value(y) AS (VALUES(1),(x'5585d09013455178cd11ce4a'))
|
|
SELECT group_concat(y,x) OVER (ORDER BY x ROWS BETWEEN 1 PRECEDING AND 1 PRECEDING)
|
|
FROM separator, value;
|
|
|