IMPALA-7022: TestQueries.test_subquery: Subquery must not return more than one row
TestQueries.test_subquery sometimes fails during exhaustive tests. In the tests we expect to catch an exception that is prefixed by the "Query aborted:" string. The prefix is usually added by impala_beeswax.py::wait_for_completion(), but in rare cases it isn't added. >From the point of the test it is irrelevant if the exception is prefixed with "Query aborted:" or not, so I removed it from the expected exception string. Change-Id: I3b8655ad273b1dd7a601099f617db609e4a4797b Reviewed-on: http://gerrit.cloudera.org:8080/10407 Reviewed-by: Tim Armstrong <[email protected]> Tested-by: Tim Armstrong <[email protected]> Project: http://git-wip-us.apache.org/repos/asf/impala/repo Commit: http://git-wip-us.apache.org/repos/asf/impala/commit/bee907c5 Tree: http://git-wip-us.apache.org/repos/asf/impala/tree/bee907c5 Diff: http://git-wip-us.apache.org/repos/asf/impala/diff/bee907c5 Branch: refs/heads/2.x Commit: bee907c5fce6a7f3499b45bd13aa7815ccbb27d8 Parents: 0e6117b Author: Zoltan Borok-Nagy <[email protected]> Authored: Tue May 15 15:47:29 2018 +0200 Committer: Impala Public Jenkins <[email protected]> Committed: Wed May 16 10:10:18 2018 +0000 ---------------------------------------------------------------------- .../functional-query/queries/QueryTest/subquery.test | 8 ++++---- 1 file changed, 4 insertions(+), 4 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/impala/blob/bee907c5/testdata/workloads/functional-query/queries/QueryTest/subquery.test ---------------------------------------------------------------------- diff --git a/testdata/workloads/functional-query/queries/QueryTest/subquery.test b/testdata/workloads/functional-query/queries/QueryTest/subquery.test index 2d691ed..df1be9a 100644 --- a/testdata/workloads/functional-query/queries/QueryTest/subquery.test +++ b/testdata/workloads/functional-query/queries/QueryTest/subquery.test @@ -929,7 +929,7 @@ WHERE int_col = ORDER BY id ---- RESULTS ---- CATCH -Query aborted:Subquery must not return more than one row: +Subquery must not return more than one row: ==== ---- QUERY # Uncorrelated subquery in arithmetic expr that returns multiple rows @@ -940,7 +940,7 @@ WHERE int_col = ORDER BY id ---- RESULTS ---- CATCH -Query aborted:Subquery must not return more than one row: +Subquery must not return more than one row: ==== ---- QUERY # Uncorrelated subquery in binary predicate that returns scalar value at runtime @@ -1000,7 +1000,7 @@ SELECT a FROM (values(1 a),(2),(3)) v WHERE a = (SELECT x FROM (values(1 x),(2),(3)) v) ---- RESULTS ---- CATCH -Query aborted:Subquery must not return more than one row: +Subquery must not return more than one row: ==== ---- QUERY # Subquery that returns more than one row @@ -1009,7 +1009,7 @@ SELECT id FROM functional.alltypes WHERE id = (SELECT bigint_col FROM functional.alltypes_view) ---- RESULTS ---- CATCH -Query aborted:Subquery must not return more than one row: SELECT bigint_col FROM functional.alltypes_view +Subquery must not return more than one row: SELECT bigint_col FROM functional.alltypes_view ==== ---- QUERY # Runtime scalar subquery with offset.
