eldenmoon commented on code in PR #53092:
URL: https://github.com/apache/doris/pull/53092#discussion_r2206195705
##########
regression-test/suites/variant_p0/predefine/test_predefine_ddl.groovy:
##########
@@ -311,4 +311,25 @@ PROPERTIES (
BUCKETS 1 PROPERTIES ( "replication_allocation" =
"tag.location.default: 1")"""
exception("The variant_max_subcolumns_count must either be 0 in all
columns, or greater than 0 in all columns")
}
+
+ sql "DROP TABLE IF EXISTS test_ddl_table"
+ sql "set global_variant_max_subcolumns_count = 10"
+ sql "set global_variant_enable_typed_paths_to_sparse = false"
+ sql """CREATE TABLE test_ddl_table (
+ `id` bigint NULL,
+ `var` variant NULL
+ ) ENGINE=OLAP DUPLICATE KEY(`id`) DISTRIBUTED BY HASH(`id`)
+ BUCKETS 1 PROPERTIES ( "replication_allocation" = "tag.location.default:
1")"""
+
+ qt_sql "desc test_ddl_table"
+
+ sql "DROP TABLE IF EXISTS test_ddl_table"
+ sql """CREATE TABLE test_ddl_table (
+ `id` bigint NULL,
+ `var` variant NULL,
+ INDEX idx_ab (var) USING INVERTED PROPERTIES("parser"="unicode",
"support_phrase" = "true") COMMENT ''
+ ) ENGINE=OLAP DUPLICATE KEY(`id`) DISTRIBUTED BY HASH(`id`)
+ BUCKETS 1 PROPERTIES ( "replication_allocation" = "tag.location.default:
1")"""
+
+ sql "create index idx_ab2 on test_ddl_table (var) using inverted"
Review Comment:
p2 cases?
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
