This will produce broken SQL on empty clauses list. Very strange. | Hacker News

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

		egormakarov on Sept 25, 2024 \| parent \| context \| favorite \| on: SQL Tips and Tricks This will produce broken SQL on empty clauses list. Very strange.

freilanzer on Sept 26, 2024 [–]

You're quite right, but this is easily fixed. That doesn't change my question, since something like this is much easier that the other logic.

paperplatter on Sept 26, 2024 | [–]

The easiest fix for this is the "WHERE 1=1" or "WHERE true"

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