diff options
| author | Vitalii Gridnev <gridnevvvit@gmail.com> | 2024-07-09 19:55:45 +0400 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2024-07-09 19:55:45 +0400 |
| commit | b6d31031437c1bdb9aae56c1cfe0e0d4090cb150 (patch) | |
| tree | e4751074cc65f102b6f527feb09d890c843ec060 | |
| parent | 2bbdb0fa4af03d8cc5fe500489b9d182e476f0e3 (diff) | |
| download | ydb-b6d31031437c1bdb9aae56c1cfe0e0d4090cb150.tar.gz | |
canonize window tests & add order by to the query (#6478)
2 files changed, 9 insertions, 9 deletions
diff --git a/ydb/tests/functional/suite_tests/canondata/test_stream_query.TestStreamQuery.test_sql_suite_results-window.test_/window.test.out b/ydb/tests/functional/suite_tests/canondata/test_stream_query.TestStreamQuery.test_sql_suite_results-window.test_/window.test.out index feece341720..e51b92410ea 100644 --- a/ydb/tests/functional/suite_tests/canondata/test_stream_query.TestStreamQuery.test_sql_suite_results-window.test_/window.test.out +++ b/ydb/tests/functional/suite_tests/canondata/test_stream_query.TestStreamQuery.test_sql_suite_results-window.test_/window.test.out @@ -21,7 +21,7 @@ SELECT depname, empno, salary, sum(salary) OVER w FROM empsalary WINDOW w AS (PA --!syntax_v1 pragma TablePathPrefix = "/Root/stream_query_window.test_results"; pragma SimpleColumns; -SELECT depname, empno, salary, rank() OVER w FROM empsalary WINDOW w AS (PARTITION BY depname ORDER BY salary) ORDER BY salary, depname; +SELECT depname, empno, salary, rank() OVER w FROM empsalary WINDOW w AS (PARTITION BY depname ORDER BY salary) ORDER BY salary, depname, empno; depname | empno | salary | column3 --------------+-------+--------+--------- @@ -29,8 +29,8 @@ SELECT depname, empno, salary, rank() OVER w FROM empsalary WINDOW w AS (PARTITI b'personnel' | 2 | 3900 | 2 b'develop' | 7 | 4200 | 1 b'develop' | 9 | 4500 | 2 - b'sales' | 4 | 4800 | 1 b'sales' | 3 | 4800 | 1 + b'sales' | 4 | 4800 | 1 b'sales' | 1 | 5000 | 3 b'develop' | 10 | 5200 | 3 b'develop' | 11 | 5200 | 3 @@ -92,19 +92,19 @@ SELECT depname, empno, salary, sum(salary) OVER w FROM empsalary WINDOW w AS (PA --!syntax_v1 pragma TablePathPrefix = "/Root/stream_query_window.test_results"; pragma SimpleColumns; -SELECT depname, empno, salary, rank() OVER w AS r FROM empsalary WINDOW w AS (PARTITION BY depname ORDER BY salary) ORDER BY r; +SELECT depname, empno, salary, rank() OVER w AS r FROM empsalary WINDOW w AS (PARTITION BY depname ORDER BY salary) ORDER BY r, empno; depname | empno | salary | r --------------+-------+--------+--- - b'develop' | 7 | 4200 | 1 - b'sales' | 4 | 4800 | 1 b'sales' | 3 | 4800 | 1 + b'sales' | 4 | 4800 | 1 b'personnel' | 5 | 3500 | 1 + b'develop' | 7 | 4200 | 1 b'personnel' | 2 | 3900 | 2 b'develop' | 9 | 4500 | 2 - b'develop' | 11 | 5200 | 3 - b'develop' | 10 | 5200 | 3 b'sales' | 1 | 5000 | 3 + b'develop' | 10 | 5200 | 3 + b'develop' | 11 | 5200 | 3 b'develop' | 8 | 6000 | 5 (10 rows) diff --git a/ydb/tests/functional/suite_tests/stream_query/window.test b/ydb/tests/functional/suite_tests/stream_query/window.test index 29a63a2a2eb..976cab43961 100644 --- a/ydb/tests/functional/suite_tests/stream_query/window.test +++ b/ydb/tests/functional/suite_tests/stream_query/window.test @@ -54,7 +54,7 @@ statement stream query SELECT depname, empno, salary, sum(salary) OVER w FROM empsalary WINDOW w AS (PARTITION BY depname) ORDER BY depname, salary; statement stream query -SELECT depname, empno, salary, rank() OVER w FROM empsalary WINDOW w AS (PARTITION BY depname ORDER BY salary) ORDER BY salary, depname; +SELECT depname, empno, salary, rank() OVER w FROM empsalary WINDOW w AS (PARTITION BY depname ORDER BY salary) ORDER BY salary, depname, empno; -- with GROUP BY statement stream query @@ -65,7 +65,7 @@ statement stream query SELECT depname, empno, salary, sum(salary) OVER w FROM empsalary WINDOW w AS (PARTITION BY depname) ORDER BY depname, salary, empno; statement stream query -SELECT depname, empno, salary, rank() OVER w AS r FROM empsalary WINDOW w AS (PARTITION BY depname ORDER BY salary) ORDER BY r; +SELECT depname, empno, salary, rank() OVER w AS r FROM empsalary WINDOW w AS (PARTITION BY depname ORDER BY salary) ORDER BY r, empno; -- empty window specification statement stream query |