Copyright 2025, 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

DateApr 02, 2025 12:03
Duration8m 45s
Framework TestFlows 2.0.250110.1002922

Artifacts

Test artifacts can be found at https://altinity-build-artifacts.s3.amazonaws.com/index.html#697/abdd84aa063c8b2035592258c91ae296a05290b5/regression/aarch64/with_analyzer/zookeeper/without_thread_fuzzer/window_functions/

Attributes

projectAltinity/ClickHouse
project.id159717931
packagehttps://s3.amazonaws.com/altinity-build-artifacts/PRs/697/abdd84aa063c8b2035592258c91ae296a05290b5/package_aarch64/clickhouse-common-static_24.12.2.20247.altinityantalya_arm64.deb
version24.12.2.20247.altinityantalya
user.namearthurpassos
repositoryhttps://github.com/Altinity/clickhouse-regression
commit.hashbd31e738c0cedaca253d15a05ed245c41b6e0b6a
job.nameCommon
job.retry1
job.urlhttps://github.com/Altinity/ClickHouse/actions/runs/14217829512
archaarch64
localTrue
clickhouse_versionNone
clickhouse_pathhttps://s3.amazonaws.com/altinity-build-artifacts/PRs/697/abdd84aa063c8b2035592258c91ae296a05290b5/package_aarch64/clickhouse-common-static_24.12.2.20247.altinityantalya_arm64.deb
as_binaryFalse
base_osNone
keeper_pathNone
zookeeper_versionNone
use_keeperFalse
stressFalse
collect_service_logsTrue
thread_fuzzerFalse
with_analyzerTrue
reuse_envFalse

Summary

97.6%OK
2.4%Known

Statistics

Units Skip OK Fail Error XFail
Modules
1
1
Features
39
39
Scenarios
458
1
433
24
Checks
256
252
4
Examples
1418
1394
24
Steps
7664
7576
72
6
10

Known Fails

Test NameResultMessage
/window functions/tests/non distributed/frame clause/range frame/between expr following and current row zero special caseXFail 93ms
known bug
AssertionError
Traceback (most recent call last):
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 274, in 
    regression()
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/argparser.py", line 171, in capture_cluster_args
    return func(self, cluster_args=cluster_args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 270, in regression
    Feature(run=load("window_functions.tests.feature", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/feature.py", line 75, in feature
    Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/frame_clause.py", line 68, in feature
    Feature(run=load("window_functions.tests.range_frame", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_frame.py", line 1745, in feature
    Scenario(run=scenario, flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_frame.py", line 1353, in between_expr_following_and_current_row_zero_special_case
    execute_query(
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/common.py", line 159, in execute_query
    r = current().context.node.query(
        ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 1188, in query
    assert False, error(r.output)
           ^^^^^
AssertionError: Oops! Assertion failed

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

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

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

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

1180\|                  assert message in r.output, error(r.output)
1181\|  
1182\|          if not ignore_exception:
1183\|              if message is None or "Exception:" not in message:
1184\|                  with Then("check if output has exception") if steps else NullStep():
1185\|                      if "Exception:" in r.output:
1186\|                          if raise_on_exception:
1187\|                              raise QueryRuntimeException(r.output)
1188\|>                         assert False, error(r.output)
1189\|  
1190\|          return r
1191\|
/window functions/tests/non distributed/frame clause/range frame/between expr following and expr following without order by errorXFail 76ms
invalid error message
AssertionError
Traceback (most recent call last):
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 274, in 
    regression()
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/argparser.py", line 171, in capture_cluster_args
    return func(self, cluster_args=cluster_args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 270, in regression
    Feature(run=load("window_functions.tests.feature", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/feature.py", line 75, in feature
    Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/frame_clause.py", line 68, in feature
    Feature(run=load("window_functions.tests.range_frame", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_frame.py", line 1745, in feature
    Scenario(run=scenario, flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_frame.py", line 1217, in between_expr_following_and_expr_following_without_order_by_error
    self.context.node.query(
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 1180, in query
    assert message in r.output, error(r.output)
           ^^^^^^^^^^^^^^^^^^^
AssertionError: Oops! Assertion failed

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

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

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

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

1172\|                  assert r.exitcode == exitcode, error(r.output)
1173\|  
1174\|          if message is not None:
1175\|              with (
1176\|                  Then(f"output should contain message", description=message)
1177\|                  if steps
1178\|                  else NullStep()
1179\|              ):
1180\|>                 assert message in r.output, error(r.output)
1181\|  
1182\|          if not ignore_exception:
1183\|              if message is None or "Exception:" not in message:
/window functions/tests/non distributed/frame clause/range frame/between expr following and expr preceding with order by zero special caseXFail 79ms
known bug
AssertionError
Traceback (most recent call last):
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 274, in 
    regression()
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/argparser.py", line 171, in capture_cluster_args
    return func(self, cluster_args=cluster_args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 270, in regression
    Feature(run=load("window_functions.tests.feature", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/feature.py", line 75, in feature
    Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/frame_clause.py", line 68, in feature
    Feature(run=load("window_functions.tests.range_frame", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_frame.py", line 1745, in feature
    Scenario(run=scenario, flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_frame.py", line 1422, in between_expr_following_and_expr_preceding_with_order_by_zero_special_case
    execute_query(
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/common.py", line 159, in execute_query
    r = current().context.node.query(
        ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 1188, in query
    assert False, error(r.output)
           ^^^^^
AssertionError: Oops! Assertion failed

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

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

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

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

1180\|                  assert message in r.output, error(r.output)
1181\|  
1182\|          if not ignore_exception:
1183\|              if message is None or "Exception:" not in message:
1184\|                  with Then("check if output has exception") if steps else NullStep():
1185\|                      if "Exception:" in r.output:
1186\|                          if raise_on_exception:
1187\|                              raise QueryRuntimeException(r.output)
1188\|>                         assert False, error(r.output)
1189\|  
1190\|          return r
1191\|
/window functions/tests/non distributed/frame clause/range frame/between expr following and expr preceding without order by errorXFail 68ms
invalid error message
AssertionError
Traceback (most recent call last):
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 274, in 
    regression()
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/argparser.py", line 171, in capture_cluster_args
    return func(self, cluster_args=cluster_args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 270, in regression
    Feature(run=load("window_functions.tests.feature", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/feature.py", line 75, in feature
    Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/frame_clause.py", line 68, in feature
    Feature(run=load("window_functions.tests.range_frame", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_frame.py", line 1745, in feature
    Scenario(run=scenario, flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_frame.py", line 1234, in between_expr_following_and_expr_preceding_without_order_by_error
    self.context.node.query(
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 1180, in query
    assert message in r.output, error(r.output)
           ^^^^^^^^^^^^^^^^^^^
AssertionError: Oops! Assertion failed

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

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

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

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

1172\|                  assert r.exitcode == exitcode, error(r.output)
1173\|  
1174\|          if message is not None:
1175\|              with (
1176\|                  Then(f"output should contain message", description=message)
1177\|                  if steps
1178\|                  else NullStep()
1179\|              ):
1180\|>                 assert message in r.output, error(r.output)
1181\|  
1182\|          if not ignore_exception:
1183\|              if message is None or "Exception:" not in message:
/window functions/tests/non distributed/frame clause/range frame/order by decimalXFail 71ms
Exception: The RANGE OFFSET frame for 'DB::ColumnDecimal >' ORDER BY column is not implemented
AssertionError
Traceback (most recent call last):
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 274, in 
    regression()
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/argparser.py", line 171, in capture_cluster_args
    return func(self, cluster_args=cluster_args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 270, in regression
    Feature(run=load("window_functions.tests.feature", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/feature.py", line 75, in feature
    Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/frame_clause.py", line 68, in feature
    Feature(run=load("window_functions.tests.range_frame", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_frame.py", line 1745, in feature
    Scenario(run=scenario, flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_frame.py", line 1658, in order_by_decimal
    execute_query(
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/common.py", line 159, in execute_query
    r = current().context.node.query(
        ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 1188, in query
    assert False, error(r.output)
           ^^^^^
AssertionError: Oops! Assertion failed

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

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

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

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

1180\|                  assert message in r.output, error(r.output)
1181\|  
1182\|          if not ignore_exception:
1183\|              if message is None or "Exception:" not in message:
1184\|                  with Then("check if output has exception") if steps else NullStep():
1185\|                      if "Exception:" in r.output:
1186\|                          if raise_on_exception:
1187\|                              raise QueryRuntimeException(r.output)
1188\|>                         assert False, error(r.output)
1189\|  
1190\|          return r
1191\|
/window functions/tests/non distributed/frame clause/range frame/with nullsXFail 94ms
DB::Exception: The RANGE OFFSET frame for 'DB::ColumnNullable' ORDER BY column is not implemented
AssertionError
Traceback (most recent call last):
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 274, in 
    regression()
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/argparser.py", line 171, in capture_cluster_args
    return func(self, cluster_args=cluster_args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 270, in regression
    Feature(run=load("window_functions.tests.feature", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/feature.py", line 75, in feature
    Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/frame_clause.py", line 68, in feature
    Feature(run=load("window_functions.tests.range_frame", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_frame.py", line 1745, in feature
    Scenario(run=scenario, flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_frame.py", line 1719, in with_nulls
    execute_query(
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/common.py", line 171, in execute_query
    assert r.output.strip() == expected, error()
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^
AssertionError: Oops! Assertion failed

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

Assertion values
  assert r.output.strip() == expected, error()
         ^ is 
  assert r.output.strip() == expected, error()
         ^ is = 'x\ty\tfirst_value\tlast_value\n1\t1\t1\t3\n2\t2\t1\t4\n3\t3\t1\t5\n4\t4\t2\t5\n5\t5\t3\t5\n\\N\t42\t42\t43\n\\N\t43\t42\t43'
  assert r.output.strip() == expected, error()
         ^ is 'x\ty\tfirst_value\tlast_value\n1\t1\t1\t3\n2\t2\t1\t4\n3\t3\t1\t5\n4\t4\t2\t5\n5\t5\t3\t5\n\\N\t42\t42\t43\n\\N\t43\t42\t43'
  assert r.output.strip() == expected, error()
         ^ is = 
  assert r.output.strip() == expected, error()
         ^ is = 'x\ty\tfirst_value\tlast_value\n1\t1\t1\t3\n2\t2\t1\t4\n3\t3\t1\t5\n4\t4\t2\t5\n5\t5\t3\t5\n\\N\t42\t42\t43\n\\N\t43\t42\t43'
  assert r.output.strip() == expected, error()
                             ^ is 'x\ty\tfirst_value\tlast_value\n\\N\t42\t42\t43\n\\N\t43\t42\t43\n1\t1\t1\t3\n2\t2\t1\t4\n3\t3\t1\t5\n4\t4\t2\t5\n5\t5\t3\t5'
  assert r.output.strip() == expected, error()
                          ^ is = False
    @@ -1,0 +2,2 @@
    +\N 42  42  43
    +\N 43  42  43
    @@ -7,2 +8,0 @@
    -\N 42  42  43
    -\N 43  42  43
  assert r.output.strip() == expected, error()
  ^ is False

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

163\|              no_checks=no_checks,
164\|          )
165\|          if no_checks:
166\|              return r
167\|  
168\|      if message is None:
169\|          if expected is not None:
170\|              with Then("I check output against expected"):
171\|>                 assert r.output.strip() == expected, error()
172\|          else:
173\|              with Then("I check output against snapshot"):
174\|                  with values() as that:
/window functions/tests/non distributed/frame clause/range overflow/negative overflow with Int16XFail 91ms
exception on conversion
AssertionError
Traceback (most recent call last):
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 274, in 
    regression()
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/argparser.py", line 171, in capture_cluster_args
    return func(self, cluster_args=cluster_args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 270, in regression
    Feature(run=load("window_functions.tests.feature", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/feature.py", line 75, in feature
    Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/frame_clause.py", line 69, in feature
    Feature(run=load("window_functions.tests.range_overflow", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_overflow.py", line 145, in feature
    Scenario(run=scenario, flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_overflow.py", line 42, in negative_overflow_with_Int16
    execute_query(
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/common.py", line 159, in execute_query
    r = current().context.node.query(
        ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 1188, in query
    assert False, error(r.output)
           ^^^^^
AssertionError: Oops! Assertion failed

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

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

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

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

1180\|                  assert message in r.output, error(r.output)
1181\|  
1182\|          if not ignore_exception:
1183\|              if message is None or "Exception:" not in message:
1184\|                  with Then("check if output has exception") if steps else NullStep():
1185\|                      if "Exception:" in r.output:
1186\|                          if raise_on_exception:
1187\|                              raise QueryRuntimeException(r.output)
1188\|>                         assert False, error(r.output)
1189\|  
1190\|          return r
1191\|
/window functions/tests/non distributed/frame clause/range overflow/positive overflow with Int16XFail 80ms
exception on conversion
AssertionError
Traceback (most recent call last):
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 274, in 
    regression()
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/argparser.py", line 171, in capture_cluster_args
    return func(self, cluster_args=cluster_args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 270, in regression
    Feature(run=load("window_functions.tests.feature", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/feature.py", line 75, in feature
    Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/frame_clause.py", line 69, in feature
    Feature(run=load("window_functions.tests.range_overflow", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_overflow.py", line 145, in feature
    Scenario(run=scenario, flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_overflow.py", line 20, in positive_overflow_with_Int16
    execute_query(
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/common.py", line 159, in execute_query
    r = current().context.node.query(
        ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 1188, in query
    assert False, error(r.output)
           ^^^^^
AssertionError: Oops! Assertion failed

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

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

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

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

1180\|                  assert message in r.output, error(r.output)
1181\|  
1182\|          if not ignore_exception:
1183\|              if message is None or "Exception:" not in message:
1184\|                  with Then("check if output has exception") if steps else NullStep():
1185\|                      if "Exception:" in r.output:
1186\|                          if raise_on_exception:
1187\|                              raise QueryRuntimeException(r.output)
1188\|>                         assert False, error(r.output)
1189\|  
1190\|          return r
1191\|
/window functions/tests/non distributed/frame clause/range errors/error negative following offsetXFail 76ms
https://github.com/ClickHouse/ClickHouse/issues/22442
AssertionError
Traceback (most recent call last):
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 274, in 
    regression()
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/argparser.py", line 171, in capture_cluster_args
    return func(self, cluster_args=cluster_args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 270, in regression
    Feature(run=load("window_functions.tests.feature", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/feature.py", line 75, in feature
    Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/frame_clause.py", line 71, in feature
    Feature(run=load("window_functions.tests.range_errors", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_errors.py", line 114, in feature
    Scenario(run=scenario, flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_errors.py", line 105, in error_negative_following_offset
    r = current().context.node.query(sql, exitcode=exitcode, message=message)
        ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 1180, in query
    assert message in r.output, error(r.output)
           ^^^^^^^^^^^^^^^^^^^
AssertionError: Oops! Assertion failed

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

Description
  Received exception from server (version 24.12.2):
Code: 36. DB::Exception: Received from localhost:9000. DB::Exception: Frame end offset for 'RANGE' frame must be a nonnegative 32-bit integer, '-2' of type 'Int64' given. (BAD_ARGUMENTS)
(query: select max(enroll_date) over (order by salary range between 1 preceding and -2 following) AS max, salary, enroll_date from empsalary FORMAT TabSeparated
)

Assertion values
  assert message in r.output, error(r.output)
         ^ is 'DB::Exception: Frame end offset must be greater than zero, -2 given'
  assert message in r.output, error(r.output)
                    ^ is 
  assert message in r.output, error(r.output)
                    ^ is = "Received exception from server (version 24.12.2):\nCode: 36. DB::Exception: Received from localhost:9000. DB::Exception: Frame end offset for 'RANGE' frame must be a nonnegative 32-bit integer, '-2' of type 'Int64' given. (BAD_ARGUMENTS)\n(query: select max(enroll_date) over (order by salary range between 1 preceding and -2 following) AS max, salary, enroll_date from empsalary FORMAT TabSeparated\n)"
  assert message in r.output, error(r.output)
                 ^ is = False
  assert message in r.output, error(r.output)
  ^ is False

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

1172\|                  assert r.exitcode == exitcode, error(r.output)
1173\|  
1174\|          if message is not None:
1175\|              with (
1176\|                  Then(f"output should contain message", description=message)
1177\|                  if steps
1178\|                  else NullStep()
1179\|              ):
1180\|>                 assert message in r.output, error(r.output)
1181\|  
1182\|          if not ignore_exception:
1183\|              if message is None or "Exception:" not in message:
/window functions/tests/non distributed/frame clause/range errors/error negative preceding offsetXFail 69ms
https://github.com/ClickHouse/ClickHouse/issues/22442
AssertionError
Traceback (most recent call last):
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 274, in 
    regression()
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/argparser.py", line 171, in capture_cluster_args
    return func(self, cluster_args=cluster_args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 270, in regression
    Feature(run=load("window_functions.tests.feature", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/feature.py", line 75, in feature
    Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/frame_clause.py", line 71, in feature
    Feature(run=load("window_functions.tests.range_errors", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_errors.py", line 114, in feature
    Scenario(run=scenario, flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_errors.py", line 89, in error_negative_preceding_offset
    r = current().context.node.query(sql, exitcode=exitcode, message=message)
        ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 1180, in query
    assert message in r.output, error(r.output)
           ^^^^^^^^^^^^^^^^^^^
AssertionError: Oops! Assertion failed

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

Description
  Received exception from server (version 24.12.2):
Code: 36. DB::Exception: Received from localhost:9000. DB::Exception: Frame start offset for 'RANGE' frame must be a nonnegative 32-bit integer, '-1' of type 'Int64' given. (BAD_ARGUMENTS)
(query: select max(enroll_date) over (order by salary range between -1 preceding and 2 following) AS max, salary, enroll_date from empsalary FORMAT TabSeparated
)

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

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

1172\|                  assert r.exitcode == exitcode, error(r.output)
1173\|  
1174\|          if message is not None:
1175\|              with (
1176\|                  Then(f"output should contain message", description=message)
1177\|                  if steps
1178\|                  else NullStep()
1179\|              ):
1180\|>                 assert message in r.output, error(r.output)
1181\|  
1182\|          if not ignore_exception:
1183\|              if message is None or "Exception:" not in message:
/window functions/tests/non distributed/misc/subquery expr precedingXFail 114ms
subquery is not supported as offset
AssertionError
Traceback (most recent call last):
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 274, in 
    regression()
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/argparser.py", line 171, in capture_cluster_args
    return func(self, cluster_args=cluster_args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 270, in regression
    Feature(run=load("window_functions.tests.feature", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/feature.py", line 82, in feature
    Feature(run=load("window_functions.tests.misc", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/misc.py", line 466, in feature
    Scenario(run=scenario, flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/misc.py", line 27, in subquery_expr_preceding
    execute_query(
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/common.py", line 171, in execute_query
    assert r.output.strip() == expected, error()
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^
AssertionError: Oops! Assertion failed

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

Assertion values
  assert r.output.strip() == expected, error()
         ^ is 
  assert r.output.strip() == expected, error()
         ^ is = 'sum\tunique1\n0\t0\n1\t1\n3\t2\n5\t3\n7\t4\n9\t5\n11\t6\n13\t7\n15\t8\n17\t9'
  assert r.output.strip() == expected, error()
         ^ is 'sum\tunique1\n0\t0\n1\t1\n3\t2\n5\t3\n7\t4\n9\t5\n11\t6\n13\t7\n15\t8\n17\t9'
  assert r.output.strip() == expected, error()
         ^ is = 
  assert r.output.strip() == expected, error()
         ^ is = 'sum\tunique1\n0\t0\n1\t1\n3\t2\n5\t3\n7\t4\n9\t5\n11\t6\n13\t7\n15\t8\n17\t9'
  assert r.output.strip() == expected, error()
                             ^ is 'sum\tunique1\n0\t0\n1\t1\n3\t2\n5\t3Fmu\n7\t4\n9\t5\n11\t6\n13\t7\n15\t8\n17\t9'
  assert r.output.strip() == expected, error()
                          ^ is = False
    @@ -5 +5 @@
    -5  3
    +5  3Fmu
  assert r.output.strip() == expected, error()
  ^ is False

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

163\|              no_checks=no_checks,
164\|          )
165\|          if no_checks:
166\|              return r
167\|  
168\|      if message is None:
169\|          if expected is not None:
170\|              with Then("I check output against expected"):
171\|>                 assert r.output.strip() == expected, error()
172\|          else:
173\|              with Then("I check output against snapshot"):
174\|                  with values() as that:
/window functions/tests/distributed/frame clause/range frame/between expr following and current row zero special caseXFail 69ms
known bug
AssertionError
Traceback (most recent call last):
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 274, in 
    regression()
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/argparser.py", line 171, in capture_cluster_args
    return func(self, cluster_args=cluster_args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 270, in regression
    Feature(run=load("window_functions.tests.feature", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/feature.py", line 75, in feature
    Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/frame_clause.py", line 68, in feature
    Feature(run=load("window_functions.tests.range_frame", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_frame.py", line 1745, in feature
    Scenario(run=scenario, flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_frame.py", line 1353, in between_expr_following_and_current_row_zero_special_case
    execute_query(
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/common.py", line 159, in execute_query
    r = current().context.node.query(
        ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 1188, in query
    assert False, error(r.output)
           ^^^^^
AssertionError: Oops! Assertion failed

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

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

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

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

1180\|                  assert message in r.output, error(r.output)
1181\|  
1182\|          if not ignore_exception:
1183\|              if message is None or "Exception:" not in message:
1184\|                  with Then("check if output has exception") if steps else NullStep():
1185\|                      if "Exception:" in r.output:
1186\|                          if raise_on_exception:
1187\|                              raise QueryRuntimeException(r.output)
1188\|>                         assert False, error(r.output)
1189\|  
1190\|          return r
1191\|
/window functions/tests/distributed/frame clause/range frame/between expr following and expr following without order by errorXFail 64ms
invalid error message
AssertionError
Traceback (most recent call last):
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 274, in 
    regression()
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/argparser.py", line 171, in capture_cluster_args
    return func(self, cluster_args=cluster_args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 270, in regression
    Feature(run=load("window_functions.tests.feature", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/feature.py", line 75, in feature
    Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/frame_clause.py", line 68, in feature
    Feature(run=load("window_functions.tests.range_frame", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_frame.py", line 1745, in feature
    Scenario(run=scenario, flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_frame.py", line 1217, in between_expr_following_and_expr_following_without_order_by_error
    self.context.node.query(
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 1180, in query
    assert message in r.output, error(r.output)
           ^^^^^^^^^^^^^^^^^^^
AssertionError: Oops! Assertion failed

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

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

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

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

1172\|                  assert r.exitcode == exitcode, error(r.output)
1173\|  
1174\|          if message is not None:
1175\|              with (
1176\|                  Then(f"output should contain message", description=message)
1177\|                  if steps
1178\|                  else NullStep()
1179\|              ):
1180\|>                 assert message in r.output, error(r.output)
1181\|  
1182\|          if not ignore_exception:
1183\|              if message is None or "Exception:" not in message:
/window functions/tests/distributed/frame clause/range frame/between expr following and expr preceding with order by zero special caseXFail 79ms
known bug
AssertionError
Traceback (most recent call last):
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 274, in 
    regression()
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/argparser.py", line 171, in capture_cluster_args
    return func(self, cluster_args=cluster_args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 270, in regression
    Feature(run=load("window_functions.tests.feature", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/feature.py", line 75, in feature
    Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/frame_clause.py", line 68, in feature
    Feature(run=load("window_functions.tests.range_frame", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_frame.py", line 1745, in feature
    Scenario(run=scenario, flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_frame.py", line 1422, in between_expr_following_and_expr_preceding_with_order_by_zero_special_case
    execute_query(
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/common.py", line 159, in execute_query
    r = current().context.node.query(
        ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 1188, in query
    assert False, error(r.output)
           ^^^^^
AssertionError: Oops! Assertion failed

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

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

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

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

1180\|                  assert message in r.output, error(r.output)
1181\|  
1182\|          if not ignore_exception:
1183\|              if message is None or "Exception:" not in message:
1184\|                  with Then("check if output has exception") if steps else NullStep():
1185\|                      if "Exception:" in r.output:
1186\|                          if raise_on_exception:
1187\|                              raise QueryRuntimeException(r.output)
1188\|>                         assert False, error(r.output)
1189\|  
1190\|          return r
1191\|
/window functions/tests/distributed/frame clause/range frame/between expr following and expr preceding without order by errorXFail 69ms
invalid error message
AssertionError
Traceback (most recent call last):
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 274, in 
    regression()
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/argparser.py", line 171, in capture_cluster_args
    return func(self, cluster_args=cluster_args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 270, in regression
    Feature(run=load("window_functions.tests.feature", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/feature.py", line 75, in feature
    Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/frame_clause.py", line 68, in feature
    Feature(run=load("window_functions.tests.range_frame", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_frame.py", line 1745, in feature
    Scenario(run=scenario, flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_frame.py", line 1234, in between_expr_following_and_expr_preceding_without_order_by_error
    self.context.node.query(
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 1180, in query
    assert message in r.output, error(r.output)
           ^^^^^^^^^^^^^^^^^^^
AssertionError: Oops! Assertion failed

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

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

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

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

1172\|                  assert r.exitcode == exitcode, error(r.output)
1173\|  
1174\|          if message is not None:
1175\|              with (
1176\|                  Then(f"output should contain message", description=message)
1177\|                  if steps
1178\|                  else NullStep()
1179\|              ):
1180\|>                 assert message in r.output, error(r.output)
1181\|  
1182\|          if not ignore_exception:
1183\|              if message is None or "Exception:" not in message:
/window functions/tests/distributed/frame clause/range frame/order by decimalXFail 84ms
Exception: The RANGE OFFSET frame for 'DB::ColumnDecimal >' ORDER BY column is not implemented
AssertionError
Traceback (most recent call last):
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 274, in 
    regression()
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/argparser.py", line 171, in capture_cluster_args
    return func(self, cluster_args=cluster_args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 270, in regression
    Feature(run=load("window_functions.tests.feature", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/feature.py", line 75, in feature
    Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/frame_clause.py", line 68, in feature
    Feature(run=load("window_functions.tests.range_frame", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_frame.py", line 1745, in feature
    Scenario(run=scenario, flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_frame.py", line 1658, in order_by_decimal
    execute_query(
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/common.py", line 159, in execute_query
    r = current().context.node.query(
        ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 1188, in query
    assert False, error(r.output)
           ^^^^^
AssertionError: Oops! Assertion failed

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

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

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

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

1180\|                  assert message in r.output, error(r.output)
1181\|  
1182\|          if not ignore_exception:
1183\|              if message is None or "Exception:" not in message:
1184\|                  with Then("check if output has exception") if steps else NullStep():
1185\|                      if "Exception:" in r.output:
1186\|                          if raise_on_exception:
1187\|                              raise QueryRuntimeException(r.output)
1188\|>                         assert False, error(r.output)
1189\|  
1190\|          return r
1191\|
/window functions/tests/distributed/frame clause/range frame/with nullsXFail 113ms
DB::Exception: The RANGE OFFSET frame for 'DB::ColumnNullable' ORDER BY column is not implemented
AssertionError
Traceback (most recent call last):
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 274, in 
    regression()
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/argparser.py", line 171, in capture_cluster_args
    return func(self, cluster_args=cluster_args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 270, in regression
    Feature(run=load("window_functions.tests.feature", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/feature.py", line 75, in feature
    Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/frame_clause.py", line 68, in feature
    Feature(run=load("window_functions.tests.range_frame", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_frame.py", line 1745, in feature
    Scenario(run=scenario, flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_frame.py", line 1719, in with_nulls
    execute_query(
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/common.py", line 171, in execute_query
    assert r.output.strip() == expected, error()
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^
AssertionError: Oops! Assertion failed

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

Assertion values
  assert r.output.strip() == expected, error()
         ^ is 
  assert r.output.strip() == expected, error()
         ^ is = 'x\ty\tfirst_value\tlast_value\n1\t1\t1\t3\n2\t2\t1\t4\n3\t3\t1\t5\n4\t4\t2\t5\n5\t5\t3\t5\n\\N\t42\t42\t43\n\\N\t43\t42\t43'
  assert r.output.strip() == expected, error()
         ^ is 'x\ty\tfirst_value\tlast_value\n1\t1\t1\t3\n2\t2\t1\t4\n3\t3\t1\t5\n4\t4\t2\t5\n5\t5\t3\t5\n\\N\t42\t42\t43\n\\N\t43\t42\t43'
  assert r.output.strip() == expected, error()
         ^ is = 
  assert r.output.strip() == expected, error()
         ^ is = 'x\ty\tfirst_value\tlast_value\n1\t1\t1\t3\n2\t2\t1\t4\n3\t3\t1\t5\n4\t4\t2\t5\n5\t5\t3\t5\n\\N\t42\t42\t43\n\\N\t43\t42\t43'
  assert r.output.strip() == expected, error()
                             ^ is 'x\ty\tfirst_value\tlast_value\n\\N\t42\t42\t43\n\\N\t43\t42\t43\n1\t1\t1\t3\n2\t2\t1\t4\n3\t3\t1\t5\n4\t4\t2\t5\n5\t5\t3\t5'
  assert r.output.strip() == expected, error()
                          ^ is = False
    @@ -1,0 +2,2 @@
    +\N 42  42  43
    +\N 43  42  43
    @@ -7,2 +8,0 @@
    -\N 42  42  43
    -\N 43  42  43
  assert r.output.strip() == expected, error()
  ^ is False

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

163\|              no_checks=no_checks,
164\|          )
165\|          if no_checks:
166\|              return r
167\|  
168\|      if message is None:
169\|          if expected is not None:
170\|              with Then("I check output against expected"):
171\|>                 assert r.output.strip() == expected, error()
172\|          else:
173\|              with Then("I check output against snapshot"):
174\|                  with values() as that:
/window functions/tests/distributed/frame clause/range overflow/negative overflow with Int16XFail 78ms
exception on conversion
AssertionError
Traceback (most recent call last):
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 274, in 
    regression()
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/argparser.py", line 171, in capture_cluster_args
    return func(self, cluster_args=cluster_args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 270, in regression
    Feature(run=load("window_functions.tests.feature", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/feature.py", line 75, in feature
    Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/frame_clause.py", line 69, in feature
    Feature(run=load("window_functions.tests.range_overflow", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_overflow.py", line 145, in feature
    Scenario(run=scenario, flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_overflow.py", line 42, in negative_overflow_with_Int16
    execute_query(
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/common.py", line 159, in execute_query
    r = current().context.node.query(
        ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 1188, in query
    assert False, error(r.output)
           ^^^^^
AssertionError: Oops! Assertion failed

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

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

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

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

1180\|                  assert message in r.output, error(r.output)
1181\|  
1182\|          if not ignore_exception:
1183\|              if message is None or "Exception:" not in message:
1184\|                  with Then("check if output has exception") if steps else NullStep():
1185\|                      if "Exception:" in r.output:
1186\|                          if raise_on_exception:
1187\|                              raise QueryRuntimeException(r.output)
1188\|>                         assert False, error(r.output)
1189\|  
1190\|          return r
1191\|
/window functions/tests/distributed/frame clause/range overflow/positive overflow with Int16XFail 77ms
exception on conversion
AssertionError
Traceback (most recent call last):
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 274, in 
    regression()
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/argparser.py", line 171, in capture_cluster_args
    return func(self, cluster_args=cluster_args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 270, in regression
    Feature(run=load("window_functions.tests.feature", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/feature.py", line 75, in feature
    Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/frame_clause.py", line 69, in feature
    Feature(run=load("window_functions.tests.range_overflow", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_overflow.py", line 145, in feature
    Scenario(run=scenario, flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_overflow.py", line 20, in positive_overflow_with_Int16
    execute_query(
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/common.py", line 159, in execute_query
    r = current().context.node.query(
        ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 1188, in query
    assert False, error(r.output)
           ^^^^^
AssertionError: Oops! Assertion failed

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

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

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

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

1180\|                  assert message in r.output, error(r.output)
1181\|  
1182\|          if not ignore_exception:
1183\|              if message is None or "Exception:" not in message:
1184\|                  with Then("check if output has exception") if steps else NullStep():
1185\|                      if "Exception:" in r.output:
1186\|                          if raise_on_exception:
1187\|                              raise QueryRuntimeException(r.output)
1188\|>                         assert False, error(r.output)
1189\|  
1190\|          return r
1191\|
/window functions/tests/distributed/frame clause/range datetime/datetime order by desc range between n preceding and n followingXFail 93ms
https://github.com/ClickHouse/ClickHouse/issues/23902
AssertionError
Traceback (most recent call last):
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 274, in 
    regression()
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/argparser.py", line 171, in capture_cluster_args
    return func(self, cluster_args=cluster_args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 270, in regression
    Feature(run=load("window_functions.tests.feature", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/feature.py", line 75, in feature
    Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/frame_clause.py", line 70, in feature
    Feature(run=load("window_functions.tests.range_datetime", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_datetime.py", line 264, in feature
    Scenario(run=scenario, flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_datetime.py", line 245, in datetime_order_by_desc_range_between_n_preceding_and_n_following
    execute_query(
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/common.py", line 171, in execute_query
    assert r.output.strip() == expected, error()
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^
AssertionError: Oops! Assertion failed

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

Assertion values
  assert r.output.strip() == expected, error()
         ^ is 
  assert r.output.strip() == expected, error()
         ^ is = 'id\tf_timestamp\tfirst_value\tlast_value\n9\t2007-10-19 10:23:54\t10\t8\n10\t2008-10-19 10:23:54\t10\t9\n8\t2006-10-19 10:23:54\t9\t7\n6\t2004-10-19 10:23:54\t7\t5\n5\t2003-10-19 10:23:54\t6\t4\n4\t2002-10-19 10:23:54\t5\t3\n2\t2001-10-19 10:23:54\t4\t1\n3\t2001-10-19 10:23:54\t4\t1\n1\t2000-10-19 10:23:54\t2\t1\n7\t2005-10-19 10:23:54\t8\t6'
  assert r.output.strip() == expected, error()
         ^ is 'id\tf_timestamp\tfirst_value\tlast_value\n9\t2007-10-19 10:23:54\t10\t8\n10\t2008-10-19 10:23:54\t10\t9\n8\t2006-10-19 10:23:54\t9\t7\n6\t2004-10-19 10:23:54\t7\t5\n5\t2003-10-19 10:23:54\t6\t4\n4\t2002-10-19 10:23:54\t5\t3\n2\t2001-10-19 10:23:54\t4\t1\n3\t2001-10-19 10:23:54\t4\t1\n1\t2000-10-19 10:23:54\t2\t1\n7\t2005-10-19 10:23:54\t8\t6'
  assert r.output.strip() == expected, error()
         ^ is = 
  assert r.output.strip() == expected, error()
         ^ is = 'id\tf_timestamp\tfirst_value\tlast_value\n9\t2007-10-19 10:23:54\t10\t8\n10\t2008-10-19 10:23:54\t10\t9\n8\t2006-10-19 10:23:54\t9\t7\n6\t2004-10-19 10:23:54\t7\t5\n5\t2003-10-19 10:23:54\t6\t4\n4\t2002-10-19 10:23:54\t5\t3\n2\t2001-10-19 10:23:54\t4\t1\n3\t2001-10-19 10:23:54\t4\t1\n1\t2000-10-19 10:23:54\t2\t1\n7\t2005-10-19 10:23:54\t8\t6'
  assert r.output.strip() == expected, error()
                             ^ is 'id\tf_timestamp\tfirst_value\tlast_value\n10\t2008-10-19 10:23:54\t10\t9\n9\t2007-10-19 10:23:54\t10\t8\n8\t2006-10-19 10:23:54\t9\t7\n7\t2005-10-19 10:23:54\t8\t6\n6\t2004-10-19 10:23:54\t7\t5\n5\t2003-10-19 10:23:54\t6\t4\n4\t2002-10-19 10:23:54\t5\t3\n2\t2001-10-19 10:23:54\t4\t1\n3\t2001-10-19 10:23:54\t4\t1\n1\t2000-10-19 10:23:54\t2\t1'
  assert r.output.strip() == expected, error()
                          ^ is = False
    @@ -1,0 +2 @@
    +10 2008-10-19 10:23:54 10  9
    @@ -3 +3,0 @@
    -10 2008-10-19 10:23:54 10  9
    @@ -4,0 +5 @@
    +7  2005-10-19 10:23:54 8   6
    @@ -11 +11,0 @@
    -7  2005-10-19 10:23:54 8   6
  assert r.output.strip() == expected, error()
  ^ is False

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

163\|              no_checks=no_checks,
164\|          )
165\|          if no_checks:
166\|              return r
167\|  
168\|      if message is None:
169\|          if expected is not None:
170\|              with Then("I check output against expected"):
171\|>                 assert r.output.strip() == expected, error()
172\|          else:
173\|              with Then("I check output against snapshot"):
174\|                  with values() as that:
/window functions/tests/distributed/frame clause/range errors/error negative following offsetXFail 69ms
https://github.com/ClickHouse/ClickHouse/issues/22442
AssertionError
Traceback (most recent call last):
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 274, in 
    regression()
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/argparser.py", line 171, in capture_cluster_args
    return func(self, cluster_args=cluster_args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 270, in regression
    Feature(run=load("window_functions.tests.feature", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/feature.py", line 75, in feature
    Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/frame_clause.py", line 71, in feature
    Feature(run=load("window_functions.tests.range_errors", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_errors.py", line 114, in feature
    Scenario(run=scenario, flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_errors.py", line 105, in error_negative_following_offset
    r = current().context.node.query(sql, exitcode=exitcode, message=message)
        ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 1180, in query
    assert message in r.output, error(r.output)
           ^^^^^^^^^^^^^^^^^^^
AssertionError: Oops! Assertion failed

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

Description
  Received exception from server (version 24.12.2):
Code: 36. DB::Exception: Received from localhost:9000. DB::Exception: Frame end offset for 'RANGE' frame must be a nonnegative 32-bit integer, '-2' of type 'Int64' given. (BAD_ARGUMENTS)
(query: select max(enroll_date) over (order by salary range between 1 preceding and -2 following) AS max, salary, enroll_date from empsalary FORMAT TabSeparated
)

Assertion values
  assert message in r.output, error(r.output)
         ^ is 'DB::Exception: Frame end offset must be greater than zero, -2 given'
  assert message in r.output, error(r.output)
                    ^ is 
  assert message in r.output, error(r.output)
                    ^ is = "Received exception from server (version 24.12.2):\nCode: 36. DB::Exception: Received from localhost:9000. DB::Exception: Frame end offset for 'RANGE' frame must be a nonnegative 32-bit integer, '-2' of type 'Int64' given. (BAD_ARGUMENTS)\n(query: select max(enroll_date) over (order by salary range between 1 preceding and -2 following) AS max, salary, enroll_date from empsalary FORMAT TabSeparated\n)"
  assert message in r.output, error(r.output)
                 ^ is = False
  assert message in r.output, error(r.output)
  ^ is False

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

1172\|                  assert r.exitcode == exitcode, error(r.output)
1173\|  
1174\|          if message is not None:
1175\|              with (
1176\|                  Then(f"output should contain message", description=message)
1177\|                  if steps
1178\|                  else NullStep()
1179\|              ):
1180\|>                 assert message in r.output, error(r.output)
1181\|  
1182\|          if not ignore_exception:
1183\|              if message is None or "Exception:" not in message:
/window functions/tests/distributed/frame clause/range errors/error negative preceding offsetXFail 66ms
https://github.com/ClickHouse/ClickHouse/issues/22442
AssertionError
Traceback (most recent call last):
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 274, in 
    regression()
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/argparser.py", line 171, in capture_cluster_args
    return func(self, cluster_args=cluster_args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 270, in regression
    Feature(run=load("window_functions.tests.feature", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/feature.py", line 75, in feature
    Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/frame_clause.py", line 71, in feature
    Feature(run=load("window_functions.tests.range_errors", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_errors.py", line 114, in feature
    Scenario(run=scenario, flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_errors.py", line 89, in error_negative_preceding_offset
    r = current().context.node.query(sql, exitcode=exitcode, message=message)
        ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 1180, in query
    assert message in r.output, error(r.output)
           ^^^^^^^^^^^^^^^^^^^
AssertionError: Oops! Assertion failed

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

Description
  Received exception from server (version 24.12.2):
Code: 36. DB::Exception: Received from localhost:9000. DB::Exception: Frame start offset for 'RANGE' frame must be a nonnegative 32-bit integer, '-1' of type 'Int64' given. (BAD_ARGUMENTS)
(query: select max(enroll_date) over (order by salary range between -1 preceding and 2 following) AS max, salary, enroll_date from empsalary FORMAT TabSeparated
)

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

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

1172\|                  assert r.exitcode == exitcode, error(r.output)
1173\|  
1174\|          if message is not None:
1175\|              with (
1176\|                  Then(f"output should contain message", description=message)
1177\|                  if steps
1178\|                  else NullStep()
1179\|              ):
1180\|>                 assert message in r.output, error(r.output)
1181\|  
1182\|          if not ignore_exception:
1183\|              if message is None or "Exception:" not in message:
/window functions/tests/distributed/misc/subquery expr precedingXFail 102ms
subquery is not supported as offset
AssertionError
Traceback (most recent call last):
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 274, in 
    regression()
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/argparser.py", line 171, in capture_cluster_args
    return func(self, cluster_args=cluster_args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 270, in regression
    Feature(run=load("window_functions.tests.feature", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/feature.py", line 82, in feature
    Feature(run=load("window_functions.tests.misc", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/misc.py", line 466, in feature
    Scenario(run=scenario, flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/misc.py", line 27, in subquery_expr_preceding
    execute_query(
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/common.py", line 171, in execute_query
    assert r.output.strip() == expected, error()
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^
AssertionError: Oops! Assertion failed

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

Assertion values
  assert r.output.strip() == expected, error()
         ^ is 
  assert r.output.strip() == expected, error()
         ^ is = 'sum\tunique1\n0\t0\n1\t1\n3\t2\n5\t3\n7\t4\n9\t5\n11\t6\n13\t7\n15\t8\n17\t9'
  assert r.output.strip() == expected, error()
         ^ is 'sum\tunique1\n0\t0\n1\t1\n3\t2\n5\t3\n7\t4\n9\t5\n11\t6\n13\t7\n15\t8\n17\t9'
  assert r.output.strip() == expected, error()
         ^ is = 
  assert r.output.strip() == expected, error()
         ^ is = 'sum\tunique1\n0\t0\n1\t1\n3\t2\n5\t3\n7\t4\n9\t5\n11\t6\n13\t7\n15\t8\n17\t9'
  assert r.output.strip() == expected, error()
                             ^ is 'sum\tunique1\n0\t0\n1\t1\n3\t2\n5\t3Fmu\n7\t4\n9\t5\n11\t6\n13\t7\n15\t8\n17\t9'
  assert r.output.strip() == expected, error()
                          ^ is = False
    @@ -5 +5 @@
    -5  3
    +5  3Fmu
  assert r.output.strip() == expected, error()
  ^ is False

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

163\|              no_checks=no_checks,
164\|          )
165\|          if no_checks:
166\|              return r
167\|  
168\|      if message is None:
169\|          if expected is not None:
170\|              with Then("I check output against expected"):
171\|>                 assert r.output.strip() == expected, error()
172\|          else:
173\|              with Then("I check output against snapshot"):
174\|                  with values() as that:
/window functions/tests/distributed/misc/window functions in select expressionXFail 107ms
not supported, https://github.com/ClickHouse/ClickHouse/issues/19857
AssertionError
Traceback (most recent call last):
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 274, in 
    regression()
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/argparser.py", line 171, in capture_cluster_args
    return func(self, cluster_args=cluster_args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 270, in regression
    Feature(run=load("window_functions.tests.feature", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/feature.py", line 82, in feature
    Feature(run=load("window_functions.tests.misc", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/misc.py", line 466, in feature
    Scenario(run=scenario, flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/misc.py", line 56, in window_functions_in_select_expression
    execute_query(
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/common.py", line 171, in execute_query
    assert r.output.strip() == expected, error()
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^
AssertionError: Oops! Assertion failed

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

Assertion values
  assert r.output.strip() == expected, error()
         ^ is 
  assert r.output.strip() == expected, error()
         ^ is = 'cntsum\n92\n136\n24\n24\n82\n92\n51\n22\n22\n87'
  assert r.output.strip() == expected, error()
         ^ is 'cntsum\n92\n136\n24\n24\n82\n92\n51\n22\n22\n87'
  assert r.output.strip() == expected, error()
         ^ is = 
  assert r.output.strip() == expected, error()
         ^ is = 'cntsum\n92\n136\n24\n24\n82\n92\n51\n22\n22\n87'
  assert r.output.strip() == expected, error()
                             ^ is 'cntsum\n22\n22\n87\n24\n24\n82\n92\n51\n92\n136'
  assert r.output.strip() == expected, error()
                          ^ is = False
    @@ -2,2 +2,3 @@
    -92
    -136
    +22
    +22
    +87
    @@ -9,3 +10,2 @@
    -22
    -22
    -87
    +92
    +136
  assert r.output.strip() == expected, error()
  ^ is False

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

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

Results

Test Name Result Duration
/window functions OK 8m 45s
/window functions/tests OK 5m 19s
/window functions/tests/non distributed OK 2m 31s
/window functions/tests/non distributed/window spec OK 691ms
/window functions/tests/non distributed/window spec/empty OK 77ms
/window functions/tests/non distributed/window spec/frame clause OK 117ms
/window functions/tests/non distributed/window spec/order by with frame OK 78ms
/window functions/tests/non distributed/window spec/orderby clause OK 82ms
/window functions/tests/non distributed/window spec/partition clause OK 75ms
/window functions/tests/non distributed/window spec/partition with frame OK 93ms
/window functions/tests/non distributed/window spec/partition with order by OK 84ms
/window functions/tests/non distributed/window spec/partition with order by and frame OK 77ms
/window functions/tests/non distributed/partition clause OK 303ms
/window functions/tests/non distributed/partition clause/invalid expr error OK 59ms
/window functions/tests/non distributed/partition clause/missing expr error OK 67ms
/window functions/tests/non distributed/partition clause/multiple expr OK 95ms
/window functions/tests/non distributed/partition clause/single expr OK 77ms
/window functions/tests/non distributed/order clause OK 889ms
/window functions/tests/non distributed/order clause/by a non integer constant OK 73ms
/window functions/tests/non distributed/order clause/by column OK 86ms
/window functions/tests/non distributed/order clause/by expr OK 83ms
/window functions/tests/non distributed/order clause/by expr with aggregates OK 92ms
/window functions/tests/non distributed/order clause/invalid expr error OK 69ms
/window functions/tests/non distributed/order clause/missing expr error OK 63ms
/window functions/tests/non distributed/order clause/multiple expr asc asc OK 79ms
/window functions/tests/non distributed/order clause/multiple expr asc desc OK 74ms
/window functions/tests/non distributed/order clause/multiple expr desc desc OK 92ms
/window functions/tests/non distributed/order clause/single expr asc OK 79ms
/window functions/tests/non distributed/order clause/single expr desc OK 89ms
/window functions/tests/non distributed/frame clause OK 10s 460ms
/window functions/tests/non distributed/frame clause/default frame OK 170ms
/window functions/tests/non distributed/frame clause/default frame/with order by OK 80ms
/window functions/tests/non distributed/frame clause/default frame/without order by OK 89ms
/window functions/tests/non distributed/frame clause/rows frame OK 2s 676ms
/window functions/tests/non distributed/frame clause/rows frame/between current row and current row OK 75ms
/window functions/tests/non distributed/frame clause/rows frame/between current row and expr following OK 93ms
/window functions/tests/non distributed/frame clause/rows frame/between current row and expr preceding error OK 60ms
/window functions/tests/non distributed/frame clause/rows frame/between current row and unbounded following OK 85ms
/window functions/tests/non distributed/frame clause/rows frame/between current row and unbounded preceding error OK 55ms
/window functions/tests/non distributed/frame clause/rows frame/between expr following and expr following OK 83ms
/window functions/tests/non distributed/frame clause/rows frame/between expr following and expr following error OK 58ms
/window functions/tests/non distributed/frame clause/rows frame/between expr following and expr following ref OK 82ms
/window functions/tests/non distributed/frame clause/rows frame/between expr following and unbounded following OK 81ms
/window functions/tests/non distributed/frame clause/rows frame/between expr following error OK 188ms
/window functions/tests/non distributed/frame clause/rows frame/between expr preceding and current row OK 76ms
/window functions/tests/non distributed/frame clause/rows frame/between expr preceding and expr following OK 85ms
/window functions/tests/non distributed/frame clause/rows frame/between expr preceding and expr following ref OK 89ms
/window functions/tests/non distributed/frame clause/rows frame/between expr preceding and expr preceding OK 107ms
/window functions/tests/non distributed/frame clause/rows frame/between expr preceding and expr preceding error OK 63ms
/window functions/tests/non distributed/frame clause/rows frame/between expr preceding and expr preceding ref OK 91ms
/window functions/tests/non distributed/frame clause/rows frame/between expr preceding and unbounded following OK 82ms
/window functions/tests/non distributed/frame clause/rows frame/between expr preceding and unbounded preceding error OK 61ms
/window functions/tests/non distributed/frame clause/rows frame/between unbounded following error OK 289ms
/window functions/tests/non distributed/frame clause/rows frame/between unbounded preceding and current row OK 82ms
/window functions/tests/non distributed/frame clause/rows frame/between unbounded preceding and expr following OK 80ms
/window functions/tests/non distributed/frame clause/rows frame/between unbounded preceding and expr preceding OK 82ms
/window functions/tests/non distributed/frame clause/rows frame/between unbounded preceding and unbounded following OK 72ms
/window functions/tests/non distributed/frame clause/rows frame/between unbounded preceding and unbounded preceding error OK 55ms
/window functions/tests/non distributed/frame clause/rows frame/invalid frame extent OK 53ms
/window functions/tests/non distributed/frame clause/rows frame/missing frame extent OK 56ms
/window functions/tests/non distributed/frame clause/rows frame/start current row OK 72ms
/window functions/tests/non distributed/frame clause/rows frame/start expr following error OK 82ms
/window functions/tests/non distributed/frame clause/rows frame/start expr preceding OK 84ms
/window functions/tests/non distributed/frame clause/rows frame/start unbounded following error OK 55ms
/window functions/tests/non distributed/frame clause/rows frame/start unbounded preceding OK 77ms
/window functions/tests/non distributed/frame clause/range frame OK 5s 927ms
/window functions/tests/non distributed/frame clause/range frame/between current row and current row OK 166ms
/window functions/tests/non distributed/frame clause/range frame/between current row and expr following with order by OK 74ms
/window functions/tests/non distributed/frame clause/range frame/between current row and expr following without order by error OK 60ms
/window functions/tests/non distributed/frame clause/range frame/between current row and expr preceding error OK 114ms
/window functions/tests/non distributed/frame clause/range frame/between current row and unbounded following OK 266ms
/window functions/tests/non distributed/frame clause/range frame/between current row and unbounded following in named window OK 81ms
/window functions/tests/non distributed/frame clause/range frame/between current row and unbounded following modifying named window OK 80ms
/window functions/tests/non distributed/frame clause/range frame/between current row and unbounded preceding error OK 118ms
/window functions/tests/non distributed/frame clause/range frame/between expr following and current row with order by error OK 57ms
/window functions/tests/non distributed/frame clause/range frame/between expr following and current row without order by error OK 61ms
/window functions/tests/non distributed/frame clause/range frame/between expr following and current row zero special case XFail 93ms
/window functions/tests/non distributed/frame clause/range frame/between expr following and expr following with order by OK 82ms
/window functions/tests/non distributed/frame clause/range frame/between expr following and expr following with order by error OK 60ms
/window functions/tests/non distributed/frame clause/range frame/between expr following and expr following without order by error XFail 76ms
/window functions/tests/non distributed/frame clause/range frame/between expr following and expr preceding error OK 124ms
/window functions/tests/non distributed/frame clause/range frame/between expr following and expr preceding with order by zero special case XFail 79ms
/window functions/tests/non distributed/frame clause/range frame/between expr following and expr preceding without order by error XFail 68ms
/window functions/tests/non distributed/frame clause/range frame/between expr following and unbounded following with order by OK 84ms
/window functions/tests/non distributed/frame clause/range frame/between expr following and unbounded following without order by error OK 60ms
/window functions/tests/non distributed/frame clause/range frame/between expr following and unbounded preceding error OK 118ms
/window functions/tests/non distributed/frame clause/range frame/between expr preceding and current row with order by OK 82ms
/window functions/tests/non distributed/frame clause/range frame/between expr preceding and current row without order by error OK 59ms
/window functions/tests/non distributed/frame clause/range frame/between expr preceding and expr following with order by OK 201ms
/window functions/tests/non distributed/frame clause/range frame/between expr preceding and expr following with partition and order by OK 104ms
/window functions/tests/non distributed/frame clause/range frame/between expr preceding and expr following with partition by same column twice OK 89ms
/window functions/tests/non distributed/frame clause/range frame/between expr preceding and expr following with partition by two columns OK 96ms
/window functions/tests/non distributed/frame clause/range frame/between expr preceding and expr following without order by error OK 64ms
/window functions/tests/non distributed/frame clause/range frame/between expr preceding and expr preceding with order by OK 173ms
/window functions/tests/non distributed/frame clause/range frame/between expr preceding and expr preceding with order by error OK 58ms
/window functions/tests/non distributed/frame clause/range frame/between expr preceding and expr preceding without order by error OK 60ms
/window functions/tests/non distributed/frame clause/range frame/between expr preceding and unbounded following with order by OK 83ms
/window functions/tests/non distributed/frame clause/range frame/between expr preceding and unbounded following without order by error OK 62ms
/window functions/tests/non distributed/frame clause/range frame/between expr preceding and unbounded preceding error OK 109ms
/window functions/tests/non distributed/frame clause/range frame/between unbounded following and current row error OK 120ms
/window functions/tests/non distributed/frame clause/range frame/between unbounded following and expr following error OK 123ms
/window functions/tests/non distributed/frame clause/range frame/between unbounded following and expr preceding error OK 142ms
/window functions/tests/non distributed/frame clause/range frame/between unbounded following and unbounded following error OK 125ms
/window functions/tests/non distributed/frame clause/range frame/between unbounded following and unbounded preceding error OK 136ms
/window functions/tests/non distributed/frame clause/range frame/between unbounded preceding and current row OK 177ms
/window functions/tests/non distributed/frame clause/range frame/between unbounded preceding and current row with expressions in order by and aggregate OK 83ms
/window functions/tests/non distributed/frame clause/range frame/between unbounded preceding and expr following with order by OK 103ms
/window functions/tests/non distributed/frame clause/range frame/between unbounded preceding and expr following without order by error OK 65ms
/window functions/tests/non distributed/frame clause/range frame/between unbounded preceding and expr preceding with order by OK 103ms
/window functions/tests/non distributed/frame clause/range frame/between unbounded preceding and expr preceding without order by error OK 65ms
/window functions/tests/non distributed/frame clause/range frame/between unbounded preceding and unbounded following OK 181ms
/window functions/tests/non distributed/frame clause/range frame/between unbounded preceding and unbounded preceding error OK 134ms
/window functions/tests/non distributed/frame clause/range frame/invalid frame extent OK 54ms
/window functions/tests/non distributed/frame clause/range frame/missing frame extent OK 56ms
/window functions/tests/non distributed/frame clause/range frame/order by decimal XFail 71ms
/window functions/tests/non distributed/frame clause/range frame/order by float OK 89ms
/window functions/tests/non distributed/frame clause/range frame/start current row with order by OK 84ms
/window functions/tests/non distributed/frame clause/range frame/start current row without order by OK 76ms
/window functions/tests/non distributed/frame clause/range frame/start expr following with order by error OK 61ms
/window functions/tests/non distributed/frame clause/range frame/start expr following without order by error OK 61ms
/window functions/tests/non distributed/frame clause/range frame/start expr preceding order by non numerical column error OK 77ms
/window functions/tests/non distributed/frame clause/range frame/start expr preceding with order by OK 83ms
/window functions/tests/non distributed/frame clause/range frame/start expr preceding without order by error OK 59ms
/window functions/tests/non distributed/frame clause/range frame/start unbounded following error OK 123ms
/window functions/tests/non distributed/frame clause/range frame/start unbounded preceding with order by OK 84ms
/window functions/tests/non distributed/frame clause/range frame/start unbounded preceding without order by OK 87ms
/window functions/tests/non distributed/frame clause/range frame/with nulls XFail 94ms
/window functions/tests/non distributed/frame clause/range overflow OK 524ms
/window functions/tests/non distributed/frame clause/range overflow/negative overflow for Int32 OK 82ms
/window functions/tests/non distributed/frame clause/range overflow/negative overflow for Int64 OK 86ms
/window functions/tests/non distributed/frame clause/range overflow/negative overflow with Int16 XFail 91ms
/window functions/tests/non distributed/frame clause/range overflow/positive overflow for Int32 OK 94ms
/window functions/tests/non distributed/frame clause/range overflow/positive overflow for Int64 OK 86ms
/window functions/tests/non distributed/frame clause/range overflow/positive overflow with Int16 XFail 80ms
/window functions/tests/non distributed/frame clause/range datetime OK 703ms
/window functions/tests/non distributed/frame clause/range datetime/datetime order by asc range between n preceding and n following OK 99ms
/window functions/tests/non distributed/frame clause/range datetime/datetime order by desc range between n preceding and n following OK 97ms
/window functions/tests/non distributed/frame clause/range datetime/datetime with timezone order by asc range between n preceding and n following OK 93ms
/window functions/tests/non distributed/frame clause/range datetime/datetime with timezone order by desc range between n preceding and n following OK 93ms
/window functions/tests/non distributed/frame clause/range datetime/order by asc range between days preceding and days following OK 78ms
/window functions/tests/non distributed/frame clause/range datetime/order by desc range between days following and days following OK 77ms
/window functions/tests/non distributed/frame clause/range datetime/order by desc range between days preceding and days following OK 78ms
/window functions/tests/non distributed/frame clause/range datetime/order by desc range between days preceding and days preceding OK 81ms
/window functions/tests/non distributed/frame clause/range errors OK 430ms
/window functions/tests/non distributed/frame clause/range errors/error missing order by OK 68ms
/window functions/tests/non distributed/frame clause/range errors/error missing order by with partition by clause OK 68ms
/window functions/tests/non distributed/frame clause/range errors/error more than one order by column OK 67ms
/window functions/tests/non distributed/frame clause/range errors/error negative following offset XFail 76ms
/window functions/tests/non distributed/frame clause/range errors/error negative preceding offset XFail 69ms
/window functions/tests/non distributed/frame clause/range errors/error range over non numerical column OK 76ms
/window functions/tests/non distributed/window clause OK 409ms
/window functions/tests/non distributed/window clause/missing window spec OK 56ms
/window functions/tests/non distributed/window clause/multiple identical windows OK 83ms
/window functions/tests/non distributed/window clause/multiple windows OK 92ms
/window functions/tests/non distributed/window clause/single window OK 81ms
/window functions/tests/non distributed/window clause/unused window OK 92ms
/window functions/tests/non distributed/over clause OK 580ms
/window functions/tests/non distributed/over clause/adhoc window OK 79ms
/window functions/tests/non distributed/over clause/empty OK 81ms
/window functions/tests/non distributed/over clause/empty named window OK 84ms
/window functions/tests/non distributed/over clause/invalid multiple windows OK 141ms
/window functions/tests/non distributed/over clause/invalid window name OK 134ms
/window functions/tests/non distributed/over clause/missing window spec OK 56ms
/window functions/tests/non distributed/funcs OK 2s 507ms
/window functions/tests/non distributed/funcs/dense rank OK 78ms
/window functions/tests/non distributed/funcs/first value OK 163ms
/window functions/tests/non distributed/funcs/first value with lead workaround OK 94ms
/window functions/tests/non distributed/funcs/lag OK 262ms
/window functions/tests/non distributed/funcs/lagInFrame OK 433ms
/window functions/tests/non distributed/funcs/last value OK 366ms
/window functions/tests/non distributed/funcs/last value with lag workaround OK 78ms
/window functions/tests/non distributed/funcs/last value with no frame OK 76ms
/window functions/tests/non distributed/funcs/lead OK 326ms
/window functions/tests/non distributed/funcs/leadInFrame OK 441ms
/window functions/tests/non distributed/funcs/rank OK 90ms
/window functions/tests/non distributed/funcs/row number OK 91ms
/window functions/tests/non distributed/aggregate funcs OK 6s 742ms
/window functions/tests/non distributed/aggregate funcs/aggregate and window function in the same window OK 94ms
/window functions/tests/non distributed/aggregate funcs/aggregate funcs over rows frame OK 5s 550ms
/window functions/tests/non distributed/aggregate funcs/aggregate function recovers from nan OK 91ms
/window functions/tests/non distributed/aggregate funcs/avgWeighted OK 151ms
/window functions/tests/non distributed/aggregate funcs/avg with nulls OK 96ms
/window functions/tests/non distributed/aggregate funcs/bit functions OK 108ms
/window functions/tests/non distributed/aggregate funcs/nested aggregates OK 105ms
/window functions/tests/non distributed/aggregate funcs/stddevpop OK 88ms
/window functions/tests/non distributed/aggregate funcs/stddevsamp OK 88ms
/window functions/tests/non distributed/aggregate funcs/sum OK 80ms
/window functions/tests/non distributed/aggregate funcs/ungrouped aggregate over empty row set OK 90ms
/window functions/tests/non distributed/aggregate funcs/var pop OK 88ms
/window functions/tests/non distributed/aggregate funcs/var samp OK 105ms
/window functions/tests/non distributed/time decayed funcs OK 1m 54s
/window functions/tests/non distributed/time decayed funcs/exponentialTimeDecayedAvg OK 14s 548ms
/window functions/tests/non distributed/time decayed funcs/exponentialTimeDecayedCount OK 13s 90ms
/window functions/tests/non distributed/time decayed funcs/exponentialTimeDecayedMax OK 1m 11s
/window functions/tests/non distributed/time decayed funcs/exponentialTimeDecayedSum OK 14s 877ms
/window functions/tests/non distributed/errors OK 1s 20ms
/window functions/tests/non distributed/errors/error coma between partition by and order by clause OK 84ms
/window functions/tests/non distributed/errors/error named window defined twice OK 65ms
/window functions/tests/non distributed/errors/error order by another window function OK 151ms
/window functions/tests/non distributed/errors/error select from window OK 60ms
/window functions/tests/non distributed/errors/error using non window function OK 151ms
/window functions/tests/non distributed/errors/error window function in alter delete where OK 72ms
/window functions/tests/non distributed/errors/error window function in group by OK 153ms
/window functions/tests/non distributed/errors/error window function in having OK 64ms
/window functions/tests/non distributed/errors/error window function in join OK 149ms
/window functions/tests/non distributed/errors/error window function in where OK 63ms
/window functions/tests/non distributed/misc OK 1s 729ms
/window functions/tests/non distributed/misc/count with empty over clause without start OK 76ms
/window functions/tests/non distributed/misc/empty table OK 80ms
/window functions/tests/non distributed/misc/exclude clause OK 61ms
/window functions/tests/non distributed/misc/from subquery OK 77ms
/window functions/tests/non distributed/misc/group by and multiple windows OK 94ms
/window functions/tests/non distributed/misc/group by and one window OK 85ms
/window functions/tests/non distributed/misc/groups frame OK 66ms
/window functions/tests/non distributed/misc/in view OK 269ms
/window functions/tests/non distributed/misc/query with order by and one window OK 113ms
/window functions/tests/non distributed/misc/subquery expr preceding XFail 114ms
/window functions/tests/non distributed/misc/subquery multiple window functions OK 104ms
/window functions/tests/non distributed/misc/subquery multiple window functions with bigger table OK 115ms
/window functions/tests/non distributed/misc/subquery with multiple windows filtering OK 103ms
/window functions/tests/non distributed/misc/window functions in select expression OK 94ms
/window functions/tests/non distributed/misc/window functions in subquery OK 95ms
/window functions/tests/non distributed/misc/windows with same partitioning but different ordering OK 88ms
/window functions/tests/non distributed/misc/with union all OK 81ms
/window functions/tests/non distributed/datatypes OK 965ms
/window functions/tests/non distributed/datatypes/date OK 80ms
/window functions/tests/non distributed/datatypes/datetime OK 76ms
/window functions/tests/non distributed/datatypes/datetime64 OK 87ms
/window functions/tests/non distributed/datatypes/decimal32 OK 83ms
/window functions/tests/non distributed/datatypes/enum OK 84ms
/window functions/tests/non distributed/datatypes/fixed string OK 84ms
/window functions/tests/non distributed/datatypes/ipv4 OK 81ms
/window functions/tests/non distributed/datatypes/ipv6 OK 75ms
/window functions/tests/non distributed/datatypes/low cardinality OK 72ms
/window functions/tests/non distributed/datatypes/map OK 81ms
/window functions/tests/non distributed/datatypes/string OK 79ms
/window functions/tests/non distributed/datatypes/uuid OK 74ms
/window functions/tests/non distributed/non-negative derivative func OK 6s 947ms
/window functions/tests/non distributed/non-negative derivative func/acceptance OK 1s 480ms
/window functions/tests/non distributed/non-negative derivative func/check intervals OK 644ms
/window functions/tests/non distributed/non-negative derivative func/check negative result OK 84ms
/window functions/tests/non distributed/non-negative derivative func/check one row per partition OK 80ms
/window functions/tests/non distributed/non-negative derivative func/check over windows OK 2s 55ms
/window functions/tests/non distributed/non-negative derivative func/division by tiny OK 165ms
/window functions/tests/non distributed/non-negative derivative func/division by zero OK 90ms
/window functions/tests/non distributed/non-negative derivative func/empty table OK 207ms
/window functions/tests/non distributed/non-negative derivative func/null values OK 128ms
/window functions/tests/non distributed/non-negative derivative func/valid metric types OK 1s 142ms
/window functions/tests/non distributed/non-negative derivative func/valid timestamp types OK 240ms
/window functions/tests/non distributed/non-negative derivative func/wrong number of arguments or types OK 544ms
/window functions/tests/non distributed/non-negative derivative func/zero interval OK 78ms
/window functions/tests/distributed OK 2m 48s
/window functions/tests/distributed/window spec OK 757ms
/window functions/tests/distributed/window spec/empty OK 83ms
/window functions/tests/distributed/window spec/frame clause OK 92ms
/window functions/tests/distributed/window spec/order by with frame OK 83ms
/window functions/tests/distributed/window spec/orderby clause OK 99ms
/window functions/tests/distributed/window spec/partition clause OK 98ms
/window functions/tests/distributed/window spec/partition with frame OK 98ms
/window functions/tests/distributed/window spec/partition with order by OK 103ms
/window functions/tests/distributed/window spec/partition with order by and frame OK 93ms
/window functions/tests/distributed/partition clause OK 295ms
/window functions/tests/distributed/partition clause/invalid expr error OK 57ms
/window functions/tests/distributed/partition clause/missing expr error OK 59ms
/window functions/tests/distributed/partition clause/multiple expr OK 94ms
/window functions/tests/distributed/partition clause/single expr OK 81ms
/window functions/tests/distributed/order clause OK 895ms
/window functions/tests/distributed/order clause/by a non integer constant OK 76ms
/window functions/tests/distributed/order clause/by column OK 97ms
/window functions/tests/distributed/order clause/by expr OK 98ms
/window functions/tests/distributed/order clause/by expr with aggregates OK 104ms
/window functions/tests/distributed/order clause/invalid expr error OK 59ms
/window functions/tests/distributed/order clause/missing expr error OK 58ms
/window functions/tests/distributed/order clause/multiple expr asc asc OK 77ms
/window functions/tests/distributed/order clause/multiple expr asc desc OK 83ms
/window functions/tests/distributed/order clause/multiple expr desc desc OK 75ms
/window functions/tests/distributed/order clause/single expr asc OK 81ms
/window functions/tests/distributed/order clause/single expr desc OK 80ms
/window functions/tests/distributed/frame clause OK 11s 149ms
/window functions/tests/distributed/frame clause/default frame OK 155ms
/window functions/tests/distributed/frame clause/default frame/with order by OK 80ms
/window functions/tests/distributed/frame clause/default frame/without order by OK 74ms
/window functions/tests/distributed/frame clause/rows frame OK 2s 985ms
/window functions/tests/distributed/frame clause/rows frame/between current row and current row OK 93ms
/window functions/tests/distributed/frame clause/rows frame/between current row and expr following OK 90ms
/window functions/tests/distributed/frame clause/rows frame/between current row and expr preceding error OK 60ms
/window functions/tests/distributed/frame clause/rows frame/between current row and unbounded following OK 87ms
/window functions/tests/distributed/frame clause/rows frame/between current row and unbounded preceding error OK 58ms
/window functions/tests/distributed/frame clause/rows frame/between expr following and expr following OK 89ms
/window functions/tests/distributed/frame clause/rows frame/between expr following and expr following error OK 68ms
/window functions/tests/distributed/frame clause/rows frame/between expr following and expr following ref OK 99ms
/window functions/tests/distributed/frame clause/rows frame/between expr following and unbounded following OK 87ms
/window functions/tests/distributed/frame clause/rows frame/between expr following error OK 183ms
/window functions/tests/distributed/frame clause/rows frame/between expr preceding and current row OK 92ms
/window functions/tests/distributed/frame clause/rows frame/between expr preceding and expr following OK 97ms
/window functions/tests/distributed/frame clause/rows frame/between expr preceding and expr following ref OK 90ms
/window functions/tests/distributed/frame clause/rows frame/between expr preceding and expr preceding OK 89ms
/window functions/tests/distributed/frame clause/rows frame/between expr preceding and expr preceding error OK 70ms
/window functions/tests/distributed/frame clause/rows frame/between expr preceding and expr preceding ref OK 113ms
/window functions/tests/distributed/frame clause/rows frame/between expr preceding and unbounded following OK 118ms
/window functions/tests/distributed/frame clause/rows frame/between expr preceding and unbounded preceding error OK 64ms
/window functions/tests/distributed/frame clause/rows frame/between unbounded following error OK 304ms
/window functions/tests/distributed/frame clause/rows frame/between unbounded preceding and current row OK 102ms
/window functions/tests/distributed/frame clause/rows frame/between unbounded preceding and expr following OK 99ms
/window functions/tests/distributed/frame clause/rows frame/between unbounded preceding and expr preceding OK 96ms
/window functions/tests/distributed/frame clause/rows frame/between unbounded preceding and unbounded following OK 119ms
/window functions/tests/distributed/frame clause/rows frame/between unbounded preceding and unbounded preceding error OK 63ms
/window functions/tests/distributed/frame clause/rows frame/invalid frame extent OK 65ms
/window functions/tests/distributed/frame clause/rows frame/missing frame extent OK 62ms
/window functions/tests/distributed/frame clause/rows frame/start current row OK 98ms
/window functions/tests/distributed/frame clause/rows frame/start expr following error OK 66ms
/window functions/tests/distributed/frame clause/rows frame/start expr preceding OK 90ms
/window functions/tests/distributed/frame clause/rows frame/start unbounded following error OK 57ms
/window functions/tests/distributed/frame clause/rows frame/start unbounded preceding OK 94ms
/window functions/tests/distributed/frame clause/range frame OK 6s 404ms
/window functions/tests/distributed/frame clause/range frame/between current row and current row OK 195ms
/window functions/tests/distributed/frame clause/range frame/between current row and expr following with order by OK 94ms
/window functions/tests/distributed/frame clause/range frame/between current row and expr following without order by error OK 59ms
/window functions/tests/distributed/frame clause/range frame/between current row and expr preceding error OK 129ms
/window functions/tests/distributed/frame clause/range frame/between current row and unbounded following OK 290ms
/window functions/tests/distributed/frame clause/range frame/between current row and unbounded following in named window OK 93ms
/window functions/tests/distributed/frame clause/range frame/between current row and unbounded following modifying named window OK 92ms
/window functions/tests/distributed/frame clause/range frame/between current row and unbounded preceding error OK 114ms
/window functions/tests/distributed/frame clause/range frame/between expr following and current row with order by error OK 64ms
/window functions/tests/distributed/frame clause/range frame/between expr following and current row without order by error OK 58ms
/window functions/tests/distributed/frame clause/range frame/between expr following and current row zero special case XFail 69ms
/window functions/tests/distributed/frame clause/range frame/between expr following and expr following with order by OK 83ms
/window functions/tests/distributed/frame clause/range frame/between expr following and expr following with order by error OK 60ms
/window functions/tests/distributed/frame clause/range frame/between expr following and expr following without order by error XFail 64ms
/window functions/tests/distributed/frame clause/range frame/between expr following and expr preceding error OK 135ms
/window functions/tests/distributed/frame clause/range frame/between expr following and expr preceding with order by zero special case XFail 79ms
/window functions/tests/distributed/frame clause/range frame/between expr following and expr preceding without order by error XFail 69ms
/window functions/tests/distributed/frame clause/range frame/between expr following and unbounded following with order by OK 92ms
/window functions/tests/distributed/frame clause/range frame/between expr following and unbounded following without order by error OK 64ms
/window functions/tests/distributed/frame clause/range frame/between expr following and unbounded preceding error OK 121ms
/window functions/tests/distributed/frame clause/range frame/between expr preceding and current row with order by OK 107ms
/window functions/tests/distributed/frame clause/range frame/between expr preceding and current row without order by error OK 61ms
/window functions/tests/distributed/frame clause/range frame/between expr preceding and expr following with order by OK 195ms
/window functions/tests/distributed/frame clause/range frame/between expr preceding and expr following with partition and order by OK 97ms
/window functions/tests/distributed/frame clause/range frame/between expr preceding and expr following with partition by same column twice OK 104ms
/window functions/tests/distributed/frame clause/range frame/between expr preceding and expr following with partition by two columns OK 108ms
/window functions/tests/distributed/frame clause/range frame/between expr preceding and expr following without order by error OK 64ms
/window functions/tests/distributed/frame clause/range frame/between expr preceding and expr preceding with order by OK 190ms
/window functions/tests/distributed/frame clause/range frame/between expr preceding and expr preceding with order by error OK 59ms
/window functions/tests/distributed/frame clause/range frame/between expr preceding and expr preceding without order by error OK 66ms
/window functions/tests/distributed/frame clause/range frame/between expr preceding and unbounded following with order by OK 93ms
/window functions/tests/distributed/frame clause/range frame/between expr preceding and unbounded following without order by error OK 63ms
/window functions/tests/distributed/frame clause/range frame/between expr preceding and unbounded preceding error OK 116ms
/window functions/tests/distributed/frame clause/range frame/between unbounded following and current row error OK 121ms
/window functions/tests/distributed/frame clause/range frame/between unbounded following and expr following error OK 133ms
/window functions/tests/distributed/frame clause/range frame/between unbounded following and expr preceding error OK 120ms
/window functions/tests/distributed/frame clause/range frame/between unbounded following and unbounded following error OK 123ms
/window functions/tests/distributed/frame clause/range frame/between unbounded following and unbounded preceding error OK 175ms
/window functions/tests/distributed/frame clause/range frame/between unbounded preceding and current row OK 221ms
/window functions/tests/distributed/frame clause/range frame/between unbounded preceding and current row with expressions in order by and aggregate OK 96ms
/window functions/tests/distributed/frame clause/range frame/between unbounded preceding and expr following with order by OK 94ms
/window functions/tests/distributed/frame clause/range frame/between unbounded preceding and expr following without order by error OK 87ms
/window functions/tests/distributed/frame clause/range frame/between unbounded preceding and expr preceding with order by OK 116ms
/window functions/tests/distributed/frame clause/range frame/between unbounded preceding and expr preceding without order by error OK 68ms
/window functions/tests/distributed/frame clause/range frame/between unbounded preceding and unbounded following OK 194ms
/window functions/tests/distributed/frame clause/range frame/between unbounded preceding and unbounded preceding error OK 121ms
/window functions/tests/distributed/frame clause/range frame/invalid frame extent OK 59ms
/window functions/tests/distributed/frame clause/range frame/missing frame extent OK 69ms
/window functions/tests/distributed/frame clause/range frame/order by decimal XFail 84ms
/window functions/tests/distributed/frame clause/range frame/order by float OK 96ms
/window functions/tests/distributed/frame clause/range frame/start current row with order by OK 95ms
/window functions/tests/distributed/frame clause/range frame/start current row without order by OK 92ms
/window functions/tests/distributed/frame clause/range frame/start expr following with order by error OK 60ms
/window functions/tests/distributed/frame clause/range frame/start expr following without order by error OK 64ms
/window functions/tests/distributed/frame clause/range frame/start expr preceding order by non numerical column error OK 78ms
/window functions/tests/distributed/frame clause/range frame/start expr preceding with order by OK 106ms
/window functions/tests/distributed/frame clause/range frame/start expr preceding without order by error OK 65ms
/window functions/tests/distributed/frame clause/range frame/start unbounded following error OK 162ms
/window functions/tests/distributed/frame clause/range frame/start unbounded preceding with order by OK 92ms
/window functions/tests/distributed/frame clause/range frame/start unbounded preceding without order by OK 102ms
/window functions/tests/distributed/frame clause/range frame/with nulls XFail 113ms
/window functions/tests/distributed/frame clause/range overflow OK 492ms
/window functions/tests/distributed/frame clause/range overflow/negative overflow for Int32 OK 81ms
/window functions/tests/distributed/frame clause/range overflow/negative overflow for Int64 OK 83ms
/window functions/tests/distributed/frame clause/range overflow/negative overflow with Int16 XFail 78ms
/window functions/tests/distributed/frame clause/range overflow/positive overflow for Int32 OK 80ms
/window functions/tests/distributed/frame clause/range overflow/positive overflow for Int64 OK 88ms
/window functions/tests/distributed/frame clause/range overflow/positive overflow with Int16 XFail 77ms
/window functions/tests/distributed/frame clause/range datetime OK 729ms
/window functions/tests/distributed/frame clause/range datetime/datetime order by asc range between n preceding and n following OK 90ms
/window functions/tests/distributed/frame clause/range datetime/datetime order by desc range between n preceding and n following XFail 93ms
/window functions/tests/distributed/frame clause/range datetime/datetime with timezone order by asc range between n preceding and n following OK 92ms
/window functions/tests/distributed/frame clause/range datetime/datetime with timezone order by desc range between n preceding and n following OK 99ms
/window functions/tests/distributed/frame clause/range datetime/order by asc range between days preceding and days following OK 89ms
/window functions/tests/distributed/frame clause/range datetime/order by desc range between days following and days following OK 80ms
/window functions/tests/distributed/frame clause/range datetime/order by desc range between days preceding and days following OK 93ms
/window functions/tests/distributed/frame clause/range datetime/order by desc range between days preceding and days preceding OK 87ms
/window functions/tests/distributed/frame clause/range errors OK 377ms
/window functions/tests/distributed/frame clause/range errors/error missing order by OK 56ms
/window functions/tests/distributed/frame clause/range errors/error missing order by with partition by clause OK 58ms
/window functions/tests/distributed/frame clause/range errors/error more than one order by column OK 61ms
/window functions/tests/distributed/frame clause/range errors/error negative following offset XFail 69ms
/window functions/tests/distributed/frame clause/range errors/error negative preceding offset XFail 66ms
/window functions/tests/distributed/frame clause/range errors/error range over non numerical column OK 63ms
/window functions/tests/distributed/window clause OK 416ms
/window functions/tests/distributed/window clause/missing window spec OK 65ms
/window functions/tests/distributed/window clause/multiple identical windows OK 86ms
/window functions/tests/distributed/window clause/multiple windows OK 86ms
/window functions/tests/distributed/window clause/single window OK 80ms
/window functions/tests/distributed/window clause/unused window OK 96ms
/window functions/tests/distributed/over clause OK 626ms
/window functions/tests/distributed/over clause/adhoc window OK 123ms
/window functions/tests/distributed/over clause/empty OK 85ms
/window functions/tests/distributed/over clause/empty named window OK 84ms
/window functions/tests/distributed/over clause/invalid multiple windows OK 137ms
/window functions/tests/distributed/over clause/invalid window name OK 131ms
/window functions/tests/distributed/over clause/missing window spec OK 59ms
/window functions/tests/distributed/funcs OK 2s 747ms
/window functions/tests/distributed/funcs/dense rank OK 97ms
/window functions/tests/distributed/funcs/first value OK 216ms
/window functions/tests/distributed/funcs/first value with lead workaround OK 93ms
/window functions/tests/distributed/funcs/lag OK 264ms
/window functions/tests/distributed/funcs/lagInFrame OK 475ms
/window functions/tests/distributed/funcs/last value OK 412ms
/window functions/tests/distributed/funcs/last value with lag workaround OK 91ms
/window functions/tests/distributed/funcs/last value with no frame OK 92ms
/window functions/tests/distributed/funcs/lead OK 367ms
/window functions/tests/distributed/funcs/leadInFrame OK 451ms
/window functions/tests/distributed/funcs/rank OK 87ms
/window functions/tests/distributed/funcs/row number OK 90ms
/window functions/tests/distributed/aggregate funcs OK 7s 121ms
/window functions/tests/distributed/aggregate funcs/aggregate and window function in the same window OK 93ms
/window functions/tests/distributed/aggregate funcs/aggregate funcs over rows frame OK 5s 966ms
/window functions/tests/distributed/aggregate funcs/aggregate function recovers from nan OK 105ms
/window functions/tests/distributed/aggregate funcs/avgWeighted OK 156ms
/window functions/tests/distributed/aggregate funcs/avg with nulls OK 82ms
/window functions/tests/distributed/aggregate funcs/bit functions OK 86ms
/window functions/tests/distributed/aggregate funcs/nested aggregates OK 96ms
/window functions/tests/distributed/aggregate funcs/stddevpop OK 90ms
/window functions/tests/distributed/aggregate funcs/stddevsamp OK 80ms
/window functions/tests/distributed/aggregate funcs/sum OK 97ms
/window functions/tests/distributed/aggregate funcs/ungrouped aggregate over empty row set OK 94ms
/window functions/tests/distributed/aggregate funcs/var pop OK 81ms
/window functions/tests/distributed/aggregate funcs/var samp OK 84ms
/window functions/tests/distributed/time decayed funcs OK 1m 54s
/window functions/tests/distributed/time decayed funcs/exponentialTimeDecayedAvg OK 14s 859ms
/window functions/tests/distributed/time decayed funcs/exponentialTimeDecayedCount OK 13s 25ms
/window functions/tests/distributed/time decayed funcs/exponentialTimeDecayedMax OK 1m 11s
/window functions/tests/distributed/time decayed funcs/exponentialTimeDecayedSum OK 14s 546ms
/window functions/tests/distributed/errors OK 951ms
/window functions/tests/distributed/errors/error coma between partition by and order by clause OK 61ms
/window functions/tests/distributed/errors/error named window defined twice OK 64ms
/window functions/tests/distributed/errors/error order by another window function OK 138ms
/window functions/tests/distributed/errors/error select from window OK 59ms
/window functions/tests/distributed/errors/error using non window function OK 151ms
/window functions/tests/distributed/errors/error window function in alter delete where OK 66ms
/window functions/tests/distributed/errors/error window function in group by OK 139ms
/window functions/tests/distributed/errors/error window function in having OK 64ms
/window functions/tests/distributed/errors/error window function in join OK 145ms
/window functions/tests/distributed/errors/error window function in where OK 57ms
/window functions/tests/distributed/misc OK 1s 701ms
/window functions/tests/distributed/misc/count with empty over clause without start OK 86ms
/window functions/tests/distributed/misc/empty table OK 82ms
/window functions/tests/distributed/misc/exclude clause OK 55ms
/window functions/tests/distributed/misc/from subquery OK 83ms
/window functions/tests/distributed/misc/group by and multiple windows OK 113ms
/window functions/tests/distributed/misc/group by and one window OK 93ms
/window functions/tests/distributed/misc/groups frame OK 60ms
/window functions/tests/distributed/misc/in view OK 249ms
/window functions/tests/distributed/misc/query with order by and one window OK 84ms
/window functions/tests/distributed/misc/subquery expr preceding XFail 102ms
/window functions/tests/distributed/misc/subquery multiple window functions OK 99ms
/window functions/tests/distributed/misc/subquery multiple window functions with bigger table Skip 671us
/window functions/tests/distributed/misc/subquery with multiple windows filtering OK 113ms
/window functions/tests/distributed/misc/window functions in select expression XFail 107ms
/window functions/tests/distributed/misc/window functions in subquery OK 101ms
/window functions/tests/distributed/misc/windows with same partitioning but different ordering OK 119ms
/window functions/tests/distributed/misc/with union all OK 140ms
/window functions/tests/distributed/datatypes OK 979ms
/window functions/tests/distributed/datatypes/date OK 88ms
/window functions/tests/distributed/datatypes/datetime OK 81ms
/window functions/tests/distributed/datatypes/datetime64 OK 77ms
/window functions/tests/distributed/datatypes/decimal32 OK 82ms
/window functions/tests/distributed/datatypes/enum OK 84ms
/window functions/tests/distributed/datatypes/fixed string OK 77ms
/window functions/tests/distributed/datatypes/ipv4 OK 75ms
/window functions/tests/distributed/datatypes/ipv6 OK 78ms
/window functions/tests/distributed/datatypes/low cardinality OK 82ms
/window functions/tests/distributed/datatypes/map OK 92ms
/window functions/tests/distributed/datatypes/string OK 82ms
/window functions/tests/distributed/datatypes/uuid OK 71ms
/window functions/tests/distributed/non-negative derivative func OK 7s 34ms
/window functions/tests/distributed/non-negative derivative func/acceptance OK 1s 488ms
/window functions/tests/distributed/non-negative derivative func/check intervals OK 631ms
/window functions/tests/distributed/non-negative derivative func/check negative result OK 86ms
/window functions/tests/distributed/non-negative derivative func/check one row per partition OK 90ms
/window functions/tests/distributed/non-negative derivative func/check over windows OK 2s 87ms
/window functions/tests/distributed/non-negative derivative func/division by tiny OK 169ms
/window functions/tests/distributed/non-negative derivative func/division by zero OK 107ms
/window functions/tests/distributed/non-negative derivative func/empty table OK 218ms
/window functions/tests/distributed/non-negative derivative func/null values OK 132ms
/window functions/tests/distributed/non-negative derivative func/valid metric types OK 1s 166ms
/window functions/tests/distributed/non-negative derivative func/valid timestamp types OK 243ms
/window functions/tests/distributed/non-negative derivative func/wrong number of arguments or types OK 526ms
/window functions/tests/distributed/non-negative derivative func/zero interval OK 81ms

Generated by TestFlows Open-Source Test Framework v2.0.250110.1002922