This is an automated email from the ASF dual-hosted git repository. vitalii pushed a commit to branch master in repository https://gitbox.apache.org/repos/asf/drill.git
commit 9a90164ceedc65f33e3a01d3e55282d19de8009b Author: Volodymyr Vysotskyi <vvo...@gmail.com> AuthorDate: Thu Jul 26 16:04:10 2018 +0300 DRILL-6649: Query with unnest of column from nested star subquery fails closes #1421 --- .../impl/lateraljoin/TestE2EUnnestAndLateral.java | 16 ++++++++++++++++ pom.xml | 2 +- 2 files changed, 17 insertions(+), 1 deletion(-) diff --git a/exec/java-exec/src/test/java/org/apache/drill/exec/physical/impl/lateraljoin/TestE2EUnnestAndLateral.java b/exec/java-exec/src/test/java/org/apache/drill/exec/physical/impl/lateraljoin/TestE2EUnnestAndLateral.java index cc9c14a..0d752a2 100644 --- a/exec/java-exec/src/test/java/org/apache/drill/exec/physical/impl/lateraljoin/TestE2EUnnestAndLateral.java +++ b/exec/java-exec/src/test/java/org/apache/drill/exec/physical/impl/lateraljoin/TestE2EUnnestAndLateral.java @@ -607,4 +607,20 @@ public class TestE2EUnnestAndLateral extends ClusterTest { .build().run(); } + @Test + public void testUnnestNestedStarSubquery() throws Exception { + String sql = "select t2.o.o_id o_id\n" + + "from (select * from cp.`lateraljoin/nested-customer.json` limit 1) t,\n" + + "unnest(t.orders) t2(o)"; + + testBuilder() + .sqlQuery(sql) + .unOrdered() + .baselineColumns("o_id") + .baselineValues(1L) + .baselineValues(2L) + .baselineValues(3L) + .go(); + } + } diff --git a/pom.xml b/pom.xml index a68c0b6..691d9fe 100644 --- a/pom.xml +++ b/pom.xml @@ -45,7 +45,7 @@ <dep.guava.version>18.0</dep.guava.version> <forkCount>2</forkCount> <parquet.version>1.10.0</parquet.version> - <calcite.version>1.16.0-drill-r6</calcite.version> + <calcite.version>1.16.0-drill-r7</calcite.version> <avatica.version>1.11.0</avatica.version> <janino.version>2.7.6</janino.version> <sqlline.version>1.1.9-drill-r7</sqlline.version>