Document status - Public

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

QA Software Build Report

ClickHouse 22.3.8.40 / x86_64

(c) 2022 Altinity Inc. All Rights Reserved.

Approval

Status: Approved for release by QA (vzakaznikov@altinity.com Wed 20 Jul 2022 10:07:59 AM EDT)

Known Issues:

Regression in window functions when ORDER BY has an expression that contains aggregates
Regression in all exponential time decayed window functions

Reviewed by: azvonov@altinity.com

Date: 19 July 2022

Table of Contents

2 Results Analysis
- 2.1 Integration Results
- 2.2 Stateful Results
- 2.3 Stateless Results
- 2.4 TestFlows Results

Test Results

Stage	Status
Integration	Pass
Stateful	Pass
Stateless	Fail (OK to fail)
TestFlows	Fail

Results https://altinity-test-reports.s3.amazonaws.com/index.html#builds/stable/v22.3.8.40/2022-07-19T09-28-19.385/
Pipeline https://gitlab.com/altinity-qa/clickhouse/cicd/release/-/pipelines/591197773
Pipeline https://gitlab.com/altinity-qa/clickhouse/cicd/release/-/pipelines/592904866

Results Analysis

Integration Results

Results
https://altinity-test-reports.s3.amazonaws.com/builds/stable/v22.3.8.40/2022-07-19T09-28-19.385/integration/integration_results_1.html
https://altinity-test-reports.s3.amazonaws.com/builds/stable/v22.3.8.40/2022-07-19T09-28-19.385/integration/integration_results_2.html

Stateful Results

Results https://altinity-test-reports.s3.amazonaws.com/builds/stable/v22.3.8.40/2022-07-19T09-28-19.385/stateful/stateful_results.html

Stateless Results

Results https://altinity-test-reports.s3.amazonaws.com/builds/stable/v22.3.8.40/2022-07-19T09-28-19.385/stateless/stateless_results.html

Test: /stateless/01193_metadata_loading

Reason:

2022-07-01 09:17:13 --- /usr/share/clickhouse-test/queries/0_stateless/01193_metadata_loading.reference 2022-07-01 08:48:36.211930910 +0200
2022-07-01 09:17:13 +++ /tmp/clickhouse-test/0_stateless/01193_metadata_loading.stdout  2022-07-01 09:17:13.767924358 +0200
2022-07-01 09:17:13 @@ -1,5 +1,5 @@
2022-07-01 09:17:13  1000   0   2020-06-25  hello   [1,2]   [3,4]
2022-07-01 09:17:13  1000   1   2020-06-26  word    [10,20] [30,40]
2022-07-01 09:17:13 -ok
2022-07-01 09:17:13 +[4910,3140,5265,4391,4880]
2022-07-01 09:17:13  8000   0   2020-06-25  hello   [1,2]   [3,4]
2022-07-01 09:17:13  8000   1   2020-06-26  word    [10,20] [30,40]
2022-07-01 09:17:13
2022-07-01 09:17:13
2022-07-01 09:17:13 Settings used in the test: --max_insert_threads=0 --group_by_two_level_threshold=100000 --group_by_two_level_threshold_bytes=50000000 --distributed_aggregation_memory_efficient=1 --fsync_metadata=1 --priority=0 --output_format_parallel_formatting=1 --input_format_parallel_parsing=1
2022-07-01 09:17:13
2022-07-01 09:17:13 Database: test_9swzgr

Comment:
Status: FAIL (OK to fail)

TestFlows Results

Passed:
- AES Encryption
- DateTime64 Extended Range
- ClickHouse Keeper
- Disk Level Encryption
- Example
- Extended Precision Data Types
- Kafka
- Kerberos
- LDAP
- Map Type
- Part Moves Between Shards
- RBAC
- S3 GCS
- S3 AWS
- S3 Minio
- SSL Server
- Tiered Storage original
- Tiered Storage Minio
- Tiered Storage AWS

Not Passed:

Lightweight Delete
Status: Not supported.

Tiered Storage GCS
Tests:

✘ [ Error ] /tiered storage/with s3gcs/alter move/concurrent/concurrent alter move (test passed locally)
✘ [ Fail ] /tiered storage/with s3gcs/ttl moves/inserts multiple ttls (passed on retest https://gitlab.com/altinity-qa/clickhouse/cicd/regression/-/jobs/2747519936)

Status: FAIL

Window Functions
Tests:

/window functions/tests/non distributed/order clause/by expr with aggregates (regression)
/window functions/tests/non distributed/time decayed funcs/* (regression)
/window functions/tests/distributed/time decayed funcs/* (regression)

Status: FAIL