Lindsey Meyer created CALCITE-3468:
--------------------------------------
Summary: Oracle cast to varchar does not use precision when it
should
Key: CALCITE-3468
URL: https://issues.apache.org/jira/browse/CALCITE-3468
Project: Calcite
Issue Type: Improvement
Reporter: Lindsey Meyer
We're trying to cast a node to a varchar with something like this:
{noformat}
relBuilder.cast(node, SqlTypeName.VARCHAR)
{noformat}
And in Oracle SQL, this generates sql like
{noformat}
CAST(node AS VARCHAR){noformat}
which is incorrect. Oracle can only have VARCHAR types with an explicit
precision.
Looking at the code, it _seems_ like this should work with Oracle, so I'm not
really sure what's going on here
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
