> there’s a test for SELECT SELECT FROM FROM WHERE WHERE AND AND which is comple... | Hacker News

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

spinachsalad 34 days ago | parent | context | favorite | on: I rewrote PostHog's SQL parser, 70x faster, while ...

> there’s a test for SELECT SELECT FROM FROM WHERE WHERE AND AND which is completely valid SQL

Is this even true? I tried it in SQLite and there's a syntax error after first SELECT. It would work when "SELECT", "FROM" etc. are quoted, but that's not the same thing.

charlieflowers 34 days ago [–]

I interpreted it as referring to a table named "FROM" and fields named "SELECT", "WHERE" and "AND".

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