0
0
mirror of https://github.com/tursodatabase/libsql.git synced 2025-07-20 04:02:01 +00:00
Files
libsql/libsql-sqlite3/test/fixtures/vtabdistinct.test
2024-05-27 12:59:10 +02:00

16 lines
307 B
Plaintext

SELECT ix FROM qpvtab WHERE vn='sqlite3_vtab_distinct';
SELECT DISTINCT ix FROM qpvtab WHERE vn='sqlite3_vtab_distinct';
SELECT distinct vn, ix FROM qpvtab(3)
WHERE +vn IN ('sqlite3_vtab_distinct','nOrderBy');
SELECT vn, ix FROM qpvtab
GROUP BY vn
HAVING vn='sqlite3_vtab_distinct';