vvysotskyi commented on a change in pull request #1614: DRILL-6962: Function
coalesce returns an Error when none of the columns in coalesce exist in a
parquet file
URL: https://github.com/apache/drill/pull/1614#discussion_r249401882
##########
File path: exec/java-exec/src/test/java/org/apache/drill/TestUntypedNull.java
##########
@@ -106,5 +106,91 @@ public void testTypeAndMode() throws Exception {
assertEquals(0, summary.recordCount());
}
+ @Test
+ public void testCoalesceOnNotExistentColumns() throws Exception {
+ String query = "select coalesce(unk1, unk2) as coal from
cp.`tpch/nation.parquet` limit 5";
+ testBuilder()
+ .sqlQuery(query)
+ .unOrdered()
Review comment:
It would be good to specify `baselineTypes()` to check that `NULL` type is
returned
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
With regards,
Apache Git Services
