Document status - Confidential

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

Window Functions Test Run Report

DateSep 16, 2022 23:06
Duration4m 26s
Framework TestFlows 1.9.220810.1192506

Artifacts

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

Attributes

projectaltinity-qa/clickhouse/cicd/release
project.id22089296
user.nameAndrey Zvonov
user.emailzvonov.andrey@gmail.com
version22.3.10.24
repositoryhttps://github.com/Altinity/ClickHouse.git
job.id3041775536
job.urlhttps://gitlab.com/altinity-qa/clickhouse/cicd/release/-/jobs/3041775536
stressFalse
localTrue
clickhouse_versionNone
clickhouse_binary_path/usr/bin/clickhouse

Tags

altinity-docker-runner

Summary

97.3%OK
2.5%Known

Statistics

Units Skip OK Fail XFail
Modules
1
1
Suites
39
2
37
Features
39
2
37
Scenarios
430
400
30
Checks
200
200
Examples
1346
1324
22
Steps
7029
6946
83

Known Fails

Test NameResultMessage
/window functions/tests/non distributed/frame clause/range frame/between current row and unbounded following modifying named windowXFail 61ms
range with named window is not supported
AssertionError
Traceback (most recent call last):
  File "regression/window_functions/regression.py", line 203, in 
    regression()
  File "regression/window_functions/regression.py", line 199, in regression
    Feature(run=load("window_functions.tests.feature", "feature"), flags=TE)
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/feature.py", line 72, in feature
    Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE)
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/frame_clause.py", line 68, in feature
    Feature(run=load("window_functions.tests.range_frame", "feature"), flags=TE)
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/range_frame.py", line 1733, in feature
    Scenario(run=scenario, flags=TE)
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/range_frame.py", line 1520, in between_current_row_and_unbounded_following_modifying_named_window
    execute_query(
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/common.py", line 140, in execute_query
    r = current().context.node.query(
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../helpers/cluster.py", line 653, in query
    assert False, error(r.output)
AssertionError: Oops! Assertion failed

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

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

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

Where
  File '/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../helpers/cluster.py', line 653 in 'query'

645\|              ) if steps else NullStep():
646\|                  assert message in r.output, error(r.output)
647\|  
648\|          if message is None or "Exception:" not in message:
649\|              with Then("check if output has exception") if steps else NullStep():
650\|                  if "Exception:" in r.output:
651\|                      if raise_on_exception:
652\|                          raise QueryRuntimeException(r.output)
653\|>                     assert False, error(r.output)
654\|  
655\|          return r
656\|
/window functions/tests/non distributed/frame clause/range frame/between expr following and current row zero special caseXFail 39ms
known bug
AssertionError
Traceback (most recent call last):
  File "regression/window_functions/regression.py", line 203, in 
    regression()
  File "regression/window_functions/regression.py", line 199, in regression
    Feature(run=load("window_functions.tests.feature", "feature"), flags=TE)
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/feature.py", line 72, in feature
    Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE)
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/frame_clause.py", line 68, in feature
    Feature(run=load("window_functions.tests.range_frame", "feature"), flags=TE)
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/range_frame.py", line 1733, in feature
    Scenario(run=scenario, flags=TE)
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/range_frame.py", line 1347, in between_expr_following_and_current_row_zero_special_case
    execute_query(
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/common.py", line 140, in execute_query
    r = current().context.node.query(
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../helpers/cluster.py", line 653, in query
    assert False, error(r.output)
AssertionError: Oops! Assertion failed

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

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

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

Where
  File '/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../helpers/cluster.py', line 653 in 'query'

645\|              ) if steps else NullStep():
646\|                  assert message in r.output, error(r.output)
647\|  
648\|          if message is None or "Exception:" not in message:
649\|              with Then("check if output has exception") if steps else NullStep():
650\|                  if "Exception:" in r.output:
651\|                      if raise_on_exception:
652\|                          raise QueryRuntimeException(r.output)
653\|>                     assert False, error(r.output)
654\|  
655\|          return r
656\|
/window functions/tests/non distributed/frame clause/range frame/between expr following and expr following without order by errorXFail 38ms
invalid error message
AssertionError
Traceback (most recent call last):
  File "regression/window_functions/regression.py", line 203, in 
    regression()
  File "regression/window_functions/regression.py", line 199, in regression
    Feature(run=load("window_functions.tests.feature", "feature"), flags=TE)
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/feature.py", line 72, in feature
    Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE)
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/frame_clause.py", line 68, in feature
    Feature(run=load("window_functions.tests.range_frame", "feature"), flags=TE)
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/range_frame.py", line 1733, in feature
    Scenario(run=scenario, flags=TE)
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/range_frame.py", line 1211, in between_expr_following_and_expr_following_without_order_by_error
    self.context.node.query(
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../helpers/cluster.py", line 646, in query
    assert message in r.output, error(r.output)
AssertionError: Oops! Assertion failed

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

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

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

Where
  File '/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../helpers/cluster.py', line 646 in 'query'

638\|          if exitcode is not None:
639\|              with Then(f"exitcode should be {exitcode}") if steps else NullStep():
640\|                  assert r.exitcode == exitcode, error(r.output)
641\|  
642\|          if message is not None:
643\|              with Then(
644\|                  f"output should contain message", description=message
645\|              ) if steps else NullStep():
646\|>                 assert message in r.output, error(r.output)
647\|  
648\|          if message is None or "Exception:" not in message:
649\|              with Then("check if output has exception") if steps else NullStep():
/window functions/tests/non distributed/frame clause/range frame/between expr following and expr preceding with order by zero special caseXFail 38ms
known bug
AssertionError
Traceback (most recent call last):
  File "regression/window_functions/regression.py", line 203, in 
    regression()
  File "regression/window_functions/regression.py", line 199, in regression
    Feature(run=load("window_functions.tests.feature", "feature"), flags=TE)
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/feature.py", line 72, in feature
    Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE)
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/frame_clause.py", line 68, in feature
    Feature(run=load("window_functions.tests.range_frame", "feature"), flags=TE)
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/range_frame.py", line 1733, in feature
    Scenario(run=scenario, flags=TE)
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/range_frame.py", line 1416, in between_expr_following_and_expr_preceding_with_order_by_zero_special_case
    execute_query(
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/common.py", line 140, in execute_query
    r = current().context.node.query(
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../helpers/cluster.py", line 653, in query
    assert False, error(r.output)
AssertionError: Oops! Assertion failed

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

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

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

Where
  File '/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../helpers/cluster.py', line 653 in 'query'

645\|              ) if steps else NullStep():
646\|                  assert message in r.output, error(r.output)
647\|  
648\|          if message is None or "Exception:" not in message:
649\|              with Then("check if output has exception") if steps else NullStep():
650\|                  if "Exception:" in r.output:
651\|                      if raise_on_exception:
652\|                          raise QueryRuntimeException(r.output)
653\|>                     assert False, error(r.output)
654\|  
655\|          return r
656\|
/window functions/tests/non distributed/frame clause/range frame/between expr following and expr preceding without order by errorXFail 38ms
invalid error message
AssertionError
Traceback (most recent call last):
  File "regression/window_functions/regression.py", line 203, in 
    regression()
  File "regression/window_functions/regression.py", line 199, in regression
    Feature(run=load("window_functions.tests.feature", "feature"), flags=TE)
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/feature.py", line 72, in feature
    Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE)
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/frame_clause.py", line 68, in feature
    Feature(run=load("window_functions.tests.range_frame", "feature"), flags=TE)
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/range_frame.py", line 1733, in feature
    Scenario(run=scenario, flags=TE)
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/range_frame.py", line 1228, in between_expr_following_and_expr_preceding_without_order_by_error
    self.context.node.query(
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../helpers/cluster.py", line 646, in query
    assert message in r.output, error(r.output)
AssertionError: Oops! Assertion failed

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

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

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

Where
  File '/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../helpers/cluster.py', line 646 in 'query'

638\|          if exitcode is not None:
639\|              with Then(f"exitcode should be {exitcode}") if steps else NullStep():
640\|                  assert r.exitcode == exitcode, error(r.output)
641\|  
642\|          if message is not None:
643\|              with Then(
644\|                  f"output should contain message", description=message
645\|              ) if steps else NullStep():
646\|>                 assert message in r.output, error(r.output)
647\|  
648\|          if message is None or "Exception:" not in message:
649\|              with Then("check if output has exception") if steps else NullStep():
/window functions/tests/non distributed/frame clause/range frame/order by decimalXFail 41ms
Exception: The RANGE OFFSET frame for 'DB::ColumnDecimal >' ORDER BY column is not implemented
AssertionError
Traceback (most recent call last):
  File "regression/window_functions/regression.py", line 203, in 
    regression()
  File "regression/window_functions/regression.py", line 199, in regression
    Feature(run=load("window_functions.tests.feature", "feature"), flags=TE)
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/feature.py", line 72, in feature
    Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE)
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/frame_clause.py", line 68, in feature
    Feature(run=load("window_functions.tests.range_frame", "feature"), flags=TE)
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/range_frame.py", line 1733, in feature
    Scenario(run=scenario, flags=TE)
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/range_frame.py", line 1649, in order_by_decimal
    execute_query(
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/common.py", line 140, in execute_query
    r = current().context.node.query(
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../helpers/cluster.py", line 653, in query
    assert False, error(r.output)
AssertionError: Oops! Assertion failed

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

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

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

Where
  File '/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../helpers/cluster.py', line 653 in 'query'

645\|              ) if steps else NullStep():
646\|                  assert message in r.output, error(r.output)
647\|  
648\|          if message is None or "Exception:" not in message:
649\|              with Then("check if output has exception") if steps else NullStep():
650\|                  if "Exception:" in r.output:
651\|                      if raise_on_exception:
652\|                          raise QueryRuntimeException(r.output)
653\|>                     assert False, error(r.output)
654\|  
655\|          return r
656\|
/window functions/tests/non distributed/frame clause/range frame/with nullsXFail 43ms
DB::Exception: The RANGE OFFSET frame for 'DB::ColumnNullable' ORDER BY column is not implemented
AssertionError
Traceback (most recent call last):
  File "regression/window_functions/regression.py", line 203, in 
    regression()
  File "regression/window_functions/regression.py", line 199, in regression
    Feature(run=load("window_functions.tests.feature", "feature"), flags=TE)
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/feature.py", line 72, in feature
    Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE)
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/frame_clause.py", line 68, in feature
    Feature(run=load("window_functions.tests.range_frame", "feature"), flags=TE)
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/range_frame.py", line 1733, in feature
    Scenario(run=scenario, flags=TE)
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/range_frame.py", line 1708, in with_nulls
    execute_query(
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/common.py", line 140, in execute_query
    r = current().context.node.query(
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../helpers/cluster.py", line 653, in query
    assert False, error(r.output)
AssertionError: Oops! Assertion failed

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

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

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

Where
  File '/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../helpers/cluster.py', line 653 in 'query'

645\|              ) if steps else NullStep():
646\|                  assert message in r.output, error(r.output)
647\|  
648\|          if message is None or "Exception:" not in message:
649\|              with Then("check if output has exception") if steps else NullStep():
650\|                  if "Exception:" in r.output:
651\|                      if raise_on_exception:
652\|                          raise QueryRuntimeException(r.output)
653\|>                     assert False, error(r.output)
654\|  
655\|          return r
656\|
/window functions/tests/non distributed/frame clause/range overflow/negative overflow with Int16XFail 41ms
exception on conversion
AssertionError
Traceback (most recent call last):
  File "regression/window_functions/regression.py", line 203, in 
    regression()
  File "regression/window_functions/regression.py", line 199, in regression
    Feature(run=load("window_functions.tests.feature", "feature"), flags=TE)
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/feature.py", line 72, in feature
    Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE)
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/frame_clause.py", line 69, in feature
    Feature(run=load("window_functions.tests.range_overflow", "feature"), flags=TE)
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/range_overflow.py", line 145, in feature
    Scenario(run=scenario, flags=TE)
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/range_overflow.py", line 42, in negative_overflow_with_Int16
    execute_query(
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/common.py", line 140, in execute_query
    r = current().context.node.query(
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../helpers/cluster.py", line 653, in query
    assert False, error(r.output)
AssertionError: Oops! Assertion failed

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

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

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

Where
  File '/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../helpers/cluster.py', line 653 in 'query'

645\|              ) if steps else NullStep():
646\|                  assert message in r.output, error(r.output)
647\|  
648\|          if message is None or "Exception:" not in message:
649\|              with Then("check if output has exception") if steps else NullStep():
650\|                  if "Exception:" in r.output:
651\|                      if raise_on_exception:
652\|                          raise QueryRuntimeException(r.output)
653\|>                     assert False, error(r.output)
654\|  
655\|          return r
656\|
/window functions/tests/non distributed/frame clause/range overflow/positive overflow with Int16XFail 40ms
exception on conversion
AssertionError
Traceback (most recent call last):
  File "regression/window_functions/regression.py", line 203, in 
    regression()
  File "regression/window_functions/regression.py", line 199, in regression
    Feature(run=load("window_functions.tests.feature", "feature"), flags=TE)
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/feature.py", line 72, in feature
    Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE)
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/frame_clause.py", line 69, in feature
    Feature(run=load("window_functions.tests.range_overflow", "feature"), flags=TE)
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/range_overflow.py", line 145, in feature
    Scenario(run=scenario, flags=TE)
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/range_overflow.py", line 20, in positive_overflow_with_Int16
    execute_query(
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/common.py", line 140, in execute_query
    r = current().context.node.query(
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../helpers/cluster.py", line 653, in query
    assert False, error(r.output)
AssertionError: Oops! Assertion failed

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

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

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

Where
  File '/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../helpers/cluster.py', line 653 in 'query'

645\|              ) if steps else NullStep():
646\|                  assert message in r.output, error(r.output)
647\|  
648\|          if message is None or "Exception:" not in message:
649\|              with Then("check if output has exception") if steps else NullStep():
650\|                  if "Exception:" in r.output:
651\|                      if raise_on_exception:
652\|                          raise QueryRuntimeException(r.output)
653\|>                     assert False, error(r.output)
654\|  
655\|          return r
656\|
/window functions/tests/non distributed/frame clause/range errors/error negative following offsetXFail 41ms
https://github.com/ClickHouse/ClickHouse/issues/22442
AssertionError
Traceback (most recent call last):
  File "regression/window_functions/regression.py", line 203, in 
    regression()
  File "regression/window_functions/regression.py", line 199, in regression
    Feature(run=load("window_functions.tests.feature", "feature"), flags=TE)
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/feature.py", line 72, in feature
    Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE)
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/frame_clause.py", line 71, in feature
    Feature(run=load("window_functions.tests.range_errors", "feature"), flags=TE)
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/range_errors.py", line 114, in feature
    Scenario(run=scenario, flags=TE)
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/range_errors.py", line 105, in error_negative_following_offset
    r = current().context.node.query(sql, exitcode=exitcode, message=message)
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../helpers/cluster.py", line 646, in query
    assert message in r.output, error(r.output)
AssertionError: Oops! Assertion failed

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

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

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

Where
  File '/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../helpers/cluster.py', line 646 in 'query'

638\|          if exitcode is not None:
639\|              with Then(f"exitcode should be {exitcode}") if steps else NullStep():
640\|                  assert r.exitcode == exitcode, error(r.output)
641\|  
642\|          if message is not None:
643\|              with Then(
644\|                  f"output should contain message", description=message
645\|              ) if steps else NullStep():
646\|>                 assert message in r.output, error(r.output)
647\|  
648\|          if message is None or "Exception:" not in message:
649\|              with Then("check if output has exception") if steps else NullStep():
/window functions/tests/non distributed/frame clause/range errors/error negative preceding offsetXFail 40ms
https://github.com/ClickHouse/ClickHouse/issues/22442
AssertionError
Traceback (most recent call last):
  File "regression/window_functions/regression.py", line 203, in 
    regression()
  File "regression/window_functions/regression.py", line 199, in regression
    Feature(run=load("window_functions.tests.feature", "feature"), flags=TE)
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/feature.py", line 72, in feature
    Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE)
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/frame_clause.py", line 71, in feature
    Feature(run=load("window_functions.tests.range_errors", "feature"), flags=TE)
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/range_errors.py", line 114, in feature
    Scenario(run=scenario, flags=TE)
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/range_errors.py", line 89, in error_negative_preceding_offset
    r = current().context.node.query(sql, exitcode=exitcode, message=message)
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../helpers/cluster.py", line 646, in query
    assert message in r.output, error(r.output)
AssertionError: Oops! Assertion failed

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

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

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

Where
  File '/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../helpers/cluster.py', line 646 in 'query'

638\|          if exitcode is not None:
639\|              with Then(f"exitcode should be {exitcode}") if steps else NullStep():
640\|                  assert r.exitcode == exitcode, error(r.output)
641\|  
642\|          if message is not None:
643\|              with Then(
644\|                  f"output should contain message", description=message
645\|              ) if steps else NullStep():
646\|>                 assert message in r.output, error(r.output)
647\|  
648\|          if message is None or "Exception:" not in message:
649\|              with Then("check if output has exception") if steps else NullStep():
/window functions/tests/non distributed/misc/window functions in select expressionXFail 39ms
not supported, https://github.com/ClickHouse/ClickHouse/issues/19857
AssertionError
Traceback (most recent call last):
  File "regression/window_functions/regression.py", line 203, in 
    regression()
  File "regression/window_functions/regression.py", line 199, in regression
    Feature(run=load("window_functions.tests.feature", "feature"), flags=TE)
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/feature.py", line 79, in feature
    Feature(run=load("window_functions.tests.misc", "feature"), flags=TE)
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/misc.py", line 428, in feature
    Scenario(run=scenario, flags=TE)
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/misc.py", line 56, in window_functions_in_select_expression
    execute_query(
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/common.py", line 140, in execute_query
    r = current().context.node.query(
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../helpers/cluster.py", line 653, in query
    assert False, error(r.output)
AssertionError: Oops! Assertion failed

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

Description
  Received exception from server (version 22.3.10):
Code: 47. DB::Exception: Received from localhost:9000. DB::Exception: Unknown identifier: count() OVER (PARTITION BY four ORDER BY ten ASC); there are columns: less(unique2, 10), 10, 10, unique2, four, ten, hundred: While processing count() OVER (PARTITION BY four ORDER BY ten ASC) + sum(hundred) OVER (PARTITION BY four ORDER BY ten ASC). (UNKNOWN_IDENTIFIER)
(query: SELECT (count(*) OVER (PARTITION BY four ORDER BY ten) + sum(hundred) OVER (PARTITION BY four ORDER BY ten)) AS cntsum FROM tenk1 WHERE unique2 < 10 FORMAT TabSeparatedWithNames
)

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

Where
  File '/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../helpers/cluster.py', line 653 in 'query'

645\|              ) if steps else NullStep():
646\|                  assert message in r.output, error(r.output)
647\|  
648\|          if message is None or "Exception:" not in message:
649\|              with Then("check if output has exception") if steps else NullStep():
650\|                  if "Exception:" in r.output:
651\|                      if raise_on_exception:
652\|                          raise QueryRuntimeException(r.output)
653\|>                     assert False, error(r.output)
654\|  
655\|          return r
656\|
/window functions/tests/non distributed/misc/window functions in subqueryXFail 42ms
not supported, https://github.com/ClickHouse/ClickHouse/issues/19857
AssertionError
Traceback (most recent call last):
  File "regression/window_functions/regression.py", line 203, in 
    regression()
  File "regression/window_functions/regression.py", line 199, in regression
    Feature(run=load("window_functions.tests.feature", "feature"), flags=TE)
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/feature.py", line 79, in feature
    Feature(run=load("window_functions.tests.misc", "feature"), flags=TE)
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/misc.py", line 428, in feature
    Scenario(run=scenario, flags=TE)
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/misc.py", line 74, in window_functions_in_subquery
    execute_query(
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/common.py", line 140, in execute_query
    r = current().context.node.query(
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../helpers/cluster.py", line 653, in query
    assert False, error(r.output)
AssertionError: Oops! Assertion failed

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

Description
  Received exception from server (version 22.3.10):
Code: 47. DB::Exception: Received from localhost:9000. DB::Exception: Unknown identifier: count() OVER (PARTITION BY four ORDER BY ten ASC); there are columns: two, four, ten, hundred: While processing count() OVER (PARTITION BY four ORDER BY ten ASC) + sum(hundred) OVER (PARTITION BY two ORDER BY ten ASC) AS total, count() OVER (PARTITION BY four ORDER BY ten ASC) AS fourcount, sum(hundred) OVER (PARTITION BY two ORDER BY ten ASC) AS twosum. (UNKNOWN_IDENTIFIER)
(query: SELECT * FROM (  SELECT count(*) OVER (PARTITION BY four ORDER BY ten) +   sum(hundred) OVER (PARTITION BY two ORDER BY ten) AS total,   count(*) OVER (PARTITION BY four ORDER BY ten) AS fourcount,   sum(hundred) OVER (PARTITION BY two ORDER BY ten) AS twosum   FROM tenk1 ) WHERE total <> fourcount + twosum FORMAT TabSeparatedWithNames
)

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

Where
  File '/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../helpers/cluster.py', line 653 in 'query'

645\|              ) if steps else NullStep():
646\|                  assert message in r.output, error(r.output)
647\|  
648\|          if message is None or "Exception:" not in message:
649\|              with Then("check if output has exception") if steps else NullStep():
650\|                  if "Exception:" in r.output:
651\|                      if raise_on_exception:
652\|                          raise QueryRuntimeException(r.output)
653\|>                     assert False, error(r.output)
654\|  
655\|          return r
656\|
/window functions/tests/distributed/frame clause/range frame/between current row and unbounded following modifying named windowXFail 42ms
range with named window is not supported
AssertionError
Traceback (most recent call last):
  File "regression/window_functions/regression.py", line 203, in 
    regression()
  File "regression/window_functions/regression.py", line 199, in regression
    Feature(run=load("window_functions.tests.feature", "feature"), flags=TE)
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/feature.py", line 72, in feature
    Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE)
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/frame_clause.py", line 68, in feature
    Feature(run=load("window_functions.tests.range_frame", "feature"), flags=TE)
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/range_frame.py", line 1733, in feature
    Scenario(run=scenario, flags=TE)
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/range_frame.py", line 1520, in between_current_row_and_unbounded_following_modifying_named_window
    execute_query(
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/common.py", line 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 '/builds/altinity-qa/clickhouse/cicd/release/regression/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 caseXFail 40ms
known bug
AssertionError
Traceback (most recent call last):
  File "regression/window_functions/regression.py", line 203, in 
    regression()
  File "regression/window_functions/regression.py", line 199, in regression
    Feature(run=load("window_functions.tests.feature", "feature"), flags=TE)
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/feature.py", line 72, in feature
    Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE)
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/frame_clause.py", line 68, in feature
    Feature(run=load("window_functions.tests.range_frame", "feature"), flags=TE)
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/range_frame.py", line 1733, in feature
    Scenario(run=scenario, flags=TE)
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/range_frame.py", line 1347, in between_expr_following_and_current_row_zero_special_case
    execute_query(
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/common.py", line 140, in execute_query
    r = current().context.node.query(
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../helpers/cluster.py", line 653, in query
    assert False, error(r.output)
AssertionError: Oops! Assertion failed

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

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

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

Where
  File '/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../helpers/cluster.py', line 653 in 'query'

645\|              ) if steps else NullStep():
646\|                  assert message in r.output, error(r.output)
647\|  
648\|          if message is None or "Exception:" not in message:
649\|              with Then("check if output has exception") if steps else NullStep():
650\|                  if "Exception:" in r.output:
651\|                      if raise_on_exception:
652\|                          raise QueryRuntimeException(r.output)
653\|>                     assert False, error(r.output)
654\|  
655\|          return r
656\|
/window functions/tests/distributed/frame clause/range frame/between expr following and expr following without order by errorXFail 38ms
invalid error message
AssertionError
Traceback (most recent call last):
  File "regression/window_functions/regression.py", line 203, in 
    regression()
  File "regression/window_functions/regression.py", line 199, in regression
    Feature(run=load("window_functions.tests.feature", "feature"), flags=TE)
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/feature.py", line 72, in feature
    Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE)
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/frame_clause.py", line 68, in feature
    Feature(run=load("window_functions.tests.range_frame", "feature"), flags=TE)
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/range_frame.py", line 1733, in feature
    Scenario(run=scenario, flags=TE)
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/range_frame.py", line 1211, in between_expr_following_and_expr_following_without_order_by_error
    self.context.node.query(
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../helpers/cluster.py", line 646, in query
    assert message in r.output, error(r.output)
AssertionError: Oops! Assertion failed

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

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

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

Where
  File '/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../helpers/cluster.py', line 646 in 'query'

638\|          if exitcode is not None:
639\|              with Then(f"exitcode should be {exitcode}") if steps else NullStep():
640\|                  assert r.exitcode == exitcode, error(r.output)
641\|  
642\|          if message is not None:
643\|              with Then(
644\|                  f"output should contain message", description=message
645\|              ) if steps else NullStep():
646\|>                 assert message in r.output, error(r.output)
647\|  
648\|          if message is None or "Exception:" not in message:
649\|              with Then("check if output has exception") if steps else NullStep():
/window functions/tests/distributed/frame clause/range frame/between expr following and expr preceding with order by zero special caseXFail 41ms
known bug
AssertionError
Traceback (most recent call last):
  File "regression/window_functions/regression.py", line 203, in 
    regression()
  File "regression/window_functions/regression.py", line 199, in regression
    Feature(run=load("window_functions.tests.feature", "feature"), flags=TE)
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/feature.py", line 72, in feature
    Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE)
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/frame_clause.py", line 68, in feature
    Feature(run=load("window_functions.tests.range_frame", "feature"), flags=TE)
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/range_frame.py", line 1733, in feature
    Scenario(run=scenario, flags=TE)
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/range_frame.py", line 1416, in between_expr_following_and_expr_preceding_with_order_by_zero_special_case
    execute_query(
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/common.py", line 140, in execute_query
    r = current().context.node.query(
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../helpers/cluster.py", line 653, in query
    assert False, error(r.output)
AssertionError: Oops! Assertion failed

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

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

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

Where
  File '/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../helpers/cluster.py', line 653 in 'query'

645\|              ) if steps else NullStep():
646\|                  assert message in r.output, error(r.output)
647\|  
648\|          if message is None or "Exception:" not in message:
649\|              with Then("check if output has exception") if steps else NullStep():
650\|                  if "Exception:" in r.output:
651\|                      if raise_on_exception:
652\|                          raise QueryRuntimeException(r.output)
653\|>                     assert False, error(r.output)
654\|  
655\|          return r
656\|
/window functions/tests/distributed/frame clause/range frame/between expr following and expr preceding without order by errorXFail 38ms
invalid error message
AssertionError
Traceback (most recent call last):
  File "regression/window_functions/regression.py", line 203, in 
    regression()
  File "regression/window_functions/regression.py", line 199, in regression
    Feature(run=load("window_functions.tests.feature", "feature"), flags=TE)
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/feature.py", line 72, in feature
    Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE)
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/frame_clause.py", line 68, in feature
    Feature(run=load("window_functions.tests.range_frame", "feature"), flags=TE)
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/range_frame.py", line 1733, in feature
    Scenario(run=scenario, flags=TE)
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/range_frame.py", line 1228, in between_expr_following_and_expr_preceding_without_order_by_error
    self.context.node.query(
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../helpers/cluster.py", line 646, in query
    assert message in r.output, error(r.output)
AssertionError: Oops! Assertion failed

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

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

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

Where
  File '/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../helpers/cluster.py', line 646 in 'query'

638\|          if exitcode is not None:
639\|              with Then(f"exitcode should be {exitcode}") if steps else NullStep():
640\|                  assert r.exitcode == exitcode, error(r.output)
641\|  
642\|          if message is not None:
643\|              with Then(
644\|                  f"output should contain message", description=message
645\|              ) if steps else NullStep():
646\|>                 assert message in r.output, error(r.output)
647\|  
648\|          if message is None or "Exception:" not in message:
649\|              with Then("check if output has exception") if steps else NullStep():
/window functions/tests/distributed/frame clause/range frame/order by decimalXFail 43ms
Exception: The RANGE OFFSET frame for 'DB::ColumnDecimal >' ORDER BY column is not implemented
AssertionError
Traceback (most recent call last):
  File "regression/window_functions/regression.py", line 203, in 
    regression()
  File "regression/window_functions/regression.py", line 199, in regression
    Feature(run=load("window_functions.tests.feature", "feature"), flags=TE)
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/feature.py", line 72, in feature
    Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE)
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/frame_clause.py", line 68, in feature
    Feature(run=load("window_functions.tests.range_frame", "feature"), flags=TE)
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/range_frame.py", line 1733, in feature
    Scenario(run=scenario, flags=TE)
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/range_frame.py", line 1649, in order_by_decimal
    execute_query(
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/common.py", line 140, in execute_query
    r = current().context.node.query(
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../helpers/cluster.py", line 653, in query
    assert False, error(r.output)
AssertionError: Oops! Assertion failed

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

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

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

Where
  File '/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../helpers/cluster.py', line 653 in 'query'

645\|              ) if steps else NullStep():
646\|                  assert message in r.output, error(r.output)
647\|  
648\|          if message is None or "Exception:" not in message:
649\|              with Then("check if output has exception") if steps else NullStep():
650\|                  if "Exception:" in r.output:
651\|                      if raise_on_exception:
652\|                          raise QueryRuntimeException(r.output)
653\|>                     assert False, error(r.output)
654\|  
655\|          return r
656\|
/window functions/tests/distributed/frame clause/range frame/with nullsXFail 43ms
DB::Exception: The RANGE OFFSET frame for 'DB::ColumnNullable' ORDER BY column is not implemented
AssertionError
Traceback (most recent call last):
  File "regression/window_functions/regression.py", line 203, in 
    regression()
  File "regression/window_functions/regression.py", line 199, in regression
    Feature(run=load("window_functions.tests.feature", "feature"), flags=TE)
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/feature.py", line 72, in feature
    Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE)
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/frame_clause.py", line 68, in feature
    Feature(run=load("window_functions.tests.range_frame", "feature"), flags=TE)
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/range_frame.py", line 1733, in feature
    Scenario(run=scenario, flags=TE)
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/range_frame.py", line 1708, in with_nulls
    execute_query(
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/common.py", line 140, in execute_query
    r = current().context.node.query(
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../helpers/cluster.py", line 653, in query
    assert False, error(r.output)
AssertionError: Oops! Assertion failed

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

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

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

Where
  File '/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../helpers/cluster.py', line 653 in 'query'

645\|              ) if steps else NullStep():
646\|                  assert message in r.output, error(r.output)
647\|  
648\|          if message is None or "Exception:" not in message:
649\|              with Then("check if output has exception") if steps else NullStep():
650\|                  if "Exception:" in r.output:
651\|                      if raise_on_exception:
652\|                          raise QueryRuntimeException(r.output)
653\|>                     assert False, error(r.output)
654\|  
655\|          return r
656\|
/window functions/tests/distributed/frame clause/range overflow/negative overflow with Int16XFail 40ms
exception on conversion
AssertionError
Traceback (most recent call last):
  File "regression/window_functions/regression.py", line 203, in 
    regression()
  File "regression/window_functions/regression.py", line 199, in regression
    Feature(run=load("window_functions.tests.feature", "feature"), flags=TE)
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/feature.py", line 72, in feature
    Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE)
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/frame_clause.py", line 69, in feature
    Feature(run=load("window_functions.tests.range_overflow", "feature"), flags=TE)
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/range_overflow.py", line 145, in feature
    Scenario(run=scenario, flags=TE)
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/range_overflow.py", line 42, in negative_overflow_with_Int16
    execute_query(
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/common.py", line 140, in execute_query
    r = current().context.node.query(
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../helpers/cluster.py", line 653, in query
    assert False, error(r.output)
AssertionError: Oops! Assertion failed

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

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

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

Where
  File '/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../helpers/cluster.py', line 653 in 'query'

645\|              ) if steps else NullStep():
646\|                  assert message in r.output, error(r.output)
647\|  
648\|          if message is None or "Exception:" not in message:
649\|              with Then("check if output has exception") if steps else NullStep():
650\|                  if "Exception:" in r.output:
651\|                      if raise_on_exception:
652\|                          raise QueryRuntimeException(r.output)
653\|>                     assert False, error(r.output)
654\|  
655\|          return r
656\|
/window functions/tests/distributed/frame clause/range overflow/positive overflow with Int16XFail 39ms
exception on conversion
AssertionError
Traceback (most recent call last):
  File "regression/window_functions/regression.py", line 203, in 
    regression()
  File "regression/window_functions/regression.py", line 199, in regression
    Feature(run=load("window_functions.tests.feature", "feature"), flags=TE)
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/feature.py", line 72, in feature
    Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE)
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/frame_clause.py", line 69, in feature
    Feature(run=load("window_functions.tests.range_overflow", "feature"), flags=TE)
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/range_overflow.py", line 145, in feature
    Scenario(run=scenario, flags=TE)
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/range_overflow.py", line 20, in positive_overflow_with_Int16
    execute_query(
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/common.py", line 140, in execute_query
    r = current().context.node.query(
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../helpers/cluster.py", line 653, in query
    assert False, error(r.output)
AssertionError: Oops! Assertion failed

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

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

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

Where
  File '/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../helpers/cluster.py', line 653 in 'query'

645\|              ) if steps else NullStep():
646\|                  assert message in r.output, error(r.output)
647\|  
648\|          if message is None or "Exception:" not in message:
649\|              with Then("check if output has exception") if steps else NullStep():
650\|                  if "Exception:" in r.output:
651\|                      if raise_on_exception:
652\|                          raise QueryRuntimeException(r.output)
653\|>                     assert False, error(r.output)
654\|  
655\|          return r
656\|
/window functions/tests/distributed/frame clause/range datetime/order by asc range between days preceding and days followingXFail 40ms
https://github.com/ClickHouse/ClickHouse/issues/23902
AssertionError
Traceback (most recent call last):
  File "regression/window_functions/regression.py", line 203, in 
    regression()
  File "regression/window_functions/regression.py", line 199, in regression
    Feature(run=load("window_functions.tests.feature", "feature"), flags=TE)
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/feature.py", line 72, in feature
    Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE)
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/frame_clause.py", line 70, in feature
    Feature(run=load("window_functions.tests.range_datetime", "feature"), flags=TE)
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/range_datetime.py", line 264, in feature
    Scenario(run=scenario, flags=TE)
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/range_datetime.py", line 29, in order_by_asc_range_between_days_preceding_and_days_following
    execute_query(
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/common.py", line 140, in execute_query
    r = current().context.node.query(
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../helpers/cluster.py", line 653, in query
    assert False, error(r.output)
AssertionError: Oops! Assertion failed

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

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

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

Where
  File '/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../helpers/cluster.py', line 653 in 'query'

645\|              ) if steps else NullStep():
646\|                  assert message in r.output, error(r.output)
647\|  
648\|          if message is None or "Exception:" not in message:
649\|              with Then("check if output has exception") if steps else NullStep():
650\|                  if "Exception:" in r.output:
651\|                      if raise_on_exception:
652\|                          raise QueryRuntimeException(r.output)
653\|>                     assert False, error(r.output)
654\|  
655\|          return r
656\|
/window functions/tests/distributed/frame clause/range datetime/order by desc range between days following and days followingXFail 39ms
https://github.com/ClickHouse/ClickHouse/issues/23902
AssertionError
Traceback (most recent call last):
  File "regression/window_functions/regression.py", line 203, in 
    regression()
  File "regression/window_functions/regression.py", line 199, in regression
    Feature(run=load("window_functions.tests.feature", "feature"), flags=TE)
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/feature.py", line 72, in feature
    Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE)
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/frame_clause.py", line 70, in feature
    Feature(run=load("window_functions.tests.range_datetime", "feature"), flags=TE)
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/range_datetime.py", line 264, in feature
    Scenario(run=scenario, flags=TE)
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/range_datetime.py", line 86, in order_by_desc_range_between_days_following_and_days_following
    execute_query(
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/common.py", line 140, in execute_query
    r = current().context.node.query(
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../helpers/cluster.py", line 653, in query
    assert False, error(r.output)
AssertionError: Oops! Assertion failed

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

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

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

Where
  File '/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../helpers/cluster.py', line 653 in 'query'

645\|              ) if steps else NullStep():
646\|                  assert message in r.output, error(r.output)
647\|  
648\|          if message is None or "Exception:" not in message:
649\|              with Then("check if output has exception") if steps else NullStep():
650\|                  if "Exception:" in r.output:
651\|                      if raise_on_exception:
652\|                          raise QueryRuntimeException(r.output)
653\|>                     assert False, error(r.output)
654\|  
655\|          return r
656\|
/window functions/tests/distributed/frame clause/range datetime/order by desc range between days preceding and days followingXFail 39ms
https://github.com/ClickHouse/ClickHouse/issues/23902
AssertionError
Traceback (most recent call last):
  File "regression/window_functions/regression.py", line 203, in 
    regression()
  File "regression/window_functions/regression.py", line 199, in regression
    Feature(run=load("window_functions.tests.feature", "feature"), flags=TE)
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/feature.py", line 72, in feature
    Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE)
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/frame_clause.py", line 70, in feature
    Feature(run=load("window_functions.tests.range_datetime", "feature"), flags=TE)
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/range_datetime.py", line 264, in feature
    Scenario(run=scenario, flags=TE)
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/range_datetime.py", line 57, in order_by_desc_range_between_days_preceding_and_days_following
    execute_query(
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/common.py", line 140, in execute_query
    r = current().context.node.query(
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../helpers/cluster.py", line 653, in query
    assert False, error(r.output)
AssertionError: Oops! Assertion failed

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

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

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

Where
  File '/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../helpers/cluster.py', line 653 in 'query'

645\|              ) if steps else NullStep():
646\|                  assert message in r.output, error(r.output)
647\|  
648\|          if message is None or "Exception:" not in message:
649\|              with Then("check if output has exception") if steps else NullStep():
650\|                  if "Exception:" in r.output:
651\|                      if raise_on_exception:
652\|                          raise QueryRuntimeException(r.output)
653\|>                     assert False, error(r.output)
654\|  
655\|          return r
656\|
/window functions/tests/distributed/frame clause/range datetime/order by desc range between days preceding and days precedingXFail 40ms
https://github.com/ClickHouse/ClickHouse/issues/23902
AssertionError
Traceback (most recent call last):
  File "regression/window_functions/regression.py", line 203, in 
    regression()
  File "regression/window_functions/regression.py", line 199, in regression
    Feature(run=load("window_functions.tests.feature", "feature"), flags=TE)
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/feature.py", line 72, in feature
    Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE)
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/frame_clause.py", line 70, in feature
    Feature(run=load("window_functions.tests.range_datetime", "feature"), flags=TE)
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/range_datetime.py", line 264, in feature
    Scenario(run=scenario, flags=TE)
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/range_datetime.py", line 115, in order_by_desc_range_between_days_preceding_and_days_preceding
    execute_query(
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/common.py", line 140, in execute_query
    r = current().context.node.query(
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../helpers/cluster.py", line 653, in query
    assert False, error(r.output)
AssertionError: Oops! Assertion failed

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

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

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

Where
  File '/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../helpers/cluster.py', line 653 in 'query'

645\|              ) if steps else NullStep():
646\|                  assert message in r.output, error(r.output)
647\|  
648\|          if message is None or "Exception:" not in message:
649\|              with Then("check if output has exception") if steps else NullStep():
650\|                  if "Exception:" in r.output:
651\|                      if raise_on_exception:
652\|                          raise QueryRuntimeException(r.output)
653\|>                     assert False, error(r.output)
654\|  
655\|          return r
656\|
/window functions/tests/distributed/frame clause/range errors/error negative following offsetXFail 39ms
https://github.com/ClickHouse/ClickHouse/issues/22442
AssertionError
Traceback (most recent call last):
  File "regression/window_functions/regression.py", line 203, in 
    regression()
  File "regression/window_functions/regression.py", line 199, in regression
    Feature(run=load("window_functions.tests.feature", "feature"), flags=TE)
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/feature.py", line 72, in feature
    Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE)
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/frame_clause.py", line 71, in feature
    Feature(run=load("window_functions.tests.range_errors", "feature"), flags=TE)
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/range_errors.py", line 114, in feature
    Scenario(run=scenario, flags=TE)
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/range_errors.py", line 105, in error_negative_following_offset
    r = current().context.node.query(sql, exitcode=exitcode, message=message)
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../helpers/cluster.py", line 646, in query
    assert message in r.output, error(r.output)
AssertionError: Oops! Assertion failed

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

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

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

Where
  File '/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../helpers/cluster.py', line 646 in 'query'

638\|          if exitcode is not None:
639\|              with Then(f"exitcode should be {exitcode}") if steps else NullStep():
640\|                  assert r.exitcode == exitcode, error(r.output)
641\|  
642\|          if message is not None:
643\|              with Then(
644\|                  f"output should contain message", description=message
645\|              ) if steps else NullStep():
646\|>                 assert message in r.output, error(r.output)
647\|  
648\|          if message is None or "Exception:" not in message:
649\|              with Then("check if output has exception") if steps else NullStep():
/window functions/tests/distributed/frame clause/range errors/error negative preceding offsetXFail 39ms
https://github.com/ClickHouse/ClickHouse/issues/22442
AssertionError
Traceback (most recent call last):
  File "regression/window_functions/regression.py", line 203, in 
    regression()
  File "regression/window_functions/regression.py", line 199, in regression
    Feature(run=load("window_functions.tests.feature", "feature"), flags=TE)
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/feature.py", line 72, in feature
    Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE)
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/frame_clause.py", line 71, in feature
    Feature(run=load("window_functions.tests.range_errors", "feature"), flags=TE)
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/range_errors.py", line 114, in feature
    Scenario(run=scenario, flags=TE)
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/range_errors.py", line 89, in error_negative_preceding_offset
    r = current().context.node.query(sql, exitcode=exitcode, message=message)
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../helpers/cluster.py", line 646, in query
    assert message in r.output, error(r.output)
AssertionError: Oops! Assertion failed

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

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

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

Where
  File '/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../helpers/cluster.py', line 646 in 'query'

638\|          if exitcode is not None:
639\|              with Then(f"exitcode should be {exitcode}") if steps else NullStep():
640\|                  assert r.exitcode == exitcode, error(r.output)
641\|  
642\|          if message is not None:
643\|              with Then(
644\|                  f"output should contain message", description=message
645\|              ) if steps else NullStep():
646\|>                 assert message in r.output, error(r.output)
647\|  
648\|          if message is None or "Exception:" not in message:
649\|              with Then("check if output has exception") if steps else NullStep():
/window functions/tests/distributed/misc/window functions in select expressionXFail 40ms
not supported, https://github.com/ClickHouse/ClickHouse/issues/19857
AssertionError
Traceback (most recent call last):
  File "regression/window_functions/regression.py", line 203, in 
    regression()
  File "regression/window_functions/regression.py", line 199, in regression
    Feature(run=load("window_functions.tests.feature", "feature"), flags=TE)
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/feature.py", line 79, in feature
    Feature(run=load("window_functions.tests.misc", "feature"), flags=TE)
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/misc.py", line 428, in feature
    Scenario(run=scenario, flags=TE)
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/misc.py", line 56, in window_functions_in_select_expression
    execute_query(
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/common.py", line 140, in execute_query
    r = current().context.node.query(
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../helpers/cluster.py", line 653, in query
    assert False, error(r.output)
AssertionError: Oops! Assertion failed

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

Description
  Received exception from server (version 22.3.10):
Code: 47. DB::Exception: Received from localhost:9000. DB::Exception: Unknown identifier: count() OVER (PARTITION BY four ORDER BY ten ASC); there are columns: unique2, four, ten, hundred, 10, 10, less(unique2, 10): While processing count() OVER (PARTITION BY four ORDER BY ten ASC) + sum(hundred) OVER (PARTITION BY four ORDER BY ten ASC) AS cntsum. (UNKNOWN_IDENTIFIER)
(query: SELECT (count(*) OVER (PARTITION BY four ORDER BY ten) + sum(hundred) OVER (PARTITION BY four ORDER BY ten)) AS cntsum FROM tenk1 WHERE unique2 < 10 FORMAT TabSeparatedWithNames
)

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

Where
  File '/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../helpers/cluster.py', line 653 in 'query'

645\|              ) if steps else NullStep():
646\|                  assert message in r.output, error(r.output)
647\|  
648\|          if message is None or "Exception:" not in message:
649\|              with Then("check if output has exception") if steps else NullStep():
650\|                  if "Exception:" in r.output:
651\|                      if raise_on_exception:
652\|                          raise QueryRuntimeException(r.output)
653\|>                     assert False, error(r.output)
654\|  
655\|          return r
656\|
/window functions/tests/distributed/misc/window functions in subqueryXFail 40ms
not supported, https://github.com/ClickHouse/ClickHouse/issues/19857
AssertionError
Traceback (most recent call last):
  File "regression/window_functions/regression.py", line 203, in 
    regression()
  File "regression/window_functions/regression.py", line 199, in regression
    Feature(run=load("window_functions.tests.feature", "feature"), flags=TE)
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/feature.py", line 79, in feature
    Feature(run=load("window_functions.tests.misc", "feature"), flags=TE)
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/misc.py", line 428, in feature
    Scenario(run=scenario, flags=TE)
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/misc.py", line 74, in window_functions_in_subquery
    execute_query(
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../window_functions/tests/common.py", line 140, in execute_query
    r = current().context.node.query(
  File "/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../helpers/cluster.py", line 653, in query
    assert False, error(r.output)
AssertionError: Oops! Assertion failed

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

Description
  Received exception from server (version 22.3.10):
Code: 47. DB::Exception: Received from localhost:9000. DB::Exception: Unknown identifier: count() OVER (PARTITION BY four ORDER BY ten ASC); there are columns: two, four, ten, hundred: While processing count() OVER (PARTITION BY four ORDER BY ten ASC) + sum(hundred) OVER (PARTITION BY two ORDER BY ten ASC) AS total, count() OVER (PARTITION BY four ORDER BY ten ASC) AS fourcount, sum(hundred) OVER (PARTITION BY two ORDER BY ten ASC) AS twosum. (UNKNOWN_IDENTIFIER)
(query: SELECT * FROM (  SELECT count(*) OVER (PARTITION BY four ORDER BY ten) +   sum(hundred) OVER (PARTITION BY two ORDER BY ten) AS total,   count(*) OVER (PARTITION BY four ORDER BY ten) AS fourcount,   sum(hundred) OVER (PARTITION BY two ORDER BY ten) AS twosum   FROM tenk1 ) WHERE total <> fourcount + twosum FORMAT TabSeparatedWithNames
)

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

Where
  File '/builds/altinity-qa/clickhouse/cicd/release/regression/window_functions/../helpers/cluster.py', line 653 in 'query'

645\|              ) if steps else NullStep():
646\|                  assert message in r.output, error(r.output)
647\|  
648\|          if message is None or "Exception:" not in message:
649\|              with Then("check if output has exception") if steps else NullStep():
650\|                  if "Exception:" in r.output:
651\|                      if raise_on_exception:
652\|                          raise QueryRuntimeException(r.output)
653\|>                     assert False, error(r.output)
654\|  
655\|          return r
656\|

Results

Test Name Result Duration
/window functions OK 4m 26s
/window functions/tests OK 2m 55s
/window functions/tests/non distributed OK 1m 23s
/window functions/tests/non distributed/window spec OK 309ms
/window functions/tests/non distributed/window spec/empty OK 36ms
/window functions/tests/non distributed/window spec/frame clause OK 36ms
/window functions/tests/non distributed/window spec/order by with frame OK 36ms
/window functions/tests/non distributed/window spec/orderby clause OK 36ms
/window functions/tests/non distributed/window spec/partition clause OK 52ms
/window functions/tests/non distributed/window spec/partition with frame OK 36ms
/window functions/tests/non distributed/window spec/partition with order by OK 35ms
/window functions/tests/non distributed/window spec/partition with order by and frame OK 36ms
/window functions/tests/non distributed/partition clause OK 144ms
/window functions/tests/non distributed/partition clause/invalid expr error OK 35ms
/window functions/tests/non distributed/partition clause/missing expr error OK 36ms
/window functions/tests/non distributed/partition clause/multiple expr OK 36ms
/window functions/tests/non distributed/partition clause/single expr OK 36ms
/window functions/tests/non distributed/order clause OK 405ms
/window functions/tests/non distributed/order clause/by a non integer constant OK 35ms
/window functions/tests/non distributed/order clause/by column OK 36ms
/window functions/tests/non distributed/order clause/by expr OK 37ms
/window functions/tests/non distributed/order clause/by expr with aggregates OK 37ms
/window functions/tests/non distributed/order clause/invalid expr error OK 34ms
/window functions/tests/non distributed/order clause/missing expr error OK 36ms
/window functions/tests/non distributed/order clause/multiple expr asc asc OK 36ms
/window functions/tests/non distributed/order clause/multiple expr asc desc OK 36ms
/window functions/tests/non distributed/order clause/multiple expr desc desc OK 36ms
/window functions/tests/non distributed/order clause/single expr asc OK 38ms
/window functions/tests/non distributed/order clause/single expr desc OK 37ms
/window functions/tests/non distributed/frame clause OK 5s 323ms
/window functions/tests/non distributed/frame clause/default frame OK 93ms
/window functions/tests/non distributed/frame clause/default frame/with order by OK 56ms
/window functions/tests/non distributed/frame clause/default frame/without order by OK 36ms
/window functions/tests/non distributed/frame clause/rows frame OK 1s 344ms
/window functions/tests/non distributed/frame clause/rows frame/between current row and current row OK 38ms
/window functions/tests/non distributed/frame clause/rows frame/between current row and expr following OK 38ms
/window functions/tests/non distributed/frame clause/rows frame/between current row and expr preceding error OK 34ms
/window functions/tests/non distributed/frame clause/rows frame/between current row and unbounded following OK 37ms
/window functions/tests/non distributed/frame clause/rows frame/between current row and unbounded preceding error OK 34ms
/window functions/tests/non distributed/frame clause/rows frame/between expr following and expr following OK 36ms
/window functions/tests/non distributed/frame clause/rows frame/between expr following and expr following error OK 35ms
/window functions/tests/non distributed/frame clause/rows frame/between expr following and expr following ref OK 37ms
/window functions/tests/non distributed/frame clause/rows frame/between expr following and unbounded following OK 37ms
/window functions/tests/non distributed/frame clause/rows frame/between expr following error OK 105ms
/window functions/tests/non distributed/frame clause/rows frame/between expr preceding and current row OK 37ms
/window functions/tests/non distributed/frame clause/rows frame/between expr preceding and expr following OK 38ms
/window functions/tests/non distributed/frame clause/rows frame/between expr preceding and expr following ref OK 38ms
/window functions/tests/non distributed/frame clause/rows frame/between expr preceding and expr preceding OK 36ms
/window functions/tests/non distributed/frame clause/rows frame/between expr preceding and expr preceding error OK 35ms
/window functions/tests/non distributed/frame clause/rows frame/between expr preceding and expr preceding ref OK 37ms
/window functions/tests/non distributed/frame clause/rows frame/between expr preceding and unbounded following OK 36ms
/window functions/tests/non distributed/frame clause/rows frame/between expr preceding and unbounded preceding error OK 34ms
/window functions/tests/non distributed/frame clause/rows frame/between unbounded following error OK 174ms
/window functions/tests/non distributed/frame clause/rows frame/between unbounded preceding and current row OK 40ms
/window functions/tests/non distributed/frame clause/rows frame/between unbounded preceding and expr following OK 37ms
/window functions/tests/non distributed/frame clause/rows frame/between unbounded preceding and expr preceding OK 37ms
/window functions/tests/non distributed/frame clause/rows frame/between unbounded preceding and unbounded following OK 36ms
/window functions/tests/non distributed/frame clause/rows frame/between unbounded preceding and unbounded preceding error OK 34ms
/window functions/tests/non distributed/frame clause/rows frame/invalid frame extent OK 33ms
/window functions/tests/non distributed/frame clause/rows frame/missing frame extent OK 33ms
/window functions/tests/non distributed/frame clause/rows frame/start current row OK 36ms
/window functions/tests/non distributed/frame clause/rows frame/start expr following error OK 34ms
/window functions/tests/non distributed/frame clause/rows frame/start expr preceding OK 37ms
/window functions/tests/non distributed/frame clause/rows frame/start unbounded following error OK 34ms
/window functions/tests/non distributed/frame clause/rows frame/start unbounded preceding OK 37ms
/window functions/tests/non distributed/frame clause/range frame OK 3s 20ms
/window functions/tests/non distributed/frame clause/range frame/between current row and current row OK 81ms
/window functions/tests/non distributed/frame clause/range frame/between current row and expr following with order by OK 59ms
/window functions/tests/non distributed/frame clause/range frame/between current row and expr following without order by error OK 35ms
/window functions/tests/non distributed/frame clause/range frame/between current row and expr preceding error OK 70ms
/window functions/tests/non distributed/frame clause/range frame/between current row and unbounded following OK 114ms
/window functions/tests/non distributed/frame clause/range frame/between current row and unbounded following in named window OK 42ms
/window functions/tests/non distributed/frame clause/range frame/between current row and unbounded following modifying named window XFail 61ms
/window functions/tests/non distributed/frame clause/range frame/between current row and unbounded preceding error OK 69ms
/window functions/tests/non distributed/frame clause/range frame/between expr following and current row with order by error OK 36ms
/window functions/tests/non distributed/frame clause/range frame/between expr following and current row without order by error OK 36ms
/window functions/tests/non distributed/frame clause/range frame/between expr following and current row zero special case XFail 39ms
/window functions/tests/non distributed/frame clause/range frame/between expr following and expr following with order by OK 37ms
/window functions/tests/non distributed/frame clause/range frame/between expr following and expr following with order by error OK 35ms
/window functions/tests/non distributed/frame clause/range frame/between expr following and expr following without order by error XFail 38ms
/window functions/tests/non distributed/frame clause/range frame/between expr following and expr preceding error OK 71ms
/window functions/tests/non distributed/frame clause/range frame/between expr following and expr preceding with order by zero special case XFail 38ms
/window functions/tests/non distributed/frame clause/range frame/between expr following and expr preceding without order by error XFail 38ms
/window functions/tests/non distributed/frame clause/range frame/between expr following and unbounded following with order by OK 36ms
/window functions/tests/non distributed/frame clause/range frame/between expr following and unbounded following without order by error OK 37ms
/window functions/tests/non distributed/frame clause/range frame/between expr following and unbounded preceding error OK 69ms
/window functions/tests/non distributed/frame clause/range frame/between expr preceding and current row with order by OK 37ms
/window functions/tests/non distributed/frame clause/range frame/between expr preceding and current row without order by error OK 36ms
/window functions/tests/non distributed/frame clause/range frame/between expr preceding and expr following with order by OK 76ms
/window functions/tests/non distributed/frame clause/range frame/between expr preceding and expr following with partition and order by OK 37ms
/window functions/tests/non distributed/frame clause/range frame/between expr preceding and expr following with partition by same column twice OK 38ms
/window functions/tests/non distributed/frame clause/range frame/between expr preceding and expr following with partition by two columns OK 38ms
/window functions/tests/non distributed/frame clause/range frame/between expr preceding and expr following without order by error OK 36ms
/window functions/tests/non distributed/frame clause/range frame/between expr preceding and expr preceding with order by OK 76ms
/window functions/tests/non distributed/frame clause/range frame/between expr preceding and expr preceding with order by error OK 35ms
/window functions/tests/non distributed/frame clause/range frame/between expr preceding and expr preceding without order by error OK 35ms
/window functions/tests/non distributed/frame clause/range frame/between expr preceding and unbounded following with order by OK 38ms
/window functions/tests/non distributed/frame clause/range frame/between expr preceding and unbounded following without order by error OK 35ms
/window functions/tests/non distributed/frame clause/range frame/between expr preceding and unbounded preceding error OK 72ms
/window functions/tests/non distributed/frame clause/range frame/between unbounded following and current row error OK 69ms
/window functions/tests/non distributed/frame clause/range frame/between unbounded following and expr following error OK 68ms
/window functions/tests/non distributed/frame clause/range frame/between unbounded following and expr preceding error OK 71ms
/window functions/tests/non distributed/frame clause/range frame/between unbounded following and unbounded following error OK 70ms
/window functions/tests/non distributed/frame clause/range frame/between unbounded following and unbounded preceding error OK 69ms
/window functions/tests/non distributed/frame clause/range frame/between unbounded preceding and current row OK 77ms
/window functions/tests/non distributed/frame clause/range frame/between unbounded preceding and current row with expressions in order by and aggregate OK 40ms
/window functions/tests/non distributed/frame clause/range frame/between unbounded preceding and expr following with order by OK 37ms
/window functions/tests/non distributed/frame clause/range frame/between unbounded preceding and expr following without order by error OK 35ms
/window functions/tests/non distributed/frame clause/range frame/between unbounded preceding and expr preceding with order by OK 37ms
/window functions/tests/non distributed/frame clause/range frame/between unbounded preceding and expr preceding without order by error OK 38ms
/window functions/tests/non distributed/frame clause/range frame/between unbounded preceding and unbounded following OK 77ms
/window functions/tests/non distributed/frame clause/range frame/between unbounded preceding and unbounded preceding error OK 69ms
/window functions/tests/non distributed/frame clause/range frame/invalid frame extent OK 33ms
/window functions/tests/non distributed/frame clause/range frame/missing frame extent OK 34ms
/window functions/tests/non distributed/frame clause/range frame/order by decimal XFail 41ms
/window functions/tests/non distributed/frame clause/range frame/order by float OK 38ms
/window functions/tests/non distributed/frame clause/range frame/start current row with order by OK 37ms
/window functions/tests/non distributed/frame clause/range frame/start current row without order by OK 37ms
/window functions/tests/non distributed/frame clause/range frame/start expr following with order by error OK 35ms
/window functions/tests/non distributed/frame clause/range frame/start expr following without order by error OK 34ms
/window functions/tests/non distributed/frame clause/range frame/start expr preceding order by non numerical column error OK 35ms
/window functions/tests/non distributed/frame clause/range frame/start expr preceding with order by OK 37ms
/window functions/tests/non distributed/frame clause/range frame/start expr preceding without order by error OK 36ms
/window functions/tests/non distributed/frame clause/range frame/start unbounded following error OK 74ms
/window functions/tests/non distributed/frame clause/range frame/start unbounded preceding with order by OK 37ms
/window functions/tests/non distributed/frame clause/range frame/start unbounded preceding without order by OK 38ms
/window functions/tests/non distributed/frame clause/range frame/with nulls XFail 43ms
/window functions/tests/non distributed/frame clause/range overflow OK 253ms
/window functions/tests/non distributed/frame clause/range overflow/negative overflow for Int32 OK 38ms
/window functions/tests/non distributed/frame clause/range overflow/negative overflow for Int64 OK 37ms
/window functions/tests/non distributed/frame clause/range overflow/negative overflow with Int16 XFail 41ms
/window functions/tests/non distributed/frame clause/range overflow/positive overflow for Int32 OK 37ms
/window functions/tests/non distributed/frame clause/range overflow/positive overflow for Int64 OK 56ms
/window functions/tests/non distributed/frame clause/range overflow/positive overflow with Int16 XFail 40ms
/window functions/tests/non distributed/frame clause/range datetime OK 332ms
/window functions/tests/non distributed/frame clause/range datetime/datetime order by asc range between n preceding and n following OK 39ms
/window functions/tests/non distributed/frame clause/range datetime/datetime order by desc range between n preceding and n following OK 38ms
/window functions/tests/non distributed/frame clause/range datetime/datetime with timezone order by asc range between n preceding and n following OK 51ms
/window functions/tests/non distributed/frame clause/range datetime/datetime with timezone order by desc range between n preceding and n following OK 52ms
/window functions/tests/non distributed/frame clause/range datetime/order by asc range between days preceding and days following OK 37ms
/window functions/tests/non distributed/frame clause/range datetime/order by desc range between days following and days following OK 37ms
/window functions/tests/non distributed/frame clause/range datetime/order by desc range between days preceding and days following OK 37ms
/window functions/tests/non distributed/frame clause/range datetime/order by desc range between days preceding and days preceding OK 37ms
/window functions/tests/non distributed/frame clause/range errors OK 269ms
/window functions/tests/non distributed/frame clause/range errors/error missing order by OK 36ms
/window functions/tests/non distributed/frame clause/range errors/error missing order by with partition by clause OK 37ms
/window functions/tests/non distributed/frame clause/range errors/error more than one order by column OK 76ms
/window functions/tests/non distributed/frame clause/range errors/error negative following offset XFail 41ms
/window functions/tests/non distributed/frame clause/range errors/error negative preceding offset XFail 40ms
/window functions/tests/non distributed/frame clause/range errors/error range over non numerical column OK 36ms
/window functions/tests/non distributed/window clause OK 282ms
/window functions/tests/non distributed/window clause/missing window spec OK 69ms
/window functions/tests/non distributed/window clause/multiple identical windows OK 57ms
/window functions/tests/non distributed/window clause/multiple windows OK 79ms
/window functions/tests/non distributed/window clause/single window OK 37ms
/window functions/tests/non distributed/window clause/unused window OK 36ms
/window functions/tests/non distributed/over clause OK 215ms
/window functions/tests/non distributed/over clause/adhoc window OK 37ms
/window functions/tests/non distributed/over clause/empty OK 36ms
/window functions/tests/non distributed/over clause/empty named window OK 36ms
/window functions/tests/non distributed/over clause/invalid multiple windows OK 35ms
/window functions/tests/non distributed/over clause/invalid window name OK 35ms
/window functions/tests/non distributed/over clause/missing window spec OK 33ms
/window functions/tests/non distributed/funcs OK 1s 156ms
/window functions/tests/non distributed/funcs/dense rank OK 37ms
/window functions/tests/non distributed/funcs/first value OK 81ms
/window functions/tests/non distributed/funcs/first value with lead workaround OK 37ms
/window functions/tests/non distributed/funcs/lag OK 121ms
/window functions/tests/non distributed/funcs/lagInFrame OK 192ms
/window functions/tests/non distributed/funcs/last value OK 162ms
/window functions/tests/non distributed/funcs/last value with lag workaround OK 37ms
/window functions/tests/non distributed/funcs/last value with no frame OK 39ms
/window functions/tests/non distributed/funcs/lead OK 158ms
/window functions/tests/non distributed/funcs/leadInFrame OK 211ms
/window functions/tests/non distributed/funcs/rank OK 37ms
/window functions/tests/non distributed/funcs/row number OK 36ms
/window functions/tests/non distributed/aggregate funcs OK 3s 2ms
/window functions/tests/non distributed/aggregate funcs/aggregate and window function in the same window OK 65ms
/window functions/tests/non distributed/aggregate funcs/aggregate funcs over rows frame OK 2s 430ms
/window functions/tests/non distributed/aggregate funcs/aggregate function recovers from nan OK 37ms
/window functions/tests/non distributed/aggregate funcs/avgWeighted OK 113ms
/window functions/tests/non distributed/aggregate funcs/avg with nulls OK 41ms
/window functions/tests/non distributed/aggregate funcs/bit functions OK 38ms
/window functions/tests/non distributed/aggregate funcs/nested aggregates OK 37ms
/window functions/tests/non distributed/aggregate funcs/stddevpop OK 40ms
/window functions/tests/non distributed/aggregate funcs/stddevsamp OK 39ms
/window functions/tests/non distributed/aggregate funcs/sum OK 37ms
/window functions/tests/non distributed/aggregate funcs/ungrouped aggregate over empty row set OK 35ms
/window functions/tests/non distributed/aggregate funcs/var pop OK 38ms
/window functions/tests/non distributed/aggregate funcs/var samp OK 41ms
/window functions/tests/non distributed/time decayed funcs OK 1m 9s
/window functions/tests/non distributed/time decayed funcs/exponentialTimeDecayedAvg OK 6s 794ms
/window functions/tests/non distributed/time decayed funcs/exponentialTimeDecayedCount OK 6s 61ms
/window functions/tests/non distributed/time decayed funcs/exponentialTimeDecayedMax OK 49s 931ms
/window functions/tests/non distributed/time decayed funcs/exponentialTimeDecayedSum OK 6s 776ms
/window functions/tests/non distributed/errors OK 357ms
/window functions/tests/non distributed/errors/error coma between partition by and order by clause OK 34ms
/window functions/tests/non distributed/errors/error named window defined twice OK 36ms
/window functions/tests/non distributed/errors/error order by another window function OK 35ms
/window functions/tests/non distributed/errors/error select from window OK 35ms
/window functions/tests/non distributed/errors/error using non window function OK 35ms
/window functions/tests/non distributed/errors/error window function in alter delete where OK 36ms
/window functions/tests/non distributed/errors/error window function in group by OK 35ms
/window functions/tests/non distributed/errors/error window function in having OK 35ms
/window functions/tests/non distributed/errors/error window function in join OK 35ms
/window functions/tests/non distributed/errors/error window function in where OK 35ms
/window functions/tests/non distributed/misc OK 741ms
/window functions/tests/non distributed/misc/count with empty over clause without start OK 37ms
/window functions/tests/non distributed/misc/empty table OK 37ms
/window functions/tests/non distributed/misc/exclude clause OK 35ms
/window functions/tests/non distributed/misc/from subquery OK 38ms
/window functions/tests/non distributed/misc/group by and multiple windows OK 39ms
/window functions/tests/non distributed/misc/group by and one window OK 37ms
/window functions/tests/non distributed/misc/groups frame OK 37ms
/window functions/tests/non distributed/misc/in view OK 155ms
/window functions/tests/non distributed/misc/query with order by and one window OK 37ms
/window functions/tests/non distributed/misc/subquery expr preceding OK 38ms
/window functions/tests/non distributed/misc/subquery multiple window functions OK 40ms
/window functions/tests/non distributed/misc/subquery with multiple windows filtering OK 42ms
/window functions/tests/non distributed/misc/window functions in select expression XFail 39ms
/window functions/tests/non distributed/misc/window functions in subquery XFail 42ms
/window functions/tests/non distributed/misc/windows with same partitioning but different ordering OK 40ms
/window functions/tests/non distributed/misc/with union all OK 38ms
/window functions/tests/non distributed/datatypes OK 449ms
/window functions/tests/non distributed/datatypes/date OK 36ms
/window functions/tests/non distributed/datatypes/datetime OK 38ms
/window functions/tests/non distributed/datatypes/datetime64 OK 37ms
/window functions/tests/non distributed/datatypes/decimal32 OK 36ms
/window functions/tests/non distributed/datatypes/enum OK 37ms
/window functions/tests/non distributed/datatypes/fixed string OK 37ms
/window functions/tests/non distributed/datatypes/ipv4 OK 36ms
/window functions/tests/non distributed/datatypes/ipv6 OK 38ms
/window functions/tests/non distributed/datatypes/low cardinality OK 36ms
/window functions/tests/non distributed/datatypes/map OK 36ms
/window functions/tests/non distributed/datatypes/string OK 36ms
/window functions/tests/non distributed/datatypes/uuid OK 37ms
/window functions/tests/non distributed/non-negative derivative func Skip 1ms
/window functions/tests/distributed OK 1m 31s
/window functions/tests/distributed/window spec OK 312ms
/window functions/tests/distributed/window spec/empty OK 39ms
/window functions/tests/distributed/window spec/frame clause OK 38ms
/window functions/tests/distributed/window spec/order by with frame OK 38ms
/window functions/tests/distributed/window spec/orderby clause OK 38ms
/window functions/tests/distributed/window spec/partition clause OK 38ms
/window functions/tests/distributed/window spec/partition with frame OK 38ms
/window functions/tests/distributed/window spec/partition with order by OK 38ms
/window functions/tests/distributed/window spec/partition with order by and frame OK 38ms
/window functions/tests/distributed/partition clause OK 142ms
/window functions/tests/distributed/partition clause/invalid expr error OK 35ms
/window functions/tests/distributed/partition clause/missing expr error OK 33ms
/window functions/tests/distributed/partition clause/multiple expr OK 36ms
/window functions/tests/distributed/partition clause/single expr OK 36ms
/window functions/tests/distributed/order clause OK 410ms
/window functions/tests/distributed/order clause/by a non integer constant OK 37ms
/window functions/tests/distributed/order clause/by column OK 39ms
/window functions/tests/distributed/order clause/by expr OK 40ms
/window functions/tests/distributed/order clause/by expr with aggregates OK 41ms
/window functions/tests/distributed/order clause/invalid expr error OK 34ms
/window functions/tests/distributed/order clause/missing expr error OK 33ms
/window functions/tests/distributed/order clause/multiple expr asc asc OK 36ms
/window functions/tests/distributed/order clause/multiple expr asc desc OK 37ms
/window functions/tests/distributed/order clause/multiple expr desc desc OK 36ms
/window functions/tests/distributed/order clause/single expr asc OK 36ms
/window functions/tests/distributed/order clause/single expr desc OK 36ms
/window functions/tests/distributed/frame clause OK 5s 401ms
/window functions/tests/distributed/frame clause/default frame OK 77ms
/window functions/tests/distributed/frame clause/default frame/with order by OK 35ms
/window functions/tests/distributed/frame clause/default frame/without order by OK 40ms
/window functions/tests/distributed/frame clause/rows frame OK 1s 425ms
/window functions/tests/distributed/frame clause/rows frame/between current row and current row OK 38ms
/window functions/tests/distributed/frame clause/rows frame/between current row and expr following OK 38ms
/window functions/tests/distributed/frame clause/rows frame/between current row and expr preceding error OK 34ms
/window functions/tests/distributed/frame clause/rows frame/between current row and unbounded following OK 44ms
/window functions/tests/distributed/frame clause/rows frame/between current row and unbounded preceding error OK 34ms
/window functions/tests/distributed/frame clause/rows frame/between expr following and expr following OK 39ms
/window functions/tests/distributed/frame clause/rows frame/between expr following and expr following error OK 34ms
/window functions/tests/distributed/frame clause/rows frame/between expr following and expr following ref OK 46ms
/window functions/tests/distributed/frame clause/rows frame/between expr following and unbounded following OK 40ms
/window functions/tests/distributed/frame clause/rows frame/between expr following error OK 136ms
/window functions/tests/distributed/frame clause/rows frame/between expr preceding and current row OK 40ms
/window functions/tests/distributed/frame clause/rows frame/between expr preceding and expr following OK 39ms
/window functions/tests/distributed/frame clause/rows frame/between expr preceding and expr following ref OK 40ms
/window functions/tests/distributed/frame clause/rows frame/between expr preceding and expr preceding OK 39ms
/window functions/tests/distributed/frame clause/rows frame/between expr preceding and expr preceding error OK 34ms
/window functions/tests/distributed/frame clause/rows frame/between expr preceding and expr preceding ref OK 39ms
/window functions/tests/distributed/frame clause/rows frame/between expr preceding and unbounded following OK 40ms
/window functions/tests/distributed/frame clause/rows frame/between expr preceding and unbounded preceding error OK 34ms
/window functions/tests/distributed/frame clause/rows frame/between unbounded following error OK 173ms
/window functions/tests/distributed/frame clause/rows frame/between unbounded preceding and current row OK 41ms
/window functions/tests/distributed/frame clause/rows frame/between unbounded preceding and expr following OK 40ms
/window functions/tests/distributed/frame clause/rows frame/between unbounded preceding and expr preceding OK 39ms
/window functions/tests/distributed/frame clause/rows frame/between unbounded preceding and unbounded following OK 39ms
/window functions/tests/distributed/frame clause/rows frame/between unbounded preceding and unbounded preceding error OK 35ms
/window functions/tests/distributed/frame clause/rows frame/invalid frame extent OK 33ms
/window functions/tests/distributed/frame clause/rows frame/missing frame extent OK 33ms
/window functions/tests/distributed/frame clause/rows frame/start current row OK 39ms
/window functions/tests/distributed/frame clause/rows frame/start expr following error OK 36ms
/window functions/tests/distributed/frame clause/rows frame/start expr preceding OK 39ms
/window functions/tests/distributed/frame clause/rows frame/start unbounded following error OK 35ms
/window functions/tests/distributed/frame clause/rows frame/start unbounded preceding OK 38ms
/window functions/tests/distributed/frame clause/range frame OK 3s 79ms
/window functions/tests/distributed/frame clause/range frame/between current row and current row OK 82ms
/window functions/tests/distributed/frame clause/range frame/between current row and expr following with order by OK 39ms
/window functions/tests/distributed/frame clause/range frame/between current row and expr following without order by error OK 36ms
/window functions/tests/distributed/frame clause/range frame/between current row and expr preceding error OK 71ms
/window functions/tests/distributed/frame clause/range frame/between current row and unbounded following OK 124ms
/window functions/tests/distributed/frame clause/range frame/between current row and unbounded following in named window OK 41ms
/window functions/tests/distributed/frame clause/range frame/between current row and unbounded following modifying named window XFail 42ms
/window functions/tests/distributed/frame clause/range frame/between current row and unbounded preceding error OK 70ms
/window functions/tests/distributed/frame clause/range frame/between expr following and current row with order by error OK 35ms
/window functions/tests/distributed/frame clause/range frame/between expr following and current row without order by error OK 45ms
/window functions/tests/distributed/frame clause/range frame/between expr following and current row zero special case XFail 40ms
/window functions/tests/distributed/frame clause/range frame/between expr following and expr following with order by OK 39ms
/window functions/tests/distributed/frame clause/range frame/between expr following and expr following with order by error OK 35ms
/window functions/tests/distributed/frame clause/range frame/between expr following and expr following without order by error XFail 38ms
/window functions/tests/distributed/frame clause/range frame/between expr following and expr preceding error OK 71ms
/window functions/tests/distributed/frame clause/range frame/between expr following and expr preceding with order by zero special case XFail 41ms
/window functions/tests/distributed/frame clause/range frame/between expr following and expr preceding without order by error XFail 38ms
/window functions/tests/distributed/frame clause/range frame/between expr following and unbounded following with order by OK 37ms
/window functions/tests/distributed/frame clause/range frame/between expr following and unbounded following without order by error OK 36ms
/window functions/tests/distributed/frame clause/range frame/between expr following and unbounded preceding error OK 70ms
/window functions/tests/distributed/frame clause/range frame/between expr preceding and current row with order by OK 39ms
/window functions/tests/distributed/frame clause/range frame/between expr preceding and current row without order by error OK 34ms
/window functions/tests/distributed/frame clause/range frame/between expr preceding and expr following with order by OK 80ms
/window functions/tests/distributed/frame clause/range frame/between expr preceding and expr following with partition and order by OK 44ms
/window functions/tests/distributed/frame clause/range frame/between expr preceding and expr following with partition by same column twice OK 42ms
/window functions/tests/distributed/frame clause/range frame/between expr preceding and expr following with partition by two columns OK 40ms
/window functions/tests/distributed/frame clause/range frame/between expr preceding and expr following without order by error OK 35ms
/window functions/tests/distributed/frame clause/range frame/between expr preceding and expr preceding with order by OK 81ms
/window functions/tests/distributed/frame clause/range frame/between expr preceding and expr preceding with order by error OK 37ms
/window functions/tests/distributed/frame clause/range frame/between expr preceding and expr preceding without order by error OK 34ms
/window functions/tests/distributed/frame clause/range frame/between expr preceding and unbounded following with order by OK 39ms
/window functions/tests/distributed/frame clause/range frame/between expr preceding and unbounded following without order by error OK 35ms
/window functions/tests/distributed/frame clause/range frame/between expr preceding and unbounded preceding error OK 69ms
/window functions/tests/distributed/frame clause/range frame/between unbounded following and current row error OK 73ms
/window functions/tests/distributed/frame clause/range frame/between unbounded following and expr following error OK 69ms
/window functions/tests/distributed/frame clause/range frame/between unbounded following and expr preceding error OK 69ms
/window functions/tests/distributed/frame clause/range frame/between unbounded following and unbounded following error OK 70ms
/window functions/tests/distributed/frame clause/range frame/between unbounded following and unbounded preceding error OK 71ms
/window functions/tests/distributed/frame clause/range frame/between unbounded preceding and current row OK 98ms
/window functions/tests/distributed/frame clause/range frame/between unbounded preceding and current row with expressions in order by and aggregate OK 41ms
/window functions/tests/distributed/frame clause/range frame/between unbounded preceding and expr following with order by OK 40ms
/window functions/tests/distributed/frame clause/range frame/between unbounded preceding and expr following without order by error OK 35ms
/window functions/tests/distributed/frame clause/range frame/between unbounded preceding and expr preceding with order by OK 39ms
/window functions/tests/distributed/frame clause/range frame/between unbounded preceding and expr preceding without order by error OK 35ms
/window functions/tests/distributed/frame clause/range frame/between unbounded preceding and unbounded following OK 81ms
/window functions/tests/distributed/frame clause/range frame/between unbounded preceding and unbounded preceding error OK 70ms
/window functions/tests/distributed/frame clause/range frame/invalid frame extent OK 33ms
/window functions/tests/distributed/frame clause/range frame/missing frame extent OK 33ms
/window functions/tests/distributed/frame clause/range frame/order by decimal XFail 43ms
/window functions/tests/distributed/frame clause/range frame/order by float OK 40ms
/window functions/tests/distributed/frame clause/range frame/start current row with order by OK 39ms
/window functions/tests/distributed/frame clause/range frame/start current row without order by OK 39ms
/window functions/tests/distributed/frame clause/range frame/start expr following with order by error OK 35ms
/window functions/tests/distributed/frame clause/range frame/start expr following without order by error OK 34ms
/window functions/tests/distributed/frame clause/range frame/start expr preceding order by non numerical column error OK 39ms
/window functions/tests/distributed/frame clause/range frame/start expr preceding with order by OK 39ms
/window functions/tests/distributed/frame clause/range frame/start expr preceding without order by error OK 36ms
/window functions/tests/distributed/frame clause/range frame/start unbounded following error OK 72ms
/window functions/tests/distributed/frame clause/range frame/start unbounded preceding with order by OK 40ms
/window functions/tests/distributed/frame clause/range frame/start unbounded preceding without order by OK 42ms
/window functions/tests/distributed/frame clause/range frame/with nulls XFail 43ms
/window functions/tests/distributed/frame clause/range overflow OK 236ms
/window functions/tests/distributed/frame clause/range overflow/negative overflow for Int32 OK 38ms
/window functions/tests/distributed/frame clause/range overflow/negative overflow for Int64 OK 37ms
/window functions/tests/distributed/frame clause/range overflow/negative overflow with Int16 XFail 40ms
/window functions/tests/distributed/frame clause/range overflow/positive overflow for Int32 OK 37ms
/window functions/tests/distributed/frame clause/range overflow/positive overflow for Int64 OK 41ms
/window functions/tests/distributed/frame clause/range overflow/positive overflow with Int16 XFail 39ms
/window functions/tests/distributed/frame clause/range datetime OK 353ms
/window functions/tests/distributed/frame clause/range datetime/datetime order by asc range between n preceding and n following OK 41ms
/window functions/tests/distributed/frame clause/range datetime/datetime order by desc range between n preceding and n following OK 41ms
/window functions/tests/distributed/frame clause/range datetime/datetime with timezone order by asc range between n preceding and n following OK 57ms
/window functions/tests/distributed/frame clause/range datetime/datetime with timezone order by desc range between n preceding and n following OK 52ms
/window functions/tests/distributed/frame clause/range datetime/order by asc range between days preceding and days following XFail 40ms
/window functions/tests/distributed/frame clause/range datetime/order by desc range between days following and days following XFail 39ms
/window functions/tests/distributed/frame clause/range datetime/order by desc range between days preceding and days following XFail 39ms
/window functions/tests/distributed/frame clause/range datetime/order by desc range between days preceding and days preceding XFail 40ms
/window functions/tests/distributed/frame clause/range errors OK 227ms
/window functions/tests/distributed/frame clause/range errors/error missing order by OK 36ms
/window functions/tests/distributed/frame clause/range errors/error missing order by with partition by clause OK 36ms
/window functions/tests/distributed/frame clause/range errors/error more than one order by column OK 36ms
/window functions/tests/distributed/frame clause/range errors/error negative following offset XFail 39ms
/window functions/tests/distributed/frame clause/range errors/error negative preceding offset XFail 39ms
/window functions/tests/distributed/frame clause/range errors/error range over non numerical column OK 39ms
/window functions/tests/distributed/window clause OK 232ms
/window functions/tests/distributed/window clause/missing window spec OK 34ms
/window functions/tests/distributed/window clause/multiple identical windows OK 39ms
/window functions/tests/distributed/window clause/multiple windows OK 39ms
/window functions/tests/distributed/window clause/single window OK 41ms
/window functions/tests/distributed/window clause/unused window OK 76ms
/window functions/tests/distributed/over clause OK 224ms
/window functions/tests/distributed/over clause/adhoc window OK 40ms
/window functions/tests/distributed/over clause/empty OK 39ms
/window functions/tests/distributed/over clause/empty named window OK 38ms
/window functions/tests/distributed/over clause/invalid multiple windows OK 35ms
/window functions/tests/distributed/over clause/invalid window name OK 35ms
/window functions/tests/distributed/over clause/missing window spec OK 33ms
/window functions/tests/distributed/funcs OK 1s 250ms
/window functions/tests/distributed/funcs/dense rank OK 43ms
/window functions/tests/distributed/funcs/first value OK 127ms
/window functions/tests/distributed/funcs/first value with lead workaround OK 53ms
/window functions/tests/distributed/funcs/lag OK 121ms
/window functions/tests/distributed/funcs/lagInFrame OK 193ms
/window functions/tests/distributed/funcs/last value OK 166ms
/window functions/tests/distributed/funcs/last value with lag workaround OK 56ms
/window functions/tests/distributed/funcs/last value with no frame OK 41ms
/window functions/tests/distributed/funcs/lead OK 163ms
/window functions/tests/distributed/funcs/leadInFrame OK 198ms
/window functions/tests/distributed/funcs/rank OK 40ms
/window functions/tests/distributed/funcs/row number OK 39ms
/window functions/tests/distributed/aggregate funcs OK 3s 103ms
/window functions/tests/distributed/aggregate funcs/aggregate and window function in the same window OK 39ms
/window functions/tests/distributed/aggregate funcs/aggregate funcs over rows frame OK 2s 559ms
/window functions/tests/distributed/aggregate funcs/aggregate function recovers from nan OK 40ms
/window functions/tests/distributed/aggregate funcs/avgWeighted OK 114ms
/window functions/tests/distributed/aggregate funcs/avg with nulls OK 38ms
/window functions/tests/distributed/aggregate funcs/bit functions OK 38ms
/window functions/tests/distributed/aggregate funcs/nested aggregates OK 40ms
/window functions/tests/distributed/aggregate funcs/stddevpop OK 39ms
/window functions/tests/distributed/aggregate funcs/stddevsamp OK 38ms
/window functions/tests/distributed/aggregate funcs/sum OK 39ms
/window functions/tests/distributed/aggregate funcs/ungrouped aggregate over empty row set OK 36ms
/window functions/tests/distributed/aggregate funcs/var pop OK 37ms
/window functions/tests/distributed/aggregate funcs/var samp OK 37ms
/window functions/tests/distributed/time decayed funcs OK 1m 9s
/window functions/tests/distributed/time decayed funcs/exponentialTimeDecayedAvg OK 6s 764ms
/window functions/tests/distributed/time decayed funcs/exponentialTimeDecayedCount OK 6s 76ms
/window functions/tests/distributed/time decayed funcs/exponentialTimeDecayedMax OK 50s 48ms
/window functions/tests/distributed/time decayed funcs/exponentialTimeDecayedSum OK 6s 736ms
/window functions/tests/distributed/errors OK 361ms
/window functions/tests/distributed/errors/error coma between partition by and order by clause OK 34ms
/window functions/tests/distributed/errors/error named window defined twice OK 36ms
/window functions/tests/distributed/errors/error order by another window function OK 35ms
/window functions/tests/distributed/errors/error select from window OK 35ms
/window functions/tests/distributed/errors/error using non window function OK 34ms
/window functions/tests/distributed/errors/error window function in alter delete where OK 37ms
/window functions/tests/distributed/errors/error window function in group by OK 35ms
/window functions/tests/distributed/errors/error window function in having OK 35ms
/window functions/tests/distributed/errors/error window function in join OK 38ms
/window functions/tests/distributed/errors/error window function in where OK 35ms
/window functions/tests/distributed/misc OK 821ms
/window functions/tests/distributed/misc/count with empty over clause without start OK 36ms
/window functions/tests/distributed/misc/empty table OK 39ms
/window functions/tests/distributed/misc/exclude clause OK 35ms
/window functions/tests/distributed/misc/from subquery OK 40ms
/window functions/tests/distributed/misc/group by and multiple windows OK 54ms
/window functions/tests/distributed/misc/group by and one window OK 41ms
/window functions/tests/distributed/misc/groups frame OK 37ms
/window functions/tests/distributed/misc/in view OK 197ms
/window functions/tests/distributed/misc/query with order by and one window OK 39ms
/window functions/tests/distributed/misc/subquery expr preceding OK 44ms
/window functions/tests/distributed/misc/subquery multiple window functions OK 46ms
/window functions/tests/distributed/misc/subquery with multiple windows filtering OK 44ms
/window functions/tests/distributed/misc/window functions in select expression XFail 40ms
/window functions/tests/distributed/misc/window functions in subquery XFail 40ms
/window functions/tests/distributed/misc/windows with same partitioning but different ordering OK 41ms
/window functions/tests/distributed/misc/with union all OK 39ms
/window functions/tests/distributed/datatypes OK 454ms
/window functions/tests/distributed/datatypes/date OK 36ms
/window functions/tests/distributed/datatypes/datetime OK 36ms
/window functions/tests/distributed/datatypes/datetime64 OK 40ms
/window functions/tests/distributed/datatypes/decimal32 OK 36ms
/window functions/tests/distributed/datatypes/enum OK 37ms
/window functions/tests/distributed/datatypes/fixed string OK 36ms
/window functions/tests/distributed/datatypes/ipv4 OK 38ms
/window functions/tests/distributed/datatypes/ipv6 OK 37ms
/window functions/tests/distributed/datatypes/low cardinality OK 37ms
/window functions/tests/distributed/datatypes/map OK 36ms
/window functions/tests/distributed/datatypes/string OK 41ms
/window functions/tests/distributed/datatypes/uuid OK 36ms
/window functions/tests/distributed/non-negative derivative func Skip 653us

Generated by TestFlows Open-Source Test Framework v1.9.220810.1192506