This is an automated email from the ASF dual-hosted git repository. krisztiankasa pushed a commit to branch master in repository https://gitbox.apache.org/repos/asf/hive.git
The following commit(s) were added to refs/heads/master by this push: new ce7a125 HIVE-25818: Values query with order by position clause fails (Krisztian Kasa, reviewed by Zoltan Haindrich) - ADDENDUM: add test ce7a125 is described below commit ce7a1255a80082550f75f5798261d14a8ee84f6a Author: Krisztian Kasa <kk...@cloudera.com> AuthorDate: Thu Jan 6 09:37:37 2022 +0100 HIVE-25818: Values query with order by position clause fails (Krisztian Kasa, reviewed by Zoltan Haindrich) - ADDENDUM: add test --- ql/src/test/queries/clientpositive/order_by_pos.q | 3 ++- ql/src/test/results/clientpositive/llap/order_by_pos.q.out | 10 ++++++++++ 2 files changed, 12 insertions(+), 1 deletion(-) diff --git a/ql/src/test/queries/clientpositive/order_by_pos.q b/ql/src/test/queries/clientpositive/order_by_pos.q index 738fbd5..4ba4a20 100644 --- a/ql/src/test/queries/clientpositive/order_by_pos.q +++ b/ql/src/test/queries/clientpositive/order_by_pos.q @@ -17,4 +17,5 @@ select * from t_n3 union select * from t_n3 order by 1, 2; select * from (select a, count(a) from t_n3 group by a)subq order by 2, 1; select * from (select a,b, count(*) from t_n3 group by a, b)subq order by 3, 2 desc, 1; - + +values(1+1, 2, 5.0, 'a'), (-12, 2, 5.0, 'a'), (100, 2, 5.0, 'a') order by 1 limit 2; diff --git a/ql/src/test/results/clientpositive/llap/order_by_pos.q.out b/ql/src/test/results/clientpositive/llap/order_by_pos.q.out index 496e5b3..6ebb0ab 100644 --- a/ql/src/test/results/clientpositive/llap/order_by_pos.q.out +++ b/ql/src/test/results/clientpositive/llap/order_by_pos.q.out @@ -129,3 +129,13 @@ POSTHOOK: Input: default@t_n3 1 3 1 20 -100 1 1 2 2 +PREHOOK: query: values(1+1, 2, 5.0, 'a'), (-12, 2, 5.0, 'a'), (100, 2, 5.0, 'a') order by 1 limit 2 +PREHOOK: type: QUERY +PREHOOK: Input: _dummy_database@_dummy_table +#### A masked pattern was here #### +POSTHOOK: query: values(1+1, 2, 5.0, 'a'), (-12, 2, 5.0, 'a'), (100, 2, 5.0, 'a') order by 1 limit 2 +POSTHOOK: type: QUERY +POSTHOOK: Input: _dummy_database@_dummy_table +#### A masked pattern was here #### +-12 2 5 a +2 2 5 a