Cannot parse select 1 in ()

[adriangb]

I'm not sure if this should parse, Postgres for example also fails, but if possible it would be nice if this at least parsed if not executed correctly.

I tested this in datafusion-cli, but originally found it using Rust:

> SELECT 1 in ();  🤔 Invalid statement: sql parser error: Expected: an expression:, found: )

[git-hulk]

@alamb @iffyio The empty () should be disallowed in many dialects, but I'm not sure if it's good to add an option to allow this in the SQL parser. This seems reasonable from my side since this behavior can be determined by the downstream, and what we should guarantee is that it won't break the old behavior.

[iffyio]

Ah is the In () syntax supported by some of the current dialects we mean or?

[alamb]

Possibly some good guidelines: https://github.com/apache/datafusion-sqlparser-rs?tab=readme-ov-file#syntax-vs-semantics