All issues

Clarification on ANN Support in Turso Database vs Legacy libSQL

#8235

· ziyak97 opened

on Aug 6, 2026

LEFT JOIN emits unmatched rows without applying a WHERE equality that spans both tables

#8231

· LeMikaelF opened

on Aug 5, 2026

LEFT JOIN turned into an INNER JOIN when the WHERE clause reaches the right table only through a correlated subquery

#8230

· LeMikaelF opened

on Aug 5, 2026

Correlated subquery in HAVING is rejected when the query has no GROUP BY

translation/planning

#8229

· LeMikaelF opened

on Aug 5, 2026

FULL JOIN unmatched-side row keeps stale values from earlier tables in a 3+ table chain (and is emitted once per outer row)

#8228

· LeMikaelF opened

on Aug 5, 2026

NOT IN (subquery) is misclassified as null-rejecting, so LEFT JOIN becomes INNER JOIN and NULL-extended rows are lost

#8227

· LeMikaelF opened

on Aug 5, 2026

Hash-join plans evaluate correlated subqueries against unpositioned cursors: NULL scalars, dropped rows, lost UPDATE writes

#8226

· LeMikaelF opened

on Aug 5, 2026

CASE x WHEN y ignores comparison affinity, so the wrong branch is taken

#8225

· LeMikaelF opened

on Aug 5, 2026

MVCC: deterministic scan livelock under concurrent writers + reopen (MvccLazyCursor / SortableIndexKey::compare spins)

#8223

· glommer opened

on Aug 5, 2026

Panic at prepare: correlated EXISTS/NOT EXISTS unnested into a semi/anti-join inside a FROM-less block

#8222

· LeMikaelF opened

on Aug 5, 2026

Subquery in HAVING/ORDER BY reads bare columns from the wrong group's row under GROUP BY

#8221

· LeMikaelF opened

on Aug 5, 2026

FULL OUTER JOIN: WHERE filters on build-side tables run before unmatched-row emission (spurious NULL-extended rows, filter bypassed)

#8220

· LeMikaelF opened

on Aug 5, 2026