Skip to content

Test Failures in 01624_soft_constraints and 02944_variant_as_common_type #67769

@Zawa-ll

Description

@Zawa-ll

Company or project name

No response

Question

I am encountering test failures in the ClickHouse test suite.
I tried to check if these two failing checks are caused by my changes, but it acually happens in both of my PR #66791 and #69882, so I doubt that this is relevant to my changes...

Here are the details:

Test Name: 01624_soft_constraints
Failure Time: 2024-08-04 19:11:39
Failure Reason: Result differs from reference
Difference:
--- /ClickHouse/tests/queries/0_stateless/01624_soft_constraints.reference 2024-08-04 19:03:18.067233465 +0200
+++ /ClickHouse/tests/queries/0_stateless/01624_soft_constraints.stdout 2024-08-04 19:11:39.015375573 +0200
@@ -1,16 +1,16 @@
      "rows_read": 4,
  -   "rows_read": 2,
      "rows_read": 4,
  -   "rows_read": 2,
  -   "rows_read": 2,
  -   "rows_read": 2,
      "rows_read": 4,
  -   "rows_read": 2,
      "rows_read": 4,
      "rows_read": 4,
  -   "rows_read": 1,
      "rows_read": 4,
  -   "rows_read": 3,
      "rows_read": 4,
      "rows_read": 4,
  -   "rows_read": 3,
  +   "rows_read": 4,
  +   "rows_read": 4,
  +   "rows_read": 4,
  +   "rows_read": 4,
  +   "rows_read": 4,
  +   "rows_read": 4,
  +   "rows_read": 4,
  +   "rows_read": 4,
Database: test_h9zmdqfq
Test Name: 02944_variant_as_common_type
Failure Time: 2024-08-04 19:11:42
Failure Reason: Result differs from reference
Difference:
diff
--- /ClickHouse/tests/queries/0_stateless/02944_variant_as_common_type.reference 2024-08-04 19:03:18.519240751 +0200
+++ /ClickHouse/tests/queries/0_stateless/02944_variant_as_common_type.stdout 2024-08-04 19:11:42.219427226 +0200
@@ -1,51 +1,51 @@
-Array(UInt8)  [1,2,3]
-Array(UInt8)  [1,2,3]
-String        str_1
-Nullable(String) str_1
-String        str_1
-Nullable(String) str_1
-Variant(Array(UInt8), String) str_1
-Variant(Array(UInt8), String) str_1
-Array(UInt8)  [1,2,3]
-Array(UInt8)  [1,2,3]
-String        str_1
-Nullable(String) str_1
-String        str_1
-Nullable(String) str_1
-Variant(Array(UInt8), String) str_1
-Variant(Array(UInt8), String) str_1
-Array(UInt8)  [1,2,3]
-Array(UInt8)  [1,2,3]
-String        str_1
-Nullable(String) str_1
-String        str_1
+Variant(Array(UInt8), String) str_1
+Variant(Array(UInt64), String) str_0
+Variant(Array(UInt64), String) str_1
+Variant(Array(UInt64), String) str_2
+Variant(Array(UInt64), String) str_3
+Variant(Array(UInt64), String) str_0
+Variant(Array(UInt64), String) str_1
+Variant(Array(UInt64), String) str_2
+Variant(Array(UInt64), String) str_3
+Variant(Array(UInt64), String) [0]
+Variant(Array(UInt64), String) [0,1]
+Variant(Array(UInt64), String) [0,1,2]
+Variant(Array(UInt64), String) [0,1,2,3]
+Variant(Array(UInt64), String) [0]
+Variant(Array(UInt64), String) [0,1]
+Variant(Array(UInt64), String) [0,1,2]
+Variant(Array(UInt64), String) [0,1,2,3]
+Variant(Array(UInt64), String) str_0
+Variant(Array(UInt64), String) str_1
+Variant(Array(UInt64), String) str_2
+Variant(Array(UInt64), String) str_3
+Variant(Array(UInt64), String) str_0
+Variant(Array(UInt64), String) str_1
+Variant(Array(UInt64), String) str_2
+Variant(Array(UInt64), String) str_3
+Variant(Array(UInt64), String) str_0
+Variant(Array(UInt64), String) str_1
+Variant(Array(UInt64), String) str_2
Database: test_gvra270w
Environment:

Steps to Reproduce:

Run the ClickHouse test suite using the command clickhouse-test.
Observe the test failures for 01624_soft_constraints and 02944_variant_as_common_type.
Expected Behavior:
The test outputs should match the reference outputs without differences.

Actual Behavior:
The test outputs differ from the reference outputs, as shown in the diffs above.

Attempts to Fix:
I tried to address the issue by making changes, but both of my PRs are failing due to these same tests.
I noticed that if I manually change the .reference file to match the actual output, the fast check passes, but then it fails in the actual build.

Please help me out, any response and guidance will be appreciated!

Metadata

Metadata

Assignees

No one assigned

    Labels

    questionQuestion?testingSpecial issue with list of bugs found by CI

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions