	Units	Skip	OK	Fail	XFail
Modules	1		1
Features	39		39
Scenarios	458	1	433		24
Checks	256		252		4
Examples	1418		1395		23
Steps	7689		7605	71	13

Test Name	Result	Message
/window functions/tests/non distributed/frame clause/range frame/between expr following and current row zero special case	XFail 125ms known bug	AssertionError Traceback (most recent call last): File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 262, in regression() File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/argparser.py", line 145, in capture_cluster_args return func(self, cluster_args=cluster_args, **kwargs) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 258, in regression Feature(run=load("window_functions.tests.feature", "feature"), flags=TE) File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/feature.py", line 75, in feature Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE) File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/frame_clause.py", line 68, in feature Feature(run=load("window_functions.tests.range_frame", "feature"), flags=TE) File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_frame.py", line 1745, in feature Scenario(run=scenario, flags=TE) File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_frame.py", line 1353, in between_expr_following_and_current_row_zero_special_case execute_query( File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/common.py", line 150, in execute_query r = current().context.node.query( ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 1079, 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 24.3.12): 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)) ORDER BY number FORMAT TabSeparatedWithNames ) Assertion values assert False, error(r.output) ^ is False Where File '/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py', line 1079 in 'query' 1071\\| assert message in r.output, error(r.output) 1072\\| 1073\\| if not ignore_exception: 1074\\| if message is None or "Exception:" not in message: 1075\\| with Then("check if output has exception") if steps else NullStep(): 1076\\| if "Exception:" in r.output: 1077\\| if raise_on_exception: 1078\\| raise QueryRuntimeException(r.output) 1079\\|> assert False, error(r.output) 1080\\| 1081\\| return r 1082\\|
/window functions/tests/non distributed/frame clause/range frame/between expr following and expr following without order by error	XFail 87ms invalid error message	AssertionError Traceback (most recent call last): File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 262, in regression() File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/argparser.py", line 145, in capture_cluster_args return func(self, cluster_args=cluster_args, **kwargs) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 258, in regression Feature(run=load("window_functions.tests.feature", "feature"), flags=TE) File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/feature.py", line 75, in feature Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE) File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/frame_clause.py", line 68, in feature Feature(run=load("window_functions.tests.range_frame", "feature"), flags=TE) File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_frame.py", line 1745, in feature Scenario(run=scenario, flags=TE) File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_frame.py", line 1217, in between_expr_following_and_expr_following_without_order_by_error self.context.node.query( File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 1071, 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 24.3.12): 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)) FORMAT TabSeparated ) 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 24.3.12):\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)) FORMAT TabSeparated\n)" assert message in r.output, error(r.output) ^ is = False assert message in r.output, error(r.output) ^ is False Where File '/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py', line 1071 in 'query' 1063\\| assert r.exitcode == exitcode, error(r.output) 1064\\| 1065\\| if message is not None: 1066\\| with ( 1067\\| Then(f"output should contain message", description=message) 1068\\| if steps 1069\\| else NullStep() 1070\\| ): 1071\\|> assert message in r.output, error(r.output) 1072\\| 1073\\| if not ignore_exception: 1074\\| if message is None or "Exception:" not in message:
/window functions/tests/non distributed/frame clause/range frame/between expr following and expr preceding with order by zero special case	XFail 74ms known bug	AssertionError Traceback (most recent call last): File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 262, in regression() File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/argparser.py", line 145, in capture_cluster_args return func(self, cluster_args=cluster_args, **kwargs) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 258, in regression Feature(run=load("window_functions.tests.feature", "feature"), flags=TE) File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/feature.py", line 75, in feature Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE) File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/frame_clause.py", line 68, in feature Feature(run=load("window_functions.tests.range_frame", "feature"), flags=TE) File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_frame.py", line 1745, in feature Scenario(run=scenario, flags=TE) File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_frame.py", line 1422, in between_expr_following_and_expr_preceding_with_order_by_zero_special_case execute_query( File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/common.py", line 150, in execute_query r = current().context.node.query( ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 1079, 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 24.3.12): 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)) ORDER BY number FORMAT TabSeparatedWithNames ) Assertion values assert False, error(r.output) ^ is False Where File '/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py', line 1079 in 'query' 1071\\| assert message in r.output, error(r.output) 1072\\| 1073\\| if not ignore_exception: 1074\\| if message is None or "Exception:" not in message: 1075\\| with Then("check if output has exception") if steps else NullStep(): 1076\\| if "Exception:" in r.output: 1077\\| if raise_on_exception: 1078\\| raise QueryRuntimeException(r.output) 1079\\|> assert False, error(r.output) 1080\\| 1081\\| return r 1082\\|
/window functions/tests/non distributed/frame clause/range frame/between expr following and expr preceding without order by error	XFail 86ms invalid error message	AssertionError Traceback (most recent call last): File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 262, in regression() File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/argparser.py", line 145, in capture_cluster_args return func(self, cluster_args=cluster_args, **kwargs) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 258, in regression Feature(run=load("window_functions.tests.feature", "feature"), flags=TE) File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/feature.py", line 75, in feature Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE) File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/frame_clause.py", line 68, in feature Feature(run=load("window_functions.tests.range_frame", "feature"), flags=TE) File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_frame.py", line 1745, in feature Scenario(run=scenario, flags=TE) File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_frame.py", line 1234, in between_expr_following_and_expr_preceding_without_order_by_error self.context.node.query( File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 1071, 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 24.3.12): 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)) FORMAT TabSeparated ) 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 24.3.12):\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)) FORMAT TabSeparated\n)" assert message in r.output, error(r.output) ^ is = False assert message in r.output, error(r.output) ^ is False Where File '/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py', line 1071 in 'query' 1063\\| assert r.exitcode == exitcode, error(r.output) 1064\\| 1065\\| if message is not None: 1066\\| with ( 1067\\| Then(f"output should contain message", description=message) 1068\\| if steps 1069\\| else NullStep() 1070\\| ): 1071\\|> assert message in r.output, error(r.output) 1072\\| 1073\\| if not ignore_exception: 1074\\| if message is None or "Exception:" not in message:
/window functions/tests/non distributed/frame clause/range frame/order by decimal	XFail 101ms Exception: The RANGE OFFSET frame for 'DB::ColumnDecimal >' ORDER BY column is not implemented	AssertionError Traceback (most recent call last): File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 262, in regression() File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/argparser.py", line 145, in capture_cluster_args return func(self, cluster_args=cluster_args, **kwargs) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 258, in regression Feature(run=load("window_functions.tests.feature", "feature"), flags=TE) File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/feature.py", line 75, in feature Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE) File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/frame_clause.py", line 68, in feature Feature(run=load("window_functions.tests.range_frame", "feature"), flags=TE) File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_frame.py", line 1745, in feature Scenario(run=scenario, flags=TE) File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_frame.py", line 1658, in order_by_decimal execute_query( File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/common.py", line 150, in execute_query r = current().context.node.query( ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 1079, 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 24.3.12): 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) ORDER BY id FORMAT TabSeparatedWithNames ) Assertion values assert False, error(r.output) ^ is False Where File '/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py', line 1079 in 'query' 1071\\| assert message in r.output, error(r.output) 1072\\| 1073\\| if not ignore_exception: 1074\\| if message is None or "Exception:" not in message: 1075\\| with Then("check if output has exception") if steps else NullStep(): 1076\\| if "Exception:" in r.output: 1077\\| if raise_on_exception: 1078\\| raise QueryRuntimeException(r.output) 1079\\|> assert False, error(r.output) 1080\\| 1081\\| return r 1082\\|
/window functions/tests/non distributed/frame clause/range frame/with nulls	XFail 109ms DB::Exception: The RANGE OFFSET frame for 'DB::ColumnNullable' ORDER BY column is not implemented	AssertionError Traceback (most recent call last): File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 262, in regression() File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/argparser.py", line 145, in capture_cluster_args return func(self, cluster_args=cluster_args, **kwargs) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 258, in regression Feature(run=load("window_functions.tests.feature", "feature"), flags=TE) File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/feature.py", line 75, in feature Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE) File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/frame_clause.py", line 68, in feature Feature(run=load("window_functions.tests.range_frame", "feature"), flags=TE) File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_frame.py", line 1745, in feature Scenario(run=scenario, flags=TE) File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_frame.py", line 1719, in with_nulls execute_query( File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/common.py", line 162, 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 = 'x\ty\tfirst_value\tlast_value\n1\t1\t1\t3\n2\t2\t1\t4\n3\t3\t1\t5\n4\t4\t2\t5\n5\t5\t3\t5\n\\N\t42\t42\t43\n\\N\t43\t42\t43' assert r.output.strip() == expected, error() ^ is 'x\ty\tfirst_value\tlast_value\n1\t1\t1\t3\n2\t2\t1\t4\n3\t3\t1\t5\n4\t4\t2\t5\n5\t5\t3\t5\n\\N\t42\t42\t43\n\\N\t43\t42\t43' assert r.output.strip() == expected, error() ^ is = assert r.output.strip() == expected, error() ^ is = 'x\ty\tfirst_value\tlast_value\n1\t1\t1\t3\n2\t2\t1\t4\n3\t3\t1\t5\n4\t4\t2\t5\n5\t5\t3\t5\n\\N\t42\t42\t43\n\\N\t43\t42\t43' assert r.output.strip() == expected, error() ^ is 'x\ty\tfirst_value\tlast_value\n\\N\t42\t42\t43\n\\N\t43\t42\t43\n1\t1\t1\t3\n2\t2\t1\t4\n3\t3\t1\t5\n4\t4\t2\t5\n5\t5\t3\t5' assert r.output.strip() == expected, error() ^ is = False @@ -1,0 +2,2 @@ +\N 42 42 43 +\N 43 42 43 @@ -7,2 +8,0 @@ -\N 42 42 43 -\N 43 42 43 assert r.output.strip() == expected, error() ^ is False Where File '/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/common.py', line 162 in 'execute_query' 154\\| no_checks=no_checks, 155\\| ) 156\\| if no_checks: 157\\| return r 158\\| 159\\| if message is None: 160\\| if expected is not None: 161\\| with Then("I check output against expected"): 162\\|> assert r.output.strip() == expected, error() 163\\| else: 164\\| with Then("I check output against snapshot"): 165\\| with values() as that:
/window functions/tests/non distributed/frame clause/range overflow/negative overflow with Int16	XFail 102ms exception on conversion	AssertionError Traceback (most recent call last): File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 262, in regression() File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/argparser.py", line 145, in capture_cluster_args return func(self, cluster_args=cluster_args, **kwargs) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 258, in regression Feature(run=load("window_functions.tests.feature", "feature"), flags=TE) File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/feature.py", line 75, in feature Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE) File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/frame_clause.py", line 69, in feature Feature(run=load("window_functions.tests.range_overflow", "feature"), flags=TE) File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_overflow.py", line 145, in feature Scenario(run=scenario, flags=TE) File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_overflow.py", line 42, in negative_overflow_with_Int16 execute_query( File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/common.py", line 150, in execute_query r = current().context.node.query( ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 1079, 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 24.3.12): 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)) order by x FORMAT TabSeparatedWithNames ) Assertion values assert False, error(r.output) ^ is False Where File '/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py', line 1079 in 'query' 1071\\| assert message in r.output, error(r.output) 1072\\| 1073\\| if not ignore_exception: 1074\\| if message is None or "Exception:" not in message: 1075\\| with Then("check if output has exception") if steps else NullStep(): 1076\\| if "Exception:" in r.output: 1077\\| if raise_on_exception: 1078\\| raise QueryRuntimeException(r.output) 1079\\|> assert False, error(r.output) 1080\\| 1081\\| return r 1082\\|
/window functions/tests/non distributed/frame clause/range overflow/positive overflow with Int16	XFail 85ms exception on conversion	AssertionError Traceback (most recent call last): File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 262, in regression() File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/argparser.py", line 145, in capture_cluster_args return func(self, cluster_args=cluster_args, **kwargs) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 258, in regression Feature(run=load("window_functions.tests.feature", "feature"), flags=TE) File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/feature.py", line 75, in feature Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE) File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/frame_clause.py", line 69, in feature Feature(run=load("window_functions.tests.range_overflow", "feature"), flags=TE) File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_overflow.py", line 145, in feature Scenario(run=scenario, flags=TE) File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_overflow.py", line 20, in positive_overflow_with_Int16 execute_query( File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/common.py", line 150, in execute_query r = current().context.node.query( ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 1079, 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 24.3.12): 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) order by x FORMAT TabSeparatedWithNames ) Assertion values assert False, error(r.output) ^ is False Where File '/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py', line 1079 in 'query' 1071\\| assert message in r.output, error(r.output) 1072\\| 1073\\| if not ignore_exception: 1074\\| if message is None or "Exception:" not in message: 1075\\| with Then("check if output has exception") if steps else NullStep(): 1076\\| if "Exception:" in r.output: 1077\\| if raise_on_exception: 1078\\| raise QueryRuntimeException(r.output) 1079\\|> assert False, error(r.output) 1080\\| 1081\\| return r 1082\\|
/window functions/tests/non distributed/frame clause/range errors/error negative following offset	XFail 58ms https://github.com/ClickHouse/ClickHouse/issues/22442	AssertionError Traceback (most recent call last): File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 262, in regression() File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/argparser.py", line 145, in capture_cluster_args return func(self, cluster_args=cluster_args, **kwargs) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 258, in regression Feature(run=load("window_functions.tests.feature", "feature"), flags=TE) File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/feature.py", line 75, in feature Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE) File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/frame_clause.py", line 71, in feature Feature(run=load("window_functions.tests.range_errors", "feature"), flags=TE) File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_errors.py", line 114, in feature Scenario(run=scenario, flags=TE) File "/home/ubuntu/_work/ClickHouse/ClickHouse/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 "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 1071, 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 24.3.12): Code: 36. DB::Exception: Received from localhost:9000. DB::Exception: Frame end offset for 'RANGE' frame must be a nonnegative 32-bit integer, '-2' of type 'Int64' 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 FORMAT TabSeparated ) 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 24.3.12):\nCode: 36. DB::Exception: Received from localhost:9000. DB::Exception: Frame end offset for 'RANGE' frame must be a nonnegative 32-bit integer, '-2' of type 'Int64' 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 FORMAT TabSeparated\n)" assert message in r.output, error(r.output) ^ is = False assert message in r.output, error(r.output) ^ is False Where File '/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py', line 1071 in 'query' 1063\\| assert r.exitcode == exitcode, error(r.output) 1064\\| 1065\\| if message is not None: 1066\\| with ( 1067\\| Then(f"output should contain message", description=message) 1068\\| if steps 1069\\| else NullStep() 1070\\| ): 1071\\|> assert message in r.output, error(r.output) 1072\\| 1073\\| if not ignore_exception: 1074\\| if message is None or "Exception:" not in message:
/window functions/tests/non distributed/frame clause/range errors/error negative preceding offset	XFail 96ms https://github.com/ClickHouse/ClickHouse/issues/22442	AssertionError Traceback (most recent call last): File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 262, in regression() File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/argparser.py", line 145, in capture_cluster_args return func(self, cluster_args=cluster_args, **kwargs) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 258, in regression Feature(run=load("window_functions.tests.feature", "feature"), flags=TE) File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/feature.py", line 75, in feature Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE) File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/frame_clause.py", line 71, in feature Feature(run=load("window_functions.tests.range_errors", "feature"), flags=TE) File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_errors.py", line 114, in feature Scenario(run=scenario, flags=TE) File "/home/ubuntu/_work/ClickHouse/ClickHouse/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 "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 1071, 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 24.3.12): Code: 36. DB::Exception: Received from localhost:9000. DB::Exception: Frame start offset for 'RANGE' frame must be a nonnegative 32-bit integer, '-1' of type 'Int64' 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 FORMAT TabSeparated ) 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 24.3.12):\nCode: 36. DB::Exception: Received from localhost:9000. DB::Exception: Frame start offset for 'RANGE' frame must be a nonnegative 32-bit integer, '-1' of type 'Int64' 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 FORMAT TabSeparated\n)" assert message in r.output, error(r.output) ^ is = False assert message in r.output, error(r.output) ^ is False Where File '/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py', line 1071 in 'query' 1063\\| assert r.exitcode == exitcode, error(r.output) 1064\\| 1065\\| if message is not None: 1066\\| with ( 1067\\| Then(f"output should contain message", description=message) 1068\\| if steps 1069\\| else NullStep() 1070\\| ): 1071\\|> assert message in r.output, error(r.output) 1072\\| 1073\\| if not ignore_exception: 1074\\| if message is None or "Exception:" not in message:
/window functions/tests/non distributed/misc/subquery expr preceding	XFail 70ms subquery is not supported as offset	AssertionError Traceback (most recent call last): File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 262, in regression() File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/argparser.py", line 145, in capture_cluster_args return func(self, cluster_args=cluster_args, **kwargs) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 258, in regression Feature(run=load("window_functions.tests.feature", "feature"), flags=TE) File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/feature.py", line 82, in feature Feature(run=load("window_functions.tests.misc", "feature"), flags=TE) File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/misc.py", line 466, in feature Scenario(run=scenario, flags=TE) File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/misc.py", line 27, in subquery_expr_preceding execute_query( File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/common.py", line 162, 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\n0\t0\n1\t1\n3\t2\n5\t3\n7\t4\n9\t5\n11\t6\n13\t7\n15\t8\n17\t9' assert r.output.strip() == expected, error() ^ is 'sum\tunique1\n0\t0\n1\t1\n3\t2\n5\t3\n7\t4\n9\t5\n11\t6\n13\t7\n15\t8\n17\t9' assert r.output.strip() == expected, error() ^ is = assert r.output.strip() == expected, error() ^ is = 'sum\tunique1\n0\t0\n1\t1\n3\t2\n5\t3\n7\t4\n9\t5\n11\t6\n13\t7\n15\t8\n17\t9' assert r.output.strip() == expected, error() ^ is 'sum\tunique1\n0\t0\n1\t1\n3\t2\n5\t3Fmu\n7\t4\n9\t5\n11\t6\n13\t7\n15\t8\n17\t9' assert r.output.strip() == expected, error() ^ is = False @@ -5 +5 @@ -5 3 +5 3Fmu assert r.output.strip() == expected, error() ^ is False Where File '/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/common.py', line 162 in 'execute_query' 154\\| no_checks=no_checks, 155\\| ) 156\\| if no_checks: 157\\| return r 158\\| 159\\| if message is None: 160\\| if expected is not None: 161\\| with Then("I check output against expected"): 162\\|> assert r.output.strip() == expected, error() 163\\| else: 164\\| with Then("I check output against snapshot"): 165\\| with values() as that:
/window functions/tests/distributed/frame clause/range frame/between expr following and current row zero special case	XFail 94ms known bug	AssertionError Traceback (most recent call last): File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 262, in regression() File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/argparser.py", line 145, in capture_cluster_args return func(self, cluster_args=cluster_args, **kwargs) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 258, in regression Feature(run=load("window_functions.tests.feature", "feature"), flags=TE) File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/feature.py", line 75, in feature Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE) File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/frame_clause.py", line 68, in feature Feature(run=load("window_functions.tests.range_frame", "feature"), flags=TE) File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_frame.py", line 1745, in feature Scenario(run=scenario, flags=TE) File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_frame.py", line 1353, in between_expr_following_and_current_row_zero_special_case execute_query( File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/common.py", line 150, in execute_query r = current().context.node.query( ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 1079, 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 24.3.12): 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)) ORDER BY number FORMAT TabSeparatedWithNames ) Assertion values assert False, error(r.output) ^ is False Where File '/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py', line 1079 in 'query' 1071\\| assert message in r.output, error(r.output) 1072\\| 1073\\| if not ignore_exception: 1074\\| if message is None or "Exception:" not in message: 1075\\| with Then("check if output has exception") if steps else NullStep(): 1076\\| if "Exception:" in r.output: 1077\\| if raise_on_exception: 1078\\| raise QueryRuntimeException(r.output) 1079\\|> assert False, error(r.output) 1080\\| 1081\\| return r 1082\\|
/window functions/tests/distributed/frame clause/range frame/between expr following and expr following without order by error	XFail 82ms invalid error message	AssertionError Traceback (most recent call last): File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 262, in regression() File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/argparser.py", line 145, in capture_cluster_args return func(self, cluster_args=cluster_args, **kwargs) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 258, in regression Feature(run=load("window_functions.tests.feature", "feature"), flags=TE) File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/feature.py", line 75, in feature Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE) File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/frame_clause.py", line 68, in feature Feature(run=load("window_functions.tests.range_frame", "feature"), flags=TE) File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_frame.py", line 1745, in feature Scenario(run=scenario, flags=TE) File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_frame.py", line 1217, in between_expr_following_and_expr_following_without_order_by_error self.context.node.query( File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 1071, 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 24.3.12): 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)) FORMAT TabSeparated ) 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 24.3.12):\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)) FORMAT TabSeparated\n)" assert message in r.output, error(r.output) ^ is = False assert message in r.output, error(r.output) ^ is False Where File '/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py', line 1071 in 'query' 1063\\| assert r.exitcode == exitcode, error(r.output) 1064\\| 1065\\| if message is not None: 1066\\| with ( 1067\\| Then(f"output should contain message", description=message) 1068\\| if steps 1069\\| else NullStep() 1070\\| ): 1071\\|> assert message in r.output, error(r.output) 1072\\| 1073\\| if not ignore_exception: 1074\\| if message is None or "Exception:" not in message:
/window functions/tests/distributed/frame clause/range frame/between expr following and expr preceding with order by zero special case	XFail 73ms known bug	AssertionError Traceback (most recent call last): File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 262, in regression() File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/argparser.py", line 145, in capture_cluster_args return func(self, cluster_args=cluster_args, **kwargs) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 258, in regression Feature(run=load("window_functions.tests.feature", "feature"), flags=TE) File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/feature.py", line 75, in feature Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE) File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/frame_clause.py", line 68, in feature Feature(run=load("window_functions.tests.range_frame", "feature"), flags=TE) File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_frame.py", line 1745, in feature Scenario(run=scenario, flags=TE) File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_frame.py", line 1422, in between_expr_following_and_expr_preceding_with_order_by_zero_special_case execute_query( File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/common.py", line 150, in execute_query r = current().context.node.query( ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 1079, 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 24.3.12): 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)) ORDER BY number FORMAT TabSeparatedWithNames ) Assertion values assert False, error(r.output) ^ is False Where File '/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py', line 1079 in 'query' 1071\\| assert message in r.output, error(r.output) 1072\\| 1073\\| if not ignore_exception: 1074\\| if message is None or "Exception:" not in message: 1075\\| with Then("check if output has exception") if steps else NullStep(): 1076\\| if "Exception:" in r.output: 1077\\| if raise_on_exception: 1078\\| raise QueryRuntimeException(r.output) 1079\\|> assert False, error(r.output) 1080\\| 1081\\| return r 1082\\|
/window functions/tests/distributed/frame clause/range frame/between expr following and expr preceding without order by error	XFail 80ms invalid error message	AssertionError Traceback (most recent call last): File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 262, in regression() File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/argparser.py", line 145, in capture_cluster_args return func(self, cluster_args=cluster_args, **kwargs) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 258, in regression Feature(run=load("window_functions.tests.feature", "feature"), flags=TE) File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/feature.py", line 75, in feature Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE) File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/frame_clause.py", line 68, in feature Feature(run=load("window_functions.tests.range_frame", "feature"), flags=TE) File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_frame.py", line 1745, in feature Scenario(run=scenario, flags=TE) File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_frame.py", line 1234, in between_expr_following_and_expr_preceding_without_order_by_error self.context.node.query( File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 1071, 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 24.3.12): 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)) FORMAT TabSeparated ) 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 24.3.12):\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)) FORMAT TabSeparated\n)" assert message in r.output, error(r.output) ^ is = False assert message in r.output, error(r.output) ^ is False Where File '/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py', line 1071 in 'query' 1063\\| assert r.exitcode == exitcode, error(r.output) 1064\\| 1065\\| if message is not None: 1066\\| with ( 1067\\| Then(f"output should contain message", description=message) 1068\\| if steps 1069\\| else NullStep() 1070\\| ): 1071\\|> assert message in r.output, error(r.output) 1072\\| 1073\\| if not ignore_exception: 1074\\| if message is None or "Exception:" not in message:
/window functions/tests/distributed/frame clause/range frame/order by decimal	XFail 104ms Exception: The RANGE OFFSET frame for 'DB::ColumnDecimal >' ORDER BY column is not implemented	AssertionError Traceback (most recent call last): File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 262, in regression() File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/argparser.py", line 145, in capture_cluster_args return func(self, cluster_args=cluster_args, **kwargs) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 258, in regression Feature(run=load("window_functions.tests.feature", "feature"), flags=TE) File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/feature.py", line 75, in feature Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE) File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/frame_clause.py", line 68, in feature Feature(run=load("window_functions.tests.range_frame", "feature"), flags=TE) File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_frame.py", line 1745, in feature Scenario(run=scenario, flags=TE) File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_frame.py", line 1658, in order_by_decimal execute_query( File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/common.py", line 150, in execute_query r = current().context.node.query( ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 1079, 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 24.3.12): 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) ORDER BY id FORMAT TabSeparatedWithNames ) Assertion values assert False, error(r.output) ^ is False Where File '/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py', line 1079 in 'query' 1071\\| assert message in r.output, error(r.output) 1072\\| 1073\\| if not ignore_exception: 1074\\| if message is None or "Exception:" not in message: 1075\\| with Then("check if output has exception") if steps else NullStep(): 1076\\| if "Exception:" in r.output: 1077\\| if raise_on_exception: 1078\\| raise QueryRuntimeException(r.output) 1079\\|> assert False, error(r.output) 1080\\| 1081\\| return r 1082\\|
/window functions/tests/distributed/frame clause/range frame/with nulls	XFail 129ms DB::Exception: The RANGE OFFSET frame for 'DB::ColumnNullable' ORDER BY column is not implemented	AssertionError Traceback (most recent call last): File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 262, in regression() File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/argparser.py", line 145, in capture_cluster_args return func(self, cluster_args=cluster_args, **kwargs) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 258, in regression Feature(run=load("window_functions.tests.feature", "feature"), flags=TE) File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/feature.py", line 75, in feature Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE) File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/frame_clause.py", line 68, in feature Feature(run=load("window_functions.tests.range_frame", "feature"), flags=TE) File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_frame.py", line 1745, in feature Scenario(run=scenario, flags=TE) File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_frame.py", line 1719, in with_nulls execute_query( File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/common.py", line 162, 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 = 'x\ty\tfirst_value\tlast_value\n1\t1\t1\t3\n2\t2\t1\t4\n3\t3\t1\t5\n4\t4\t2\t5\n5\t5\t3\t5\n\\N\t42\t42\t43\n\\N\t43\t42\t43' assert r.output.strip() == expected, error() ^ is 'x\ty\tfirst_value\tlast_value\n1\t1\t1\t3\n2\t2\t1\t4\n3\t3\t1\t5\n4\t4\t2\t5\n5\t5\t3\t5\n\\N\t42\t42\t43\n\\N\t43\t42\t43' assert r.output.strip() == expected, error() ^ is = assert r.output.strip() == expected, error() ^ is = 'x\ty\tfirst_value\tlast_value\n1\t1\t1\t3\n2\t2\t1\t4\n3\t3\t1\t5\n4\t4\t2\t5\n5\t5\t3\t5\n\\N\t42\t42\t43\n\\N\t43\t42\t43' assert r.output.strip() == expected, error() ^ is 'x\ty\tfirst_value\tlast_value\n\\N\t42\t42\t43\n\\N\t43\t42\t43\n1\t1\t1\t3\n2\t2\t1\t4\n3\t3\t1\t5\n4\t4\t2\t5\n5\t5\t3\t5' assert r.output.strip() == expected, error() ^ is = False @@ -1,0 +2,2 @@ +\N 42 42 43 +\N 43 42 43 @@ -7,2 +8,0 @@ -\N 42 42 43 -\N 43 42 43 assert r.output.strip() == expected, error() ^ is False Where File '/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/common.py', line 162 in 'execute_query' 154\\| no_checks=no_checks, 155\\| ) 156\\| if no_checks: 157\\| return r 158\\| 159\\| if message is None: 160\\| if expected is not None: 161\\| with Then("I check output against expected"): 162\\|> assert r.output.strip() == expected, error() 163\\| else: 164\\| with Then("I check output against snapshot"): 165\\| with values() as that:
/window functions/tests/distributed/frame clause/range overflow/negative overflow with Int16	XFail 84ms exception on conversion	AssertionError Traceback (most recent call last): File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 262, in regression() File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/argparser.py", line 145, in capture_cluster_args return func(self, cluster_args=cluster_args, **kwargs) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 258, in regression Feature(run=load("window_functions.tests.feature", "feature"), flags=TE) File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/feature.py", line 75, in feature Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE) File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/frame_clause.py", line 69, in feature Feature(run=load("window_functions.tests.range_overflow", "feature"), flags=TE) File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_overflow.py", line 145, in feature Scenario(run=scenario, flags=TE) File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_overflow.py", line 42, in negative_overflow_with_Int16 execute_query( File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/common.py", line 150, in execute_query r = current().context.node.query( ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 1079, 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 24.3.12): 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)) order by x FORMAT TabSeparatedWithNames ) Assertion values assert False, error(r.output) ^ is False Where File '/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py', line 1079 in 'query' 1071\\| assert message in r.output, error(r.output) 1072\\| 1073\\| if not ignore_exception: 1074\\| if message is None or "Exception:" not in message: 1075\\| with Then("check if output has exception") if steps else NullStep(): 1076\\| if "Exception:" in r.output: 1077\\| if raise_on_exception: 1078\\| raise QueryRuntimeException(r.output) 1079\\|> assert False, error(r.output) 1080\\| 1081\\| return r 1082\\|
/window functions/tests/distributed/frame clause/range overflow/positive overflow with Int16	XFail 87ms exception on conversion	AssertionError Traceback (most recent call last): File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 262, in regression() File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/argparser.py", line 145, in capture_cluster_args return func(self, cluster_args=cluster_args, **kwargs) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 258, in regression Feature(run=load("window_functions.tests.feature", "feature"), flags=TE) File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/feature.py", line 75, in feature Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE) File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/frame_clause.py", line 69, in feature Feature(run=load("window_functions.tests.range_overflow", "feature"), flags=TE) File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_overflow.py", line 145, in feature Scenario(run=scenario, flags=TE) File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_overflow.py", line 20, in positive_overflow_with_Int16 execute_query( File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/common.py", line 150, in execute_query r = current().context.node.query( ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 1079, 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 24.3.12): 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) order by x FORMAT TabSeparatedWithNames ) Assertion values assert False, error(r.output) ^ is False Where File '/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py', line 1079 in 'query' 1071\\| assert message in r.output, error(r.output) 1072\\| 1073\\| if not ignore_exception: 1074\\| if message is None or "Exception:" not in message: 1075\\| with Then("check if output has exception") if steps else NullStep(): 1076\\| if "Exception:" in r.output: 1077\\| if raise_on_exception: 1078\\| raise QueryRuntimeException(r.output) 1079\\|> assert False, error(r.output) 1080\\| 1081\\| return r 1082\\|
/window functions/tests/distributed/frame clause/range datetime/datetime order by desc range between n preceding and n following	XFail 109ms https://github.com/ClickHouse/ClickHouse/issues/23902	AssertionError Traceback (most recent call last): File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 262, in regression() File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/argparser.py", line 145, in capture_cluster_args return func(self, cluster_args=cluster_args, **kwargs) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 258, in regression Feature(run=load("window_functions.tests.feature", "feature"), flags=TE) File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/feature.py", line 75, in feature Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE) File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/frame_clause.py", line 70, in feature Feature(run=load("window_functions.tests.range_datetime", "feature"), flags=TE) File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_datetime.py", line 264, in feature Scenario(run=scenario, flags=TE) File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_datetime.py", line 245, in datetime_order_by_desc_range_between_n_preceding_and_n_following execute_query( File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/common.py", line 162, 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 = 'id\tf_timestamp\tfirst_value\tlast_value\n10\t2008-10-19 10:23:54\t10\t9\n9\t2007-10-19 10:23:54\t10\t8\n6\t2004-10-19 10:23:54\t7\t5\n5\t2003-10-19 10:23:54\t6\t4\n4\t2002-10-19 10:23:54\t5\t3\n2\t2001-10-19 10:23:54\t4\t1\n3\t2001-10-19 10:23:54\t4\t1\n1\t2000-10-19 10:23:54\t2\t1\n7\t2005-10-19 10:23:54\t8\t6\n8\t2006-10-19 10:23:54\t9\t7' assert r.output.strip() == expected, error() ^ is 'id\tf_timestamp\tfirst_value\tlast_value\n10\t2008-10-19 10:23:54\t10\t9\n9\t2007-10-19 10:23:54\t10\t8\n6\t2004-10-19 10:23:54\t7\t5\n5\t2003-10-19 10:23:54\t6\t4\n4\t2002-10-19 10:23:54\t5\t3\n2\t2001-10-19 10:23:54\t4\t1\n3\t2001-10-19 10:23:54\t4\t1\n1\t2000-10-19 10:23:54\t2\t1\n7\t2005-10-19 10:23:54\t8\t6\n8\t2006-10-19 10:23:54\t9\t7' assert r.output.strip() == expected, error() ^ is = assert r.output.strip() == expected, error() ^ is = 'id\tf_timestamp\tfirst_value\tlast_value\n10\t2008-10-19 10:23:54\t10\t9\n9\t2007-10-19 10:23:54\t10\t8\n6\t2004-10-19 10:23:54\t7\t5\n5\t2003-10-19 10:23:54\t6\t4\n4\t2002-10-19 10:23:54\t5\t3\n2\t2001-10-19 10:23:54\t4\t1\n3\t2001-10-19 10:23:54\t4\t1\n1\t2000-10-19 10:23:54\t2\t1\n7\t2005-10-19 10:23:54\t8\t6\n8\t2006-10-19 10:23:54\t9\t7' assert r.output.strip() == expected, error() ^ is 'id\tf_timestamp\tfirst_value\tlast_value\n10\t2008-10-19 10:23:54\t10\t9\n9\t2007-10-19 10:23:54\t10\t8\n8\t2006-10-19 10:23:54\t9\t7\n7\t2005-10-19 10:23:54\t8\t6\n6\t2004-10-19 10:23:54\t7\t5\n5\t2003-10-19 10:23:54\t6\t4\n4\t2002-10-19 10:23:54\t5\t3\n2\t2001-10-19 10:23:54\t4\t1\n3\t2001-10-19 10:23:54\t4\t1\n1\t2000-10-19 10:23:54\t2\t1' assert r.output.strip() == expected, error() ^ is = False @@ -3,0 +4,2 @@ +8 2006-10-19 10:23:54 9 7 +7 2005-10-19 10:23:54 8 6 @@ -10,2 +11,0 @@ -7 2005-10-19 10:23:54 8 6 -8 2006-10-19 10:23:54 9 7 assert r.output.strip() == expected, error() ^ is False Where File '/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/common.py', line 162 in 'execute_query' 154\\| no_checks=no_checks, 155\\| ) 156\\| if no_checks: 157\\| return r 158\\| 159\\| if message is None: 160\\| if expected is not None: 161\\| with Then("I check output against expected"): 162\\|> assert r.output.strip() == expected, error() 163\\| else: 164\\| with Then("I check output against snapshot"): 165\\| with values() as that:
/window functions/tests/distributed/frame clause/range errors/error negative following offset	XFail 66ms https://github.com/ClickHouse/ClickHouse/issues/22442	AssertionError Traceback (most recent call last): File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 262, in regression() File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/argparser.py", line 145, in capture_cluster_args return func(self, cluster_args=cluster_args, **kwargs) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 258, in regression Feature(run=load("window_functions.tests.feature", "feature"), flags=TE) File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/feature.py", line 75, in feature Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE) File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/frame_clause.py", line 71, in feature Feature(run=load("window_functions.tests.range_errors", "feature"), flags=TE) File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_errors.py", line 114, in feature Scenario(run=scenario, flags=TE) File "/home/ubuntu/_work/ClickHouse/ClickHouse/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 "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 1071, 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 24.3.12): Code: 36. DB::Exception: Received from localhost:9000. DB::Exception: Frame end offset for 'RANGE' frame must be a nonnegative 32-bit integer, '-2' of type 'Int64' 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 FORMAT TabSeparated ) 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 24.3.12):\nCode: 36. DB::Exception: Received from localhost:9000. DB::Exception: Frame end offset for 'RANGE' frame must be a nonnegative 32-bit integer, '-2' of type 'Int64' 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 FORMAT TabSeparated\n)" assert message in r.output, error(r.output) ^ is = False assert message in r.output, error(r.output) ^ is False Where File '/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py', line 1071 in 'query' 1063\\| assert r.exitcode == exitcode, error(r.output) 1064\\| 1065\\| if message is not None: 1066\\| with ( 1067\\| Then(f"output should contain message", description=message) 1068\\| if steps 1069\\| else NullStep() 1070\\| ): 1071\\|> assert message in r.output, error(r.output) 1072\\| 1073\\| if not ignore_exception: 1074\\| if message is None or "Exception:" not in message:
/window functions/tests/distributed/frame clause/range errors/error negative preceding offset	XFail 96ms https://github.com/ClickHouse/ClickHouse/issues/22442	AssertionError Traceback (most recent call last): File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 262, in regression() File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/argparser.py", line 145, in capture_cluster_args return func(self, cluster_args=cluster_args, **kwargs) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 258, in regression Feature(run=load("window_functions.tests.feature", "feature"), flags=TE) File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/feature.py", line 75, in feature Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE) File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/frame_clause.py", line 71, in feature Feature(run=load("window_functions.tests.range_errors", "feature"), flags=TE) File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_errors.py", line 114, in feature Scenario(run=scenario, flags=TE) File "/home/ubuntu/_work/ClickHouse/ClickHouse/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 "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 1071, 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 24.3.12): Code: 36. DB::Exception: Received from localhost:9000. DB::Exception: Frame start offset for 'RANGE' frame must be a nonnegative 32-bit integer, '-1' of type 'Int64' 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 FORMAT TabSeparated ) 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 24.3.12):\nCode: 36. DB::Exception: Received from localhost:9000. DB::Exception: Frame start offset for 'RANGE' frame must be a nonnegative 32-bit integer, '-1' of type 'Int64' 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 FORMAT TabSeparated\n)" assert message in r.output, error(r.output) ^ is = False assert message in r.output, error(r.output) ^ is False Where File '/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py', line 1071 in 'query' 1063\\| assert r.exitcode == exitcode, error(r.output) 1064\\| 1065\\| if message is not None: 1066\\| with ( 1067\\| Then(f"output should contain message", description=message) 1068\\| if steps 1069\\| else NullStep() 1070\\| ): 1071\\|> assert message in r.output, error(r.output) 1072\\| 1073\\| if not ignore_exception: 1074\\| if message is None or "Exception:" not in message:
/window functions/tests/distributed/misc/subquery expr preceding	XFail 137ms subquery is not supported as offset	AssertionError Traceback (most recent call last): File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 262, in regression() File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/argparser.py", line 145, in capture_cluster_args return func(self, cluster_args=cluster_args, **kwargs) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 258, in regression Feature(run=load("window_functions.tests.feature", "feature"), flags=TE) File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/feature.py", line 82, in feature Feature(run=load("window_functions.tests.misc", "feature"), flags=TE) File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/misc.py", line 466, in feature Scenario(run=scenario, flags=TE) File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/misc.py", line 27, in subquery_expr_preceding execute_query( File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/common.py", line 162, 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\n0\t0\n1\t1\n3\t2\n5\t3\n7\t4\n9\t5\n11\t6\n15\t8\n17\t9\n13\t7' assert r.output.strip() == expected, error() ^ is 'sum\tunique1\n0\t0\n1\t1\n3\t2\n5\t3\n7\t4\n9\t5\n11\t6\n15\t8\n17\t9\n13\t7' assert r.output.strip() == expected, error() ^ is = assert r.output.strip() == expected, error() ^ is = 'sum\tunique1\n0\t0\n1\t1\n3\t2\n5\t3\n7\t4\n9\t5\n11\t6\n15\t8\n17\t9\n13\t7' assert r.output.strip() == expected, error() ^ is 'sum\tunique1\n0\t0\n1\t1\n3\t2\n5\t3Fmu\n7\t4\n9\t5\n11\t6\n13\t7\n15\t8\n17\t9' assert r.output.strip() == expected, error() ^ is = False @@ -5 +5 @@ -5 3 +5 3Fmu @@ -8,0 +9 @@ +13 7 @@ -11 +11,0 @@ -13 7 assert r.output.strip() == expected, error() ^ is False Where File '/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/common.py', line 162 in 'execute_query' 154\\| no_checks=no_checks, 155\\| ) 156\\| if no_checks: 157\\| return r 158\\| 159\\| if message is None: 160\\| if expected is not None: 161\\| with Then("I check output against expected"): 162\\|> assert r.output.strip() == expected, error() 163\\| else: 164\\| with Then("I check output against snapshot"): 165\\| with values() as that:
/window functions/tests/distributed/misc/window functions in select expression	XFail 140ms not supported, https://github.com/ClickHouse/ClickHouse/issues/19857	AssertionError Traceback (most recent call last): File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 262, in regression() File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/argparser.py", line 145, in capture_cluster_args return func(self, cluster_args=cluster_args, **kwargs) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 258, in regression Feature(run=load("window_functions.tests.feature", "feature"), flags=TE) File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/feature.py", line 82, in feature Feature(run=load("window_functions.tests.misc", "feature"), flags=TE) File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/misc.py", line 466, in feature Scenario(run=scenario, flags=TE) File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/misc.py", line 56, in window_functions_in_select_expression execute_query( File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/common.py", line 162, 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 = 'cntsum\n22\n22\n87\n92\n136\n24\n24\n82\n92\n51' assert r.output.strip() == expected, error() ^ is 'cntsum\n22\n22\n87\n92\n136\n24\n24\n82\n92\n51' assert r.output.strip() == expected, error() ^ is = assert r.output.strip() == expected, error() ^ is = 'cntsum\n22\n22\n87\n92\n136\n24\n24\n82\n92\n51' assert r.output.strip() == expected, error() ^ is 'cntsum\n22\n22\n87\n24\n24\n82\n92\n51\n92\n136' assert r.output.strip() == expected, error() ^ is = False @@ -5,2 +4,0 @@ -92 -136 @@ -11,0 +10,2 @@ +92 +136 assert r.output.strip() == expected, error() ^ is False Where File '/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/common.py', line 162 in 'execute_query' 154\\| no_checks=no_checks, 155\\| ) 156\\| if no_checks: 157\\| return r 158\\| 159\\| if message is None: 160\\| if expected is not None: 161\\| with Then("I check output against expected"): 162\\|> assert r.output.strip() == expected, error() 163\\| else: 164\\| with Then("I check output against snapshot"): 165\\| with values() as that:

Test Name

Result

Message

/window functions/tests/non distributed/frame clause/range frame/between expr following and current row zero special case

XFail 125ms
known bug

AssertionError
Traceback (most recent call last):
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 262, in 
    regression()
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/argparser.py", line 145, in capture_cluster_args
    return func(self, cluster_args=cluster_args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 258, in regression
    Feature(run=load("window_functions.tests.feature", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/feature.py", line 75, in feature
    Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/frame_clause.py", line 68, in feature
    Feature(run=load("window_functions.tests.range_frame", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_frame.py", line 1745, in feature
    Scenario(run=scenario, flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_frame.py", line 1353, in between_expr_following_and_current_row_zero_special_case
    execute_query(
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/common.py", line 150, in execute_query
    r = current().context.node.query(
        ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 1079, 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 24.3.12):
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)) ORDER BY number FORMAT TabSeparatedWithNames
)

Assertion values
  assert False, error(r.output)
  ^ is False

Where
  File '/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py', line 1079 in 'query'

1071\|                  assert message in r.output, error(r.output)
1072\|  
1073\|          if not ignore_exception:
1074\|              if message is None or "Exception:" not in message:
1075\|                  with Then("check if output has exception") if steps else NullStep():
1076\|                      if "Exception:" in r.output:
1077\|                          if raise_on_exception:
1078\|                              raise QueryRuntimeException(r.output)
1079\|>                         assert False, error(r.output)
1080\|  
1081\|          return r
1082\|

/window functions/tests/non distributed/frame clause/range frame/between expr following and expr following without order by error

XFail 87ms
invalid error message

AssertionError
Traceback (most recent call last):
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 262, in 
    regression()
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/argparser.py", line 145, in capture_cluster_args
    return func(self, cluster_args=cluster_args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 258, in regression
    Feature(run=load("window_functions.tests.feature", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/feature.py", line 75, in feature
    Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/frame_clause.py", line 68, in feature
    Feature(run=load("window_functions.tests.range_frame", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_frame.py", line 1745, in feature
    Scenario(run=scenario, flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_frame.py", line 1217, in between_expr_following_and_expr_following_without_order_by_error
    self.context.node.query(
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 1071, 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 24.3.12):
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)) FORMAT TabSeparated
)

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 24.3.12):\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)) FORMAT TabSeparated\n)"
  assert message in r.output, error(r.output)
                 ^ is = False
  assert message in r.output, error(r.output)
  ^ is False

Where
  File '/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py', line 1071 in 'query'

1063\|                  assert r.exitcode == exitcode, error(r.output)
1064\|  
1065\|          if message is not None:
1066\|              with (
1067\|                  Then(f"output should contain message", description=message)
1068\|                  if steps
1069\|                  else NullStep()
1070\|              ):
1071\|>                 assert message in r.output, error(r.output)
1072\|  
1073\|          if not ignore_exception:
1074\|              if message is None or "Exception:" not in message:

/window functions/tests/non distributed/frame clause/range frame/between expr following and expr preceding with order by zero special case

XFail 74ms
known bug

AssertionError
Traceback (most recent call last):
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 262, in 
    regression()
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/argparser.py", line 145, in capture_cluster_args
    return func(self, cluster_args=cluster_args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 258, in regression
    Feature(run=load("window_functions.tests.feature", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/feature.py", line 75, in feature
    Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/frame_clause.py", line 68, in feature
    Feature(run=load("window_functions.tests.range_frame", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_frame.py", line 1745, in feature
    Scenario(run=scenario, flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_frame.py", line 1422, in between_expr_following_and_expr_preceding_with_order_by_zero_special_case
    execute_query(
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/common.py", line 150, in execute_query
    r = current().context.node.query(
        ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 1079, 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 24.3.12):
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)) ORDER BY number FORMAT TabSeparatedWithNames
)

Assertion values
  assert False, error(r.output)
  ^ is False

Where
  File '/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py', line 1079 in 'query'

1071\|                  assert message in r.output, error(r.output)
1072\|  
1073\|          if not ignore_exception:
1074\|              if message is None or "Exception:" not in message:
1075\|                  with Then("check if output has exception") if steps else NullStep():
1076\|                      if "Exception:" in r.output:
1077\|                          if raise_on_exception:
1078\|                              raise QueryRuntimeException(r.output)
1079\|>                         assert False, error(r.output)
1080\|  
1081\|          return r
1082\|

/window functions/tests/non distributed/frame clause/range frame/between expr following and expr preceding without order by error

XFail 86ms
invalid error message

AssertionError
Traceback (most recent call last):
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 262, in 
    regression()
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/argparser.py", line 145, in capture_cluster_args
    return func(self, cluster_args=cluster_args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 258, in regression
    Feature(run=load("window_functions.tests.feature", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/feature.py", line 75, in feature
    Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/frame_clause.py", line 68, in feature
    Feature(run=load("window_functions.tests.range_frame", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_frame.py", line 1745, in feature
    Scenario(run=scenario, flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_frame.py", line 1234, in between_expr_following_and_expr_preceding_without_order_by_error
    self.context.node.query(
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 1071, 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 24.3.12):
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)) FORMAT TabSeparated
)

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 24.3.12):\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)) FORMAT TabSeparated\n)"
  assert message in r.output, error(r.output)
                 ^ is = False
  assert message in r.output, error(r.output)
  ^ is False

Where
  File '/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py', line 1071 in 'query'

1063\|                  assert r.exitcode == exitcode, error(r.output)
1064\|  
1065\|          if message is not None:
1066\|              with (
1067\|                  Then(f"output should contain message", description=message)
1068\|                  if steps
1069\|                  else NullStep()
1070\|              ):
1071\|>                 assert message in r.output, error(r.output)
1072\|  
1073\|          if not ignore_exception:
1074\|              if message is None or "Exception:" not in message:

/window functions/tests/non distributed/frame clause/range frame/order by decimal

XFail 101ms
Exception: The RANGE OFFSET frame for 'DB::ColumnDecimal >' ORDER BY column is not implemented

AssertionError
Traceback (most recent call last):
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 262, in 
    regression()
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/argparser.py", line 145, in capture_cluster_args
    return func(self, cluster_args=cluster_args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 258, in regression
    Feature(run=load("window_functions.tests.feature", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/feature.py", line 75, in feature
    Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/frame_clause.py", line 68, in feature
    Feature(run=load("window_functions.tests.range_frame", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_frame.py", line 1745, in feature
    Scenario(run=scenario, flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_frame.py", line 1658, in order_by_decimal
    execute_query(
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/common.py", line 150, in execute_query
    r = current().context.node.query(
        ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 1079, 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 24.3.12):
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)
        ORDER BY id
         FORMAT TabSeparatedWithNames
)

Assertion values
  assert False, error(r.output)
  ^ is False

Where
  File '/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py', line 1079 in 'query'

1071\|                  assert message in r.output, error(r.output)
1072\|  
1073\|          if not ignore_exception:
1074\|              if message is None or "Exception:" not in message:
1075\|                  with Then("check if output has exception") if steps else NullStep():
1076\|                      if "Exception:" in r.output:
1077\|                          if raise_on_exception:
1078\|                              raise QueryRuntimeException(r.output)
1079\|>                         assert False, error(r.output)
1080\|  
1081\|          return r
1082\|

/window functions/tests/non distributed/frame clause/range frame/with nulls

XFail 109ms
DB::Exception: The RANGE OFFSET frame for 'DB::ColumnNullable' ORDER BY column is not implemented

AssertionError
Traceback (most recent call last):
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 262, in 
    regression()
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/argparser.py", line 145, in capture_cluster_args
    return func(self, cluster_args=cluster_args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 258, in regression
    Feature(run=load("window_functions.tests.feature", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/feature.py", line 75, in feature
    Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/frame_clause.py", line 68, in feature
    Feature(run=load("window_functions.tests.range_frame", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_frame.py", line 1745, in feature
    Scenario(run=scenario, flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_frame.py", line 1719, in with_nulls
    execute_query(
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/common.py", line 162, 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 = 'x\ty\tfirst_value\tlast_value\n1\t1\t1\t3\n2\t2\t1\t4\n3\t3\t1\t5\n4\t4\t2\t5\n5\t5\t3\t5\n\\N\t42\t42\t43\n\\N\t43\t42\t43'
  assert r.output.strip() == expected, error()
         ^ is 'x\ty\tfirst_value\tlast_value\n1\t1\t1\t3\n2\t2\t1\t4\n3\t3\t1\t5\n4\t4\t2\t5\n5\t5\t3\t5\n\\N\t42\t42\t43\n\\N\t43\t42\t43'
  assert r.output.strip() == expected, error()
         ^ is = 
  assert r.output.strip() == expected, error()
         ^ is = 'x\ty\tfirst_value\tlast_value\n1\t1\t1\t3\n2\t2\t1\t4\n3\t3\t1\t5\n4\t4\t2\t5\n5\t5\t3\t5\n\\N\t42\t42\t43\n\\N\t43\t42\t43'
  assert r.output.strip() == expected, error()
                             ^ is 'x\ty\tfirst_value\tlast_value\n\\N\t42\t42\t43\n\\N\t43\t42\t43\n1\t1\t1\t3\n2\t2\t1\t4\n3\t3\t1\t5\n4\t4\t2\t5\n5\t5\t3\t5'
  assert r.output.strip() == expected, error()
                          ^ is = False
    @@ -1,0 +2,2 @@
    +\N 42  42  43
    +\N 43  42  43
    @@ -7,2 +8,0 @@
    -\N 42  42  43
    -\N 43  42  43
  assert r.output.strip() == expected, error()
  ^ is False

Where
  File '/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/common.py', line 162 in 'execute_query'

154\|              no_checks=no_checks,
155\|          )
156\|          if no_checks:
157\|              return r
158\|  
159\|      if message is None:
160\|          if expected is not None:
161\|              with Then("I check output against expected"):
162\|>                 assert r.output.strip() == expected, error()
163\|          else:
164\|              with Then("I check output against snapshot"):
165\|                  with values() as that:

/window functions/tests/non distributed/frame clause/range overflow/negative overflow with Int16

XFail 102ms
exception on conversion

AssertionError
Traceback (most recent call last):
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 262, in 
    regression()
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/argparser.py", line 145, in capture_cluster_args
    return func(self, cluster_args=cluster_args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 258, in regression
    Feature(run=load("window_functions.tests.feature", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/feature.py", line 75, in feature
    Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/frame_clause.py", line 69, in feature
    Feature(run=load("window_functions.tests.range_overflow", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_overflow.py", line 145, in feature
    Scenario(run=scenario, flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_overflow.py", line 42, in negative_overflow_with_Int16
    execute_query(
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/common.py", line 150, in execute_query
    r = current().context.node.query(
        ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 1079, 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 24.3.12):
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)) order by x
         FORMAT TabSeparatedWithNames
)

Assertion values
  assert False, error(r.output)
  ^ is False

Where
  File '/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py', line 1079 in 'query'

1071\|                  assert message in r.output, error(r.output)
1072\|  
1073\|          if not ignore_exception:
1074\|              if message is None or "Exception:" not in message:
1075\|                  with Then("check if output has exception") if steps else NullStep():
1076\|                      if "Exception:" in r.output:
1077\|                          if raise_on_exception:
1078\|                              raise QueryRuntimeException(r.output)
1079\|>                         assert False, error(r.output)
1080\|  
1081\|          return r
1082\|

/window functions/tests/non distributed/frame clause/range overflow/positive overflow with Int16

XFail 85ms
exception on conversion

AssertionError
Traceback (most recent call last):
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 262, in 
    regression()
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/argparser.py", line 145, in capture_cluster_args
    return func(self, cluster_args=cluster_args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 258, in regression
    Feature(run=load("window_functions.tests.feature", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/feature.py", line 75, in feature
    Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/frame_clause.py", line 69, in feature
    Feature(run=load("window_functions.tests.range_overflow", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_overflow.py", line 145, in feature
    Scenario(run=scenario, flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_overflow.py", line 20, in positive_overflow_with_Int16
    execute_query(
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/common.py", line 150, in execute_query
    r = current().context.node.query(
        ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 1079, 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 24.3.12):
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) order by x
         FORMAT TabSeparatedWithNames
)

Assertion values
  assert False, error(r.output)
  ^ is False

Where
  File '/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py', line 1079 in 'query'

1071\|                  assert message in r.output, error(r.output)
1072\|  
1073\|          if not ignore_exception:
1074\|              if message is None or "Exception:" not in message:
1075\|                  with Then("check if output has exception") if steps else NullStep():
1076\|                      if "Exception:" in r.output:
1077\|                          if raise_on_exception:
1078\|                              raise QueryRuntimeException(r.output)
1079\|>                         assert False, error(r.output)
1080\|  
1081\|          return r
1082\|

/window functions/tests/non distributed/frame clause/range errors/error negative following offset

XFail 58ms
https://github.com/ClickHouse/ClickHouse/issues/22442

AssertionError
Traceback (most recent call last):
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 262, in 
    regression()
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/argparser.py", line 145, in capture_cluster_args
    return func(self, cluster_args=cluster_args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 258, in regression
    Feature(run=load("window_functions.tests.feature", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/feature.py", line 75, in feature
    Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/frame_clause.py", line 71, in feature
    Feature(run=load("window_functions.tests.range_errors", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_errors.py", line 114, in feature
    Scenario(run=scenario, flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/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 "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 1071, 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 24.3.12):
Code: 36. DB::Exception: Received from localhost:9000. DB::Exception: Frame end offset for 'RANGE' frame must be a nonnegative 32-bit integer, '-2' of type 'Int64' 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 FORMAT TabSeparated
)

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 24.3.12):\nCode: 36. DB::Exception: Received from localhost:9000. DB::Exception: Frame end offset for 'RANGE' frame must be a nonnegative 32-bit integer, '-2' of type 'Int64' 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 FORMAT TabSeparated\n)"
  assert message in r.output, error(r.output)
                 ^ is = False
  assert message in r.output, error(r.output)
  ^ is False

Where
  File '/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py', line 1071 in 'query'

1063\|                  assert r.exitcode == exitcode, error(r.output)
1064\|  
1065\|          if message is not None:
1066\|              with (
1067\|                  Then(f"output should contain message", description=message)
1068\|                  if steps
1069\|                  else NullStep()
1070\|              ):
1071\|>                 assert message in r.output, error(r.output)
1072\|  
1073\|          if not ignore_exception:
1074\|              if message is None or "Exception:" not in message:

/window functions/tests/non distributed/frame clause/range errors/error negative preceding offset

XFail 96ms
https://github.com/ClickHouse/ClickHouse/issues/22442

AssertionError
Traceback (most recent call last):
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 262, in 
    regression()
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/argparser.py", line 145, in capture_cluster_args
    return func(self, cluster_args=cluster_args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 258, in regression
    Feature(run=load("window_functions.tests.feature", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/feature.py", line 75, in feature
    Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/frame_clause.py", line 71, in feature
    Feature(run=load("window_functions.tests.range_errors", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_errors.py", line 114, in feature
    Scenario(run=scenario, flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/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 "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 1071, 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 24.3.12):
Code: 36. DB::Exception: Received from localhost:9000. DB::Exception: Frame start offset for 'RANGE' frame must be a nonnegative 32-bit integer, '-1' of type 'Int64' 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 FORMAT TabSeparated
)

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 24.3.12):\nCode: 36. DB::Exception: Received from localhost:9000. DB::Exception: Frame start offset for 'RANGE' frame must be a nonnegative 32-bit integer, '-1' of type 'Int64' 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 FORMAT TabSeparated\n)"
  assert message in r.output, error(r.output)
                 ^ is = False
  assert message in r.output, error(r.output)
  ^ is False

Where
  File '/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py', line 1071 in 'query'

1063\|                  assert r.exitcode == exitcode, error(r.output)
1064\|  
1065\|          if message is not None:
1066\|              with (
1067\|                  Then(f"output should contain message", description=message)
1068\|                  if steps
1069\|                  else NullStep()
1070\|              ):
1071\|>                 assert message in r.output, error(r.output)
1072\|  
1073\|          if not ignore_exception:
1074\|              if message is None or "Exception:" not in message:

/window functions/tests/non distributed/misc/subquery expr preceding

XFail 70ms
subquery is not supported as offset

AssertionError
Traceback (most recent call last):
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 262, in 
    regression()
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/argparser.py", line 145, in capture_cluster_args
    return func(self, cluster_args=cluster_args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 258, in regression
    Feature(run=load("window_functions.tests.feature", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/feature.py", line 82, in feature
    Feature(run=load("window_functions.tests.misc", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/misc.py", line 466, in feature
    Scenario(run=scenario, flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/misc.py", line 27, in subquery_expr_preceding
    execute_query(
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/common.py", line 162, 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\n0\t0\n1\t1\n3\t2\n5\t3\n7\t4\n9\t5\n11\t6\n13\t7\n15\t8\n17\t9'
  assert r.output.strip() == expected, error()
         ^ is 'sum\tunique1\n0\t0\n1\t1\n3\t2\n5\t3\n7\t4\n9\t5\n11\t6\n13\t7\n15\t8\n17\t9'
  assert r.output.strip() == expected, error()
         ^ is = 
  assert r.output.strip() == expected, error()
         ^ is = 'sum\tunique1\n0\t0\n1\t1\n3\t2\n5\t3\n7\t4\n9\t5\n11\t6\n13\t7\n15\t8\n17\t9'
  assert r.output.strip() == expected, error()
                             ^ is 'sum\tunique1\n0\t0\n1\t1\n3\t2\n5\t3Fmu\n7\t4\n9\t5\n11\t6\n13\t7\n15\t8\n17\t9'
  assert r.output.strip() == expected, error()
                          ^ is = False
    @@ -5 +5 @@
    -5  3
    +5  3Fmu
  assert r.output.strip() == expected, error()
  ^ is False

Where
  File '/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/common.py', line 162 in 'execute_query'

154\|              no_checks=no_checks,
155\|          )
156\|          if no_checks:
157\|              return r
158\|  
159\|      if message is None:
160\|          if expected is not None:
161\|              with Then("I check output against expected"):
162\|>                 assert r.output.strip() == expected, error()
163\|          else:
164\|              with Then("I check output against snapshot"):
165\|                  with values() as that:

/window functions/tests/distributed/frame clause/range frame/between expr following and current row zero special case

XFail 94ms
known bug

AssertionError
Traceback (most recent call last):
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 262, in 
    regression()
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/argparser.py", line 145, in capture_cluster_args
    return func(self, cluster_args=cluster_args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 258, in regression
    Feature(run=load("window_functions.tests.feature", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/feature.py", line 75, in feature
    Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/frame_clause.py", line 68, in feature
    Feature(run=load("window_functions.tests.range_frame", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_frame.py", line 1745, in feature
    Scenario(run=scenario, flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_frame.py", line 1353, in between_expr_following_and_current_row_zero_special_case
    execute_query(
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/common.py", line 150, in execute_query
    r = current().context.node.query(
        ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 1079, 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 24.3.12):
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)) ORDER BY number FORMAT TabSeparatedWithNames
)

Assertion values
  assert False, error(r.output)
  ^ is False

Where
  File '/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py', line 1079 in 'query'

1071\|                  assert message in r.output, error(r.output)
1072\|  
1073\|          if not ignore_exception:
1074\|              if message is None or "Exception:" not in message:
1075\|                  with Then("check if output has exception") if steps else NullStep():
1076\|                      if "Exception:" in r.output:
1077\|                          if raise_on_exception:
1078\|                              raise QueryRuntimeException(r.output)
1079\|>                         assert False, error(r.output)
1080\|  
1081\|          return r
1082\|

/window functions/tests/distributed/frame clause/range frame/between expr following and expr following without order by error

XFail 82ms
invalid error message

AssertionError
Traceback (most recent call last):
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 262, in 
    regression()
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/argparser.py", line 145, in capture_cluster_args
    return func(self, cluster_args=cluster_args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 258, in regression
    Feature(run=load("window_functions.tests.feature", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/feature.py", line 75, in feature
    Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/frame_clause.py", line 68, in feature
    Feature(run=load("window_functions.tests.range_frame", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_frame.py", line 1745, in feature
    Scenario(run=scenario, flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_frame.py", line 1217, in between_expr_following_and_expr_following_without_order_by_error
    self.context.node.query(
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 1071, 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 24.3.12):
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)) FORMAT TabSeparated
)

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 24.3.12):\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)) FORMAT TabSeparated\n)"
  assert message in r.output, error(r.output)
                 ^ is = False
  assert message in r.output, error(r.output)
  ^ is False

Where
  File '/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py', line 1071 in 'query'

1063\|                  assert r.exitcode == exitcode, error(r.output)
1064\|  
1065\|          if message is not None:
1066\|              with (
1067\|                  Then(f"output should contain message", description=message)
1068\|                  if steps
1069\|                  else NullStep()
1070\|              ):
1071\|>                 assert message in r.output, error(r.output)
1072\|  
1073\|          if not ignore_exception:
1074\|              if message is None or "Exception:" not in message:

/window functions/tests/distributed/frame clause/range frame/between expr following and expr preceding with order by zero special case

XFail 73ms
known bug

AssertionError
Traceback (most recent call last):
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 262, in 
    regression()
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/argparser.py", line 145, in capture_cluster_args
    return func(self, cluster_args=cluster_args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 258, in regression
    Feature(run=load("window_functions.tests.feature", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/feature.py", line 75, in feature
    Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/frame_clause.py", line 68, in feature
    Feature(run=load("window_functions.tests.range_frame", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_frame.py", line 1745, in feature
    Scenario(run=scenario, flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_frame.py", line 1422, in between_expr_following_and_expr_preceding_with_order_by_zero_special_case
    execute_query(
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/common.py", line 150, in execute_query
    r = current().context.node.query(
        ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 1079, 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 24.3.12):
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)) ORDER BY number FORMAT TabSeparatedWithNames
)

Assertion values
  assert False, error(r.output)
  ^ is False

Where
  File '/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py', line 1079 in 'query'

1071\|                  assert message in r.output, error(r.output)
1072\|  
1073\|          if not ignore_exception:
1074\|              if message is None or "Exception:" not in message:
1075\|                  with Then("check if output has exception") if steps else NullStep():
1076\|                      if "Exception:" in r.output:
1077\|                          if raise_on_exception:
1078\|                              raise QueryRuntimeException(r.output)
1079\|>                         assert False, error(r.output)
1080\|  
1081\|          return r
1082\|

/window functions/tests/distributed/frame clause/range frame/between expr following and expr preceding without order by error

XFail 80ms
invalid error message

AssertionError
Traceback (most recent call last):
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 262, in 
    regression()
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/argparser.py", line 145, in capture_cluster_args
    return func(self, cluster_args=cluster_args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 258, in regression
    Feature(run=load("window_functions.tests.feature", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/feature.py", line 75, in feature
    Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/frame_clause.py", line 68, in feature
    Feature(run=load("window_functions.tests.range_frame", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_frame.py", line 1745, in feature
    Scenario(run=scenario, flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_frame.py", line 1234, in between_expr_following_and_expr_preceding_without_order_by_error
    self.context.node.query(
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 1071, 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 24.3.12):
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)) FORMAT TabSeparated
)

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 24.3.12):\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)) FORMAT TabSeparated\n)"
  assert message in r.output, error(r.output)
                 ^ is = False
  assert message in r.output, error(r.output)
  ^ is False

Where
  File '/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py', line 1071 in 'query'

1063\|                  assert r.exitcode == exitcode, error(r.output)
1064\|  
1065\|          if message is not None:
1066\|              with (
1067\|                  Then(f"output should contain message", description=message)
1068\|                  if steps
1069\|                  else NullStep()
1070\|              ):
1071\|>                 assert message in r.output, error(r.output)
1072\|  
1073\|          if not ignore_exception:
1074\|              if message is None or "Exception:" not in message:

/window functions/tests/distributed/frame clause/range frame/order by decimal

XFail 104ms
Exception: The RANGE OFFSET frame for 'DB::ColumnDecimal >' ORDER BY column is not implemented

AssertionError
Traceback (most recent call last):
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 262, in 
    regression()
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/argparser.py", line 145, in capture_cluster_args
    return func(self, cluster_args=cluster_args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 258, in regression
    Feature(run=load("window_functions.tests.feature", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/feature.py", line 75, in feature
    Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/frame_clause.py", line 68, in feature
    Feature(run=load("window_functions.tests.range_frame", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_frame.py", line 1745, in feature
    Scenario(run=scenario, flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_frame.py", line 1658, in order_by_decimal
    execute_query(
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/common.py", line 150, in execute_query
    r = current().context.node.query(
        ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 1079, 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 24.3.12):
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)
        ORDER BY id
         FORMAT TabSeparatedWithNames
)

Assertion values
  assert False, error(r.output)
  ^ is False

Where
  File '/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py', line 1079 in 'query'

1071\|                  assert message in r.output, error(r.output)
1072\|  
1073\|          if not ignore_exception:
1074\|              if message is None or "Exception:" not in message:
1075\|                  with Then("check if output has exception") if steps else NullStep():
1076\|                      if "Exception:" in r.output:
1077\|                          if raise_on_exception:
1078\|                              raise QueryRuntimeException(r.output)
1079\|>                         assert False, error(r.output)
1080\|  
1081\|          return r
1082\|

/window functions/tests/distributed/frame clause/range frame/with nulls

XFail 129ms
DB::Exception: The RANGE OFFSET frame for 'DB::ColumnNullable' ORDER BY column is not implemented

AssertionError
Traceback (most recent call last):
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 262, in 
    regression()
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/argparser.py", line 145, in capture_cluster_args
    return func(self, cluster_args=cluster_args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 258, in regression
    Feature(run=load("window_functions.tests.feature", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/feature.py", line 75, in feature
    Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/frame_clause.py", line 68, in feature
    Feature(run=load("window_functions.tests.range_frame", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_frame.py", line 1745, in feature
    Scenario(run=scenario, flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_frame.py", line 1719, in with_nulls
    execute_query(
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/common.py", line 162, 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 = 'x\ty\tfirst_value\tlast_value\n1\t1\t1\t3\n2\t2\t1\t4\n3\t3\t1\t5\n4\t4\t2\t5\n5\t5\t3\t5\n\\N\t42\t42\t43\n\\N\t43\t42\t43'
  assert r.output.strip() == expected, error()
         ^ is 'x\ty\tfirst_value\tlast_value\n1\t1\t1\t3\n2\t2\t1\t4\n3\t3\t1\t5\n4\t4\t2\t5\n5\t5\t3\t5\n\\N\t42\t42\t43\n\\N\t43\t42\t43'
  assert r.output.strip() == expected, error()
         ^ is = 
  assert r.output.strip() == expected, error()
         ^ is = 'x\ty\tfirst_value\tlast_value\n1\t1\t1\t3\n2\t2\t1\t4\n3\t3\t1\t5\n4\t4\t2\t5\n5\t5\t3\t5\n\\N\t42\t42\t43\n\\N\t43\t42\t43'
  assert r.output.strip() == expected, error()
                             ^ is 'x\ty\tfirst_value\tlast_value\n\\N\t42\t42\t43\n\\N\t43\t42\t43\n1\t1\t1\t3\n2\t2\t1\t4\n3\t3\t1\t5\n4\t4\t2\t5\n5\t5\t3\t5'
  assert r.output.strip() == expected, error()
                          ^ is = False
    @@ -1,0 +2,2 @@
    +\N 42  42  43
    +\N 43  42  43
    @@ -7,2 +8,0 @@
    -\N 42  42  43
    -\N 43  42  43
  assert r.output.strip() == expected, error()
  ^ is False

Where
  File '/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/common.py', line 162 in 'execute_query'

154\|              no_checks=no_checks,
155\|          )
156\|          if no_checks:
157\|              return r
158\|  
159\|      if message is None:
160\|          if expected is not None:
161\|              with Then("I check output against expected"):
162\|>                 assert r.output.strip() == expected, error()
163\|          else:
164\|              with Then("I check output against snapshot"):
165\|                  with values() as that:

/window functions/tests/distributed/frame clause/range overflow/negative overflow with Int16

XFail 84ms
exception on conversion

AssertionError
Traceback (most recent call last):
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 262, in 
    regression()
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/argparser.py", line 145, in capture_cluster_args
    return func(self, cluster_args=cluster_args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 258, in regression
    Feature(run=load("window_functions.tests.feature", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/feature.py", line 75, in feature
    Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/frame_clause.py", line 69, in feature
    Feature(run=load("window_functions.tests.range_overflow", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_overflow.py", line 145, in feature
    Scenario(run=scenario, flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_overflow.py", line 42, in negative_overflow_with_Int16
    execute_query(
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/common.py", line 150, in execute_query
    r = current().context.node.query(
        ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 1079, 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 24.3.12):
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)) order by x
         FORMAT TabSeparatedWithNames
)

Assertion values
  assert False, error(r.output)
  ^ is False

Where
  File '/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py', line 1079 in 'query'

1071\|                  assert message in r.output, error(r.output)
1072\|  
1073\|          if not ignore_exception:
1074\|              if message is None or "Exception:" not in message:
1075\|                  with Then("check if output has exception") if steps else NullStep():
1076\|                      if "Exception:" in r.output:
1077\|                          if raise_on_exception:
1078\|                              raise QueryRuntimeException(r.output)
1079\|>                         assert False, error(r.output)
1080\|  
1081\|          return r
1082\|

/window functions/tests/distributed/frame clause/range overflow/positive overflow with Int16

XFail 87ms
exception on conversion

AssertionError
Traceback (most recent call last):
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 262, in 
    regression()
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/argparser.py", line 145, in capture_cluster_args
    return func(self, cluster_args=cluster_args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 258, in regression
    Feature(run=load("window_functions.tests.feature", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/feature.py", line 75, in feature
    Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/frame_clause.py", line 69, in feature
    Feature(run=load("window_functions.tests.range_overflow", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_overflow.py", line 145, in feature
    Scenario(run=scenario, flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_overflow.py", line 20, in positive_overflow_with_Int16
    execute_query(
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/common.py", line 150, in execute_query
    r = current().context.node.query(
        ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 1079, 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 24.3.12):
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) order by x
         FORMAT TabSeparatedWithNames
)

Assertion values
  assert False, error(r.output)
  ^ is False

Where
  File '/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py', line 1079 in 'query'

1071\|                  assert message in r.output, error(r.output)
1072\|  
1073\|          if not ignore_exception:
1074\|              if message is None or "Exception:" not in message:
1075\|                  with Then("check if output has exception") if steps else NullStep():
1076\|                      if "Exception:" in r.output:
1077\|                          if raise_on_exception:
1078\|                              raise QueryRuntimeException(r.output)
1079\|>                         assert False, error(r.output)
1080\|  
1081\|          return r
1082\|

/window functions/tests/distributed/frame clause/range datetime/datetime order by desc range between n preceding and n following

XFail 109ms
https://github.com/ClickHouse/ClickHouse/issues/23902

AssertionError
Traceback (most recent call last):
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 262, in 
    regression()
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/argparser.py", line 145, in capture_cluster_args
    return func(self, cluster_args=cluster_args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 258, in regression
    Feature(run=load("window_functions.tests.feature", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/feature.py", line 75, in feature
    Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/frame_clause.py", line 70, in feature
    Feature(run=load("window_functions.tests.range_datetime", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_datetime.py", line 264, in feature
    Scenario(run=scenario, flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_datetime.py", line 245, in datetime_order_by_desc_range_between_n_preceding_and_n_following
    execute_query(
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/common.py", line 162, 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 = 'id\tf_timestamp\tfirst_value\tlast_value\n10\t2008-10-19 10:23:54\t10\t9\n9\t2007-10-19 10:23:54\t10\t8\n6\t2004-10-19 10:23:54\t7\t5\n5\t2003-10-19 10:23:54\t6\t4\n4\t2002-10-19 10:23:54\t5\t3\n2\t2001-10-19 10:23:54\t4\t1\n3\t2001-10-19 10:23:54\t4\t1\n1\t2000-10-19 10:23:54\t2\t1\n7\t2005-10-19 10:23:54\t8\t6\n8\t2006-10-19 10:23:54\t9\t7'
  assert r.output.strip() == expected, error()
         ^ is 'id\tf_timestamp\tfirst_value\tlast_value\n10\t2008-10-19 10:23:54\t10\t9\n9\t2007-10-19 10:23:54\t10\t8\n6\t2004-10-19 10:23:54\t7\t5\n5\t2003-10-19 10:23:54\t6\t4\n4\t2002-10-19 10:23:54\t5\t3\n2\t2001-10-19 10:23:54\t4\t1\n3\t2001-10-19 10:23:54\t4\t1\n1\t2000-10-19 10:23:54\t2\t1\n7\t2005-10-19 10:23:54\t8\t6\n8\t2006-10-19 10:23:54\t9\t7'
  assert r.output.strip() == expected, error()
         ^ is = 
  assert r.output.strip() == expected, error()
         ^ is = 'id\tf_timestamp\tfirst_value\tlast_value\n10\t2008-10-19 10:23:54\t10\t9\n9\t2007-10-19 10:23:54\t10\t8\n6\t2004-10-19 10:23:54\t7\t5\n5\t2003-10-19 10:23:54\t6\t4\n4\t2002-10-19 10:23:54\t5\t3\n2\t2001-10-19 10:23:54\t4\t1\n3\t2001-10-19 10:23:54\t4\t1\n1\t2000-10-19 10:23:54\t2\t1\n7\t2005-10-19 10:23:54\t8\t6\n8\t2006-10-19 10:23:54\t9\t7'
  assert r.output.strip() == expected, error()
                             ^ is 'id\tf_timestamp\tfirst_value\tlast_value\n10\t2008-10-19 10:23:54\t10\t9\n9\t2007-10-19 10:23:54\t10\t8\n8\t2006-10-19 10:23:54\t9\t7\n7\t2005-10-19 10:23:54\t8\t6\n6\t2004-10-19 10:23:54\t7\t5\n5\t2003-10-19 10:23:54\t6\t4\n4\t2002-10-19 10:23:54\t5\t3\n2\t2001-10-19 10:23:54\t4\t1\n3\t2001-10-19 10:23:54\t4\t1\n1\t2000-10-19 10:23:54\t2\t1'
  assert r.output.strip() == expected, error()
                          ^ is = False
    @@ -3,0 +4,2 @@
    +8  2006-10-19 10:23:54 9   7
    +7  2005-10-19 10:23:54 8   6
    @@ -10,2 +11,0 @@
    -7  2005-10-19 10:23:54 8   6
    -8  2006-10-19 10:23:54 9   7
  assert r.output.strip() == expected, error()
  ^ is False

Where
  File '/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/common.py', line 162 in 'execute_query'

154\|              no_checks=no_checks,
155\|          )
156\|          if no_checks:
157\|              return r
158\|  
159\|      if message is None:
160\|          if expected is not None:
161\|              with Then("I check output against expected"):
162\|>                 assert r.output.strip() == expected, error()
163\|          else:
164\|              with Then("I check output against snapshot"):
165\|                  with values() as that:

/window functions/tests/distributed/frame clause/range errors/error negative following offset

XFail 66ms
https://github.com/ClickHouse/ClickHouse/issues/22442

AssertionError
Traceback (most recent call last):
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 262, in 
    regression()
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/argparser.py", line 145, in capture_cluster_args
    return func(self, cluster_args=cluster_args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 258, in regression
    Feature(run=load("window_functions.tests.feature", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/feature.py", line 75, in feature
    Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/frame_clause.py", line 71, in feature
    Feature(run=load("window_functions.tests.range_errors", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_errors.py", line 114, in feature
    Scenario(run=scenario, flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/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 "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 1071, 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 24.3.12):
Code: 36. DB::Exception: Received from localhost:9000. DB::Exception: Frame end offset for 'RANGE' frame must be a nonnegative 32-bit integer, '-2' of type 'Int64' 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 FORMAT TabSeparated
)

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 24.3.12):\nCode: 36. DB::Exception: Received from localhost:9000. DB::Exception: Frame end offset for 'RANGE' frame must be a nonnegative 32-bit integer, '-2' of type 'Int64' 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 FORMAT TabSeparated\n)"
  assert message in r.output, error(r.output)
                 ^ is = False
  assert message in r.output, error(r.output)
  ^ is False

Where
  File '/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py', line 1071 in 'query'

1063\|                  assert r.exitcode == exitcode, error(r.output)
1064\|  
1065\|          if message is not None:
1066\|              with (
1067\|                  Then(f"output should contain message", description=message)
1068\|                  if steps
1069\|                  else NullStep()
1070\|              ):
1071\|>                 assert message in r.output, error(r.output)
1072\|  
1073\|          if not ignore_exception:
1074\|              if message is None or "Exception:" not in message:

/window functions/tests/distributed/frame clause/range errors/error negative preceding offset

XFail 96ms
https://github.com/ClickHouse/ClickHouse/issues/22442

AssertionError
Traceback (most recent call last):
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 262, in 
    regression()
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/argparser.py", line 145, in capture_cluster_args
    return func(self, cluster_args=cluster_args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 258, in regression
    Feature(run=load("window_functions.tests.feature", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/feature.py", line 75, in feature
    Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/frame_clause.py", line 71, in feature
    Feature(run=load("window_functions.tests.range_errors", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_errors.py", line 114, in feature
    Scenario(run=scenario, flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/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 "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 1071, 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 24.3.12):
Code: 36. DB::Exception: Received from localhost:9000. DB::Exception: Frame start offset for 'RANGE' frame must be a nonnegative 32-bit integer, '-1' of type 'Int64' 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 FORMAT TabSeparated
)

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 24.3.12):\nCode: 36. DB::Exception: Received from localhost:9000. DB::Exception: Frame start offset for 'RANGE' frame must be a nonnegative 32-bit integer, '-1' of type 'Int64' 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 FORMAT TabSeparated\n)"
  assert message in r.output, error(r.output)
                 ^ is = False
  assert message in r.output, error(r.output)
  ^ is False

Where
  File '/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py', line 1071 in 'query'

1063\|                  assert r.exitcode == exitcode, error(r.output)
1064\|  
1065\|          if message is not None:
1066\|              with (
1067\|                  Then(f"output should contain message", description=message)
1068\|                  if steps
1069\|                  else NullStep()
1070\|              ):
1071\|>                 assert message in r.output, error(r.output)
1072\|  
1073\|          if not ignore_exception:
1074\|              if message is None or "Exception:" not in message:

/window functions/tests/distributed/misc/subquery expr preceding

XFail 137ms
subquery is not supported as offset

AssertionError
Traceback (most recent call last):
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 262, in 
    regression()
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/argparser.py", line 145, in capture_cluster_args
    return func(self, cluster_args=cluster_args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 258, in regression
    Feature(run=load("window_functions.tests.feature", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/feature.py", line 82, in feature
    Feature(run=load("window_functions.tests.misc", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/misc.py", line 466, in feature
    Scenario(run=scenario, flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/misc.py", line 27, in subquery_expr_preceding
    execute_query(
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/common.py", line 162, 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\n0\t0\n1\t1\n3\t2\n5\t3\n7\t4\n9\t5\n11\t6\n15\t8\n17\t9\n13\t7'
  assert r.output.strip() == expected, error()
         ^ is 'sum\tunique1\n0\t0\n1\t1\n3\t2\n5\t3\n7\t4\n9\t5\n11\t6\n15\t8\n17\t9\n13\t7'
  assert r.output.strip() == expected, error()
         ^ is = 
  assert r.output.strip() == expected, error()
         ^ is = 'sum\tunique1\n0\t0\n1\t1\n3\t2\n5\t3\n7\t4\n9\t5\n11\t6\n15\t8\n17\t9\n13\t7'
  assert r.output.strip() == expected, error()
                             ^ is 'sum\tunique1\n0\t0\n1\t1\n3\t2\n5\t3Fmu\n7\t4\n9\t5\n11\t6\n13\t7\n15\t8\n17\t9'
  assert r.output.strip() == expected, error()
                          ^ is = False
    @@ -5 +5 @@
    -5  3
    +5  3Fmu
    @@ -8,0 +9 @@
    +13 7
    @@ -11 +11,0 @@
    -13 7
  assert r.output.strip() == expected, error()
  ^ is False

Where
  File '/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/common.py', line 162 in 'execute_query'

154\|              no_checks=no_checks,
155\|          )
156\|          if no_checks:
157\|              return r
158\|  
159\|      if message is None:
160\|          if expected is not None:
161\|              with Then("I check output against expected"):
162\|>                 assert r.output.strip() == expected, error()
163\|          else:
164\|              with Then("I check output against snapshot"):
165\|                  with values() as that:

/window functions/tests/distributed/misc/window functions in select expression

XFail 140ms
not supported, https://github.com/ClickHouse/ClickHouse/issues/19857

AssertionError
Traceback (most recent call last):
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 262, in 
    regression()
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/argparser.py", line 145, in capture_cluster_args
    return func(self, cluster_args=cluster_args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 258, in regression
    Feature(run=load("window_functions.tests.feature", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/feature.py", line 82, in feature
    Feature(run=load("window_functions.tests.misc", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/misc.py", line 466, in feature
    Scenario(run=scenario, flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/misc.py", line 56, in window_functions_in_select_expression
    execute_query(
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/common.py", line 162, 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 = 'cntsum\n22\n22\n87\n92\n136\n24\n24\n82\n92\n51'
  assert r.output.strip() == expected, error()
         ^ is 'cntsum\n22\n22\n87\n92\n136\n24\n24\n82\n92\n51'
  assert r.output.strip() == expected, error()
         ^ is = 
  assert r.output.strip() == expected, error()
         ^ is = 'cntsum\n22\n22\n87\n92\n136\n24\n24\n82\n92\n51'
  assert r.output.strip() == expected, error()
                             ^ is 'cntsum\n22\n22\n87\n24\n24\n82\n92\n51\n92\n136'
  assert r.output.strip() == expected, error()
                          ^ is = False
    @@ -5,2 +4,0 @@
    -92
    -136
    @@ -11,0 +10,2 @@
    +92
    +136
  assert r.output.strip() == expected, error()
  ^ is False

Where
  File '/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/common.py', line 162 in 'execute_query'

154\|              no_checks=no_checks,
155\|          )
156\|          if no_checks:
157\|              return r
158\|  
159\|      if message is None:
160\|          if expected is not None:
161\|              with Then("I check output against expected"):
162\|>                 assert r.output.strip() == expected, error()
163\|          else:
164\|              with Then("I check output against snapshot"):
165\|                  with values() as that:

Date	Nov 04, 2024 21:59
Duration	6m 49s
Framework	TestFlows 2.0.240705.1133204

project	Altinity/ClickHouse
project.id	159717931
package	https://s3.amazonaws.com/altinity-build-artifacts/24.3/5b67ba5a4febfa774d6373929d551c6a697d7d92/package_release/clickhouse-common-static_24.3.12.76.altinitystable_amd64.deb
version	24.3.12.76.altinitystable
user.name	Enmk
repository	https://github.com/Altinity/clickhouse-regression
commit.hash	c5e1513a2214ee33696c29717935e0a94989ac2a
job.id	11672696143
job.url	https://github.com/Altinity/ClickHouse/actions/runs/11672696143
arch	x86_64
local	True
clickhouse_version	None
clickhouse_binary_path	https://s3.amazonaws.com/altinity-build-artifacts/24.3/5b67ba5a4febfa774d6373929d551c6a697d7d92/package_release/clickhouse-common-static_24.3.12.76.altinitystable_amd64.deb
keeper_binary_path	None
zookeeper_version	None
use_keeper	False
stress	False
collect_service_logs	True
thread_fuzzer	False
with_analyzer	False
reuse_env	False

Window Functions Test Run Report

Artifacts

Attributes

Summary

Statistics

Known Fails

Results