Jackie-Jiang opened a new pull request, #11763: URL: https://github.com/apache/pinot/pull/11763
Currently when literal is single quoted (e.g. 'abc', '123', '1.23'), the type is auto-derived based on the literal itself. Also, it can only derive to big-decimal, timestamp or string but not other numeric types. In Standard SQL (we reference PostgreSQL convention as standard), single quoted literal has unknown type and the type should be resolved based on the context around the literal (read more [here](https://www.postgresql.org/docs/current/typeconv-overview.html)). This PR: - Preserve the literal type, and only resolve the type when the context is clear - Fix the wrong behavior when quoted string is used as number (currently it will be resolved as 0) - Fix `CASE` to follow the PostgreSQL convention (read more [here](https://www.postgresql.org/docs/current/typeconv-union-case.html)), and fix a bug of reading float value as double type -- 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: commits-unsubscr...@pinot.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@pinot.apache.org For additional commands, e-mail: commits-h...@pinot.apache.org
