tursodatabase/turso
BETWEEN Expression Evaluates Left Side Twice
Ouverte
#5 152 ouverte le 11 févr. 2026
good first issueperformancequery planner
Métriques du dépôt
- Stars
- (19 103 étoiles)
- Métriques de merge PR
- (Merge moyen 2j 11h) (147 PRs mergées en 30 j)
Description
Description
BETWEEN expressions evaluate the left side twice per row.
Reproducer
CREATE TABLE t(id INTEGER PRIMARY KEY);
INSERT INTO t VALUES(1), (2), (3);
SELECT id FROM t WHERE (SELECT max(id) FROM t) BETWEEN 1 AND 3;
-- Subquery executed twice per row
core/translate/expr.rs:4025-4048 - BETWEEN expands to two comparisons, each calling translate_expr(left).
This issue brought to you by Mikaël and Claude Code.