0
0
mirror of https://github.com/tursodatabase/libsql.git synced 2025-07-23 12:11:46 +00:00
Files
libsql/libsql-sqlite3/test/fixtures/tkt-91e2e8ba6f.test
2024-05-27 12:59:10 +02:00

26 lines
546 B
Plaintext

CREATE TABLE t1(x INTEGER, y REAL);
INSERT INTO t1 VALUES(11, 11);
SELECT x/10, y/10 FROM t1;
SELECT x/10, y/10 FROM (SELECT * FROM t1);
SELECT x/10, y/10 FROM (SELECT * FROM t1 LIMIT 5 OFFSET 0);
SELECT x/10, y/10 FROM (SELECT * FROM t1 LIMIT 5 OFFSET 0) LIMIT 5 OFFSET 0;
SELECT a.x/10, a.y/10 FROM
(SELECT * FROM t1 LIMIT 5 OFFSET 0) AS a, t1 AS b WHERE a.x = b.x
LIMIT 5 OFFSET 0;
CREATE VIEW v1 AS SELECT * FROM t1 LIMIT 5;
SELECT a.x/10, a.y/10 FROM v1 AS a, t1 AS b WHERE a.x = b.x LIMIT 5 OFFSET 0;