fixed test

mkmkme · mkmkme · commit 6da3227f71a5 · 2026-03-18T16:05:52.000+01:00
add_minmax_index_for_numeric_columns is unavailable on 24.8. Also, some
lines in reference are different or missing.
diff --git a/tests/queries/0_stateless/03822_alias_column_skip_index_no_merge.reference b/tests/queries/0_stateless/03822_alias_column_skip_index_no_merge.reference
@@ -7,19 +7,16 @@ Expression (Project names)
           ReadFromMergeTree (default.test_alias_skip_idx)
           Indexes:
             PrimaryKey
-              Keys:
+              Keys: 
                 c
               Condition: (plus(c, 1) in [101, +Inf))
               Parts: 1/2
               Granules: 1/2
-              Search Algorithm: generic exclusion search
             Skip
               Name: idx_a
               Description: minmax GRANULARITY 1
-              Condition: (plus(c, 1) in [101, +Inf))
               Parts: 1/1
               Granules: 1/1
-            Ranges: 1
 enable_optimizations=0
 Expression (Project names)
   Expression (Projection)
@@ -29,19 +26,16 @@ Expression (Project names)
           ReadFromMergeTree (default.test_alias_skip_idx)
           Indexes:
             PrimaryKey
-              Keys:
+              Keys: 
                 c
               Condition: (plus(c, 1) in [101, +Inf))
               Parts: 1/2
               Granules: 1/2
-              Search Algorithm: generic exclusion search
             Skip
               Name: idx_a
               Description: minmax GRANULARITY 1
-              Condition: (plus(c, 1) in [101, +Inf))
               Parts: 1/1
               Granules: 1/1
-            Ranges: 1
 nested_alias
 Expression (Project names)
   Expression (Projection)
@@ -51,35 +45,29 @@ Expression (Project names)
           ReadFromMergeTree (default.test_nested_alias_idx)
           Indexes:
             PrimaryKey
-              Keys:
+              Keys: 
                 c
               Condition: (plus(plus(c, 1), 1) in [101, +Inf))
               Parts: 1/2
               Granules: 1/2
-              Search Algorithm: generic exclusion search
             Skip
               Name: idx_a2
               Description: minmax GRANULARITY 1
-              Condition: (plus(plus(c, 1), 1) in [101, +Inf))
               Parts: 1/1
               Granules: 1/1
-            Ranges: 1
 default_settings
 Expression ((Project names + Projection))
   Filter ((WHERE + (Change column names to column identifiers + Compute alias columns)))
     ReadFromMergeTree (default.test_alias_skip_idx)
     Indexes:
       PrimaryKey
-        Keys:
+        Keys: 
           c
         Condition: (plus(c, 1) in [101, +Inf))
         Parts: 1/2
         Granules: 1/2
-        Search Algorithm: generic exclusion search
       Skip
         Name: idx_a
         Description: minmax GRANULARITY 1
-        Condition: (plus(c, 1) in [101, +Inf))
         Parts: 1/1
         Granules: 1/1
-      Ranges: 1
diff --git a/tests/queries/0_stateless/03822_alias_column_skip_index_no_merge.sql b/tests/queries/0_stateless/03822_alias_column_skip_index_no_merge.sql
@@ -16,7 +16,7 @@ CREATE TABLE test_alias_skip_idx
 )
 ENGINE = MergeTree
 ORDER BY c
-SETTINGS index_granularity = 8192, add_minmax_index_for_numeric_columns = 0;
+SETTINGS index_granularity = 8192;
 
 INSERT INTO test_alias_skip_idx SELECT number FROM numbers(10);
 INSERT INTO test_alias_skip_idx SELECT number + 200 FROM numbers(10);
@@ -43,7 +43,7 @@ CREATE TABLE test_nested_alias_idx
 )
 ENGINE = MergeTree
 ORDER BY c
-SETTINGS index_granularity = 8192, add_minmax_index_for_numeric_columns = 0;
+SETTINGS index_granularity = 8192;
 
 INSERT INTO test_nested_alias_idx SELECT number FROM numbers(10);
 INSERT INTO test_nested_alias_idx SELECT number + 200 FROM numbers(10);
