Document status - Confidential

Copyright 2022, Altinity Inc.. All Rights Reserved. All information contained herein is, and remains the property of Altinity Inc.. Any dissemination of this information or reproduction of this material is strictly forbidden unless prior written permission is obtained from Altinity Inc..

Window Functions Test Run Report

Date	Jul 19, 2022 12:20
Duration	2m 48s
Framework	TestFlows 1.9.220712.1163352

Artifacts

Test artifacts can be found at https://gitlab.com/altinity-qa/clickhouse/cicd/release/-/jobs/2739540949/artifacts/browse

Attributes

project	altinity-qa/clickhouse/cicd/release
project.id	22089296
user.name	Andrey Zvonov
user.email	zvonov.andrey@gmail.com
version	22.3.8.40
repository	https://github.com/Altinity/ClickHouse.git
job.id	2739540949
job.url	https://gitlab.com/altinity-qa/clickhouse/cicd/release/-/jobs/2739540949
stress	False
local	True
clickhouse_version	None
clickhouse_binary_path	/usr/bin/clickhouse

Summary

47.6%OK

2.7%Known

49.5%Fail

Statistics

	Units	Skip	OK	Fail	XFail
Modules	1			1
Suites	39	2	32	5
Features	39	2	32	5
Scenarios	430		390	10	30
Checks	200		20	180
Examples	1330		497	808	25
Steps	6963		6067	896

Fails

Test Name	Result	Message
/window functions	Fail 2m 48s	AssertionError Traceback (most recent call last): File "regression/window_functions/regression.py", line 203, in regression() File "regression/window_functions/regression.py", line 199, in regression Feature(run=load("window_functions.tests.feature", "feature"), flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/feature.py", line 71, in feature Feature(run=load("window_functions.tests.order_clause", "feature"), flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/order_clause.py", line 236, in feature Scenario(run=scenario, flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/order_clause.py", line 207, in by_expr_with_aggregates execute_query( File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/common.py", line 144, in execute_query r = current().context.node.query( File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../helpers/cluster.py", line 641, in query assert False, error(r.output) AssertionError: Oops! Assertion failed The following assertion was not satisfied assert False, error(r.output) Description Received exception from server (version 22.3.8): Code: 47. DB::Exception: Received from localhost:9000. DB::Exception: Unknown identifier: sum(unique1); there are columns: unique1, unique2, ten: While processing sum(unique1) + sum(unique2) ASC. (UNKNOWN_IDENTIFIER) (query: select ten, sum(unique1) + sum(unique2) as res, rank() over (order by sum(unique1) + sum(unique2)) as rank from tenk1 group by ten order by ten FORMAT TabSeparatedWithNames ) Assertion values assert False, error(r.output) ^ is False Where File '/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../helpers/cluster.py', line 641 in 'query' 633\\| ) if steps else NullStep(): 634\\| assert message in r.output, error(r.output) 635\\| 636\\| if message is None or "Exception:" not in message: 637\\| with Then("check if output has exception") if steps else NullStep(): 638\\| if "Exception:" in r.output: 639\\| if raise_on_exception: 640\\| raise QueryRuntimeException(r.output) 641\\|> assert False, error(r.output) 642\\| 643\\| return r 644\\|
/window functions/tests	Fail 2m 18s	AssertionError Traceback (most recent call last): File "regression/window_functions/regression.py", line 203, in regression() File "regression/window_functions/regression.py", line 199, in regression Feature(run=load("window_functions.tests.feature", "feature"), flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/feature.py", line 71, in feature Feature(run=load("window_functions.tests.order_clause", "feature"), flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/order_clause.py", line 236, in feature Scenario(run=scenario, flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/order_clause.py", line 207, in by_expr_with_aggregates execute_query( File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/common.py", line 144, in execute_query r = current().context.node.query( File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../helpers/cluster.py", line 641, in query assert False, error(r.output) AssertionError: Oops! Assertion failed The following assertion was not satisfied assert False, error(r.output) Description Received exception from server (version 22.3.8): Code: 47. DB::Exception: Received from localhost:9000. DB::Exception: Unknown identifier: sum(unique1); there are columns: unique1, unique2, ten: While processing sum(unique1) + sum(unique2) ASC. (UNKNOWN_IDENTIFIER) (query: select ten, sum(unique1) + sum(unique2) as res, rank() over (order by sum(unique1) + sum(unique2)) as rank from tenk1 group by ten order by ten FORMAT TabSeparatedWithNames ) Assertion values assert False, error(r.output) ^ is False Where File '/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../helpers/cluster.py', line 641 in 'query' 633\\| ) if steps else NullStep(): 634\\| assert message in r.output, error(r.output) 635\\| 636\\| if message is None or "Exception:" not in message: 637\\| with Then("check if output has exception") if steps else NullStep(): 638\\| if "Exception:" in r.output: 639\\| if raise_on_exception: 640\\| raise QueryRuntimeException(r.output) 641\\|> assert False, error(r.output) 642\\| 643\\| return r 644\\|
/window functions/tests/non distributed	Fail 1m 6s	AssertionError Traceback (most recent call last): File "regression/window_functions/regression.py", line 203, in regression() File "regression/window_functions/regression.py", line 199, in regression Feature(run=load("window_functions.tests.feature", "feature"), flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/feature.py", line 71, in feature Feature(run=load("window_functions.tests.order_clause", "feature"), flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/order_clause.py", line 236, in feature Scenario(run=scenario, flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/order_clause.py", line 207, in by_expr_with_aggregates execute_query( File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/common.py", line 144, in execute_query r = current().context.node.query( File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../helpers/cluster.py", line 641, in query assert False, error(r.output) AssertionError: Oops! Assertion failed The following assertion was not satisfied assert False, error(r.output) Description Received exception from server (version 22.3.8): Code: 47. DB::Exception: Received from localhost:9000. DB::Exception: Unknown identifier: sum(unique1); there are columns: unique1, unique2, ten: While processing sum(unique1) + sum(unique2) ASC. (UNKNOWN_IDENTIFIER) (query: select ten, sum(unique1) + sum(unique2) as res, rank() over (order by sum(unique1) + sum(unique2)) as rank from tenk1 group by ten order by ten FORMAT TabSeparatedWithNames ) Assertion values assert False, error(r.output) ^ is False Where File '/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../helpers/cluster.py', line 641 in 'query' 633\\| ) if steps else NullStep(): 634\\| assert message in r.output, error(r.output) 635\\| 636\\| if message is None or "Exception:" not in message: 637\\| with Then("check if output has exception") if steps else NullStep(): 638\\| if "Exception:" in r.output: 639\\| if raise_on_exception: 640\\| raise QueryRuntimeException(r.output) 641\\|> assert False, error(r.output) 642\\| 643\\| return r 644\\|
/window functions/tests/non distributed/order clause	Fail 386ms	AssertionError Traceback (most recent call last): File "regression/window_functions/regression.py", line 203, in regression() File "regression/window_functions/regression.py", line 199, in regression Feature(run=load("window_functions.tests.feature", "feature"), flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/feature.py", line 71, in feature Feature(run=load("window_functions.tests.order_clause", "feature"), flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/order_clause.py", line 236, in feature Scenario(run=scenario, flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/order_clause.py", line 207, in by_expr_with_aggregates execute_query( File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/common.py", line 144, in execute_query r = current().context.node.query( File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../helpers/cluster.py", line 641, in query assert False, error(r.output) AssertionError: Oops! Assertion failed The following assertion was not satisfied assert False, error(r.output) Description Received exception from server (version 22.3.8): Code: 47. DB::Exception: Received from localhost:9000. DB::Exception: Unknown identifier: sum(unique1); there are columns: unique1, unique2, ten: While processing sum(unique1) + sum(unique2) ASC. (UNKNOWN_IDENTIFIER) (query: select ten, sum(unique1) + sum(unique2) as res, rank() over (order by sum(unique1) + sum(unique2)) as rank from tenk1 group by ten order by ten FORMAT TabSeparatedWithNames ) Assertion values assert False, error(r.output) ^ is False Where File '/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../helpers/cluster.py', line 641 in 'query' 633\\| ) if steps else NullStep(): 634\\| assert message in r.output, error(r.output) 635\\| 636\\| if message is None or "Exception:" not in message: 637\\| with Then("check if output has exception") if steps else NullStep(): 638\\| if "Exception:" in r.output: 639\\| if raise_on_exception: 640\\| raise QueryRuntimeException(r.output) 641\\|> assert False, error(r.output) 642\\| 643\\| return r 644\\|
/window functions/tests/non distributed/order clause/by expr with aggregates	Fail 54ms	AssertionError Traceback (most recent call last): File "regression/window_functions/regression.py", line 203, in regression() File "regression/window_functions/regression.py", line 199, in regression Feature(run=load("window_functions.tests.feature", "feature"), flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/feature.py", line 71, in feature Feature(run=load("window_functions.tests.order_clause", "feature"), flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/order_clause.py", line 236, in feature Scenario(run=scenario, flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/order_clause.py", line 207, in by_expr_with_aggregates execute_query( File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/common.py", line 144, in execute_query r = current().context.node.query( File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../helpers/cluster.py", line 641, in query assert False, error(r.output) AssertionError: Oops! Assertion failed The following assertion was not satisfied assert False, error(r.output) Description Received exception from server (version 22.3.8): Code: 47. DB::Exception: Received from localhost:9000. DB::Exception: Unknown identifier: sum(unique1); there are columns: unique1, unique2, ten: While processing sum(unique1) + sum(unique2) ASC. (UNKNOWN_IDENTIFIER) (query: select ten, sum(unique1) + sum(unique2) as res, rank() over (order by sum(unique1) + sum(unique2)) as rank from tenk1 group by ten order by ten FORMAT TabSeparatedWithNames ) Assertion values assert False, error(r.output) ^ is False Where File '/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../helpers/cluster.py', line 641 in 'query' 633\\| ) if steps else NullStep(): 634\\| assert message in r.output, error(r.output) 635\\| 636\\| if message is None or "Exception:" not in message: 637\\| with Then("check if output has exception") if steps else NullStep(): 638\\| if "Exception:" in r.output: 639\\| if raise_on_exception: 640\\| raise QueryRuntimeException(r.output) 641\\|> assert False, error(r.output) 642\\| 643\\| return r 644\\|
/window functions/tests/non distributed/time decayed funcs	Fail 53s 605ms	AssertionError Traceback (most recent call last): File "regression/window_functions/regression.py", line 203, in regression() File "regression/window_functions/regression.py", line 199, in regression Feature(run=load("window_functions.tests.feature", "feature"), flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/feature.py", line 77, in feature Feature(run=load("window_functions.tests.time_decayed_funcs", "feature"), flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/time_decayed_funcs.py", line 365, in feature Scenario(run=scenario, flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/time_decayed_funcs.py", line 199, in exponentialTimeDecayedAvg exponentialTimeDecayedFunc(funcname="exponentialTimeDecayedAvg") File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/time_decayed_funcs.py", line 53, in exponentialTimeDecayedFunc execute_query( File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/common.py", line 160, in execute_query assert that( AssertionError: Oops! Assertion failed The following assertion was not satisfied assert that( snapshot( "\n" + r.output.strip() + "\n", "tests", name=snapshot_name, encoder=str, ) ), error() Assertion values assert that( ^ is = SnapshotError( filename=/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/snapshots/common.py.tests.snapshot name=_window_functions_tests_time_decayed_funcs_exponentialTimeDecayedAvg_check_decay_length_with_zero snapshot_value=""" id time w 0 2020-01-01 00:00:00 0 1 2020-01-01 00:00:01 1 2 2020-01-01 00:00:02 2 3 2020-01-01 00:00:03 3 4 2020-01-01 00:00:04 4 5 2020-01-01 00:00:05 5 6 2020-01-01 00:00:06 6 7 2020-01-01 00:00:07 7 8 2020-01-01 00:00:08 8 9 2020-01-01 00:00:09 9 """, actual_value=""" id time w 0 2020-01-01 00:00:00 nan 1 2020-01-01 00:00:01 nan 2 2020-01-01 00:00:02 nan 3 2020-01-01 00:00:03 nan 4 2020-01-01 00:00:04 nan 5 2020-01-01 00:00:05 nan 6 2020-01-01 00:00:06 nan 7 2020-01-01 00:00:07 nan 8 2020-01-01 00:00:08 nan 9 2020-01-01 00:00:09 nan """, diff=""" --- /builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/snapshots/common.py.tests.snapshot +++ @@ -1,12 +1,12 @@ id time w -0 2020-01-01 00:00:00 0 -1 2020-01-01 00:00:01 1 -2 2020-01-01 00:00:02 2 -3 2020-01-01 00:00:03 3 -4 2020-01-01 00:00:04 4 -5 2020-01-01 00:00:05 5 -6 2020-01-01 00:00:06 6 -7 2020-01-01 00:00:07 7 -8 2020-01-01 00:00:08 8 -9 2020-01-01 00:00:09 9 +0 2020-01-01 00:00:00 nan +1 2020-01-01 00:00:01 nan +2 2020-01-01 00:00:02 nan +3 2020-01-01 00:00:03 nan +4 2020-01-01 00:00:04 nan +5 2020-01-01 00:00:05 nan +6 2020-01-01 00:00:06 nan +7 2020-01-01 00:00:07 nan +8 2020-01-01 00:00:08 nan +9 2020-01-01 00:00:09 nan """) snapshot( "\n" + r.output.strip() + "\n", "tests", name=snapshot_name, encoder=str, ) ), error() assert that( ^ is False snapshot( "\n" + r.output.strip() + "\n", "tests", name=snapshot_name, encoder=str, ) ), error() Where File '/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/common.py', line 167 in 'execute_query' 159\\| with values() as that: 160\\| assert that( 161\\| snapshot( 162\\| "\n" + r.output.strip() + "\n", 163\\| "tests", 164\\| name=snapshot_name, 165\\| encoder=str, 166\\| ) 167\\|> ), error() 168\\| 169\\| 170\\| @TestStep(Given)
/window functions/tests/non distributed/time decayed funcs/exponentialTimeDecayedAvg	Fail 6s 242ms	AssertionError Traceback (most recent call last): File "regression/window_functions/regression.py", line 203, in regression() File "regression/window_functions/regression.py", line 199, in regression Feature(run=load("window_functions.tests.feature", "feature"), flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/feature.py", line 77, in feature Feature(run=load("window_functions.tests.time_decayed_funcs", "feature"), flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/time_decayed_funcs.py", line 365, in feature Scenario(run=scenario, flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/time_decayed_funcs.py", line 199, in exponentialTimeDecayedAvg exponentialTimeDecayedFunc(funcname="exponentialTimeDecayedAvg") File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/time_decayed_funcs.py", line 53, in exponentialTimeDecayedFunc execute_query( File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/common.py", line 160, in execute_query assert that( AssertionError: Oops! Assertion failed The following assertion was not satisfied assert that( snapshot( "\n" + r.output.strip() + "\n", "tests", name=snapshot_name, encoder=str, ) ), error() Assertion values assert that( ^ is = SnapshotError( filename=/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/snapshots/common.py.tests.snapshot name=_window_functions_tests_time_decayed_funcs_exponentialTimeDecayedAvg_check_decay_length_with_zero snapshot_value=""" id time w 0 2020-01-01 00:00:00 0 1 2020-01-01 00:00:01 1 2 2020-01-01 00:00:02 2 3 2020-01-01 00:00:03 3 4 2020-01-01 00:00:04 4 5 2020-01-01 00:00:05 5 6 2020-01-01 00:00:06 6 7 2020-01-01 00:00:07 7 8 2020-01-01 00:00:08 8 9 2020-01-01 00:00:09 9 """, actual_value=""" id time w 0 2020-01-01 00:00:00 nan 1 2020-01-01 00:00:01 nan 2 2020-01-01 00:00:02 nan 3 2020-01-01 00:00:03 nan 4 2020-01-01 00:00:04 nan 5 2020-01-01 00:00:05 nan 6 2020-01-01 00:00:06 nan 7 2020-01-01 00:00:07 nan 8 2020-01-01 00:00:08 nan 9 2020-01-01 00:00:09 nan """, diff=""" --- /builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/snapshots/common.py.tests.snapshot +++ @@ -1,12 +1,12 @@ id time w -0 2020-01-01 00:00:00 0 -1 2020-01-01 00:00:01 1 -2 2020-01-01 00:00:02 2 -3 2020-01-01 00:00:03 3 -4 2020-01-01 00:00:04 4 -5 2020-01-01 00:00:05 5 -6 2020-01-01 00:00:06 6 -7 2020-01-01 00:00:07 7 -8 2020-01-01 00:00:08 8 -9 2020-01-01 00:00:09 9 +0 2020-01-01 00:00:00 nan +1 2020-01-01 00:00:01 nan +2 2020-01-01 00:00:02 nan +3 2020-01-01 00:00:03 nan +4 2020-01-01 00:00:04 nan +5 2020-01-01 00:00:05 nan +6 2020-01-01 00:00:06 nan +7 2020-01-01 00:00:07 nan +8 2020-01-01 00:00:08 nan +9 2020-01-01 00:00:09 nan """) snapshot( "\n" + r.output.strip() + "\n", "tests", name=snapshot_name, encoder=str, ) ), error() assert that( ^ is False snapshot( "\n" + r.output.strip() + "\n", "tests", name=snapshot_name, encoder=str, ) ), error() Where File '/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/common.py', line 167 in 'execute_query' 159\\| with values() as that: 160\\| assert that( 161\\| snapshot( 162\\| "\n" + r.output.strip() + "\n", 163\\| "tests", 164\\| name=snapshot_name, 165\\| encoder=str, 166\\| ) 167\\|> ), error() 168\\| 169\\| 170\\| @TestStep(Given)
/window functions/tests/non distributed/time decayed funcs/exponentialTimeDecayedCount	Fail 5s 594ms	AssertionError Traceback (most recent call last): File "regression/window_functions/regression.py", line 203, in regression() File "regression/window_functions/regression.py", line 199, in regression Feature(run=load("window_functions.tests.feature", "feature"), flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/feature.py", line 77, in feature Feature(run=load("window_functions.tests.time_decayed_funcs", "feature"), flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/time_decayed_funcs.py", line 365, in feature Scenario(run=scenario, flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/time_decayed_funcs.py", line 246, in exponentialTimeDecayedCount execute_query( File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/common.py", line 160, in execute_query assert that( AssertionError: Oops! Assertion failed The following assertion was not satisfied assert that( snapshot( "\n" + r.output.strip() + "\n", "tests", name=snapshot_name, encoder=str, ) ), error() Assertion values assert that( ^ is = SnapshotError( filename=/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/snapshots/common.py.tests.snapshot name=_window_functions_tests_time_decayed_funcs_exponentialTimeDecayedCount_check_decay_length_with_zero snapshot_value=""" id time w 0 2020-01-01 00:00:00 1 1 2020-01-01 00:00:01 1 2 2020-01-01 00:00:02 1 3 2020-01-01 00:00:03 1 4 2020-01-01 00:00:04 1 5 2020-01-01 00:00:05 1 6 2020-01-01 00:00:06 1 7 2020-01-01 00:00:07 1 8 2020-01-01 00:00:08 1 9 2020-01-01 00:00:09 1 """, actual_value=""" id time w 0 2020-01-01 00:00:00 nan 1 2020-01-01 00:00:01 nan 2 2020-01-01 00:00:02 nan 3 2020-01-01 00:00:03 nan 4 2020-01-01 00:00:04 nan 5 2020-01-01 00:00:05 nan 6 2020-01-01 00:00:06 nan 7 2020-01-01 00:00:07 nan 8 2020-01-01 00:00:08 nan 9 2020-01-01 00:00:09 nan """, diff=""" --- /builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/snapshots/common.py.tests.snapshot +++ @@ -1,12 +1,12 @@ id time w -0 2020-01-01 00:00:00 1 -1 2020-01-01 00:00:01 1 -2 2020-01-01 00:00:02 1 -3 2020-01-01 00:00:03 1 -4 2020-01-01 00:00:04 1 -5 2020-01-01 00:00:05 1 -6 2020-01-01 00:00:06 1 -7 2020-01-01 00:00:07 1 -8 2020-01-01 00:00:08 1 -9 2020-01-01 00:00:09 1 +0 2020-01-01 00:00:00 nan +1 2020-01-01 00:00:01 nan +2 2020-01-01 00:00:02 nan +3 2020-01-01 00:00:03 nan +4 2020-01-01 00:00:04 nan +5 2020-01-01 00:00:05 nan +6 2020-01-01 00:00:06 nan +7 2020-01-01 00:00:07 nan +8 2020-01-01 00:00:08 nan +9 2020-01-01 00:00:09 nan """) snapshot( "\n" + r.output.strip() + "\n", "tests", name=snapshot_name, encoder=str, ) ), error() assert that( ^ is False snapshot( "\n" + r.output.strip() + "\n", "tests", name=snapshot_name, encoder=str, ) ), error() Where File '/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/common.py', line 167 in 'execute_query' 159\\| with values() as that: 160\\| assert that( 161\\| snapshot( 162\\| "\n" + r.output.strip() + "\n", 163\\| "tests", 164\\| name=snapshot_name, 165\\| encoder=str, 166\\| ) 167\\|> ), error() 168\\| 169\\| 170\\| @TestStep(Given)
/window functions/tests/non distributed/time decayed funcs/exponentialTimeDecayedMax	Fail 35s 614ms	AssertionError Traceback (most recent call last): File "regression/window_functions/regression.py", line 203, in regression() File "regression/window_functions/regression.py", line 199, in regression Feature(run=load("window_functions.tests.feature", "feature"), flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/feature.py", line 77, in feature Feature(run=load("window_functions.tests.time_decayed_funcs", "feature"), flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/time_decayed_funcs.py", line 365, in feature Scenario(run=scenario, flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/time_decayed_funcs.py", line 193, in exponentialTimeDecayedMax exponentialTimeDecayedFunc(funcname="exponentialTimeDecayedMax") File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/time_decayed_funcs.py", line 53, in exponentialTimeDecayedFunc execute_query( File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/common.py", line 160, in execute_query assert that( AssertionError: Oops! Assertion failed The following assertion was not satisfied assert that( snapshot( "\n" + r.output.strip() + "\n", "tests", name=snapshot_name, encoder=str, ) ), error() Assertion values assert that( ^ is = SnapshotError( filename=/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/snapshots/common.py.tests.snapshot name=_window_functions_tests_time_decayed_funcs_exponentialTimeDecayedMax_check_decay_length_with_zero snapshot_value=""" id time w 0 2020-01-01 00:00:00 0 1 2020-01-01 00:00:01 1 2 2020-01-01 00:00:02 2 3 2020-01-01 00:00:03 3 4 2020-01-01 00:00:04 4 5 2020-01-01 00:00:05 5 6 2020-01-01 00:00:06 6 7 2020-01-01 00:00:07 7 8 2020-01-01 00:00:08 8 9 2020-01-01 00:00:09 9 """, actual_value=""" id time w 0 2020-01-01 00:00:00 inf 1 2020-01-01 00:00:01 inf 2 2020-01-01 00:00:02 inf 3 2020-01-01 00:00:03 inf 4 2020-01-01 00:00:04 inf 5 2020-01-01 00:00:05 inf 6 2020-01-01 00:00:06 inf 7 2020-01-01 00:00:07 inf 8 2020-01-01 00:00:08 inf 9 2020-01-01 00:00:09 inf """, diff=""" --- /builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/snapshots/common.py.tests.snapshot +++ @@ -1,12 +1,12 @@ id time w -0 2020-01-01 00:00:00 0 -1 2020-01-01 00:00:01 1 -2 2020-01-01 00:00:02 2 -3 2020-01-01 00:00:03 3 -4 2020-01-01 00:00:04 4 -5 2020-01-01 00:00:05 5 -6 2020-01-01 00:00:06 6 -7 2020-01-01 00:00:07 7 -8 2020-01-01 00:00:08 8 -9 2020-01-01 00:00:09 9 +0 2020-01-01 00:00:00 inf +1 2020-01-01 00:00:01 inf +2 2020-01-01 00:00:02 inf +3 2020-01-01 00:00:03 inf +4 2020-01-01 00:00:04 inf +5 2020-01-01 00:00:05 inf +6 2020-01-01 00:00:06 inf +7 2020-01-01 00:00:07 inf +8 2020-01-01 00:00:08 inf +9 2020-01-01 00:00:09 inf """) snapshot( "\n" + r.output.strip() + "\n", "tests", name=snapshot_name, encoder=str, ) ), error() assert that( ^ is False snapshot( "\n" + r.output.strip() + "\n", "tests", name=snapshot_name, encoder=str, ) ), error() Where File '/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/common.py', line 167 in 'execute_query' 159\\| with values() as that: 160\\| assert that( 161\\| snapshot( 162\\| "\n" + r.output.strip() + "\n", 163\\| "tests", 164\\| name=snapshot_name, 165\\| encoder=str, 166\\| ) 167\\|> ), error() 168\\| 169\\| 170\\| @TestStep(Given)
/window functions/tests/non distributed/time decayed funcs/exponentialTimeDecayedSum	Fail 6s 152ms	AssertionError Traceback (most recent call last): File "regression/window_functions/regression.py", line 203, in regression() File "regression/window_functions/regression.py", line 199, in regression Feature(run=load("window_functions.tests.feature", "feature"), flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/feature.py", line 77, in feature Feature(run=load("window_functions.tests.time_decayed_funcs", "feature"), flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/time_decayed_funcs.py", line 365, in feature Scenario(run=scenario, flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/time_decayed_funcs.py", line 187, in exponentialTimeDecayedSum exponentialTimeDecayedFunc(funcname="exponentialTimeDecayedSum") File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/time_decayed_funcs.py", line 53, in exponentialTimeDecayedFunc execute_query( File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/common.py", line 160, in execute_query assert that( AssertionError: Oops! Assertion failed The following assertion was not satisfied assert that( snapshot( "\n" + r.output.strip() + "\n", "tests", name=snapshot_name, encoder=str, ) ), error() Assertion values assert that( ^ is = SnapshotError( filename=/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/snapshots/common.py.tests.snapshot name=_window_functions_tests_time_decayed_funcs_exponentialTimeDecayedSum_check_decay_length_with_zero snapshot_value=""" id time w 0 2020-01-01 00:00:00 0 1 2020-01-01 00:00:01 1 2 2020-01-01 00:00:02 2 3 2020-01-01 00:00:03 3 4 2020-01-01 00:00:04 4 5 2020-01-01 00:00:05 5 6 2020-01-01 00:00:06 6 7 2020-01-01 00:00:07 7 8 2020-01-01 00:00:08 8 9 2020-01-01 00:00:09 9 """, actual_value=""" id time w 0 2020-01-01 00:00:00 nan 1 2020-01-01 00:00:01 nan 2 2020-01-01 00:00:02 nan 3 2020-01-01 00:00:03 nan 4 2020-01-01 00:00:04 nan 5 2020-01-01 00:00:05 nan 6 2020-01-01 00:00:06 nan 7 2020-01-01 00:00:07 nan 8 2020-01-01 00:00:08 nan 9 2020-01-01 00:00:09 nan """, diff=""" --- /builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/snapshots/common.py.tests.snapshot +++ @@ -1,12 +1,12 @@ id time w -0 2020-01-01 00:00:00 0 -1 2020-01-01 00:00:01 1 -2 2020-01-01 00:00:02 2 -3 2020-01-01 00:00:03 3 -4 2020-01-01 00:00:04 4 -5 2020-01-01 00:00:05 5 -6 2020-01-01 00:00:06 6 -7 2020-01-01 00:00:07 7 -8 2020-01-01 00:00:08 8 -9 2020-01-01 00:00:09 9 +0 2020-01-01 00:00:00 nan +1 2020-01-01 00:00:01 nan +2 2020-01-01 00:00:02 nan +3 2020-01-01 00:00:03 nan +4 2020-01-01 00:00:04 nan +5 2020-01-01 00:00:05 nan +6 2020-01-01 00:00:06 nan +7 2020-01-01 00:00:07 nan +8 2020-01-01 00:00:08 nan +9 2020-01-01 00:00:09 nan """) snapshot( "\n" + r.output.strip() + "\n", "tests", name=snapshot_name, encoder=str, ) ), error() assert that( ^ is False snapshot( "\n" + r.output.strip() + "\n", "tests", name=snapshot_name, encoder=str, ) ), error() Where File '/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/common.py', line 167 in 'execute_query' 159\\| with values() as that: 160\\| assert that( 161\\| snapshot( 162\\| "\n" + r.output.strip() + "\n", 163\\| "tests", 164\\| name=snapshot_name, 165\\| encoder=str, 166\\| ) 167\\|> ), error() 168\\| 169\\| 170\\| @TestStep(Given)
/window functions/tests/distributed	Fail 1m 12s	AssertionError Traceback (most recent call last): File "regression/window_functions/regression.py", line 203, in regression() File "regression/window_functions/regression.py", line 199, in regression Feature(run=load("window_functions.tests.feature", "feature"), flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/feature.py", line 71, in feature Feature(run=load("window_functions.tests.order_clause", "feature"), flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/order_clause.py", line 236, in feature Scenario(run=scenario, flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/order_clause.py", line 207, in by_expr_with_aggregates execute_query( File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/common.py", line 144, in execute_query r = current().context.node.query( File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../helpers/cluster.py", line 641, in query assert False, error(r.output) AssertionError: Oops! Assertion failed The following assertion was not satisfied assert False, error(r.output) Description Received exception from server (version 22.3.8): Code: 47. DB::Exception: Received from localhost:9000. DB::Exception: Unknown identifier: sum(unique1); there are columns: unique1, unique2, ten: While processing sum(unique1) + sum(unique2) ASC. (UNKNOWN_IDENTIFIER) (query: select ten, sum(unique1) + sum(unique2) as res, rank() over (order by sum(unique1) + sum(unique2)) as rank from tenk1 group by ten order by ten FORMAT TabSeparatedWithNames ) Assertion values assert False, error(r.output) ^ is False Where File '/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../helpers/cluster.py', line 641 in 'query' 633\\| ) if steps else NullStep(): 634\\| assert message in r.output, error(r.output) 635\\| 636\\| if message is None or "Exception:" not in message: 637\\| with Then("check if output has exception") if steps else NullStep(): 638\\| if "Exception:" in r.output: 639\\| if raise_on_exception: 640\\| raise QueryRuntimeException(r.output) 641\\|> assert False, error(r.output) 642\\| 643\\| return r 644\\|
/window functions/tests/distributed/order clause	Fail 424ms	AssertionError Traceback (most recent call last): File "regression/window_functions/regression.py", line 203, in regression() File "regression/window_functions/regression.py", line 199, in regression Feature(run=load("window_functions.tests.feature", "feature"), flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/feature.py", line 71, in feature Feature(run=load("window_functions.tests.order_clause", "feature"), flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/order_clause.py", line 236, in feature Scenario(run=scenario, flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/order_clause.py", line 207, in by_expr_with_aggregates execute_query( File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/common.py", line 144, in execute_query r = current().context.node.query( File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../helpers/cluster.py", line 641, in query assert False, error(r.output) AssertionError: Oops! Assertion failed The following assertion was not satisfied assert False, error(r.output) Description Received exception from server (version 22.3.8): Code: 47. DB::Exception: Received from localhost:9000. DB::Exception: Unknown identifier: sum(unique1); there are columns: unique1, unique2, ten: While processing sum(unique1) + sum(unique2) ASC. (UNKNOWN_IDENTIFIER) (query: select ten, sum(unique1) + sum(unique2) as res, rank() over (order by sum(unique1) + sum(unique2)) as rank from tenk1 group by ten order by ten FORMAT TabSeparatedWithNames ) Assertion values assert False, error(r.output) ^ is False Where File '/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../helpers/cluster.py', line 641 in 'query' 633\\| ) if steps else NullStep(): 634\\| assert message in r.output, error(r.output) 635\\| 636\\| if message is None or "Exception:" not in message: 637\\| with Then("check if output has exception") if steps else NullStep(): 638\\| if "Exception:" in r.output: 639\\| if raise_on_exception: 640\\| raise QueryRuntimeException(r.output) 641\\|> assert False, error(r.output) 642\\| 643\\| return r 644\\|
/window functions/tests/distributed/order clause/by expr with aggregates	Fail 38ms	AssertionError Traceback (most recent call last): File "regression/window_functions/regression.py", line 203, in regression() File "regression/window_functions/regression.py", line 199, in regression Feature(run=load("window_functions.tests.feature", "feature"), flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/feature.py", line 71, in feature Feature(run=load("window_functions.tests.order_clause", "feature"), flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/order_clause.py", line 236, in feature Scenario(run=scenario, flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/order_clause.py", line 207, in by_expr_with_aggregates execute_query( File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/common.py", line 144, in execute_query r = current().context.node.query( File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../helpers/cluster.py", line 641, in query assert False, error(r.output) AssertionError: Oops! Assertion failed The following assertion was not satisfied assert False, error(r.output) Description Received exception from server (version 22.3.8): Code: 47. DB::Exception: Received from localhost:9000. DB::Exception: Unknown identifier: sum(unique1); there are columns: unique1, unique2, ten: While processing sum(unique1) + sum(unique2) ASC. (UNKNOWN_IDENTIFIER) (query: select ten, sum(unique1) + sum(unique2) as res, rank() over (order by sum(unique1) + sum(unique2)) as rank from tenk1 group by ten order by ten FORMAT TabSeparatedWithNames ) Assertion values assert False, error(r.output) ^ is False Where File '/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../helpers/cluster.py', line 641 in 'query' 633\\| ) if steps else NullStep(): 634\\| assert message in r.output, error(r.output) 635\\| 636\\| if message is None or "Exception:" not in message: 637\\| with Then("check if output has exception") if steps else NullStep(): 638\\| if "Exception:" in r.output: 639\\| if raise_on_exception: 640\\| raise QueryRuntimeException(r.output) 641\\|> assert False, error(r.output) 642\\| 643\\| return r 644\\|
/window functions/tests/distributed/time decayed funcs	Fail 53s 320ms	AssertionError Traceback (most recent call last): File "regression/window_functions/regression.py", line 203, in regression() File "regression/window_functions/regression.py", line 199, in regression Feature(run=load("window_functions.tests.feature", "feature"), flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/feature.py", line 77, in feature Feature(run=load("window_functions.tests.time_decayed_funcs", "feature"), flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/time_decayed_funcs.py", line 365, in feature Scenario(run=scenario, flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/time_decayed_funcs.py", line 199, in exponentialTimeDecayedAvg exponentialTimeDecayedFunc(funcname="exponentialTimeDecayedAvg") File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/time_decayed_funcs.py", line 53, in exponentialTimeDecayedFunc execute_query( File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/common.py", line 160, in execute_query assert that( AssertionError: Oops! Assertion failed The following assertion was not satisfied assert that( snapshot( "\n" + r.output.strip() + "\n", "tests", name=snapshot_name, encoder=str, ) ), error() Assertion values assert that( ^ is = SnapshotError( filename=/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/snapshots/common.py.tests.snapshot name=_window_functions_tests_time_decayed_funcs_exponentialTimeDecayedAvg_check_decay_length_with_zero snapshot_value=""" id time w 0 2020-01-01 00:00:00 0 1 2020-01-01 00:00:01 1 2 2020-01-01 00:00:02 2 3 2020-01-01 00:00:03 3 4 2020-01-01 00:00:04 4 5 2020-01-01 00:00:05 5 6 2020-01-01 00:00:06 6 7 2020-01-01 00:00:07 7 8 2020-01-01 00:00:08 8 9 2020-01-01 00:00:09 9 """, actual_value=""" id time w 0 2020-01-01 00:00:00 nan 1 2020-01-01 00:00:01 nan 2 2020-01-01 00:00:02 nan 3 2020-01-01 00:00:03 nan 4 2020-01-01 00:00:04 nan 5 2020-01-01 00:00:05 nan 6 2020-01-01 00:00:06 nan 7 2020-01-01 00:00:07 nan 8 2020-01-01 00:00:08 nan 9 2020-01-01 00:00:09 nan """, diff=""" --- /builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/snapshots/common.py.tests.snapshot +++ @@ -1,12 +1,12 @@ id time w -0 2020-01-01 00:00:00 0 -1 2020-01-01 00:00:01 1 -2 2020-01-01 00:00:02 2 -3 2020-01-01 00:00:03 3 -4 2020-01-01 00:00:04 4 -5 2020-01-01 00:00:05 5 -6 2020-01-01 00:00:06 6 -7 2020-01-01 00:00:07 7 -8 2020-01-01 00:00:08 8 -9 2020-01-01 00:00:09 9 +0 2020-01-01 00:00:00 nan +1 2020-01-01 00:00:01 nan +2 2020-01-01 00:00:02 nan +3 2020-01-01 00:00:03 nan +4 2020-01-01 00:00:04 nan +5 2020-01-01 00:00:05 nan +6 2020-01-01 00:00:06 nan +7 2020-01-01 00:00:07 nan +8 2020-01-01 00:00:08 nan +9 2020-01-01 00:00:09 nan """) snapshot( "\n" + r.output.strip() + "\n", "tests", name=snapshot_name, encoder=str, ) ), error() assert that( ^ is False snapshot( "\n" + r.output.strip() + "\n", "tests", name=snapshot_name, encoder=str, ) ), error() Where File '/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/common.py', line 167 in 'execute_query' 159\\| with values() as that: 160\\| assert that( 161\\| snapshot( 162\\| "\n" + r.output.strip() + "\n", 163\\| "tests", 164\\| name=snapshot_name, 165\\| encoder=str, 166\\| ) 167\\|> ), error() 168\\| 169\\| 170\\| @TestStep(Given)
/window functions/tests/distributed/time decayed funcs/exponentialTimeDecayedAvg	Fail 6s 242ms	AssertionError Traceback (most recent call last): File "regression/window_functions/regression.py", line 203, in regression() File "regression/window_functions/regression.py", line 199, in regression Feature(run=load("window_functions.tests.feature", "feature"), flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/feature.py", line 77, in feature Feature(run=load("window_functions.tests.time_decayed_funcs", "feature"), flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/time_decayed_funcs.py", line 365, in feature Scenario(run=scenario, flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/time_decayed_funcs.py", line 199, in exponentialTimeDecayedAvg exponentialTimeDecayedFunc(funcname="exponentialTimeDecayedAvg") File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/time_decayed_funcs.py", line 53, in exponentialTimeDecayedFunc execute_query( File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/common.py", line 160, in execute_query assert that( AssertionError: Oops! Assertion failed The following assertion was not satisfied assert that( snapshot( "\n" + r.output.strip() + "\n", "tests", name=snapshot_name, encoder=str, ) ), error() Assertion values assert that( ^ is = SnapshotError( filename=/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/snapshots/common.py.tests.snapshot name=_window_functions_tests_time_decayed_funcs_exponentialTimeDecayedAvg_check_decay_length_with_zero snapshot_value=""" id time w 0 2020-01-01 00:00:00 0 1 2020-01-01 00:00:01 1 2 2020-01-01 00:00:02 2 3 2020-01-01 00:00:03 3 4 2020-01-01 00:00:04 4 5 2020-01-01 00:00:05 5 6 2020-01-01 00:00:06 6 7 2020-01-01 00:00:07 7 8 2020-01-01 00:00:08 8 9 2020-01-01 00:00:09 9 """, actual_value=""" id time w 0 2020-01-01 00:00:00 nan 1 2020-01-01 00:00:01 nan 2 2020-01-01 00:00:02 nan 3 2020-01-01 00:00:03 nan 4 2020-01-01 00:00:04 nan 5 2020-01-01 00:00:05 nan 6 2020-01-01 00:00:06 nan 7 2020-01-01 00:00:07 nan 8 2020-01-01 00:00:08 nan 9 2020-01-01 00:00:09 nan """, diff=""" --- /builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/snapshots/common.py.tests.snapshot +++ @@ -1,12 +1,12 @@ id time w -0 2020-01-01 00:00:00 0 -1 2020-01-01 00:00:01 1 -2 2020-01-01 00:00:02 2 -3 2020-01-01 00:00:03 3 -4 2020-01-01 00:00:04 4 -5 2020-01-01 00:00:05 5 -6 2020-01-01 00:00:06 6 -7 2020-01-01 00:00:07 7 -8 2020-01-01 00:00:08 8 -9 2020-01-01 00:00:09 9 +0 2020-01-01 00:00:00 nan +1 2020-01-01 00:00:01 nan +2 2020-01-01 00:00:02 nan +3 2020-01-01 00:00:03 nan +4 2020-01-01 00:00:04 nan +5 2020-01-01 00:00:05 nan +6 2020-01-01 00:00:06 nan +7 2020-01-01 00:00:07 nan +8 2020-01-01 00:00:08 nan +9 2020-01-01 00:00:09 nan """) snapshot( "\n" + r.output.strip() + "\n", "tests", name=snapshot_name, encoder=str, ) ), error() assert that( ^ is False snapshot( "\n" + r.output.strip() + "\n", "tests", name=snapshot_name, encoder=str, ) ), error() Where File '/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/common.py', line 167 in 'execute_query' 159\\| with values() as that: 160\\| assert that( 161\\| snapshot( 162\\| "\n" + r.output.strip() + "\n", 163\\| "tests", 164\\| name=snapshot_name, 165\\| encoder=str, 166\\| ) 167\\|> ), error() 168\\| 169\\| 170\\| @TestStep(Given)
/window functions/tests/distributed/time decayed funcs/exponentialTimeDecayedCount	Fail 5s 412ms	AssertionError Traceback (most recent call last): File "regression/window_functions/regression.py", line 203, in regression() File "regression/window_functions/regression.py", line 199, in regression Feature(run=load("window_functions.tests.feature", "feature"), flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/feature.py", line 77, in feature Feature(run=load("window_functions.tests.time_decayed_funcs", "feature"), flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/time_decayed_funcs.py", line 365, in feature Scenario(run=scenario, flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/time_decayed_funcs.py", line 246, in exponentialTimeDecayedCount execute_query( File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/common.py", line 160, in execute_query assert that( AssertionError: Oops! Assertion failed The following assertion was not satisfied assert that( snapshot( "\n" + r.output.strip() + "\n", "tests", name=snapshot_name, encoder=str, ) ), error() Assertion values assert that( ^ is = SnapshotError( filename=/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/snapshots/common.py.tests.snapshot name=_window_functions_tests_time_decayed_funcs_exponentialTimeDecayedCount_check_decay_length_with_zero snapshot_value=""" id time w 0 2020-01-01 00:00:00 1 1 2020-01-01 00:00:01 1 2 2020-01-01 00:00:02 1 3 2020-01-01 00:00:03 1 4 2020-01-01 00:00:04 1 5 2020-01-01 00:00:05 1 6 2020-01-01 00:00:06 1 7 2020-01-01 00:00:07 1 8 2020-01-01 00:00:08 1 9 2020-01-01 00:00:09 1 """, actual_value=""" id time w 0 2020-01-01 00:00:00 nan 1 2020-01-01 00:00:01 nan 2 2020-01-01 00:00:02 nan 3 2020-01-01 00:00:03 nan 4 2020-01-01 00:00:04 nan 5 2020-01-01 00:00:05 nan 6 2020-01-01 00:00:06 nan 7 2020-01-01 00:00:07 nan 8 2020-01-01 00:00:08 nan 9 2020-01-01 00:00:09 nan """, diff=""" --- /builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/snapshots/common.py.tests.snapshot +++ @@ -1,12 +1,12 @@ id time w -0 2020-01-01 00:00:00 1 -1 2020-01-01 00:00:01 1 -2 2020-01-01 00:00:02 1 -3 2020-01-01 00:00:03 1 -4 2020-01-01 00:00:04 1 -5 2020-01-01 00:00:05 1 -6 2020-01-01 00:00:06 1 -7 2020-01-01 00:00:07 1 -8 2020-01-01 00:00:08 1 -9 2020-01-01 00:00:09 1 +0 2020-01-01 00:00:00 nan +1 2020-01-01 00:00:01 nan +2 2020-01-01 00:00:02 nan +3 2020-01-01 00:00:03 nan +4 2020-01-01 00:00:04 nan +5 2020-01-01 00:00:05 nan +6 2020-01-01 00:00:06 nan +7 2020-01-01 00:00:07 nan +8 2020-01-01 00:00:08 nan +9 2020-01-01 00:00:09 nan """) snapshot( "\n" + r.output.strip() + "\n", "tests", name=snapshot_name, encoder=str, ) ), error() assert that( ^ is False snapshot( "\n" + r.output.strip() + "\n", "tests", name=snapshot_name, encoder=str, ) ), error() Where File '/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/common.py', line 167 in 'execute_query' 159\\| with values() as that: 160\\| assert that( 161\\| snapshot( 162\\| "\n" + r.output.strip() + "\n", 163\\| "tests", 164\\| name=snapshot_name, 165\\| encoder=str, 166\\| ) 167\\|> ), error() 168\\| 169\\| 170\\| @TestStep(Given)
/window functions/tests/distributed/time decayed funcs/exponentialTimeDecayedMax	Fail 35s 529ms	AssertionError Traceback (most recent call last): File "regression/window_functions/regression.py", line 203, in regression() File "regression/window_functions/regression.py", line 199, in regression Feature(run=load("window_functions.tests.feature", "feature"), flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/feature.py", line 77, in feature Feature(run=load("window_functions.tests.time_decayed_funcs", "feature"), flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/time_decayed_funcs.py", line 365, in feature Scenario(run=scenario, flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/time_decayed_funcs.py", line 193, in exponentialTimeDecayedMax exponentialTimeDecayedFunc(funcname="exponentialTimeDecayedMax") File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/time_decayed_funcs.py", line 53, in exponentialTimeDecayedFunc execute_query( File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/common.py", line 160, in execute_query assert that( AssertionError: Oops! Assertion failed The following assertion was not satisfied assert that( snapshot( "\n" + r.output.strip() + "\n", "tests", name=snapshot_name, encoder=str, ) ), error() Assertion values assert that( ^ is = SnapshotError( filename=/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/snapshots/common.py.tests.snapshot name=_window_functions_tests_time_decayed_funcs_exponentialTimeDecayedMax_check_decay_length_with_zero snapshot_value=""" id time w 0 2020-01-01 00:00:00 0 1 2020-01-01 00:00:01 1 2 2020-01-01 00:00:02 2 3 2020-01-01 00:00:03 3 4 2020-01-01 00:00:04 4 5 2020-01-01 00:00:05 5 6 2020-01-01 00:00:06 6 7 2020-01-01 00:00:07 7 8 2020-01-01 00:00:08 8 9 2020-01-01 00:00:09 9 """, actual_value=""" id time w 0 2020-01-01 00:00:00 inf 1 2020-01-01 00:00:01 inf 2 2020-01-01 00:00:02 inf 3 2020-01-01 00:00:03 inf 4 2020-01-01 00:00:04 inf 5 2020-01-01 00:00:05 inf 6 2020-01-01 00:00:06 inf 7 2020-01-01 00:00:07 inf 8 2020-01-01 00:00:08 inf 9 2020-01-01 00:00:09 inf """, diff=""" --- /builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/snapshots/common.py.tests.snapshot +++ @@ -1,12 +1,12 @@ id time w -0 2020-01-01 00:00:00 0 -1 2020-01-01 00:00:01 1 -2 2020-01-01 00:00:02 2 -3 2020-01-01 00:00:03 3 -4 2020-01-01 00:00:04 4 -5 2020-01-01 00:00:05 5 -6 2020-01-01 00:00:06 6 -7 2020-01-01 00:00:07 7 -8 2020-01-01 00:00:08 8 -9 2020-01-01 00:00:09 9 +0 2020-01-01 00:00:00 inf +1 2020-01-01 00:00:01 inf +2 2020-01-01 00:00:02 inf +3 2020-01-01 00:00:03 inf +4 2020-01-01 00:00:04 inf +5 2020-01-01 00:00:05 inf +6 2020-01-01 00:00:06 inf +7 2020-01-01 00:00:07 inf +8 2020-01-01 00:00:08 inf +9 2020-01-01 00:00:09 inf """) snapshot( "\n" + r.output.strip() + "\n", "tests", name=snapshot_name, encoder=str, ) ), error() assert that( ^ is False snapshot( "\n" + r.output.strip() + "\n", "tests", name=snapshot_name, encoder=str, ) ), error() Where File '/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/common.py', line 167 in 'execute_query' 159\\| with values() as that: 160\\| assert that( 161\\| snapshot( 162\\| "\n" + r.output.strip() + "\n", 163\\| "tests", 164\\| name=snapshot_name, 165\\| encoder=str, 166\\| ) 167\\|> ), error() 168\\| 169\\| 170\\| @TestStep(Given)
/window functions/tests/distributed/time decayed funcs/exponentialTimeDecayedSum	Fail 6s 134ms	AssertionError Traceback (most recent call last): File "regression/window_functions/regression.py", line 203, in regression() File "regression/window_functions/regression.py", line 199, in regression Feature(run=load("window_functions.tests.feature", "feature"), flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/feature.py", line 77, in feature Feature(run=load("window_functions.tests.time_decayed_funcs", "feature"), flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/time_decayed_funcs.py", line 365, in feature Scenario(run=scenario, flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/time_decayed_funcs.py", line 187, in exponentialTimeDecayedSum exponentialTimeDecayedFunc(funcname="exponentialTimeDecayedSum") File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/time_decayed_funcs.py", line 53, in exponentialTimeDecayedFunc execute_query( File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/common.py", line 160, in execute_query assert that( AssertionError: Oops! Assertion failed The following assertion was not satisfied assert that( snapshot( "\n" + r.output.strip() + "\n", "tests", name=snapshot_name, encoder=str, ) ), error() Assertion values assert that( ^ is = SnapshotError( filename=/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/snapshots/common.py.tests.snapshot name=_window_functions_tests_time_decayed_funcs_exponentialTimeDecayedSum_check_decay_length_with_zero snapshot_value=""" id time w 0 2020-01-01 00:00:00 0 1 2020-01-01 00:00:01 1 2 2020-01-01 00:00:02 2 3 2020-01-01 00:00:03 3 4 2020-01-01 00:00:04 4 5 2020-01-01 00:00:05 5 6 2020-01-01 00:00:06 6 7 2020-01-01 00:00:07 7 8 2020-01-01 00:00:08 8 9 2020-01-01 00:00:09 9 """, actual_value=""" id time w 0 2020-01-01 00:00:00 nan 1 2020-01-01 00:00:01 nan 2 2020-01-01 00:00:02 nan 3 2020-01-01 00:00:03 nan 4 2020-01-01 00:00:04 nan 5 2020-01-01 00:00:05 nan 6 2020-01-01 00:00:06 nan 7 2020-01-01 00:00:07 nan 8 2020-01-01 00:00:08 nan 9 2020-01-01 00:00:09 nan """, diff=""" --- /builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/snapshots/common.py.tests.snapshot +++ @@ -1,12 +1,12 @@ id time w -0 2020-01-01 00:00:00 0 -1 2020-01-01 00:00:01 1 -2 2020-01-01 00:00:02 2 -3 2020-01-01 00:00:03 3 -4 2020-01-01 00:00:04 4 -5 2020-01-01 00:00:05 5 -6 2020-01-01 00:00:06 6 -7 2020-01-01 00:00:07 7 -8 2020-01-01 00:00:08 8 -9 2020-01-01 00:00:09 9 +0 2020-01-01 00:00:00 nan +1 2020-01-01 00:00:01 nan +2 2020-01-01 00:00:02 nan +3 2020-01-01 00:00:03 nan +4 2020-01-01 00:00:04 nan +5 2020-01-01 00:00:05 nan +6 2020-01-01 00:00:06 nan +7 2020-01-01 00:00:07 nan +8 2020-01-01 00:00:08 nan +9 2020-01-01 00:00:09 nan """) snapshot( "\n" + r.output.strip() + "\n", "tests", name=snapshot_name, encoder=str, ) ), error() assert that( ^ is False snapshot( "\n" + r.output.strip() + "\n", "tests", name=snapshot_name, encoder=str, ) ), error() Where File '/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/common.py', line 167 in 'execute_query' 159\\| with values() as that: 160\\| assert that( 161\\| snapshot( 162\\| "\n" + r.output.strip() + "\n", 163\\| "tests", 164\\| name=snapshot_name, 165\\| encoder=str, 166\\| ) 167\\|> ), error() 168\\| 169\\| 170\\| @TestStep(Given)

Known Fails

Test Name	Result	Message
/window functions/tests/non distributed/frame clause/range frame/between current row and unbounded following modifying named window	XFail 38ms range with named window is not supported	AssertionError Traceback (most recent call last): File "regression/window_functions/regression.py", line 203, in regression() File "regression/window_functions/regression.py", line 199, in regression Feature(run=load("window_functions.tests.feature", "feature"), flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/feature.py", line 72, in feature Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/frame_clause.py", line 68, in feature Feature(run=load("window_functions.tests.range_frame", "feature"), flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/range_frame.py", line 1733, in feature Scenario(run=scenario, flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/range_frame.py", line 1520, in between_current_row_and_unbounded_following_modifying_named_window execute_query( File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/common.py", line 144, in execute_query r = current().context.node.query( File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../helpers/cluster.py", line 641, in query assert False, error(r.output) AssertionError: Oops! Assertion failed The following assertion was not satisfied assert False, error(r.output) Description Received exception from server (version 22.3.8): Code: 49. DB::Exception: Received from localhost:9000. DB::Exception: Sizes of sort description and actions are mismatched. (LOGICAL_ERROR) (query: SELECT * FROM (SELECT sum(unique1) over (w range between current row and unbounded following) AS sum,unique1, four FROM tenk1 WHERE unique1 < 10 WINDOW w AS (order by four)) ORDER BY unique1 FORMAT TabSeparatedWithNames ) Assertion values assert False, error(r.output) ^ is False Where File '/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../helpers/cluster.py', line 641 in 'query' 633\\| ) if steps else NullStep(): 634\\| assert message in r.output, error(r.output) 635\\| 636\\| if message is None or "Exception:" not in message: 637\\| with Then("check if output has exception") if steps else NullStep(): 638\\| if "Exception:" in r.output: 639\\| if raise_on_exception: 640\\| raise QueryRuntimeException(r.output) 641\\|> assert False, error(r.output) 642\\| 643\\| return r 644\\|
/window functions/tests/non distributed/frame clause/range frame/between expr following and current row zero special case	XFail 41ms known bug	AssertionError Traceback (most recent call last): File "regression/window_functions/regression.py", line 203, in regression() File "regression/window_functions/regression.py", line 199, in regression Feature(run=load("window_functions.tests.feature", "feature"), flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/feature.py", line 72, in feature Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/frame_clause.py", line 68, in feature Feature(run=load("window_functions.tests.range_frame", "feature"), flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/range_frame.py", line 1733, in feature Scenario(run=scenario, flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/range_frame.py", line 1347, in between_expr_following_and_current_row_zero_special_case execute_query( File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/common.py", line 144, in execute_query r = current().context.node.query( File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../helpers/cluster.py", line 641, in query assert False, error(r.output) AssertionError: Oops! Assertion failed The following assertion was not satisfied assert False, error(r.output) Description Received exception from server (version 22.3.8): Code: 36. DB::Exception: Received from localhost:9000. DB::Exception: Window frame 'Range BETWEEN 0 FOLLOWING AND CURRENT ROW' is invalid. (BAD_ARGUMENTS) (query: SELECT number,sum(number) OVER (ORDER BY number RANGE BETWEEN 0 FOLLOWING AND CURRENT ROW) AS sum FROM values('number Int8', (1),(1),(2),(3)) FORMAT TabSeparatedWithNames ) Assertion values assert False, error(r.output) ^ is False Where File '/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../helpers/cluster.py', line 641 in 'query' 633\\| ) if steps else NullStep(): 634\\| assert message in r.output, error(r.output) 635\\| 636\\| if message is None or "Exception:" not in message: 637\\| with Then("check if output has exception") if steps else NullStep(): 638\\| if "Exception:" in r.output: 639\\| if raise_on_exception: 640\\| raise QueryRuntimeException(r.output) 641\\|> assert False, error(r.output) 642\\| 643\\| return r 644\\|
/window functions/tests/non distributed/frame clause/range frame/between expr following and expr following without order by error	XFail 37ms invalid error message	AssertionError Traceback (most recent call last): File "regression/window_functions/regression.py", line 203, in regression() File "regression/window_functions/regression.py", line 199, in regression Feature(run=load("window_functions.tests.feature", "feature"), flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/feature.py", line 72, in feature Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/frame_clause.py", line 68, in feature Feature(run=load("window_functions.tests.range_frame", "feature"), flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/range_frame.py", line 1733, in feature Scenario(run=scenario, flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/range_frame.py", line 1211, in between_expr_following_and_expr_following_without_order_by_error self.context.node.query( File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../helpers/cluster.py", line 634, in query assert message in r.output, error(r.output) AssertionError: Oops! Assertion failed The following assertion was not satisfied assert message in r.output, error(r.output) Description Received exception from server (version 22.3.8): Code: 36. DB::Exception: Received from localhost:9000. DB::Exception: The RANGE OFFSET window frame requires exactly one ORDER BY column, 0 given. (BAD_ARGUMENTS) (query: SELECT number,sum(number) OVER (RANGE BETWEEN 1 FOLLOWING AND 1 FOLLOWING) FROM values('number Int8', (1),(1),(2),(3)) ) Assertion values assert message in r.output, error(r.output) ^ is 'Exception: Window frame' assert message in r.output, error(r.output) ^ is assert message in r.output, error(r.output) ^ is = "Received exception from server (version 22.3.8):\nCode: 36. DB::Exception: Received from localhost:9000. DB::Exception: The RANGE OFFSET window frame requires exactly one ORDER BY column, 0 given. (BAD_ARGUMENTS)\n(query: SELECT number,sum(number) OVER (RANGE BETWEEN 1 FOLLOWING AND 1 FOLLOWING) FROM values('number Int8', (1),(1),(2),(3))\n)" assert message in r.output, error(r.output) ^ is = False assert message in r.output, error(r.output) ^ is False Where File '/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../helpers/cluster.py', line 634 in 'query' 626\\| if exitcode is not None: 627\\| with Then(f"exitcode should be {exitcode}") if steps else NullStep(): 628\\| assert r.exitcode == exitcode, error(r.output) 629\\| 630\\| if message is not None: 631\\| with Then( 632\\| f"output should contain message", description=message 633\\| ) if steps else NullStep(): 634\\|> assert message in r.output, error(r.output) 635\\| 636\\| if message is None or "Exception:" not in message: 637\\| with Then("check if output has exception") if steps else NullStep():
/window functions/tests/non distributed/frame clause/range frame/between expr following and expr preceding with order by zero special case	XFail 36ms known bug	AssertionError Traceback (most recent call last): File "regression/window_functions/regression.py", line 203, in regression() File "regression/window_functions/regression.py", line 199, in regression Feature(run=load("window_functions.tests.feature", "feature"), flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/feature.py", line 72, in feature Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/frame_clause.py", line 68, in feature Feature(run=load("window_functions.tests.range_frame", "feature"), flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/range_frame.py", line 1733, in feature Scenario(run=scenario, flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/range_frame.py", line 1416, in between_expr_following_and_expr_preceding_with_order_by_zero_special_case execute_query( File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/common.py", line 144, in execute_query r = current().context.node.query( File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../helpers/cluster.py", line 641, in query assert False, error(r.output) AssertionError: Oops! Assertion failed The following assertion was not satisfied assert False, error(r.output) Description Received exception from server (version 22.3.8): Code: 36. DB::Exception: Received from localhost:9000. DB::Exception: Frame start offset 0 FOLLOWING does not precede the frame end offset 0 PRECEDING. (BAD_ARGUMENTS) (query: SELECT number,sum(number) OVER (ORDER BY number RANGE BETWEEN 0 FOLLOWING AND 0 PRECEDING) AS sum FROM values('number Int8', (1),(1),(2),(3)) FORMAT TabSeparatedWithNames ) Assertion values assert False, error(r.output) ^ is False Where File '/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../helpers/cluster.py', line 641 in 'query' 633\\| ) if steps else NullStep(): 634\\| assert message in r.output, error(r.output) 635\\| 636\\| if message is None or "Exception:" not in message: 637\\| with Then("check if output has exception") if steps else NullStep(): 638\\| if "Exception:" in r.output: 639\\| if raise_on_exception: 640\\| raise QueryRuntimeException(r.output) 641\\|> assert False, error(r.output) 642\\| 643\\| return r 644\\|
/window functions/tests/non distributed/frame clause/range frame/between expr following and expr preceding without order by error	XFail 37ms invalid error message	AssertionError Traceback (most recent call last): File "regression/window_functions/regression.py", line 203, in regression() File "regression/window_functions/regression.py", line 199, in regression Feature(run=load("window_functions.tests.feature", "feature"), flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/feature.py", line 72, in feature Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/frame_clause.py", line 68, in feature Feature(run=load("window_functions.tests.range_frame", "feature"), flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/range_frame.py", line 1733, in feature Scenario(run=scenario, flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/range_frame.py", line 1228, in between_expr_following_and_expr_preceding_without_order_by_error self.context.node.query( File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../helpers/cluster.py", line 634, in query assert message in r.output, error(r.output) AssertionError: Oops! Assertion failed The following assertion was not satisfied assert message in r.output, error(r.output) Description Received exception from server (version 22.3.8): Code: 36. DB::Exception: Received from localhost:9000. DB::Exception: Frame start offset 0 FOLLOWING does not precede the frame end offset 0 PRECEDING. (BAD_ARGUMENTS) (query: SELECT number,sum(number) OVER (RANGE BETWEEN 0 FOLLOWING AND 0 PRECEDING) FROM values('number Int8', (1),(1),(2),(3)) ) Assertion values assert message in r.output, error(r.output) ^ is 'Exception: Window frame' assert message in r.output, error(r.output) ^ is assert message in r.output, error(r.output) ^ is = "Received exception from server (version 22.3.8):\nCode: 36. DB::Exception: Received from localhost:9000. DB::Exception: Frame start offset 0 FOLLOWING does not precede the frame end offset 0 PRECEDING. (BAD_ARGUMENTS)\n(query: SELECT number,sum(number) OVER (RANGE BETWEEN 0 FOLLOWING AND 0 PRECEDING) FROM values('number Int8', (1),(1),(2),(3))\n)" assert message in r.output, error(r.output) ^ is = False assert message in r.output, error(r.output) ^ is False Where File '/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../helpers/cluster.py', line 634 in 'query' 626\\| if exitcode is not None: 627\\| with Then(f"exitcode should be {exitcode}") if steps else NullStep(): 628\\| assert r.exitcode == exitcode, error(r.output) 629\\| 630\\| if message is not None: 631\\| with Then( 632\\| f"output should contain message", description=message 633\\| ) if steps else NullStep(): 634\\|> assert message in r.output, error(r.output) 635\\| 636\\| if message is None or "Exception:" not in message: 637\\| with Then("check if output has exception") if steps else NullStep():
/window functions/tests/non distributed/frame clause/range frame/order by decimal	XFail 42ms Exception: The RANGE OFFSET frame for 'DB::ColumnDecimal >' ORDER BY column is not implemented	AssertionError Traceback (most recent call last): File "regression/window_functions/regression.py", line 203, in regression() File "regression/window_functions/regression.py", line 199, in regression Feature(run=load("window_functions.tests.feature", "feature"), flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/feature.py", line 72, in feature Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/frame_clause.py", line 68, in feature Feature(run=load("window_functions.tests.range_frame", "feature"), flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/range_frame.py", line 1733, in feature Scenario(run=scenario, flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/range_frame.py", line 1649, in order_by_decimal execute_query( File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/common.py", line 144, in execute_query r = current().context.node.query( File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../helpers/cluster.py", line 641, in query assert False, error(r.output) AssertionError: Oops! Assertion failed The following assertion was not satisfied assert False, error(r.output) Description Received exception from server (version 22.3.8): Code: 48. DB::Exception: Received from localhost:9000. DB::Exception: The RANGE OFFSET frame for 'DB::ColumnDecimal >' ORDER BY column is not implemented. (NOT_IMPLEMENTED) (query: select id, f_numeric, first_value(id) over w AS first_value, last_value(id) over w AS last_value from numerics window w as (order by f_numeric range between 1 preceding and 1 following) FORMAT TabSeparatedWithNames ) Assertion values assert False, error(r.output) ^ is False Where File '/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../helpers/cluster.py', line 641 in 'query' 633\\| ) if steps else NullStep(): 634\\| assert message in r.output, error(r.output) 635\\| 636\\| if message is None or "Exception:" not in message: 637\\| with Then("check if output has exception") if steps else NullStep(): 638\\| if "Exception:" in r.output: 639\\| if raise_on_exception: 640\\| raise QueryRuntimeException(r.output) 641\\|> assert False, error(r.output) 642\\| 643\\| return r 644\\|
/window functions/tests/non distributed/frame clause/range frame/with nulls	XFail 42ms DB::Exception: The RANGE OFFSET frame for 'DB::ColumnNullable' ORDER BY column is not implemented	AssertionError Traceback (most recent call last): File "regression/window_functions/regression.py", line 203, in regression() File "regression/window_functions/regression.py", line 199, in regression Feature(run=load("window_functions.tests.feature", "feature"), flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/feature.py", line 72, in feature Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/frame_clause.py", line 68, in feature Feature(run=load("window_functions.tests.range_frame", "feature"), flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/range_frame.py", line 1733, in feature Scenario(run=scenario, flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/range_frame.py", line 1708, in with_nulls execute_query( File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/common.py", line 144, in execute_query r = current().context.node.query( File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../helpers/cluster.py", line 641, in query assert False, error(r.output) AssertionError: Oops! Assertion failed The following assertion was not satisfied assert False, error(r.output) Description Received exception from server (version 22.3.8): Code: 48. DB::Exception: Received from localhost:9000. DB::Exception: The RANGE OFFSET frame for 'DB::ColumnNullable' ORDER BY column is not implemented. (NOT_IMPLEMENTED) (query: select x, y, first_value(y) over w AS first_value, last_value(y) over w AS last_value from (select number as x, x as y from numbers(1,5) union all select null, 42 union all select null, 43) window w as (order by x asc nulls first range between 2 preceding and 2 following) FORMAT TabSeparatedWithNames ) Assertion values assert False, error(r.output) ^ is False Where File '/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../helpers/cluster.py', line 641 in 'query' 633\\| ) if steps else NullStep(): 634\\| assert message in r.output, error(r.output) 635\\| 636\\| if message is None or "Exception:" not in message: 637\\| with Then("check if output has exception") if steps else NullStep(): 638\\| if "Exception:" in r.output: 639\\| if raise_on_exception: 640\\| raise QueryRuntimeException(r.output) 641\\|> assert False, error(r.output) 642\\| 643\\| return r 644\\|
/window functions/tests/non distributed/frame clause/range overflow/negative overflow with Int16	XFail 39ms exception on conversion	AssertionError Traceback (most recent call last): File "regression/window_functions/regression.py", line 203, in regression() File "regression/window_functions/regression.py", line 199, in regression Feature(run=load("window_functions.tests.feature", "feature"), flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/feature.py", line 72, in feature Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/frame_clause.py", line 69, in feature Feature(run=load("window_functions.tests.range_overflow", "feature"), flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/range_overflow.py", line 145, in feature Scenario(run=scenario, flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/range_overflow.py", line 42, in negative_overflow_with_Int16 execute_query( File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/common.py", line 144, in execute_query r = current().context.node.query( File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../helpers/cluster.py", line 641, in query assert False, error(r.output) AssertionError: Oops! Assertion failed The following assertion was not satisfied assert False, error(r.output) Description Received exception from server (version 22.3.8): Code: 69. DB::Exception: Received from localhost:9000. DB::Exception: Cannot convert value '2147450885': it cannot be represented as Int16. (ARGUMENT_OUT_OF_BOUND) (query: select number as x, last_value(x) over (order by toInt16(x) desc range between current row and 2147450885 following) as last_value from (SELECT -number - 32763 AS number FROM numbers(1, 3)) FORMAT TabSeparatedWithNames ) Assertion values assert False, error(r.output) ^ is False Where File '/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../helpers/cluster.py', line 641 in 'query' 633\\| ) if steps else NullStep(): 634\\| assert message in r.output, error(r.output) 635\\| 636\\| if message is None or "Exception:" not in message: 637\\| with Then("check if output has exception") if steps else NullStep(): 638\\| if "Exception:" in r.output: 639\\| if raise_on_exception: 640\\| raise QueryRuntimeException(r.output) 641\\|> assert False, error(r.output) 642\\| 643\\| return r 644\\|
/window functions/tests/non distributed/frame clause/range overflow/positive overflow with Int16	XFail 49ms exception on conversion	AssertionError Traceback (most recent call last): File "regression/window_functions/regression.py", line 203, in regression() File "regression/window_functions/regression.py", line 199, in regression Feature(run=load("window_functions.tests.feature", "feature"), flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/feature.py", line 72, in feature Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/frame_clause.py", line 69, in feature Feature(run=load("window_functions.tests.range_overflow", "feature"), flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/range_overflow.py", line 145, in feature Scenario(run=scenario, flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/range_overflow.py", line 20, in positive_overflow_with_Int16 execute_query( File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/common.py", line 144, in execute_query r = current().context.node.query( File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../helpers/cluster.py", line 641, in query assert False, error(r.output) AssertionError: Oops! Assertion failed The following assertion was not satisfied assert False, error(r.output) Description Received exception from server (version 22.3.8): Code: 69. DB::Exception: Received from localhost:9000. DB::Exception: Cannot convert value '2147450884': it cannot be represented as Int16. (ARGUMENT_OUT_OF_BOUND) (query: select number as x, last_value(x) over (order by toInt16(x) range between current row and 2147450884 following) AS last_value from numbers(32764, 3) FORMAT TabSeparatedWithNames ) Assertion values assert False, error(r.output) ^ is False Where File '/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../helpers/cluster.py', line 641 in 'query' 633\\| ) if steps else NullStep(): 634\\| assert message in r.output, error(r.output) 635\\| 636\\| if message is None or "Exception:" not in message: 637\\| with Then("check if output has exception") if steps else NullStep(): 638\\| if "Exception:" in r.output: 639\\| if raise_on_exception: 640\\| raise QueryRuntimeException(r.output) 641\\|> assert False, error(r.output) 642\\| 643\\| return r 644\\|
/window functions/tests/non distributed/frame clause/range errors/error negative following offset	XFail 36ms https://github.com/ClickHouse/ClickHouse/issues/22442	AssertionError Traceback (most recent call last): File "regression/window_functions/regression.py", line 203, in regression() File "regression/window_functions/regression.py", line 199, in regression Feature(run=load("window_functions.tests.feature", "feature"), flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/feature.py", line 72, in feature Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/frame_clause.py", line 71, in feature Feature(run=load("window_functions.tests.range_errors", "feature"), flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/range_errors.py", line 114, in feature Scenario(run=scenario, flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/range_errors.py", line 105, in error_negative_following_offset r = current().context.node.query(sql, exitcode=exitcode, message=message) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../helpers/cluster.py", line 634, in query assert message in r.output, error(r.output) AssertionError: Oops! Assertion failed The following assertion was not satisfied assert message in r.output, error(r.output) Description Received exception from server (version 22.3.8): Code: 36. DB::Exception: Received from localhost:9000. DB::Exception: Window frame start offset must be nonnegative, -2 given. (BAD_ARGUMENTS) (query: select max(enroll_date) over (order by salary range between 1 preceding and -2 following) AS max, salary, enroll_date from empsalary ) Assertion values assert message in r.output, error(r.output) ^ is 'DB::Exception: Frame end offset must be greater than zero, -2 given' assert message in r.output, error(r.output) ^ is assert message in r.output, error(r.output) ^ is = 'Received exception from server (version 22.3.8):\nCode: 36. DB::Exception: Received from localhost:9000. DB::Exception: Window frame start offset must be nonnegative, -2 given. (BAD_ARGUMENTS)\n(query: select max(enroll_date) over (order by salary range between 1 preceding and -2 following) AS max, salary, enroll_date from empsalary\n)' assert message in r.output, error(r.output) ^ is = False assert message in r.output, error(r.output) ^ is False Where File '/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../helpers/cluster.py', line 634 in 'query' 626\\| if exitcode is not None: 627\\| with Then(f"exitcode should be {exitcode}") if steps else NullStep(): 628\\| assert r.exitcode == exitcode, error(r.output) 629\\| 630\\| if message is not None: 631\\| with Then( 632\\| f"output should contain message", description=message 633\\| ) if steps else NullStep(): 634\\|> assert message in r.output, error(r.output) 635\\| 636\\| if message is None or "Exception:" not in message: 637\\| with Then("check if output has exception") if steps else NullStep():
/window functions/tests/non distributed/frame clause/range errors/error negative preceding offset	XFail 39ms https://github.com/ClickHouse/ClickHouse/issues/22442	AssertionError Traceback (most recent call last): File "regression/window_functions/regression.py", line 203, in regression() File "regression/window_functions/regression.py", line 199, in regression Feature(run=load("window_functions.tests.feature", "feature"), flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/feature.py", line 72, in feature Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/frame_clause.py", line 71, in feature Feature(run=load("window_functions.tests.range_errors", "feature"), flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/range_errors.py", line 114, in feature Scenario(run=scenario, flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/range_errors.py", line 89, in error_negative_preceding_offset r = current().context.node.query(sql, exitcode=exitcode, message=message) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../helpers/cluster.py", line 634, in query assert message in r.output, error(r.output) AssertionError: Oops! Assertion failed The following assertion was not satisfied assert message in r.output, error(r.output) Description Received exception from server (version 22.3.8): Code: 36. DB::Exception: Received from localhost:9000. DB::Exception: Window frame start offset must be nonnegative, -1 given. (BAD_ARGUMENTS) (query: select max(enroll_date) over (order by salary range between -1 preceding and 2 following) AS max, salary, enroll_date from empsalary ) Assertion values assert message in r.output, error(r.output) ^ is 'DB::Exception: Frame start offset must be greater than zero, -1 given' assert message in r.output, error(r.output) ^ is assert message in r.output, error(r.output) ^ is = 'Received exception from server (version 22.3.8):\nCode: 36. DB::Exception: Received from localhost:9000. DB::Exception: Window frame start offset must be nonnegative, -1 given. (BAD_ARGUMENTS)\n(query: select max(enroll_date) over (order by salary range between -1 preceding and 2 following) AS max, salary, enroll_date from empsalary\n)' assert message in r.output, error(r.output) ^ is = False assert message in r.output, error(r.output) ^ is False Where File '/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../helpers/cluster.py', line 634 in 'query' 626\\| if exitcode is not None: 627\\| with Then(f"exitcode should be {exitcode}") if steps else NullStep(): 628\\| assert r.exitcode == exitcode, error(r.output) 629\\| 630\\| if message is not None: 631\\| with Then( 632\\| f"output should contain message", description=message 633\\| ) if steps else NullStep(): 634\\|> assert message in r.output, error(r.output) 635\\| 636\\| if message is None or "Exception:" not in message: 637\\| with Then("check if output has exception") if steps else NullStep():
/window functions/tests/non distributed/misc/window functions in select expression	XFail 36ms not supported, https://github.com/ClickHouse/ClickHouse/issues/19857	AssertionError Traceback (most recent call last): File "regression/window_functions/regression.py", line 203, in regression() File "regression/window_functions/regression.py", line 199, in regression Feature(run=load("window_functions.tests.feature", "feature"), flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/feature.py", line 79, in feature Feature(run=load("window_functions.tests.misc", "feature"), flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/misc.py", line 428, in feature Scenario(run=scenario, flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/misc.py", line 56, in window_functions_in_select_expression execute_query( File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/common.py", line 144, in execute_query r = current().context.node.query( File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../helpers/cluster.py", line 641, in query assert False, error(r.output) AssertionError: Oops! Assertion failed The following assertion was not satisfied assert False, error(r.output) Description Received exception from server (version 22.3.8): Code: 47. DB::Exception: Received from localhost:9000. DB::Exception: Unknown identifier: count() OVER (PARTITION BY four ORDER BY ten ASC); there are columns: less(unique2, 10), 10, 10, unique2, four, ten, hundred: While processing count() OVER (PARTITION BY four ORDER BY ten ASC) + sum(hundred) OVER (PARTITION BY four ORDER BY ten ASC). (UNKNOWN_IDENTIFIER) (query: SELECT (count(*) OVER (PARTITION BY four ORDER BY ten) + sum(hundred) OVER (PARTITION BY four ORDER BY ten)) AS cntsum FROM tenk1 WHERE unique2 < 10 FORMAT TabSeparatedWithNames ) Assertion values assert False, error(r.output) ^ is False Where File '/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../helpers/cluster.py', line 641 in 'query' 633\\| ) if steps else NullStep(): 634\\| assert message in r.output, error(r.output) 635\\| 636\\| if message is None or "Exception:" not in message: 637\\| with Then("check if output has exception") if steps else NullStep(): 638\\| if "Exception:" in r.output: 639\\| if raise_on_exception: 640\\| raise QueryRuntimeException(r.output) 641\\|> assert False, error(r.output) 642\\| 643\\| return r 644\\|
/window functions/tests/non distributed/misc/window functions in subquery	XFail 39ms not supported, https://github.com/ClickHouse/ClickHouse/issues/19857	AssertionError Traceback (most recent call last): File "regression/window_functions/regression.py", line 203, in regression() File "regression/window_functions/regression.py", line 199, in regression Feature(run=load("window_functions.tests.feature", "feature"), flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/feature.py", line 79, in feature Feature(run=load("window_functions.tests.misc", "feature"), flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/misc.py", line 428, in feature Scenario(run=scenario, flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/misc.py", line 74, in window_functions_in_subquery execute_query( File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/common.py", line 144, in execute_query r = current().context.node.query( File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../helpers/cluster.py", line 641, in query assert False, error(r.output) AssertionError: Oops! Assertion failed The following assertion was not satisfied assert False, error(r.output) Description Received exception from server (version 22.3.8): Code: 47. DB::Exception: Received from localhost:9000. DB::Exception: Unknown identifier: count() OVER (PARTITION BY four ORDER BY ten ASC); there are columns: two, four, ten, hundred: While processing count() OVER (PARTITION BY four ORDER BY ten ASC) + sum(hundred) OVER (PARTITION BY two ORDER BY ten ASC) AS total, count() OVER (PARTITION BY four ORDER BY ten ASC) AS fourcount, sum(hundred) OVER (PARTITION BY two ORDER BY ten ASC) AS twosum. (UNKNOWN_IDENTIFIER) (query: SELECT * FROM ( SELECT count() OVER (PARTITION BY four ORDER BY ten) + sum(hundred) OVER (PARTITION BY two ORDER BY ten) AS total, count() OVER (PARTITION BY four ORDER BY ten) AS fourcount, sum(hundred) OVER (PARTITION BY two ORDER BY ten) AS twosum FROM tenk1 ) WHERE total <> fourcount + twosum FORMAT TabSeparatedWithNames ) Assertion values assert False, error(r.output) ^ is False Where File '/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../helpers/cluster.py', line 641 in 'query' 633\\| ) if steps else NullStep(): 634\\| assert message in r.output, error(r.output) 635\\| 636\\| if message is None or "Exception:" not in message: 637\\| with Then("check if output has exception") if steps else NullStep(): 638\\| if "Exception:" in r.output: 639\\| if raise_on_exception: 640\\| raise QueryRuntimeException(r.output) 641\\|> assert False, error(r.output) 642\\| 643\\| return r 644\\|
/window functions/tests/distributed/frame clause/range frame/between current row and unbounded following modifying named window	XFail 41ms range with named window is not supported	AssertionError Traceback (most recent call last): File "regression/window_functions/regression.py", line 203, in regression() File "regression/window_functions/regression.py", line 199, in regression Feature(run=load("window_functions.tests.feature", "feature"), flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/feature.py", line 72, in feature Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/frame_clause.py", line 68, in feature Feature(run=load("window_functions.tests.range_frame", "feature"), flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/range_frame.py", line 1733, in feature Scenario(run=scenario, flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/range_frame.py", line 1520, in between_current_row_and_unbounded_following_modifying_named_window execute_query( File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/common.py", line 156, in execute_query assert r.output.strip() == expected, error() AssertionError: Oops! Assertion failed The following assertion was not satisfied assert r.output.strip() == expected, error() Assertion values assert r.output.strip() == expected, error() ^ is assert r.output.strip() == expected, error() ^ is = 'sum\tunique1\tfour\n45\t0\t0\n33\t1\t1\n18\t2\t2\n10\t3\t3\n45\t4\t0\n33\t5\t1\n18\t6\t2\n10\t7\t3\n45\t8\t0\n33\t9\t1' assert r.output.strip() == expected, error() ^ is 'sum\tunique1\tfour\n45\t0\t0\n33\t1\t1\n18\t2\t2\n10\t3\t3\n45\t4\t0\n33\t5\t1\n18\t6\t2\n10\t7\t3\n45\t8\t0\n33\t9\t1' assert r.output.strip() == expected, error() ^ is = assert r.output.strip() == expected, error() ^ is = 'sum\tunique1\tfour\n45\t0\t0\n33\t1\t1\n18\t2\t2\n10\t3\t3\n45\t4\t0\n33\t5\t1\n18\t6\t2\n10\t7\t3\n45\t8\t0\n33\t9\t1' assert r.output.strip() == expected, error() ^ is 'sum\tunique1\tfour\n45\t0\t0\n45\t8\t0\n45\t4\t0\n33\t5\t1\n33\t9\t1\n33\t1\t1\n18\t6\t2\n18\t2\t2\n10\t3\t3\n10\t7\t3' assert r.output.strip() == expected, error() ^ is = False @@ -2,0 +3,4 @@ +45 8 0 +45 4 0 +33 5 1 +33 9 1 @@ -3,0 +8 @@ +18 6 2 @@ -6,3 +10,0 @@ -45 4 0 -33 5 1 -18 6 2 @@ -10,2 +11,0 @@ -45 8 0 -33 9 1 assert r.output.strip() == expected, error() ^ is False Where File '/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/common.py', line 156 in 'execute_query' 148\\| no_checks=no_checks, 149\\| ) 150\\| if no_checks: 151\\| return r 152\\| 153\\| if message is None: 154\\| if expected is not None: 155\\| with Then("I check output against expected"): 156\\|> assert r.output.strip() == expected, error() 157\\| else: 158\\| with Then("I check output against snapshot"): 159\\| with values() as that:
/window functions/tests/distributed/frame clause/range frame/between expr following and current row zero special case	XFail 33ms known bug	AssertionError Traceback (most recent call last): File "regression/window_functions/regression.py", line 203, in regression() File "regression/window_functions/regression.py", line 199, in regression Feature(run=load("window_functions.tests.feature", "feature"), flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/feature.py", line 72, in feature Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/frame_clause.py", line 68, in feature Feature(run=load("window_functions.tests.range_frame", "feature"), flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/range_frame.py", line 1733, in feature Scenario(run=scenario, flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/range_frame.py", line 1347, in between_expr_following_and_current_row_zero_special_case execute_query( File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/common.py", line 144, in execute_query r = current().context.node.query( File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../helpers/cluster.py", line 641, in query assert False, error(r.output) AssertionError: Oops! Assertion failed The following assertion was not satisfied assert False, error(r.output) Description Received exception from server (version 22.3.8): Code: 36. DB::Exception: Received from localhost:9000. DB::Exception: Window frame 'Range BETWEEN 0 FOLLOWING AND CURRENT ROW' is invalid. (BAD_ARGUMENTS) (query: SELECT number,sum(number) OVER (ORDER BY number RANGE BETWEEN 0 FOLLOWING AND CURRENT ROW) AS sum FROM values('number Int8', (1),(1),(2),(3)) FORMAT TabSeparatedWithNames ) Assertion values assert False, error(r.output) ^ is False Where File '/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../helpers/cluster.py', line 641 in 'query' 633\\| ) if steps else NullStep(): 634\\| assert message in r.output, error(r.output) 635\\| 636\\| if message is None or "Exception:" not in message: 637\\| with Then("check if output has exception") if steps else NullStep(): 638\\| if "Exception:" in r.output: 639\\| if raise_on_exception: 640\\| raise QueryRuntimeException(r.output) 641\\|> assert False, error(r.output) 642\\| 643\\| return r 644\\|
/window functions/tests/distributed/frame clause/range frame/between expr following and expr following without order by error	XFail 33ms invalid error message	AssertionError Traceback (most recent call last): File "regression/window_functions/regression.py", line 203, in regression() File "regression/window_functions/regression.py", line 199, in regression Feature(run=load("window_functions.tests.feature", "feature"), flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/feature.py", line 72, in feature Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/frame_clause.py", line 68, in feature Feature(run=load("window_functions.tests.range_frame", "feature"), flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/range_frame.py", line 1733, in feature Scenario(run=scenario, flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/range_frame.py", line 1211, in between_expr_following_and_expr_following_without_order_by_error self.context.node.query( File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../helpers/cluster.py", line 634, in query assert message in r.output, error(r.output) AssertionError: Oops! Assertion failed The following assertion was not satisfied assert message in r.output, error(r.output) Description Received exception from server (version 22.3.8): Code: 36. DB::Exception: Received from localhost:9000. DB::Exception: The RANGE OFFSET window frame requires exactly one ORDER BY column, 0 given. (BAD_ARGUMENTS) (query: SELECT number,sum(number) OVER (RANGE BETWEEN 1 FOLLOWING AND 1 FOLLOWING) FROM values('number Int8', (1),(1),(2),(3)) ) Assertion values assert message in r.output, error(r.output) ^ is 'Exception: Window frame' assert message in r.output, error(r.output) ^ is assert message in r.output, error(r.output) ^ is = "Received exception from server (version 22.3.8):\nCode: 36. DB::Exception: Received from localhost:9000. DB::Exception: The RANGE OFFSET window frame requires exactly one ORDER BY column, 0 given. (BAD_ARGUMENTS)\n(query: SELECT number,sum(number) OVER (RANGE BETWEEN 1 FOLLOWING AND 1 FOLLOWING) FROM values('number Int8', (1),(1),(2),(3))\n)" assert message in r.output, error(r.output) ^ is = False assert message in r.output, error(r.output) ^ is False Where File '/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../helpers/cluster.py', line 634 in 'query' 626\\| if exitcode is not None: 627\\| with Then(f"exitcode should be {exitcode}") if steps else NullStep(): 628\\| assert r.exitcode == exitcode, error(r.output) 629\\| 630\\| if message is not None: 631\\| with Then( 632\\| f"output should contain message", description=message 633\\| ) if steps else NullStep(): 634\\|> assert message in r.output, error(r.output) 635\\| 636\\| if message is None or "Exception:" not in message: 637\\| with Then("check if output has exception") if steps else NullStep():
/window functions/tests/distributed/frame clause/range frame/between expr following and expr preceding with order by zero special case	XFail 36ms known bug	AssertionError Traceback (most recent call last): File "regression/window_functions/regression.py", line 203, in regression() File "regression/window_functions/regression.py", line 199, in regression Feature(run=load("window_functions.tests.feature", "feature"), flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/feature.py", line 72, in feature Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/frame_clause.py", line 68, in feature Feature(run=load("window_functions.tests.range_frame", "feature"), flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/range_frame.py", line 1733, in feature Scenario(run=scenario, flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/range_frame.py", line 1416, in between_expr_following_and_expr_preceding_with_order_by_zero_special_case execute_query( File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/common.py", line 144, in execute_query r = current().context.node.query( File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../helpers/cluster.py", line 641, in query assert False, error(r.output) AssertionError: Oops! Assertion failed The following assertion was not satisfied assert False, error(r.output) Description Received exception from server (version 22.3.8): Code: 36. DB::Exception: Received from localhost:9000. DB::Exception: Frame start offset 0 FOLLOWING does not precede the frame end offset 0 PRECEDING. (BAD_ARGUMENTS) (query: SELECT number,sum(number) OVER (ORDER BY number RANGE BETWEEN 0 FOLLOWING AND 0 PRECEDING) AS sum FROM values('number Int8', (1),(1),(2),(3)) FORMAT TabSeparatedWithNames ) Assertion values assert False, error(r.output) ^ is False Where File '/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../helpers/cluster.py', line 641 in 'query' 633\\| ) if steps else NullStep(): 634\\| assert message in r.output, error(r.output) 635\\| 636\\| if message is None or "Exception:" not in message: 637\\| with Then("check if output has exception") if steps else NullStep(): 638\\| if "Exception:" in r.output: 639\\| if raise_on_exception: 640\\| raise QueryRuntimeException(r.output) 641\\|> assert False, error(r.output) 642\\| 643\\| return r 644\\|
/window functions/tests/distributed/frame clause/range frame/between expr following and expr preceding without order by error	XFail 35ms invalid error message	AssertionError Traceback (most recent call last): File "regression/window_functions/regression.py", line 203, in regression() File "regression/window_functions/regression.py", line 199, in regression Feature(run=load("window_functions.tests.feature", "feature"), flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/feature.py", line 72, in feature Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/frame_clause.py", line 68, in feature Feature(run=load("window_functions.tests.range_frame", "feature"), flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/range_frame.py", line 1733, in feature Scenario(run=scenario, flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/range_frame.py", line 1228, in between_expr_following_and_expr_preceding_without_order_by_error self.context.node.query( File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../helpers/cluster.py", line 634, in query assert message in r.output, error(r.output) AssertionError: Oops! Assertion failed The following assertion was not satisfied assert message in r.output, error(r.output) Description Received exception from server (version 22.3.8): Code: 36. DB::Exception: Received from localhost:9000. DB::Exception: Frame start offset 0 FOLLOWING does not precede the frame end offset 0 PRECEDING. (BAD_ARGUMENTS) (query: SELECT number,sum(number) OVER (RANGE BETWEEN 0 FOLLOWING AND 0 PRECEDING) FROM values('number Int8', (1),(1),(2),(3)) ) Assertion values assert message in r.output, error(r.output) ^ is 'Exception: Window frame' assert message in r.output, error(r.output) ^ is assert message in r.output, error(r.output) ^ is = "Received exception from server (version 22.3.8):\nCode: 36. DB::Exception: Received from localhost:9000. DB::Exception: Frame start offset 0 FOLLOWING does not precede the frame end offset 0 PRECEDING. (BAD_ARGUMENTS)\n(query: SELECT number,sum(number) OVER (RANGE BETWEEN 0 FOLLOWING AND 0 PRECEDING) FROM values('number Int8', (1),(1),(2),(3))\n)" assert message in r.output, error(r.output) ^ is = False assert message in r.output, error(r.output) ^ is False Where File '/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../helpers/cluster.py', line 634 in 'query' 626\\| if exitcode is not None: 627\\| with Then(f"exitcode should be {exitcode}") if steps else NullStep(): 628\\| assert r.exitcode == exitcode, error(r.output) 629\\| 630\\| if message is not None: 631\\| with Then( 632\\| f"output should contain message", description=message 633\\| ) if steps else NullStep(): 634\\|> assert message in r.output, error(r.output) 635\\| 636\\| if message is None or "Exception:" not in message: 637\\| with Then("check if output has exception") if steps else NullStep():
/window functions/tests/distributed/frame clause/range frame/order by decimal	XFail 36ms Exception: The RANGE OFFSET frame for 'DB::ColumnDecimal >' ORDER BY column is not implemented	AssertionError Traceback (most recent call last): File "regression/window_functions/regression.py", line 203, in regression() File "regression/window_functions/regression.py", line 199, in regression Feature(run=load("window_functions.tests.feature", "feature"), flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/feature.py", line 72, in feature Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/frame_clause.py", line 68, in feature Feature(run=load("window_functions.tests.range_frame", "feature"), flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/range_frame.py", line 1733, in feature Scenario(run=scenario, flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/range_frame.py", line 1649, in order_by_decimal execute_query( File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/common.py", line 144, in execute_query r = current().context.node.query( File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../helpers/cluster.py", line 641, in query assert False, error(r.output) AssertionError: Oops! Assertion failed The following assertion was not satisfied assert False, error(r.output) Description Received exception from server (version 22.3.8): Code: 48. DB::Exception: Received from localhost:9000. DB::Exception: The RANGE OFFSET frame for 'DB::ColumnDecimal >' ORDER BY column is not implemented. (NOT_IMPLEMENTED) (query: select id, f_numeric, first_value(id) over w AS first_value, last_value(id) over w AS last_value from numerics window w as (order by f_numeric range between 1 preceding and 1 following) FORMAT TabSeparatedWithNames ) Assertion values assert False, error(r.output) ^ is False Where File '/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../helpers/cluster.py', line 641 in 'query' 633\\| ) if steps else NullStep(): 634\\| assert message in r.output, error(r.output) 635\\| 636\\| if message is None or "Exception:" not in message: 637\\| with Then("check if output has exception") if steps else NullStep(): 638\\| if "Exception:" in r.output: 639\\| if raise_on_exception: 640\\| raise QueryRuntimeException(r.output) 641\\|> assert False, error(r.output) 642\\| 643\\| return r 644\\|
/window functions/tests/distributed/frame clause/range frame/with nulls	XFail 41ms DB::Exception: The RANGE OFFSET frame for 'DB::ColumnNullable' ORDER BY column is not implemented	AssertionError Traceback (most recent call last): File "regression/window_functions/regression.py", line 203, in regression() File "regression/window_functions/regression.py", line 199, in regression Feature(run=load("window_functions.tests.feature", "feature"), flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/feature.py", line 72, in feature Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/frame_clause.py", line 68, in feature Feature(run=load("window_functions.tests.range_frame", "feature"), flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/range_frame.py", line 1733, in feature Scenario(run=scenario, flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/range_frame.py", line 1708, in with_nulls execute_query( File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/common.py", line 144, in execute_query r = current().context.node.query( File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../helpers/cluster.py", line 641, in query assert False, error(r.output) AssertionError: Oops! Assertion failed The following assertion was not satisfied assert False, error(r.output) Description Received exception from server (version 22.3.8): Code: 48. DB::Exception: Received from localhost:9000. DB::Exception: The RANGE OFFSET frame for 'DB::ColumnNullable' ORDER BY column is not implemented. (NOT_IMPLEMENTED) (query: select x, y, first_value(y) over w AS first_value, last_value(y) over w AS last_value from (select number as x, x as y from numbers(1,5) union all select null, 42 union all select null, 43) window w as (order by x asc nulls first range between 2 preceding and 2 following) FORMAT TabSeparatedWithNames ) Assertion values assert False, error(r.output) ^ is False Where File '/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../helpers/cluster.py', line 641 in 'query' 633\\| ) if steps else NullStep(): 634\\| assert message in r.output, error(r.output) 635\\| 636\\| if message is None or "Exception:" not in message: 637\\| with Then("check if output has exception") if steps else NullStep(): 638\\| if "Exception:" in r.output: 639\\| if raise_on_exception: 640\\| raise QueryRuntimeException(r.output) 641\\|> assert False, error(r.output) 642\\| 643\\| return r 644\\|
/window functions/tests/distributed/frame clause/range overflow/negative overflow with Int16	XFail 36ms exception on conversion	AssertionError Traceback (most recent call last): File "regression/window_functions/regression.py", line 203, in regression() File "regression/window_functions/regression.py", line 199, in regression Feature(run=load("window_functions.tests.feature", "feature"), flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/feature.py", line 72, in feature Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/frame_clause.py", line 69, in feature Feature(run=load("window_functions.tests.range_overflow", "feature"), flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/range_overflow.py", line 145, in feature Scenario(run=scenario, flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/range_overflow.py", line 42, in negative_overflow_with_Int16 execute_query( File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/common.py", line 144, in execute_query r = current().context.node.query( File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../helpers/cluster.py", line 641, in query assert False, error(r.output) AssertionError: Oops! Assertion failed The following assertion was not satisfied assert False, error(r.output) Description Received exception from server (version 22.3.8): Code: 69. DB::Exception: Received from localhost:9000. DB::Exception: Cannot convert value '2147450885': it cannot be represented as Int16. (ARGUMENT_OUT_OF_BOUND) (query: select number as x, last_value(x) over (order by toInt16(x) desc range between current row and 2147450885 following) as last_value from (SELECT -number - 32763 AS number FROM numbers(1, 3)) FORMAT TabSeparatedWithNames ) Assertion values assert False, error(r.output) ^ is False Where File '/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../helpers/cluster.py', line 641 in 'query' 633\\| ) if steps else NullStep(): 634\\| assert message in r.output, error(r.output) 635\\| 636\\| if message is None or "Exception:" not in message: 637\\| with Then("check if output has exception") if steps else NullStep(): 638\\| if "Exception:" in r.output: 639\\| if raise_on_exception: 640\\| raise QueryRuntimeException(r.output) 641\\|> assert False, error(r.output) 642\\| 643\\| return r 644\\|
/window functions/tests/distributed/frame clause/range overflow/positive overflow with Int16	XFail 42ms exception on conversion	AssertionError Traceback (most recent call last): File "regression/window_functions/regression.py", line 203, in regression() File "regression/window_functions/regression.py", line 199, in regression Feature(run=load("window_functions.tests.feature", "feature"), flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/feature.py", line 72, in feature Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/frame_clause.py", line 69, in feature Feature(run=load("window_functions.tests.range_overflow", "feature"), flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/range_overflow.py", line 145, in feature Scenario(run=scenario, flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/range_overflow.py", line 20, in positive_overflow_with_Int16 execute_query( File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/common.py", line 144, in execute_query r = current().context.node.query( File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../helpers/cluster.py", line 641, in query assert False, error(r.output) AssertionError: Oops! Assertion failed The following assertion was not satisfied assert False, error(r.output) Description Received exception from server (version 22.3.8): Code: 69. DB::Exception: Received from localhost:9000. DB::Exception: Cannot convert value '2147450884': it cannot be represented as Int16. (ARGUMENT_OUT_OF_BOUND) (query: select number as x, last_value(x) over (order by toInt16(x) range between current row and 2147450884 following) AS last_value from numbers(32764, 3) FORMAT TabSeparatedWithNames ) Assertion values assert False, error(r.output) ^ is False Where File '/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../helpers/cluster.py', line 641 in 'query' 633\\| ) if steps else NullStep(): 634\\| assert message in r.output, error(r.output) 635\\| 636\\| if message is None or "Exception:" not in message: 637\\| with Then("check if output has exception") if steps else NullStep(): 638\\| if "Exception:" in r.output: 639\\| if raise_on_exception: 640\\| raise QueryRuntimeException(r.output) 641\\|> assert False, error(r.output) 642\\| 643\\| return r 644\\|
/window functions/tests/distributed/frame clause/range datetime/order by asc range between days preceding and days following	XFail 37ms https://github.com/ClickHouse/ClickHouse/issues/23902	AssertionError Traceback (most recent call last): File "regression/window_functions/regression.py", line 203, in regression() File "regression/window_functions/regression.py", line 199, in regression Feature(run=load("window_functions.tests.feature", "feature"), flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/feature.py", line 72, in feature Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/frame_clause.py", line 70, in feature Feature(run=load("window_functions.tests.range_datetime", "feature"), flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/range_datetime.py", line 264, in feature Scenario(run=scenario, flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/range_datetime.py", line 29, in order_by_asc_range_between_days_preceding_and_days_following execute_query( File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/common.py", line 144, in execute_query r = current().context.node.query( File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../helpers/cluster.py", line 641, in query assert False, error(r.output) AssertionError: Oops! Assertion failed The following assertion was not satisfied assert False, error(r.output) Description Received exception from server (version 22.3.8): Code: 10. DB::Exception: Received from localhost:9000. DB::Exception: Not found column empno in block. There are only columns: salary, enroll_date, sum(salary) OVER (ORDER BY enroll_date ASC Range BETWEEN 365 PRECEDING AND 365 FOLLOWING). (NOT_FOUND_COLUMN_IN_BLOCK) (query: select sum(salary) over (order by enroll_date range between 365 preceding and 365 following) AS sum, salary, enroll_date from empsalary order by empno FORMAT TabSeparatedWithNames ) Assertion values assert False, error(r.output) ^ is False Where File '/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../helpers/cluster.py', line 641 in 'query' 633\\| ) if steps else NullStep(): 634\\| assert message in r.output, error(r.output) 635\\| 636\\| if message is None or "Exception:" not in message: 637\\| with Then("check if output has exception") if steps else NullStep(): 638\\| if "Exception:" in r.output: 639\\| if raise_on_exception: 640\\| raise QueryRuntimeException(r.output) 641\\|> assert False, error(r.output) 642\\| 643\\| return r 644\\|
/window functions/tests/distributed/frame clause/range datetime/order by desc range between days following and days following	XFail 37ms https://github.com/ClickHouse/ClickHouse/issues/23902	AssertionError Traceback (most recent call last): File "regression/window_functions/regression.py", line 203, in regression() File "regression/window_functions/regression.py", line 199, in regression Feature(run=load("window_functions.tests.feature", "feature"), flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/feature.py", line 72, in feature Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/frame_clause.py", line 70, in feature Feature(run=load("window_functions.tests.range_datetime", "feature"), flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/range_datetime.py", line 264, in feature Scenario(run=scenario, flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/range_datetime.py", line 86, in order_by_desc_range_between_days_following_and_days_following execute_query( File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/common.py", line 144, in execute_query r = current().context.node.query( File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../helpers/cluster.py", line 641, in query assert False, error(r.output) AssertionError: Oops! Assertion failed The following assertion was not satisfied assert False, error(r.output) Description Received exception from server (version 22.3.8): Code: 10. DB::Exception: Received from localhost:9000. DB::Exception: Not found column empno in block. There are only columns: salary, enroll_date, sum(salary) OVER (ORDER BY enroll_date DESC Range BETWEEN 365 FOLLOWING AND 365 FOLLOWING). (NOT_FOUND_COLUMN_IN_BLOCK) (query: select sum(salary) over (order by enroll_date desc range between 365 following and 365 following) AS sum, salary, enroll_date from empsalary order by empno FORMAT TabSeparatedWithNames ) Assertion values assert False, error(r.output) ^ is False Where File '/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../helpers/cluster.py', line 641 in 'query' 633\\| ) if steps else NullStep(): 634\\| assert message in r.output, error(r.output) 635\\| 636\\| if message is None or "Exception:" not in message: 637\\| with Then("check if output has exception") if steps else NullStep(): 638\\| if "Exception:" in r.output: 639\\| if raise_on_exception: 640\\| raise QueryRuntimeException(r.output) 641\\|> assert False, error(r.output) 642\\| 643\\| return r 644\\|
/window functions/tests/distributed/frame clause/range datetime/order by desc range between days preceding and days following	XFail 38ms https://github.com/ClickHouse/ClickHouse/issues/23902	AssertionError Traceback (most recent call last): File "regression/window_functions/regression.py", line 203, in regression() File "regression/window_functions/regression.py", line 199, in regression Feature(run=load("window_functions.tests.feature", "feature"), flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/feature.py", line 72, in feature Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/frame_clause.py", line 70, in feature Feature(run=load("window_functions.tests.range_datetime", "feature"), flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/range_datetime.py", line 264, in feature Scenario(run=scenario, flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/range_datetime.py", line 57, in order_by_desc_range_between_days_preceding_and_days_following execute_query( File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/common.py", line 144, in execute_query r = current().context.node.query( File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../helpers/cluster.py", line 641, in query assert False, error(r.output) AssertionError: Oops! Assertion failed The following assertion was not satisfied assert False, error(r.output) Description Received exception from server (version 22.3.8): Code: 10. DB::Exception: Received from localhost:9000. DB::Exception: Not found column empno in block. There are only columns: salary, enroll_date, sum(salary) OVER (ORDER BY enroll_date DESC Range BETWEEN 365 PRECEDING AND 365 FOLLOWING). (NOT_FOUND_COLUMN_IN_BLOCK) (query: select sum(salary) over (order by enroll_date desc range between 365 preceding and 365 following) AS sum, salary, enroll_date from empsalary order by empno FORMAT TabSeparatedWithNames ) Assertion values assert False, error(r.output) ^ is False Where File '/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../helpers/cluster.py', line 641 in 'query' 633\\| ) if steps else NullStep(): 634\\| assert message in r.output, error(r.output) 635\\| 636\\| if message is None or "Exception:" not in message: 637\\| with Then("check if output has exception") if steps else NullStep(): 638\\| if "Exception:" in r.output: 639\\| if raise_on_exception: 640\\| raise QueryRuntimeException(r.output) 641\\|> assert False, error(r.output) 642\\| 643\\| return r 644\\|
/window functions/tests/distributed/frame clause/range datetime/order by desc range between days preceding and days preceding	XFail 38ms https://github.com/ClickHouse/ClickHouse/issues/23902	AssertionError Traceback (most recent call last): File "regression/window_functions/regression.py", line 203, in regression() File "regression/window_functions/regression.py", line 199, in regression Feature(run=load("window_functions.tests.feature", "feature"), flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/feature.py", line 72, in feature Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/frame_clause.py", line 70, in feature Feature(run=load("window_functions.tests.range_datetime", "feature"), flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/range_datetime.py", line 264, in feature Scenario(run=scenario, flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/range_datetime.py", line 115, in order_by_desc_range_between_days_preceding_and_days_preceding execute_query( File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/common.py", line 144, in execute_query r = current().context.node.query( File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../helpers/cluster.py", line 641, in query assert False, error(r.output) AssertionError: Oops! Assertion failed The following assertion was not satisfied assert False, error(r.output) Description Received exception from server (version 22.3.8): Code: 10. DB::Exception: Received from localhost:9000. DB::Exception: Not found column empno in block. There are only columns: salary, enroll_date, sum(salary) OVER (ORDER BY enroll_date DESC Range BETWEEN 365 PRECEDING AND 365 PRECEDING). (NOT_FOUND_COLUMN_IN_BLOCK) (query: select sum(salary) over (order by enroll_date desc range between 365 preceding and 365 preceding) AS sum, salary, enroll_date from empsalary order by empno FORMAT TabSeparatedWithNames ) Assertion values assert False, error(r.output) ^ is False Where File '/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../helpers/cluster.py', line 641 in 'query' 633\\| ) if steps else NullStep(): 634\\| assert message in r.output, error(r.output) 635\\| 636\\| if message is None or "Exception:" not in message: 637\\| with Then("check if output has exception") if steps else NullStep(): 638\\| if "Exception:" in r.output: 639\\| if raise_on_exception: 640\\| raise QueryRuntimeException(r.output) 641\\|> assert False, error(r.output) 642\\| 643\\| return r 644\\|
/window functions/tests/distributed/frame clause/range errors/error negative following offset	XFail 36ms https://github.com/ClickHouse/ClickHouse/issues/22442	AssertionError Traceback (most recent call last): File "regression/window_functions/regression.py", line 203, in regression() File "regression/window_functions/regression.py", line 199, in regression Feature(run=load("window_functions.tests.feature", "feature"), flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/feature.py", line 72, in feature Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/frame_clause.py", line 71, in feature Feature(run=load("window_functions.tests.range_errors", "feature"), flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/range_errors.py", line 114, in feature Scenario(run=scenario, flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/range_errors.py", line 105, in error_negative_following_offset r = current().context.node.query(sql, exitcode=exitcode, message=message) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../helpers/cluster.py", line 634, in query assert message in r.output, error(r.output) AssertionError: Oops! Assertion failed The following assertion was not satisfied assert message in r.output, error(r.output) Description Received exception from server (version 22.3.8): Code: 36. DB::Exception: Received from localhost:9000. DB::Exception: Window frame start offset must be nonnegative, -2 given. (BAD_ARGUMENTS) (query: select max(enroll_date) over (order by salary range between 1 preceding and -2 following) AS max, salary, enroll_date from empsalary ) Assertion values assert message in r.output, error(r.output) ^ is 'DB::Exception: Frame end offset must be greater than zero, -2 given' assert message in r.output, error(r.output) ^ is assert message in r.output, error(r.output) ^ is = 'Received exception from server (version 22.3.8):\nCode: 36. DB::Exception: Received from localhost:9000. DB::Exception: Window frame start offset must be nonnegative, -2 given. (BAD_ARGUMENTS)\n(query: select max(enroll_date) over (order by salary range between 1 preceding and -2 following) AS max, salary, enroll_date from empsalary\n)' assert message in r.output, error(r.output) ^ is = False assert message in r.output, error(r.output) ^ is False Where File '/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../helpers/cluster.py', line 634 in 'query' 626\\| if exitcode is not None: 627\\| with Then(f"exitcode should be {exitcode}") if steps else NullStep(): 628\\| assert r.exitcode == exitcode, error(r.output) 629\\| 630\\| if message is not None: 631\\| with Then( 632\\| f"output should contain message", description=message 633\\| ) if steps else NullStep(): 634\\|> assert message in r.output, error(r.output) 635\\| 636\\| if message is None or "Exception:" not in message: 637\\| with Then("check if output has exception") if steps else NullStep():
/window functions/tests/distributed/frame clause/range errors/error negative preceding offset	XFail 36ms https://github.com/ClickHouse/ClickHouse/issues/22442	AssertionError Traceback (most recent call last): File "regression/window_functions/regression.py", line 203, in regression() File "regression/window_functions/regression.py", line 199, in regression Feature(run=load("window_functions.tests.feature", "feature"), flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/feature.py", line 72, in feature Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/frame_clause.py", line 71, in feature Feature(run=load("window_functions.tests.range_errors", "feature"), flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/range_errors.py", line 114, in feature Scenario(run=scenario, flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/range_errors.py", line 89, in error_negative_preceding_offset r = current().context.node.query(sql, exitcode=exitcode, message=message) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../helpers/cluster.py", line 634, in query assert message in r.output, error(r.output) AssertionError: Oops! Assertion failed The following assertion was not satisfied assert message in r.output, error(r.output) Description Received exception from server (version 22.3.8): Code: 36. DB::Exception: Received from localhost:9000. DB::Exception: Window frame start offset must be nonnegative, -1 given. (BAD_ARGUMENTS) (query: select max(enroll_date) over (order by salary range between -1 preceding and 2 following) AS max, salary, enroll_date from empsalary ) Assertion values assert message in r.output, error(r.output) ^ is 'DB::Exception: Frame start offset must be greater than zero, -1 given' assert message in r.output, error(r.output) ^ is assert message in r.output, error(r.output) ^ is = 'Received exception from server (version 22.3.8):\nCode: 36. DB::Exception: Received from localhost:9000. DB::Exception: Window frame start offset must be nonnegative, -1 given. (BAD_ARGUMENTS)\n(query: select max(enroll_date) over (order by salary range between -1 preceding and 2 following) AS max, salary, enroll_date from empsalary\n)' assert message in r.output, error(r.output) ^ is = False assert message in r.output, error(r.output) ^ is False Where File '/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../helpers/cluster.py', line 634 in 'query' 626\\| if exitcode is not None: 627\\| with Then(f"exitcode should be {exitcode}") if steps else NullStep(): 628\\| assert r.exitcode == exitcode, error(r.output) 629\\| 630\\| if message is not None: 631\\| with Then( 632\\| f"output should contain message", description=message 633\\| ) if steps else NullStep(): 634\\|> assert message in r.output, error(r.output) 635\\| 636\\| if message is None or "Exception:" not in message: 637\\| with Then("check if output has exception") if steps else NullStep():
/window functions/tests/distributed/misc/window functions in select expression	XFail 36ms not supported, https://github.com/ClickHouse/ClickHouse/issues/19857	AssertionError Traceback (most recent call last): File "regression/window_functions/regression.py", line 203, in regression() File "regression/window_functions/regression.py", line 199, in regression Feature(run=load("window_functions.tests.feature", "feature"), flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/feature.py", line 79, in feature Feature(run=load("window_functions.tests.misc", "feature"), flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/misc.py", line 428, in feature Scenario(run=scenario, flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/misc.py", line 56, in window_functions_in_select_expression execute_query( File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/common.py", line 144, in execute_query r = current().context.node.query( File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../helpers/cluster.py", line 641, in query assert False, error(r.output) AssertionError: Oops! Assertion failed The following assertion was not satisfied assert False, error(r.output) Description Received exception from server (version 22.3.8): Code: 47. DB::Exception: Received from localhost:9000. DB::Exception: Unknown identifier: count() OVER (PARTITION BY four ORDER BY ten ASC); there are columns: unique2, four, ten, hundred, 10, 10, less(unique2, 10): While processing count() OVER (PARTITION BY four ORDER BY ten ASC) + sum(hundred) OVER (PARTITION BY four ORDER BY ten ASC) AS cntsum. (UNKNOWN_IDENTIFIER) (query: SELECT (count(*) OVER (PARTITION BY four ORDER BY ten) + sum(hundred) OVER (PARTITION BY four ORDER BY ten)) AS cntsum FROM tenk1 WHERE unique2 < 10 FORMAT TabSeparatedWithNames ) Assertion values assert False, error(r.output) ^ is False Where File '/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../helpers/cluster.py', line 641 in 'query' 633\\| ) if steps else NullStep(): 634\\| assert message in r.output, error(r.output) 635\\| 636\\| if message is None or "Exception:" not in message: 637\\| with Then("check if output has exception") if steps else NullStep(): 638\\| if "Exception:" in r.output: 639\\| if raise_on_exception: 640\\| raise QueryRuntimeException(r.output) 641\\|> assert False, error(r.output) 642\\| 643\\| return r 644\\|
/window functions/tests/distributed/misc/window functions in subquery	XFail 52ms not supported, https://github.com/ClickHouse/ClickHouse/issues/19857	AssertionError Traceback (most recent call last): File "regression/window_functions/regression.py", line 203, in regression() File "regression/window_functions/regression.py", line 199, in regression Feature(run=load("window_functions.tests.feature", "feature"), flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/feature.py", line 79, in feature Feature(run=load("window_functions.tests.misc", "feature"), flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/misc.py", line 428, in feature Scenario(run=scenario, flags=TE) File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/misc.py", line 74, in window_functions_in_subquery execute_query( File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/common.py", line 144, in execute_query r = current().context.node.query( File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../helpers/cluster.py", line 641, in query assert False, error(r.output) AssertionError: Oops! Assertion failed The following assertion was not satisfied assert False, error(r.output) Description Received exception from server (version 22.3.8): Code: 47. DB::Exception: Received from localhost:9000. DB::Exception: Unknown identifier: count() OVER (PARTITION BY four ORDER BY ten ASC); there are columns: two, four, ten, hundred: While processing count() OVER (PARTITION BY four ORDER BY ten ASC) + sum(hundred) OVER (PARTITION BY two ORDER BY ten ASC) AS total, count() OVER (PARTITION BY four ORDER BY ten ASC) AS fourcount, sum(hundred) OVER (PARTITION BY two ORDER BY ten ASC) AS twosum. (UNKNOWN_IDENTIFIER) (query: SELECT * FROM ( SELECT count() OVER (PARTITION BY four ORDER BY ten) + sum(hundred) OVER (PARTITION BY two ORDER BY ten) AS total, count() OVER (PARTITION BY four ORDER BY ten) AS fourcount, sum(hundred) OVER (PARTITION BY two ORDER BY ten) AS twosum FROM tenk1 ) WHERE total <> fourcount + twosum FORMAT TabSeparatedWithNames ) Assertion values assert False, error(r.output) ^ is False Where File '/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../helpers/cluster.py', line 641 in 'query' 633\\| ) if steps else NullStep(): 634\\| assert message in r.output, error(r.output) 635\\| 636\\| if message is None or "Exception:" not in message: 637\\| with Then("check if output has exception") if steps else NullStep(): 638\\| if "Exception:" in r.output: 639\\| if raise_on_exception: 640\\| raise QueryRuntimeException(r.output) 641\\|> assert False, error(r.output) 642\\| 643\\| return r 644\\|

Results

Test Name	Result	Duration
/window functions	Fail	2m 48s
/window functions/tests	Fail	2m 18s
/window functions/tests/non distributed	Fail	1m 6s
/window functions/tests/non distributed/window spec	OK	286ms
/window functions/tests/non distributed/window spec/empty	OK	34ms
/window functions/tests/non distributed/window spec/frame clause	OK	30ms
/window functions/tests/non distributed/window spec/order by with frame	OK	33ms
/window functions/tests/non distributed/window spec/orderby clause	OK	31ms
/window functions/tests/non distributed/window spec/partition clause	OK	42ms
/window functions/tests/non distributed/window spec/partition with frame	OK	36ms
/window functions/tests/non distributed/window spec/partition with order by	OK	38ms
/window functions/tests/non distributed/window spec/partition with order by and frame	OK	37ms
/window functions/tests/non distributed/partition clause	OK	133ms
/window functions/tests/non distributed/partition clause/invalid expr error	OK	28ms
/window functions/tests/non distributed/partition clause/missing expr error	OK	33ms
/window functions/tests/non distributed/partition clause/multiple expr	OK	33ms
/window functions/tests/non distributed/partition clause/single expr	OK	36ms
/window functions/tests/non distributed/order clause	Fail	386ms
/window functions/tests/non distributed/order clause/by a non integer constant	OK	31ms
/window functions/tests/non distributed/order clause/by column	OK	31ms
/window functions/tests/non distributed/order clause/by expr	OK	37ms
/window functions/tests/non distributed/order clause/by expr with aggregates	Fail	54ms
/window functions/tests/non distributed/order clause/invalid expr error	OK	31ms
/window functions/tests/non distributed/order clause/missing expr error	OK	32ms
/window functions/tests/non distributed/order clause/multiple expr asc asc	OK	31ms
/window functions/tests/non distributed/order clause/multiple expr asc desc	OK	37ms
/window functions/tests/non distributed/order clause/multiple expr desc desc	OK	33ms
/window functions/tests/non distributed/order clause/single expr asc	OK	33ms
/window functions/tests/non distributed/order clause/single expr desc	OK	28ms
/window functions/tests/non distributed/frame clause	OK	4s 933ms
/window functions/tests/non distributed/frame clause/default frame	OK	70ms
/window functions/tests/non distributed/frame clause/default frame/with order by	OK	34ms
/window functions/tests/non distributed/frame clause/default frame/without order by	OK	35ms
/window functions/tests/non distributed/frame clause/rows frame	OK	1s 244ms
/window functions/tests/non distributed/frame clause/rows frame/between current row and current row	OK	34ms
/window functions/tests/non distributed/frame clause/rows frame/between current row and expr following	OK	31ms
/window functions/tests/non distributed/frame clause/rows frame/between current row and expr preceding error	OK	29ms
/window functions/tests/non distributed/frame clause/rows frame/between current row and unbounded following	OK	28ms
/window functions/tests/non distributed/frame clause/rows frame/between current row and unbounded preceding error	OK	33ms
/window functions/tests/non distributed/frame clause/rows frame/between expr following and expr following	OK	37ms
/window functions/tests/non distributed/frame clause/rows frame/between expr following and expr following error	OK	32ms
/window functions/tests/non distributed/frame clause/rows frame/between expr following and expr following ref	OK	34ms
/window functions/tests/non distributed/frame clause/rows frame/between expr following and unbounded following	OK	32ms
/window functions/tests/non distributed/frame clause/rows frame/between expr following error	OK	101ms
/window functions/tests/non distributed/frame clause/rows frame/between expr preceding and current row	OK	33ms
/window functions/tests/non distributed/frame clause/rows frame/between expr preceding and expr following	OK	34ms
/window functions/tests/non distributed/frame clause/rows frame/between expr preceding and expr following ref	OK	28ms
/window functions/tests/non distributed/frame clause/rows frame/between expr preceding and expr preceding	OK	35ms
/window functions/tests/non distributed/frame clause/rows frame/between expr preceding and expr preceding error	OK	33ms
/window functions/tests/non distributed/frame clause/rows frame/between expr preceding and expr preceding ref	OK	32ms
/window functions/tests/non distributed/frame clause/rows frame/between expr preceding and unbounded following	OK	33ms
/window functions/tests/non distributed/frame clause/rows frame/between expr preceding and unbounded preceding error	OK	36ms
/window functions/tests/non distributed/frame clause/rows frame/between unbounded following error	OK	161ms
/window functions/tests/non distributed/frame clause/rows frame/between unbounded preceding and current row	OK	32ms
/window functions/tests/non distributed/frame clause/rows frame/between unbounded preceding and expr following	OK	36ms
/window functions/tests/non distributed/frame clause/rows frame/between unbounded preceding and expr preceding	OK	34ms
/window functions/tests/non distributed/frame clause/rows frame/between unbounded preceding and unbounded following	OK	33ms
/window functions/tests/non distributed/frame clause/rows frame/between unbounded preceding and unbounded preceding error	OK	29ms
/window functions/tests/non distributed/frame clause/rows frame/invalid frame extent	OK	46ms
/window functions/tests/non distributed/frame clause/rows frame/missing frame extent	OK	32ms
/window functions/tests/non distributed/frame clause/rows frame/start current row	OK	33ms
/window functions/tests/non distributed/frame clause/rows frame/start expr following error	OK	31ms
/window functions/tests/non distributed/frame clause/rows frame/start expr preceding	OK	33ms
/window functions/tests/non distributed/frame clause/rows frame/start unbounded following error	OK	32ms
/window functions/tests/non distributed/frame clause/rows frame/start unbounded preceding	OK	36ms
/window functions/tests/non distributed/frame clause/range frame	OK	2s 825ms
/window functions/tests/non distributed/frame clause/range frame/between current row and current row	OK	78ms
/window functions/tests/non distributed/frame clause/range frame/between current row and expr following with order by	OK	32ms
/window functions/tests/non distributed/frame clause/range frame/between current row and expr following without order by error	OK	31ms
/window functions/tests/non distributed/frame clause/range frame/between current row and expr preceding error	OK	68ms
/window functions/tests/non distributed/frame clause/range frame/between current row and unbounded following	OK	104ms
/window functions/tests/non distributed/frame clause/range frame/between current row and unbounded following in named window	OK	32ms
/window functions/tests/non distributed/frame clause/range frame/between current row and unbounded following modifying named window	XFail	38ms
/window functions/tests/non distributed/frame clause/range frame/between current row and unbounded preceding error	OK	61ms
/window functions/tests/non distributed/frame clause/range frame/between expr following and current row with order by error	OK	33ms
/window functions/tests/non distributed/frame clause/range frame/between expr following and current row without order by error	OK	37ms
/window functions/tests/non distributed/frame clause/range frame/between expr following and current row zero special case	XFail	41ms
/window functions/tests/non distributed/frame clause/range frame/between expr following and expr following with order by	OK	34ms
/window functions/tests/non distributed/frame clause/range frame/between expr following and expr following with order by error	OK	32ms
/window functions/tests/non distributed/frame clause/range frame/between expr following and expr following without order by error	XFail	37ms
/window functions/tests/non distributed/frame clause/range frame/between expr following and expr preceding error	OK	65ms
/window functions/tests/non distributed/frame clause/range frame/between expr following and expr preceding with order by zero special case	XFail	36ms
/window functions/tests/non distributed/frame clause/range frame/between expr following and expr preceding without order by error	XFail	37ms
/window functions/tests/non distributed/frame clause/range frame/between expr following and unbounded following with order by	OK	32ms
/window functions/tests/non distributed/frame clause/range frame/between expr following and unbounded following without order by error	OK	30ms
/window functions/tests/non distributed/frame clause/range frame/between expr following and unbounded preceding error	OK	90ms
/window functions/tests/non distributed/frame clause/range frame/between expr preceding and current row with order by	OK	34ms
/window functions/tests/non distributed/frame clause/range frame/between expr preceding and current row without order by error	OK	35ms
/window functions/tests/non distributed/frame clause/range frame/between expr preceding and expr following with order by	OK	66ms
/window functions/tests/non distributed/frame clause/range frame/between expr preceding and expr following with partition and order by	OK	38ms
/window functions/tests/non distributed/frame clause/range frame/between expr preceding and expr following with partition by same column twice	OK	32ms
/window functions/tests/non distributed/frame clause/range frame/between expr preceding and expr following with partition by two columns	OK	34ms
/window functions/tests/non distributed/frame clause/range frame/between expr preceding and expr following without order by error	OK	32ms
/window functions/tests/non distributed/frame clause/range frame/between expr preceding and expr preceding with order by	OK	74ms
/window functions/tests/non distributed/frame clause/range frame/between expr preceding and expr preceding with order by error	OK	33ms
/window functions/tests/non distributed/frame clause/range frame/between expr preceding and expr preceding without order by error	OK	33ms
/window functions/tests/non distributed/frame clause/range frame/between expr preceding and unbounded following with order by	OK	37ms
/window functions/tests/non distributed/frame clause/range frame/between expr preceding and unbounded following without order by error	OK	31ms
/window functions/tests/non distributed/frame clause/range frame/between expr preceding and unbounded preceding error	OK	65ms
/window functions/tests/non distributed/frame clause/range frame/between unbounded following and current row error	OK	65ms
/window functions/tests/non distributed/frame clause/range frame/between unbounded following and expr following error	OK	64ms
/window functions/tests/non distributed/frame clause/range frame/between unbounded following and expr preceding error	OK	66ms
/window functions/tests/non distributed/frame clause/range frame/between unbounded following and unbounded following error	OK	69ms
/window functions/tests/non distributed/frame clause/range frame/between unbounded following and unbounded preceding error	OK	63ms
/window functions/tests/non distributed/frame clause/range frame/between unbounded preceding and current row	OK	71ms
/window functions/tests/non distributed/frame clause/range frame/between unbounded preceding and current row with expressions in order by and aggregate	OK	36ms
/window functions/tests/non distributed/frame clause/range frame/between unbounded preceding and expr following with order by	OK	39ms
/window functions/tests/non distributed/frame clause/range frame/between unbounded preceding and expr following without order by error	OK	34ms
/window functions/tests/non distributed/frame clause/range frame/between unbounded preceding and expr preceding with order by	OK	32ms
/window functions/tests/non distributed/frame clause/range frame/between unbounded preceding and expr preceding without order by error	OK	35ms
/window functions/tests/non distributed/frame clause/range frame/between unbounded preceding and unbounded following	OK	77ms
/window functions/tests/non distributed/frame clause/range frame/between unbounded preceding and unbounded preceding error	OK	68ms
/window functions/tests/non distributed/frame clause/range frame/invalid frame extent	OK	34ms
/window functions/tests/non distributed/frame clause/range frame/missing frame extent	OK	32ms
/window functions/tests/non distributed/frame clause/range frame/order by decimal	XFail	42ms
/window functions/tests/non distributed/frame clause/range frame/order by float	OK	38ms
/window functions/tests/non distributed/frame clause/range frame/start current row with order by	OK	35ms
/window functions/tests/non distributed/frame clause/range frame/start current row without order by	OK	35ms
/window functions/tests/non distributed/frame clause/range frame/start expr following with order by error	OK	35ms
/window functions/tests/non distributed/frame clause/range frame/start expr following without order by error	OK	33ms
/window functions/tests/non distributed/frame clause/range frame/start expr preceding order by non numerical column error	OK	37ms
/window functions/tests/non distributed/frame clause/range frame/start expr preceding with order by	OK	32ms
/window functions/tests/non distributed/frame clause/range frame/start expr preceding without order by error	OK	33ms
/window functions/tests/non distributed/frame clause/range frame/start unbounded following error	OK	67ms
/window functions/tests/non distributed/frame clause/range frame/start unbounded preceding with order by	OK	37ms
/window functions/tests/non distributed/frame clause/range frame/start unbounded preceding without order by	OK	39ms
/window functions/tests/non distributed/frame clause/range frame/with nulls	XFail	42ms
/window functions/tests/non distributed/frame clause/range overflow	OK	250ms
/window functions/tests/non distributed/frame clause/range overflow/negative overflow for Int32	OK	45ms
/window functions/tests/non distributed/frame clause/range overflow/negative overflow for Int64	OK	43ms
/window functions/tests/non distributed/frame clause/range overflow/negative overflow with Int16	XFail	39ms
/window functions/tests/non distributed/frame clause/range overflow/positive overflow for Int32	OK	36ms
/window functions/tests/non distributed/frame clause/range overflow/positive overflow for Int64	OK	34ms
/window functions/tests/non distributed/frame clause/range overflow/positive overflow with Int16	XFail	49ms
/window functions/tests/non distributed/frame clause/range datetime	OK	317ms
/window functions/tests/non distributed/frame clause/range datetime/datetime order by asc range between n preceding and n following	OK	34ms
/window functions/tests/non distributed/frame clause/range datetime/datetime order by desc range between n preceding and n following	OK	37ms
/window functions/tests/non distributed/frame clause/range datetime/datetime with timezone order by asc range between n preceding and n following	OK	53ms
/window functions/tests/non distributed/frame clause/range datetime/datetime with timezone order by desc range between n preceding and n following	OK	44ms
/window functions/tests/non distributed/frame clause/range datetime/order by asc range between days preceding and days following	OK	33ms
/window functions/tests/non distributed/frame clause/range datetime/order by desc range between days following and days following	OK	33ms
/window functions/tests/non distributed/frame clause/range datetime/order by desc range between days preceding and days following	OK	45ms
/window functions/tests/non distributed/frame clause/range datetime/order by desc range between days preceding and days preceding	OK	33ms
/window functions/tests/non distributed/frame clause/range errors	OK	211ms
/window functions/tests/non distributed/frame clause/range errors/error missing order by	OK	36ms
/window functions/tests/non distributed/frame clause/range errors/error missing order by with partition by clause	OK	33ms
/window functions/tests/non distributed/frame clause/range errors/error more than one order by column	OK	34ms
/window functions/tests/non distributed/frame clause/range errors/error negative following offset	XFail	36ms
/window functions/tests/non distributed/frame clause/range errors/error negative preceding offset	XFail	39ms
/window functions/tests/non distributed/frame clause/range errors/error range over non numerical column	OK	29ms
/window functions/tests/non distributed/window clause	OK	181ms
/window functions/tests/non distributed/window clause/missing window spec	OK	31ms
/window functions/tests/non distributed/window clause/multiple identical windows	OK	38ms
/window functions/tests/non distributed/window clause/multiple windows	OK	37ms
/window functions/tests/non distributed/window clause/single window	OK	34ms
/window functions/tests/non distributed/window clause/unused window	OK	37ms
/window functions/tests/non distributed/over clause	OK	222ms
/window functions/tests/non distributed/over clause/adhoc window	OK	42ms
/window functions/tests/non distributed/over clause/empty	OK	37ms
/window functions/tests/non distributed/over clause/empty named window	OK	34ms
/window functions/tests/non distributed/over clause/invalid multiple windows	OK	36ms
/window functions/tests/non distributed/over clause/invalid window name	OK	35ms
/window functions/tests/non distributed/over clause/missing window spec	OK	33ms
/window functions/tests/non distributed/funcs	OK	1s 22ms
/window functions/tests/non distributed/funcs/dense rank	OK	36ms
/window functions/tests/non distributed/funcs/first value	OK	75ms
/window functions/tests/non distributed/funcs/first value with lead workaround	OK	34ms
/window functions/tests/non distributed/funcs/lag	OK	100ms
/window functions/tests/non distributed/funcs/lagInFrame	OK	178ms
/window functions/tests/non distributed/funcs/last value	OK	142ms
/window functions/tests/non distributed/funcs/last value with lag workaround	OK	33ms
/window functions/tests/non distributed/funcs/last value with no frame	OK	33ms
/window functions/tests/non distributed/funcs/lead	OK	142ms
/window functions/tests/non distributed/funcs/leadInFrame	OK	174ms
/window functions/tests/non distributed/funcs/rank	OK	32ms
/window functions/tests/non distributed/funcs/row number	OK	35ms
/window functions/tests/non distributed/aggregate funcs	OK	2s 819ms
/window functions/tests/non distributed/aggregate funcs/aggregate and window function in the same window	OK	33ms
/window functions/tests/non distributed/aggregate funcs/aggregate funcs over rows frame	OK	2s 312ms
/window functions/tests/non distributed/aggregate funcs/aggregate function recovers from nan	OK	34ms
/window functions/tests/non distributed/aggregate funcs/avgWeighted	OK	105ms
/window functions/tests/non distributed/aggregate funcs/avg with nulls	OK	33ms
/window functions/tests/non distributed/aggregate funcs/bit functions	OK	36ms
/window functions/tests/non distributed/aggregate funcs/nested aggregates	OK	31ms
/window functions/tests/non distributed/aggregate funcs/stddevpop	OK	39ms
/window functions/tests/non distributed/aggregate funcs/stddevsamp	OK	39ms
/window functions/tests/non distributed/aggregate funcs/sum	OK	36ms
/window functions/tests/non distributed/aggregate funcs/ungrouped aggregate over empty row set	OK	36ms
/window functions/tests/non distributed/aggregate funcs/var pop	OK	33ms
/window functions/tests/non distributed/aggregate funcs/var samp	OK	43ms
/window functions/tests/non distributed/time decayed funcs	Fail	53s 605ms
/window functions/tests/non distributed/time decayed funcs/exponentialTimeDecayedAvg	Fail	6s 242ms
/window functions/tests/non distributed/time decayed funcs/exponentialTimeDecayedCount	Fail	5s 594ms
/window functions/tests/non distributed/time decayed funcs/exponentialTimeDecayedMax	Fail	35s 614ms
/window functions/tests/non distributed/time decayed funcs/exponentialTimeDecayedSum	Fail	6s 152ms
/window functions/tests/non distributed/errors	OK	334ms
/window functions/tests/non distributed/errors/error coma between partition by and order by clause	OK	33ms
/window functions/tests/non distributed/errors/error named window defined twice	OK	30ms
/window functions/tests/non distributed/errors/error order by another window function	OK	39ms
/window functions/tests/non distributed/errors/error select from window	OK	31ms
/window functions/tests/non distributed/errors/error using non window function	OK	33ms
/window functions/tests/non distributed/errors/error window function in alter delete where	OK	33ms
/window functions/tests/non distributed/errors/error window function in group by	OK	35ms
/window functions/tests/non distributed/errors/error window function in having	OK	33ms
/window functions/tests/non distributed/errors/error window function in join	OK	28ms
/window functions/tests/non distributed/errors/error window function in where	OK	33ms
/window functions/tests/non distributed/misc	OK	692ms
/window functions/tests/non distributed/misc/count with empty over clause without start	OK	32ms
/window functions/tests/non distributed/misc/empty table	OK	46ms
/window functions/tests/non distributed/misc/exclude clause	OK	33ms
/window functions/tests/non distributed/misc/from subquery	OK	37ms
/window functions/tests/non distributed/misc/group by and multiple windows	OK	35ms
/window functions/tests/non distributed/misc/group by and one window	OK	38ms
/window functions/tests/non distributed/misc/groups frame	OK	34ms
/window functions/tests/non distributed/misc/in view	OK	128ms
/window functions/tests/non distributed/misc/query with order by and one window	OK	38ms
/window functions/tests/non distributed/misc/subquery expr preceding	OK	37ms
/window functions/tests/non distributed/misc/subquery multiple window functions	OK	36ms
/window functions/tests/non distributed/misc/subquery with multiple windows filtering	OK	38ms
/window functions/tests/non distributed/misc/window functions in select expression	XFail	36ms
/window functions/tests/non distributed/misc/window functions in subquery	XFail	39ms
/window functions/tests/non distributed/misc/windows with same partitioning but different ordering	OK	35ms
/window functions/tests/non distributed/misc/with union all	OK	40ms
/window functions/tests/non distributed/datatypes	OK	421ms
/window functions/tests/non distributed/datatypes/date	OK	37ms
/window functions/tests/non distributed/datatypes/datetime	OK	32ms
/window functions/tests/non distributed/datatypes/datetime64	OK	31ms
/window functions/tests/non distributed/datatypes/decimal32	OK	34ms
/window functions/tests/non distributed/datatypes/enum	OK	40ms
/window functions/tests/non distributed/datatypes/fixed string	OK	33ms
/window functions/tests/non distributed/datatypes/ipv4	OK	33ms
/window functions/tests/non distributed/datatypes/ipv6	OK	34ms
/window functions/tests/non distributed/datatypes/low cardinality	OK	36ms
/window functions/tests/non distributed/datatypes/map	OK	33ms
/window functions/tests/non distributed/datatypes/string	OK	37ms
/window functions/tests/non distributed/datatypes/uuid	OK	33ms
/window functions/tests/non distributed/non-negative derivative func	Skip	2ms
/window functions/tests/distributed	Fail	1m 12s
/window functions/tests/distributed/window spec	OK	304ms
/window functions/tests/distributed/window spec/empty	OK	37ms
/window functions/tests/distributed/window spec/frame clause	OK	38ms
/window functions/tests/distributed/window spec/order by with frame	OK	39ms
/window functions/tests/distributed/window spec/orderby clause	OK	36ms
/window functions/tests/distributed/window spec/partition clause	OK	39ms
/window functions/tests/distributed/window spec/partition with frame	OK	36ms
/window functions/tests/distributed/window spec/partition with order by	OK	35ms
/window functions/tests/distributed/window spec/partition with order by and frame	OK	38ms
/window functions/tests/distributed/partition clause	OK	145ms
/window functions/tests/distributed/partition clause/invalid expr error	OK	34ms
/window functions/tests/distributed/partition clause/missing expr error	OK	38ms
/window functions/tests/distributed/partition clause/multiple expr	OK	35ms
/window functions/tests/distributed/partition clause/single expr	OK	35ms
/window functions/tests/distributed/order clause	Fail	424ms
/window functions/tests/distributed/order clause/by a non integer constant	OK	34ms
/window functions/tests/distributed/order clause/by column	OK	47ms
/window functions/tests/distributed/order clause/by expr	OK	37ms
/window functions/tests/distributed/order clause/by expr with aggregates	Fail	38ms
/window functions/tests/distributed/order clause/invalid expr error	OK	35ms
/window functions/tests/distributed/order clause/missing expr error	OK	31ms
/window functions/tests/distributed/order clause/multiple expr asc asc	OK	31ms
/window functions/tests/distributed/order clause/multiple expr asc desc	OK	34ms
/window functions/tests/distributed/order clause/multiple expr desc desc	OK	33ms
/window functions/tests/distributed/order clause/single expr asc	OK	35ms
/window functions/tests/distributed/order clause/single expr desc	OK	60ms
/window functions/tests/distributed/frame clause	OK	5s 28ms
/window functions/tests/distributed/frame clause/default frame	OK	71ms
/window functions/tests/distributed/frame clause/default frame/with order by	OK	36ms
/window functions/tests/distributed/frame clause/default frame/without order by	OK	33ms
/window functions/tests/distributed/frame clause/rows frame	OK	1s 309ms
/window functions/tests/distributed/frame clause/rows frame/between current row and current row	OK	40ms
/window functions/tests/distributed/frame clause/rows frame/between current row and expr following	OK	36ms
/window functions/tests/distributed/frame clause/rows frame/between current row and expr preceding error	OK	35ms
/window functions/tests/distributed/frame clause/rows frame/between current row and unbounded following	OK	38ms
/window functions/tests/distributed/frame clause/rows frame/between current row and unbounded preceding error	OK	35ms
/window functions/tests/distributed/frame clause/rows frame/between expr following and expr following	OK	36ms
/window functions/tests/distributed/frame clause/rows frame/between expr following and expr following error	OK	35ms
/window functions/tests/distributed/frame clause/rows frame/between expr following and expr following ref	OK	42ms
/window functions/tests/distributed/frame clause/rows frame/between expr following and unbounded following	OK	36ms
/window functions/tests/distributed/frame clause/rows frame/between expr following error	OK	98ms
/window functions/tests/distributed/frame clause/rows frame/between expr preceding and current row	OK	36ms
/window functions/tests/distributed/frame clause/rows frame/between expr preceding and expr following	OK	38ms
/window functions/tests/distributed/frame clause/rows frame/between expr preceding and expr following ref	OK	35ms
/window functions/tests/distributed/frame clause/rows frame/between expr preceding and expr preceding	OK	33ms
/window functions/tests/distributed/frame clause/rows frame/between expr preceding and expr preceding error	OK	36ms
/window functions/tests/distributed/frame clause/rows frame/between expr preceding and expr preceding ref	OK	38ms
/window functions/tests/distributed/frame clause/rows frame/between expr preceding and unbounded following	OK	35ms
/window functions/tests/distributed/frame clause/rows frame/between expr preceding and unbounded preceding error	OK	30ms
/window functions/tests/distributed/frame clause/rows frame/between unbounded following error	OK	162ms
/window functions/tests/distributed/frame clause/rows frame/between unbounded preceding and current row	OK	34ms
/window functions/tests/distributed/frame clause/rows frame/between unbounded preceding and expr following	OK	37ms
/window functions/tests/distributed/frame clause/rows frame/between unbounded preceding and expr preceding	OK	35ms
/window functions/tests/distributed/frame clause/rows frame/between unbounded preceding and unbounded following	OK	36ms
/window functions/tests/distributed/frame clause/rows frame/between unbounded preceding and unbounded preceding error	OK	29ms
/window functions/tests/distributed/frame clause/rows frame/invalid frame extent	OK	32ms
/window functions/tests/distributed/frame clause/rows frame/missing frame extent	OK	31ms
/window functions/tests/distributed/frame clause/rows frame/start current row	OK	43ms
/window functions/tests/distributed/frame clause/rows frame/start expr following error	OK	34ms
/window functions/tests/distributed/frame clause/rows frame/start expr preceding	OK	36ms
/window functions/tests/distributed/frame clause/rows frame/start unbounded following error	OK	32ms
/window functions/tests/distributed/frame clause/rows frame/start unbounded preceding	OK	39ms
/window functions/tests/distributed/frame clause/range frame	OK	2s 875ms
/window functions/tests/distributed/frame clause/range frame/between current row and current row	OK	76ms
/window functions/tests/distributed/frame clause/range frame/between current row and expr following with order by	OK	35ms
/window functions/tests/distributed/frame clause/range frame/between current row and expr following without order by error	OK	34ms
/window functions/tests/distributed/frame clause/range frame/between current row and expr preceding error	OK	63ms
/window functions/tests/distributed/frame clause/range frame/between current row and unbounded following	OK	120ms
/window functions/tests/distributed/frame clause/range frame/between current row and unbounded following in named window	OK	36ms
/window functions/tests/distributed/frame clause/range frame/between current row and unbounded following modifying named window	XFail	41ms
/window functions/tests/distributed/frame clause/range frame/between current row and unbounded preceding error	OK	68ms
/window functions/tests/distributed/frame clause/range frame/between expr following and current row with order by error	OK	42ms
/window functions/tests/distributed/frame clause/range frame/between expr following and current row without order by error	OK	34ms
/window functions/tests/distributed/frame clause/range frame/between expr following and current row zero special case	XFail	33ms
/window functions/tests/distributed/frame clause/range frame/between expr following and expr following with order by	OK	36ms
/window functions/tests/distributed/frame clause/range frame/between expr following and expr following with order by error	OK	32ms
/window functions/tests/distributed/frame clause/range frame/between expr following and expr following without order by error	XFail	33ms
/window functions/tests/distributed/frame clause/range frame/between expr following and expr preceding error	OK	65ms
/window functions/tests/distributed/frame clause/range frame/between expr following and expr preceding with order by zero special case	XFail	36ms
/window functions/tests/distributed/frame clause/range frame/between expr following and expr preceding without order by error	XFail	35ms
/window functions/tests/distributed/frame clause/range frame/between expr following and unbounded following with order by	OK	29ms
/window functions/tests/distributed/frame clause/range frame/between expr following and unbounded following without order by error	OK	28ms
/window functions/tests/distributed/frame clause/range frame/between expr following and unbounded preceding error	OK	58ms
/window functions/tests/distributed/frame clause/range frame/between expr preceding and current row with order by	OK	36ms
/window functions/tests/distributed/frame clause/range frame/between expr preceding and current row without order by error	OK	31ms
/window functions/tests/distributed/frame clause/range frame/between expr preceding and expr following with order by	OK	78ms
/window functions/tests/distributed/frame clause/range frame/between expr preceding and expr following with partition and order by	OK	39ms
/window functions/tests/distributed/frame clause/range frame/between expr preceding and expr following with partition by same column twice	OK	42ms
/window functions/tests/distributed/frame clause/range frame/between expr preceding and expr following with partition by two columns	OK	38ms
/window functions/tests/distributed/frame clause/range frame/between expr preceding and expr following without order by error	OK	34ms
/window functions/tests/distributed/frame clause/range frame/between expr preceding and expr preceding with order by	OK	80ms
/window functions/tests/distributed/frame clause/range frame/between expr preceding and expr preceding with order by error	OK	37ms
/window functions/tests/distributed/frame clause/range frame/between expr preceding and expr preceding without order by error	OK	32ms
/window functions/tests/distributed/frame clause/range frame/between expr preceding and unbounded following with order by	OK	39ms
/window functions/tests/distributed/frame clause/range frame/between expr preceding and unbounded following without order by error	OK	32ms
/window functions/tests/distributed/frame clause/range frame/between expr preceding and unbounded preceding error	OK	68ms
/window functions/tests/distributed/frame clause/range frame/between unbounded following and current row error	OK	62ms
/window functions/tests/distributed/frame clause/range frame/between unbounded following and expr following error	OK	73ms
/window functions/tests/distributed/frame clause/range frame/between unbounded following and expr preceding error	OK	58ms
/window functions/tests/distributed/frame clause/range frame/between unbounded following and unbounded following error	OK	64ms
/window functions/tests/distributed/frame clause/range frame/between unbounded following and unbounded preceding error	OK	63ms
/window functions/tests/distributed/frame clause/range frame/between unbounded preceding and current row	OK	83ms
/window functions/tests/distributed/frame clause/range frame/between unbounded preceding and current row with expressions in order by and aggregate	OK	37ms
/window functions/tests/distributed/frame clause/range frame/between unbounded preceding and expr following with order by	OK	34ms
/window functions/tests/distributed/frame clause/range frame/between unbounded preceding and expr following without order by error	OK	68ms
/window functions/tests/distributed/frame clause/range frame/between unbounded preceding and expr preceding with order by	OK	36ms
/window functions/tests/distributed/frame clause/range frame/between unbounded preceding and expr preceding without order by error	OK	34ms
/window functions/tests/distributed/frame clause/range frame/between unbounded preceding and unbounded following	OK	73ms
/window functions/tests/distributed/frame clause/range frame/between unbounded preceding and unbounded preceding error	OK	63ms
/window functions/tests/distributed/frame clause/range frame/invalid frame extent	OK	32ms
/window functions/tests/distributed/frame clause/range frame/missing frame extent	OK	30ms
/window functions/tests/distributed/frame clause/range frame/order by decimal	XFail	36ms
/window functions/tests/distributed/frame clause/range frame/order by float	OK	39ms
/window functions/tests/distributed/frame clause/range frame/start current row with order by	OK	38ms
/window functions/tests/distributed/frame clause/range frame/start current row without order by	OK	40ms
/window functions/tests/distributed/frame clause/range frame/start expr following with order by error	OK	32ms
/window functions/tests/distributed/frame clause/range frame/start expr following without order by error	OK	32ms
/window functions/tests/distributed/frame clause/range frame/start expr preceding order by non numerical column error	OK	33ms
/window functions/tests/distributed/frame clause/range frame/start expr preceding with order by	OK	42ms
/window functions/tests/distributed/frame clause/range frame/start expr preceding without order by error	OK	30ms
/window functions/tests/distributed/frame clause/range frame/start unbounded following error	OK	65ms
/window functions/tests/distributed/frame clause/range frame/start unbounded preceding with order by	OK	36ms
/window functions/tests/distributed/frame clause/range frame/start unbounded preceding without order by	OK	38ms
/window functions/tests/distributed/frame clause/range frame/with nulls	XFail	41ms
/window functions/tests/distributed/frame clause/range overflow	OK	227ms
/window functions/tests/distributed/frame clause/range overflow/negative overflow for Int32	OK	35ms
/window functions/tests/distributed/frame clause/range overflow/negative overflow for Int64	OK	36ms
/window functions/tests/distributed/frame clause/range overflow/negative overflow with Int16	XFail	36ms
/window functions/tests/distributed/frame clause/range overflow/positive overflow for Int32	OK	37ms
/window functions/tests/distributed/frame clause/range overflow/positive overflow for Int64	OK	36ms
/window functions/tests/distributed/frame clause/range overflow/positive overflow with Int16	XFail	42ms
/window functions/tests/distributed/frame clause/range datetime	OK	321ms
/window functions/tests/distributed/frame clause/range datetime/datetime order by asc range between n preceding and n following	OK	40ms
/window functions/tests/distributed/frame clause/range datetime/datetime order by desc range between n preceding and n following	OK	40ms
/window functions/tests/distributed/frame clause/range datetime/datetime with timezone order by asc range between n preceding and n following	OK	45ms
/window functions/tests/distributed/frame clause/range datetime/datetime with timezone order by desc range between n preceding and n following	OK	42ms
/window functions/tests/distributed/frame clause/range datetime/order by asc range between days preceding and days following	XFail	37ms
/window functions/tests/distributed/frame clause/range datetime/order by desc range between days following and days following	XFail	37ms
/window functions/tests/distributed/frame clause/range datetime/order by desc range between days preceding and days following	XFail	38ms
/window functions/tests/distributed/frame clause/range datetime/order by desc range between days preceding and days preceding	XFail	38ms
/window functions/tests/distributed/frame clause/range errors	OK	221ms
/window functions/tests/distributed/frame clause/range errors/error missing order by	OK	37ms
/window functions/tests/distributed/frame clause/range errors/error missing order by with partition by clause	OK	37ms
/window functions/tests/distributed/frame clause/range errors/error more than one order by column	OK	35ms
/window functions/tests/distributed/frame clause/range errors/error negative following offset	XFail	36ms
/window functions/tests/distributed/frame clause/range errors/error negative preceding offset	XFail	36ms
/window functions/tests/distributed/frame clause/range errors/error range over non numerical column	OK	35ms
/window functions/tests/distributed/window clause	OK	189ms
/window functions/tests/distributed/window clause/missing window spec	OK	34ms
/window functions/tests/distributed/window clause/multiple identical windows	OK	40ms
/window functions/tests/distributed/window clause/multiple windows	OK	37ms
/window functions/tests/distributed/window clause/single window	OK	35ms
/window functions/tests/distributed/window clause/unused window	OK	39ms
/window functions/tests/distributed/over clause	OK	219ms
/window functions/tests/distributed/over clause/adhoc window	OK	39ms
/window functions/tests/distributed/over clause/empty	OK	36ms
/window functions/tests/distributed/over clause/empty named window	OK	40ms
/window functions/tests/distributed/over clause/invalid multiple windows	OK	34ms
/window functions/tests/distributed/over clause/invalid window name	OK	34ms
/window functions/tests/distributed/over clause/missing window spec	OK	32ms
/window functions/tests/distributed/funcs	OK	1s 190ms
/window functions/tests/distributed/funcs/dense rank	OK	39ms
/window functions/tests/distributed/funcs/first value	OK	79ms
/window functions/tests/distributed/funcs/first value with lead workaround	OK	38ms
/window functions/tests/distributed/funcs/lag	OK	151ms
/window functions/tests/distributed/funcs/lagInFrame	OK	190ms
/window functions/tests/distributed/funcs/last value	OK	174ms
/window functions/tests/distributed/funcs/last value with lag workaround	OK	35ms
/window functions/tests/distributed/funcs/last value with no frame	OK	39ms
/window functions/tests/distributed/funcs/lead	OK	164ms
/window functions/tests/distributed/funcs/leadInFrame	OK	196ms
/window functions/tests/distributed/funcs/rank	OK	38ms
/window functions/tests/distributed/funcs/row number	OK	37ms
/window functions/tests/distributed/aggregate funcs	OK	3s 5ms
/window functions/tests/distributed/aggregate funcs/aggregate and window function in the same window	OK	34ms
/window functions/tests/distributed/aggregate funcs/aggregate funcs over rows frame	OK	2s 454ms
/window functions/tests/distributed/aggregate funcs/aggregate function recovers from nan	OK	60ms
/window functions/tests/distributed/aggregate funcs/avgWeighted	OK	118ms
/window functions/tests/distributed/aggregate funcs/avg with nulls	OK	44ms
/window functions/tests/distributed/aggregate funcs/bit functions	OK	36ms
/window functions/tests/distributed/aggregate funcs/nested aggregates	OK	37ms
/window functions/tests/distributed/aggregate funcs/stddevpop	OK	34ms
/window functions/tests/distributed/aggregate funcs/stddevsamp	OK	35ms
/window functions/tests/distributed/aggregate funcs/sum	OK	40ms
/window functions/tests/distributed/aggregate funcs/ungrouped aggregate over empty row set	OK	35ms
/window functions/tests/distributed/aggregate funcs/var pop	OK	35ms
/window functions/tests/distributed/aggregate funcs/var samp	OK	35ms
/window functions/tests/distributed/time decayed funcs	Fail	53s 320ms
/window functions/tests/distributed/time decayed funcs/exponentialTimeDecayedAvg	Fail	6s 242ms
/window functions/tests/distributed/time decayed funcs/exponentialTimeDecayedCount	Fail	5s 412ms
/window functions/tests/distributed/time decayed funcs/exponentialTimeDecayedMax	Fail	35s 529ms
/window functions/tests/distributed/time decayed funcs/exponentialTimeDecayedSum	Fail	6s 134ms
/window functions/tests/distributed/errors	OK	347ms
/window functions/tests/distributed/errors/error coma between partition by and order by clause	OK	32ms
/window functions/tests/distributed/errors/error named window defined twice	OK	34ms
/window functions/tests/distributed/errors/error order by another window function	OK	32ms
/window functions/tests/distributed/errors/error select from window	OK	44ms
/window functions/tests/distributed/errors/error using non window function	OK	34ms
/window functions/tests/distributed/errors/error window function in alter delete where	OK	30ms
/window functions/tests/distributed/errors/error window function in group by	OK	35ms
/window functions/tests/distributed/errors/error window function in having	OK	33ms
/window functions/tests/distributed/errors/error window function in join	OK	36ms
/window functions/tests/distributed/errors/error window function in where	OK	31ms
/window functions/tests/distributed/misc	OK	721ms
/window functions/tests/distributed/misc/count with empty over clause without start	OK	36ms
/window functions/tests/distributed/misc/empty table	OK	35ms
/window functions/tests/distributed/misc/exclude clause	OK	38ms
/window functions/tests/distributed/misc/from subquery	OK	40ms
/window functions/tests/distributed/misc/group by and multiple windows	OK	45ms
/window functions/tests/distributed/misc/group by and one window	OK	39ms
/window functions/tests/distributed/misc/groups frame	OK	35ms
/window functions/tests/distributed/misc/in view	OK	133ms
/window functions/tests/distributed/misc/query with order by and one window	OK	34ms
/window functions/tests/distributed/misc/subquery expr preceding	OK	41ms
/window functions/tests/distributed/misc/subquery multiple window functions	OK	38ms
/window functions/tests/distributed/misc/subquery with multiple windows filtering	OK	37ms
/window functions/tests/distributed/misc/window functions in select expression	XFail	36ms
/window functions/tests/distributed/misc/window functions in subquery	XFail	52ms
/window functions/tests/distributed/misc/windows with same partitioning but different ordering	OK	38ms
/window functions/tests/distributed/misc/with union all	OK	33ms
/window functions/tests/distributed/datatypes	OK	428ms
/window functions/tests/distributed/datatypes/date	OK	34ms
/window functions/tests/distributed/datatypes/datetime	OK	33ms
/window functions/tests/distributed/datatypes/datetime64	OK	34ms
/window functions/tests/distributed/datatypes/decimal32	OK	37ms
/window functions/tests/distributed/datatypes/enum	OK	46ms
/window functions/tests/distributed/datatypes/fixed string	OK	31ms
/window functions/tests/distributed/datatypes/ipv4	OK	31ms
/window functions/tests/distributed/datatypes/ipv6	OK	33ms
/window functions/tests/distributed/datatypes/low cardinality	OK	35ms
/window functions/tests/distributed/datatypes/map	OK	37ms
/window functions/tests/distributed/datatypes/string	OK	33ms
/window functions/tests/distributed/datatypes/uuid	OK	36ms
/window functions/tests/distributed/non-negative derivative func	Skip	517us

Generated by TestFlows Open-Source Test Framework v1.9.220712.1163352