	Units	OK	Fail	XFail
Modules	1	1
Suites	39	39
Features	39	39
Scenarios	456	430		26
Checks	256	256
Examples	1418	1396		22
Steps	7589	7514	75

Test Name	Result	Message
/window functions/tests/non distributed/frame clause/range frame/between current row and unbounded following modifying named window	XFail 172ms range with named window is not supported	AssertionError Traceback (most recent call last): File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 228, in regression() File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 224, 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 72, 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 1733, in feature Scenario(run=scenario, flags=TE) File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_frame.py", line 1520, in between_current_row_and_unbounded_following_modifying_named_window execute_query( File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/common.py", line 140, in execute_query r = current().context.node.query( File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 780, in query assert False, error(r.output) AssertionError: Oops! Assertion failed The following assertion was not satisfied assert False, error(r.output) Description Received exception from server (version 22.8.15): Code: 49. DB::Exception: Received from localhost:9000. DB::Exception: Sizes of sort description and actions are mismatched. (LOGICAL_ERROR) (query: SELECT * FROM (SELECT sum(unique1) over (w range between current row and unbounded following) AS sum,unique1, four FROM tenk1 WHERE unique1 < 10 WINDOW w AS (order by four)) ORDER BY unique1 FORMAT TabSeparatedWithNames ) Assertion values assert False, error(r.output) ^ is False Where File '/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py', line 780 in 'query' 772\\| assert message in r.output, error(r.output) 773\\| 774\\| if not ignore_exception: 775\\| if message is None or "Exception:" not in message: 776\\| with Then("check if output has exception") if steps else NullStep(): 777\\| if "Exception:" in r.output: 778\\| if raise_on_exception: 779\\| raise QueryRuntimeException(r.output) 780\\|> assert False, error(r.output) 781\\| 782\\| return r 783\\|
/window functions/tests/non distributed/frame clause/range frame/between expr following and current row zero special case	XFail 164ms known bug	AssertionError Traceback (most recent call last): File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 228, in regression() File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 224, 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 72, 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 1733, in feature Scenario(run=scenario, flags=TE) File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_frame.py", line 1347, 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 140, in execute_query r = current().context.node.query( File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 780, in query assert False, error(r.output) AssertionError: Oops! Assertion failed The following assertion was not satisfied assert False, error(r.output) Description Received exception from server (version 22.8.15): Code: 36. DB::Exception: Received from localhost:9000. DB::Exception: Window frame 'RANGE BETWEEN 0 FOLLOWING AND CURRENT ROW' is invalid. (BAD_ARGUMENTS) (query: SELECT number,sum(number) OVER (ORDER BY number RANGE BETWEEN 0 FOLLOWING AND CURRENT ROW) AS sum FROM values('number Int8', (1),(1),(2),(3)) FORMAT TabSeparatedWithNames ) Assertion values assert False, error(r.output) ^ is False Where File '/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py', line 780 in 'query' 772\\| assert message in r.output, error(r.output) 773\\| 774\\| if not ignore_exception: 775\\| if message is None or "Exception:" not in message: 776\\| with Then("check if output has exception") if steps else NullStep(): 777\\| if "Exception:" in r.output: 778\\| if raise_on_exception: 779\\| raise QueryRuntimeException(r.output) 780\\|> assert False, error(r.output) 781\\| 782\\| return r 783\\|
/window functions/tests/non distributed/frame clause/range frame/between expr following and expr following without order by error	XFail 124ms invalid error message	AssertionError Traceback (most recent call last): File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 228, in regression() File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 224, 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 72, 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 1733, in feature Scenario(run=scenario, flags=TE) File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_frame.py", line 1211, in between_expr_following_and_expr_following_without_order_by_error self.context.node.query( File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 772, in query assert message in r.output, error(r.output) AssertionError: Oops! Assertion failed The following assertion was not satisfied assert message in r.output, error(r.output) Description Received exception from server (version 22.8.15): Code: 36. DB::Exception: Received from localhost:9000. DB::Exception: The RANGE OFFSET window frame requires exactly one ORDER BY column, 0 given. (BAD_ARGUMENTS) (query: SELECT number,sum(number) OVER (RANGE BETWEEN 1 FOLLOWING AND 1 FOLLOWING) FROM values('number Int8', (1),(1),(2),(3)) ) Assertion values assert message in r.output, error(r.output) ^ is 'Exception: Window frame' assert message in r.output, error(r.output) ^ is assert message in r.output, error(r.output) ^ is = "Received exception from server (version 22.8.15):\nCode: 36. DB::Exception: Received from localhost:9000. DB::Exception: The RANGE OFFSET window frame requires exactly one ORDER BY column, 0 given. (BAD_ARGUMENTS)\n(query: SELECT number,sum(number) OVER (RANGE BETWEEN 1 FOLLOWING AND 1 FOLLOWING) FROM values('number Int8', (1),(1),(2),(3))\n)" assert message in r.output, error(r.output) ^ is = False assert message in r.output, error(r.output) ^ is False Where File '/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py', line 772 in 'query' 764\\| if exitcode is not None: 765\\| with Then(f"exitcode should be {exitcode}") if steps else NullStep(): 766\\| assert r.exitcode == exitcode, error(r.output) 767\\| 768\\| if message is not None: 769\\| with Then( 770\\| f"output should contain message", description=message 771\\| ) if steps else NullStep(): 772\\|> assert message in r.output, error(r.output) 773\\| 774\\| if not ignore_exception: 775\\| 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 140ms known bug	AssertionError Traceback (most recent call last): File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 228, in regression() File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 224, 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 72, 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 1733, in feature Scenario(run=scenario, flags=TE) File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_frame.py", line 1416, in between_expr_following_and_expr_preceding_with_order_by_zero_special_case execute_query( File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/common.py", line 140, in execute_query r = current().context.node.query( File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 780, in query assert False, error(r.output) AssertionError: Oops! Assertion failed The following assertion was not satisfied assert False, error(r.output) Description Received exception from server (version 22.8.15): Code: 36. DB::Exception: Received from localhost:9000. DB::Exception: Frame start offset 0 FOLLOWING does not precede the frame end offset 0 PRECEDING. (BAD_ARGUMENTS) (query: SELECT number,sum(number) OVER (ORDER BY number RANGE BETWEEN 0 FOLLOWING AND 0 PRECEDING) AS sum FROM values('number Int8', (1),(1),(2),(3)) FORMAT TabSeparatedWithNames ) Assertion values assert False, error(r.output) ^ is False Where File '/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py', line 780 in 'query' 772\\| assert message in r.output, error(r.output) 773\\| 774\\| if not ignore_exception: 775\\| if message is None or "Exception:" not in message: 776\\| with Then("check if output has exception") if steps else NullStep(): 777\\| if "Exception:" in r.output: 778\\| if raise_on_exception: 779\\| raise QueryRuntimeException(r.output) 780\\|> assert False, error(r.output) 781\\| 782\\| return r 783\\|
/window functions/tests/non distributed/frame clause/range frame/between expr following and expr preceding without order by error	XFail 122ms invalid error message	AssertionError Traceback (most recent call last): File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 228, in regression() File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 224, 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 72, 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 1733, in feature Scenario(run=scenario, flags=TE) File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_frame.py", line 1228, in between_expr_following_and_expr_preceding_without_order_by_error self.context.node.query( File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 772, in query assert message in r.output, error(r.output) AssertionError: Oops! Assertion failed The following assertion was not satisfied assert message in r.output, error(r.output) Description Received exception from server (version 22.8.15): Code: 36. DB::Exception: Received from localhost:9000. DB::Exception: Frame start offset 0 FOLLOWING does not precede the frame end offset 0 PRECEDING. (BAD_ARGUMENTS) (query: SELECT number,sum(number) OVER (RANGE BETWEEN 0 FOLLOWING AND 0 PRECEDING) FROM values('number Int8', (1),(1),(2),(3)) ) Assertion values assert message in r.output, error(r.output) ^ is 'Exception: Window frame' assert message in r.output, error(r.output) ^ is assert message in r.output, error(r.output) ^ is = "Received exception from server (version 22.8.15):\nCode: 36. DB::Exception: Received from localhost:9000. DB::Exception: Frame start offset 0 FOLLOWING does not precede the frame end offset 0 PRECEDING. (BAD_ARGUMENTS)\n(query: SELECT number,sum(number) OVER (RANGE BETWEEN 0 FOLLOWING AND 0 PRECEDING) FROM values('number Int8', (1),(1),(2),(3))\n)" assert message in r.output, error(r.output) ^ is = False assert message in r.output, error(r.output) ^ is False Where File '/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py', line 772 in 'query' 764\\| if exitcode is not None: 765\\| with Then(f"exitcode should be {exitcode}") if steps else NullStep(): 766\\| assert r.exitcode == exitcode, error(r.output) 767\\| 768\\| if message is not None: 769\\| with Then( 770\\| f"output should contain message", description=message 771\\| ) if steps else NullStep(): 772\\|> assert message in r.output, error(r.output) 773\\| 774\\| if not ignore_exception: 775\\| if message is None or "Exception:" not in message:
/window functions/tests/non distributed/frame clause/range frame/order by decimal	XFail 170ms 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 228, in regression() File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 224, 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 72, 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 1733, in feature Scenario(run=scenario, flags=TE) File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_frame.py", line 1649, in order_by_decimal execute_query( File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/common.py", line 140, in execute_query r = current().context.node.query( File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 780, in query assert False, error(r.output) AssertionError: Oops! Assertion failed The following assertion was not satisfied assert False, error(r.output) Description Received exception from server (version 22.8.15): Code: 48. DB::Exception: Received from localhost:9000. DB::Exception: The RANGE OFFSET frame for 'DB::ColumnDecimal >' ORDER BY column is not implemented. (NOT_IMPLEMENTED) (query: select id, f_numeric, first_value(id) over w AS first_value, last_value(id) over w AS last_value from numerics window w as (order by f_numeric range between 1 preceding and 1 following) FORMAT TabSeparatedWithNames ) Assertion values assert False, error(r.output) ^ is False Where File '/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py', line 780 in 'query' 772\\| assert message in r.output, error(r.output) 773\\| 774\\| if not ignore_exception: 775\\| if message is None or "Exception:" not in message: 776\\| with Then("check if output has exception") if steps else NullStep(): 777\\| if "Exception:" in r.output: 778\\| if raise_on_exception: 779\\| raise QueryRuntimeException(r.output) 780\\|> assert False, error(r.output) 781\\| 782\\| return r 783\\|
/window functions/tests/non distributed/frame clause/range frame/with nulls	XFail 213ms 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 228, in regression() File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 224, 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 72, 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 1733, in feature Scenario(run=scenario, flags=TE) File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_frame.py", line 1708, in with_nulls execute_query( File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/common.py", line 140, in execute_query r = current().context.node.query( File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 780, in query assert False, error(r.output) AssertionError: Oops! Assertion failed The following assertion was not satisfied assert False, error(r.output) Description Received exception from server (version 22.8.15): Code: 48. DB::Exception: Received from localhost:9000. DB::Exception: The RANGE OFFSET frame for 'DB::ColumnNullable' ORDER BY column is not implemented. (NOT_IMPLEMENTED) (query: select x, y, first_value(y) over w AS first_value, last_value(y) over w AS last_value from (select number as x, x as y from numbers(1,5) union all select null, 42 union all select null, 43) window w as (order by x asc nulls first range between 2 preceding and 2 following) FORMAT TabSeparatedWithNames ) Assertion values assert False, error(r.output) ^ is False Where File '/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py', line 780 in 'query' 772\\| assert message in r.output, error(r.output) 773\\| 774\\| if not ignore_exception: 775\\| if message is None or "Exception:" not in message: 776\\| with Then("check if output has exception") if steps else NullStep(): 777\\| if "Exception:" in r.output: 778\\| if raise_on_exception: 779\\| raise QueryRuntimeException(r.output) 780\\|> assert False, error(r.output) 781\\| 782\\| return r 783\\|
/window functions/tests/non distributed/frame clause/range overflow/negative overflow with Int16	XFail 153ms exception on conversion	AssertionError Traceback (most recent call last): File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 228, in regression() File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 224, 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 72, 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 140, in execute_query r = current().context.node.query( File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 780, in query assert False, error(r.output) AssertionError: Oops! Assertion failed The following assertion was not satisfied assert False, error(r.output) Description Received exception from server (version 22.8.15): Code: 69. DB::Exception: Received from localhost:9000. DB::Exception: Cannot convert value '2147450885': it cannot be represented as Int16. (ARGUMENT_OUT_OF_BOUND) (query: select number as x, last_value(x) over (order by toInt16(x) desc range between current row and 2147450885 following) as last_value from (SELECT -number - 32763 AS number FROM numbers(1, 3)) FORMAT TabSeparatedWithNames ) Assertion values assert False, error(r.output) ^ is False Where File '/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py', line 780 in 'query' 772\\| assert message in r.output, error(r.output) 773\\| 774\\| if not ignore_exception: 775\\| if message is None or "Exception:" not in message: 776\\| with Then("check if output has exception") if steps else NullStep(): 777\\| if "Exception:" in r.output: 778\\| if raise_on_exception: 779\\| raise QueryRuntimeException(r.output) 780\\|> assert False, error(r.output) 781\\| 782\\| return r 783\\|
/window functions/tests/non distributed/frame clause/range overflow/positive overflow with Int16	XFail 157ms exception on conversion	AssertionError Traceback (most recent call last): File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 228, in regression() File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 224, 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 72, 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 140, in execute_query r = current().context.node.query( File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 780, in query assert False, error(r.output) AssertionError: Oops! Assertion failed The following assertion was not satisfied assert False, error(r.output) Description Received exception from server (version 22.8.15): Code: 69. DB::Exception: Received from localhost:9000. DB::Exception: Cannot convert value '2147450884': it cannot be represented as Int16. (ARGUMENT_OUT_OF_BOUND) (query: select number as x, last_value(x) over (order by toInt16(x) range between current row and 2147450884 following) AS last_value from numbers(32764, 3) FORMAT TabSeparatedWithNames ) Assertion values assert False, error(r.output) ^ is False Where File '/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py', line 780 in 'query' 772\\| assert message in r.output, error(r.output) 773\\| 774\\| if not ignore_exception: 775\\| if message is None or "Exception:" not in message: 776\\| with Then("check if output has exception") if steps else NullStep(): 777\\| if "Exception:" in r.output: 778\\| if raise_on_exception: 779\\| raise QueryRuntimeException(r.output) 780\\|> assert False, error(r.output) 781\\| 782\\| return r 783\\|
/window functions/tests/non distributed/frame clause/range errors/error negative following offset	XFail 120ms https://github.com/ClickHouse/ClickHouse/issues/22442	AssertionError Traceback (most recent call last): File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 228, in regression() File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 224, 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 72, 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 772, in query assert message in r.output, error(r.output) AssertionError: Oops! Assertion failed The following assertion was not satisfied assert message in r.output, error(r.output) Description Received exception from server (version 22.8.15): Code: 36. DB::Exception: Received from localhost:9000. DB::Exception: Window frame start offset must be nonnegative, -2 given. (BAD_ARGUMENTS) (query: select max(enroll_date) over (order by salary range between 1 preceding and -2 following) AS max, salary, enroll_date from empsalary ) Assertion values assert message in r.output, error(r.output) ^ is 'DB::Exception: Frame end offset must be greater than zero, -2 given' assert message in r.output, error(r.output) ^ is assert message in r.output, error(r.output) ^ is = 'Received exception from server (version 22.8.15):\nCode: 36. DB::Exception: Received from localhost:9000. DB::Exception: Window frame start offset must be nonnegative, -2 given. (BAD_ARGUMENTS)\n(query: select max(enroll_date) over (order by salary range between 1 preceding and -2 following) AS max, salary, enroll_date from empsalary\n)' assert message in r.output, error(r.output) ^ is = False assert message in r.output, error(r.output) ^ is False Where File '/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py', line 772 in 'query' 764\\| if exitcode is not None: 765\\| with Then(f"exitcode should be {exitcode}") if steps else NullStep(): 766\\| assert r.exitcode == exitcode, error(r.output) 767\\| 768\\| if message is not None: 769\\| with Then( 770\\| f"output should contain message", description=message 771\\| ) if steps else NullStep(): 772\\|> assert message in r.output, error(r.output) 773\\| 774\\| if not ignore_exception: 775\\| if message is None or "Exception:" not in message:
/window functions/tests/non distributed/frame clause/range errors/error negative preceding offset	XFail 166ms https://github.com/ClickHouse/ClickHouse/issues/22442	AssertionError Traceback (most recent call last): File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 228, in regression() File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 224, 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 72, 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 772, in query assert message in r.output, error(r.output) AssertionError: Oops! Assertion failed The following assertion was not satisfied assert message in r.output, error(r.output) Description Received exception from server (version 22.8.15): Code: 36. DB::Exception: Received from localhost:9000. DB::Exception: Window frame start offset must be nonnegative, -1 given. (BAD_ARGUMENTS) (query: select max(enroll_date) over (order by salary range between -1 preceding and 2 following) AS max, salary, enroll_date from empsalary ) Assertion values assert message in r.output, error(r.output) ^ is 'DB::Exception: Frame start offset must be greater than zero, -1 given' assert message in r.output, error(r.output) ^ is assert message in r.output, error(r.output) ^ is = 'Received exception from server (version 22.8.15):\nCode: 36. DB::Exception: Received from localhost:9000. DB::Exception: Window frame start offset must be nonnegative, -1 given. (BAD_ARGUMENTS)\n(query: select max(enroll_date) over (order by salary range between -1 preceding and 2 following) AS max, salary, enroll_date from empsalary\n)' assert message in r.output, error(r.output) ^ is = False assert message in r.output, error(r.output) ^ is False Where File '/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py', line 772 in 'query' 764\\| if exitcode is not None: 765\\| with Then(f"exitcode should be {exitcode}") if steps else NullStep(): 766\\| assert r.exitcode == exitcode, error(r.output) 767\\| 768\\| if message is not None: 769\\| with Then( 770\\| f"output should contain message", description=message 771\\| ) if steps else NullStep(): 772\\|> assert message in r.output, error(r.output) 773\\| 774\\| if not ignore_exception: 775\\| if message is None or "Exception:" not in message:
/window functions/tests/distributed/frame clause/range frame/between current row and unbounded following modifying named window	XFail 125ms range with named window is not supported	AssertionError Traceback (most recent call last): File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 228, in regression() File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 224, 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 72, 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 1733, in feature Scenario(run=scenario, flags=TE) File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_frame.py", line 1520, in between_current_row_and_unbounded_following_modifying_named_window execute_query( File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/common.py", line 152, in execute_query assert r.output.strip() == expected, error() AssertionError: Oops! Assertion failed The following assertion was not satisfied assert r.output.strip() == expected, error() Assertion values assert r.output.strip() == expected, error() ^ is assert r.output.strip() == expected, error() ^ is = 'sum\tunique1\tfour\n45\t0\t0\n33\t1\t1\n18\t2\t2\n10\t3\t3\n45\t4\t0\n33\t5\t1\n18\t6\t2\n10\t7\t3\n45\t8\t0\n33\t9\t1' assert r.output.strip() == expected, error() ^ is 'sum\tunique1\tfour\n45\t0\t0\n33\t1\t1\n18\t2\t2\n10\t3\t3\n45\t4\t0\n33\t5\t1\n18\t6\t2\n10\t7\t3\n45\t8\t0\n33\t9\t1' assert r.output.strip() == expected, error() ^ is = assert r.output.strip() == expected, error() ^ is = 'sum\tunique1\tfour\n45\t0\t0\n33\t1\t1\n18\t2\t2\n10\t3\t3\n45\t4\t0\n33\t5\t1\n18\t6\t2\n10\t7\t3\n45\t8\t0\n33\t9\t1' assert r.output.strip() == expected, error() ^ is 'sum\tunique1\tfour\n45\t0\t0\n45\t8\t0\n45\t4\t0\n33\t5\t1\n33\t9\t1\n33\t1\t1\n18\t6\t2\n18\t2\t2\n10\t3\t3\n10\t7\t3' assert r.output.strip() == expected, error() ^ is = False @@ -2,0 +3,4 @@ +45 8 0 +45 4 0 +33 5 1 +33 9 1 @@ -3,0 +8 @@ +18 6 2 @@ -6,3 +10,0 @@ -45 4 0 -33 5 1 -18 6 2 @@ -10,2 +11,0 @@ -45 8 0 -33 9 1 assert r.output.strip() == expected, error() ^ is False Where File '/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/common.py', line 152 in 'execute_query' 144\\| no_checks=no_checks, 145\\| ) 146\\| if no_checks: 147\\| return r 148\\| 149\\| if message is None: 150\\| if expected is not None: 151\\| with Then("I check output against expected"): 152\\|> assert r.output.strip() == expected, error() 153\\| else: 154\\| with Then("I check output against snapshot"): 155\\| with values() as that:
/window functions/tests/distributed/frame clause/range frame/between expr following and current row zero special case	XFail 127ms known bug	AssertionError Traceback (most recent call last): File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 228, in regression() File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 224, 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 72, 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 1733, in feature Scenario(run=scenario, flags=TE) File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_frame.py", line 1347, 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 140, in execute_query r = current().context.node.query( File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 780, in query assert False, error(r.output) AssertionError: Oops! Assertion failed The following assertion was not satisfied assert False, error(r.output) Description Received exception from server (version 22.8.15): Code: 36. DB::Exception: Received from localhost:9000. DB::Exception: Window frame 'RANGE BETWEEN 0 FOLLOWING AND CURRENT ROW' is invalid. (BAD_ARGUMENTS) (query: SELECT number,sum(number) OVER (ORDER BY number RANGE BETWEEN 0 FOLLOWING AND CURRENT ROW) AS sum FROM values('number Int8', (1),(1),(2),(3)) FORMAT TabSeparatedWithNames ) Assertion values assert False, error(r.output) ^ is False Where File '/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py', line 780 in 'query' 772\\| assert message in r.output, error(r.output) 773\\| 774\\| if not ignore_exception: 775\\| if message is None or "Exception:" not in message: 776\\| with Then("check if output has exception") if steps else NullStep(): 777\\| if "Exception:" in r.output: 778\\| if raise_on_exception: 779\\| raise QueryRuntimeException(r.output) 780\\|> assert False, error(r.output) 781\\| 782\\| return r 783\\|
/window functions/tests/distributed/frame clause/range frame/between expr following and expr following without order by error	XFail 167ms invalid error message	AssertionError Traceback (most recent call last): File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 228, in regression() File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 224, 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 72, 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 1733, in feature Scenario(run=scenario, flags=TE) File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_frame.py", line 1211, in between_expr_following_and_expr_following_without_order_by_error self.context.node.query( File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 772, in query assert message in r.output, error(r.output) AssertionError: Oops! Assertion failed The following assertion was not satisfied assert message in r.output, error(r.output) Description Received exception from server (version 22.8.15): Code: 36. DB::Exception: Received from localhost:9000. DB::Exception: The RANGE OFFSET window frame requires exactly one ORDER BY column, 0 given. (BAD_ARGUMENTS) (query: SELECT number,sum(number) OVER (RANGE BETWEEN 1 FOLLOWING AND 1 FOLLOWING) FROM values('number Int8', (1),(1),(2),(3)) ) Assertion values assert message in r.output, error(r.output) ^ is 'Exception: Window frame' assert message in r.output, error(r.output) ^ is assert message in r.output, error(r.output) ^ is = "Received exception from server (version 22.8.15):\nCode: 36. DB::Exception: Received from localhost:9000. DB::Exception: The RANGE OFFSET window frame requires exactly one ORDER BY column, 0 given. (BAD_ARGUMENTS)\n(query: SELECT number,sum(number) OVER (RANGE BETWEEN 1 FOLLOWING AND 1 FOLLOWING) FROM values('number Int8', (1),(1),(2),(3))\n)" assert message in r.output, error(r.output) ^ is = False assert message in r.output, error(r.output) ^ is False Where File '/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py', line 772 in 'query' 764\\| if exitcode is not None: 765\\| with Then(f"exitcode should be {exitcode}") if steps else NullStep(): 766\\| assert r.exitcode == exitcode, error(r.output) 767\\| 768\\| if message is not None: 769\\| with Then( 770\\| f"output should contain message", description=message 771\\| ) if steps else NullStep(): 772\\|> assert message in r.output, error(r.output) 773\\| 774\\| if not ignore_exception: 775\\| 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 125ms known bug	AssertionError Traceback (most recent call last): File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 228, in regression() File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 224, 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 72, 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 1733, in feature Scenario(run=scenario, flags=TE) File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_frame.py", line 1416, in between_expr_following_and_expr_preceding_with_order_by_zero_special_case execute_query( File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/common.py", line 140, in execute_query r = current().context.node.query( File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 780, in query assert False, error(r.output) AssertionError: Oops! Assertion failed The following assertion was not satisfied assert False, error(r.output) Description Received exception from server (version 22.8.15): Code: 36. DB::Exception: Received from localhost:9000. DB::Exception: Frame start offset 0 FOLLOWING does not precede the frame end offset 0 PRECEDING. (BAD_ARGUMENTS) (query: SELECT number,sum(number) OVER (ORDER BY number RANGE BETWEEN 0 FOLLOWING AND 0 PRECEDING) AS sum FROM values('number Int8', (1),(1),(2),(3)) FORMAT TabSeparatedWithNames ) Assertion values assert False, error(r.output) ^ is False Where File '/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py', line 780 in 'query' 772\\| assert message in r.output, error(r.output) 773\\| 774\\| if not ignore_exception: 775\\| if message is None or "Exception:" not in message: 776\\| with Then("check if output has exception") if steps else NullStep(): 777\\| if "Exception:" in r.output: 778\\| if raise_on_exception: 779\\| raise QueryRuntimeException(r.output) 780\\|> assert False, error(r.output) 781\\| 782\\| return r 783\\|
/window functions/tests/distributed/frame clause/range frame/between expr following and expr preceding without order by error	XFail 184ms invalid error message	AssertionError Traceback (most recent call last): File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 228, in regression() File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 224, 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 72, 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 1733, in feature Scenario(run=scenario, flags=TE) File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_frame.py", line 1228, in between_expr_following_and_expr_preceding_without_order_by_error self.context.node.query( File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 772, in query assert message in r.output, error(r.output) AssertionError: Oops! Assertion failed The following assertion was not satisfied assert message in r.output, error(r.output) Description Received exception from server (version 22.8.15): Code: 36. DB::Exception: Received from localhost:9000. DB::Exception: Frame start offset 0 FOLLOWING does not precede the frame end offset 0 PRECEDING. (BAD_ARGUMENTS) (query: SELECT number,sum(number) OVER (RANGE BETWEEN 0 FOLLOWING AND 0 PRECEDING) FROM values('number Int8', (1),(1),(2),(3)) ) Assertion values assert message in r.output, error(r.output) ^ is 'Exception: Window frame' assert message in r.output, error(r.output) ^ is assert message in r.output, error(r.output) ^ is = "Received exception from server (version 22.8.15):\nCode: 36. DB::Exception: Received from localhost:9000. DB::Exception: Frame start offset 0 FOLLOWING does not precede the frame end offset 0 PRECEDING. (BAD_ARGUMENTS)\n(query: SELECT number,sum(number) OVER (RANGE BETWEEN 0 FOLLOWING AND 0 PRECEDING) FROM values('number Int8', (1),(1),(2),(3))\n)" assert message in r.output, error(r.output) ^ is = False assert message in r.output, error(r.output) ^ is False Where File '/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py', line 772 in 'query' 764\\| if exitcode is not None: 765\\| with Then(f"exitcode should be {exitcode}") if steps else NullStep(): 766\\| assert r.exitcode == exitcode, error(r.output) 767\\| 768\\| if message is not None: 769\\| with Then( 770\\| f"output should contain message", description=message 771\\| ) if steps else NullStep(): 772\\|> assert message in r.output, error(r.output) 773\\| 774\\| if not ignore_exception: 775\\| if message is None or "Exception:" not in message:
/window functions/tests/distributed/frame clause/range frame/order by decimal	XFail 160ms 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 228, in regression() File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 224, 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 72, 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 1733, in feature Scenario(run=scenario, flags=TE) File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_frame.py", line 1649, in order_by_decimal execute_query( File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/common.py", line 140, in execute_query r = current().context.node.query( File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 780, in query assert False, error(r.output) AssertionError: Oops! Assertion failed The following assertion was not satisfied assert False, error(r.output) Description Received exception from server (version 22.8.15): Code: 48. DB::Exception: Received from localhost:9000. DB::Exception: The RANGE OFFSET frame for 'DB::ColumnDecimal >' ORDER BY column is not implemented. (NOT_IMPLEMENTED) (query: select id, f_numeric, first_value(id) over w AS first_value, last_value(id) over w AS last_value from numerics window w as (order by f_numeric range between 1 preceding and 1 following) FORMAT TabSeparatedWithNames ) Assertion values assert False, error(r.output) ^ is False Where File '/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py', line 780 in 'query' 772\\| assert message in r.output, error(r.output) 773\\| 774\\| if not ignore_exception: 775\\| if message is None or "Exception:" not in message: 776\\| with Then("check if output has exception") if steps else NullStep(): 777\\| if "Exception:" in r.output: 778\\| if raise_on_exception: 779\\| raise QueryRuntimeException(r.output) 780\\|> assert False, error(r.output) 781\\| 782\\| return r 783\\|
/window functions/tests/distributed/frame clause/range frame/with nulls	XFail 206ms 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 228, in regression() File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 224, 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 72, 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 1733, in feature Scenario(run=scenario, flags=TE) File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_frame.py", line 1708, in with_nulls execute_query( File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/common.py", line 140, in execute_query r = current().context.node.query( File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 780, in query assert False, error(r.output) AssertionError: Oops! Assertion failed The following assertion was not satisfied assert False, error(r.output) Description Received exception from server (version 22.8.15): Code: 48. DB::Exception: Received from localhost:9000. DB::Exception: The RANGE OFFSET frame for 'DB::ColumnNullable' ORDER BY column is not implemented. (NOT_IMPLEMENTED) (query: select x, y, first_value(y) over w AS first_value, last_value(y) over w AS last_value from (select number as x, x as y from numbers(1,5) union all select null, 42 union all select null, 43) window w as (order by x asc nulls first range between 2 preceding and 2 following) FORMAT TabSeparatedWithNames ) Assertion values assert False, error(r.output) ^ is False Where File '/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py', line 780 in 'query' 772\\| assert message in r.output, error(r.output) 773\\| 774\\| if not ignore_exception: 775\\| if message is None or "Exception:" not in message: 776\\| with Then("check if output has exception") if steps else NullStep(): 777\\| if "Exception:" in r.output: 778\\| if raise_on_exception: 779\\| raise QueryRuntimeException(r.output) 780\\|> assert False, error(r.output) 781\\| 782\\| return r 783\\|
/window functions/tests/distributed/frame clause/range overflow/negative overflow with Int16	XFail 179ms exception on conversion	AssertionError Traceback (most recent call last): File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 228, in regression() File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 224, 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 72, 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 140, in execute_query r = current().context.node.query( File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 780, in query assert False, error(r.output) AssertionError: Oops! Assertion failed The following assertion was not satisfied assert False, error(r.output) Description Received exception from server (version 22.8.15): Code: 69. DB::Exception: Received from localhost:9000. DB::Exception: Cannot convert value '2147450885': it cannot be represented as Int16. (ARGUMENT_OUT_OF_BOUND) (query: select number as x, last_value(x) over (order by toInt16(x) desc range between current row and 2147450885 following) as last_value from (SELECT -number - 32763 AS number FROM numbers(1, 3)) FORMAT TabSeparatedWithNames ) Assertion values assert False, error(r.output) ^ is False Where File '/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py', line 780 in 'query' 772\\| assert message in r.output, error(r.output) 773\\| 774\\| if not ignore_exception: 775\\| if message is None or "Exception:" not in message: 776\\| with Then("check if output has exception") if steps else NullStep(): 777\\| if "Exception:" in r.output: 778\\| if raise_on_exception: 779\\| raise QueryRuntimeException(r.output) 780\\|> assert False, error(r.output) 781\\| 782\\| return r 783\\|
/window functions/tests/distributed/frame clause/range overflow/positive overflow with Int16	XFail 127ms exception on conversion	AssertionError Traceback (most recent call last): File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 228, in regression() File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 224, 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 72, 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 140, in execute_query r = current().context.node.query( File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 780, in query assert False, error(r.output) AssertionError: Oops! Assertion failed The following assertion was not satisfied assert False, error(r.output) Description Received exception from server (version 22.8.15): Code: 69. DB::Exception: Received from localhost:9000. DB::Exception: Cannot convert value '2147450884': it cannot be represented as Int16. (ARGUMENT_OUT_OF_BOUND) (query: select number as x, last_value(x) over (order by toInt16(x) range between current row and 2147450884 following) AS last_value from numbers(32764, 3) FORMAT TabSeparatedWithNames ) Assertion values assert False, error(r.output) ^ is False Where File '/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py', line 780 in 'query' 772\\| assert message in r.output, error(r.output) 773\\| 774\\| if not ignore_exception: 775\\| if message is None or "Exception:" not in message: 776\\| with Then("check if output has exception") if steps else NullStep(): 777\\| if "Exception:" in r.output: 778\\| if raise_on_exception: 779\\| raise QueryRuntimeException(r.output) 780\\|> assert False, error(r.output) 781\\| 782\\| return r 783\\|
/window functions/tests/distributed/frame clause/range datetime/order by asc range between days preceding and days following	XFail 142ms https://github.com/ClickHouse/ClickHouse/issues/23902	AssertionError Traceback (most recent call last): File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 228, in regression() File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 224, 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 72, 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 29, in order_by_asc_range_between_days_preceding_and_days_following execute_query( File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/common.py", line 140, in execute_query r = current().context.node.query( File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 780, in query assert False, error(r.output) AssertionError: Oops! Assertion failed The following assertion was not satisfied assert False, error(r.output) Description Received exception from server (version 22.8.15): Code: 10. DB::Exception: Received from localhost:9000. DB::Exception: Not found column empno in block. There are only columns: salary, enroll_date, sum(salary) OVER (ORDER BY enroll_date ASC RANGE BETWEEN 365 PRECEDING AND 365 FOLLOWING). (NOT_FOUND_COLUMN_IN_BLOCK) (query: select sum(salary) over (order by enroll_date range between 365 preceding and 365 following) AS sum, salary, enroll_date from empsalary order by empno FORMAT TabSeparatedWithNames ) Assertion values assert False, error(r.output) ^ is False Where File '/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py', line 780 in 'query' 772\\| assert message in r.output, error(r.output) 773\\| 774\\| if not ignore_exception: 775\\| if message is None or "Exception:" not in message: 776\\| with Then("check if output has exception") if steps else NullStep(): 777\\| if "Exception:" in r.output: 778\\| if raise_on_exception: 779\\| raise QueryRuntimeException(r.output) 780\\|> assert False, error(r.output) 781\\| 782\\| return r 783\\|
/window functions/tests/distributed/frame clause/range datetime/order by desc range between days following and days following	XFail 188ms https://github.com/ClickHouse/ClickHouse/issues/23902	AssertionError Traceback (most recent call last): File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 228, in regression() File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 224, 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 72, 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 86, in order_by_desc_range_between_days_following_and_days_following execute_query( File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/common.py", line 140, in execute_query r = current().context.node.query( File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 780, in query assert False, error(r.output) AssertionError: Oops! Assertion failed The following assertion was not satisfied assert False, error(r.output) Description Received exception from server (version 22.8.15): Code: 10. DB::Exception: Received from localhost:9000. DB::Exception: Not found column empno in block. There are only columns: salary, enroll_date, sum(salary) OVER (ORDER BY enroll_date DESC RANGE BETWEEN 365 FOLLOWING AND 365 FOLLOWING). (NOT_FOUND_COLUMN_IN_BLOCK) (query: select sum(salary) over (order by enroll_date desc range between 365 following and 365 following) AS sum, salary, enroll_date from empsalary order by empno FORMAT TabSeparatedWithNames ) Assertion values assert False, error(r.output) ^ is False Where File '/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py', line 780 in 'query' 772\\| assert message in r.output, error(r.output) 773\\| 774\\| if not ignore_exception: 775\\| if message is None or "Exception:" not in message: 776\\| with Then("check if output has exception") if steps else NullStep(): 777\\| if "Exception:" in r.output: 778\\| if raise_on_exception: 779\\| raise QueryRuntimeException(r.output) 780\\|> assert False, error(r.output) 781\\| 782\\| return r 783\\|
/window functions/tests/distributed/frame clause/range datetime/order by desc range between days preceding and days following	XFail 136ms https://github.com/ClickHouse/ClickHouse/issues/23902	AssertionError Traceback (most recent call last): File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 228, in regression() File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 224, 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 72, 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 57, in order_by_desc_range_between_days_preceding_and_days_following execute_query( File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/common.py", line 140, in execute_query r = current().context.node.query( File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 780, in query assert False, error(r.output) AssertionError: Oops! Assertion failed The following assertion was not satisfied assert False, error(r.output) Description Received exception from server (version 22.8.15): Code: 10. DB::Exception: Received from localhost:9000. DB::Exception: Not found column empno in block. There are only columns: salary, enroll_date, sum(salary) OVER (ORDER BY enroll_date DESC RANGE BETWEEN 365 PRECEDING AND 365 FOLLOWING). (NOT_FOUND_COLUMN_IN_BLOCK) (query: select sum(salary) over (order by enroll_date desc range between 365 preceding and 365 following) AS sum, salary, enroll_date from empsalary order by empno FORMAT TabSeparatedWithNames ) Assertion values assert False, error(r.output) ^ is False Where File '/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py', line 780 in 'query' 772\\| assert message in r.output, error(r.output) 773\\| 774\\| if not ignore_exception: 775\\| if message is None or "Exception:" not in message: 776\\| with Then("check if output has exception") if steps else NullStep(): 777\\| if "Exception:" in r.output: 778\\| if raise_on_exception: 779\\| raise QueryRuntimeException(r.output) 780\\|> assert False, error(r.output) 781\\| 782\\| return r 783\\|
/window functions/tests/distributed/frame clause/range datetime/order by desc range between days preceding and days preceding	XFail 166ms https://github.com/ClickHouse/ClickHouse/issues/23902	AssertionError Traceback (most recent call last): File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 228, in regression() File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 224, 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 72, 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 115, in order_by_desc_range_between_days_preceding_and_days_preceding execute_query( File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/common.py", line 140, in execute_query r = current().context.node.query( File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 780, in query assert False, error(r.output) AssertionError: Oops! Assertion failed The following assertion was not satisfied assert False, error(r.output) Description Received exception from server (version 22.8.15): Code: 10. DB::Exception: Received from localhost:9000. DB::Exception: Not found column empno in block. There are only columns: salary, enroll_date, sum(salary) OVER (ORDER BY enroll_date DESC RANGE BETWEEN 365 PRECEDING AND 365 PRECEDING). (NOT_FOUND_COLUMN_IN_BLOCK) (query: select sum(salary) over (order by enroll_date desc range between 365 preceding and 365 preceding) AS sum, salary, enroll_date from empsalary order by empno FORMAT TabSeparatedWithNames ) Assertion values assert False, error(r.output) ^ is False Where File '/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py', line 780 in 'query' 772\\| assert message in r.output, error(r.output) 773\\| 774\\| if not ignore_exception: 775\\| if message is None or "Exception:" not in message: 776\\| with Then("check if output has exception") if steps else NullStep(): 777\\| if "Exception:" in r.output: 778\\| if raise_on_exception: 779\\| raise QueryRuntimeException(r.output) 780\\|> assert False, error(r.output) 781\\| 782\\| return r 783\\|
/window functions/tests/distributed/frame clause/range errors/error negative following offset	XFail 151ms https://github.com/ClickHouse/ClickHouse/issues/22442	AssertionError Traceback (most recent call last): File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 228, in regression() File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 224, 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 72, 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 772, in query assert message in r.output, error(r.output) AssertionError: Oops! Assertion failed The following assertion was not satisfied assert message in r.output, error(r.output) Description Received exception from server (version 22.8.15): Code: 36. DB::Exception: Received from localhost:9000. DB::Exception: Window frame start offset must be nonnegative, -2 given. (BAD_ARGUMENTS) (query: select max(enroll_date) over (order by salary range between 1 preceding and -2 following) AS max, salary, enroll_date from empsalary ) Assertion values assert message in r.output, error(r.output) ^ is 'DB::Exception: Frame end offset must be greater than zero, -2 given' assert message in r.output, error(r.output) ^ is assert message in r.output, error(r.output) ^ is = 'Received exception from server (version 22.8.15):\nCode: 36. DB::Exception: Received from localhost:9000. DB::Exception: Window frame start offset must be nonnegative, -2 given. (BAD_ARGUMENTS)\n(query: select max(enroll_date) over (order by salary range between 1 preceding and -2 following) AS max, salary, enroll_date from empsalary\n)' assert message in r.output, error(r.output) ^ is = False assert message in r.output, error(r.output) ^ is False Where File '/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py', line 772 in 'query' 764\\| if exitcode is not None: 765\\| with Then(f"exitcode should be {exitcode}") if steps else NullStep(): 766\\| assert r.exitcode == exitcode, error(r.output) 767\\| 768\\| if message is not None: 769\\| with Then( 770\\| f"output should contain message", description=message 771\\| ) if steps else NullStep(): 772\\|> assert message in r.output, error(r.output) 773\\| 774\\| if not ignore_exception: 775\\| if message is None or "Exception:" not in message:
/window functions/tests/distributed/frame clause/range errors/error negative preceding offset	XFail 126ms https://github.com/ClickHouse/ClickHouse/issues/22442	AssertionError Traceback (most recent call last): File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 228, in regression() File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 224, 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 72, 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 772, in query assert message in r.output, error(r.output) AssertionError: Oops! Assertion failed The following assertion was not satisfied assert message in r.output, error(r.output) Description Received exception from server (version 22.8.15): Code: 36. DB::Exception: Received from localhost:9000. DB::Exception: Window frame start offset must be nonnegative, -1 given. (BAD_ARGUMENTS) (query: select max(enroll_date) over (order by salary range between -1 preceding and 2 following) AS max, salary, enroll_date from empsalary ) Assertion values assert message in r.output, error(r.output) ^ is 'DB::Exception: Frame start offset must be greater than zero, -1 given' assert message in r.output, error(r.output) ^ is assert message in r.output, error(r.output) ^ is = 'Received exception from server (version 22.8.15):\nCode: 36. DB::Exception: Received from localhost:9000. DB::Exception: Window frame start offset must be nonnegative, -1 given. (BAD_ARGUMENTS)\n(query: select max(enroll_date) over (order by salary range between -1 preceding and 2 following) AS max, salary, enroll_date from empsalary\n)' assert message in r.output, error(r.output) ^ is = False assert message in r.output, error(r.output) ^ is False Where File '/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py', line 772 in 'query' 764\\| if exitcode is not None: 765\\| with Then(f"exitcode should be {exitcode}") if steps else NullStep(): 766\\| assert r.exitcode == exitcode, error(r.output) 767\\| 768\\| if message is not None: 769\\| with Then( 770\\| f"output should contain message", description=message 771\\| ) if steps else NullStep(): 772\\|> assert message in r.output, error(r.output) 773\\| 774\\| if not ignore_exception: 775\\| if message is None or "Exception:" not in message:

Test Name

Result

Message

/window functions/tests/non distributed/frame clause/range frame/between current row and unbounded following modifying named window

XFail 172ms
range with named window is not supported

AssertionError
Traceback (most recent call last):
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 228, in 
    regression()
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 224, 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 72, 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 1733, in feature
    Scenario(run=scenario, flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_frame.py", line 1520, in between_current_row_and_unbounded_following_modifying_named_window
    execute_query(
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/common.py", line 140, in execute_query
    r = current().context.node.query(
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 780, in query
    assert False, error(r.output)
AssertionError: Oops! Assertion failed

The following assertion was not satisfied
  assert False, error(r.output)

Description
  Received exception from server (version 22.8.15):
Code: 49. DB::Exception: Received from localhost:9000. DB::Exception: Sizes of sort description and actions are mismatched. (LOGICAL_ERROR)
(query: SELECT * FROM (SELECT sum(unique1) over (w range between current row and unbounded following) AS sum,unique1, four FROM tenk1 WHERE unique1 < 10 WINDOW w AS (order by four)) ORDER BY unique1 FORMAT TabSeparatedWithNames
)

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

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

772\|                  assert message in r.output, error(r.output)
773\|  
774\|          if not ignore_exception:
775\|              if message is None or "Exception:" not in message:
776\|                  with Then("check if output has exception") if steps else NullStep():
777\|                      if "Exception:" in r.output:
778\|                          if raise_on_exception:
779\|                              raise QueryRuntimeException(r.output)
780\|>                         assert False, error(r.output)
781\|  
782\|          return r
783\|

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

XFail 164ms
known bug

AssertionError
Traceback (most recent call last):
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 228, in 
    regression()
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 224, 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 72, 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 1733, in feature
    Scenario(run=scenario, flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_frame.py", line 1347, 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 140, in execute_query
    r = current().context.node.query(
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 780, in query
    assert False, error(r.output)
AssertionError: Oops! Assertion failed

The following assertion was not satisfied
  assert False, error(r.output)

Description
  Received exception from server (version 22.8.15):
Code: 36. DB::Exception: Received from localhost:9000. DB::Exception: Window frame 'RANGE BETWEEN 0 FOLLOWING AND CURRENT ROW' is invalid. (BAD_ARGUMENTS)
(query: SELECT number,sum(number) OVER (ORDER BY number RANGE BETWEEN 0 FOLLOWING AND CURRENT ROW) AS sum FROM values('number Int8', (1),(1),(2),(3)) FORMAT TabSeparatedWithNames
)

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

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

772\|                  assert message in r.output, error(r.output)
773\|  
774\|          if not ignore_exception:
775\|              if message is None or "Exception:" not in message:
776\|                  with Then("check if output has exception") if steps else NullStep():
777\|                      if "Exception:" in r.output:
778\|                          if raise_on_exception:
779\|                              raise QueryRuntimeException(r.output)
780\|>                         assert False, error(r.output)
781\|  
782\|          return r
783\|

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

XFail 124ms
invalid error message

AssertionError
Traceback (most recent call last):
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 228, in 
    regression()
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 224, 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 72, 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 1733, in feature
    Scenario(run=scenario, flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_frame.py", line 1211, in between_expr_following_and_expr_following_without_order_by_error
    self.context.node.query(
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 772, in query
    assert message in r.output, error(r.output)
AssertionError: Oops! Assertion failed

The following assertion was not satisfied
  assert message in r.output, error(r.output)

Description
  Received exception from server (version 22.8.15):
Code: 36. DB::Exception: Received from localhost:9000. DB::Exception: The RANGE OFFSET window frame requires exactly one ORDER BY column, 0 given. (BAD_ARGUMENTS)
(query: SELECT number,sum(number) OVER (RANGE BETWEEN 1 FOLLOWING AND 1 FOLLOWING) FROM values('number Int8', (1),(1),(2),(3))
)

Assertion values
  assert message in r.output, error(r.output)
         ^ is 'Exception: Window frame'
  assert message in r.output, error(r.output)
                    ^ is 
  assert message in r.output, error(r.output)
                    ^ is = "Received exception from server (version 22.8.15):\nCode: 36. DB::Exception: Received from localhost:9000. DB::Exception: The RANGE OFFSET window frame requires exactly one ORDER BY column, 0 given. (BAD_ARGUMENTS)\n(query: SELECT number,sum(number) OVER (RANGE BETWEEN 1 FOLLOWING AND 1 FOLLOWING) FROM values('number Int8', (1),(1),(2),(3))\n)"
  assert message in r.output, error(r.output)
                 ^ is = False
  assert message in r.output, error(r.output)
  ^ is False

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

764\|          if exitcode is not None:
765\|              with Then(f"exitcode should be {exitcode}") if steps else NullStep():
766\|                  assert r.exitcode == exitcode, error(r.output)
767\|  
768\|          if message is not None:
769\|              with Then(
770\|                  f"output should contain message", description=message
771\|              ) if steps else NullStep():
772\|>                 assert message in r.output, error(r.output)
773\|  
774\|          if not ignore_exception:
775\|              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 140ms
known bug

AssertionError
Traceback (most recent call last):
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 228, in 
    regression()
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 224, 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 72, 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 1733, in feature
    Scenario(run=scenario, flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_frame.py", line 1416, in between_expr_following_and_expr_preceding_with_order_by_zero_special_case
    execute_query(
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/common.py", line 140, in execute_query
    r = current().context.node.query(
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 780, in query
    assert False, error(r.output)
AssertionError: Oops! Assertion failed

The following assertion was not satisfied
  assert False, error(r.output)

Description
  Received exception from server (version 22.8.15):
Code: 36. DB::Exception: Received from localhost:9000. DB::Exception: Frame start offset 0 FOLLOWING does not precede the frame end offset 0 PRECEDING. (BAD_ARGUMENTS)
(query: SELECT number,sum(number) OVER (ORDER BY number RANGE BETWEEN 0 FOLLOWING AND 0 PRECEDING) AS sum FROM values('number Int8', (1),(1),(2),(3)) FORMAT TabSeparatedWithNames
)

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

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

772\|                  assert message in r.output, error(r.output)
773\|  
774\|          if not ignore_exception:
775\|              if message is None or "Exception:" not in message:
776\|                  with Then("check if output has exception") if steps else NullStep():
777\|                      if "Exception:" in r.output:
778\|                          if raise_on_exception:
779\|                              raise QueryRuntimeException(r.output)
780\|>                         assert False, error(r.output)
781\|  
782\|          return r
783\|

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

XFail 122ms
invalid error message

AssertionError
Traceback (most recent call last):
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 228, in 
    regression()
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 224, 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 72, 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 1733, in feature
    Scenario(run=scenario, flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_frame.py", line 1228, in between_expr_following_and_expr_preceding_without_order_by_error
    self.context.node.query(
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 772, in query
    assert message in r.output, error(r.output)
AssertionError: Oops! Assertion failed

The following assertion was not satisfied
  assert message in r.output, error(r.output)

Description
  Received exception from server (version 22.8.15):
Code: 36. DB::Exception: Received from localhost:9000. DB::Exception: Frame start offset 0 FOLLOWING does not precede the frame end offset 0 PRECEDING. (BAD_ARGUMENTS)
(query: SELECT number,sum(number) OVER (RANGE BETWEEN 0 FOLLOWING AND 0 PRECEDING) FROM values('number Int8', (1),(1),(2),(3))
)

Assertion values
  assert message in r.output, error(r.output)
         ^ is 'Exception: Window frame'
  assert message in r.output, error(r.output)
                    ^ is 
  assert message in r.output, error(r.output)
                    ^ is = "Received exception from server (version 22.8.15):\nCode: 36. DB::Exception: Received from localhost:9000. DB::Exception: Frame start offset 0 FOLLOWING does not precede the frame end offset 0 PRECEDING. (BAD_ARGUMENTS)\n(query: SELECT number,sum(number) OVER (RANGE BETWEEN 0 FOLLOWING AND 0 PRECEDING) FROM values('number Int8', (1),(1),(2),(3))\n)"
  assert message in r.output, error(r.output)
                 ^ is = False
  assert message in r.output, error(r.output)
  ^ is False

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

764\|          if exitcode is not None:
765\|              with Then(f"exitcode should be {exitcode}") if steps else NullStep():
766\|                  assert r.exitcode == exitcode, error(r.output)
767\|  
768\|          if message is not None:
769\|              with Then(
770\|                  f"output should contain message", description=message
771\|              ) if steps else NullStep():
772\|>                 assert message in r.output, error(r.output)
773\|  
774\|          if not ignore_exception:
775\|              if message is None or "Exception:" not in message:

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

XFail 170ms
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 228, in 
    regression()
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 224, 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 72, 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 1733, in feature
    Scenario(run=scenario, flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_frame.py", line 1649, in order_by_decimal
    execute_query(
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/common.py", line 140, in execute_query
    r = current().context.node.query(
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 780, in query
    assert False, error(r.output)
AssertionError: Oops! Assertion failed

The following assertion was not satisfied
  assert False, error(r.output)

Description
  Received exception from server (version 22.8.15):
Code: 48. DB::Exception: Received from localhost:9000. DB::Exception: The RANGE OFFSET frame for 'DB::ColumnDecimal >' ORDER BY column is not implemented. (NOT_IMPLEMENTED)
(query: select id, f_numeric, first_value(id) over w AS first_value, last_value(id) over w AS last_value
        from numerics
        window w as (order by f_numeric range between
                     1 preceding and 1 following)
         FORMAT TabSeparatedWithNames
)

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

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

772\|                  assert message in r.output, error(r.output)
773\|  
774\|          if not ignore_exception:
775\|              if message is None or "Exception:" not in message:
776\|                  with Then("check if output has exception") if steps else NullStep():
777\|                      if "Exception:" in r.output:
778\|                          if raise_on_exception:
779\|                              raise QueryRuntimeException(r.output)
780\|>                         assert False, error(r.output)
781\|  
782\|          return r
783\|

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

XFail 213ms
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 228, in 
    regression()
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 224, 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 72, 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 1733, in feature
    Scenario(run=scenario, flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_frame.py", line 1708, in with_nulls
    execute_query(
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/common.py", line 140, in execute_query
    r = current().context.node.query(
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 780, in query
    assert False, error(r.output)
AssertionError: Oops! Assertion failed

The following assertion was not satisfied
  assert False, error(r.output)

Description
  Received exception from server (version 22.8.15):
Code: 48. DB::Exception: Received from localhost:9000. DB::Exception: The RANGE OFFSET frame for 'DB::ColumnNullable' ORDER BY column is not implemented. (NOT_IMPLEMENTED)
(query: select x, y,
               first_value(y) over w AS first_value,
               last_value(y) over w AS last_value
        from
          (select number as x, x as y from numbers(1,5)
           union all select null, 42
           union all select null, 43)
        window w as
          (order by x asc nulls first range between 2 preceding and 2 following)
         FORMAT TabSeparatedWithNames
)

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

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

772\|                  assert message in r.output, error(r.output)
773\|  
774\|          if not ignore_exception:
775\|              if message is None or "Exception:" not in message:
776\|                  with Then("check if output has exception") if steps else NullStep():
777\|                      if "Exception:" in r.output:
778\|                          if raise_on_exception:
779\|                              raise QueryRuntimeException(r.output)
780\|>                         assert False, error(r.output)
781\|  
782\|          return r
783\|

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

XFail 153ms
exception on conversion

AssertionError
Traceback (most recent call last):
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 228, in 
    regression()
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 224, 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 72, 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 140, in execute_query
    r = current().context.node.query(
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 780, in query
    assert False, error(r.output)
AssertionError: Oops! Assertion failed

The following assertion was not satisfied
  assert False, error(r.output)

Description
  Received exception from server (version 22.8.15):
Code: 69. DB::Exception: Received from localhost:9000. DB::Exception: Cannot convert value '2147450885': it cannot be represented as Int16. (ARGUMENT_OUT_OF_BOUND)
(query: select number as x, last_value(x) over (order by toInt16(x) desc range between current row and 2147450885 following) as last_value
        from (SELECT -number - 32763 AS number FROM numbers(1, 3))
         FORMAT TabSeparatedWithNames
)

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

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

772\|                  assert message in r.output, error(r.output)
773\|  
774\|          if not ignore_exception:
775\|              if message is None or "Exception:" not in message:
776\|                  with Then("check if output has exception") if steps else NullStep():
777\|                      if "Exception:" in r.output:
778\|                          if raise_on_exception:
779\|                              raise QueryRuntimeException(r.output)
780\|>                         assert False, error(r.output)
781\|  
782\|          return r
783\|

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

XFail 157ms
exception on conversion

AssertionError
Traceback (most recent call last):
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 228, in 
    regression()
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 224, 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 72, 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 140, in execute_query
    r = current().context.node.query(
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 780, in query
    assert False, error(r.output)
AssertionError: Oops! Assertion failed

The following assertion was not satisfied
  assert False, error(r.output)

Description
  Received exception from server (version 22.8.15):
Code: 69. DB::Exception: Received from localhost:9000. DB::Exception: Cannot convert value '2147450884': it cannot be represented as Int16. (ARGUMENT_OUT_OF_BOUND)
(query: select number as x, last_value(x) over (order by toInt16(x) range between current row and 2147450884 following) AS last_value
        from numbers(32764, 3)
         FORMAT TabSeparatedWithNames
)

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

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

772\|                  assert message in r.output, error(r.output)
773\|  
774\|          if not ignore_exception:
775\|              if message is None or "Exception:" not in message:
776\|                  with Then("check if output has exception") if steps else NullStep():
777\|                      if "Exception:" in r.output:
778\|                          if raise_on_exception:
779\|                              raise QueryRuntimeException(r.output)
780\|>                         assert False, error(r.output)
781\|  
782\|          return r
783\|

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

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

AssertionError
Traceback (most recent call last):
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 228, in 
    regression()
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 224, 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 72, 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 772, in query
    assert message in r.output, error(r.output)
AssertionError: Oops! Assertion failed

The following assertion was not satisfied
  assert message in r.output, error(r.output)

Description
  Received exception from server (version 22.8.15):
Code: 36. DB::Exception: Received from localhost:9000. DB::Exception: Window frame start offset must be nonnegative, -2 given. (BAD_ARGUMENTS)
(query: select max(enroll_date) over (order by salary range between 1 preceding and -2 following) AS max, salary, enroll_date from empsalary
)

Assertion values
  assert message in r.output, error(r.output)
         ^ is 'DB::Exception: Frame end offset must be greater than zero, -2 given'
  assert message in r.output, error(r.output)
                    ^ is 
  assert message in r.output, error(r.output)
                    ^ is = 'Received exception from server (version 22.8.15):\nCode: 36. DB::Exception: Received from localhost:9000. DB::Exception: Window frame start offset must be nonnegative, -2 given. (BAD_ARGUMENTS)\n(query: select max(enroll_date) over (order by salary range between 1 preceding and -2 following) AS max, salary, enroll_date from empsalary\n)'
  assert message in r.output, error(r.output)
                 ^ is = False
  assert message in r.output, error(r.output)
  ^ is False

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

764\|          if exitcode is not None:
765\|              with Then(f"exitcode should be {exitcode}") if steps else NullStep():
766\|                  assert r.exitcode == exitcode, error(r.output)
767\|  
768\|          if message is not None:
769\|              with Then(
770\|                  f"output should contain message", description=message
771\|              ) if steps else NullStep():
772\|>                 assert message in r.output, error(r.output)
773\|  
774\|          if not ignore_exception:
775\|              if message is None or "Exception:" not in message:

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

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

AssertionError
Traceback (most recent call last):
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 228, in 
    regression()
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 224, 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 72, 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 772, in query
    assert message in r.output, error(r.output)
AssertionError: Oops! Assertion failed

The following assertion was not satisfied
  assert message in r.output, error(r.output)

Description
  Received exception from server (version 22.8.15):
Code: 36. DB::Exception: Received from localhost:9000. DB::Exception: Window frame start offset must be nonnegative, -1 given. (BAD_ARGUMENTS)
(query: select max(enroll_date) over (order by salary range between -1 preceding and 2 following) AS max, salary, enroll_date from empsalary
)

Assertion values
  assert message in r.output, error(r.output)
         ^ is 'DB::Exception: Frame start offset must be greater than zero, -1 given'
  assert message in r.output, error(r.output)
                    ^ is 
  assert message in r.output, error(r.output)
                    ^ is = 'Received exception from server (version 22.8.15):\nCode: 36. DB::Exception: Received from localhost:9000. DB::Exception: Window frame start offset must be nonnegative, -1 given. (BAD_ARGUMENTS)\n(query: select max(enroll_date) over (order by salary range between -1 preceding and 2 following) AS max, salary, enroll_date from empsalary\n)'
  assert message in r.output, error(r.output)
                 ^ is = False
  assert message in r.output, error(r.output)
  ^ is False

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

764\|          if exitcode is not None:
765\|              with Then(f"exitcode should be {exitcode}") if steps else NullStep():
766\|                  assert r.exitcode == exitcode, error(r.output)
767\|  
768\|          if message is not None:
769\|              with Then(
770\|                  f"output should contain message", description=message
771\|              ) if steps else NullStep():
772\|>                 assert message in r.output, error(r.output)
773\|  
774\|          if not ignore_exception:
775\|              if message is None or "Exception:" not in message:

/window functions/tests/distributed/frame clause/range frame/between current row and unbounded following modifying named window

XFail 125ms
range with named window is not supported

AssertionError
Traceback (most recent call last):
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 228, in 
    regression()
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 224, 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 72, 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 1733, in feature
    Scenario(run=scenario, flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_frame.py", line 1520, in between_current_row_and_unbounded_following_modifying_named_window
    execute_query(
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/common.py", line 152, in execute_query
    assert r.output.strip() == expected, error()
AssertionError: Oops! Assertion failed

The following assertion was not satisfied
  assert r.output.strip() == expected, error()

Assertion values
  assert r.output.strip() == expected, error()
         ^ is 
  assert r.output.strip() == expected, error()
         ^ is = 'sum\tunique1\tfour\n45\t0\t0\n33\t1\t1\n18\t2\t2\n10\t3\t3\n45\t4\t0\n33\t5\t1\n18\t6\t2\n10\t7\t3\n45\t8\t0\n33\t9\t1'
  assert r.output.strip() == expected, error()
         ^ is 'sum\tunique1\tfour\n45\t0\t0\n33\t1\t1\n18\t2\t2\n10\t3\t3\n45\t4\t0\n33\t5\t1\n18\t6\t2\n10\t7\t3\n45\t8\t0\n33\t9\t1'
  assert r.output.strip() == expected, error()
         ^ is = 
  assert r.output.strip() == expected, error()
         ^ is = 'sum\tunique1\tfour\n45\t0\t0\n33\t1\t1\n18\t2\t2\n10\t3\t3\n45\t4\t0\n33\t5\t1\n18\t6\t2\n10\t7\t3\n45\t8\t0\n33\t9\t1'
  assert r.output.strip() == expected, error()
                             ^ is 'sum\tunique1\tfour\n45\t0\t0\n45\t8\t0\n45\t4\t0\n33\t5\t1\n33\t9\t1\n33\t1\t1\n18\t6\t2\n18\t2\t2\n10\t3\t3\n10\t7\t3'
  assert r.output.strip() == expected, error()
                          ^ is = False
    @@ -2,0 +3,4 @@
    +45 8   0
    +45 4   0
    +33 5   1
    +33 9   1
    @@ -3,0 +8 @@
    +18 6   2
    @@ -6,3 +10,0 @@
    -45 4   0
    -33 5   1
    -18 6   2
    @@ -10,2 +11,0 @@
    -45 8   0
    -33 9   1
  assert r.output.strip() == expected, error()
  ^ is False

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

144\|              no_checks=no_checks,
145\|          )
146\|          if no_checks:
147\|              return r
148\|  
149\|      if message is None:
150\|          if expected is not None:
151\|              with Then("I check output against expected"):
152\|>                 assert r.output.strip() == expected, error()
153\|          else:
154\|              with Then("I check output against snapshot"):
155\|                  with values() as that:

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

XFail 127ms
known bug

AssertionError
Traceback (most recent call last):
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 228, in 
    regression()
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 224, 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 72, 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 1733, in feature
    Scenario(run=scenario, flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_frame.py", line 1347, 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 140, in execute_query
    r = current().context.node.query(
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 780, in query
    assert False, error(r.output)
AssertionError: Oops! Assertion failed

The following assertion was not satisfied
  assert False, error(r.output)

Description
  Received exception from server (version 22.8.15):
Code: 36. DB::Exception: Received from localhost:9000. DB::Exception: Window frame 'RANGE BETWEEN 0 FOLLOWING AND CURRENT ROW' is invalid. (BAD_ARGUMENTS)
(query: SELECT number,sum(number) OVER (ORDER BY number RANGE BETWEEN 0 FOLLOWING AND CURRENT ROW) AS sum FROM values('number Int8', (1),(1),(2),(3)) FORMAT TabSeparatedWithNames
)

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

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

772\|                  assert message in r.output, error(r.output)
773\|  
774\|          if not ignore_exception:
775\|              if message is None or "Exception:" not in message:
776\|                  with Then("check if output has exception") if steps else NullStep():
777\|                      if "Exception:" in r.output:
778\|                          if raise_on_exception:
779\|                              raise QueryRuntimeException(r.output)
780\|>                         assert False, error(r.output)
781\|  
782\|          return r
783\|

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

XFail 167ms
invalid error message

AssertionError
Traceback (most recent call last):
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 228, in 
    regression()
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 224, 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 72, 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 1733, in feature
    Scenario(run=scenario, flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_frame.py", line 1211, in between_expr_following_and_expr_following_without_order_by_error
    self.context.node.query(
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 772, in query
    assert message in r.output, error(r.output)
AssertionError: Oops! Assertion failed

The following assertion was not satisfied
  assert message in r.output, error(r.output)

Description
  Received exception from server (version 22.8.15):
Code: 36. DB::Exception: Received from localhost:9000. DB::Exception: The RANGE OFFSET window frame requires exactly one ORDER BY column, 0 given. (BAD_ARGUMENTS)
(query: SELECT number,sum(number) OVER (RANGE BETWEEN 1 FOLLOWING AND 1 FOLLOWING) FROM values('number Int8', (1),(1),(2),(3))
)

Assertion values
  assert message in r.output, error(r.output)
         ^ is 'Exception: Window frame'
  assert message in r.output, error(r.output)
                    ^ is 
  assert message in r.output, error(r.output)
                    ^ is = "Received exception from server (version 22.8.15):\nCode: 36. DB::Exception: Received from localhost:9000. DB::Exception: The RANGE OFFSET window frame requires exactly one ORDER BY column, 0 given. (BAD_ARGUMENTS)\n(query: SELECT number,sum(number) OVER (RANGE BETWEEN 1 FOLLOWING AND 1 FOLLOWING) FROM values('number Int8', (1),(1),(2),(3))\n)"
  assert message in r.output, error(r.output)
                 ^ is = False
  assert message in r.output, error(r.output)
  ^ is False

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

764\|          if exitcode is not None:
765\|              with Then(f"exitcode should be {exitcode}") if steps else NullStep():
766\|                  assert r.exitcode == exitcode, error(r.output)
767\|  
768\|          if message is not None:
769\|              with Then(
770\|                  f"output should contain message", description=message
771\|              ) if steps else NullStep():
772\|>                 assert message in r.output, error(r.output)
773\|  
774\|          if not ignore_exception:
775\|              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 125ms
known bug

AssertionError
Traceback (most recent call last):
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 228, in 
    regression()
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 224, 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 72, 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 1733, in feature
    Scenario(run=scenario, flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_frame.py", line 1416, in between_expr_following_and_expr_preceding_with_order_by_zero_special_case
    execute_query(
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/common.py", line 140, in execute_query
    r = current().context.node.query(
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 780, in query
    assert False, error(r.output)
AssertionError: Oops! Assertion failed

The following assertion was not satisfied
  assert False, error(r.output)

Description
  Received exception from server (version 22.8.15):
Code: 36. DB::Exception: Received from localhost:9000. DB::Exception: Frame start offset 0 FOLLOWING does not precede the frame end offset 0 PRECEDING. (BAD_ARGUMENTS)
(query: SELECT number,sum(number) OVER (ORDER BY number RANGE BETWEEN 0 FOLLOWING AND 0 PRECEDING) AS sum FROM values('number Int8', (1),(1),(2),(3)) FORMAT TabSeparatedWithNames
)

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

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

772\|                  assert message in r.output, error(r.output)
773\|  
774\|          if not ignore_exception:
775\|              if message is None or "Exception:" not in message:
776\|                  with Then("check if output has exception") if steps else NullStep():
777\|                      if "Exception:" in r.output:
778\|                          if raise_on_exception:
779\|                              raise QueryRuntimeException(r.output)
780\|>                         assert False, error(r.output)
781\|  
782\|          return r
783\|

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

XFail 184ms
invalid error message

AssertionError
Traceback (most recent call last):
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 228, in 
    regression()
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 224, 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 72, 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 1733, in feature
    Scenario(run=scenario, flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_frame.py", line 1228, in between_expr_following_and_expr_preceding_without_order_by_error
    self.context.node.query(
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 772, in query
    assert message in r.output, error(r.output)
AssertionError: Oops! Assertion failed

The following assertion was not satisfied
  assert message in r.output, error(r.output)

Description
  Received exception from server (version 22.8.15):
Code: 36. DB::Exception: Received from localhost:9000. DB::Exception: Frame start offset 0 FOLLOWING does not precede the frame end offset 0 PRECEDING. (BAD_ARGUMENTS)
(query: SELECT number,sum(number) OVER (RANGE BETWEEN 0 FOLLOWING AND 0 PRECEDING) FROM values('number Int8', (1),(1),(2),(3))
)

Assertion values
  assert message in r.output, error(r.output)
         ^ is 'Exception: Window frame'
  assert message in r.output, error(r.output)
                    ^ is 
  assert message in r.output, error(r.output)
                    ^ is = "Received exception from server (version 22.8.15):\nCode: 36. DB::Exception: Received from localhost:9000. DB::Exception: Frame start offset 0 FOLLOWING does not precede the frame end offset 0 PRECEDING. (BAD_ARGUMENTS)\n(query: SELECT number,sum(number) OVER (RANGE BETWEEN 0 FOLLOWING AND 0 PRECEDING) FROM values('number Int8', (1),(1),(2),(3))\n)"
  assert message in r.output, error(r.output)
                 ^ is = False
  assert message in r.output, error(r.output)
  ^ is False

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

764\|          if exitcode is not None:
765\|              with Then(f"exitcode should be {exitcode}") if steps else NullStep():
766\|                  assert r.exitcode == exitcode, error(r.output)
767\|  
768\|          if message is not None:
769\|              with Then(
770\|                  f"output should contain message", description=message
771\|              ) if steps else NullStep():
772\|>                 assert message in r.output, error(r.output)
773\|  
774\|          if not ignore_exception:
775\|              if message is None or "Exception:" not in message:

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

XFail 160ms
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 228, in 
    regression()
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 224, 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 72, 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 1733, in feature
    Scenario(run=scenario, flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_frame.py", line 1649, in order_by_decimal
    execute_query(
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/common.py", line 140, in execute_query
    r = current().context.node.query(
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 780, in query
    assert False, error(r.output)
AssertionError: Oops! Assertion failed

The following assertion was not satisfied
  assert False, error(r.output)

Description
  Received exception from server (version 22.8.15):
Code: 48. DB::Exception: Received from localhost:9000. DB::Exception: The RANGE OFFSET frame for 'DB::ColumnDecimal >' ORDER BY column is not implemented. (NOT_IMPLEMENTED)
(query: select id, f_numeric, first_value(id) over w AS first_value, last_value(id) over w AS last_value
        from numerics
        window w as (order by f_numeric range between
                     1 preceding and 1 following)
         FORMAT TabSeparatedWithNames
)

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

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

772\|                  assert message in r.output, error(r.output)
773\|  
774\|          if not ignore_exception:
775\|              if message is None or "Exception:" not in message:
776\|                  with Then("check if output has exception") if steps else NullStep():
777\|                      if "Exception:" in r.output:
778\|                          if raise_on_exception:
779\|                              raise QueryRuntimeException(r.output)
780\|>                         assert False, error(r.output)
781\|  
782\|          return r
783\|

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

XFail 206ms
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 228, in 
    regression()
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 224, 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 72, 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 1733, in feature
    Scenario(run=scenario, flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_frame.py", line 1708, in with_nulls
    execute_query(
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/common.py", line 140, in execute_query
    r = current().context.node.query(
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 780, in query
    assert False, error(r.output)
AssertionError: Oops! Assertion failed

The following assertion was not satisfied
  assert False, error(r.output)

Description
  Received exception from server (version 22.8.15):
Code: 48. DB::Exception: Received from localhost:9000. DB::Exception: The RANGE OFFSET frame for 'DB::ColumnNullable' ORDER BY column is not implemented. (NOT_IMPLEMENTED)
(query: select x, y,
               first_value(y) over w AS first_value,
               last_value(y) over w AS last_value
        from
          (select number as x, x as y from numbers(1,5)
           union all select null, 42
           union all select null, 43)
        window w as
          (order by x asc nulls first range between 2 preceding and 2 following)
         FORMAT TabSeparatedWithNames
)

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

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

772\|                  assert message in r.output, error(r.output)
773\|  
774\|          if not ignore_exception:
775\|              if message is None or "Exception:" not in message:
776\|                  with Then("check if output has exception") if steps else NullStep():
777\|                      if "Exception:" in r.output:
778\|                          if raise_on_exception:
779\|                              raise QueryRuntimeException(r.output)
780\|>                         assert False, error(r.output)
781\|  
782\|          return r
783\|

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

XFail 179ms
exception on conversion

AssertionError
Traceback (most recent call last):
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 228, in 
    regression()
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 224, 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 72, 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 140, in execute_query
    r = current().context.node.query(
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 780, in query
    assert False, error(r.output)
AssertionError: Oops! Assertion failed

The following assertion was not satisfied
  assert False, error(r.output)

Description
  Received exception from server (version 22.8.15):
Code: 69. DB::Exception: Received from localhost:9000. DB::Exception: Cannot convert value '2147450885': it cannot be represented as Int16. (ARGUMENT_OUT_OF_BOUND)
(query: select number as x, last_value(x) over (order by toInt16(x) desc range between current row and 2147450885 following) as last_value
        from (SELECT -number - 32763 AS number FROM numbers(1, 3))
         FORMAT TabSeparatedWithNames
)

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

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

772\|                  assert message in r.output, error(r.output)
773\|  
774\|          if not ignore_exception:
775\|              if message is None or "Exception:" not in message:
776\|                  with Then("check if output has exception") if steps else NullStep():
777\|                      if "Exception:" in r.output:
778\|                          if raise_on_exception:
779\|                              raise QueryRuntimeException(r.output)
780\|>                         assert False, error(r.output)
781\|  
782\|          return r
783\|

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

XFail 127ms
exception on conversion

AssertionError
Traceback (most recent call last):
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 228, in 
    regression()
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 224, 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 72, 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 140, in execute_query
    r = current().context.node.query(
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 780, in query
    assert False, error(r.output)
AssertionError: Oops! Assertion failed

The following assertion was not satisfied
  assert False, error(r.output)

Description
  Received exception from server (version 22.8.15):
Code: 69. DB::Exception: Received from localhost:9000. DB::Exception: Cannot convert value '2147450884': it cannot be represented as Int16. (ARGUMENT_OUT_OF_BOUND)
(query: select number as x, last_value(x) over (order by toInt16(x) range between current row and 2147450884 following) AS last_value
        from numbers(32764, 3)
         FORMAT TabSeparatedWithNames
)

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

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

772\|                  assert message in r.output, error(r.output)
773\|  
774\|          if not ignore_exception:
775\|              if message is None or "Exception:" not in message:
776\|                  with Then("check if output has exception") if steps else NullStep():
777\|                      if "Exception:" in r.output:
778\|                          if raise_on_exception:
779\|                              raise QueryRuntimeException(r.output)
780\|>                         assert False, error(r.output)
781\|  
782\|          return r
783\|

/window functions/tests/distributed/frame clause/range datetime/order by asc range between days preceding and days following

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

AssertionError
Traceback (most recent call last):
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 228, in 
    regression()
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 224, 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 72, 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 29, in order_by_asc_range_between_days_preceding_and_days_following
    execute_query(
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/common.py", line 140, in execute_query
    r = current().context.node.query(
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 780, in query
    assert False, error(r.output)
AssertionError: Oops! Assertion failed

The following assertion was not satisfied
  assert False, error(r.output)

Description
  Received exception from server (version 22.8.15):
Code: 10. DB::Exception: Received from localhost:9000. DB::Exception: Not found column empno in block. There are only columns: salary, enroll_date, sum(salary) OVER (ORDER BY enroll_date ASC RANGE BETWEEN 365 PRECEDING AND 365 FOLLOWING). (NOT_FOUND_COLUMN_IN_BLOCK)
(query: select sum(salary) over (order by enroll_date range between 365 preceding and 365 following) AS sum, salary, enroll_date from empsalary order by empno FORMAT TabSeparatedWithNames
)

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

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

772\|                  assert message in r.output, error(r.output)
773\|  
774\|          if not ignore_exception:
775\|              if message is None or "Exception:" not in message:
776\|                  with Then("check if output has exception") if steps else NullStep():
777\|                      if "Exception:" in r.output:
778\|                          if raise_on_exception:
779\|                              raise QueryRuntimeException(r.output)
780\|>                         assert False, error(r.output)
781\|  
782\|          return r
783\|

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

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

AssertionError
Traceback (most recent call last):
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 228, in 
    regression()
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 224, 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 72, 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 86, in order_by_desc_range_between_days_following_and_days_following
    execute_query(
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/common.py", line 140, in execute_query
    r = current().context.node.query(
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 780, in query
    assert False, error(r.output)
AssertionError: Oops! Assertion failed

The following assertion was not satisfied
  assert False, error(r.output)

Description
  Received exception from server (version 22.8.15):
Code: 10. DB::Exception: Received from localhost:9000. DB::Exception: Not found column empno in block. There are only columns: salary, enroll_date, sum(salary) OVER (ORDER BY enroll_date DESC RANGE BETWEEN 365 FOLLOWING AND 365 FOLLOWING). (NOT_FOUND_COLUMN_IN_BLOCK)
(query: select sum(salary) over (order by enroll_date desc range between 365 following and 365 following) AS sum, salary, enroll_date from empsalary order by empno FORMAT TabSeparatedWithNames
)

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

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

772\|                  assert message in r.output, error(r.output)
773\|  
774\|          if not ignore_exception:
775\|              if message is None or "Exception:" not in message:
776\|                  with Then("check if output has exception") if steps else NullStep():
777\|                      if "Exception:" in r.output:
778\|                          if raise_on_exception:
779\|                              raise QueryRuntimeException(r.output)
780\|>                         assert False, error(r.output)
781\|  
782\|          return r
783\|

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

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

AssertionError
Traceback (most recent call last):
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 228, in 
    regression()
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 224, 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 72, 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 57, in order_by_desc_range_between_days_preceding_and_days_following
    execute_query(
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/common.py", line 140, in execute_query
    r = current().context.node.query(
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 780, in query
    assert False, error(r.output)
AssertionError: Oops! Assertion failed

The following assertion was not satisfied
  assert False, error(r.output)

Description
  Received exception from server (version 22.8.15):
Code: 10. DB::Exception: Received from localhost:9000. DB::Exception: Not found column empno in block. There are only columns: salary, enroll_date, sum(salary) OVER (ORDER BY enroll_date DESC RANGE BETWEEN 365 PRECEDING AND 365 FOLLOWING). (NOT_FOUND_COLUMN_IN_BLOCK)
(query: select sum(salary) over (order by enroll_date desc range between 365 preceding and 365 following) AS sum, salary, enroll_date from empsalary order by empno FORMAT TabSeparatedWithNames
)

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

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

772\|                  assert message in r.output, error(r.output)
773\|  
774\|          if not ignore_exception:
775\|              if message is None or "Exception:" not in message:
776\|                  with Then("check if output has exception") if steps else NullStep():
777\|                      if "Exception:" in r.output:
778\|                          if raise_on_exception:
779\|                              raise QueryRuntimeException(r.output)
780\|>                         assert False, error(r.output)
781\|  
782\|          return r
783\|

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

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

AssertionError
Traceback (most recent call last):
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 228, in 
    regression()
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 224, 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 72, 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 115, in order_by_desc_range_between_days_preceding_and_days_preceding
    execute_query(
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/common.py", line 140, in execute_query
    r = current().context.node.query(
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 780, in query
    assert False, error(r.output)
AssertionError: Oops! Assertion failed

The following assertion was not satisfied
  assert False, error(r.output)

Description
  Received exception from server (version 22.8.15):
Code: 10. DB::Exception: Received from localhost:9000. DB::Exception: Not found column empno in block. There are only columns: salary, enroll_date, sum(salary) OVER (ORDER BY enroll_date DESC RANGE BETWEEN 365 PRECEDING AND 365 PRECEDING). (NOT_FOUND_COLUMN_IN_BLOCK)
(query: select sum(salary) over (order by enroll_date desc range between 365 preceding and 365 preceding) AS sum, salary, enroll_date from empsalary order by empno FORMAT TabSeparatedWithNames
)

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

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

772\|                  assert message in r.output, error(r.output)
773\|  
774\|          if not ignore_exception:
775\|              if message is None or "Exception:" not in message:
776\|                  with Then("check if output has exception") if steps else NullStep():
777\|                      if "Exception:" in r.output:
778\|                          if raise_on_exception:
779\|                              raise QueryRuntimeException(r.output)
780\|>                         assert False, error(r.output)
781\|  
782\|          return r
783\|

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

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

AssertionError
Traceback (most recent call last):
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 228, in 
    regression()
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 224, 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 72, 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 772, in query
    assert message in r.output, error(r.output)
AssertionError: Oops! Assertion failed

The following assertion was not satisfied
  assert message in r.output, error(r.output)

Description
  Received exception from server (version 22.8.15):
Code: 36. DB::Exception: Received from localhost:9000. DB::Exception: Window frame start offset must be nonnegative, -2 given. (BAD_ARGUMENTS)
(query: select max(enroll_date) over (order by salary range between 1 preceding and -2 following) AS max, salary, enroll_date from empsalary
)

Assertion values
  assert message in r.output, error(r.output)
         ^ is 'DB::Exception: Frame end offset must be greater than zero, -2 given'
  assert message in r.output, error(r.output)
                    ^ is 
  assert message in r.output, error(r.output)
                    ^ is = 'Received exception from server (version 22.8.15):\nCode: 36. DB::Exception: Received from localhost:9000. DB::Exception: Window frame start offset must be nonnegative, -2 given. (BAD_ARGUMENTS)\n(query: select max(enroll_date) over (order by salary range between 1 preceding and -2 following) AS max, salary, enroll_date from empsalary\n)'
  assert message in r.output, error(r.output)
                 ^ is = False
  assert message in r.output, error(r.output)
  ^ is False

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

764\|          if exitcode is not None:
765\|              with Then(f"exitcode should be {exitcode}") if steps else NullStep():
766\|                  assert r.exitcode == exitcode, error(r.output)
767\|  
768\|          if message is not None:
769\|              with Then(
770\|                  f"output should contain message", description=message
771\|              ) if steps else NullStep():
772\|>                 assert message in r.output, error(r.output)
773\|  
774\|          if not ignore_exception:
775\|              if message is None or "Exception:" not in message:

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

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

AssertionError
Traceback (most recent call last):
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 228, in 
    regression()
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 224, 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 72, 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 772, in query
    assert message in r.output, error(r.output)
AssertionError: Oops! Assertion failed

The following assertion was not satisfied
  assert message in r.output, error(r.output)

Description
  Received exception from server (version 22.8.15):
Code: 36. DB::Exception: Received from localhost:9000. DB::Exception: Window frame start offset must be nonnegative, -1 given. (BAD_ARGUMENTS)
(query: select max(enroll_date) over (order by salary range between -1 preceding and 2 following) AS max, salary, enroll_date from empsalary
)

Assertion values
  assert message in r.output, error(r.output)
         ^ is 'DB::Exception: Frame start offset must be greater than zero, -1 given'
  assert message in r.output, error(r.output)
                    ^ is 
  assert message in r.output, error(r.output)
                    ^ is = 'Received exception from server (version 22.8.15):\nCode: 36. DB::Exception: Received from localhost:9000. DB::Exception: Window frame start offset must be nonnegative, -1 given. (BAD_ARGUMENTS)\n(query: select max(enroll_date) over (order by salary range between -1 preceding and 2 following) AS max, salary, enroll_date from empsalary\n)'
  assert message in r.output, error(r.output)
                 ^ is = False
  assert message in r.output, error(r.output)
  ^ is False

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

764\|          if exitcode is not None:
765\|              with Then(f"exitcode should be {exitcode}") if steps else NullStep():
766\|                  assert r.exitcode == exitcode, error(r.output)
767\|  
768\|          if message is not None:
769\|              with Then(
770\|                  f"output should contain message", description=message
771\|              ) if steps else NullStep():
772\|>                 assert message in r.output, error(r.output)
773\|  
774\|          if not ignore_exception:
775\|              if message is None or "Exception:" not in message:

Date	Sep 19, 2023 8:00
Duration	8m 57s
Framework	TestFlows 1.9.230315.1003122

project	Altinity/ClickHouse
project.id	159717931
package	https://s3.amazonaws.com/altinity-build-artifacts/265/6b52da82b6ca003e8ebd34ead5f4eabbc45d1cd6/package_aarch64/clickhouse-common-static_22.8.15.25.altinitystable_arm64.deb
version	22.8.15.25.altinitystable
user.name	MyroTk
repository	https://github.com/Altinity/clickhouse-regression
commit.hash	c23ebf091e566342377fb79fbd78ac3f7a42e678
job.id	6231175917
job.url	https://github.com/Altinity/ClickHouse/actions/runs/6231175917
arch	aarch64
stress	False
local	True
clickhouse_version	None
clickhouse_binary_path	https://s3.amazonaws.com/altinity-build-artifacts/265/6b52da82b6ca003e8ebd34ead5f4eabbc45d1cd6/package_aarch64/clickhouse-common-static_22.8.15.25.altinitystable_arm64.deb
collect_service_logs	True

Window Functions Test Run Report

Artifacts

Attributes

Summary

Statistics

Known Fails

Results