You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@calcite.apache.org by "Soma Mondal (Jira)" <ji...@apache.org> on 2019/09/03 09:52:00 UTC
[jira] [Created] (CALCITE-3318) Preserving CAST of STRING operands
in comparison operator
Soma Mondal created CALCITE-3318:
------------------------------------
Summary: Preserving CAST of STRING operands in comparison operator
Key: CALCITE-3318
URL: https://issues.apache.org/jira/browse/CALCITE-3318
Project: Calcite
Issue Type: Bug
Components: core
Affects Versions: 1.20.0
Reporter: Soma Mondal
We have a REL which has this information
select * from employee where employee_id = cast('12' as float);
but Calcite removes the CAST from the STRING literal('12' in our case).
select * from employee where employee_id = '12';
There are dialects which needs explicit casting in the above case and we need to maintain the CAST in our dialect.
Calcite removes the cast in SqlImplementor's stripCastFromString() method.
I'm thinking of having the dialect intercept this and decide whether or not to remove the cast.
--
This message was sent by Atlassian Jira
(v8.3.2#803003)