yanlin-Lynn commented on a change in pull request #1516: [CALCITE-3423] Support
using CAST operation and BOOLEAN type value in table macro
URL: https://github.com/apache/calcite/pull/1516#discussion_r342926688
##########
File path: core/src/test/java/org/apache/calcite/test/JdbcTest.java
##########
@@ -461,6 +464,43 @@ private static String q(String s) {
connection.close();
}
+ /**
+ * <p>Test case for
+ * <a
href="https://issues.apache.org/jira/browse/CALCITE-3423";>[CALCITE-3423]
+ * Support using CAST operation and BOOLEAN type value in table macro</a>. */
+ @Test public void testTableMacroWithCastOrBoolean() throws SQLException {
+ Connection connection =
+ DriverManager.getConnection("jdbc:calcite:");
+ addTableMacro(connection, Smalls.STR_METHOD);
+ // check for cast
+ ResultSet 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 Boolean 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"));
+
+ resultSet = connection.createStatement().executeQuery(
Review comment:
Sure, I'll update the PR soon.
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
[email protected]
With regards,
Apache Git Services
