Skip to content

Commit fea3d44

Browse files
csun5285claude
csun5285
and
claude
authored
[fix](variant) clamp variant_sparse_hash_shard_count to >=1 in SHOW CREATE output (apache#63661)
Variant columns default variant_sparse_hash_shard_count to 0 internally. SHOW CREATE TABLE used to emit `"variant_sparse_hash_shard_count" = "0"`, which older Doris versions reject (range was [1, 1024]) when the same DDL is fed back through CREATE TABLE LIKE: errCode = 2, detailMessage = variant_sparse_hash_shard_count format error: ... must between 1 and 1024 Clamp the serialized value with Math.max(1, count) in both nereids.types.VariantType and catalog.VariantType so the emitted DDL is accepted by old and new versions. Existing parsing logic on master already allows 0, so internal behaviour is unchanged. Update the affected SHOW CREATE / DESC golden .out files to match the new emitted value. Add a regression suite covering the CREATE TABLE -> CREATE TABLE LIKE round-trip on a variant column with default properties. ### What problem does this PR solve? Issue Number: close #xxx Related PR: #xxx Problem Summary: ### Release note None ### Check List (For Author) - Test <!-- At least one of them must be included. --> - [x] Regression test - [ ] Unit Test - [ ] Manual test (add detailed scripts or steps below) - [ ] No need to test or manual test. Explain why: - [ ] This is a refactor/code format and no logic has been changed. - [ ] Previous test can cover this change. - [ ] No code files have been changed. - [ ] Other reason <!-- Add your reason? --> - Behavior changed: - [ ] No. - [ ] Yes. <!-- Explain the behavior change --> - Does this need documentation? - [ ] No. - [ ] Yes. <!-- Add document PR link here. eg: apache/doris-website#1214 --> ### Check List (For Reviewer who merge this PR) - [ ] Confirm the release note - [ ] Confirm test cases - [ ] Confirm document - [ ] Add branch pick label <!-- Add branch pick label that this PR should merge into --> Co-authored-by: Claude Opus 4.7 (1M context) <noreply@anthropic.com>
1 parent 1aa32e4 commit fea3d44

7 files changed

Lines changed: 99 additions & 38 deletions

File tree

‎fe/fe-core/src/main/java/org/apache/doris/nereids/types/VariantType.java‎

Lines changed: 2 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -181,8 +181,9 @@ public String toSql() {
181181
.append(String.valueOf(variantMaxSparseColumnStatisticsSize))
182182
.append("\"");
183183
sb.append(",");
184+
// Output at least 1 for backward compatibility: old data without this parameter defaults to 0
184185
sb.append("\"variant_sparse_hash_shard_count\" = \"")
185-
.append(String.valueOf(variantSparseHashShardCount))
186+
.append(String.valueOf(Math.max(1, variantSparseHashShardCount)))
186187
.append("\"");
187188
}
188189
if (enableNestedGroup) {

‎fe/fe-type/src/main/java/org/apache/doris/catalog/VariantType.java‎

Lines changed: 2 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -183,8 +183,9 @@ public String toSql(int depth) {
183183
sb.append("\"variant_max_sparse_column_statistics_size\" = \"")
184184
.append(String.valueOf(variantMaxSparseColumnStatisticsSize)).append("\"");
185185
sb.append(",");
186+
// Output at least 1 for backward compatibility: old data without this parameter defaults to 0
186187
sb.append("\"variant_sparse_hash_shard_count\" = \"")
187-
.append(String.valueOf(variantSparseHashShardCount)).append("\"");
188+
.append(String.valueOf(Math.max(1, variantSparseHashShardCount))).append("\"");
188189
}
189190
sb.append(")>");
190191
return sb.toString();

‎regression-test/data/datatype_p0/nested_types/ddl/create_nestedtypes_with_schemachange.out‎

Lines changed: 6 additions & 6 deletions
Original file line numberDiff line numberDiff line change
@@ -53,7 +53,7 @@ col2 int No false \N NONE
5353
col3 array<int> Yes false \N NONE
5454
col4 map<int,int> Yes false \N NONE
5555
col5 struct<f1:int> Yes false \N NONE
56-
col6 variant<PROPERTIES ("variant_max_subcolumns_count" = "0","variant_enable_typed_paths_to_sparse" = "false","variant_max_sparse_column_statistics_size" = "0","variant_sparse_hash_shard_count" = "0")> Yes false \N NONE
56+
col6 variant<PROPERTIES ("variant_max_subcolumns_count" = "0","variant_enable_typed_paths_to_sparse" = "false","variant_max_sparse_column_statistics_size" = "0","variant_sparse_hash_shard_count" = "1")> Yes false \N NONE
5757

5858
-- !sql_after --
5959
1 2 [1, 2] {1:2} {"f1":1} {"a":[1, 2, 3]}
@@ -67,7 +67,7 @@ col2 int No false \N NONE
6767
col3 array<int> Yes false \N NONE
6868
col4 map<int,int> No false \N NONE
6969
col5 struct<f1:int> No false \N NONE
70-
col6 variant<PROPERTIES ("variant_max_subcolumns_count" = "0","variant_enable_typed_paths_to_sparse" = "false","variant_max_sparse_column_statistics_size" = "0","variant_sparse_hash_shard_count" = "0")> No false \N NONE
70+
col6 variant<PROPERTIES ("variant_max_subcolumns_count" = "0","variant_enable_typed_paths_to_sparse" = "false","variant_max_sparse_column_statistics_size" = "0","variant_sparse_hash_shard_count" = "1")> No false \N NONE
7171

7272
-- !sql_after --
7373
1 2 [1, 2] {1:2} {"f1":1} {"a":[1, 2, 3]}
@@ -81,7 +81,7 @@ col2 int No false \N NONE
8181
col3 array<int> Yes false \N NONE
8282
col4 map<int,int> Yes false \N NONE
8383
col5 struct<f1:int> Yes false \N NONE
84-
col6 variant<PROPERTIES ("variant_max_subcolumns_count" = "0","variant_enable_typed_paths_to_sparse" = "false","variant_max_sparse_column_statistics_size" = "0","variant_sparse_hash_shard_count" = "0")> Yes false \N NONE
84+
col6 variant<PROPERTIES ("variant_max_subcolumns_count" = "0","variant_enable_typed_paths_to_sparse" = "false","variant_max_sparse_column_statistics_size" = "0","variant_sparse_hash_shard_count" = "1")> Yes false \N NONE
8585

8686
-- !sql_after --
8787
1 2 [1, 2] {1:2} {"f1":1} {"a":[1, 2, 3]}
@@ -95,7 +95,7 @@ col2 int No false \N NONE
9595
col3 array<int> No false \N NONE
9696
col4 map<int,int> Yes false \N NONE
9797
col5 struct<f1:int> No false \N NONE
98-
col6 variant<PROPERTIES ("variant_max_subcolumns_count" = "0","variant_enable_typed_paths_to_sparse" = "false","variant_max_sparse_column_statistics_size" = "0","variant_sparse_hash_shard_count" = "0")> No false \N NONE
98+
col6 variant<PROPERTIES ("variant_max_subcolumns_count" = "0","variant_enable_typed_paths_to_sparse" = "false","variant_max_sparse_column_statistics_size" = "0","variant_sparse_hash_shard_count" = "1")> No false \N NONE
9999

100100
-- !sql_after --
101101
1 2 [1, 2] {1:2} {"f1":1} {"a":[1, 2, 3]}
@@ -109,7 +109,7 @@ col2 int No false \N NONE
109109
col3 array<int> Yes false \N NONE
110110
col4 map<int,int> Yes false \N NONE
111111
col5 struct<f1:int> Yes false \N NONE
112-
col6 variant<PROPERTIES ("variant_max_subcolumns_count" = "0","variant_enable_typed_paths_to_sparse" = "false","variant_max_sparse_column_statistics_size" = "0","variant_sparse_hash_shard_count" = "0")> Yes false \N NONE
112+
col6 variant<PROPERTIES ("variant_max_subcolumns_count" = "0","variant_enable_typed_paths_to_sparse" = "false","variant_max_sparse_column_statistics_size" = "0","variant_sparse_hash_shard_count" = "1")> Yes false \N NONE
113113

114114
-- !sql_after --
115115
1 2 [1, 2] {1:2} {"f1":1} {"a":[1, 2, 3]}
@@ -123,7 +123,7 @@ col2 int No false \N NONE
123123
col3 array<int> No false \N NONE
124124
col4 map<int,int> No false \N NONE
125125
col5 struct<f1:int> Yes false \N NONE
126-
col6 variant<PROPERTIES ("variant_max_subcolumns_count" = "0","variant_enable_typed_paths_to_sparse" = "false","variant_max_sparse_column_statistics_size" = "0","variant_sparse_hash_shard_count" = "0")> No false \N NONE
126+
col6 variant<PROPERTIES ("variant_max_subcolumns_count" = "0","variant_enable_typed_paths_to_sparse" = "false","variant_max_sparse_column_statistics_size" = "0","variant_sparse_hash_shard_count" = "1")> No false \N NONE
127127

128128
-- !sql_after --
129129
1 2 [1, 2] {1:2} {"f1":1} {"a":[1, 2, 3]}

‎regression-test/data/variant_p0/desc.out‎

Lines changed: 25 additions & 25 deletions
Original file line numberDiff line numberDiff line change
@@ -1,19 +1,19 @@
11
-- This file is automatically generated. You should know what you did if you want to edit this
22
-- !sql_1 --
33
k bigint Yes true \N
4-
v variant<PROPERTIES ("variant_max_subcolumns_count" = "2","variant_enable_typed_paths_to_sparse" = "false","variant_max_sparse_column_statistics_size" = "10000","variant_sparse_hash_shard_count" = "0")> Yes false \N NONE
4+
v variant<PROPERTIES ("variant_max_subcolumns_count" = "2","variant_enable_typed_paths_to_sparse" = "false","variant_max_sparse_column_statistics_size" = "10000","variant_sparse_hash_shard_count" = "1")> Yes false \N NONE
55
v.a bigint Yes false \N NONE
66
v.xxxx text Yes false \N NONE
77

88
-- !sql_2 --
99
k bigint Yes true \N
10-
v variant<PROPERTIES ("variant_max_subcolumns_count" = "2","variant_enable_typed_paths_to_sparse" = "false","variant_max_sparse_column_statistics_size" = "10000","variant_sparse_hash_shard_count" = "0")> Yes false \N NONE
10+
v variant<PROPERTIES ("variant_max_subcolumns_count" = "2","variant_enable_typed_paths_to_sparse" = "false","variant_max_sparse_column_statistics_size" = "10000","variant_sparse_hash_shard_count" = "1")> Yes false \N NONE
1111
v.a bigint Yes false \N NONE
1212
v.ddd.mxmxm array<json> Yes false \N NONE
1313

1414
-- !sql_3 --
1515
k bigint Yes true \N
16-
v variant<PROPERTIES ("variant_max_subcolumns_count" = "0","variant_enable_typed_paths_to_sparse" = "false","variant_max_sparse_column_statistics_size" = "10000","variant_sparse_hash_shard_count" = "0")> Yes false \N NONE
16+
v variant<PROPERTIES ("variant_max_subcolumns_count" = "0","variant_enable_typed_paths_to_sparse" = "false","variant_max_sparse_column_statistics_size" = "10000","variant_sparse_hash_shard_count" = "1")> Yes false \N NONE
1717
v.a bigint Yes false \N NONE
1818
v.b json Yes false \N NONE
1919
v.c.c bigint Yes false \N NONE
@@ -22,7 +22,7 @@ v.xxxx text Yes false \N NONE
2222

2323
-- !sql_6_1 --
2424
k bigint Yes true \N
25-
v variant<PROPERTIES ("variant_max_subcolumns_count" = "0","variant_enable_typed_paths_to_sparse" = "false","variant_max_sparse_column_statistics_size" = "10000","variant_sparse_hash_shard_count" = "0")> Yes false \N NONE
25+
v variant<PROPERTIES ("variant_max_subcolumns_count" = "0","variant_enable_typed_paths_to_sparse" = "false","variant_max_sparse_column_statistics_size" = "10000","variant_sparse_hash_shard_count" = "1")> Yes false \N NONE
2626
v.a bigint Yes false \N NONE
2727
v.b json Yes false \N NONE
2828
v.c.c bigint Yes false \N NONE
@@ -34,7 +34,7 @@ v.xxxx text Yes false \N NONE
3434

3535
-- !sql_6_2 --
3636
k bigint Yes true \N
37-
v variant<PROPERTIES ("variant_max_subcolumns_count" = "0","variant_enable_typed_paths_to_sparse" = "false","variant_max_sparse_column_statistics_size" = "10000","variant_sparse_hash_shard_count" = "0")> Yes false \N NONE
37+
v variant<PROPERTIES ("variant_max_subcolumns_count" = "0","variant_enable_typed_paths_to_sparse" = "false","variant_max_sparse_column_statistics_size" = "10000","variant_sparse_hash_shard_count" = "1")> Yes false \N NONE
3838
v.a bigint Yes false \N NONE
3939
v.b json Yes false \N NONE
4040
v.c.c bigint Yes false \N NONE
@@ -43,15 +43,15 @@ v.xxxx text Yes false \N NONE
4343

4444
-- !sql_6_3 --
4545
k bigint Yes true \N
46-
v variant<PROPERTIES ("variant_max_subcolumns_count" = "0","variant_enable_typed_paths_to_sparse" = "false","variant_max_sparse_column_statistics_size" = "10000","variant_sparse_hash_shard_count" = "0")> Yes false \N NONE
46+
v variant<PROPERTIES ("variant_max_subcolumns_count" = "0","variant_enable_typed_paths_to_sparse" = "false","variant_max_sparse_column_statistics_size" = "10000","variant_sparse_hash_shard_count" = "1")> Yes false \N NONE
4747
v.a bigint Yes false \N NONE
4848
v.b json Yes false \N NONE
4949
v.c.c bigint Yes false \N NONE
5050
v.c.e double Yes false \N NONE
5151

5252
-- !sql_6 --
5353
k bigint Yes true \N
54-
v variant<PROPERTIES ("variant_max_subcolumns_count" = "0","variant_enable_typed_paths_to_sparse" = "false","variant_max_sparse_column_statistics_size" = "10000","variant_sparse_hash_shard_count" = "0")> Yes false \N NONE
54+
v variant<PROPERTIES ("variant_max_subcolumns_count" = "0","variant_enable_typed_paths_to_sparse" = "false","variant_max_sparse_column_statistics_size" = "10000","variant_sparse_hash_shard_count" = "1")> Yes false \N NONE
5555
v.a bigint Yes false \N NONE
5656
v.b json Yes false \N NONE
5757
v.c.c bigint Yes false \N NONE
@@ -63,7 +63,7 @@ v.xxxx text Yes false \N NONE
6363

6464
-- !sql_7 --
6565
k bigint Yes true \N
66-
v variant<PROPERTIES ("variant_max_subcolumns_count" = "0","variant_enable_typed_paths_to_sparse" = "false","variant_max_sparse_column_statistics_size" = "10000","variant_sparse_hash_shard_count" = "0")> Yes false \N NONE
66+
v variant<PROPERTIES ("variant_max_subcolumns_count" = "0","variant_enable_typed_paths_to_sparse" = "false","variant_max_sparse_column_statistics_size" = "10000","variant_sparse_hash_shard_count" = "1")> Yes false \N NONE
6767
v.a bigint Yes false \N NONE
6868
v.b json Yes false \N NONE
6969
v.c.c bigint Yes false \N NONE
@@ -72,21 +72,21 @@ v.xxxx text Yes false \N NONE
7272

7373
-- !sql_7_1 --
7474
k bigint Yes true \N
75-
v variant<PROPERTIES ("variant_max_subcolumns_count" = "0","variant_enable_typed_paths_to_sparse" = "false","variant_max_sparse_column_statistics_size" = "10000","variant_sparse_hash_shard_count" = "0")> Yes false \N NONE
75+
v variant<PROPERTIES ("variant_max_subcolumns_count" = "0","variant_enable_typed_paths_to_sparse" = "false","variant_max_sparse_column_statistics_size" = "10000","variant_sparse_hash_shard_count" = "1")> Yes false \N NONE
7676
v.a bigint Yes false \N NONE
7777
v.xxxx text Yes false \N NONE
7878

7979
-- !sql_7_2 --
8080
k bigint Yes true \N
81-
v variant<PROPERTIES ("variant_max_subcolumns_count" = "0","variant_enable_typed_paths_to_sparse" = "false","variant_max_sparse_column_statistics_size" = "10000","variant_sparse_hash_shard_count" = "0")> Yes false \N NONE
81+
v variant<PROPERTIES ("variant_max_subcolumns_count" = "0","variant_enable_typed_paths_to_sparse" = "false","variant_max_sparse_column_statistics_size" = "10000","variant_sparse_hash_shard_count" = "1")> Yes false \N NONE
8282
v.a bigint Yes false \N NONE
8383
v.b json Yes false \N NONE
8484
v.c.c bigint Yes false \N NONE
8585
v.c.e double Yes false \N NONE
8686

8787
-- !sql_7_3 --
8888
k bigint Yes true \N
89-
v variant<PROPERTIES ("variant_max_subcolumns_count" = "0","variant_enable_typed_paths_to_sparse" = "false","variant_max_sparse_column_statistics_size" = "10000","variant_sparse_hash_shard_count" = "0")> Yes false \N NONE
89+
v variant<PROPERTIES ("variant_max_subcolumns_count" = "0","variant_enable_typed_paths_to_sparse" = "false","variant_max_sparse_column_statistics_size" = "10000","variant_sparse_hash_shard_count" = "1")> Yes false \N NONE
9090
v.a bigint Yes false \N NONE
9191
v.b json Yes false \N NONE
9292
v.c.c bigint Yes false \N NONE
@@ -95,9 +95,9 @@ v.xxxx text Yes false \N NONE
9595

9696
-- !sql_8 --
9797
k bigint Yes true \N
98-
v1 variant<PROPERTIES ("variant_max_subcolumns_count" = "0","variant_enable_typed_paths_to_sparse" = "false","variant_max_sparse_column_statistics_size" = "10000","variant_sparse_hash_shard_count" = "0")> Yes false \N NONE
99-
v2 variant<PROPERTIES ("variant_max_subcolumns_count" = "0","variant_enable_typed_paths_to_sparse" = "false","variant_max_sparse_column_statistics_size" = "10000","variant_sparse_hash_shard_count" = "0")> Yes false \N NONE
100-
v3 variant<PROPERTIES ("variant_max_subcolumns_count" = "0","variant_enable_typed_paths_to_sparse" = "false","variant_max_sparse_column_statistics_size" = "10000","variant_sparse_hash_shard_count" = "0")> Yes false \N NONE
98+
v1 variant<PROPERTIES ("variant_max_subcolumns_count" = "0","variant_enable_typed_paths_to_sparse" = "false","variant_max_sparse_column_statistics_size" = "10000","variant_sparse_hash_shard_count" = "1")> Yes false \N NONE
99+
v2 variant<PROPERTIES ("variant_max_subcolumns_count" = "0","variant_enable_typed_paths_to_sparse" = "false","variant_max_sparse_column_statistics_size" = "10000","variant_sparse_hash_shard_count" = "1")> Yes false \N NONE
100+
v3 variant<PROPERTIES ("variant_max_subcolumns_count" = "0","variant_enable_typed_paths_to_sparse" = "false","variant_max_sparse_column_statistics_size" = "10000","variant_sparse_hash_shard_count" = "1")> Yes false \N NONE
101101
v1.a bigint Yes false \N NONE
102102
v1.b json Yes false \N NONE
103103
v1.c.c bigint Yes false \N NONE
@@ -112,11 +112,11 @@ v3.c.e double Yes false \N NONE
112112

113113
-- !sql_9 --
114114
k bigint Yes true \N
115-
v variant<PROPERTIES ("variant_max_subcolumns_count" = "0","variant_enable_typed_paths_to_sparse" = "false","variant_max_sparse_column_statistics_size" = "10000","variant_sparse_hash_shard_count" = "0")> Yes false \N NONE
115+
v variant<PROPERTIES ("variant_max_subcolumns_count" = "0","variant_enable_typed_paths_to_sparse" = "false","variant_max_sparse_column_statistics_size" = "10000","variant_sparse_hash_shard_count" = "1")> Yes false \N NONE
116116

117117
-- !sql_9_1 --
118118
k bigint Yes true \N
119-
v variant<PROPERTIES ("variant_max_subcolumns_count" = "0","variant_enable_typed_paths_to_sparse" = "false","variant_max_sparse_column_statistics_size" = "10000","variant_sparse_hash_shard_count" = "0")> Yes false \N NONE
119+
v variant<PROPERTIES ("variant_max_subcolumns_count" = "0","variant_enable_typed_paths_to_sparse" = "false","variant_max_sparse_column_statistics_size" = "10000","variant_sparse_hash_shard_count" = "1")> Yes false \N NONE
120120
v.a bigint Yes false \N NONE
121121
v.b json Yes false \N NONE
122122
v.c.c bigint Yes false \N NONE
@@ -125,7 +125,7 @@ v.oooo.xxxx.xxx bigint Yes false \N NONE
125125

126126
-- !sql_10 --
127127
k bigint Yes true \N
128-
v variant<PROPERTIES ("variant_max_subcolumns_count" = "0","variant_enable_typed_paths_to_sparse" = "false","variant_max_sparse_column_statistics_size" = "10000","variant_sparse_hash_shard_count" = "0")> Yes false \N NONE
128+
v variant<PROPERTIES ("variant_max_subcolumns_count" = "0","variant_enable_typed_paths_to_sparse" = "false","variant_max_sparse_column_statistics_size" = "10000","variant_sparse_hash_shard_count" = "1")> Yes false \N NONE
129129
v.k1 bigint Yes false \N NONE
130130
v.k2 text Yes false \N NONE
131131
v.k3 array<bigint> Yes false \N NONE
@@ -134,8 +134,8 @@ v.k5 json Yes false \N NONE
134134

135135
-- !sql_10_1 --
136136
k bigint Yes true \N
137-
v variant<PROPERTIES ("variant_max_subcolumns_count" = "0","variant_enable_typed_paths_to_sparse" = "false","variant_max_sparse_column_statistics_size" = "10000","variant_sparse_hash_shard_count" = "0")> Yes false \N NONE
138-
v2 variant<PROPERTIES ("variant_max_subcolumns_count" = "0","variant_enable_typed_paths_to_sparse" = "false","variant_max_sparse_column_statistics_size" = "10000","variant_sparse_hash_shard_count" = "0")> Yes false \N NONE
137+
v variant<PROPERTIES ("variant_max_subcolumns_count" = "0","variant_enable_typed_paths_to_sparse" = "false","variant_max_sparse_column_statistics_size" = "10000","variant_sparse_hash_shard_count" = "1")> Yes false \N NONE
138+
v2 variant<PROPERTIES ("variant_max_subcolumns_count" = "0","variant_enable_typed_paths_to_sparse" = "false","variant_max_sparse_column_statistics_size" = "10000","variant_sparse_hash_shard_count" = "1")> Yes false \N NONE
139139
v.a bigint Yes false \N NONE
140140
v.b json Yes false \N NONE
141141
v.c.c bigint Yes false \N NONE
@@ -154,7 +154,7 @@ v2.oooo.xxxx.xxx bigint Yes false \N NONE
154154

155155
-- !sql_10_2 --
156156
k bigint Yes true \N
157-
v variant<PROPERTIES ("variant_max_subcolumns_count" = "0","variant_enable_typed_paths_to_sparse" = "false","variant_max_sparse_column_statistics_size" = "10000","variant_sparse_hash_shard_count" = "0")> Yes false \N NONE
157+
v variant<PROPERTIES ("variant_max_subcolumns_count" = "0","variant_enable_typed_paths_to_sparse" = "false","variant_max_sparse_column_statistics_size" = "10000","variant_sparse_hash_shard_count" = "1")> Yes false \N NONE
158158
v.a bigint Yes false \N NONE
159159
v.b json Yes false \N NONE
160160
v.c.c bigint Yes false \N NONE
@@ -173,8 +173,8 @@ v2.oooo.xxxx.xxx bigint Yes false \N NONE
173173

174174
-- !sql_10_3 --
175175
k bigint Yes true \N
176-
v variant<PROPERTIES ("variant_max_subcolumns_count" = "0","variant_enable_typed_paths_to_sparse" = "false","variant_max_sparse_column_statistics_size" = "10000","variant_sparse_hash_shard_count" = "0")> Yes false \N NONE
177-
v3 variant<PROPERTIES ("variant_max_subcolumns_count" = "0","variant_enable_typed_paths_to_sparse" = "false","variant_max_sparse_column_statistics_size" = "10000","variant_sparse_hash_shard_count" = "0")> Yes false \N NONE
176+
v variant<PROPERTIES ("variant_max_subcolumns_count" = "0","variant_enable_typed_paths_to_sparse" = "false","variant_max_sparse_column_statistics_size" = "10000","variant_sparse_hash_shard_count" = "1")> Yes false \N NONE
177+
v3 variant<PROPERTIES ("variant_max_subcolumns_count" = "0","variant_enable_typed_paths_to_sparse" = "false","variant_max_sparse_column_statistics_size" = "10000","variant_sparse_hash_shard_count" = "1")> Yes false \N NONE
178178
v.a bigint Yes false \N NONE
179179
v.b json Yes false \N NONE
180180
v.c.c bigint Yes false \N NONE
@@ -193,7 +193,7 @@ v3.oooo.xxxx.xxx bigint Yes false \N NONE
193193

194194
-- !sql_11 --
195195
k bigint Yes true \N
196-
v variant<PROPERTIES ("variant_max_subcolumns_count" = "0","variant_enable_typed_paths_to_sparse" = "false","variant_max_sparse_column_statistics_size" = "10000","variant_sparse_hash_shard_count" = "0")> Yes false \N NONE
196+
v variant<PROPERTIES ("variant_max_subcolumns_count" = "0","variant_enable_typed_paths_to_sparse" = "false","variant_max_sparse_column_statistics_size" = "10000","variant_sparse_hash_shard_count" = "1")> Yes false \N NONE
197197
v.!@#^&*() text Yes false \N NONE
198198
v.名字 text Yes false \N NONE
199199
v.画像.丬文 text Yes false \N NONE
@@ -202,11 +202,11 @@ v.金额 bigint Yes false \N NONE
202202

203203
-- !sql_12 --
204204
k bigint Yes true \N
205-
v variant<PROPERTIES ("variant_max_subcolumns_count" = "0","variant_enable_typed_paths_to_sparse" = "false","variant_max_sparse_column_statistics_size" = "10000","variant_sparse_hash_shard_count" = "0")> Yes false \N NONE
205+
v variant<PROPERTIES ("variant_max_subcolumns_count" = "0","variant_enable_typed_paths_to_sparse" = "false","variant_max_sparse_column_statistics_size" = "10000","variant_sparse_hash_shard_count" = "1")> Yes false \N NONE
206206

207207
-- !sql15 --
208208
k bigint Yes true \N
209-
v variant<PROPERTIES ("variant_max_subcolumns_count" = "0","variant_enable_typed_paths_to_sparse" = "false","variant_max_sparse_column_statistics_size" = "10000","variant_sparse_hash_shard_count" = "0")> Yes false \N NONE
209+
v variant<PROPERTIES ("variant_max_subcolumns_count" = "0","variant_enable_typed_paths_to_sparse" = "false","variant_max_sparse_column_statistics_size" = "10000","variant_sparse_hash_shard_count" = "1")> Yes false \N NONE
210210
v.a bigint Yes false \N NONE
211211
v.b bigint Yes false \N NONE
212212
v.c bigint Yes false \N NONE

0 commit comments

Comments
 (0)