mirror of
https://github.com/tursodatabase/libsql.git
synced 2024-12-15 08:39:46 +00:00
ad79ef48a2
* add tests * add bench
16 lines
307 B
Plaintext
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';
|
|
|