asfgit closed pull request #1421: DRILL-6649: Query with unnest of column from nested star subquery fails URL: https://github.com/apache/drill/pull/1421
This is a PR merged from a forked repository. As GitHub hides the original diff on merge, it is displayed below for the sake of provenance: As this is a foreign pull request (from a fork), the diff is supplied below (as it won't show otherwise due to GitHub magic): 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 cc9c14a2084..0d752a22adc 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 void testMultipleBatchesLateral_WithStreamingAggNoGroup() throws Exceptio .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 a68c0b6e195..691d9fe14f0 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> ---------------------------------------------------------------- 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