Wang Yanlin created CALCITE-3423:
------------------------------------
Summary: Support using CAST operation and bool type value in table
macro
Key: CALCITE-3423
URL: https://issues.apache.org/jira/browse/CALCITE-3423
Project: Calcite
Issue Type: New Feature
Reporter: Wang Yanlin
Currently, using bool type or cast operation in table macro, got exception.
Add the code snippet in *JdbcTest* to reproduce.
{code:java}
// check for cast
resultSet = connection.createStatement().executeQuery(
"select * from table(\"s\".\"Str\"(MAP['a', 1, 'baz', 2], cast(1 as
bigint))) as t(n)");
assertThat(CalciteAssert.toString(resultSet),
equalTo("N={'a'=1, 'baz'=2}\n"
+ "N=1 \n"));
// check for bool type
resultSet = connection.createStatement().executeQuery(
"select * from table(\"s\".\"Str\"(MAP['a', 1, 'baz', 2], true)) as
t(n)");
assertThat(CalciteAssert.toString(resultSet),
equalTo("N={'a'=1, 'baz'=2}\n"
+ "N=true \n"));
// check for nested cast
resultSet = connection.createStatement().executeQuery(
"select * from table(\"s\".\"Str\"(MAP['a', 1, 'baz', 2],"
+ "cast(cast(1 as int) as varchar(1)))) as t(n)");
assertThat(CalciteAssert.toString(resultSet),
equalTo("N={'a'=1, 'baz'=2}\n"
+ "N=1 \n"));
{code}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
