0
0
mirror of https://github.com/tursodatabase/libsql.git synced 2025-07-14 00:55:18 +00:00
Files
libsql/libsql-sqlite3/test/fixtures/windowC.test
2024-05-27 12:59:10 +02:00

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;