0
0
mirror of https://github.com/tursodatabase/libsql.git synced 2024-12-15 08:39:46 +00:00
libsql/libsql-wal/tests/assets/fixtures/vtabdistinct.test
ad hoc ad79ef48a2
libsql wal tests (#1408)
* add tests

* add bench
2024-05-24 13:59:17 +00: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';