	Units	Skip	OK	Fail	Error	XFail
Modules	1		1
Features	39		39
Scenarios	458	1	434			23
Checks	256		252			4
Examples	1418		1394			24
Steps	7664		7577	71	6	10

Test Name	Result	Message
/window functions/tests/non distributed/frame clause/range frame/between expr following and current row zero special case	XFail 110ms known bug	AssertionError Traceback (most recent call last): File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 274, in regression() File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/argparser.py", line 171, in capture_cluster_args return func(self, cluster_args=cluster_args, **kwargs) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 270, 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 159, in execute_query r = current().context.node.query( ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 1188, 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.12.2): 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 1188 in 'query' 1180\\| assert message in r.output, error(r.output) 1181\\| 1182\\| if not ignore_exception: 1183\\| if message is None or "Exception:" not in message: 1184\\| with Then("check if output has exception") if steps else NullStep(): 1185\\| if "Exception:" in r.output: 1186\\| if raise_on_exception: 1187\\| raise QueryRuntimeException(r.output) 1188\\|> assert False, error(r.output) 1189\\| 1190\\| return r 1191\\|
/window functions/tests/non distributed/frame clause/range frame/between expr following and expr following without order by error	XFail 79ms invalid error message	AssertionError Traceback (most recent call last): File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 274, in regression() File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/argparser.py", line 171, in capture_cluster_args return func(self, cluster_args=cluster_args, **kwargs) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 270, 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 1180, 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.12.2): 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.12.2):\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 1180 in 'query' 1172\\| assert r.exitcode == exitcode, error(r.output) 1173\\| 1174\\| if message is not None: 1175\\| with ( 1176\\| Then(f"output should contain message", description=message) 1177\\| if steps 1178\\| else NullStep() 1179\\| ): 1180\\|> assert message in r.output, error(r.output) 1181\\| 1182\\| if not ignore_exception: 1183\\| 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 89ms known bug	AssertionError Traceback (most recent call last): File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 274, in regression() File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/argparser.py", line 171, in capture_cluster_args return func(self, cluster_args=cluster_args, **kwargs) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 270, 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 159, in execute_query r = current().context.node.query( ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 1188, 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.12.2): 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 1188 in 'query' 1180\\| assert message in r.output, error(r.output) 1181\\| 1182\\| if not ignore_exception: 1183\\| if message is None or "Exception:" not in message: 1184\\| with Then("check if output has exception") if steps else NullStep(): 1185\\| if "Exception:" in r.output: 1186\\| if raise_on_exception: 1187\\| raise QueryRuntimeException(r.output) 1188\\|> assert False, error(r.output) 1189\\| 1190\\| return r 1191\\|
/window functions/tests/non distributed/frame clause/range frame/between expr following and expr preceding without order by error	XFail 74ms invalid error message	AssertionError Traceback (most recent call last): File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 274, in regression() File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/argparser.py", line 171, in capture_cluster_args return func(self, cluster_args=cluster_args, **kwargs) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 270, 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 1180, 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.12.2): 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.12.2):\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 1180 in 'query' 1172\\| assert r.exitcode == exitcode, error(r.output) 1173\\| 1174\\| if message is not None: 1175\\| with ( 1176\\| Then(f"output should contain message", description=message) 1177\\| if steps 1178\\| else NullStep() 1179\\| ): 1180\\|> assert message in r.output, error(r.output) 1181\\| 1182\\| if not ignore_exception: 1183\\| if message is None or "Exception:" not in message:
/window functions/tests/non distributed/frame clause/range frame/order by decimal	XFail 84ms 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 274, in regression() File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/argparser.py", line 171, in capture_cluster_args return func(self, cluster_args=cluster_args, **kwargs) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 270, 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 159, in execute_query r = current().context.node.query( ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 1188, 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.12.2): 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 1188 in 'query' 1180\\| assert message in r.output, error(r.output) 1181\\| 1182\\| if not ignore_exception: 1183\\| if message is None or "Exception:" not in message: 1184\\| with Then("check if output has exception") if steps else NullStep(): 1185\\| if "Exception:" in r.output: 1186\\| if raise_on_exception: 1187\\| raise QueryRuntimeException(r.output) 1188\\|> assert False, error(r.output) 1189\\| 1190\\| return r 1191\\|
/window functions/tests/non distributed/frame clause/range frame/with nulls	XFail 114ms 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 274, in regression() File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/argparser.py", line 171, in capture_cluster_args return func(self, cluster_args=cluster_args, **kwargs) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 270, 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 171, 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 171 in 'execute_query' 163\\| no_checks=no_checks, 164\\| ) 165\\| if no_checks: 166\\| return r 167\\| 168\\| if message is None: 169\\| if expected is not None: 170\\| with Then("I check output against expected"): 171\\|> assert r.output.strip() == expected, error() 172\\| else: 173\\| with Then("I check output against snapshot"): 174\\| with values() as that:
/window functions/tests/non distributed/frame clause/range overflow/negative 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 274, in regression() File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/argparser.py", line 171, in capture_cluster_args return func(self, cluster_args=cluster_args, **kwargs) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 270, 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 159, in execute_query r = current().context.node.query( ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 1188, 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.12.2): 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 1188 in 'query' 1180\\| assert message in r.output, error(r.output) 1181\\| 1182\\| if not ignore_exception: 1183\\| if message is None or "Exception:" not in message: 1184\\| with Then("check if output has exception") if steps else NullStep(): 1185\\| if "Exception:" in r.output: 1186\\| if raise_on_exception: 1187\\| raise QueryRuntimeException(r.output) 1188\\|> assert False, error(r.output) 1189\\| 1190\\| return r 1191\\|
/window functions/tests/non distributed/frame clause/range overflow/positive overflow with Int16	XFail 89ms exception on conversion	AssertionError Traceback (most recent call last): File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 274, in regression() File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/argparser.py", line 171, in capture_cluster_args return func(self, cluster_args=cluster_args, **kwargs) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 270, 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 159, in execute_query r = current().context.node.query( ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 1188, 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.12.2): 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 1188 in 'query' 1180\\| assert message in r.output, error(r.output) 1181\\| 1182\\| if not ignore_exception: 1183\\| if message is None or "Exception:" not in message: 1184\\| with Then("check if output has exception") if steps else NullStep(): 1185\\| if "Exception:" in r.output: 1186\\| if raise_on_exception: 1187\\| raise QueryRuntimeException(r.output) 1188\\|> assert False, error(r.output) 1189\\| 1190\\| return r 1191\\|
/window functions/tests/non distributed/frame clause/range errors/error negative following offset	XFail 74ms https://github.com/ClickHouse/ClickHouse/issues/22442	AssertionError Traceback (most recent call last): File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 274, in regression() File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/argparser.py", line 171, in capture_cluster_args return func(self, cluster_args=cluster_args, **kwargs) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 270, 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 1180, 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.12.2): 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.12.2):\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 1180 in 'query' 1172\\| assert r.exitcode == exitcode, error(r.output) 1173\\| 1174\\| if message is not None: 1175\\| with ( 1176\\| Then(f"output should contain message", description=message) 1177\\| if steps 1178\\| else NullStep() 1179\\| ): 1180\\|> assert message in r.output, error(r.output) 1181\\| 1182\\| if not ignore_exception: 1183\\| if message is None or "Exception:" not in message:
/window functions/tests/non distributed/frame clause/range errors/error negative preceding offset	XFail 78ms https://github.com/ClickHouse/ClickHouse/issues/22442	AssertionError Traceback (most recent call last): File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 274, in regression() File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/argparser.py", line 171, in capture_cluster_args return func(self, cluster_args=cluster_args, **kwargs) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 270, 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 1180, 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.12.2): 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.12.2):\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 1180 in 'query' 1172\\| assert r.exitcode == exitcode, error(r.output) 1173\\| 1174\\| if message is not None: 1175\\| with ( 1176\\| Then(f"output should contain message", description=message) 1177\\| if steps 1178\\| else NullStep() 1179\\| ): 1180\\|> assert message in r.output, error(r.output) 1181\\| 1182\\| if not ignore_exception: 1183\\| if message is None or "Exception:" not in message:
/window functions/tests/non distributed/misc/subquery expr preceding	XFail 86ms subquery is not supported as offset	AssertionError Traceback (most recent call last): File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 274, in regression() File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/argparser.py", line 171, in capture_cluster_args return func(self, cluster_args=cluster_args, **kwargs) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 270, 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 171, 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 171 in 'execute_query' 163\\| no_checks=no_checks, 164\\| ) 165\\| if no_checks: 166\\| return r 167\\| 168\\| if message is None: 169\\| if expected is not None: 170\\| with Then("I check output against expected"): 171\\|> assert r.output.strip() == expected, error() 172\\| else: 173\\| with Then("I check output against snapshot"): 174\\| with values() as that:
/window functions/tests/distributed/frame clause/range frame/between expr following and current row zero special case	XFail 71ms known bug	AssertionError Traceback (most recent call last): File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 274, in regression() File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/argparser.py", line 171, in capture_cluster_args return func(self, cluster_args=cluster_args, **kwargs) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 270, 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 159, in execute_query r = current().context.node.query( ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 1188, 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.12.2): 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 1188 in 'query' 1180\\| assert message in r.output, error(r.output) 1181\\| 1182\\| if not ignore_exception: 1183\\| if message is None or "Exception:" not in message: 1184\\| with Then("check if output has exception") if steps else NullStep(): 1185\\| if "Exception:" in r.output: 1186\\| if raise_on_exception: 1187\\| raise QueryRuntimeException(r.output) 1188\\|> assert False, error(r.output) 1189\\| 1190\\| return r 1191\\|
/window functions/tests/distributed/frame clause/range frame/between expr following and expr following without order by error	XFail 65ms invalid error message	AssertionError Traceback (most recent call last): File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 274, in regression() File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/argparser.py", line 171, in capture_cluster_args return func(self, cluster_args=cluster_args, **kwargs) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 270, 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 1180, 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.12.2): 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.12.2):\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 1180 in 'query' 1172\\| assert r.exitcode == exitcode, error(r.output) 1173\\| 1174\\| if message is not None: 1175\\| with ( 1176\\| Then(f"output should contain message", description=message) 1177\\| if steps 1178\\| else NullStep() 1179\\| ): 1180\\|> assert message in r.output, error(r.output) 1181\\| 1182\\| if not ignore_exception: 1183\\| 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 67ms known bug	AssertionError Traceback (most recent call last): File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 274, in regression() File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/argparser.py", line 171, in capture_cluster_args return func(self, cluster_args=cluster_args, **kwargs) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 270, 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 159, in execute_query r = current().context.node.query( ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 1188, 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.12.2): 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 1188 in 'query' 1180\\| assert message in r.output, error(r.output) 1181\\| 1182\\| if not ignore_exception: 1183\\| if message is None or "Exception:" not in message: 1184\\| with Then("check if output has exception") if steps else NullStep(): 1185\\| if "Exception:" in r.output: 1186\\| if raise_on_exception: 1187\\| raise QueryRuntimeException(r.output) 1188\\|> assert False, error(r.output) 1189\\| 1190\\| return r 1191\\|
/window functions/tests/distributed/frame clause/range frame/between expr following and expr preceding without order by error	XFail 69ms invalid error message	AssertionError Traceback (most recent call last): File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 274, in regression() File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/argparser.py", line 171, in capture_cluster_args return func(self, cluster_args=cluster_args, **kwargs) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 270, 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 1180, 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.12.2): 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.12.2):\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 1180 in 'query' 1172\\| assert r.exitcode == exitcode, error(r.output) 1173\\| 1174\\| if message is not None: 1175\\| with ( 1176\\| Then(f"output should contain message", description=message) 1177\\| if steps 1178\\| else NullStep() 1179\\| ): 1180\\|> assert message in r.output, error(r.output) 1181\\| 1182\\| if not ignore_exception: 1183\\| if message is None or "Exception:" not in message:
/window functions/tests/distributed/frame clause/range frame/order by decimal	XFail 96ms 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 274, in regression() File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/argparser.py", line 171, in capture_cluster_args return func(self, cluster_args=cluster_args, **kwargs) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 270, 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 159, in execute_query r = current().context.node.query( ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 1188, 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.12.2): 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 1188 in 'query' 1180\\| assert message in r.output, error(r.output) 1181\\| 1182\\| if not ignore_exception: 1183\\| if message is None or "Exception:" not in message: 1184\\| with Then("check if output has exception") if steps else NullStep(): 1185\\| if "Exception:" in r.output: 1186\\| if raise_on_exception: 1187\\| raise QueryRuntimeException(r.output) 1188\\|> assert False, error(r.output) 1189\\| 1190\\| return r 1191\\|
/window functions/tests/distributed/frame clause/range frame/with nulls	XFail 110ms 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 274, in regression() File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/argparser.py", line 171, in capture_cluster_args return func(self, cluster_args=cluster_args, **kwargs) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 270, 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 171, 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 171 in 'execute_query' 163\\| no_checks=no_checks, 164\\| ) 165\\| if no_checks: 166\\| return r 167\\| 168\\| if message is None: 169\\| if expected is not None: 170\\| with Then("I check output against expected"): 171\\|> assert r.output.strip() == expected, error() 172\\| else: 173\\| with Then("I check output against snapshot"): 174\\| with values() as that:
/window functions/tests/distributed/frame clause/range overflow/negative overflow with Int16	XFail 71ms exception on conversion	AssertionError Traceback (most recent call last): File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 274, in regression() File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/argparser.py", line 171, in capture_cluster_args return func(self, cluster_args=cluster_args, **kwargs) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 270, 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 159, in execute_query r = current().context.node.query( ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 1188, 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.12.2): 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 1188 in 'query' 1180\\| assert message in r.output, error(r.output) 1181\\| 1182\\| if not ignore_exception: 1183\\| if message is None or "Exception:" not in message: 1184\\| with Then("check if output has exception") if steps else NullStep(): 1185\\| if "Exception:" in r.output: 1186\\| if raise_on_exception: 1187\\| raise QueryRuntimeException(r.output) 1188\\|> assert False, error(r.output) 1189\\| 1190\\| return r 1191\\|
/window functions/tests/distributed/frame clause/range overflow/positive overflow with Int16	XFail 73ms exception on conversion	AssertionError Traceback (most recent call last): File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 274, in regression() File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/argparser.py", line 171, in capture_cluster_args return func(self, cluster_args=cluster_args, **kwargs) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 270, 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 159, in execute_query r = current().context.node.query( ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 1188, 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.12.2): 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 1188 in 'query' 1180\\| assert message in r.output, error(r.output) 1181\\| 1182\\| if not ignore_exception: 1183\\| if message is None or "Exception:" not in message: 1184\\| with Then("check if output has exception") if steps else NullStep(): 1185\\| if "Exception:" in r.output: 1186\\| if raise_on_exception: 1187\\| raise QueryRuntimeException(r.output) 1188\\|> assert False, error(r.output) 1189\\| 1190\\| return r 1191\\|
/window functions/tests/distributed/frame clause/range datetime/datetime order by desc range between n preceding and n following	XFail 99ms https://github.com/ClickHouse/ClickHouse/issues/23902	AssertionError Traceback (most recent call last): File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 274, in regression() File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/argparser.py", line 171, in capture_cluster_args return func(self, cluster_args=cluster_args, **kwargs) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 270, 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 171, 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\n8\t2006-10-19 10:23:54\t9\t7\n7\t2005-10-19 10:23:54\t8\t6' 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\n8\t2006-10-19 10:23:54\t9\t7\n7\t2005-10-19 10:23:54\t8\t6' 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\n8\t2006-10-19 10:23:54\t9\t7\n7\t2005-10-19 10:23:54\t8\t6' 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 @@ -8 2006-10-19 10:23:54 9 7 -7 2005-10-19 10:23:54 8 6 assert r.output.strip() == expected, error() ^ is False Where File '/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/common.py', line 171 in 'execute_query' 163\\| no_checks=no_checks, 164\\| ) 165\\| if no_checks: 166\\| return r 167\\| 168\\| if message is None: 169\\| if expected is not None: 170\\| with Then("I check output against expected"): 171\\|> assert r.output.strip() == expected, error() 172\\| else: 173\\| with Then("I check output against snapshot"): 174\\| with values() as that:
/window functions/tests/distributed/frame clause/range errors/error negative following offset	XFail 65ms https://github.com/ClickHouse/ClickHouse/issues/22442	AssertionError Traceback (most recent call last): File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 274, in regression() File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/argparser.py", line 171, in capture_cluster_args return func(self, cluster_args=cluster_args, **kwargs) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 270, 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 1180, 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.12.2): 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.12.2):\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 1180 in 'query' 1172\\| assert r.exitcode == exitcode, error(r.output) 1173\\| 1174\\| if message is not None: 1175\\| with ( 1176\\| Then(f"output should contain message", description=message) 1177\\| if steps 1178\\| else NullStep() 1179\\| ): 1180\\|> assert message in r.output, error(r.output) 1181\\| 1182\\| if not ignore_exception: 1183\\| if message is None or "Exception:" not in message:
/window functions/tests/distributed/frame clause/range errors/error negative preceding offset	XFail 80ms https://github.com/ClickHouse/ClickHouse/issues/22442	AssertionError Traceback (most recent call last): File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 274, in regression() File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/argparser.py", line 171, in capture_cluster_args return func(self, cluster_args=cluster_args, **kwargs) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 270, 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 1180, 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.12.2): 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.12.2):\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 1180 in 'query' 1172\\| assert r.exitcode == exitcode, error(r.output) 1173\\| 1174\\| if message is not None: 1175\\| with ( 1176\\| Then(f"output should contain message", description=message) 1177\\| if steps 1178\\| else NullStep() 1179\\| ): 1180\\|> assert message in r.output, error(r.output) 1181\\| 1182\\| if not ignore_exception: 1183\\| if message is None or "Exception:" not in message:
/window functions/tests/distributed/misc/subquery expr preceding	XFail 107ms subquery is not supported as offset	AssertionError Traceback (most recent call last): File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 274, in regression() File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/argparser.py", line 171, in capture_cluster_args return func(self, cluster_args=cluster_args, **kwargs) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 270, 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 171, 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\n13\t7\n1\t1\n3\t2\n5\t3\n7\t4\n9\t5\n11\t6\n15\t8\n17\t9' assert r.output.strip() == expected, error() ^ is 'sum\tunique1\n0\t0\n13\t7\n1\t1\n3\t2\n5\t3\n7\t4\n9\t5\n11\t6\n15\t8\n17\t9' assert r.output.strip() == expected, error() ^ is = assert r.output.strip() == expected, error() ^ is = 'sum\tunique1\n0\t0\n13\t7\n1\t1\n3\t2\n5\t3\n7\t4\n9\t5\n11\t6\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 @@ -3 +2,0 @@ -13 7 @@ -6 +5 @@ -5 3 +5 3Fmu @@ -9,0 +9 @@ +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 171 in 'execute_query' 163\\| no_checks=no_checks, 164\\| ) 165\\| if no_checks: 166\\| return r 167\\| 168\\| if message is None: 169\\| if expected is not None: 170\\| with Then("I check output against expected"): 171\\|> assert r.output.strip() == expected, error() 172\\| else: 173\\| with Then("I check output against snapshot"): 174\\| 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 110ms
known bug

AssertionError
Traceback (most recent call last):
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 274, in 
    regression()
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/argparser.py", line 171, in capture_cluster_args
    return func(self, cluster_args=cluster_args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 270, 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 159, in execute_query
    r = current().context.node.query(
        ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 1188, 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.12.2):
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 1188 in 'query'

1180\|                  assert message in r.output, error(r.output)
1181\|  
1182\|          if not ignore_exception:
1183\|              if message is None or "Exception:" not in message:
1184\|                  with Then("check if output has exception") if steps else NullStep():
1185\|                      if "Exception:" in r.output:
1186\|                          if raise_on_exception:
1187\|                              raise QueryRuntimeException(r.output)
1188\|>                         assert False, error(r.output)
1189\|  
1190\|          return r
1191\|

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

XFail 79ms
invalid error message

AssertionError
Traceback (most recent call last):
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 274, in 
    regression()
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/argparser.py", line 171, in capture_cluster_args
    return func(self, cluster_args=cluster_args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 270, 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 1180, 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.12.2):
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.12.2):\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 1180 in 'query'

1172\|                  assert r.exitcode == exitcode, error(r.output)
1173\|  
1174\|          if message is not None:
1175\|              with (
1176\|                  Then(f"output should contain message", description=message)
1177\|                  if steps
1178\|                  else NullStep()
1179\|              ):
1180\|>                 assert message in r.output, error(r.output)
1181\|  
1182\|          if not ignore_exception:
1183\|              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 89ms
known bug

AssertionError
Traceback (most recent call last):
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 274, in 
    regression()
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/argparser.py", line 171, in capture_cluster_args
    return func(self, cluster_args=cluster_args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 270, 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 159, in execute_query
    r = current().context.node.query(
        ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 1188, 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.12.2):
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 1188 in 'query'

1180\|                  assert message in r.output, error(r.output)
1181\|  
1182\|          if not ignore_exception:
1183\|              if message is None or "Exception:" not in message:
1184\|                  with Then("check if output has exception") if steps else NullStep():
1185\|                      if "Exception:" in r.output:
1186\|                          if raise_on_exception:
1187\|                              raise QueryRuntimeException(r.output)
1188\|>                         assert False, error(r.output)
1189\|  
1190\|          return r
1191\|

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

XFail 74ms
invalid error message

AssertionError
Traceback (most recent call last):
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 274, in 
    regression()
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/argparser.py", line 171, in capture_cluster_args
    return func(self, cluster_args=cluster_args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 270, 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 1180, 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.12.2):
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.12.2):\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 1180 in 'query'

1172\|                  assert r.exitcode == exitcode, error(r.output)
1173\|  
1174\|          if message is not None:
1175\|              with (
1176\|                  Then(f"output should contain message", description=message)
1177\|                  if steps
1178\|                  else NullStep()
1179\|              ):
1180\|>                 assert message in r.output, error(r.output)
1181\|  
1182\|          if not ignore_exception:
1183\|              if message is None or "Exception:" not in message:

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

XFail 84ms
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 274, in 
    regression()
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/argparser.py", line 171, in capture_cluster_args
    return func(self, cluster_args=cluster_args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 270, 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 159, in execute_query
    r = current().context.node.query(
        ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 1188, 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.12.2):
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 1188 in 'query'

1180\|                  assert message in r.output, error(r.output)
1181\|  
1182\|          if not ignore_exception:
1183\|              if message is None or "Exception:" not in message:
1184\|                  with Then("check if output has exception") if steps else NullStep():
1185\|                      if "Exception:" in r.output:
1186\|                          if raise_on_exception:
1187\|                              raise QueryRuntimeException(r.output)
1188\|>                         assert False, error(r.output)
1189\|  
1190\|          return r
1191\|

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

XFail 114ms
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 274, in 
    regression()
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/argparser.py", line 171, in capture_cluster_args
    return func(self, cluster_args=cluster_args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 270, 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 171, 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 171 in 'execute_query'

163\|              no_checks=no_checks,
164\|          )
165\|          if no_checks:
166\|              return r
167\|  
168\|      if message is None:
169\|          if expected is not None:
170\|              with Then("I check output against expected"):
171\|>                 assert r.output.strip() == expected, error()
172\|          else:
173\|              with Then("I check output against snapshot"):
174\|                  with values() as that:

/window functions/tests/non distributed/frame clause/range overflow/negative 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 274, in 
    regression()
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/argparser.py", line 171, in capture_cluster_args
    return func(self, cluster_args=cluster_args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 270, 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 159, in execute_query
    r = current().context.node.query(
        ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 1188, 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.12.2):
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 1188 in 'query'

1180\|                  assert message in r.output, error(r.output)
1181\|  
1182\|          if not ignore_exception:
1183\|              if message is None or "Exception:" not in message:
1184\|                  with Then("check if output has exception") if steps else NullStep():
1185\|                      if "Exception:" in r.output:
1186\|                          if raise_on_exception:
1187\|                              raise QueryRuntimeException(r.output)
1188\|>                         assert False, error(r.output)
1189\|  
1190\|          return r
1191\|

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

XFail 89ms
exception on conversion

AssertionError
Traceback (most recent call last):
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 274, in 
    regression()
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/argparser.py", line 171, in capture_cluster_args
    return func(self, cluster_args=cluster_args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 270, 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 159, in execute_query
    r = current().context.node.query(
        ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 1188, 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.12.2):
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 1188 in 'query'

1180\|                  assert message in r.output, error(r.output)
1181\|  
1182\|          if not ignore_exception:
1183\|              if message is None or "Exception:" not in message:
1184\|                  with Then("check if output has exception") if steps else NullStep():
1185\|                      if "Exception:" in r.output:
1186\|                          if raise_on_exception:
1187\|                              raise QueryRuntimeException(r.output)
1188\|>                         assert False, error(r.output)
1189\|  
1190\|          return r
1191\|

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

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

AssertionError
Traceback (most recent call last):
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 274, in 
    regression()
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/argparser.py", line 171, in capture_cluster_args
    return func(self, cluster_args=cluster_args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 270, 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 1180, 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.12.2):
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.12.2):\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 1180 in 'query'

1172\|                  assert r.exitcode == exitcode, error(r.output)
1173\|  
1174\|          if message is not None:
1175\|              with (
1176\|                  Then(f"output should contain message", description=message)
1177\|                  if steps
1178\|                  else NullStep()
1179\|              ):
1180\|>                 assert message in r.output, error(r.output)
1181\|  
1182\|          if not ignore_exception:
1183\|              if message is None or "Exception:" not in message:

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

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

AssertionError
Traceback (most recent call last):
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 274, in 
    regression()
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/argparser.py", line 171, in capture_cluster_args
    return func(self, cluster_args=cluster_args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 270, 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 1180, 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.12.2):
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.12.2):\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 1180 in 'query'

1172\|                  assert r.exitcode == exitcode, error(r.output)
1173\|  
1174\|          if message is not None:
1175\|              with (
1176\|                  Then(f"output should contain message", description=message)
1177\|                  if steps
1178\|                  else NullStep()
1179\|              ):
1180\|>                 assert message in r.output, error(r.output)
1181\|  
1182\|          if not ignore_exception:
1183\|              if message is None or "Exception:" not in message:

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

XFail 86ms
subquery is not supported as offset

AssertionError
Traceback (most recent call last):
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 274, in 
    regression()
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/argparser.py", line 171, in capture_cluster_args
    return func(self, cluster_args=cluster_args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 270, 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 171, 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 171 in 'execute_query'

163\|              no_checks=no_checks,
164\|          )
165\|          if no_checks:
166\|              return r
167\|  
168\|      if message is None:
169\|          if expected is not None:
170\|              with Then("I check output against expected"):
171\|>                 assert r.output.strip() == expected, error()
172\|          else:
173\|              with Then("I check output against snapshot"):
174\|                  with values() as that:

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

XFail 71ms
known bug

AssertionError
Traceback (most recent call last):
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 274, in 
    regression()
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/argparser.py", line 171, in capture_cluster_args
    return func(self, cluster_args=cluster_args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 270, 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 159, in execute_query
    r = current().context.node.query(
        ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 1188, 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.12.2):
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 1188 in 'query'

1180\|                  assert message in r.output, error(r.output)
1181\|  
1182\|          if not ignore_exception:
1183\|              if message is None or "Exception:" not in message:
1184\|                  with Then("check if output has exception") if steps else NullStep():
1185\|                      if "Exception:" in r.output:
1186\|                          if raise_on_exception:
1187\|                              raise QueryRuntimeException(r.output)
1188\|>                         assert False, error(r.output)
1189\|  
1190\|          return r
1191\|

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

XFail 65ms
invalid error message

AssertionError
Traceback (most recent call last):
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 274, in 
    regression()
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/argparser.py", line 171, in capture_cluster_args
    return func(self, cluster_args=cluster_args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 270, 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 1180, 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.12.2):
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.12.2):\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 1180 in 'query'

1172\|                  assert r.exitcode == exitcode, error(r.output)
1173\|  
1174\|          if message is not None:
1175\|              with (
1176\|                  Then(f"output should contain message", description=message)
1177\|                  if steps
1178\|                  else NullStep()
1179\|              ):
1180\|>                 assert message in r.output, error(r.output)
1181\|  
1182\|          if not ignore_exception:
1183\|              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 67ms
known bug

AssertionError
Traceback (most recent call last):
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 274, in 
    regression()
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/argparser.py", line 171, in capture_cluster_args
    return func(self, cluster_args=cluster_args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 270, 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 159, in execute_query
    r = current().context.node.query(
        ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 1188, 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.12.2):
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 1188 in 'query'

1180\|                  assert message in r.output, error(r.output)
1181\|  
1182\|          if not ignore_exception:
1183\|              if message is None or "Exception:" not in message:
1184\|                  with Then("check if output has exception") if steps else NullStep():
1185\|                      if "Exception:" in r.output:
1186\|                          if raise_on_exception:
1187\|                              raise QueryRuntimeException(r.output)
1188\|>                         assert False, error(r.output)
1189\|  
1190\|          return r
1191\|

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

XFail 69ms
invalid error message

AssertionError
Traceback (most recent call last):
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 274, in 
    regression()
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/argparser.py", line 171, in capture_cluster_args
    return func(self, cluster_args=cluster_args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 270, 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 1180, 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.12.2):
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.12.2):\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 1180 in 'query'

1172\|                  assert r.exitcode == exitcode, error(r.output)
1173\|  
1174\|          if message is not None:
1175\|              with (
1176\|                  Then(f"output should contain message", description=message)
1177\|                  if steps
1178\|                  else NullStep()
1179\|              ):
1180\|>                 assert message in r.output, error(r.output)
1181\|  
1182\|          if not ignore_exception:
1183\|              if message is None or "Exception:" not in message:

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

XFail 96ms
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 274, in 
    regression()
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/argparser.py", line 171, in capture_cluster_args
    return func(self, cluster_args=cluster_args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 270, 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 159, in execute_query
    r = current().context.node.query(
        ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 1188, 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.12.2):
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 1188 in 'query'

1180\|                  assert message in r.output, error(r.output)
1181\|  
1182\|          if not ignore_exception:
1183\|              if message is None or "Exception:" not in message:
1184\|                  with Then("check if output has exception") if steps else NullStep():
1185\|                      if "Exception:" in r.output:
1186\|                          if raise_on_exception:
1187\|                              raise QueryRuntimeException(r.output)
1188\|>                         assert False, error(r.output)
1189\|  
1190\|          return r
1191\|

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

XFail 110ms
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 274, in 
    regression()
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/argparser.py", line 171, in capture_cluster_args
    return func(self, cluster_args=cluster_args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 270, 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 171, 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 171 in 'execute_query'

163\|              no_checks=no_checks,
164\|          )
165\|          if no_checks:
166\|              return r
167\|  
168\|      if message is None:
169\|          if expected is not None:
170\|              with Then("I check output against expected"):
171\|>                 assert r.output.strip() == expected, error()
172\|          else:
173\|              with Then("I check output against snapshot"):
174\|                  with values() as that:

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

XFail 71ms
exception on conversion

AssertionError
Traceback (most recent call last):
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 274, in 
    regression()
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/argparser.py", line 171, in capture_cluster_args
    return func(self, cluster_args=cluster_args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 270, 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 159, in execute_query
    r = current().context.node.query(
        ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 1188, 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.12.2):
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 1188 in 'query'

1180\|                  assert message in r.output, error(r.output)
1181\|  
1182\|          if not ignore_exception:
1183\|              if message is None or "Exception:" not in message:
1184\|                  with Then("check if output has exception") if steps else NullStep():
1185\|                      if "Exception:" in r.output:
1186\|                          if raise_on_exception:
1187\|                              raise QueryRuntimeException(r.output)
1188\|>                         assert False, error(r.output)
1189\|  
1190\|          return r
1191\|

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

XFail 73ms
exception on conversion

AssertionError
Traceback (most recent call last):
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 274, in 
    regression()
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/argparser.py", line 171, in capture_cluster_args
    return func(self, cluster_args=cluster_args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 270, 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 159, in execute_query
    r = current().context.node.query(
        ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 1188, 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.12.2):
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 1188 in 'query'

1180\|                  assert message in r.output, error(r.output)
1181\|  
1182\|          if not ignore_exception:
1183\|              if message is None or "Exception:" not in message:
1184\|                  with Then("check if output has exception") if steps else NullStep():
1185\|                      if "Exception:" in r.output:
1186\|                          if raise_on_exception:
1187\|                              raise QueryRuntimeException(r.output)
1188\|>                         assert False, error(r.output)
1189\|  
1190\|          return r
1191\|

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

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

AssertionError
Traceback (most recent call last):
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 274, in 
    regression()
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/argparser.py", line 171, in capture_cluster_args
    return func(self, cluster_args=cluster_args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 270, 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 171, 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\n8\t2006-10-19 10:23:54\t9\t7\n7\t2005-10-19 10:23:54\t8\t6'
  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\n8\t2006-10-19 10:23:54\t9\t7\n7\t2005-10-19 10:23:54\t8\t6'
  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\n8\t2006-10-19 10:23:54\t9\t7\n7\t2005-10-19 10:23:54\t8\t6'
  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 @@
    -8  2006-10-19 10:23:54 9   7
    -7  2005-10-19 10:23:54 8   6
  assert r.output.strip() == expected, error()
  ^ is False

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

163\|              no_checks=no_checks,
164\|          )
165\|          if no_checks:
166\|              return r
167\|  
168\|      if message is None:
169\|          if expected is not None:
170\|              with Then("I check output against expected"):
171\|>                 assert r.output.strip() == expected, error()
172\|          else:
173\|              with Then("I check output against snapshot"):
174\|                  with values() as that:

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

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

AssertionError
Traceback (most recent call last):
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 274, in 
    regression()
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/argparser.py", line 171, in capture_cluster_args
    return func(self, cluster_args=cluster_args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 270, 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 1180, 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.12.2):
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.12.2):\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 1180 in 'query'

1172\|                  assert r.exitcode == exitcode, error(r.output)
1173\|  
1174\|          if message is not None:
1175\|              with (
1176\|                  Then(f"output should contain message", description=message)
1177\|                  if steps
1178\|                  else NullStep()
1179\|              ):
1180\|>                 assert message in r.output, error(r.output)
1181\|  
1182\|          if not ignore_exception:
1183\|              if message is None or "Exception:" not in message:

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

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

AssertionError
Traceback (most recent call last):
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 274, in 
    regression()
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/argparser.py", line 171, in capture_cluster_args
    return func(self, cluster_args=cluster_args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 270, 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 1180, 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.12.2):
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.12.2):\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 1180 in 'query'

1172\|                  assert r.exitcode == exitcode, error(r.output)
1173\|  
1174\|          if message is not None:
1175\|              with (
1176\|                  Then(f"output should contain message", description=message)
1177\|                  if steps
1178\|                  else NullStep()
1179\|              ):
1180\|>                 assert message in r.output, error(r.output)
1181\|  
1182\|          if not ignore_exception:
1183\|              if message is None or "Exception:" not in message:

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

XFail 107ms
subquery is not supported as offset

AssertionError
Traceback (most recent call last):
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 274, in 
    regression()
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/argparser.py", line 171, in capture_cluster_args
    return func(self, cluster_args=cluster_args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 270, 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 171, 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\n13\t7\n1\t1\n3\t2\n5\t3\n7\t4\n9\t5\n11\t6\n15\t8\n17\t9'
  assert r.output.strip() == expected, error()
         ^ is 'sum\tunique1\n0\t0\n13\t7\n1\t1\n3\t2\n5\t3\n7\t4\n9\t5\n11\t6\n15\t8\n17\t9'
  assert r.output.strip() == expected, error()
         ^ is = 
  assert r.output.strip() == expected, error()
         ^ is = 'sum\tunique1\n0\t0\n13\t7\n1\t1\n3\t2\n5\t3\n7\t4\n9\t5\n11\t6\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
    @@ -3 +2,0 @@
    -13 7
    @@ -6 +5 @@
    -5  3
    +5  3Fmu
    @@ -9,0 +9 @@
    +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 171 in 'execute_query'

163\|              no_checks=no_checks,
164\|          )
165\|          if no_checks:
166\|              return r
167\|  
168\|      if message is None:
169\|          if expected is not None:
170\|              with Then("I check output against expected"):
171\|>                 assert r.output.strip() == expected, error()
172\|          else:
173\|              with Then("I check output against snapshot"):
174\|                  with values() as that:

Date	Apr 03, 2025 16:03
Duration	9m 6s
Framework	TestFlows 2.0.250110.1002922

project	Altinity/ClickHouse
project.id	159717931
package	https://s3.amazonaws.com/altinity-build-artifacts/PRs/683/485c050b9eebde39c0497e5f66e1f969576e2271/package_aarch64/clickhouse-common-static_24.12.2.20228.altinityantalya_arm64.deb
version	24.12.2.20228.altinityantalya
user.name	ianton-ru
repository	https://github.com/Altinity/clickhouse-regression
commit.hash	bd31e738c0cedaca253d15a05ed245c41b6e0b6a
job.name	Common
job.retry	1
job.url	https://github.com/Altinity/ClickHouse/actions/runs/14243856895
arch	aarch64
local	True
clickhouse_version	None
clickhouse_path	https://s3.amazonaws.com/altinity-build-artifacts/PRs/683/485c050b9eebde39c0497e5f66e1f969576e2271/package_aarch64/clickhouse-common-static_24.12.2.20228.altinityantalya_arm64.deb
as_binary	False
base_os	None
keeper_path	None
zookeeper_version	None
use_keeper	False
stress	False
collect_service_logs	True
thread_fuzzer	False
with_analyzer	True
reuse_env	False

Window Functions Test Run Report

Artifacts

Attributes

Summary

Statistics

Known Fails

Results