Unverified Proof shown
A FarmBot cross join that re-uploaded every point fixed
A contributor used Claude Code to fix a cross join in FarmBot OS that made one changed point trigger a re-upload of every point in the table.
—
Credits
- Source byline tencur Source ↗
Earliest dated source:
The full story
A query in FarmBot OS joined a subquery with a condition that was always true, making a cross join. As soon as any record was marked dirty, every row in the table was returned and re-uploaded with its full body.
A contributor used Claude Code to fix the join and added a test: with three points and one marked dirty, only that one is returned. They asked for CI confirmation, as they couldn't run the tests locally.
How it was done
Tools
Themes
Loading themes…
Sources
From the maker's own write-up or code. We summarise what they report; we haven't tested it ourselves.
- FarmBot on GitHub: Fix cross join in Private.list_meta_status: one dirty point no longer re-uploads every pointSource byline: tencurPublished
The pull request on GitHub.