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

DateJul 14, 2023 18:48
Duration5m 51s
Framework TestFlows 1.9.230315.1003122

Artifacts

Test artifacts can be found at https://altinity-test-reports.s3.amazonaws.com/index.html#clickhouse/23.3.8.22.altinitystable/5553084583/testflows/

Attributes

projectAltinity/ClickHouse
project.id159717931
packagehttps://s3.amazonaws.com/altinity-build-artifacts/23.3/b2217a3881bc514b436b6e2c0e21eb899b4d4aee/package_release/clickhouse-common-static_23.3.8.22.altinitystable_amd64.deb
version23.3.8.22.altinitystable
user.nameEnmk
repositoryhttps://github.com/Altinity/clickhouse-regression
commit.hashb13df10b2ee4ce720b5635d1e0208debff3f6ca8
job.id5553084583
job.urlhttps://github.com/Altinity/ClickHouse/actions/runs/5553084583
archx86_64
stressFalse
localTrue
clickhouse_versionNone
clickhouse_binary_pathhttps://s3.amazonaws.com/altinity-build-artifacts/23.3/b2217a3881bc514b436b6e2c0e21eb899b4d4aee/package_release/clickhouse-common-static_23.3.8.22.altinitystable_amd64.deb
collect_service_logsTrue

Summary

97.8%OK
2.2%Known

Statistics

Units OK Fail XFail
Modules
1
1
Suites
39
39
Features
39
39
Scenarios
456
434
22
Checks
256
252
4
Examples
1418
1396
22
Steps
7594
7524
70

Known Fails

Test NameResultMessage
/window functions/tests/non distributed/frame clause/range frame/between current row and unbounded following modifying named windowXFail 109ms
range with named window is not supported
AssertionError
Traceback (most recent call last):
  File "/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 228, in 
    regression()
  File "/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 224, in regression
    Feature(run=load("window_functions.tests.feature", "feature"), flags=TE)
  File "/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/feature.py", line 72, in feature
    Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE)
  File "/home/ubuntu/actions-runner/_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/actions-runner/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_frame.py", line 1733, in feature
    Scenario(run=scenario, flags=TE)
  File "/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_frame.py", line 1520, in between_current_row_and_unbounded_following_modifying_named_window
    execute_query(
  File "/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/common.py", line 152, in execute_query
    assert r.output.strip() == expected, error()
AssertionError: Oops! Assertion failed

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

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

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

144\|              no_checks=no_checks,
145\|          )
146\|          if no_checks:
147\|              return r
148\|  
149\|      if message is None:
150\|          if expected is not None:
151\|              with Then("I check output against expected"):
152\|>                 assert r.output.strip() == expected, error()
153\|          else:
154\|              with Then("I check output against snapshot"):
155\|                  with values() as that:
/window functions/tests/non distributed/frame clause/range frame/between expr following and current row zero special caseXFail 73ms
known bug
AssertionError
Traceback (most recent call last):
  File "/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 228, in 
    regression()
  File "/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 224, in regression
    Feature(run=load("window_functions.tests.feature", "feature"), flags=TE)
  File "/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/feature.py", line 72, in feature
    Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE)
  File "/home/ubuntu/actions-runner/_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/actions-runner/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_frame.py", line 1733, in feature
    Scenario(run=scenario, flags=TE)
  File "/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_frame.py", line 1347, in between_expr_following_and_current_row_zero_special_case
    execute_query(
  File "/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/common.py", line 140, in execute_query
    r = current().context.node.query(
  File "/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 777, 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 23.3.8):
Code: 36. DB::Exception: Received from localhost:9000. DB::Exception: Window frame 'RANGE BETWEEN 0 FOLLOWING AND CURRENT ROW' is invalid. (BAD_ARGUMENTS)
(query: SELECT number,sum(number) OVER (ORDER BY number RANGE BETWEEN 0 FOLLOWING AND CURRENT ROW) AS sum FROM values('number Int8', (1),(1),(2),(3)) FORMAT TabSeparatedWithNames
)

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

Where
  File '/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py', line 777 in 'query'

769\|                  assert message in r.output, error(r.output)
770\|  
771\|          if not ignore_exception:
772\|              if message is None or "Exception:" not in message:
773\|                  with Then("check if output has exception") if steps else NullStep():
774\|                      if "Exception:" in r.output:
775\|                          if raise_on_exception:
776\|                              raise QueryRuntimeException(r.output)
777\|>                         assert False, error(r.output)
778\|  
779\|          return r
780\|
/window functions/tests/non distributed/frame clause/range frame/between expr following and expr following without order by errorXFail 70ms
invalid error message
AssertionError
Traceback (most recent call last):
  File "/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 228, in 
    regression()
  File "/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 224, in regression
    Feature(run=load("window_functions.tests.feature", "feature"), flags=TE)
  File "/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/feature.py", line 72, in feature
    Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE)
  File "/home/ubuntu/actions-runner/_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/actions-runner/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_frame.py", line 1733, in feature
    Scenario(run=scenario, flags=TE)
  File "/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_frame.py", line 1211, in between_expr_following_and_expr_following_without_order_by_error
    self.context.node.query(
  File "/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 769, 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 23.3.8):
Code: 36. DB::Exception: Received from localhost:9000. DB::Exception: The RANGE OFFSET window frame requires exactly one ORDER BY column, 0 given. (BAD_ARGUMENTS)
(query: SELECT number,sum(number) OVER (RANGE BETWEEN 1 FOLLOWING AND 1 FOLLOWING) FROM values('number Int8', (1),(1),(2),(3))
)

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

Where
  File '/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py', line 769 in 'query'

761\|          if exitcode is not None:
762\|              with Then(f"exitcode should be {exitcode}") if steps else NullStep():
763\|                  assert r.exitcode == exitcode, error(r.output)
764\|  
765\|          if message is not None:
766\|              with Then(
767\|                  f"output should contain message", description=message
768\|              ) if steps else NullStep():
769\|>                 assert message in r.output, error(r.output)
770\|  
771\|          if not ignore_exception:
772\|              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 67ms
known bug
AssertionError
Traceback (most recent call last):
  File "/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 228, in 
    regression()
  File "/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 224, in regression
    Feature(run=load("window_functions.tests.feature", "feature"), flags=TE)
  File "/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/feature.py", line 72, in feature
    Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE)
  File "/home/ubuntu/actions-runner/_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/actions-runner/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_frame.py", line 1733, in feature
    Scenario(run=scenario, flags=TE)
  File "/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_frame.py", line 1416, in between_expr_following_and_expr_preceding_with_order_by_zero_special_case
    execute_query(
  File "/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/common.py", line 140, in execute_query
    r = current().context.node.query(
  File "/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 777, 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 23.3.8):
Code: 36. DB::Exception: Received from localhost:9000. DB::Exception: Frame start offset 0 FOLLOWING does not precede the frame end offset 0 PRECEDING. (BAD_ARGUMENTS)
(query: SELECT number,sum(number) OVER (ORDER BY number RANGE BETWEEN 0 FOLLOWING AND 0 PRECEDING) AS sum FROM values('number Int8', (1),(1),(2),(3)) FORMAT TabSeparatedWithNames
)

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

Where
  File '/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py', line 777 in 'query'

769\|                  assert message in r.output, error(r.output)
770\|  
771\|          if not ignore_exception:
772\|              if message is None or "Exception:" not in message:
773\|                  with Then("check if output has exception") if steps else NullStep():
774\|                      if "Exception:" in r.output:
775\|                          if raise_on_exception:
776\|                              raise QueryRuntimeException(r.output)
777\|>                         assert False, error(r.output)
778\|  
779\|          return r
780\|
/window functions/tests/non 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/actions-runner/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 228, in 
    regression()
  File "/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 224, in regression
    Feature(run=load("window_functions.tests.feature", "feature"), flags=TE)
  File "/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/feature.py", line 72, in feature
    Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE)
  File "/home/ubuntu/actions-runner/_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/actions-runner/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_frame.py", line 1733, in feature
    Scenario(run=scenario, flags=TE)
  File "/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_frame.py", line 1228, in between_expr_following_and_expr_preceding_without_order_by_error
    self.context.node.query(
  File "/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 769, 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 23.3.8):
Code: 36. DB::Exception: Received from localhost:9000. DB::Exception: Frame start offset 0 FOLLOWING does not precede the frame end offset 0 PRECEDING. (BAD_ARGUMENTS)
(query: SELECT number,sum(number) OVER (RANGE BETWEEN 0 FOLLOWING AND 0 PRECEDING) FROM values('number Int8', (1),(1),(2),(3))
)

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

Where
  File '/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py', line 769 in 'query'

761\|          if exitcode is not None:
762\|              with Then(f"exitcode should be {exitcode}") if steps else NullStep():
763\|                  assert r.exitcode == exitcode, error(r.output)
764\|  
765\|          if message is not None:
766\|              with Then(
767\|                  f"output should contain message", description=message
768\|              ) if steps else NullStep():
769\|>                 assert message in r.output, error(r.output)
770\|  
771\|          if not ignore_exception:
772\|              if message is None or "Exception:" not in message:
/window functions/tests/non distributed/frame clause/range frame/order by decimalXFail 70ms
Exception: The RANGE OFFSET frame for 'DB::ColumnDecimal >' ORDER BY column is not implemented
AssertionError
Traceback (most recent call last):
  File "/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 228, in 
    regression()
  File "/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 224, in regression
    Feature(run=load("window_functions.tests.feature", "feature"), flags=TE)
  File "/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/feature.py", line 72, in feature
    Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE)
  File "/home/ubuntu/actions-runner/_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/actions-runner/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_frame.py", line 1733, in feature
    Scenario(run=scenario, flags=TE)
  File "/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_frame.py", line 1649, in order_by_decimal
    execute_query(
  File "/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/common.py", line 140, in execute_query
    r = current().context.node.query(
  File "/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 777, 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 23.3.8):
Code: 48. DB::Exception: Received from localhost:9000. DB::Exception: The RANGE OFFSET frame for 'DB::ColumnDecimal>' ORDER BY column is not implemented. (NOT_IMPLEMENTED)
(query: select id, f_numeric, first_value(id) over w AS first_value, last_value(id) over w AS last_value
        from numerics
        window w as (order by f_numeric range between
                     1 preceding and 1 following)
         FORMAT TabSeparatedWithNames
)

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

Where
  File '/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py', line 777 in 'query'

769\|                  assert message in r.output, error(r.output)
770\|  
771\|          if not ignore_exception:
772\|              if message is None or "Exception:" not in message:
773\|                  with Then("check if output has exception") if steps else NullStep():
774\|                      if "Exception:" in r.output:
775\|                          if raise_on_exception:
776\|                              raise QueryRuntimeException(r.output)
777\|>                         assert False, error(r.output)
778\|  
779\|          return r
780\|
/window functions/tests/non distributed/frame clause/range frame/with nullsXFail 83ms
DB::Exception: The RANGE OFFSET frame for 'DB::ColumnNullable' ORDER BY column is not implemented
AssertionError
Traceback (most recent call last):
  File "/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 228, in 
    regression()
  File "/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 224, in regression
    Feature(run=load("window_functions.tests.feature", "feature"), flags=TE)
  File "/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/feature.py", line 72, in feature
    Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE)
  File "/home/ubuntu/actions-runner/_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/actions-runner/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_frame.py", line 1733, in feature
    Scenario(run=scenario, flags=TE)
  File "/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_frame.py", line 1708, in with_nulls
    execute_query(
  File "/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/common.py", line 140, in execute_query
    r = current().context.node.query(
  File "/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 777, 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 23.3.8):
Code: 48. DB::Exception: Received from localhost:9000. DB::Exception: The RANGE OFFSET frame for 'DB::ColumnNullable' ORDER BY column is not implemented. (NOT_IMPLEMENTED)
(query: select x, y,
               first_value(y) over w AS first_value,
               last_value(y) over w AS last_value
        from
          (select number as x, x as y from numbers(1,5)
           union all select null, 42
           union all select null, 43)
        window w as
          (order by x asc nulls first range between 2 preceding and 2 following)
         FORMAT TabSeparatedWithNames
)

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

Where
  File '/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py', line 777 in 'query'

769\|                  assert message in r.output, error(r.output)
770\|  
771\|          if not ignore_exception:
772\|              if message is None or "Exception:" not in message:
773\|                  with Then("check if output has exception") if steps else NullStep():
774\|                      if "Exception:" in r.output:
775\|                          if raise_on_exception:
776\|                              raise QueryRuntimeException(r.output)
777\|>                         assert False, error(r.output)
778\|  
779\|          return r
780\|
/window functions/tests/non distributed/frame clause/range overflow/negative overflow with Int16XFail 86ms
exception on conversion
AssertionError
Traceback (most recent call last):
  File "/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 228, in 
    regression()
  File "/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 224, in regression
    Feature(run=load("window_functions.tests.feature", "feature"), flags=TE)
  File "/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/feature.py", line 72, in feature
    Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE)
  File "/home/ubuntu/actions-runner/_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/actions-runner/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_overflow.py", line 145, in feature
    Scenario(run=scenario, flags=TE)
  File "/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_overflow.py", line 42, in negative_overflow_with_Int16
    execute_query(
  File "/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/common.py", line 140, in execute_query
    r = current().context.node.query(
  File "/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 777, 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 23.3.8):
Code: 69. DB::Exception: Received from localhost:9000. DB::Exception: Cannot convert value '2147450885': it cannot be represented as Int16. (ARGUMENT_OUT_OF_BOUND)
(query: select number as x, last_value(x) over (order by toInt16(x) desc range between current row and 2147450885 following) as last_value
        from (SELECT -number - 32763 AS number FROM numbers(1, 3))
         FORMAT TabSeparatedWithNames
)

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

Where
  File '/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py', line 777 in 'query'

769\|                  assert message in r.output, error(r.output)
770\|  
771\|          if not ignore_exception:
772\|              if message is None or "Exception:" not in message:
773\|                  with Then("check if output has exception") if steps else NullStep():
774\|                      if "Exception:" in r.output:
775\|                          if raise_on_exception:
776\|                              raise QueryRuntimeException(r.output)
777\|>                         assert False, error(r.output)
778\|  
779\|          return r
780\|
/window functions/tests/non distributed/frame clause/range overflow/positive overflow with Int16XFail 70ms
exception on conversion
AssertionError
Traceback (most recent call last):
  File "/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 228, in 
    regression()
  File "/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 224, in regression
    Feature(run=load("window_functions.tests.feature", "feature"), flags=TE)
  File "/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/feature.py", line 72, in feature
    Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE)
  File "/home/ubuntu/actions-runner/_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/actions-runner/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_overflow.py", line 145, in feature
    Scenario(run=scenario, flags=TE)
  File "/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_overflow.py", line 20, in positive_overflow_with_Int16
    execute_query(
  File "/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/common.py", line 140, in execute_query
    r = current().context.node.query(
  File "/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 777, 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 23.3.8):
Code: 69. DB::Exception: Received from localhost:9000. DB::Exception: Cannot convert value '2147450884': it cannot be represented as Int16. (ARGUMENT_OUT_OF_BOUND)
(query: select number as x, last_value(x) over (order by toInt16(x) range between current row and 2147450884 following) AS last_value
        from numbers(32764, 3)
         FORMAT TabSeparatedWithNames
)

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

Where
  File '/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py', line 777 in 'query'

769\|                  assert message in r.output, error(r.output)
770\|  
771\|          if not ignore_exception:
772\|              if message is None or "Exception:" not in message:
773\|                  with Then("check if output has exception") if steps else NullStep():
774\|                      if "Exception:" in r.output:
775\|                          if raise_on_exception:
776\|                              raise QueryRuntimeException(r.output)
777\|>                         assert False, error(r.output)
778\|  
779\|          return r
780\|
/window functions/tests/non distributed/frame clause/range errors/error negative following offsetXFail 72ms
https://github.com/ClickHouse/ClickHouse/issues/22442
AssertionError
Traceback (most recent call last):
  File "/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 228, in 
    regression()
  File "/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 224, in regression
    Feature(run=load("window_functions.tests.feature", "feature"), flags=TE)
  File "/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/feature.py", line 72, in feature
    Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE)
  File "/home/ubuntu/actions-runner/_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/actions-runner/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_errors.py", line 114, in feature
    Scenario(run=scenario, flags=TE)
  File "/home/ubuntu/actions-runner/_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/actions-runner/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 769, 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 23.3.8):
Code: 36. DB::Exception: Received from localhost:9000. DB::Exception: Window frame start offset must be nonnegative, -2 given. (BAD_ARGUMENTS)
(query: select max(enroll_date) over (order by salary range between 1 preceding and -2 following) AS max, salary, enroll_date from empsalary
)

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

Where
  File '/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py', line 769 in 'query'

761\|          if exitcode is not None:
762\|              with Then(f"exitcode should be {exitcode}") if steps else NullStep():
763\|                  assert r.exitcode == exitcode, error(r.output)
764\|  
765\|          if message is not None:
766\|              with Then(
767\|                  f"output should contain message", description=message
768\|              ) if steps else NullStep():
769\|>                 assert message in r.output, error(r.output)
770\|  
771\|          if not ignore_exception:
772\|              if message is None or "Exception:" not in message:
/window functions/tests/non distributed/frame clause/range errors/error negative preceding offsetXFail 73ms
https://github.com/ClickHouse/ClickHouse/issues/22442
AssertionError
Traceback (most recent call last):
  File "/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 228, in 
    regression()
  File "/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 224, in regression
    Feature(run=load("window_functions.tests.feature", "feature"), flags=TE)
  File "/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/feature.py", line 72, in feature
    Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE)
  File "/home/ubuntu/actions-runner/_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/actions-runner/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_errors.py", line 114, in feature
    Scenario(run=scenario, flags=TE)
  File "/home/ubuntu/actions-runner/_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/actions-runner/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 769, 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 23.3.8):
Code: 36. DB::Exception: Received from localhost:9000. DB::Exception: Window frame start offset must be nonnegative, -1 given. (BAD_ARGUMENTS)
(query: select max(enroll_date) over (order by salary range between -1 preceding and 2 following) AS max, salary, enroll_date from empsalary
)

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

Where
  File '/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py', line 769 in 'query'

761\|          if exitcode is not None:
762\|              with Then(f"exitcode should be {exitcode}") if steps else NullStep():
763\|                  assert r.exitcode == exitcode, error(r.output)
764\|  
765\|          if message is not None:
766\|              with Then(
767\|                  f"output should contain message", description=message
768\|              ) if steps else NullStep():
769\|>                 assert message in r.output, error(r.output)
770\|  
771\|          if not ignore_exception:
772\|              if message is None or "Exception:" not in message:
/window functions/tests/distributed/frame clause/range frame/between current row and unbounded following modifying named windowXFail 77ms
range with named window is not supported
AssertionError
Traceback (most recent call last):
  File "/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 228, in 
    regression()
  File "/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 224, in regression
    Feature(run=load("window_functions.tests.feature", "feature"), flags=TE)
  File "/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/feature.py", line 72, in feature
    Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE)
  File "/home/ubuntu/actions-runner/_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/actions-runner/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_frame.py", line 1733, in feature
    Scenario(run=scenario, flags=TE)
  File "/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_frame.py", line 1520, in between_current_row_and_unbounded_following_modifying_named_window
    execute_query(
  File "/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/common.py", line 152, in execute_query
    assert r.output.strip() == expected, error()
AssertionError: Oops! Assertion failed

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

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

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

144\|              no_checks=no_checks,
145\|          )
146\|          if no_checks:
147\|              return r
148\|  
149\|      if message is None:
150\|          if expected is not None:
151\|              with Then("I check output against expected"):
152\|>                 assert r.output.strip() == expected, error()
153\|          else:
154\|              with Then("I check output against snapshot"):
155\|                  with values() as that:
/window functions/tests/distributed/frame clause/range frame/between expr following and current row zero special caseXFail 72ms
known bug
AssertionError
Traceback (most recent call last):
  File "/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 228, in 
    regression()
  File "/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 224, in regression
    Feature(run=load("window_functions.tests.feature", "feature"), flags=TE)
  File "/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/feature.py", line 72, in feature
    Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE)
  File "/home/ubuntu/actions-runner/_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/actions-runner/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_frame.py", line 1733, in feature
    Scenario(run=scenario, flags=TE)
  File "/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_frame.py", line 1347, in between_expr_following_and_current_row_zero_special_case
    execute_query(
  File "/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/common.py", line 140, in execute_query
    r = current().context.node.query(
  File "/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 777, 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 23.3.8):
Code: 36. DB::Exception: Received from localhost:9000. DB::Exception: Window frame 'RANGE BETWEEN 0 FOLLOWING AND CURRENT ROW' is invalid. (BAD_ARGUMENTS)
(query: SELECT number,sum(number) OVER (ORDER BY number RANGE BETWEEN 0 FOLLOWING AND CURRENT ROW) AS sum FROM values('number Int8', (1),(1),(2),(3)) FORMAT TabSeparatedWithNames
)

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

Where
  File '/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py', line 777 in 'query'

769\|                  assert message in r.output, error(r.output)
770\|  
771\|          if not ignore_exception:
772\|              if message is None or "Exception:" not in message:
773\|                  with Then("check if output has exception") if steps else NullStep():
774\|                      if "Exception:" in r.output:
775\|                          if raise_on_exception:
776\|                              raise QueryRuntimeException(r.output)
777\|>                         assert False, error(r.output)
778\|  
779\|          return r
780\|
/window functions/tests/distributed/frame clause/range frame/between expr following and expr following without order by errorXFail 71ms
invalid error message
AssertionError
Traceback (most recent call last):
  File "/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 228, in 
    regression()
  File "/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 224, in regression
    Feature(run=load("window_functions.tests.feature", "feature"), flags=TE)
  File "/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/feature.py", line 72, in feature
    Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE)
  File "/home/ubuntu/actions-runner/_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/actions-runner/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_frame.py", line 1733, in feature
    Scenario(run=scenario, flags=TE)
  File "/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_frame.py", line 1211, in between_expr_following_and_expr_following_without_order_by_error
    self.context.node.query(
  File "/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 769, 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 23.3.8):
Code: 36. DB::Exception: Received from localhost:9000. DB::Exception: The RANGE OFFSET window frame requires exactly one ORDER BY column, 0 given. (BAD_ARGUMENTS)
(query: SELECT number,sum(number) OVER (RANGE BETWEEN 1 FOLLOWING AND 1 FOLLOWING) FROM values('number Int8', (1),(1),(2),(3))
)

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

Where
  File '/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py', line 769 in 'query'

761\|          if exitcode is not None:
762\|              with Then(f"exitcode should be {exitcode}") if steps else NullStep():
763\|                  assert r.exitcode == exitcode, error(r.output)
764\|  
765\|          if message is not None:
766\|              with Then(
767\|                  f"output should contain message", description=message
768\|              ) if steps else NullStep():
769\|>                 assert message in r.output, error(r.output)
770\|  
771\|          if not ignore_exception:
772\|              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 74ms
known bug
AssertionError
Traceback (most recent call last):
  File "/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 228, in 
    regression()
  File "/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 224, in regression
    Feature(run=load("window_functions.tests.feature", "feature"), flags=TE)
  File "/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/feature.py", line 72, in feature
    Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE)
  File "/home/ubuntu/actions-runner/_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/actions-runner/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_frame.py", line 1733, in feature
    Scenario(run=scenario, flags=TE)
  File "/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_frame.py", line 1416, in between_expr_following_and_expr_preceding_with_order_by_zero_special_case
    execute_query(
  File "/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/common.py", line 140, in execute_query
    r = current().context.node.query(
  File "/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 777, 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 23.3.8):
Code: 36. DB::Exception: Received from localhost:9000. DB::Exception: Frame start offset 0 FOLLOWING does not precede the frame end offset 0 PRECEDING. (BAD_ARGUMENTS)
(query: SELECT number,sum(number) OVER (ORDER BY number RANGE BETWEEN 0 FOLLOWING AND 0 PRECEDING) AS sum FROM values('number Int8', (1),(1),(2),(3)) FORMAT TabSeparatedWithNames
)

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

Where
  File '/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py', line 777 in 'query'

769\|                  assert message in r.output, error(r.output)
770\|  
771\|          if not ignore_exception:
772\|              if message is None or "Exception:" not in message:
773\|                  with Then("check if output has exception") if steps else NullStep():
774\|                      if "Exception:" in r.output:
775\|                          if raise_on_exception:
776\|                              raise QueryRuntimeException(r.output)
777\|>                         assert False, error(r.output)
778\|  
779\|          return r
780\|
/window functions/tests/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/actions-runner/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 228, in 
    regression()
  File "/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 224, in regression
    Feature(run=load("window_functions.tests.feature", "feature"), flags=TE)
  File "/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/feature.py", line 72, in feature
    Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE)
  File "/home/ubuntu/actions-runner/_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/actions-runner/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_frame.py", line 1733, in feature
    Scenario(run=scenario, flags=TE)
  File "/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_frame.py", line 1228, in between_expr_following_and_expr_preceding_without_order_by_error
    self.context.node.query(
  File "/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 769, 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 23.3.8):
Code: 36. DB::Exception: Received from localhost:9000. DB::Exception: Frame start offset 0 FOLLOWING does not precede the frame end offset 0 PRECEDING. (BAD_ARGUMENTS)
(query: SELECT number,sum(number) OVER (RANGE BETWEEN 0 FOLLOWING AND 0 PRECEDING) FROM values('number Int8', (1),(1),(2),(3))
)

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

Where
  File '/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py', line 769 in 'query'

761\|          if exitcode is not None:
762\|              with Then(f"exitcode should be {exitcode}") if steps else NullStep():
763\|                  assert r.exitcode == exitcode, error(r.output)
764\|  
765\|          if message is not None:
766\|              with Then(
767\|                  f"output should contain message", description=message
768\|              ) if steps else NullStep():
769\|>                 assert message in r.output, error(r.output)
770\|  
771\|          if not ignore_exception:
772\|              if message is None or "Exception:" not in message:
/window functions/tests/distributed/frame clause/range frame/order by decimalXFail 76ms
Exception: The RANGE OFFSET frame for 'DB::ColumnDecimal >' ORDER BY column is not implemented
AssertionError
Traceback (most recent call last):
  File "/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 228, in 
    regression()
  File "/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 224, in regression
    Feature(run=load("window_functions.tests.feature", "feature"), flags=TE)
  File "/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/feature.py", line 72, in feature
    Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE)
  File "/home/ubuntu/actions-runner/_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/actions-runner/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_frame.py", line 1733, in feature
    Scenario(run=scenario, flags=TE)
  File "/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_frame.py", line 1649, in order_by_decimal
    execute_query(
  File "/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/common.py", line 140, in execute_query
    r = current().context.node.query(
  File "/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 777, 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 23.3.8):
Code: 48. DB::Exception: Received from localhost:9000. DB::Exception: The RANGE OFFSET frame for 'DB::ColumnDecimal>' ORDER BY column is not implemented. (NOT_IMPLEMENTED)
(query: select id, f_numeric, first_value(id) over w AS first_value, last_value(id) over w AS last_value
        from numerics
        window w as (order by f_numeric range between
                     1 preceding and 1 following)
         FORMAT TabSeparatedWithNames
)

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

Where
  File '/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py', line 777 in 'query'

769\|                  assert message in r.output, error(r.output)
770\|  
771\|          if not ignore_exception:
772\|              if message is None or "Exception:" not in message:
773\|                  with Then("check if output has exception") if steps else NullStep():
774\|                      if "Exception:" in r.output:
775\|                          if raise_on_exception:
776\|                              raise QueryRuntimeException(r.output)
777\|>                         assert False, error(r.output)
778\|  
779\|          return r
780\|
/window functions/tests/distributed/frame clause/range frame/with nullsXFail 90ms
DB::Exception: The RANGE OFFSET frame for 'DB::ColumnNullable' ORDER BY column is not implemented
AssertionError
Traceback (most recent call last):
  File "/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 228, in 
    regression()
  File "/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 224, in regression
    Feature(run=load("window_functions.tests.feature", "feature"), flags=TE)
  File "/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/feature.py", line 72, in feature
    Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE)
  File "/home/ubuntu/actions-runner/_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/actions-runner/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_frame.py", line 1733, in feature
    Scenario(run=scenario, flags=TE)
  File "/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_frame.py", line 1708, in with_nulls
    execute_query(
  File "/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/common.py", line 140, in execute_query
    r = current().context.node.query(
  File "/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 777, 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 23.3.8):
Code: 48. DB::Exception: Received from localhost:9000. DB::Exception: The RANGE OFFSET frame for 'DB::ColumnNullable' ORDER BY column is not implemented. (NOT_IMPLEMENTED)
(query: select x, y,
               first_value(y) over w AS first_value,
               last_value(y) over w AS last_value
        from
          (select number as x, x as y from numbers(1,5)
           union all select null, 42
           union all select null, 43)
        window w as
          (order by x asc nulls first range between 2 preceding and 2 following)
         FORMAT TabSeparatedWithNames
)

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

Where
  File '/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py', line 777 in 'query'

769\|                  assert message in r.output, error(r.output)
770\|  
771\|          if not ignore_exception:
772\|              if message is None or "Exception:" not in message:
773\|                  with Then("check if output has exception") if steps else NullStep():
774\|                      if "Exception:" in r.output:
775\|                          if raise_on_exception:
776\|                              raise QueryRuntimeException(r.output)
777\|>                         assert False, error(r.output)
778\|  
779\|          return r
780\|
/window functions/tests/distributed/frame clause/range overflow/negative overflow with Int16XFail 73ms
exception on conversion
AssertionError
Traceback (most recent call last):
  File "/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 228, in 
    regression()
  File "/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 224, in regression
    Feature(run=load("window_functions.tests.feature", "feature"), flags=TE)
  File "/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/feature.py", line 72, in feature
    Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE)
  File "/home/ubuntu/actions-runner/_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/actions-runner/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_overflow.py", line 145, in feature
    Scenario(run=scenario, flags=TE)
  File "/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_overflow.py", line 42, in negative_overflow_with_Int16
    execute_query(
  File "/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/common.py", line 140, in execute_query
    r = current().context.node.query(
  File "/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 777, 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 23.3.8):
Code: 69. DB::Exception: Received from localhost:9000. DB::Exception: Cannot convert value '2147450885': it cannot be represented as Int16. (ARGUMENT_OUT_OF_BOUND)
(query: select number as x, last_value(x) over (order by toInt16(x) desc range between current row and 2147450885 following) as last_value
        from (SELECT -number - 32763 AS number FROM numbers(1, 3))
         FORMAT TabSeparatedWithNames
)

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

Where
  File '/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py', line 777 in 'query'

769\|                  assert message in r.output, error(r.output)
770\|  
771\|          if not ignore_exception:
772\|              if message is None or "Exception:" not in message:
773\|                  with Then("check if output has exception") if steps else NullStep():
774\|                      if "Exception:" in r.output:
775\|                          if raise_on_exception:
776\|                              raise QueryRuntimeException(r.output)
777\|>                         assert False, error(r.output)
778\|  
779\|          return r
780\|
/window functions/tests/distributed/frame clause/range overflow/positive overflow with Int16XFail 68ms
exception on conversion
AssertionError
Traceback (most recent call last):
  File "/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 228, in 
    regression()
  File "/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 224, in regression
    Feature(run=load("window_functions.tests.feature", "feature"), flags=TE)
  File "/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/feature.py", line 72, in feature
    Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE)
  File "/home/ubuntu/actions-runner/_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/actions-runner/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_overflow.py", line 145, in feature
    Scenario(run=scenario, flags=TE)
  File "/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_overflow.py", line 20, in positive_overflow_with_Int16
    execute_query(
  File "/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/common.py", line 140, in execute_query
    r = current().context.node.query(
  File "/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 777, 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 23.3.8):
Code: 69. DB::Exception: Received from localhost:9000. DB::Exception: Cannot convert value '2147450884': it cannot be represented as Int16. (ARGUMENT_OUT_OF_BOUND)
(query: select number as x, last_value(x) over (order by toInt16(x) range between current row and 2147450884 following) AS last_value
        from numbers(32764, 3)
         FORMAT TabSeparatedWithNames
)

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

Where
  File '/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py', line 777 in 'query'

769\|                  assert message in r.output, error(r.output)
770\|  
771\|          if not ignore_exception:
772\|              if message is None or "Exception:" not in message:
773\|                  with Then("check if output has exception") if steps else NullStep():
774\|                      if "Exception:" in r.output:
775\|                          if raise_on_exception:
776\|                              raise QueryRuntimeException(r.output)
777\|>                         assert False, error(r.output)
778\|  
779\|          return r
780\|
/window functions/tests/distributed/frame clause/range errors/error negative following offsetXFail 74ms
https://github.com/ClickHouse/ClickHouse/issues/22442
AssertionError
Traceback (most recent call last):
  File "/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 228, in 
    regression()
  File "/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 224, in regression
    Feature(run=load("window_functions.tests.feature", "feature"), flags=TE)
  File "/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/feature.py", line 72, in feature
    Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE)
  File "/home/ubuntu/actions-runner/_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/actions-runner/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_errors.py", line 114, in feature
    Scenario(run=scenario, flags=TE)
  File "/home/ubuntu/actions-runner/_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/actions-runner/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 769, 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 23.3.8):
Code: 36. DB::Exception: Received from localhost:9000. DB::Exception: Window frame start offset must be nonnegative, -2 given. (BAD_ARGUMENTS)
(query: select max(enroll_date) over (order by salary range between 1 preceding and -2 following) AS max, salary, enroll_date from empsalary
)

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

Where
  File '/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py', line 769 in 'query'

761\|          if exitcode is not None:
762\|              with Then(f"exitcode should be {exitcode}") if steps else NullStep():
763\|                  assert r.exitcode == exitcode, error(r.output)
764\|  
765\|          if message is not None:
766\|              with Then(
767\|                  f"output should contain message", description=message
768\|              ) if steps else NullStep():
769\|>                 assert message in r.output, error(r.output)
770\|  
771\|          if not ignore_exception:
772\|              if message is None or "Exception:" not in message:
/window functions/tests/distributed/frame clause/range errors/error negative preceding offsetXFail 68ms
https://github.com/ClickHouse/ClickHouse/issues/22442
AssertionError
Traceback (most recent call last):
  File "/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 228, in 
    regression()
  File "/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 224, in regression
    Feature(run=load("window_functions.tests.feature", "feature"), flags=TE)
  File "/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/feature.py", line 72, in feature
    Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE)
  File "/home/ubuntu/actions-runner/_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/actions-runner/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_errors.py", line 114, in feature
    Scenario(run=scenario, flags=TE)
  File "/home/ubuntu/actions-runner/_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/actions-runner/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 769, 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 23.3.8):
Code: 36. DB::Exception: Received from localhost:9000. DB::Exception: Window frame start offset must be nonnegative, -1 given. (BAD_ARGUMENTS)
(query: select max(enroll_date) over (order by salary range between -1 preceding and 2 following) AS max, salary, enroll_date from empsalary
)

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

Where
  File '/home/ubuntu/actions-runner/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py', line 769 in 'query'

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

Results

Test Name Result Duration
/window functions OK 5m 51s
/window functions/tests OK 4m 29s
/window functions/tests/non distributed OK 2m 8s
/window functions/tests/non distributed/window spec OK 548ms
/window functions/tests/non distributed/window spec/empty OK 67ms
/window functions/tests/non distributed/window spec/frame clause OK 65ms
/window functions/tests/non distributed/window spec/order by with frame OK 69ms
/window functions/tests/non distributed/window spec/orderby clause OK 67ms
/window functions/tests/non distributed/window spec/partition clause OK 69ms
/window functions/tests/non distributed/window spec/partition with frame OK 68ms
/window functions/tests/non distributed/window spec/partition with order by OK 69ms
/window functions/tests/non distributed/window spec/partition with order by and frame OK 69ms
/window functions/tests/non distributed/partition clause OK 263ms
/window functions/tests/non distributed/partition clause/invalid expr error OK 61ms
/window functions/tests/non distributed/partition clause/missing expr error OK 64ms
/window functions/tests/non distributed/partition clause/multiple expr OK 66ms
/window functions/tests/non distributed/partition clause/single expr OK 68ms
/window functions/tests/non distributed/order clause OK 786ms
/window functions/tests/non distributed/order clause/by a non integer constant OK 65ms
/window functions/tests/non distributed/order clause/by column OK 68ms
/window functions/tests/non distributed/order clause/by expr OK 67ms
/window functions/tests/non distributed/order clause/by expr with aggregates OK 129ms
/window functions/tests/non distributed/order clause/invalid expr error OK 60ms
/window functions/tests/non distributed/order clause/missing expr error OK 61ms
/window functions/tests/non distributed/order clause/multiple expr asc asc OK 68ms
/window functions/tests/non distributed/order clause/multiple expr asc desc OK 64ms
/window functions/tests/non distributed/order clause/multiple expr desc desc OK 66ms
/window functions/tests/non distributed/order clause/single expr asc OK 65ms
/window functions/tests/non distributed/order clause/single expr desc OK 65ms
/window functions/tests/non distributed/frame clause OK 9s 441ms
/window functions/tests/non distributed/frame clause/default frame OK 140ms
/window functions/tests/non distributed/frame clause/default frame/with order by OK 72ms
/window functions/tests/non distributed/frame clause/default frame/without order by OK 67ms
/window functions/tests/non distributed/frame clause/rows frame OK 2s 428ms
/window functions/tests/non distributed/frame clause/rows frame/between current row and current row OK 63ms
/window functions/tests/non distributed/frame clause/rows frame/between current row and expr following OK 70ms
/window functions/tests/non distributed/frame clause/rows frame/between current row and expr preceding error OK 63ms
/window functions/tests/non distributed/frame clause/rows frame/between current row and unbounded following OK 70ms
/window functions/tests/non distributed/frame clause/rows frame/between current row and unbounded preceding error OK 61ms
/window functions/tests/non distributed/frame clause/rows frame/between expr following and expr following OK 65ms
/window functions/tests/non distributed/frame clause/rows frame/between expr following and expr following error OK 63ms
/window functions/tests/non distributed/frame clause/rows frame/between expr following and expr following ref OK 69ms
/window functions/tests/non distributed/frame clause/rows frame/between expr following and unbounded following OK 66ms
/window functions/tests/non distributed/frame clause/rows frame/between expr following error OK 192ms
/window functions/tests/non distributed/frame clause/rows frame/between expr preceding and current row OK 68ms
/window functions/tests/non distributed/frame clause/rows frame/between expr preceding and expr following OK 66ms
/window functions/tests/non distributed/frame clause/rows frame/between expr preceding and expr following ref OK 70ms
/window functions/tests/non distributed/frame clause/rows frame/between expr preceding and expr preceding OK 67ms
/window functions/tests/non distributed/frame clause/rows frame/between expr preceding and expr preceding error OK 62ms
/window functions/tests/non distributed/frame clause/rows frame/between expr preceding and expr preceding ref OK 66ms
/window functions/tests/non distributed/frame clause/rows frame/between expr preceding and unbounded following OK 68ms
/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 307ms
/window functions/tests/non distributed/frame clause/rows frame/between unbounded preceding and current row OK 73ms
/window functions/tests/non distributed/frame clause/rows frame/between unbounded preceding and expr following OK 81ms
/window functions/tests/non distributed/frame clause/rows frame/between unbounded preceding and expr preceding OK 64ms
/window functions/tests/non distributed/frame clause/rows frame/between unbounded preceding and unbounded following OK 68ms
/window functions/tests/non distributed/frame clause/rows frame/between unbounded preceding and unbounded preceding error OK 63ms
/window functions/tests/non distributed/frame clause/rows frame/invalid frame extent OK 59ms
/window functions/tests/non distributed/frame clause/rows frame/missing frame extent OK 61ms
/window functions/tests/non distributed/frame clause/rows frame/start current row OK 64ms
/window functions/tests/non distributed/frame clause/rows frame/start expr following error OK 62ms
/window functions/tests/non distributed/frame clause/rows frame/start expr preceding OK 64ms
/window functions/tests/non distributed/frame clause/rows frame/start unbounded following error OK 65ms
/window functions/tests/non distributed/frame clause/rows frame/start unbounded preceding OK 65ms
/window functions/tests/non distributed/frame clause/range frame OK 5s 395ms
/window functions/tests/non distributed/frame clause/range frame/between current row and current row OK 144ms
/window functions/tests/non distributed/frame clause/range frame/between current row and expr following with order by OK 86ms
/window functions/tests/non distributed/frame clause/range frame/between current row and expr following without order by error OK 70ms
/window functions/tests/non distributed/frame clause/range frame/between current row and expr preceding error OK 125ms
/window functions/tests/non distributed/frame clause/range frame/between current row and unbounded following OK 204ms
/window functions/tests/non distributed/frame clause/range frame/between current row and unbounded following in named window OK 66ms
/window functions/tests/non distributed/frame clause/range frame/between current row and unbounded following modifying named window XFail 109ms
/window functions/tests/non distributed/frame clause/range frame/between current row and unbounded preceding error OK 130ms
/window functions/tests/non distributed/frame clause/range frame/between expr following and current row with order by error OK 62ms
/window functions/tests/non distributed/frame clause/range frame/between expr following and current row without order by error OK 62ms
/window functions/tests/non distributed/frame clause/range frame/between expr following and current row zero special case XFail 73ms
/window functions/tests/non distributed/frame clause/range frame/between expr following and expr following with order by OK 67ms
/window functions/tests/non distributed/frame clause/range frame/between expr following and expr following with order by error OK 63ms
/window functions/tests/non distributed/frame clause/range frame/between expr following and expr following without order by error XFail 70ms
/window functions/tests/non distributed/frame clause/range frame/between expr following and expr preceding error OK 126ms
/window functions/tests/non distributed/frame clause/range frame/between expr following and expr preceding with order by zero special case XFail 67ms
/window functions/tests/non distributed/frame clause/range frame/between expr following and expr preceding without order by error XFail 69ms
/window functions/tests/non distributed/frame clause/range frame/between expr following and unbounded following with order by OK 68ms
/window functions/tests/non distributed/frame clause/range frame/between expr following and unbounded following without order by error OK 67ms
/window functions/tests/non distributed/frame clause/range frame/between expr following and unbounded preceding error OK 124ms
/window functions/tests/non distributed/frame clause/range frame/between expr preceding and current row with order by OK 67ms
/window functions/tests/non distributed/frame clause/range frame/between expr preceding and current row without order by error OK 64ms
/window functions/tests/non distributed/frame clause/range frame/between expr preceding and expr following with order by OK 136ms
/window functions/tests/non distributed/frame clause/range frame/between expr preceding and expr following with partition and order by OK 77ms
/window functions/tests/non distributed/frame clause/range frame/between expr preceding and expr following with partition by same column twice OK 72ms
/window functions/tests/non distributed/frame clause/range frame/between expr preceding and expr following with partition by two columns OK 73ms
/window functions/tests/non distributed/frame clause/range frame/between expr preceding and expr following without order by error OK 63ms
/window functions/tests/non distributed/frame clause/range frame/between expr preceding and expr preceding with order by OK 140ms
/window functions/tests/non distributed/frame clause/range frame/between expr preceding and expr preceding with order by error OK 61ms
/window functions/tests/non distributed/frame clause/range frame/between expr preceding and expr preceding without order by error OK 64ms
/window functions/tests/non distributed/frame clause/range frame/between expr preceding and unbounded following with order by OK 72ms
/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 127ms
/window functions/tests/non distributed/frame clause/range frame/between unbounded following and current row error OK 123ms
/window functions/tests/non distributed/frame clause/range frame/between unbounded following and expr following error OK 126ms
/window functions/tests/non distributed/frame clause/range frame/between unbounded following and expr preceding error OK 141ms
/window functions/tests/non distributed/frame clause/range frame/between unbounded following and unbounded following error OK 127ms
/window functions/tests/non distributed/frame clause/range frame/between unbounded following and unbounded preceding error OK 121ms
/window functions/tests/non distributed/frame clause/range frame/between unbounded preceding and current row OK 152ms
/window functions/tests/non distributed/frame clause/range frame/between unbounded preceding and current row with expressions in order by and aggregate OK 71ms
/window functions/tests/non distributed/frame clause/range frame/between unbounded preceding and expr following with order by OK 69ms
/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 68ms
/window functions/tests/non distributed/frame clause/range frame/between unbounded preceding and expr preceding without order by error OK 61ms
/window functions/tests/non distributed/frame clause/range frame/between unbounded preceding and unbounded following OK 135ms
/window functions/tests/non distributed/frame clause/range frame/between unbounded preceding and unbounded preceding error OK 118ms
/window functions/tests/non distributed/frame clause/range frame/invalid frame extent OK 61ms
/window functions/tests/non distributed/frame clause/range frame/missing frame extent OK 57ms
/window functions/tests/non distributed/frame clause/range frame/order by decimal XFail 70ms
/window functions/tests/non distributed/frame clause/range frame/order by float OK 69ms
/window functions/tests/non distributed/frame clause/range frame/start current row with order by OK 64ms
/window functions/tests/non distributed/frame clause/range frame/start current row without order by OK 67ms
/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 60ms
/window functions/tests/non distributed/frame clause/range frame/start expr preceding order by non numerical column error OK 61ms
/window functions/tests/non distributed/frame clause/range frame/start expr preceding with order by OK 67ms
/window functions/tests/non distributed/frame clause/range frame/start expr preceding without order by error OK 60ms
/window functions/tests/non distributed/frame clause/range frame/start unbounded following error OK 124ms
/window functions/tests/non distributed/frame clause/range frame/start unbounded preceding with order by OK 67ms
/window functions/tests/non distributed/frame clause/range frame/start unbounded preceding without order by OK 66ms
/window functions/tests/non distributed/frame clause/range frame/with nulls XFail 83ms
/window functions/tests/non distributed/frame clause/range overflow OK 432ms
/window functions/tests/non distributed/frame clause/range overflow/negative overflow for Int32 OK 67ms
/window functions/tests/non distributed/frame clause/range overflow/negative overflow for Int64 OK 68ms
/window functions/tests/non distributed/frame clause/range overflow/negative overflow with Int16 XFail 86ms
/window functions/tests/non distributed/frame clause/range overflow/positive overflow for Int32 OK 67ms
/window functions/tests/non distributed/frame clause/range overflow/positive overflow for Int64 OK 69ms
/window functions/tests/non distributed/frame clause/range overflow/positive overflow with Int16 XFail 70ms
/window functions/tests/non distributed/frame clause/range datetime OK 617ms
/window functions/tests/non distributed/frame clause/range datetime/datetime order by asc range between n preceding and n following OK 70ms
/window functions/tests/non distributed/frame clause/range datetime/datetime order by desc range between n preceding and n following OK 70ms
/window functions/tests/non distributed/frame clause/range datetime/datetime with timezone order by asc range between n preceding and n following OK 90ms
/window functions/tests/non distributed/frame clause/range datetime/datetime with timezone order by desc range between n preceding and n following OK 90ms
/window functions/tests/non distributed/frame clause/range datetime/order by asc range between days preceding and days following OK 67ms
/window functions/tests/non distributed/frame clause/range datetime/order by desc range between days following and days following OK 70ms
/window functions/tests/non distributed/frame clause/range datetime/order by desc range between days preceding and days following OK 71ms
/window functions/tests/non distributed/frame clause/range datetime/order by desc range between days preceding and days preceding OK 82ms
/window functions/tests/non distributed/frame clause/range errors OK 403ms
/window functions/tests/non distributed/frame clause/range errors/error missing order by OK 62ms
/window functions/tests/non distributed/frame clause/range errors/error missing order by with partition by clause OK 63ms
/window functions/tests/non distributed/frame clause/range errors/error more than one order by column OK 63ms
/window functions/tests/non distributed/frame clause/range errors/error negative following offset XFail 72ms
/window functions/tests/non distributed/frame clause/range errors/error negative preceding offset XFail 73ms
/window functions/tests/non distributed/frame clause/range errors/error range over non numerical column OK 65ms
/window functions/tests/non distributed/window clause OK 337ms
/window functions/tests/non distributed/window clause/missing window spec OK 62ms
/window functions/tests/non distributed/window clause/multiple identical windows OK 71ms
/window functions/tests/non distributed/window clause/multiple windows OK 70ms
/window functions/tests/non distributed/window clause/single window OK 65ms
/window functions/tests/non distributed/window clause/unused window OK 65ms
/window functions/tests/non distributed/over clause OK 396ms
/window functions/tests/non distributed/over clause/adhoc window OK 73ms
/window functions/tests/non distributed/over clause/empty OK 69ms
/window functions/tests/non distributed/over clause/empty named window OK 67ms
/window functions/tests/non distributed/over clause/invalid multiple windows OK 61ms
/window functions/tests/non distributed/over clause/invalid window name OK 60ms
/window functions/tests/non distributed/over clause/missing window spec OK 60ms
/window functions/tests/non distributed/funcs OK 2s 55ms
/window functions/tests/non distributed/funcs/dense rank OK 66ms
/window functions/tests/non distributed/funcs/first value OK 137ms
/window functions/tests/non distributed/funcs/first value with lead workaround OK 68ms
/window functions/tests/non distributed/funcs/lag OK 216ms
/window functions/tests/non distributed/funcs/lagInFrame OK 343ms
/window functions/tests/non distributed/funcs/last value OK 319ms
/window functions/tests/non distributed/funcs/last value with lag workaround OK 66ms
/window functions/tests/non distributed/funcs/last value with no frame OK 68ms
/window functions/tests/non distributed/funcs/lead OK 274ms
/window functions/tests/non distributed/funcs/leadInFrame OK 351ms
/window functions/tests/non distributed/funcs/rank OK 69ms
/window functions/tests/non distributed/funcs/row number OK 67ms
/window functions/tests/non distributed/aggregate funcs OK 5s 475ms
/window functions/tests/non distributed/aggregate funcs/aggregate and window function in the same window OK 69ms
/window functions/tests/non distributed/aggregate funcs/aggregate funcs over rows frame OK 4s 476ms
/window functions/tests/non distributed/aggregate funcs/aggregate function recovers from nan OK 76ms
/window functions/tests/non distributed/aggregate funcs/avgWeighted OK 216ms
/window functions/tests/non distributed/aggregate funcs/avg with nulls OK 71ms
/window functions/tests/non distributed/aggregate funcs/bit functions OK 66ms
/window functions/tests/non distributed/aggregate funcs/nested aggregates OK 75ms
/window functions/tests/non distributed/aggregate funcs/stddevpop OK 68ms
/window functions/tests/non distributed/aggregate funcs/stddevsamp OK 71ms
/window functions/tests/non distributed/aggregate funcs/sum OK 68ms
/window functions/tests/non distributed/aggregate funcs/ungrouped aggregate over empty row set OK 72ms
/window functions/tests/non distributed/aggregate funcs/var pop OK 71ms
/window functions/tests/non distributed/aggregate funcs/var samp OK 66ms
/window functions/tests/non distributed/time decayed funcs OK 1m 38s
/window functions/tests/non distributed/time decayed funcs/exponentialTimeDecayedAvg OK 11s 753ms
/window functions/tests/non distributed/time decayed funcs/exponentialTimeDecayedCount OK 10s 311ms
/window functions/tests/non distributed/time decayed funcs/exponentialTimeDecayedMax OK 1m 4s
/window functions/tests/non distributed/time decayed funcs/exponentialTimeDecayedSum OK 11s 643ms
/window functions/tests/non distributed/errors OK 637ms
/window functions/tests/non distributed/errors/error coma between partition by and order by clause OK 60ms
/window functions/tests/non distributed/errors/error named window defined twice OK 67ms
/window functions/tests/non distributed/errors/error order by another window function OK 64ms
/window functions/tests/non distributed/errors/error select from window OK 61ms
/window functions/tests/non distributed/errors/error using non window function OK 63ms
/window functions/tests/non distributed/errors/error window function in alter delete where OK 63ms
/window functions/tests/non distributed/errors/error window function in group by OK 64ms
/window functions/tests/non distributed/errors/error window function in having OK 63ms
/window functions/tests/non distributed/errors/error window function in join OK 65ms
/window functions/tests/non distributed/errors/error window function in where OK 60ms
/window functions/tests/non distributed/misc OK 1s 367ms
/window functions/tests/non distributed/misc/count with empty over clause without start OK 69ms
/window functions/tests/non distributed/misc/empty table OK 72ms
/window functions/tests/non distributed/misc/exclude clause OK 66ms
/window functions/tests/non distributed/misc/from subquery OK 72ms
/window functions/tests/non distributed/misc/group by and multiple windows OK 77ms
/window functions/tests/non distributed/misc/group by and one window OK 75ms
/window functions/tests/non distributed/misc/groups frame OK 64ms
/window functions/tests/non distributed/misc/in view OK 278ms
/window functions/tests/non distributed/misc/query with order by and one window OK 67ms
/window functions/tests/non distributed/misc/subquery expr preceding OK 68ms
/window functions/tests/non distributed/misc/subquery multiple window functions OK 73ms
/window functions/tests/non distributed/misc/subquery with multiple windows filtering OK 86ms
/window functions/tests/non distributed/misc/window functions in select expression OK 65ms
/window functions/tests/non distributed/misc/window functions in subquery OK 80ms
/window functions/tests/non distributed/misc/windows with same partitioning but different ordering OK 73ms
/window functions/tests/non distributed/misc/with union all OK 70ms
/window functions/tests/non distributed/datatypes OK 828ms
/window functions/tests/non distributed/datatypes/date OK 69ms
/window functions/tests/non distributed/datatypes/datetime OK 68ms
/window functions/tests/non distributed/datatypes/datetime64 OK 65ms
/window functions/tests/non distributed/datatypes/decimal32 OK 68ms
/window functions/tests/non distributed/datatypes/enum OK 72ms
/window functions/tests/non distributed/datatypes/fixed string OK 72ms
/window functions/tests/non distributed/datatypes/ipv4 OK 66ms
/window functions/tests/non distributed/datatypes/ipv6 OK 70ms
/window functions/tests/non distributed/datatypes/low cardinality OK 67ms
/window functions/tests/non distributed/datatypes/map OK 69ms
/window functions/tests/non distributed/datatypes/string OK 66ms
/window functions/tests/non distributed/datatypes/uuid OK 67ms
/window functions/tests/non distributed/non-negative derivative func OK 5s 489ms
/window functions/tests/non distributed/non-negative derivative func/acceptance OK 708ms
/window functions/tests/non distributed/non-negative derivative func/check intervals OK 554ms
/window functions/tests/non distributed/non-negative derivative func/check negative result OK 65ms
/window functions/tests/non distributed/non-negative derivative func/check one row per partition OK 72ms
/window functions/tests/non distributed/non-negative derivative func/check over windows OK 1s 792ms
/window functions/tests/non distributed/non-negative derivative func/division by tiny OK 143ms
/window functions/tests/non distributed/non-negative derivative func/division by zero OK 69ms
/window functions/tests/non distributed/non-negative derivative func/empty table OK 228ms
/window functions/tests/non distributed/non-negative derivative func/null values OK 132ms
/window functions/tests/non distributed/non-negative derivative func/valid metric types OK 914ms
/window functions/tests/non distributed/non-negative derivative func/valid timestamp types OK 212ms
/window functions/tests/non distributed/non-negative derivative func/wrong number of arguments or types OK 521ms
/window functions/tests/non distributed/non-negative derivative func/zero interval OK 66ms
/window functions/tests/distributed OK 2m 21s
/window functions/tests/distributed/window spec OK 607ms
/window functions/tests/distributed/window spec/empty OK 72ms
/window functions/tests/distributed/window spec/frame clause OK 88ms
/window functions/tests/distributed/window spec/order by with frame OK 72ms
/window functions/tests/distributed/window spec/orderby clause OK 73ms
/window functions/tests/distributed/window spec/partition clause OK 73ms
/window functions/tests/distributed/window spec/partition with frame OK 76ms
/window functions/tests/distributed/window spec/partition with order by OK 72ms
/window functions/tests/distributed/window spec/partition with order by and frame OK 74ms
/window functions/tests/distributed/partition clause OK 260ms
/window functions/tests/distributed/partition clause/invalid expr error OK 61ms
/window functions/tests/distributed/partition clause/missing expr error OK 60ms
/window functions/tests/distributed/partition clause/multiple expr OK 67ms
/window functions/tests/distributed/partition clause/single expr OK 68ms
/window functions/tests/distributed/order clause OK 787ms
/window functions/tests/distributed/order clause/by a non integer constant OK 64ms
/window functions/tests/distributed/order clause/by column OK 71ms
/window functions/tests/distributed/order clause/by expr OK 73ms
/window functions/tests/distributed/order clause/by expr with aggregates OK 113ms
/window functions/tests/distributed/order clause/invalid expr error OK 63ms
/window functions/tests/distributed/order clause/missing expr error OK 60ms
/window functions/tests/distributed/order clause/multiple expr asc asc OK 67ms
/window functions/tests/distributed/order clause/multiple expr asc desc OK 70ms
/window functions/tests/distributed/order clause/multiple expr desc desc OK 64ms
/window functions/tests/distributed/order clause/single expr asc OK 66ms
/window functions/tests/distributed/order clause/single expr desc OK 67ms
/window functions/tests/distributed/frame clause OK 9s 762ms
/window functions/tests/distributed/frame clause/default frame OK 137ms
/window functions/tests/distributed/frame clause/default frame/with order by OK 72ms
/window functions/tests/distributed/frame clause/default frame/without order by OK 63ms
/window functions/tests/distributed/frame clause/rows frame OK 2s 551ms
/window functions/tests/distributed/frame clause/rows frame/between current row and current row OK 76ms
/window functions/tests/distributed/frame clause/rows frame/between current row and expr following OK 79ms
/window functions/tests/distributed/frame clause/rows frame/between current row and expr preceding error OK 67ms
/window functions/tests/distributed/frame clause/rows frame/between current row and unbounded following OK 73ms
/window functions/tests/distributed/frame clause/rows frame/between current row and unbounded preceding error OK 61ms
/window functions/tests/distributed/frame clause/rows frame/between expr following and expr following OK 74ms
/window functions/tests/distributed/frame clause/rows frame/between expr following and expr following error OK 61ms
/window functions/tests/distributed/frame clause/rows frame/between expr following and expr following ref OK 75ms
/window functions/tests/distributed/frame clause/rows frame/between expr following and unbounded following OK 75ms
/window functions/tests/distributed/frame clause/rows frame/between expr following error OK 196ms
/window functions/tests/distributed/frame clause/rows frame/between expr preceding and current row OK 77ms
/window functions/tests/distributed/frame clause/rows frame/between expr preceding and expr following OK 73ms
/window functions/tests/distributed/frame clause/rows frame/between expr preceding and expr following ref OK 74ms
/window functions/tests/distributed/frame clause/rows frame/between expr preceding and expr preceding OK 72ms
/window functions/tests/distributed/frame clause/rows frame/between expr preceding and expr preceding error OK 59ms
/window functions/tests/distributed/frame clause/rows frame/between expr preceding and expr preceding ref OK 75ms
/window functions/tests/distributed/frame clause/rows frame/between expr preceding and unbounded following OK 81ms
/window functions/tests/distributed/frame clause/rows frame/between expr preceding and unbounded preceding error OK 61ms
/window functions/tests/distributed/frame clause/rows frame/between unbounded following error OK 305ms
/window functions/tests/distributed/frame clause/rows frame/between unbounded preceding and current row OK 68ms
/window functions/tests/distributed/frame clause/rows frame/between unbounded preceding and expr following OK 73ms
/window functions/tests/distributed/frame clause/rows frame/between unbounded preceding and expr preceding OK 74ms
/window functions/tests/distributed/frame clause/rows frame/between unbounded preceding and unbounded following OK 71ms
/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 59ms
/window functions/tests/distributed/frame clause/rows frame/missing frame extent OK 61ms
/window functions/tests/distributed/frame clause/rows frame/start current row OK 68ms
/window functions/tests/distributed/frame clause/rows frame/start expr following error OK 68ms
/window functions/tests/distributed/frame clause/rows frame/start expr preceding OK 71ms
/window functions/tests/distributed/frame clause/rows frame/start unbounded following error OK 63ms
/window functions/tests/distributed/frame clause/rows frame/start unbounded preceding OK 71ms
/window functions/tests/distributed/frame clause/range frame OK 5s 616ms
/window functions/tests/distributed/frame clause/range frame/between current row and current row OK 157ms
/window functions/tests/distributed/frame clause/range frame/between current row and expr following with order by OK 72ms
/window functions/tests/distributed/frame clause/range frame/between current row and expr following without order by error OK 63ms
/window functions/tests/distributed/frame clause/range frame/between current row and expr preceding error OK 126ms
/window functions/tests/distributed/frame clause/range frame/between current row and unbounded following OK 246ms
/window functions/tests/distributed/frame clause/range frame/between current row and unbounded following in named window OK 72ms
/window functions/tests/distributed/frame clause/range frame/between current row and unbounded following modifying named window XFail 77ms
/window functions/tests/distributed/frame clause/range frame/between current row and unbounded preceding error OK 122ms
/window functions/tests/distributed/frame clause/range frame/between expr following and current row with order by error OK 62ms
/window functions/tests/distributed/frame clause/range frame/between expr following and current row without order by error OK 67ms
/window functions/tests/distributed/frame clause/range frame/between expr following and current row zero special case XFail 72ms
/window functions/tests/distributed/frame clause/range frame/between expr following and expr following with order by OK 76ms
/window functions/tests/distributed/frame clause/range frame/between expr following and expr following with order by error OK 64ms
/window functions/tests/distributed/frame clause/range frame/between expr following and expr following without order by error XFail 71ms
/window functions/tests/distributed/frame clause/range frame/between expr following and expr preceding error OK 122ms
/window functions/tests/distributed/frame clause/range frame/between expr following and expr preceding with order by zero special case XFail 74ms
/window functions/tests/distributed/frame clause/range frame/between expr following and expr preceding without order by error XFail 68ms
/window functions/tests/distributed/frame clause/range frame/between expr following and unbounded following with order by OK 64ms
/window functions/tests/distributed/frame clause/range frame/between expr following and unbounded following without order by error OK 65ms
/window functions/tests/distributed/frame clause/range frame/between expr following and unbounded preceding error OK 122ms
/window functions/tests/distributed/frame clause/range frame/between expr preceding and current row with order by OK 69ms
/window functions/tests/distributed/frame clause/range frame/between expr preceding and current row without order by error OK 66ms
/window functions/tests/distributed/frame clause/range frame/between expr preceding and expr following with order by OK 155ms
/window functions/tests/distributed/frame clause/range frame/between expr preceding and expr following with partition and order by OK 74ms
/window functions/tests/distributed/frame clause/range frame/between expr preceding and expr following with partition by same column twice OK 86ms
/window functions/tests/distributed/frame clause/range frame/between expr preceding and expr following with partition by two columns OK 79ms
/window functions/tests/distributed/frame clause/range frame/between expr preceding and expr following without order by error OK 61ms
/window functions/tests/distributed/frame clause/range frame/between expr preceding and expr preceding with order by OK 152ms
/window functions/tests/distributed/frame clause/range frame/between expr preceding and expr preceding with order by error OK 68ms
/window functions/tests/distributed/frame clause/range frame/between expr preceding and expr preceding without order by error OK 64ms
/window functions/tests/distributed/frame clause/range frame/between expr preceding and unbounded following with order by OK 74ms
/window functions/tests/distributed/frame clause/range frame/between expr preceding and unbounded following without order by error OK 65ms
/window functions/tests/distributed/frame clause/range frame/between expr preceding and unbounded preceding error OK 125ms
/window functions/tests/distributed/frame clause/range frame/between unbounded following and current row error OK 126ms
/window functions/tests/distributed/frame clause/range frame/between unbounded following and expr following error OK 126ms
/window functions/tests/distributed/frame clause/range frame/between unbounded following and expr preceding error OK 143ms
/window functions/tests/distributed/frame clause/range frame/between unbounded following and unbounded following error OK 118ms
/window functions/tests/distributed/frame clause/range frame/between unbounded following and unbounded preceding error OK 125ms
/window functions/tests/distributed/frame clause/range frame/between unbounded preceding and current row OK 173ms
/window functions/tests/distributed/frame clause/range frame/between unbounded preceding and current row with expressions in order by and aggregate OK 86ms
/window functions/tests/distributed/frame clause/range frame/between unbounded preceding and expr following with order by OK 76ms
/window functions/tests/distributed/frame clause/range frame/between unbounded preceding and expr following without order by error OK 67ms
/window functions/tests/distributed/frame clause/range frame/between unbounded preceding and expr preceding with order by OK 74ms
/window functions/tests/distributed/frame clause/range frame/between unbounded preceding and expr preceding without order by error OK 66ms
/window functions/tests/distributed/frame clause/range frame/between unbounded preceding and unbounded following OK 154ms
/window functions/tests/distributed/frame clause/range frame/between unbounded preceding and unbounded preceding error OK 124ms
/window functions/tests/distributed/frame clause/range frame/invalid frame extent OK 55ms
/window functions/tests/distributed/frame clause/range frame/missing frame extent OK 58ms
/window functions/tests/distributed/frame clause/range frame/order by decimal XFail 76ms
/window functions/tests/distributed/frame clause/range frame/order by float OK 74ms
/window functions/tests/distributed/frame clause/range frame/start current row with order by OK 77ms
/window functions/tests/distributed/frame clause/range frame/start current row without order by OK 72ms
/window functions/tests/distributed/frame clause/range frame/start expr following with order by error OK 66ms
/window functions/tests/distributed/frame clause/range frame/start expr following without order by error OK 60ms
/window functions/tests/distributed/frame clause/range frame/start expr preceding order by non numerical column error OK 68ms
/window functions/tests/distributed/frame clause/range frame/start expr preceding with order by OK 71ms
/window functions/tests/distributed/frame clause/range frame/start expr preceding without order by error OK 66ms
/window functions/tests/distributed/frame clause/range frame/start unbounded following error OK 126ms
/window functions/tests/distributed/frame clause/range frame/start unbounded preceding with order by OK 71ms
/window functions/tests/distributed/frame clause/range frame/start unbounded preceding without order by OK 72ms
/window functions/tests/distributed/frame clause/range frame/with nulls XFail 90ms
/window functions/tests/distributed/frame clause/range overflow OK 419ms
/window functions/tests/distributed/frame clause/range overflow/negative overflow for Int32 OK 70ms
/window functions/tests/distributed/frame clause/range overflow/negative overflow for Int64 OK 67ms
/window functions/tests/distributed/frame clause/range overflow/negative overflow with Int16 XFail 73ms
/window functions/tests/distributed/frame clause/range overflow/positive overflow for Int32 OK 67ms
/window functions/tests/distributed/frame clause/range overflow/positive overflow for Int64 OK 68ms
/window functions/tests/distributed/frame clause/range overflow/positive overflow with Int16 XFail 68ms
/window functions/tests/distributed/frame clause/range datetime OK 634ms
/window functions/tests/distributed/frame clause/range datetime/datetime order by asc range between n preceding and n following OK 84ms
/window functions/tests/distributed/frame clause/range datetime/datetime order by desc range between n preceding and n following OK 75ms
/window functions/tests/distributed/frame clause/range datetime/datetime with timezone order by asc range between n preceding and n following OK 88ms
/window functions/tests/distributed/frame clause/range datetime/datetime with timezone order by desc range between n preceding and n following OK 88ms
/window functions/tests/distributed/frame clause/range datetime/order by asc range between days preceding and days following OK 69ms
/window functions/tests/distributed/frame clause/range datetime/order by desc range between days following and days following OK 70ms
/window functions/tests/distributed/frame clause/range datetime/order by desc range between days preceding and days following OK 73ms
/window functions/tests/distributed/frame clause/range datetime/order by desc range between days preceding and days preceding OK 80ms
/window functions/tests/distributed/frame clause/range errors OK 398ms
/window functions/tests/distributed/frame clause/range errors/error missing order by OK 62ms
/window functions/tests/distributed/frame clause/range errors/error missing order by with partition by clause OK 62ms
/window functions/tests/distributed/frame clause/range errors/error more than one order by column OK 64ms
/window functions/tests/distributed/frame clause/range errors/error negative following offset XFail 74ms
/window functions/tests/distributed/frame clause/range errors/error negative preceding offset XFail 68ms
/window functions/tests/distributed/frame clause/range errors/error range over non numerical column OK 62ms
/window functions/tests/distributed/window clause OK 360ms
/window functions/tests/distributed/window clause/missing window spec OK 71ms
/window functions/tests/distributed/window clause/multiple identical windows OK 70ms
/window functions/tests/distributed/window clause/multiple windows OK 73ms
/window functions/tests/distributed/window clause/single window OK 69ms
/window functions/tests/distributed/window clause/unused window OK 72ms
/window functions/tests/distributed/over clause OK 416ms
/window functions/tests/distributed/over clause/adhoc window OK 76ms
/window functions/tests/distributed/over clause/empty OK 72ms
/window functions/tests/distributed/over clause/empty named window OK 69ms
/window functions/tests/distributed/over clause/invalid multiple windows OK 67ms
/window functions/tests/distributed/over clause/invalid window name OK 62ms
/window functions/tests/distributed/over clause/missing window spec OK 65ms
/window functions/tests/distributed/funcs OK 2s 180ms
/window functions/tests/distributed/funcs/dense rank OK 73ms
/window functions/tests/distributed/funcs/first value OK 150ms
/window functions/tests/distributed/funcs/first value with lead workaround OK 75ms
/window functions/tests/distributed/funcs/lag OK 224ms
/window functions/tests/distributed/funcs/lagInFrame OK 363ms
/window functions/tests/distributed/funcs/last value OK 302ms
/window functions/tests/distributed/funcs/last value with lag workaround OK 74ms
/window functions/tests/distributed/funcs/last value with no frame OK 71ms
/window functions/tests/distributed/funcs/lead OK 301ms
/window functions/tests/distributed/funcs/leadInFrame OK 376ms
/window functions/tests/distributed/funcs/rank OK 74ms
/window functions/tests/distributed/funcs/row number OK 84ms
/window functions/tests/distributed/aggregate funcs OK 5s 766ms
/window functions/tests/distributed/aggregate funcs/aggregate and window function in the same window OK 69ms
/window functions/tests/distributed/aggregate funcs/aggregate funcs over rows frame OK 4s 756ms
/window functions/tests/distributed/aggregate funcs/aggregate function recovers from nan OK 69ms
/window functions/tests/distributed/aggregate funcs/avgWeighted OK 208ms
/window functions/tests/distributed/aggregate funcs/avg with nulls OK 71ms
/window functions/tests/distributed/aggregate funcs/bit functions OK 81ms
/window functions/tests/distributed/aggregate funcs/nested aggregates OK 90ms
/window functions/tests/distributed/aggregate funcs/stddevpop OK 71ms
/window functions/tests/distributed/aggregate funcs/stddevsamp OK 68ms
/window functions/tests/distributed/aggregate funcs/sum OK 71ms
/window functions/tests/distributed/aggregate funcs/ungrouped aggregate over empty row set OK 65ms
/window functions/tests/distributed/aggregate funcs/var pop OK 68ms
/window functions/tests/distributed/aggregate funcs/var samp OK 68ms
/window functions/tests/distributed/time decayed funcs OK 1m 38s
/window functions/tests/distributed/time decayed funcs/exponentialTimeDecayedAvg OK 11s 719ms
/window functions/tests/distributed/time decayed funcs/exponentialTimeDecayedCount OK 10s 377ms
/window functions/tests/distributed/time decayed funcs/exponentialTimeDecayedMax OK 1m 4s
/window functions/tests/distributed/time decayed funcs/exponentialTimeDecayedSum OK 11s 716ms
/window functions/tests/distributed/errors OK 629ms
/window functions/tests/distributed/errors/error coma between partition by and order by clause OK 60ms
/window functions/tests/distributed/errors/error named window defined twice OK 63ms
/window functions/tests/distributed/errors/error order by another window function OK 59ms
/window functions/tests/distributed/errors/error select from window OK 64ms
/window functions/tests/distributed/errors/error using non window function OK 60ms
/window functions/tests/distributed/errors/error window function in alter delete where OK 58ms
/window functions/tests/distributed/errors/error window function in group by OK 62ms
/window functions/tests/distributed/errors/error window function in having OK 65ms
/window functions/tests/distributed/errors/error window function in join OK 70ms
/window functions/tests/distributed/errors/error window function in where OK 60ms
/window functions/tests/distributed/misc OK 1s 472ms
/window functions/tests/distributed/misc/count with empty over clause without start OK 67ms
/window functions/tests/distributed/misc/empty table OK 74ms
/window functions/tests/distributed/misc/exclude clause OK 64ms
/window functions/tests/distributed/misc/from subquery OK 93ms
/window functions/tests/distributed/misc/group by and multiple windows OK 94ms
/window functions/tests/distributed/misc/group by and one window OK 82ms
/window functions/tests/distributed/misc/groups frame OK 65ms
/window functions/tests/distributed/misc/in view OK 271ms
/window functions/tests/distributed/misc/query with order by and one window OK 76ms
/window functions/tests/distributed/misc/subquery expr preceding OK 83ms
/window functions/tests/distributed/misc/subquery multiple window functions OK 81ms
/window functions/tests/distributed/misc/subquery with multiple windows filtering OK 80ms
/window functions/tests/distributed/misc/window functions in select expression OK 75ms
/window functions/tests/distributed/misc/window functions in subquery OK 82ms
/window functions/tests/distributed/misc/windows with same partitioning but different ordering OK 96ms
/window functions/tests/distributed/misc/with union all OK 74ms
/window functions/tests/distributed/datatypes OK 809ms
/window functions/tests/distributed/datatypes/date OK 69ms
/window functions/tests/distributed/datatypes/datetime OK 68ms
/window functions/tests/distributed/datatypes/datetime64 OK 67ms
/window functions/tests/distributed/datatypes/decimal32 OK 66ms
/window functions/tests/distributed/datatypes/enum OK 69ms
/window functions/tests/distributed/datatypes/fixed string OK 64ms
/window functions/tests/distributed/datatypes/ipv4 OK 64ms
/window functions/tests/distributed/datatypes/ipv6 OK 67ms
/window functions/tests/distributed/datatypes/low cardinality OK 65ms
/window functions/tests/distributed/datatypes/map OK 68ms
/window functions/tests/distributed/datatypes/string OK 65ms
/window functions/tests/distributed/datatypes/uuid OK 68ms
/window functions/tests/distributed/non-negative derivative func OK 5s 436ms
/window functions/tests/distributed/non-negative derivative func/acceptance OK 684ms
/window functions/tests/distributed/non-negative derivative func/check intervals OK 572ms
/window functions/tests/distributed/non-negative derivative func/check negative result OK 68ms
/window functions/tests/distributed/non-negative derivative func/check one row per partition OK 75ms
/window functions/tests/distributed/non-negative derivative func/check over windows OK 1s 769ms
/window functions/tests/distributed/non-negative derivative func/division by tiny OK 143ms
/window functions/tests/distributed/non-negative derivative func/division by zero OK 66ms
/window functions/tests/distributed/non-negative derivative func/empty table OK 213ms
/window functions/tests/distributed/non-negative derivative func/null values OK 129ms
/window functions/tests/distributed/non-negative derivative func/valid metric types OK 917ms
/window functions/tests/distributed/non-negative derivative func/valid timestamp types OK 206ms
/window functions/tests/distributed/non-negative derivative func/wrong number of arguments or types OK 514ms
/window functions/tests/distributed/non-negative derivative func/zero interval OK 68ms

Generated by TestFlows Open-Source Test Framework v1.9.230315.1003122