vrajat opened a new pull request, #13650:
URL: https://github.com/apache/pinot/pull/13650
Apache Calcite allows implicit cast from VARCHAR to INT. The implicit cast
may surprise users with a Runtime Exception if some of the rows cannot be
parsed or to unexpected results if parsing is unintentionally successful.
As the intention is to keep the multi-stage engine strongly typed, this PR
disables implicit casts from VARCHAR to INT.
Postgres also does not allow this implicit cast.
```
postgres=# select * from str;
str
-----
1
a
100
(3 rows)
postgres=# select * from str where str > 10;
ERROR: operator does not exist: character varying > integer
LINE 1: select * from str where str > 10;
^
HINT: No operator matches the given name and argument types. You might need
to add explicit type casts.
```
tags: multi-stage, release notes
--
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
