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/fab65d44 Tree: http://git-wip-us.apache.org/repos/asf/impala/tree/fab65d44 Diff: http://git-wip-us.apache.org/repos/asf/impala/diff/fab65d44 Branch: refs/heads/master Commit: fab65d44792f5a5effcb6f26f08c6ad865c4b64a Parents: 4fab428 Author: Zoltan Borok-Nagy <[email protected]> Authored: Tue May 15 15:47:29 2018 +0200 Committer: Tim Armstrong <[email protected]> Committed: Tue May 15 23:37:06 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/fab65d44/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.
