That's exactly what I have done with diffing SQL in lazy mode - just use a serve... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

		hobs on March 21, 2024 \| parent \| context \| favorite \| on: Difftastic, a structural diff tool that understand... That's exactly what I have done with diffing SQL in lazy mode - just use a server and diff the AST/plan.

slotrans on March 21, 2024 [–]

Two semantically equivalent SQL statements can plan differently...

rrrrrrrrrrrryan on March 21, 2024 | | [–]

The exact same SQL statement can plan differently if table statistics change.

hobs on March 21, 2024 | | [–]

Absolutely and for this case a different plan mattered.

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact