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

DateDec 26, 2023 15:54
Duration8m 7s
Framework TestFlows 2.0.231130.1212236

Artifacts

Test artifacts can be found at https://altinity-build-artifacts.s3.amazonaws.com/index.html#/

Attributes

projectAltinity/ClickHouse
project.id159717931
packagehttps://s3.amazonaws.com/altinity-build-artifacts/23.8/57762a45dd8d7579a37ae9643654cde6896312dc/package_aarch64/clickhouse-common-static_23.8.8.21.altinitystable_arm64.deb
version23.8.8.21.altinitystable
user.nameEnmk
repositoryhttps://github.com/Altinity/clickhouse-regression
commit.hash09db6160aac30e37169797b73fac77b4cbca41c6
job.id7328846900
job.urlhttps://github.com/Altinity/ClickHouse/actions/runs/7328846900
archaarch64
stressFalse
localTrue
clickhouse_versionNone
clickhouse_binary_pathhttps://s3.amazonaws.com/altinity-build-artifacts/23.8/57762a45dd8d7579a37ae9643654cde6896312dc/package_aarch64/clickhouse-common-static_23.8.8.21.altinitystable_arm64.deb
collect_service_logsTrue

Summary

94%OK
2.2%Known
3.8%Fail

Statistics

Units OK Fail XFail
Modules
1
1
Suites
39
36
3
Features
39
36
3
Scenarios
456
434
2
20
Checks
256
252
4
Examples
1418
1318
76
24
Steps
7603
7459
144

Fails

Test NameResultMessage
/window functionsFail 8m 7s
AssertionError
Traceback (most recent call last):
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 227, in 
    regression()
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 223, in regression
    Feature(run=load("window_functions.tests.feature", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/feature.py", line 76, in feature
    Feature(run=load("window_functions.tests.aggregate_funcs", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/aggregate_funcs.py", line 454, in feature
    Scenario(run=scenario, flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/aggregate_funcs.py", line 96, in aggregate_funcs_over_rows_frame
    execute_query(
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/common.py", line 156, in execute_query
    assert that(
AssertionError: Oops! Assertion failed

The following assertion was not satisfied
  assert that(
      snapshot(
          "\n" + r.output.strip() + "\n",
          "tests." + current_cpu(),
          name=snapshot_name,
          encoder=str,
      )
  ), error()

Assertion values
  assert that(
         ^ is = SnapshotError(
    filename=/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/snapshots/common.py.tests.aarch64.snapshot
    name=_window_functions_tests_aggregate_funcs_aggregate_funcs_over_rows_frame_func__min_salary__
    snapshot_value="""

        func
        3500
        3900
        4200
        4500
        4800
        4800
        5000
        5200
        5200
        6000
    """,
    actual_value="""

        func
        6000
        5200
        5200
        5000
        4800
        4800
        4500
        4200
        3900
        3500
    """,
    diff="""
        --- /home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/snapshots/common.py.tests.aarch64.snapshot
        +++ 
        @@ -1,12 +1,12 @@

         func
        -3500
        -3900
        -4200
        -4500
        +6000
        +5200
        +5200
        +5000
         4800
         4800
        -5000
        -5200
        -5200
        -6000
        +4500
        +4200
        +3900
        +3500
    """)
      snapshot(
          "\n" + r.output.strip() + "\n",
          "tests." + current_cpu(),
          name=snapshot_name,
          encoder=str,
      )
  ), error()
  assert that(
  ^ is False
      snapshot(
          "\n" + r.output.strip() + "\n",
          "tests." + current_cpu(),
          name=snapshot_name,
          encoder=str,
      )
  ), error()

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

155\|                  with values() as that:
156\|                      assert that(
157\|                          snapshot(
158\|                              "\n" + r.output.strip() + "\n",
159\|                              "tests." + current_cpu(),
160\|                              name=snapshot_name,
161\|                              encoder=str,
162\|                          )
163\|>                     ), error()
164\|  
165\|  
166\|  @TestStep(Given)
/window functions/testsFail 5m 42s
AssertionError
Traceback (most recent call last):
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 227, in 
    regression()
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 223, in regression
    Feature(run=load("window_functions.tests.feature", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/feature.py", line 76, in feature
    Feature(run=load("window_functions.tests.aggregate_funcs", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/aggregate_funcs.py", line 454, in feature
    Scenario(run=scenario, flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/aggregate_funcs.py", line 96, in aggregate_funcs_over_rows_frame
    execute_query(
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/common.py", line 156, in execute_query
    assert that(
AssertionError: Oops! Assertion failed

The following assertion was not satisfied
  assert that(
      snapshot(
          "\n" + r.output.strip() + "\n",
          "tests." + current_cpu(),
          name=snapshot_name,
          encoder=str,
      )
  ), error()

Assertion values
  assert that(
         ^ is = SnapshotError(
    filename=/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/snapshots/common.py.tests.aarch64.snapshot
    name=_window_functions_tests_aggregate_funcs_aggregate_funcs_over_rows_frame_func__min_salary__
    snapshot_value="""

        func
        3500
        3900
        4200
        4500
        4800
        4800
        5000
        5200
        5200
        6000
    """,
    actual_value="""

        func
        6000
        5200
        5200
        5000
        4800
        4800
        4500
        4200
        3900
        3500
    """,
    diff="""
        --- /home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/snapshots/common.py.tests.aarch64.snapshot
        +++ 
        @@ -1,12 +1,12 @@

         func
        -3500
        -3900
        -4200
        -4500
        +6000
        +5200
        +5200
        +5000
         4800
         4800
        -5000
        -5200
        -5200
        -6000
        +4500
        +4200
        +3900
        +3500
    """)
      snapshot(
          "\n" + r.output.strip() + "\n",
          "tests." + current_cpu(),
          name=snapshot_name,
          encoder=str,
      )
  ), error()
  assert that(
  ^ is False
      snapshot(
          "\n" + r.output.strip() + "\n",
          "tests." + current_cpu(),
          name=snapshot_name,
          encoder=str,
      )
  ), error()

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

155\|                  with values() as that:
156\|                      assert that(
157\|                          snapshot(
158\|                              "\n" + r.output.strip() + "\n",
159\|                              "tests." + current_cpu(),
160\|                              name=snapshot_name,
161\|                              encoder=str,
162\|                          )
163\|>                     ), error()
164\|  
165\|  
166\|  @TestStep(Given)
/window functions/tests/non distributedFail 2m 42s
AssertionError
Traceback (most recent call last):
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 227, in 
    regression()
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 223, in regression
    Feature(run=load("window_functions.tests.feature", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/feature.py", line 76, in feature
    Feature(run=load("window_functions.tests.aggregate_funcs", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/aggregate_funcs.py", line 454, in feature
    Scenario(run=scenario, flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/aggregate_funcs.py", line 96, in aggregate_funcs_over_rows_frame
    execute_query(
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/common.py", line 156, in execute_query
    assert that(
AssertionError: Oops! Assertion failed

The following assertion was not satisfied
  assert that(
      snapshot(
          "\n" + r.output.strip() + "\n",
          "tests." + current_cpu(),
          name=snapshot_name,
          encoder=str,
      )
  ), error()

Assertion values
  assert that(
         ^ is = SnapshotError(
    filename=/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/snapshots/common.py.tests.aarch64.snapshot
    name=_window_functions_tests_aggregate_funcs_aggregate_funcs_over_rows_frame_func__min_salary__
    snapshot_value="""

        func
        3500
        3900
        4200
        4500
        4800
        4800
        5000
        5200
        5200
        6000
    """,
    actual_value="""

        func
        6000
        5200
        5200
        5000
        4800
        4800
        4500
        4200
        3900
        3500
    """,
    diff="""
        --- /home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/snapshots/common.py.tests.aarch64.snapshot
        +++ 
        @@ -1,12 +1,12 @@

         func
        -3500
        -3900
        -4200
        -4500
        +6000
        +5200
        +5200
        +5000
         4800
         4800
        -5000
        -5200
        -5200
        -6000
        +4500
        +4200
        +3900
        +3500
    """)
      snapshot(
          "\n" + r.output.strip() + "\n",
          "tests." + current_cpu(),
          name=snapshot_name,
          encoder=str,
      )
  ), error()
  assert that(
  ^ is False
      snapshot(
          "\n" + r.output.strip() + "\n",
          "tests." + current_cpu(),
          name=snapshot_name,
          encoder=str,
      )
  ), error()

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

155\|                  with values() as that:
156\|                      assert that(
157\|                          snapshot(
158\|                              "\n" + r.output.strip() + "\n",
159\|                              "tests." + current_cpu(),
160\|                              name=snapshot_name,
161\|                              encoder=str,
162\|                          )
163\|>                     ), error()
164\|  
165\|  
166\|  @TestStep(Given)
/window functions/tests/non distributed/aggregate funcsFail 8s 186ms
AssertionError
Traceback (most recent call last):
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 227, in 
    regression()
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 223, in regression
    Feature(run=load("window_functions.tests.feature", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/feature.py", line 76, in feature
    Feature(run=load("window_functions.tests.aggregate_funcs", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/aggregate_funcs.py", line 454, in feature
    Scenario(run=scenario, flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/aggregate_funcs.py", line 96, in aggregate_funcs_over_rows_frame
    execute_query(
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/common.py", line 156, in execute_query
    assert that(
AssertionError: Oops! Assertion failed

The following assertion was not satisfied
  assert that(
      snapshot(
          "\n" + r.output.strip() + "\n",
          "tests." + current_cpu(),
          name=snapshot_name,
          encoder=str,
      )
  ), error()

Assertion values
  assert that(
         ^ is = SnapshotError(
    filename=/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/snapshots/common.py.tests.aarch64.snapshot
    name=_window_functions_tests_aggregate_funcs_aggregate_funcs_over_rows_frame_func__min_salary__
    snapshot_value="""

        func
        3500
        3900
        4200
        4500
        4800
        4800
        5000
        5200
        5200
        6000
    """,
    actual_value="""

        func
        6000
        5200
        5200
        5000
        4800
        4800
        4500
        4200
        3900
        3500
    """,
    diff="""
        --- /home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/snapshots/common.py.tests.aarch64.snapshot
        +++ 
        @@ -1,12 +1,12 @@

         func
        -3500
        -3900
        -4200
        -4500
        +6000
        +5200
        +5200
        +5000
         4800
         4800
        -5000
        -5200
        -5200
        -6000
        +4500
        +4200
        +3900
        +3500
    """)
      snapshot(
          "\n" + r.output.strip() + "\n",
          "tests." + current_cpu(),
          name=snapshot_name,
          encoder=str,
      )
  ), error()
  assert that(
  ^ is False
      snapshot(
          "\n" + r.output.strip() + "\n",
          "tests." + current_cpu(),
          name=snapshot_name,
          encoder=str,
      )
  ), error()

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

155\|                  with values() as that:
156\|                      assert that(
157\|                          snapshot(
158\|                              "\n" + r.output.strip() + "\n",
159\|                              "tests." + current_cpu(),
160\|                              name=snapshot_name,
161\|                              encoder=str,
162\|                          )
163\|>                     ), error()
164\|  
165\|  
166\|  @TestStep(Given)
/window functions/tests/non distributed/aggregate funcs/aggregate funcs over rows frameFail 6s 689ms
AssertionError
Traceback (most recent call last):
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 227, in 
    regression()
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 223, in regression
    Feature(run=load("window_functions.tests.feature", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/feature.py", line 76, in feature
    Feature(run=load("window_functions.tests.aggregate_funcs", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/aggregate_funcs.py", line 454, in feature
    Scenario(run=scenario, flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/aggregate_funcs.py", line 96, in aggregate_funcs_over_rows_frame
    execute_query(
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/common.py", line 156, in execute_query
    assert that(
AssertionError: Oops! Assertion failed

The following assertion was not satisfied
  assert that(
      snapshot(
          "\n" + r.output.strip() + "\n",
          "tests." + current_cpu(),
          name=snapshot_name,
          encoder=str,
      )
  ), error()

Assertion values
  assert that(
         ^ is = SnapshotError(
    filename=/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/snapshots/common.py.tests.aarch64.snapshot
    name=_window_functions_tests_aggregate_funcs_aggregate_funcs_over_rows_frame_func__min_salary__
    snapshot_value="""

        func
        3500
        3900
        4200
        4500
        4800
        4800
        5000
        5200
        5200
        6000
    """,
    actual_value="""

        func
        6000
        5200
        5200
        5000
        4800
        4800
        4500
        4200
        3900
        3500
    """,
    diff="""
        --- /home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/snapshots/common.py.tests.aarch64.snapshot
        +++ 
        @@ -1,12 +1,12 @@

         func
        -3500
        -3900
        -4200
        -4500
        +6000
        +5200
        +5200
        +5000
         4800
         4800
        -5000
        -5200
        -5200
        -6000
        +4500
        +4200
        +3900
        +3500
    """)
      snapshot(
          "\n" + r.output.strip() + "\n",
          "tests." + current_cpu(),
          name=snapshot_name,
          encoder=str,
      )
  ), error()
  assert that(
  ^ is False
      snapshot(
          "\n" + r.output.strip() + "\n",
          "tests." + current_cpu(),
          name=snapshot_name,
          encoder=str,
      )
  ), error()

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

155\|                  with values() as that:
156\|                      assert that(
157\|                          snapshot(
158\|                              "\n" + r.output.strip() + "\n",
159\|                              "tests." + current_cpu(),
160\|                              name=snapshot_name,
161\|                              encoder=str,
162\|                          )
163\|>                     ), error()
164\|  
165\|  
166\|  @TestStep(Given)
/window functions/tests/distributedFail 3m 0s
AssertionError
Traceback (most recent call last):
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 227, in 
    regression()
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 223, in regression
    Feature(run=load("window_functions.tests.feature", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/feature.py", line 76, in feature
    Feature(run=load("window_functions.tests.aggregate_funcs", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/aggregate_funcs.py", line 454, in feature
    Scenario(run=scenario, flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/aggregate_funcs.py", line 96, in aggregate_funcs_over_rows_frame
    execute_query(
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/common.py", line 156, in execute_query
    assert that(
AssertionError: Oops! Assertion failed

The following assertion was not satisfied
  assert that(
      snapshot(
          "\n" + r.output.strip() + "\n",
          "tests." + current_cpu(),
          name=snapshot_name,
          encoder=str,
      )
  ), error()

Assertion values
  assert that(
         ^ is = SnapshotError(
    filename=/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/snapshots/common.py.tests.aarch64.snapshot
    name=_window_functions_tests_aggregate_funcs_aggregate_funcs_over_rows_frame_func__min_salary__
    snapshot_value="""

        func
        3500
        3900
        4200
        4500
        4800
        4800
        5000
        5200
        5200
        6000
    """,
    actual_value="""

        func
        6000
        5200
        5200
        5000
        4800
        4800
        4500
        4200
        3900
        3500
    """,
    diff="""
        --- /home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/snapshots/common.py.tests.aarch64.snapshot
        +++ 
        @@ -1,12 +1,12 @@

         func
        -3500
        -3900
        -4200
        -4500
        +6000
        +5200
        +5200
        +5000
         4800
         4800
        -5000
        -5200
        -5200
        -6000
        +4500
        +4200
        +3900
        +3500
    """)
      snapshot(
          "\n" + r.output.strip() + "\n",
          "tests." + current_cpu(),
          name=snapshot_name,
          encoder=str,
      )
  ), error()
  assert that(
  ^ is False
      snapshot(
          "\n" + r.output.strip() + "\n",
          "tests." + current_cpu(),
          name=snapshot_name,
          encoder=str,
      )
  ), error()

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

155\|                  with values() as that:
156\|                      assert that(
157\|                          snapshot(
158\|                              "\n" + r.output.strip() + "\n",
159\|                              "tests." + current_cpu(),
160\|                              name=snapshot_name,
161\|                              encoder=str,
162\|                          )
163\|>                     ), error()
164\|  
165\|  
166\|  @TestStep(Given)
/window functions/tests/distributed/aggregate funcsFail 8s 903ms
AssertionError
Traceback (most recent call last):
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 227, in 
    regression()
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 223, in regression
    Feature(run=load("window_functions.tests.feature", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/feature.py", line 76, in feature
    Feature(run=load("window_functions.tests.aggregate_funcs", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/aggregate_funcs.py", line 454, in feature
    Scenario(run=scenario, flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/aggregate_funcs.py", line 96, in aggregate_funcs_over_rows_frame
    execute_query(
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/common.py", line 156, in execute_query
    assert that(
AssertionError: Oops! Assertion failed

The following assertion was not satisfied
  assert that(
      snapshot(
          "\n" + r.output.strip() + "\n",
          "tests." + current_cpu(),
          name=snapshot_name,
          encoder=str,
      )
  ), error()

Assertion values
  assert that(
         ^ is = SnapshotError(
    filename=/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/snapshots/common.py.tests.aarch64.snapshot
    name=_window_functions_tests_aggregate_funcs_aggregate_funcs_over_rows_frame_func__min_salary__
    snapshot_value="""

        func
        3500
        3900
        4200
        4500
        4800
        4800
        5000
        5200
        5200
        6000
    """,
    actual_value="""

        func
        6000
        5200
        5200
        5000
        4800
        4800
        4500
        4200
        3900
        3500
    """,
    diff="""
        --- /home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/snapshots/common.py.tests.aarch64.snapshot
        +++ 
        @@ -1,12 +1,12 @@

         func
        -3500
        -3900
        -4200
        -4500
        +6000
        +5200
        +5200
        +5000
         4800
         4800
        -5000
        -5200
        -5200
        -6000
        +4500
        +4200
        +3900
        +3500
    """)
      snapshot(
          "\n" + r.output.strip() + "\n",
          "tests." + current_cpu(),
          name=snapshot_name,
          encoder=str,
      )
  ), error()
  assert that(
  ^ is False
      snapshot(
          "\n" + r.output.strip() + "\n",
          "tests." + current_cpu(),
          name=snapshot_name,
          encoder=str,
      )
  ), error()

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

155\|                  with values() as that:
156\|                      assert that(
157\|                          snapshot(
158\|                              "\n" + r.output.strip() + "\n",
159\|                              "tests." + current_cpu(),
160\|                              name=snapshot_name,
161\|                              encoder=str,
162\|                          )
163\|>                     ), error()
164\|  
165\|  
166\|  @TestStep(Given)
/window functions/tests/distributed/aggregate funcs/aggregate funcs over rows frameFail 7s 423ms
AssertionError
Traceback (most recent call last):
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 227, in 
    regression()
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 223, in regression
    Feature(run=load("window_functions.tests.feature", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/feature.py", line 76, in feature
    Feature(run=load("window_functions.tests.aggregate_funcs", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/aggregate_funcs.py", line 454, in feature
    Scenario(run=scenario, flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/aggregate_funcs.py", line 96, in aggregate_funcs_over_rows_frame
    execute_query(
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/common.py", line 156, in execute_query
    assert that(
AssertionError: Oops! Assertion failed

The following assertion was not satisfied
  assert that(
      snapshot(
          "\n" + r.output.strip() + "\n",
          "tests." + current_cpu(),
          name=snapshot_name,
          encoder=str,
      )
  ), error()

Assertion values
  assert that(
         ^ is = SnapshotError(
    filename=/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/snapshots/common.py.tests.aarch64.snapshot
    name=_window_functions_tests_aggregate_funcs_aggregate_funcs_over_rows_frame_func__min_salary__
    snapshot_value="""

        func
        3500
        3900
        4200
        4500
        4800
        4800
        5000
        5200
        5200
        6000
    """,
    actual_value="""

        func
        6000
        5200
        5200
        5000
        4800
        4800
        4500
        4200
        3900
        3500
    """,
    diff="""
        --- /home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/snapshots/common.py.tests.aarch64.snapshot
        +++ 
        @@ -1,12 +1,12 @@

         func
        -3500
        -3900
        -4200
        -4500
        +6000
        +5200
        +5200
        +5000
         4800
         4800
        -5000
        -5200
        -5200
        -6000
        +4500
        +4200
        +3900
        +3500
    """)
      snapshot(
          "\n" + r.output.strip() + "\n",
          "tests." + current_cpu(),
          name=snapshot_name,
          encoder=str,
      )
  ), error()
  assert that(
  ^ is False
      snapshot(
          "\n" + r.output.strip() + "\n",
          "tests." + current_cpu(),
          name=snapshot_name,
          encoder=str,
      )
  ), error()

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

155\|                  with values() as that:
156\|                      assert that(
157\|                          snapshot(
158\|                              "\n" + r.output.strip() + "\n",
159\|                              "tests." + current_cpu(),
160\|                              name=snapshot_name,
161\|                              encoder=str,
162\|                          )
163\|>                     ), error()
164\|  
165\|  
166\|  @TestStep(Given)

Known Fails

Test NameResultMessage
/window functions/tests/non distributed/frame clause/range frame/between expr following and current row zero special caseXFail 137ms
known bug
AssertionError
Traceback (most recent call last):
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 227, in 
    regression()
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 223, in regression
    Feature(run=load("window_functions.tests.feature", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/feature.py", line 72, in feature
    Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/frame_clause.py", line 68, in feature
    Feature(run=load("window_functions.tests.range_frame", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_frame.py", line 1745, in feature
    Scenario(run=scenario, flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_frame.py", line 1353, in between_expr_following_and_current_row_zero_special_case
    execute_query(
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/common.py", line 140, in execute_query
    r = current().context.node.query(
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 802, 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.8.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)) ORDER BY number FORMAT TabSeparatedWithNames
)

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

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

794\|                  assert message in r.output, error(r.output)
795\|  
796\|          if not ignore_exception:
797\|              if message is None or "Exception:" not in message:
798\|                  with Then("check if output has exception") if steps else NullStep():
799\|                      if "Exception:" in r.output:
800\|                          if raise_on_exception:
801\|                              raise QueryRuntimeException(r.output)
802\|>                         assert False, error(r.output)
803\|  
804\|          return r
805\|
/window functions/tests/non distributed/frame clause/range frame/between expr following and expr following without order by errorXFail 106ms
invalid error message
AssertionError
Traceback (most recent call last):
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 227, in 
    regression()
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 223, in regression
    Feature(run=load("window_functions.tests.feature", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/feature.py", line 72, in feature
    Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/frame_clause.py", line 68, in feature
    Feature(run=load("window_functions.tests.range_frame", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_frame.py", line 1745, in feature
    Scenario(run=scenario, flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_frame.py", line 1217, in between_expr_following_and_expr_following_without_order_by_error
    self.context.node.query(
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 794, 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.8.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.8.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/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py', line 794 in 'query'

786\|          if exitcode is not None:
787\|              with Then(f"exitcode should be {exitcode}") if steps else NullStep():
788\|                  assert r.exitcode == exitcode, error(r.output)
789\|  
790\|          if message is not None:
791\|              with Then(
792\|                  f"output should contain message", description=message
793\|              ) if steps else NullStep():
794\|>                 assert message in r.output, error(r.output)
795\|  
796\|          if not ignore_exception:
797\|              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 110ms
known bug
AssertionError
Traceback (most recent call last):
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 227, in 
    regression()
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 223, in regression
    Feature(run=load("window_functions.tests.feature", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/feature.py", line 72, in feature
    Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/frame_clause.py", line 68, in feature
    Feature(run=load("window_functions.tests.range_frame", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_frame.py", line 1745, in feature
    Scenario(run=scenario, flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_frame.py", line 1422, in between_expr_following_and_expr_preceding_with_order_by_zero_special_case
    execute_query(
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/common.py", line 140, in execute_query
    r = current().context.node.query(
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 802, 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.8.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)) ORDER BY number FORMAT TabSeparatedWithNames
)

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

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

794\|                  assert message in r.output, error(r.output)
795\|  
796\|          if not ignore_exception:
797\|              if message is None or "Exception:" not in message:
798\|                  with Then("check if output has exception") if steps else NullStep():
799\|                      if "Exception:" in r.output:
800\|                          if raise_on_exception:
801\|                              raise QueryRuntimeException(r.output)
802\|>                         assert False, error(r.output)
803\|  
804\|          return r
805\|
/window functions/tests/non distributed/frame clause/range frame/between expr following and expr preceding without order by errorXFail 104ms
invalid error message
AssertionError
Traceback (most recent call last):
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 227, in 
    regression()
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 223, in regression
    Feature(run=load("window_functions.tests.feature", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/feature.py", line 72, in feature
    Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/frame_clause.py", line 68, in feature
    Feature(run=load("window_functions.tests.range_frame", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_frame.py", line 1745, in feature
    Scenario(run=scenario, flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_frame.py", line 1234, in between_expr_following_and_expr_preceding_without_order_by_error
    self.context.node.query(
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 794, 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.8.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.8.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/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py', line 794 in 'query'

786\|          if exitcode is not None:
787\|              with Then(f"exitcode should be {exitcode}") if steps else NullStep():
788\|                  assert r.exitcode == exitcode, error(r.output)
789\|  
790\|          if message is not None:
791\|              with Then(
792\|                  f"output should contain message", description=message
793\|              ) if steps else NullStep():
794\|>                 assert message in r.output, error(r.output)
795\|  
796\|          if not ignore_exception:
797\|              if message is None or "Exception:" not in message:
/window functions/tests/non distributed/frame clause/range frame/order by decimalXFail 117ms
Exception: The RANGE OFFSET frame for 'DB::ColumnDecimal >' ORDER BY column is not implemented
AssertionError
Traceback (most recent call last):
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 227, in 
    regression()
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 223, in regression
    Feature(run=load("window_functions.tests.feature", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/feature.py", line 72, in feature
    Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/frame_clause.py", line 68, in feature
    Feature(run=load("window_functions.tests.range_frame", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_frame.py", line 1745, in feature
    Scenario(run=scenario, flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_frame.py", line 1658, in order_by_decimal
    execute_query(
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/common.py", line 140, in execute_query
    r = current().context.node.query(
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 802, 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.8.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)
        ORDER BY id
         FORMAT TabSeparatedWithNames
)

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

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

794\|                  assert message in r.output, error(r.output)
795\|  
796\|          if not ignore_exception:
797\|              if message is None or "Exception:" not in message:
798\|                  with Then("check if output has exception") if steps else NullStep():
799\|                      if "Exception:" in r.output:
800\|                          if raise_on_exception:
801\|                              raise QueryRuntimeException(r.output)
802\|>                         assert False, error(r.output)
803\|  
804\|          return r
805\|
/window functions/tests/non distributed/frame clause/range frame/with nullsXFail 135ms
DB::Exception: The RANGE OFFSET frame for 'DB::ColumnNullable' ORDER BY column is not implemented
AssertionError
Traceback (most recent call last):
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 227, in 
    regression()
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 223, in regression
    Feature(run=load("window_functions.tests.feature", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/feature.py", line 72, in feature
    Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/frame_clause.py", line 68, in feature
    Feature(run=load("window_functions.tests.range_frame", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_frame.py", line 1745, in feature
    Scenario(run=scenario, flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_frame.py", line 1719, in with_nulls
    execute_query(
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/common.py", line 140, in execute_query
    r = current().context.node.query(
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 802, 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.8.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)
        ORDER BY x, y
         FORMAT TabSeparatedWithNames
)

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

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

794\|                  assert message in r.output, error(r.output)
795\|  
796\|          if not ignore_exception:
797\|              if message is None or "Exception:" not in message:
798\|                  with Then("check if output has exception") if steps else NullStep():
799\|                      if "Exception:" in r.output:
800\|                          if raise_on_exception:
801\|                              raise QueryRuntimeException(r.output)
802\|>                         assert False, error(r.output)
803\|  
804\|          return r
805\|
/window functions/tests/non distributed/frame clause/range overflow/negative overflow with Int16XFail 106ms
exception on conversion
AssertionError
Traceback (most recent call last):
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 227, in 
    regression()
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 223, in regression
    Feature(run=load("window_functions.tests.feature", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/feature.py", line 72, in feature
    Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/frame_clause.py", line 69, in feature
    Feature(run=load("window_functions.tests.range_overflow", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_overflow.py", line 145, in feature
    Scenario(run=scenario, flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_overflow.py", line 42, in negative_overflow_with_Int16
    execute_query(
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/common.py", line 140, in execute_query
    r = current().context.node.query(
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 802, 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.8.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)) order by x
         FORMAT TabSeparatedWithNames
)

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

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

794\|                  assert message in r.output, error(r.output)
795\|  
796\|          if not ignore_exception:
797\|              if message is None or "Exception:" not in message:
798\|                  with Then("check if output has exception") if steps else NullStep():
799\|                      if "Exception:" in r.output:
800\|                          if raise_on_exception:
801\|                              raise QueryRuntimeException(r.output)
802\|>                         assert False, error(r.output)
803\|  
804\|          return r
805\|
/window functions/tests/non distributed/frame clause/range overflow/positive overflow with Int16XFail 127ms
exception on conversion
AssertionError
Traceback (most recent call last):
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 227, in 
    regression()
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 223, in regression
    Feature(run=load("window_functions.tests.feature", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/feature.py", line 72, in feature
    Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/frame_clause.py", line 69, in feature
    Feature(run=load("window_functions.tests.range_overflow", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_overflow.py", line 145, in feature
    Scenario(run=scenario, flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_overflow.py", line 20, in positive_overflow_with_Int16
    execute_query(
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/common.py", line 140, in execute_query
    r = current().context.node.query(
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 802, 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.8.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) order by x
         FORMAT TabSeparatedWithNames
)

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

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

794\|                  assert message in r.output, error(r.output)
795\|  
796\|          if not ignore_exception:
797\|              if message is None or "Exception:" not in message:
798\|                  with Then("check if output has exception") if steps else NullStep():
799\|                      if "Exception:" in r.output:
800\|                          if raise_on_exception:
801\|                              raise QueryRuntimeException(r.output)
802\|>                         assert False, error(r.output)
803\|  
804\|          return r
805\|
/window functions/tests/non distributed/frame clause/range errors/error negative following offsetXFail 109ms
https://github.com/ClickHouse/ClickHouse/issues/22442
AssertionError
Traceback (most recent call last):
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 227, in 
    regression()
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 223, in regression
    Feature(run=load("window_functions.tests.feature", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/feature.py", line 72, in feature
    Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/frame_clause.py", line 71, in feature
    Feature(run=load("window_functions.tests.range_errors", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_errors.py", line 114, in feature
    Scenario(run=scenario, flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_errors.py", line 105, in error_negative_following_offset
    r = current().context.node.query(sql, exitcode=exitcode, message=message)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 794, 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.8.8):
Code: 36. DB::Exception: Received from localhost:9000. DB::Exception: Frame end offset for 'RANGE' frame must be a nonnegative 32-bit integer, '-2' of type 'Int64' given. (BAD_ARGUMENTS)
(query: select max(enroll_date) over (order by salary range between 1 preceding and -2 following) AS max, salary, enroll_date from empsalary
)

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.8.8):\nCode: 36. DB::Exception: Received from localhost:9000. DB::Exception: Frame end offset for 'RANGE' frame must be a nonnegative 32-bit integer, '-2' of type 'Int64' given. (BAD_ARGUMENTS)\n(query: select max(enroll_date) over (order by salary range between 1 preceding and -2 following) AS max, salary, enroll_date from empsalary\n)"
  assert message in r.output, error(r.output)
                 ^ is = False
  assert message in r.output, error(r.output)
  ^ is False

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

786\|          if exitcode is not None:
787\|              with Then(f"exitcode should be {exitcode}") if steps else NullStep():
788\|                  assert r.exitcode == exitcode, error(r.output)
789\|  
790\|          if message is not None:
791\|              with Then(
792\|                  f"output should contain message", description=message
793\|              ) if steps else NullStep():
794\|>                 assert message in r.output, error(r.output)
795\|  
796\|          if not ignore_exception:
797\|              if message is None or "Exception:" not in message:
/window functions/tests/non distributed/frame clause/range errors/error negative preceding offsetXFail 104ms
https://github.com/ClickHouse/ClickHouse/issues/22442
AssertionError
Traceback (most recent call last):
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 227, in 
    regression()
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 223, in regression
    Feature(run=load("window_functions.tests.feature", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/feature.py", line 72, in feature
    Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/frame_clause.py", line 71, in feature
    Feature(run=load("window_functions.tests.range_errors", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_errors.py", line 114, in feature
    Scenario(run=scenario, flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_errors.py", line 89, in error_negative_preceding_offset
    r = current().context.node.query(sql, exitcode=exitcode, message=message)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 794, 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.8.8):
Code: 36. DB::Exception: Received from localhost:9000. DB::Exception: Frame start offset for 'RANGE' frame must be a nonnegative 32-bit integer, '-1' of type 'Int64' given. (BAD_ARGUMENTS)
(query: select max(enroll_date) over (order by salary range between -1 preceding and 2 following) AS max, salary, enroll_date from empsalary
)

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.8.8):\nCode: 36. DB::Exception: Received from localhost:9000. DB::Exception: Frame start offset for 'RANGE' frame must be a nonnegative 32-bit integer, '-1' of type 'Int64' given. (BAD_ARGUMENTS)\n(query: select max(enroll_date) over (order by salary range between -1 preceding and 2 following) AS max, salary, enroll_date from empsalary\n)"
  assert message in r.output, error(r.output)
                 ^ is = False
  assert message in r.output, error(r.output)
  ^ is False

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

786\|          if exitcode is not None:
787\|              with Then(f"exitcode should be {exitcode}") if steps else NullStep():
788\|                  assert r.exitcode == exitcode, error(r.output)
789\|  
790\|          if message is not None:
791\|              with Then(
792\|                  f"output should contain message", description=message
793\|              ) if steps else NullStep():
794\|>                 assert message in r.output, error(r.output)
795\|  
796\|          if not ignore_exception:
797\|              if message is None or "Exception:" not in message:
/window functions/tests/distributed/frame clause/range frame/between expr following and current row zero special caseXFail 105ms
known bug
AssertionError
Traceback (most recent call last):
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 227, in 
    regression()
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 223, in regression
    Feature(run=load("window_functions.tests.feature", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/feature.py", line 72, in feature
    Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/frame_clause.py", line 68, in feature
    Feature(run=load("window_functions.tests.range_frame", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_frame.py", line 1745, in feature
    Scenario(run=scenario, flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_frame.py", line 1353, in between_expr_following_and_current_row_zero_special_case
    execute_query(
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/common.py", line 140, in execute_query
    r = current().context.node.query(
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 802, 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.8.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)) ORDER BY number FORMAT TabSeparatedWithNames
)

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

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

794\|                  assert message in r.output, error(r.output)
795\|  
796\|          if not ignore_exception:
797\|              if message is None or "Exception:" not in message:
798\|                  with Then("check if output has exception") if steps else NullStep():
799\|                      if "Exception:" in r.output:
800\|                          if raise_on_exception:
801\|                              raise QueryRuntimeException(r.output)
802\|>                         assert False, error(r.output)
803\|  
804\|          return r
805\|
/window functions/tests/distributed/frame clause/range frame/between expr following and expr following without order by errorXFail 107ms
invalid error message
AssertionError
Traceback (most recent call last):
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 227, in 
    regression()
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 223, in regression
    Feature(run=load("window_functions.tests.feature", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/feature.py", line 72, in feature
    Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/frame_clause.py", line 68, in feature
    Feature(run=load("window_functions.tests.range_frame", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_frame.py", line 1745, in feature
    Scenario(run=scenario, flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_frame.py", line 1217, in between_expr_following_and_expr_following_without_order_by_error
    self.context.node.query(
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 794, 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.8.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.8.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/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py', line 794 in 'query'

786\|          if exitcode is not None:
787\|              with Then(f"exitcode should be {exitcode}") if steps else NullStep():
788\|                  assert r.exitcode == exitcode, error(r.output)
789\|  
790\|          if message is not None:
791\|              with Then(
792\|                  f"output should contain message", description=message
793\|              ) if steps else NullStep():
794\|>                 assert message in r.output, error(r.output)
795\|  
796\|          if not ignore_exception:
797\|              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 103ms
known bug
AssertionError
Traceback (most recent call last):
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 227, in 
    regression()
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 223, in regression
    Feature(run=load("window_functions.tests.feature", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/feature.py", line 72, in feature
    Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/frame_clause.py", line 68, in feature
    Feature(run=load("window_functions.tests.range_frame", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_frame.py", line 1745, in feature
    Scenario(run=scenario, flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_frame.py", line 1422, in between_expr_following_and_expr_preceding_with_order_by_zero_special_case
    execute_query(
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/common.py", line 140, in execute_query
    r = current().context.node.query(
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 802, 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.8.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)) ORDER BY number FORMAT TabSeparatedWithNames
)

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

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

794\|                  assert message in r.output, error(r.output)
795\|  
796\|          if not ignore_exception:
797\|              if message is None or "Exception:" not in message:
798\|                  with Then("check if output has exception") if steps else NullStep():
799\|                      if "Exception:" in r.output:
800\|                          if raise_on_exception:
801\|                              raise QueryRuntimeException(r.output)
802\|>                         assert False, error(r.output)
803\|  
804\|          return r
805\|
/window functions/tests/distributed/frame clause/range frame/between expr following and expr preceding without order by errorXFail 105ms
invalid error message
AssertionError
Traceback (most recent call last):
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 227, in 
    regression()
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 223, in regression
    Feature(run=load("window_functions.tests.feature", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/feature.py", line 72, in feature
    Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/frame_clause.py", line 68, in feature
    Feature(run=load("window_functions.tests.range_frame", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_frame.py", line 1745, in feature
    Scenario(run=scenario, flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_frame.py", line 1234, in between_expr_following_and_expr_preceding_without_order_by_error
    self.context.node.query(
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 794, 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.8.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.8.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/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py', line 794 in 'query'

786\|          if exitcode is not None:
787\|              with Then(f"exitcode should be {exitcode}") if steps else NullStep():
788\|                  assert r.exitcode == exitcode, error(r.output)
789\|  
790\|          if message is not None:
791\|              with Then(
792\|                  f"output should contain message", description=message
793\|              ) if steps else NullStep():
794\|>                 assert message in r.output, error(r.output)
795\|  
796\|          if not ignore_exception:
797\|              if message is None or "Exception:" not in message:
/window functions/tests/distributed/frame clause/range frame/order by decimalXFail 116ms
Exception: The RANGE OFFSET frame for 'DB::ColumnDecimal >' ORDER BY column is not implemented
AssertionError
Traceback (most recent call last):
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 227, in 
    regression()
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 223, in regression
    Feature(run=load("window_functions.tests.feature", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/feature.py", line 72, in feature
    Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/frame_clause.py", line 68, in feature
    Feature(run=load("window_functions.tests.range_frame", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_frame.py", line 1745, in feature
    Scenario(run=scenario, flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_frame.py", line 1658, in order_by_decimal
    execute_query(
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/common.py", line 140, in execute_query
    r = current().context.node.query(
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 802, 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.8.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)
        ORDER BY id
         FORMAT TabSeparatedWithNames
)

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

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

794\|                  assert message in r.output, error(r.output)
795\|  
796\|          if not ignore_exception:
797\|              if message is None or "Exception:" not in message:
798\|                  with Then("check if output has exception") if steps else NullStep():
799\|                      if "Exception:" in r.output:
800\|                          if raise_on_exception:
801\|                              raise QueryRuntimeException(r.output)
802\|>                         assert False, error(r.output)
803\|  
804\|          return r
805\|
/window functions/tests/distributed/frame clause/range frame/with nullsXFail 141ms
DB::Exception: The RANGE OFFSET frame for 'DB::ColumnNullable' ORDER BY column is not implemented
AssertionError
Traceback (most recent call last):
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 227, in 
    regression()
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 223, in regression
    Feature(run=load("window_functions.tests.feature", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/feature.py", line 72, in feature
    Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/frame_clause.py", line 68, in feature
    Feature(run=load("window_functions.tests.range_frame", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_frame.py", line 1745, in feature
    Scenario(run=scenario, flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_frame.py", line 1719, in with_nulls
    execute_query(
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/common.py", line 140, in execute_query
    r = current().context.node.query(
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 802, 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.8.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)
        ORDER BY x, y
         FORMAT TabSeparatedWithNames
)

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

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

794\|                  assert message in r.output, error(r.output)
795\|  
796\|          if not ignore_exception:
797\|              if message is None or "Exception:" not in message:
798\|                  with Then("check if output has exception") if steps else NullStep():
799\|                      if "Exception:" in r.output:
800\|                          if raise_on_exception:
801\|                              raise QueryRuntimeException(r.output)
802\|>                         assert False, error(r.output)
803\|  
804\|          return r
805\|
/window functions/tests/distributed/frame clause/range overflow/negative overflow with Int16XFail 122ms
exception on conversion
AssertionError
Traceback (most recent call last):
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 227, in 
    regression()
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 223, in regression
    Feature(run=load("window_functions.tests.feature", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/feature.py", line 72, in feature
    Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/frame_clause.py", line 69, in feature
    Feature(run=load("window_functions.tests.range_overflow", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_overflow.py", line 145, in feature
    Scenario(run=scenario, flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_overflow.py", line 42, in negative_overflow_with_Int16
    execute_query(
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/common.py", line 140, in execute_query
    r = current().context.node.query(
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 802, 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.8.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)) order by x
         FORMAT TabSeparatedWithNames
)

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

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

794\|                  assert message in r.output, error(r.output)
795\|  
796\|          if not ignore_exception:
797\|              if message is None or "Exception:" not in message:
798\|                  with Then("check if output has exception") if steps else NullStep():
799\|                      if "Exception:" in r.output:
800\|                          if raise_on_exception:
801\|                              raise QueryRuntimeException(r.output)
802\|>                         assert False, error(r.output)
803\|  
804\|          return r
805\|
/window functions/tests/distributed/frame clause/range overflow/positive overflow with Int16XFail 116ms
exception on conversion
AssertionError
Traceback (most recent call last):
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 227, in 
    regression()
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 223, in regression
    Feature(run=load("window_functions.tests.feature", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/feature.py", line 72, in feature
    Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/frame_clause.py", line 69, in feature
    Feature(run=load("window_functions.tests.range_overflow", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_overflow.py", line 145, in feature
    Scenario(run=scenario, flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_overflow.py", line 20, in positive_overflow_with_Int16
    execute_query(
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/common.py", line 140, in execute_query
    r = current().context.node.query(
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 802, 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.8.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) order by x
         FORMAT TabSeparatedWithNames
)

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

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

794\|                  assert message in r.output, error(r.output)
795\|  
796\|          if not ignore_exception:
797\|              if message is None or "Exception:" not in message:
798\|                  with Then("check if output has exception") if steps else NullStep():
799\|                      if "Exception:" in r.output:
800\|                          if raise_on_exception:
801\|                              raise QueryRuntimeException(r.output)
802\|>                         assert False, error(r.output)
803\|  
804\|          return r
805\|
/window functions/tests/distributed/frame clause/range errors/error negative following offsetXFail 109ms
https://github.com/ClickHouse/ClickHouse/issues/22442
AssertionError
Traceback (most recent call last):
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 227, in 
    regression()
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 223, in regression
    Feature(run=load("window_functions.tests.feature", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/feature.py", line 72, in feature
    Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/frame_clause.py", line 71, in feature
    Feature(run=load("window_functions.tests.range_errors", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_errors.py", line 114, in feature
    Scenario(run=scenario, flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_errors.py", line 105, in error_negative_following_offset
    r = current().context.node.query(sql, exitcode=exitcode, message=message)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 794, 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.8.8):
Code: 36. DB::Exception: Received from localhost:9000. DB::Exception: Frame end offset for 'RANGE' frame must be a nonnegative 32-bit integer, '-2' of type 'Int64' given. (BAD_ARGUMENTS)
(query: select max(enroll_date) over (order by salary range between 1 preceding and -2 following) AS max, salary, enroll_date from empsalary
)

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.8.8):\nCode: 36. DB::Exception: Received from localhost:9000. DB::Exception: Frame end offset for 'RANGE' frame must be a nonnegative 32-bit integer, '-2' of type 'Int64' given. (BAD_ARGUMENTS)\n(query: select max(enroll_date) over (order by salary range between 1 preceding and -2 following) AS max, salary, enroll_date from empsalary\n)"
  assert message in r.output, error(r.output)
                 ^ is = False
  assert message in r.output, error(r.output)
  ^ is False

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

786\|          if exitcode is not None:
787\|              with Then(f"exitcode should be {exitcode}") if steps else NullStep():
788\|                  assert r.exitcode == exitcode, error(r.output)
789\|  
790\|          if message is not None:
791\|              with Then(
792\|                  f"output should contain message", description=message
793\|              ) if steps else NullStep():
794\|>                 assert message in r.output, error(r.output)
795\|  
796\|          if not ignore_exception:
797\|              if message is None or "Exception:" not in message:
/window functions/tests/distributed/frame clause/range errors/error negative preceding offsetXFail 108ms
https://github.com/ClickHouse/ClickHouse/issues/22442
AssertionError
Traceback (most recent call last):
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 227, in 
    regression()
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/regression.py", line 223, in regression
    Feature(run=load("window_functions.tests.feature", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/feature.py", line 72, in feature
    Feature(run=load("window_functions.tests.frame_clause", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/frame_clause.py", line 71, in feature
    Feature(run=load("window_functions.tests.range_errors", "feature"), flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_errors.py", line 114, in feature
    Scenario(run=scenario, flags=TE)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../window_functions/tests/range_errors.py", line 89, in error_negative_preceding_offset
    r = current().context.node.query(sql, exitcode=exitcode, message=message)
  File "/home/ubuntu/_work/ClickHouse/ClickHouse/window_functions/../helpers/cluster.py", line 794, 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.8.8):
Code: 36. DB::Exception: Received from localhost:9000. DB::Exception: Frame start offset for 'RANGE' frame must be a nonnegative 32-bit integer, '-1' of type 'Int64' given. (BAD_ARGUMENTS)
(query: select max(enroll_date) over (order by salary range between -1 preceding and 2 following) AS max, salary, enroll_date from empsalary
)

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.8.8):\nCode: 36. DB::Exception: Received from localhost:9000. DB::Exception: Frame start offset for 'RANGE' frame must be a nonnegative 32-bit integer, '-1' of type 'Int64' given. (BAD_ARGUMENTS)\n(query: select max(enroll_date) over (order by salary range between -1 preceding and 2 following) AS max, salary, enroll_date from empsalary\n)"
  assert message in r.output, error(r.output)
                 ^ is = False
  assert message in r.output, error(r.output)
  ^ is False

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

786\|          if exitcode is not None:
787\|              with Then(f"exitcode should be {exitcode}") if steps else NullStep():
788\|                  assert r.exitcode == exitcode, error(r.output)
789\|  
790\|          if message is not None:
791\|              with Then(
792\|                  f"output should contain message", description=message
793\|              ) if steps else NullStep():
794\|>                 assert message in r.output, error(r.output)
795\|  
796\|          if not ignore_exception:
797\|              if message is None or "Exception:" not in message:

Results

Test Name Result Duration
/window functions Fail 8m 7s
/window functions/tests Fail 5m 42s
/window functions/tests/non distributed Fail 2m 42s
/window functions/tests/non distributed/window spec OK 822ms
/window functions/tests/non distributed/window spec/empty OK 106ms
/window functions/tests/non distributed/window spec/frame clause OK 106ms
/window functions/tests/non distributed/window spec/order by with frame OK 94ms
/window functions/tests/non distributed/window spec/orderby clause OK 94ms
/window functions/tests/non distributed/window spec/partition clause OK 96ms
/window functions/tests/non distributed/window spec/partition with frame OK 105ms
/window functions/tests/non distributed/window spec/partition with order by OK 108ms
/window functions/tests/non distributed/window spec/partition with order by and frame OK 103ms
/window functions/tests/non distributed/partition clause OK 396ms
/window functions/tests/non distributed/partition clause/invalid expr error OK 98ms
/window functions/tests/non distributed/partition clause/missing expr error OK 102ms
/window functions/tests/non distributed/partition clause/multiple expr OK 97ms
/window functions/tests/non distributed/partition clause/single expr OK 95ms
/window functions/tests/non distributed/order clause OK 1s 157ms
/window functions/tests/non distributed/order clause/by a non integer constant OK 119ms
/window functions/tests/non distributed/order clause/by column OK 98ms
/window functions/tests/non distributed/order clause/by expr OK 103ms
/window functions/tests/non distributed/order clause/by expr with aggregates OK 141ms
/window functions/tests/non distributed/order clause/invalid expr error OK 96ms
/window functions/tests/non distributed/order clause/missing expr error OK 94ms
/window functions/tests/non distributed/order clause/multiple expr asc asc OK 96ms
/window functions/tests/non distributed/order clause/multiple expr asc desc OK 96ms
/window functions/tests/non distributed/order clause/multiple expr desc desc OK 102ms
/window functions/tests/non distributed/order clause/single expr asc OK 105ms
/window functions/tests/non distributed/order clause/single expr desc OK 97ms
/window functions/tests/non distributed/frame clause OK 13s 949ms
/window functions/tests/non distributed/frame clause/default frame OK 189ms
/window functions/tests/non distributed/frame clause/default frame/with order by OK 94ms
/window functions/tests/non distributed/frame clause/default frame/without order by OK 93ms
/window functions/tests/non distributed/frame clause/rows frame OK 3s 601ms
/window functions/tests/non distributed/frame clause/rows frame/between current row and current row OK 100ms
/window functions/tests/non distributed/frame clause/rows frame/between current row and expr following OK 106ms
/window functions/tests/non distributed/frame clause/rows frame/between current row and expr preceding error OK 100ms
/window functions/tests/non distributed/frame clause/rows frame/between current row and unbounded following OK 110ms
/window functions/tests/non distributed/frame clause/rows frame/between current row and unbounded preceding error OK 86ms
/window functions/tests/non distributed/frame clause/rows frame/between expr following and expr following OK 107ms
/window functions/tests/non distributed/frame clause/rows frame/between expr following and expr following error OK 99ms
/window functions/tests/non distributed/frame clause/rows frame/between expr following and expr following ref OK 104ms
/window functions/tests/non distributed/frame clause/rows frame/between expr following and unbounded following OK 101ms
/window functions/tests/non distributed/frame clause/rows frame/between expr following error OK 280ms
/window functions/tests/non distributed/frame clause/rows frame/between expr preceding and current row OK 103ms
/window functions/tests/non distributed/frame clause/rows frame/between expr preceding and expr following OK 101ms
/window functions/tests/non distributed/frame clause/rows frame/between expr preceding and expr following ref OK 102ms
/window functions/tests/non distributed/frame clause/rows frame/between expr preceding and expr preceding OK 123ms
/window functions/tests/non distributed/frame clause/rows frame/between expr preceding and expr preceding error OK 98ms
/window functions/tests/non distributed/frame clause/rows frame/between expr preceding and expr preceding ref OK 139ms
/window functions/tests/non distributed/frame clause/rows frame/between expr preceding and unbounded following OK 98ms
/window functions/tests/non distributed/frame clause/rows frame/between expr preceding and unbounded preceding error OK 80ms
/window functions/tests/non distributed/frame clause/rows frame/between unbounded following error OK 395ms
/window functions/tests/non distributed/frame clause/rows frame/between unbounded preceding and current row OK 100ms
/window functions/tests/non distributed/frame clause/rows frame/between unbounded preceding and expr following OK 97ms
/window functions/tests/non distributed/frame clause/rows frame/between unbounded preceding and expr preceding OK 95ms
/window functions/tests/non distributed/frame clause/rows frame/between unbounded preceding and unbounded following OK 100ms
/window functions/tests/non distributed/frame clause/rows frame/between unbounded preceding and unbounded preceding error OK 74ms
/window functions/tests/non distributed/frame clause/rows frame/invalid frame extent OK 97ms
/window functions/tests/non distributed/frame clause/rows frame/missing frame extent OK 95ms
/window functions/tests/non distributed/frame clause/rows frame/start current row OK 95ms
/window functions/tests/non distributed/frame clause/rows frame/start expr following error OK 109ms
/window functions/tests/non distributed/frame clause/rows frame/start expr preceding OK 104ms
/window functions/tests/non distributed/frame clause/rows frame/start unbounded following error OK 82ms
/window functions/tests/non distributed/frame clause/rows frame/start unbounded preceding OK 96ms
/window functions/tests/non distributed/frame clause/range frame OK 8s 20ms
/window functions/tests/non distributed/frame clause/range frame/between current row and current row OK 203ms
/window functions/tests/non distributed/frame clause/range frame/between current row and expr following with order by OK 98ms
/window functions/tests/non distributed/frame clause/range frame/between current row and expr following without order by error OK 99ms
/window functions/tests/non distributed/frame clause/range frame/between current row and expr preceding error OK 198ms
/window functions/tests/non distributed/frame clause/range frame/between current row and unbounded following OK 319ms
/window functions/tests/non distributed/frame clause/range frame/between current row and unbounded following in named window OK 97ms
/window functions/tests/non distributed/frame clause/range frame/between current row and unbounded following modifying named window OK 106ms
/window functions/tests/non distributed/frame clause/range frame/between current row and unbounded preceding error OK 176ms
/window functions/tests/non distributed/frame clause/range frame/between expr following and current row with order by error OK 119ms
/window functions/tests/non distributed/frame clause/range frame/between expr following and current row without order by error OK 98ms
/window functions/tests/non distributed/frame clause/range frame/between expr following and current row zero special case XFail 137ms
/window functions/tests/non distributed/frame clause/range frame/between expr following and expr following with order by OK 93ms
/window functions/tests/non distributed/frame clause/range frame/between expr following and expr following with order by error OK 105ms
/window functions/tests/non distributed/frame clause/range frame/between expr following and expr following without order by error XFail 106ms
/window functions/tests/non distributed/frame clause/range frame/between expr following and expr preceding error OK 191ms
/window functions/tests/non distributed/frame clause/range frame/between expr following and expr preceding with order by zero special case XFail 110ms
/window functions/tests/non distributed/frame clause/range frame/between expr following and expr preceding without order by error XFail 104ms
/window functions/tests/non distributed/frame clause/range frame/between expr following and unbounded following with order by OK 103ms
/window functions/tests/non distributed/frame clause/range frame/between expr following and unbounded following without order by error OK 107ms
/window functions/tests/non distributed/frame clause/range frame/between expr following and unbounded preceding error OK 162ms
/window functions/tests/non distributed/frame clause/range frame/between expr preceding and current row with order by OK 95ms
/window functions/tests/non distributed/frame clause/range frame/between expr preceding and current row without order by error OK 102ms
/window functions/tests/non distributed/frame clause/range frame/between expr preceding and expr following with order by OK 232ms
/window functions/tests/non distributed/frame clause/range frame/between expr preceding and expr following with partition and order by OK 118ms
/window functions/tests/non distributed/frame clause/range frame/between expr preceding and expr following with partition by same column twice OK 104ms
/window functions/tests/non distributed/frame clause/range frame/between expr preceding and expr following with partition by two columns OK 104ms
/window functions/tests/non distributed/frame clause/range frame/between expr preceding and expr following without order by error OK 100ms
/window functions/tests/non distributed/frame clause/range frame/between expr preceding and expr preceding with order by OK 213ms
/window functions/tests/non distributed/frame clause/range frame/between expr preceding and expr preceding with order by error OK 99ms
/window functions/tests/non distributed/frame clause/range frame/between expr preceding and expr preceding without order by error OK 97ms
/window functions/tests/non distributed/frame clause/range frame/between expr preceding and unbounded following with order by OK 103ms
/window functions/tests/non distributed/frame clause/range frame/between expr preceding and unbounded following without order by error OK 103ms
/window functions/tests/non distributed/frame clause/range frame/between expr preceding and unbounded preceding error OK 188ms
/window functions/tests/non distributed/frame clause/range frame/between unbounded following and current row error OK 163ms
/window functions/tests/non distributed/frame clause/range frame/between unbounded following and expr following error OK 158ms
/window functions/tests/non distributed/frame clause/range frame/between unbounded following and expr preceding error OK 160ms
/window functions/tests/non distributed/frame clause/range frame/between unbounded following and unbounded following error OK 156ms
/window functions/tests/non distributed/frame clause/range frame/between unbounded following and unbounded preceding error OK 159ms
/window functions/tests/non distributed/frame clause/range frame/between unbounded preceding and current row OK 221ms
/window functions/tests/non distributed/frame clause/range frame/between unbounded preceding and current row with expressions in order by and aggregate OK 114ms
/window functions/tests/non distributed/frame clause/range frame/between unbounded preceding and expr following with order by OK 103ms
/window functions/tests/non distributed/frame clause/range frame/between unbounded preceding and expr following without order by error OK 122ms
/window functions/tests/non distributed/frame clause/range frame/between unbounded preceding and expr preceding with order by OK 105ms
/window functions/tests/non distributed/frame clause/range frame/between unbounded preceding and expr preceding without order by error OK 100ms
/window functions/tests/non distributed/frame clause/range frame/between unbounded preceding and unbounded following OK 208ms
/window functions/tests/non distributed/frame clause/range frame/between unbounded preceding and unbounded preceding error OK 160ms
/window functions/tests/non distributed/frame clause/range frame/invalid frame extent OK 97ms
/window functions/tests/non distributed/frame clause/range frame/missing frame extent OK 97ms
/window functions/tests/non distributed/frame clause/range frame/order by decimal XFail 117ms
/window functions/tests/non distributed/frame clause/range frame/order by float OK 103ms
/window functions/tests/non distributed/frame clause/range frame/start current row with order by OK 112ms
/window functions/tests/non distributed/frame clause/range frame/start current row without order by OK 101ms
/window functions/tests/non distributed/frame clause/range frame/start expr following with order by error OK 98ms
/window functions/tests/non distributed/frame clause/range frame/start expr following without order by error OK 100ms
/window functions/tests/non distributed/frame clause/range frame/start expr preceding order by non numerical column error OK 100ms
/window functions/tests/non distributed/frame clause/range frame/start expr preceding with order by OK 100ms
/window functions/tests/non distributed/frame clause/range frame/start expr preceding without order by error OK 121ms
/window functions/tests/non distributed/frame clause/range frame/start unbounded following error OK 164ms
/window functions/tests/non distributed/frame clause/range frame/start unbounded preceding with order by OK 99ms
/window functions/tests/non distributed/frame clause/range frame/start unbounded preceding without order by OK 101ms
/window functions/tests/non distributed/frame clause/range frame/with nulls XFail 135ms
/window functions/tests/non distributed/frame clause/range overflow OK 644ms
/window functions/tests/non distributed/frame clause/range overflow/negative overflow for Int32 OK 102ms
/window functions/tests/non distributed/frame clause/range overflow/negative overflow for Int64 OK 104ms
/window functions/tests/non distributed/frame clause/range overflow/negative overflow with Int16 XFail 106ms
/window functions/tests/non distributed/frame clause/range overflow/positive overflow for Int32 OK 103ms
/window functions/tests/non distributed/frame clause/range overflow/positive overflow for Int64 OK 97ms
/window functions/tests/non distributed/frame clause/range overflow/positive overflow with Int16 XFail 127ms
/window functions/tests/non distributed/frame clause/range datetime OK 847ms
/window functions/tests/non distributed/frame clause/range datetime/datetime order by asc range between n preceding and n following OK 119ms
/window functions/tests/non distributed/frame clause/range datetime/datetime order by desc range between n preceding and n following OK 104ms
/window functions/tests/non distributed/frame clause/range datetime/datetime with timezone order by asc range between n preceding and n following OK 108ms
/window functions/tests/non distributed/frame clause/range datetime/datetime with timezone order by desc range between n preceding and n following OK 108ms
/window functions/tests/non distributed/frame clause/range datetime/order by asc range between days preceding and days following OK 101ms
/window functions/tests/non distributed/frame clause/range datetime/order by desc range between days following and days following OK 98ms
/window functions/tests/non distributed/frame clause/range datetime/order by desc range between days preceding and days following OK 97ms
/window functions/tests/non distributed/frame clause/range datetime/order by desc range between days preceding and days preceding OK 105ms
/window functions/tests/non distributed/frame clause/range errors OK 624ms
/window functions/tests/non distributed/frame clause/range errors/error missing order by OK 99ms
/window functions/tests/non distributed/frame clause/range errors/error missing order by with partition by clause OK 103ms
/window functions/tests/non distributed/frame clause/range errors/error more than one order by column OK 102ms
/window functions/tests/non distributed/frame clause/range errors/error negative following offset XFail 109ms
/window functions/tests/non distributed/frame clause/range errors/error negative preceding offset XFail 104ms
/window functions/tests/non distributed/frame clause/range errors/error range over non numerical column OK 102ms
/window functions/tests/non distributed/window clause OK 500ms
/window functions/tests/non distributed/window clause/missing window spec OK 101ms
/window functions/tests/non distributed/window clause/multiple identical windows OK 101ms
/window functions/tests/non distributed/window clause/multiple windows OK 97ms
/window functions/tests/non distributed/window clause/single window OK 103ms
/window functions/tests/non distributed/window clause/unused window OK 93ms
/window functions/tests/non distributed/over clause OK 622ms
/window functions/tests/non distributed/over clause/adhoc window OK 100ms
/window functions/tests/non distributed/over clause/empty OK 99ms
/window functions/tests/non distributed/over clause/empty named window OK 109ms
/window functions/tests/non distributed/over clause/invalid multiple windows OK 104ms
/window functions/tests/non distributed/over clause/invalid window name OK 101ms
/window functions/tests/non distributed/over clause/missing window spec OK 104ms
/window functions/tests/non distributed/funcs OK 3s 99ms
/window functions/tests/non distributed/funcs/dense rank OK 105ms
/window functions/tests/non distributed/funcs/first value OK 254ms
/window functions/tests/non distributed/funcs/first value with lead workaround OK 99ms
/window functions/tests/non distributed/funcs/lag OK 321ms
/window functions/tests/non distributed/funcs/lagInFrame OK 549ms
/window functions/tests/non distributed/funcs/last value OK 424ms
/window functions/tests/non distributed/funcs/last value with lag workaround OK 93ms
/window functions/tests/non distributed/funcs/last value with no frame OK 106ms
/window functions/tests/non distributed/funcs/lead OK 413ms
/window functions/tests/non distributed/funcs/leadInFrame OK 507ms
/window functions/tests/non distributed/funcs/rank OK 114ms
/window functions/tests/non distributed/funcs/row number OK 103ms
/window functions/tests/non distributed/aggregate funcs Fail 8s 186ms
/window functions/tests/non distributed/aggregate funcs/aggregate and window function in the same window OK 115ms
/window functions/tests/non distributed/aggregate funcs/aggregate funcs over rows frame Fail 6s 689ms
/window functions/tests/non distributed/aggregate funcs/aggregate function recovers from nan OK 103ms
/window functions/tests/non distributed/aggregate funcs/avgWeighted OK 319ms
/window functions/tests/non distributed/aggregate funcs/avg with nulls OK 102ms
/window functions/tests/non distributed/aggregate funcs/bit functions OK 106ms
/window functions/tests/non distributed/aggregate funcs/nested aggregates OK 108ms
/window functions/tests/non distributed/aggregate funcs/stddevpop OK 100ms
/window functions/tests/non distributed/aggregate funcs/stddevsamp OK 107ms
/window functions/tests/non distributed/aggregate funcs/sum OK 110ms
/window functions/tests/non distributed/aggregate funcs/ungrouped aggregate over empty row set OK 100ms
/window functions/tests/non distributed/aggregate funcs/var pop OK 108ms
/window functions/tests/non distributed/aggregate funcs/var samp OK 108ms
/window functions/tests/non distributed/time decayed funcs OK 1m 57s
/window functions/tests/non distributed/time decayed funcs/exponentialTimeDecayedAvg OK 17s 269ms
/window functions/tests/non distributed/time decayed funcs/exponentialTimeDecayedCount OK 15s 191ms
/window functions/tests/non distributed/time decayed funcs/exponentialTimeDecayedMax OK 1m 7s
/window functions/tests/non distributed/time decayed funcs/exponentialTimeDecayedSum OK 17s 160ms
/window functions/tests/non distributed/errors OK 1s 28ms
/window functions/tests/non distributed/errors/error coma between partition by and order by clause OK 97ms
/window functions/tests/non distributed/errors/error named window defined twice OK 105ms
/window functions/tests/non distributed/errors/error order by another window function OK 100ms
/window functions/tests/non distributed/errors/error select from window OK 99ms
/window functions/tests/non distributed/errors/error using non window function OK 106ms
/window functions/tests/non distributed/errors/error window function in alter delete where OK 105ms
/window functions/tests/non distributed/errors/error window function in group by OK 99ms
/window functions/tests/non distributed/errors/error window function in having OK 99ms
/window functions/tests/non distributed/errors/error window function in join OK 108ms
/window functions/tests/non distributed/errors/error window function in where OK 104ms
/window functions/tests/non distributed/misc OK 1s 970ms
/window functions/tests/non distributed/misc/count with empty over clause without start OK 102ms
/window functions/tests/non distributed/misc/empty table OK 101ms
/window functions/tests/non distributed/misc/exclude clause OK 97ms
/window functions/tests/non distributed/misc/from subquery OK 108ms
/window functions/tests/non distributed/misc/group by and multiple windows OK 107ms
/window functions/tests/non distributed/misc/group by and one window OK 110ms
/window functions/tests/non distributed/misc/groups frame OK 109ms
/window functions/tests/non distributed/misc/in view OK 344ms
/window functions/tests/non distributed/misc/query with order by and one window OK 104ms
/window functions/tests/non distributed/misc/subquery expr preceding OK 103ms
/window functions/tests/non distributed/misc/subquery multiple window functions OK 143ms
/window functions/tests/non distributed/misc/subquery with multiple windows filtering OK 110ms
/window functions/tests/non distributed/misc/window functions in select expression OK 97ms
/window functions/tests/non distributed/misc/window functions in subquery OK 113ms
/window functions/tests/non distributed/misc/windows with same partitioning but different ordering OK 105ms
/window functions/tests/non distributed/misc/with union all OK 102ms
/window functions/tests/non distributed/datatypes OK 1s 276ms
/window functions/tests/non distributed/datatypes/date OK 143ms
/window functions/tests/non distributed/datatypes/datetime OK 100ms
/window functions/tests/non distributed/datatypes/datetime64 OK 99ms
/window functions/tests/non distributed/datatypes/decimal32 OK 101ms
/window functions/tests/non distributed/datatypes/enum OK 105ms
/window functions/tests/non distributed/datatypes/fixed string OK 103ms
/window functions/tests/non distributed/datatypes/ipv4 OK 116ms
/window functions/tests/non distributed/datatypes/ipv6 OK 107ms
/window functions/tests/non distributed/datatypes/low cardinality OK 99ms
/window functions/tests/non distributed/datatypes/map OK 101ms
/window functions/tests/non distributed/datatypes/string OK 97ms
/window functions/tests/non distributed/datatypes/uuid OK 95ms
/window functions/tests/non distributed/non-negative derivative func OK 8s 297ms
/window functions/tests/non distributed/non-negative derivative func/acceptance OK 1s 257ms
/window functions/tests/non distributed/non-negative derivative func/check intervals OK 833ms
/window functions/tests/non distributed/non-negative derivative func/check negative result OK 112ms
/window functions/tests/non distributed/non-negative derivative func/check one row per partition OK 105ms
/window functions/tests/non distributed/non-negative derivative func/check over windows OK 2s 544ms
/window functions/tests/non distributed/non-negative derivative func/division by tiny OK 246ms
/window functions/tests/non distributed/non-negative derivative func/division by zero OK 102ms
/window functions/tests/non distributed/non-negative derivative func/empty table OK 274ms
/window functions/tests/non distributed/non-negative derivative func/null values OK 212ms
/window functions/tests/non distributed/non-negative derivative func/valid metric types OK 1s 327ms
/window functions/tests/non distributed/non-negative derivative func/valid timestamp types OK 311ms
/window functions/tests/non distributed/non-negative derivative func/wrong number of arguments or types OK 834ms
/window functions/tests/non distributed/non-negative derivative func/zero interval OK 127ms
/window functions/tests/distributed Fail 3m 0s
/window functions/tests/distributed/window spec OK 883ms
/window functions/tests/distributed/window spec/empty OK 110ms
/window functions/tests/distributed/window spec/frame clause OK 108ms
/window functions/tests/distributed/window spec/order by with frame OK 109ms
/window functions/tests/distributed/window spec/orderby clause OK 109ms
/window functions/tests/distributed/window spec/partition clause OK 113ms
/window functions/tests/distributed/window spec/partition with frame OK 109ms
/window functions/tests/distributed/window spec/partition with order by OK 111ms
/window functions/tests/distributed/window spec/partition with order by and frame OK 106ms
/window functions/tests/distributed/partition clause OK 410ms
/window functions/tests/distributed/partition clause/invalid expr error OK 98ms
/window functions/tests/distributed/partition clause/missing expr error OK 93ms
/window functions/tests/distributed/partition clause/multiple expr OK 119ms
/window functions/tests/distributed/partition clause/single expr OK 96ms
/window functions/tests/distributed/order clause OK 1s 141ms
/window functions/tests/distributed/order clause/by a non integer constant OK 97ms
/window functions/tests/distributed/order clause/by column OK 115ms
/window functions/tests/distributed/order clause/by expr OK 112ms
/window functions/tests/distributed/order clause/by expr with aggregates OK 112ms
/window functions/tests/distributed/order clause/invalid expr error OK 101ms
/window functions/tests/distributed/order clause/missing expr error OK 89ms
/window functions/tests/distributed/order clause/multiple expr asc asc OK 100ms
/window functions/tests/distributed/order clause/multiple expr asc desc OK 94ms
/window functions/tests/distributed/order clause/multiple expr desc desc OK 101ms
/window functions/tests/distributed/order clause/single expr asc OK 97ms
/window functions/tests/distributed/order clause/single expr desc OK 114ms
/window functions/tests/distributed/frame clause OK 14s 533ms
/window functions/tests/distributed/frame clause/default frame OK 202ms
/window functions/tests/distributed/frame clause/default frame/with order by OK 102ms
/window functions/tests/distributed/frame clause/default frame/without order by OK 98ms
/window functions/tests/distributed/frame clause/rows frame OK 3s 849ms
/window functions/tests/distributed/frame clause/rows frame/between current row and current row OK 115ms
/window functions/tests/distributed/frame clause/rows frame/between current row and expr following OK 115ms
/window functions/tests/distributed/frame clause/rows frame/between current row and expr preceding error OK 101ms
/window functions/tests/distributed/frame clause/rows frame/between current row and unbounded following OK 123ms
/window functions/tests/distributed/frame clause/rows frame/between current row and unbounded preceding error OK 79ms
/window functions/tests/distributed/frame clause/rows frame/between expr following and expr following OK 108ms
/window functions/tests/distributed/frame clause/rows frame/between expr following and expr following error OK 102ms
/window functions/tests/distributed/frame clause/rows frame/between expr following and expr following ref OK 111ms
/window functions/tests/distributed/frame clause/rows frame/between expr following and unbounded following OK 117ms
/window functions/tests/distributed/frame clause/rows frame/between expr following error OK 286ms
/window functions/tests/distributed/frame clause/rows frame/between expr preceding and current row OK 128ms
/window functions/tests/distributed/frame clause/rows frame/between expr preceding and expr following OK 106ms
/window functions/tests/distributed/frame clause/rows frame/between expr preceding and expr following ref OK 113ms
/window functions/tests/distributed/frame clause/rows frame/between expr preceding and expr preceding OK 111ms
/window functions/tests/distributed/frame clause/rows frame/between expr preceding and expr preceding error OK 99ms
/window functions/tests/distributed/frame clause/rows frame/between expr preceding and expr preceding ref OK 113ms
/window functions/tests/distributed/frame clause/rows frame/between expr preceding and unbounded following OK 115ms
/window functions/tests/distributed/frame clause/rows frame/between expr preceding and unbounded preceding error OK 78ms
/window functions/tests/distributed/frame clause/rows frame/between unbounded following error OK 409ms
/window functions/tests/distributed/frame clause/rows frame/between unbounded preceding and current row OK 118ms
/window functions/tests/distributed/frame clause/rows frame/between unbounded preceding and expr following OK 111ms
/window functions/tests/distributed/frame clause/rows frame/between unbounded preceding and expr preceding OK 152ms
/window functions/tests/distributed/frame clause/rows frame/between unbounded preceding and unbounded following OK 109ms
/window functions/tests/distributed/frame clause/rows frame/between unbounded preceding and unbounded preceding error OK 84ms
/window functions/tests/distributed/frame clause/rows frame/invalid frame extent OK 104ms
/window functions/tests/distributed/frame clause/rows frame/missing frame extent OK 110ms
/window functions/tests/distributed/frame clause/rows frame/start current row OK 108ms
/window functions/tests/distributed/frame clause/rows frame/start expr following error OK 99ms
/window functions/tests/distributed/frame clause/rows frame/start expr preceding OK 108ms
/window functions/tests/distributed/frame clause/rows frame/start unbounded following error OK 84ms
/window functions/tests/distributed/frame clause/rows frame/start unbounded preceding OK 107ms
/window functions/tests/distributed/frame clause/range frame OK 8s 273ms
/window functions/tests/distributed/frame clause/range frame/between current row and current row OK 228ms
/window functions/tests/distributed/frame clause/range frame/between current row and expr following with order by OK 109ms
/window functions/tests/distributed/frame clause/range frame/between current row and expr following without order by error OK 94ms
/window functions/tests/distributed/frame clause/range frame/between current row and expr preceding error OK 202ms
/window functions/tests/distributed/frame clause/range frame/between current row and unbounded following OK 334ms
/window functions/tests/distributed/frame clause/range frame/between current row and unbounded following in named window OK 109ms
/window functions/tests/distributed/frame clause/range frame/between current row and unbounded following modifying named window OK 109ms
/window functions/tests/distributed/frame clause/range frame/between current row and unbounded preceding error OK 171ms
/window functions/tests/distributed/frame clause/range frame/between expr following and current row with order by error OK 105ms
/window functions/tests/distributed/frame clause/range frame/between expr following and current row without order by error OK 116ms
/window functions/tests/distributed/frame clause/range frame/between expr following and current row zero special case XFail 105ms
/window functions/tests/distributed/frame clause/range frame/between expr following and expr following with order by OK 116ms
/window functions/tests/distributed/frame clause/range frame/between expr following and expr following with order by error OK 100ms
/window functions/tests/distributed/frame clause/range frame/between expr following and expr following without order by error XFail 107ms
/window functions/tests/distributed/frame clause/range frame/between expr following and expr preceding error OK 224ms
/window functions/tests/distributed/frame clause/range frame/between expr following and expr preceding with order by zero special case XFail 103ms
/window functions/tests/distributed/frame clause/range frame/between expr following and expr preceding without order by error XFail 105ms
/window functions/tests/distributed/frame clause/range frame/between expr following and unbounded following with order by OK 104ms
/window functions/tests/distributed/frame clause/range frame/between expr following and unbounded following without order by error OK 99ms
/window functions/tests/distributed/frame clause/range frame/between expr following and unbounded preceding error OK 160ms
/window functions/tests/distributed/frame clause/range frame/between expr preceding and current row with order by OK 109ms
/window functions/tests/distributed/frame clause/range frame/between expr preceding and current row without order by error OK 99ms
/window functions/tests/distributed/frame clause/range frame/between expr preceding and expr following with order by OK 221ms
/window functions/tests/distributed/frame clause/range frame/between expr preceding and expr following with partition and order by OK 117ms
/window functions/tests/distributed/frame clause/range frame/between expr preceding and expr following with partition by same column twice OK 137ms
/window functions/tests/distributed/frame clause/range frame/between expr preceding and expr following with partition by two columns OK 112ms
/window functions/tests/distributed/frame clause/range frame/between expr preceding and expr following without order by error OK 104ms
/window functions/tests/distributed/frame clause/range frame/between expr preceding and expr preceding with order by OK 232ms
/window functions/tests/distributed/frame clause/range frame/between expr preceding and expr preceding with order by error OK 95ms
/window functions/tests/distributed/frame clause/range frame/between expr preceding and expr preceding without order by error OK 104ms
/window functions/tests/distributed/frame clause/range frame/between expr preceding and unbounded following with order by OK 117ms
/window functions/tests/distributed/frame clause/range frame/between expr preceding and unbounded following without order by error OK 106ms
/window functions/tests/distributed/frame clause/range frame/between expr preceding and unbounded preceding error OK 157ms
/window functions/tests/distributed/frame clause/range frame/between unbounded following and current row error OK 172ms
/window functions/tests/distributed/frame clause/range frame/between unbounded following and expr following error OK 167ms
/window functions/tests/distributed/frame clause/range frame/between unbounded following and expr preceding error OK 162ms
/window functions/tests/distributed/frame clause/range frame/between unbounded following and unbounded following error OK 192ms
/window functions/tests/distributed/frame clause/range frame/between unbounded following and unbounded preceding error OK 165ms
/window functions/tests/distributed/frame clause/range frame/between unbounded preceding and current row OK 228ms
/window functions/tests/distributed/frame clause/range frame/between unbounded preceding and current row with expressions in order by and aggregate OK 123ms
/window functions/tests/distributed/frame clause/range frame/between unbounded preceding and expr following with order by OK 107ms
/window functions/tests/distributed/frame clause/range frame/between unbounded preceding and expr following without order by error OK 99ms
/window functions/tests/distributed/frame clause/range frame/between unbounded preceding and expr preceding with order by OK 114ms
/window functions/tests/distributed/frame clause/range frame/between unbounded preceding and expr preceding without order by error OK 99ms
/window functions/tests/distributed/frame clause/range frame/between unbounded preceding and unbounded following OK 220ms
/window functions/tests/distributed/frame clause/range frame/between unbounded preceding and unbounded preceding error OK 165ms
/window functions/tests/distributed/frame clause/range frame/invalid frame extent OK 93ms
/window functions/tests/distributed/frame clause/range frame/missing frame extent OK 90ms
/window functions/tests/distributed/frame clause/range frame/order by decimal XFail 116ms
/window functions/tests/distributed/frame clause/range frame/order by float OK 112ms
/window functions/tests/distributed/frame clause/range frame/start current row with order by OK 105ms
/window functions/tests/distributed/frame clause/range frame/start current row without order by OK 108ms
/window functions/tests/distributed/frame clause/range frame/start expr following with order by error OK 102ms
/window functions/tests/distributed/frame clause/range frame/start expr following without order by error OK 109ms
/window functions/tests/distributed/frame clause/range frame/start expr preceding order by non numerical column error OK 105ms
/window functions/tests/distributed/frame clause/range frame/start expr preceding with order by OK 119ms
/window functions/tests/distributed/frame clause/range frame/start expr preceding without order by error OK 102ms
/window functions/tests/distributed/frame clause/range frame/start unbounded following error OK 165ms
/window functions/tests/distributed/frame clause/range frame/start unbounded preceding with order by OK 111ms
/window functions/tests/distributed/frame clause/range frame/start unbounded preceding without order by OK 117ms
/window functions/tests/distributed/frame clause/range frame/with nulls XFail 141ms
/window functions/tests/distributed/frame clause/range overflow OK 645ms
/window functions/tests/distributed/frame clause/range overflow/negative overflow for Int32 OK 101ms
/window functions/tests/distributed/frame clause/range overflow/negative overflow for Int64 OK 99ms
/window functions/tests/distributed/frame clause/range overflow/negative overflow with Int16 XFail 122ms
/window functions/tests/distributed/frame clause/range overflow/positive overflow for Int32 OK 101ms
/window functions/tests/distributed/frame clause/range overflow/positive overflow for Int64 OK 100ms
/window functions/tests/distributed/frame clause/range overflow/positive overflow with Int16 XFail 116ms
/window functions/tests/distributed/frame clause/range datetime OK 915ms
/window functions/tests/distributed/frame clause/range datetime/datetime order by asc range between n preceding and n following OK 111ms
/window functions/tests/distributed/frame clause/range datetime/datetime order by desc range between n preceding and n following OK 111ms
/window functions/tests/distributed/frame clause/range datetime/datetime with timezone order by asc range between n preceding and n following OK 112ms
/window functions/tests/distributed/frame clause/range datetime/datetime with timezone order by desc range between n preceding and n following OK 110ms
/window functions/tests/distributed/frame clause/range datetime/order by asc range between days preceding and days following OK 115ms
/window functions/tests/distributed/frame clause/range datetime/order by desc range between days following and days following OK 108ms
/window functions/tests/distributed/frame clause/range datetime/order by desc range between days preceding and days following OK 130ms
/window functions/tests/distributed/frame clause/range datetime/order by desc range between days preceding and days preceding OK 111ms
/window functions/tests/distributed/frame clause/range errors OK 642ms
/window functions/tests/distributed/frame clause/range errors/error missing order by OK 108ms
/window functions/tests/distributed/frame clause/range errors/error missing order by with partition by clause OK 101ms
/window functions/tests/distributed/frame clause/range errors/error more than one order by column OK 106ms
/window functions/tests/distributed/frame clause/range errors/error negative following offset XFail 109ms
/window functions/tests/distributed/frame clause/range errors/error negative preceding offset XFail 108ms
/window functions/tests/distributed/frame clause/range errors/error range over non numerical column OK 104ms
/window functions/tests/distributed/window clause OK 539ms
/window functions/tests/distributed/window clause/missing window spec OK 100ms
/window functions/tests/distributed/window clause/multiple identical windows OK 106ms
/window functions/tests/distributed/window clause/multiple windows OK 110ms
/window functions/tests/distributed/window clause/single window OK 115ms
/window functions/tests/distributed/window clause/unused window OK 104ms
/window functions/tests/distributed/over clause OK 663ms
/window functions/tests/distributed/over clause/adhoc window OK 114ms
/window functions/tests/distributed/over clause/empty OK 111ms
/window functions/tests/distributed/over clause/empty named window OK 142ms
/window functions/tests/distributed/over clause/invalid multiple windows OK 98ms
/window functions/tests/distributed/over clause/invalid window name OK 99ms
/window functions/tests/distributed/over clause/missing window spec OK 93ms
/window functions/tests/distributed/funcs OK 3s 335ms
/window functions/tests/distributed/funcs/dense rank OK 109ms
/window functions/tests/distributed/funcs/first value OK 229ms
/window functions/tests/distributed/funcs/first value with lead workaround OK 113ms
/window functions/tests/distributed/funcs/lag OK 329ms
/window functions/tests/distributed/funcs/lagInFrame OK 558ms
/window functions/tests/distributed/funcs/last value OK 487ms
/window functions/tests/distributed/funcs/last value with lag workaround OK 110ms
/window functions/tests/distributed/funcs/last value with no frame OK 105ms
/window functions/tests/distributed/funcs/lead OK 460ms
/window functions/tests/distributed/funcs/leadInFrame OK 587ms
/window functions/tests/distributed/funcs/rank OK 130ms
/window functions/tests/distributed/funcs/row number OK 107ms
/window functions/tests/distributed/aggregate funcs Fail 8s 903ms
/window functions/tests/distributed/aggregate funcs/aggregate and window function in the same window OK 110ms
/window functions/tests/distributed/aggregate funcs/aggregate funcs over rows frame Fail 7s 423ms
/window functions/tests/distributed/aggregate funcs/aggregate function recovers from nan OK 103ms
/window functions/tests/distributed/aggregate funcs/avgWeighted OK 314ms
/window functions/tests/distributed/aggregate funcs/avg with nulls OK 101ms
/window functions/tests/distributed/aggregate funcs/bit functions OK 111ms
/window functions/tests/distributed/aggregate funcs/nested aggregates OK 110ms
/window functions/tests/distributed/aggregate funcs/stddevpop OK 101ms
/window functions/tests/distributed/aggregate funcs/stddevsamp OK 108ms
/window functions/tests/distributed/aggregate funcs/sum OK 115ms
/window functions/tests/distributed/aggregate funcs/ungrouped aggregate over empty row set OK 97ms
/window functions/tests/distributed/aggregate funcs/var pop OK 96ms
/window functions/tests/distributed/aggregate funcs/var samp OK 101ms
/window functions/tests/distributed/time decayed funcs OK 1m 57s
/window functions/tests/distributed/time decayed funcs/exponentialTimeDecayedAvg OK 17s 226ms
/window functions/tests/distributed/time decayed funcs/exponentialTimeDecayedCount OK 15s 357ms
/window functions/tests/distributed/time decayed funcs/exponentialTimeDecayedMax OK 1m 7s
/window functions/tests/distributed/time decayed funcs/exponentialTimeDecayedSum OK 17s 118ms
/window functions/tests/distributed/errors OK 1s 42ms
/window functions/tests/distributed/errors/error coma between partition by and order by clause OK 103ms
/window functions/tests/distributed/errors/error named window defined twice OK 101ms
/window functions/tests/distributed/errors/error order by another window function OK 98ms
/window functions/tests/distributed/errors/error select from window OK 103ms
/window functions/tests/distributed/errors/error using non window function OK 113ms
/window functions/tests/distributed/errors/error window function in alter delete where OK 104ms
/window functions/tests/distributed/errors/error window function in group by OK 97ms
/window functions/tests/distributed/errors/error window function in having OK 102ms
/window functions/tests/distributed/errors/error window function in join OK 108ms
/window functions/tests/distributed/errors/error window function in where OK 104ms
/window functions/tests/distributed/misc OK 2s 94ms
/window functions/tests/distributed/misc/count with empty over clause without start OK 109ms
/window functions/tests/distributed/misc/empty table OK 113ms
/window functions/tests/distributed/misc/exclude clause OK 95ms
/window functions/tests/distributed/misc/from subquery OK 115ms
/window functions/tests/distributed/misc/group by and multiple windows OK 140ms
/window functions/tests/distributed/misc/group by and one window OK 117ms
/window functions/tests/distributed/misc/groups frame OK 105ms
/window functions/tests/distributed/misc/in view OK 355ms
/window functions/tests/distributed/misc/query with order by and one window OK 108ms
/window functions/tests/distributed/misc/subquery expr preceding OK 122ms
/window functions/tests/distributed/misc/subquery multiple window functions OK 114ms
/window functions/tests/distributed/misc/subquery with multiple windows filtering OK 112ms
/window functions/tests/distributed/misc/window functions in select expression OK 112ms
/window functions/tests/distributed/misc/window functions in subquery OK 121ms
/window functions/tests/distributed/misc/windows with same partitioning but different ordering OK 119ms
/window functions/tests/distributed/misc/with union all OK 121ms
/window functions/tests/distributed/datatypes OK 1s 235ms
/window functions/tests/distributed/datatypes/date OK 100ms
/window functions/tests/distributed/datatypes/datetime OK 100ms
/window functions/tests/distributed/datatypes/datetime64 OK 111ms
/window functions/tests/distributed/datatypes/decimal32 OK 93ms
/window functions/tests/distributed/datatypes/enum OK 105ms
/window functions/tests/distributed/datatypes/fixed string OK 101ms
/window functions/tests/distributed/datatypes/ipv4 OK 98ms
/window functions/tests/distributed/datatypes/ipv6 OK 93ms
/window functions/tests/distributed/datatypes/low cardinality OK 95ms
/window functions/tests/distributed/datatypes/map OK 126ms
/window functions/tests/distributed/datatypes/string OK 100ms
/window functions/tests/distributed/datatypes/uuid OK 103ms
/window functions/tests/distributed/non-negative derivative func OK 8s 224ms
/window functions/tests/distributed/non-negative derivative func/acceptance OK 1s 289ms
/window functions/tests/distributed/non-negative derivative func/check intervals OK 837ms
/window functions/tests/distributed/non-negative derivative func/check negative result OK 99ms
/window functions/tests/distributed/non-negative derivative func/check one row per partition OK 101ms
/window functions/tests/distributed/non-negative derivative func/check over windows OK 2s 552ms
/window functions/tests/distributed/non-negative derivative func/division by tiny OK 202ms
/window functions/tests/distributed/non-negative derivative func/division by zero OK 97ms
/window functions/tests/distributed/non-negative derivative func/empty table OK 271ms
/window functions/tests/distributed/non-negative derivative func/null values OK 199ms
/window functions/tests/distributed/non-negative derivative func/valid metric types OK 1s 331ms
/window functions/tests/distributed/non-negative derivative func/valid timestamp types OK 301ms
/window functions/tests/distributed/non-negative derivative func/wrong number of arguments or types OK 839ms
/window functions/tests/distributed/non-negative derivative func/zero interval OK 96ms

Generated by TestFlows Open-Source Test Framework v2.0.231130.1212236