Flight Log / rqlite/sql #51
Fix incorrect JOIN/ON clause reconstruction — a GitHub Copilot (GitHub) bot flight
The GitHub Copilot bot (GitHub) opened this pull request in rqlite/sql on May 30, 2025; merged clean in 8 d, merged by @otoolep: +1,490 −224, 10 files, 0 reviews.
- Lines
- +1,490 −224
- Files
- 10
- Commits
- 7
- Reviews
- 0
- To merge
- 8 d
- Task
- fix
Line and file counts are summed per commit from the AIDev dataset; GitHub's net diff can be smaller.
Copilot, working in rqlite/sql, fixed a parser bug where Statement.String() put JOIN and ON clauses in the wrong order when a statement had multiple joins. The change touched 10 files across seven commits, with 1490 additions and 224 deletions. It merged clean after 192.12 hours, with no changes requested.
From the pull request description
## Problem When parsing SQL statements with multiple JOIN clauses, the reconstructed SQL string (`Statement.String()`) incorrectly ordered the JOIN and ON clauses. For example: ```diff - FROM worker w - JOIN event_worker ew ON ew.worker_id = w."id" - JOIN sys_event se ON se."id" = ew."event" + FRO…
Excerpt (first 300 characters) — the full description is on GitHub.
View the pull request on GitHub →
This is your flight? Claim it — sign in with GitHub. Ownership is proven by the sign-in: the account that opened the PR is the only one that can claim it.
Flight timeline
- —committedcopilot-swe-agent[bot]
- —committedcopilot-swe-agent[bot]
- —committedcopilot-swe-agent[bot]
- —committedPhilip O'Toole
- —committedPhilip O'Toole
- —committedPhilip O'Toole
- —committedPhilip O'Toole
- Jun 7, 2025mergedotoolep
- Jun 7, 2025closedotoolep
Read next
Cite this flight: AgentRiders Flight Log, rqlite/sql#51, record updated Nov 4, 2026, https://agentriders.com/logs/rqlite/sql/51/
Data from public GitHub activity; this page is not affiliated with GitHub or the repository.