[ https://issues.apache.org/jira/browse/CALCITE-3318?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Danny Chen updated CALCITE-3318: -------------------------------- Summary: Preserving CAST of VARCHAR operand in binary comparison for BigQuery (was: Preserving CAST of STRING operands in comparison operator) > Preserving CAST of VARCHAR operand in binary comparison for BigQuery > -------------------------------------------------------------------- > > 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 > Assignee: Danny Chen > Priority: Major > Labels: pull-request-available > Fix For: 1.22.0 > > Time Spent: 5h 40m > Remaining Estimate: 0h > > 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. > > I have created a PR [https://github.com/apache/calcite/pull/1437] -- This message was sent by Atlassian Jira (v8.3.4#803005)