srielau commented on PR #45593: URL: https://github.com/apache/spark/pull/45593#issuecomment-2093902007
> Sorry for being late, @MaxGekk . > > * Is this ANSI SQL syntax? > * Do you have any reference for this syntax in other references? I only know of this for the SELECT list, where it is popularized by duckDB and now Snowflake. This is NOT ANSI SQL syntax and I'm not in favor of starting down this path for two reasons: 1. This will increase pressure on trailing commas in SELECT which we cannot do without a hard breaking change 2. Generally I think "nothing" after a comma is associated with an unset value (i.e. a NULL). E.g. (,,) should, if we were to support this be parsed as (NULL, NULL, NULL). -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: reviews-unsubscr...@spark.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: reviews-unsubscr...@spark.apache.org For additional commands, e-mail: reviews-h...@spark.apache.org
