-
Notifications
You must be signed in to change notification settings - Fork 0
Open
Labels
priority:mediumShould be done soonShould be done soonsize:sSmall — 1 to 4 hoursSmall — 1 to 4 hoursstatus:readyRefined and ready for sprint selectionRefined and ready for sprint selectiontype:featureNew functionalityNew functionality
Description
Part of #69
Depends on #92 (chunked CSV reading)
Description
In streaming mode, some SQL operations require seeing the full dataset before producing output (e.g. unbounded ORDER BY, certain JOINs). Detect these cases and emit a clear error or warning instead of silently producing wrong or truncated results.
Acceptance Criteria
- Queries with unbounded
ORDER BYin--streammode emit a clear error message - Queries with multi-table JOINs that aren't supported in streaming mode emit a clear error
- Error message explains the limitation and suggests removing
--streamor rewriting the query - Safe queries (WHERE, LIMIT, bounded GROUP BY) pass validation without warnings
- Validation runs before any data is processed (fail fast)
Notes
- Parse the query AST or use SQLite's EXPLAIN to detect full-scan operations
- Keep the validator conservative: false positives (blocking a safe query) are better than false negatives (silently wrong output)
Reactions are currently unavailable
Metadata
Metadata
Assignees
Labels
priority:mediumShould be done soonShould be done soonsize:sSmall — 1 to 4 hoursSmall — 1 to 4 hoursstatus:readyRefined and ready for sprint selectionRefined and ready for sprint selectiontype:featureNew functionalityNew functionality