Fuzzer: add ORDER BY DESC / multi-column / positional coverage
Nobody has claimed this yet.
Assessment
- Difficulty
- 2/5
- Estimated time
- 1-3 hours
- Newbie friendliness
- 87/100
Research direction
Start with bench/query_fuzz.sh, especially emit_projection, emit_limit_offset, and the kind_roll dispatch in the BEGIN block; consult the README's SQL Reference for the supported ORDER BY forms. Add generated coverage for DESC, multi-column, and positional ORDER BY, then run ./bench/query_fuzz.sh --seed 1 --count 3000 with DuckDB on PATH and a built csvql binary.
Written by the indexing model from the issue text.
Description
bench/query_fuzz.sh's generated queries always sort with a bare `ORDER BY id` (see emit_projection/emit_limit_offset in the script) — DESC, multi-column ORDER BY, and positional (`ORDER BY 1`) are all supported SQL features (see README's SQL Reference) but never exercised by the differential fuzzer against DuckDB.
Good starting point for getting familiar with the generator: the script is heavily commented, and adding a new query shape is adding one new emit_* awk function plus a new branch in the kind_roll dispatch at the top of the BEGIN block — see emit_limit_offset for a recent, well-commented example of exactly this pattern.
Test with: ./bench/query_fuzz.sh --seed 1 --count 3000 (needs duckdb on PATH and a built csvql binary).
- Dominant language
- Zig
- Stars
- 27
- Forks
- 5
- Avg merge
- 11h 53m
- Merged PRs (30d)
- 14
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
More from melihbirim/csvql
-
enhancement good first issue
Difficulty 2/5 1-3 hours Newbie friendliness 84/100
melihbirim/csvql#162 ·
-
enhancement good first issue
Difficulty 2/5 1-3 hours Newbie friendliness 88/100
melihbirim/csvql#157 ·
-
enhancement good first issue
Difficulty 2/5 1-3 hours Newbie friendliness 82/100
melihbirim/csvql#73 ·
-
Difficulty 4/5 3-5 days Newbie friendliness 50/100
melihbirim/csvql#176 · 2 comments ·
-
Difficulty 4/5 3-5 days Newbie friendliness 65/100
melihbirim/csvql#170 ·
All issues in melihbirim/csvql
Similar issues
-
bug
Difficulty 2/5 1-3 hours Newbie friendliness 88/100
-
from:qa priority:P2 reliability tech-debt
Difficulty 2/5 1-3 hours Newbie friendliness 78/100
spec-kitty/spec-kitty#4874 ·
-
0. Needs triage bug
Difficulty 2/5 1-3 hours Newbie friendliness 78/100
nextcloud/fulltextsearch#1011 ·
-
automation code-quality cookie deep-report documentation improvement quick-win task-mining
Difficulty 1/5 Under an hour Newbie friendliness 88/100
-
Difficulty 2/5 1-3 hours Newbie friendliness 62/100