mirror of
https://github.com/tursodatabase/libsql.git
synced 2024-12-15 20:20:20 +00:00
45 lines
755 B
Plaintext
45 lines
755 B
Plaintext
|
|
CREATE TABLE t0(c0 TEXT);
|
|
CREATE VIEW v0(c0, c1)
|
|
AS SELECT CUME_DIST() OVER (PARTITION BY t0.c0), TRUE FROM t0;
|
|
INSERT INTO t0 VALUES ('x');
|
|
|
|
|
|
SELECT ('500') IS (v0.c1) FROM v0;
|
|
|
|
|
|
SELECT (('500') IS (v0.c1)) FROM v0, t0;
|
|
|
|
|
|
SELECT (('500') IS (v0.c1)) IS FALSE FROM v0;
|
|
|
|
|
|
SELECT * FROM v0;
|
|
|
|
|
|
SELECT * FROM v0 WHERE ('500' IS v0.c1) IS FALSE;
|
|
|
|
|
|
CREATE TABLE t1(x);
|
|
INSERT INTO t1 VALUES('value');
|
|
CREATE VIEW v1(a, b, c, d) AS SELECT 1, 2, TRUE, FALSE FROM t1;
|
|
|
|
|
|
SELECT 500 IS a, 500 IS b, 500 IS c, 500 IS d FROM v1
|
|
|
|
|
|
SELECT * FROM v1 WHERE 500 IS c;
|
|
|
|
|
|
SELECT * FROM v1 WHERE 500 IS d;
|
|
|
|
|
|
CREATE VIEW v2 AS SELECT max(x) OVER () AS a, TRUE AS c FROM t1;
|
|
|
|
|
|
SELECT 500 IS c FROM v2;
|
|
|
|
|
|
SELECT * FROM v2 WHERE 500 IS c;
|
|
|