This is an automated email from the ASF dual-hosted git repository.
morrysnow pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/doris.git
The following commit(s) were added to refs/heads/master by this push:
new 6085a61f1ea [chore](test) correct create table statement (#28863)
6085a61f1ea is described below
commit 6085a61f1eafd6f41dfd7b83aa15df61f4804d69
Author: starocean999 <[email protected]>
AuthorDate: Mon Dec 25 10:55:35 2023 +0800
[chore](test) correct create table statement (#28863)
---
regression-test/suites/correctness/test_in_null.groovy | 2 +-
regression-test/suites/correctness_p0/test_many_inlineview.groovy | 2 +-
regression-test/suites/ddl_p0/test_ctas.groovy | 2 +-
regression-test/suites/delete_p0/test_delete.groovy | 4 ++--
.../suites/external_table_p0/tvf/queries/test_queries_tvf.groovy | 2 +-
regression-test/suites/load_p0/broker_load/ddl/dup_tbl_array.sql | 2 +-
regression-test/suites/load_p0/broker_load/ddl/dup_tbl_basic.sql | 2 +-
regression-test/suites/load_p0/broker_load/ddl/uniq_tbl_array.sql | 2 +-
.../suites/load_p0/http_stream/test_http_stream_json.groovy | 8 ++++----
.../suites/load_p0/routine_load/ddl/dup_tbl_array_create.sql | 2 +-
.../suites/load_p0/routine_load/ddl/dup_tbl_basic_create.sql | 2 +-
.../suites/load_p0/routine_load/ddl/uniq_tbl_array_create.sql | 2 +-
.../suites/load_p0/stream_load/ddl/dup_tbl_array_create.sql | 2 +-
.../suites/load_p0/stream_load/ddl/dup_tbl_basic_create.sql | 2 +-
.../stream_load/ddl/dup_tbl_basic_create_random_bucket.sql | 2 +-
.../suites/load_p0/stream_load/ddl/uniq_tbl_array_create.sql | 2 +-
.../suites/load_p0/stream_load/test_stream_load.groovy | 2 +-
regression-test/suites/load_p0/tvf/ddl/dup_tbl_array_tvf.sql | 2 +-
regression-test/suites/load_p0/tvf/ddl/dup_tbl_basic_tvf.sql | 2 +-
regression-test/suites/load_p0/tvf/ddl/uniq_tbl_array_tvf.sql | 2 +-
.../partition_prune/test_date_function_prune.groovy | 2 +-
.../partition_p0/auto_partition/test_auto_list_partition.groovy | 4 ++--
regression-test/suites/point_query_p0/test_rowstore.groovy | 2 +-
regression-test/suites/query_p0/aggregate/array_agg.groovy | 2 +-
.../suites/query_p0/limit/test_map_select_with_limit.groovy | 2 +-
regression-test/suites/query_p0/sort/sort.groovy | 2 +-
regression-test/suites/query_p0/test_array_orderby_limit.groovy | 2 +-
.../suites/show_p0/test_show_create_table_and_views.groovy | 2 +-
28 files changed, 33 insertions(+), 33 deletions(-)
diff --git a/regression-test/suites/correctness/test_in_null.groovy
b/regression-test/suites/correctness/test_in_null.groovy
index f1e08f38b1b..04b0c9a4bb2 100644
--- a/regression-test/suites/correctness/test_in_null.groovy
+++ b/regression-test/suites/correctness/test_in_null.groovy
@@ -19,7 +19,7 @@ suite("test_in_null") {
sql """ DROP TABLE IF EXISTS db """
sql """
CREATE TABLE IF NOT EXISTS db(
- `id` INT NULL ,
+ `id` INT NULL
) ENGINE=OLAP
DUPLICATE KEY(`id`)
DISTRIBUTED BY HASH(`id`) BUCKETS 1
diff --git a/regression-test/suites/correctness_p0/test_many_inlineview.groovy
b/regression-test/suites/correctness_p0/test_many_inlineview.groovy
index 651b32411e8..810144947cb 100644
--- a/regression-test/suites/correctness_p0/test_many_inlineview.groovy
+++ b/regression-test/suites/correctness_p0/test_many_inlineview.groovy
@@ -56,7 +56,7 @@ suite("test_many_inlineview") {
sql """
CREATE TABLE `ods_drp_xpi_storemain` (
`fID` varchar(300) NOT NULL COMMENT 'ID',
- `fStoreCode` varchar(150) NULL COMMENT '店铺编码',
+ `fStoreCode` varchar(150) NULL COMMENT '店铺编码'
) ENGINE=OLAP
UNIQUE KEY(`fID`)
DISTRIBUTED BY HASH(`fID`) BUCKETS 4
diff --git a/regression-test/suites/ddl_p0/test_ctas.groovy
b/regression-test/suites/ddl_p0/test_ctas.groovy
index 2aaf56ee593..cf0ad869e92 100644
--- a/regression-test/suites/ddl_p0/test_ctas.groovy
+++ b/regression-test/suites/ddl_p0/test_ctas.groovy
@@ -259,7 +259,7 @@ suite("test_ctas") {
`l_varchar` varchar(65533) NULL
) ENGINE=OLAP
DUPLICATE KEY(`l_varchar`)
- COMMENT 'OLAP\'
+ COMMENT 'OLAP'
DISTRIBUTED BY HASH(`l_varchar`) BUCKETS 10
PROPERTIES (
"replication_allocation" = "tag.location.default: 1",
diff --git a/regression-test/suites/delete_p0/test_delete.groovy
b/regression-test/suites/delete_p0/test_delete.groovy
index 9b1b8af64bc..635762a3275 100644
--- a/regression-test/suites/delete_p0/test_delete.groovy
+++ b/regression-test/suites/delete_p0/test_delete.groovy
@@ -255,7 +255,7 @@ suite("test_delete") {
sql """
CREATE TABLE `dwd_pay` (
`tenant_id` int(11) DEFAULT NULL COMMENT '租户ID',
- `pay_time` datetime DEFAULT NULL COMMENT '付款时间',
+ `pay_time` datetime DEFAULT NULL COMMENT '付款时间'
) ENGINE=OLAP
DUPLICATE KEY(`tenant_id`)
COMMENT "付款明细"
@@ -308,7 +308,7 @@ suite("test_delete") {
col_10 datetime,
col_11 boolean,
col_12 decimalv2(10,3),
- col_8 string,
+ col_8 string
) ENGINE=OLAP
duplicate KEY(`col_1`, col_2, col_3, col_4, col_5, col_6, col_7,
col_9, col_10, col_11, col_12)
COMMENT 'OLAP'
diff --git
a/regression-test/suites/external_table_p0/tvf/queries/test_queries_tvf.groovy
b/regression-test/suites/external_table_p0/tvf/queries/test_queries_tvf.groovy
index 95cd0d3aaca..7594b4bd7b5 100644
---
a/regression-test/suites/external_table_p0/tvf/queries/test_queries_tvf.groovy
+++
b/regression-test/suites/external_table_p0/tvf/queries/test_queries_tvf.groovy
@@ -22,7 +22,7 @@ suite("test_queries_tvf","p0,external,tvf,external_docker") {
CREATE TABLE IF NOT EXISTS ${table_name} (
`user_id` LARGEINT NOT NULL COMMENT "用户id",
`name` STRING COMMENT "用户名称",
- `age` INT COMMENT "用户年龄",
+ `age` INT COMMENT "用户年龄"
)
DISTRIBUTED BY HASH(user_id) PROPERTIES("replication_num" = "1");
"""
diff --git a/regression-test/suites/load_p0/broker_load/ddl/dup_tbl_array.sql
b/regression-test/suites/load_p0/broker_load/ddl/dup_tbl_array.sql
index d9c31be6658..36763c13b84 100644
--- a/regression-test/suites/load_p0/broker_load/ddl/dup_tbl_array.sql
+++ b/regression-test/suites/load_p0/broker_load/ddl/dup_tbl_array.sql
@@ -33,7 +33,7 @@ CREATE TABLE dup_tbl_array
kd13 array<DATEV2> NOT NULL DEFAULT "[]",
kd14 array<DATETIMEV2> NOT NULL DEFAULT "[]",
kd15 array<CHAR> NOT NULL DEFAULT "[]",
- kd16 array<VARCHAR> NOT NULL DEFAULT "[]",
+ kd16 array<VARCHAR> NOT NULL DEFAULT "[]"
)
DUPLICATE KEY(k00)
DISTRIBUTED BY HASH(k00) BUCKETS 32
diff --git a/regression-test/suites/load_p0/broker_load/ddl/dup_tbl_basic.sql
b/regression-test/suites/load_p0/broker_load/ddl/dup_tbl_basic.sql
index 0fa50ada8e4..cd0ea4b0e80 100644
--- a/regression-test/suites/load_p0/broker_load/ddl/dup_tbl_basic.sql
+++ b/regression-test/suites/load_p0/broker_load/ddl/dup_tbl_basic.sql
@@ -48,7 +48,7 @@ CREATE TABLE dup_tbl_basic
INDEX idx_ngrambf_k117 (`k17`) USING NGRAM_BF PROPERTIES("gram_size"="3",
"bf_size"="256"),
INDEX idx_bitmap_k104 (`k02`) USING BITMAP,
- INDEX idx_bitmap_k110 (`kd01`) USING BITMAP,
+ INDEX idx_bitmap_k110 (`kd01`) USING BITMAP
)
DUPLICATE KEY(k00)
diff --git a/regression-test/suites/load_p0/broker_load/ddl/uniq_tbl_array.sql
b/regression-test/suites/load_p0/broker_load/ddl/uniq_tbl_array.sql
index 69e166aa523..9e0d48e39d5 100644
--- a/regression-test/suites/load_p0/broker_load/ddl/uniq_tbl_array.sql
+++ b/regression-test/suites/load_p0/broker_load/ddl/uniq_tbl_array.sql
@@ -34,7 +34,7 @@ CREATE TABLE uniq_tbl_array
kd14 array<DATETIMEV2> NOT NULL DEFAULT "[]",
kd15 array<CHAR> NOT NULL DEFAULT "[]",
kd16 array<VARCHAR> NOT NULL DEFAULT "[]",
- kd17 array<STRING> NOT NULL DEFAULT "[]",
+ kd17 array<STRING> NOT NULL DEFAULT "[]"
)
UNIQUE KEY(k00)
DISTRIBUTED BY HASH(k00) BUCKETS 32
diff --git
a/regression-test/suites/load_p0/http_stream/test_http_stream_json.groovy
b/regression-test/suites/load_p0/http_stream/test_http_stream_json.groovy
index 8a4710d0aa6..a2ae83e0342 100644
--- a/regression-test/suites/load_p0/http_stream/test_http_stream_json.groovy
+++ b/regression-test/suites/load_p0/http_stream/test_http_stream_json.groovy
@@ -27,7 +27,7 @@ suite("test_http_stream_json", "p0") {
CREATE TABLE IF NOT EXISTS ${tableName1} (
id int,
city VARCHAR(10),
- code int,
+ code int
)
DISTRIBUTED BY HASH(id) BUCKETS 1
PROPERTIES (
@@ -70,7 +70,7 @@ suite("test_http_stream_json", "p0") {
CREATE TABLE IF NOT EXISTS ${tableName2} (
id int,
city VARCHAR(10),
- code int,
+ code int
)
DISTRIBUTED BY HASH(id) BUCKETS 1
PROPERTIES (
@@ -113,7 +113,7 @@ suite("test_http_stream_json", "p0") {
CREATE TABLE IF NOT EXISTS ${tableName3} (
id int,
city VARCHAR(10),
- code int,
+ code int
)
DISTRIBUTED BY HASH(id) BUCKETS 1
PROPERTIES (
@@ -157,7 +157,7 @@ suite("test_http_stream_json", "p0") {
CREATE TABLE IF NOT EXISTS ${tableName4} (
id int,
city VARCHAR(10),
- code int,
+ code int
)
DISTRIBUTED BY HASH(id) BUCKETS 1
PROPERTIES (
diff --git
a/regression-test/suites/load_p0/routine_load/ddl/dup_tbl_array_create.sql
b/regression-test/suites/load_p0/routine_load/ddl/dup_tbl_array_create.sql
index b0c3a2bd7f3..4c86f6b7c33 100644
--- a/regression-test/suites/load_p0/routine_load/ddl/dup_tbl_array_create.sql
+++ b/regression-test/suites/load_p0/routine_load/ddl/dup_tbl_array_create.sql
@@ -33,7 +33,7 @@ CREATE TABLE routine_load_dup_tbl_array
kd13 array<DATEV2> NOT NULL DEFAULT "[]",
kd14 array<DATETIMEV2> NOT NULL DEFAULT "[]",
kd15 array<CHAR> NOT NULL DEFAULT "[]",
- kd16 array<VARCHAR> NOT NULL DEFAULT "[]",
+ kd16 array<VARCHAR> NOT NULL DEFAULT "[]"
)
DUPLICATE KEY(k00)
DISTRIBUTED BY HASH(k00) BUCKETS 32
diff --git
a/regression-test/suites/load_p0/routine_load/ddl/dup_tbl_basic_create.sql
b/regression-test/suites/load_p0/routine_load/ddl/dup_tbl_basic_create.sql
index 85fa3790184..561f3e66b1d 100644
--- a/regression-test/suites/load_p0/routine_load/ddl/dup_tbl_basic_create.sql
+++ b/regression-test/suites/load_p0/routine_load/ddl/dup_tbl_basic_create.sql
@@ -48,7 +48,7 @@ CREATE TABLE routine_load_dup_tbl_basic
INDEX idx_ngrambf_k117 (`k17`) USING NGRAM_BF PROPERTIES("gram_size"="3",
"bf_size"="256"),
INDEX idx_bitmap_k104 (`k02`) USING BITMAP,
- INDEX idx_bitmap_k110 (`kd01`) USING BITMAP,
+ INDEX idx_bitmap_k110 (`kd01`) USING BITMAP
)
DUPLICATE KEY(k00)
diff --git
a/regression-test/suites/load_p0/routine_load/ddl/uniq_tbl_array_create.sql
b/regression-test/suites/load_p0/routine_load/ddl/uniq_tbl_array_create.sql
index c5b4f07ff87..ea4a4b39eab 100644
--- a/regression-test/suites/load_p0/routine_load/ddl/uniq_tbl_array_create.sql
+++ b/regression-test/suites/load_p0/routine_load/ddl/uniq_tbl_array_create.sql
@@ -34,7 +34,7 @@ CREATE TABLE routine_load_uniq_tbl_array
kd14 array<DATETIMEV2> NOT NULL DEFAULT "[]",
kd15 array<CHAR> NOT NULL DEFAULT "[]",
kd16 array<VARCHAR> NOT NULL DEFAULT "[]",
- kd17 array<STRING> NOT NULL DEFAULT "[]",
+ kd17 array<STRING> NOT NULL DEFAULT "[]"
)
UNIQUE KEY(k00)
DISTRIBUTED BY HASH(k00) BUCKETS 32
diff --git
a/regression-test/suites/load_p0/stream_load/ddl/dup_tbl_array_create.sql
b/regression-test/suites/load_p0/stream_load/ddl/dup_tbl_array_create.sql
index 0277e3368cd..61c471480d6 100644
--- a/regression-test/suites/load_p0/stream_load/ddl/dup_tbl_array_create.sql
+++ b/regression-test/suites/load_p0/stream_load/ddl/dup_tbl_array_create.sql
@@ -33,7 +33,7 @@ CREATE TABLE stream_load_dup_tbl_array
kd13 array<DATEV2> NOT NULL DEFAULT "[]",
kd14 array<DATETIMEV2> NOT NULL DEFAULT "[]",
kd15 array<CHAR> NOT NULL DEFAULT "[]",
- kd16 array<VARCHAR> NOT NULL DEFAULT "[]",
+ kd16 array<VARCHAR> NOT NULL DEFAULT "[]"
)
DUPLICATE KEY(k00)
DISTRIBUTED BY HASH(k00) BUCKETS 32
diff --git
a/regression-test/suites/load_p0/stream_load/ddl/dup_tbl_basic_create.sql
b/regression-test/suites/load_p0/stream_load/ddl/dup_tbl_basic_create.sql
index 57c5c468c83..f81ae5e20ea 100644
--- a/regression-test/suites/load_p0/stream_load/ddl/dup_tbl_basic_create.sql
+++ b/regression-test/suites/load_p0/stream_load/ddl/dup_tbl_basic_create.sql
@@ -48,7 +48,7 @@ CREATE TABLE stream_load_dup_tbl_basic
INDEX idx_ngrambf_k117 (`k17`) USING NGRAM_BF PROPERTIES("gram_size"="3",
"bf_size"="256"),
INDEX idx_bitmap_k104 (`k02`) USING BITMAP,
- INDEX idx_bitmap_k110 (`kd01`) USING BITMAP,
+ INDEX idx_bitmap_k110 (`kd01`) USING BITMAP
)
DUPLICATE KEY(k00)
diff --git
a/regression-test/suites/load_p0/stream_load/ddl/dup_tbl_basic_create_random_bucket.sql
b/regression-test/suites/load_p0/stream_load/ddl/dup_tbl_basic_create_random_bucket.sql
index cbd0fa7e719..9c86eb64745 100644
---
a/regression-test/suites/load_p0/stream_load/ddl/dup_tbl_basic_create_random_bucket.sql
+++
b/regression-test/suites/load_p0/stream_load/ddl/dup_tbl_basic_create_random_bucket.sql
@@ -48,7 +48,7 @@ CREATE TABLE stream_load_dup_tbl_basic_random_bucket
INDEX idx_ngrambf_k117 (`k17`) USING NGRAM_BF PROPERTIES("gram_size"="3",
"bf_size"="256"),
INDEX idx_bitmap_k104 (`k02`) USING BITMAP,
- INDEX idx_bitmap_k110 (`kd01`) USING BITMAP,
+ INDEX idx_bitmap_k110 (`kd01`) USING BITMAP
)
DUPLICATE KEY(k00)
diff --git
a/regression-test/suites/load_p0/stream_load/ddl/uniq_tbl_array_create.sql
b/regression-test/suites/load_p0/stream_load/ddl/uniq_tbl_array_create.sql
index c6ba1b69496..41291df9948 100644
--- a/regression-test/suites/load_p0/stream_load/ddl/uniq_tbl_array_create.sql
+++ b/regression-test/suites/load_p0/stream_load/ddl/uniq_tbl_array_create.sql
@@ -34,7 +34,7 @@ CREATE TABLE stream_load_uniq_tbl_array
kd14 array<DATETIMEV2> NOT NULL DEFAULT "[]",
kd15 array<CHAR> NOT NULL DEFAULT "[]",
kd16 array<VARCHAR> NOT NULL DEFAULT "[]",
- kd17 array<STRING> NOT NULL DEFAULT "[]",
+ kd17 array<STRING> NOT NULL DEFAULT "[]"
)
UNIQUE KEY(k00)
DISTRIBUTED BY HASH(k00) BUCKETS 32
diff --git a/regression-test/suites/load_p0/stream_load/test_stream_load.groovy
b/regression-test/suites/load_p0/stream_load/test_stream_load.groovy
index 4e809ff2a5d..d6b50fcae2c 100644
--- a/regression-test/suites/load_p0/stream_load/test_stream_load.groovy
+++ b/regression-test/suites/load_p0/stream_load/test_stream_load.groovy
@@ -1543,7 +1543,7 @@ suite("test_stream_load", "p0") {
`c47` varchar(48) NULL,
`c48` varchar(48) NULL,
`c49` varchar(48) NULL,
- `c50` varchar(48) NULL,
+ `c50` varchar(48) NULL
) ENGINE=OLAP
DUPLICATE KEY(`c1`)
COMMENT 'OLAP'
diff --git a/regression-test/suites/load_p0/tvf/ddl/dup_tbl_array_tvf.sql
b/regression-test/suites/load_p0/tvf/ddl/dup_tbl_array_tvf.sql
index 4ddbba40631..b6bc8aa4371 100644
--- a/regression-test/suites/load_p0/tvf/ddl/dup_tbl_array_tvf.sql
+++ b/regression-test/suites/load_p0/tvf/ddl/dup_tbl_array_tvf.sql
@@ -33,7 +33,7 @@ CREATE TABLE dup_tbl_array_tvf
kd13 array<DATEV2> NOT NULL DEFAULT "[]",
kd14 array<DATETIMEV2> NOT NULL DEFAULT "[]",
kd15 array<CHAR> NOT NULL DEFAULT "[]",
- kd16 array<VARCHAR> NOT NULL DEFAULT "[]",
+ kd16 array<VARCHAR> NOT NULL DEFAULT "[]"
)
DUPLICATE KEY(k00)
DISTRIBUTED BY HASH(k00) BUCKETS 32
diff --git a/regression-test/suites/load_p0/tvf/ddl/dup_tbl_basic_tvf.sql
b/regression-test/suites/load_p0/tvf/ddl/dup_tbl_basic_tvf.sql
index 573807576c2..95950d3b388 100644
--- a/regression-test/suites/load_p0/tvf/ddl/dup_tbl_basic_tvf.sql
+++ b/regression-test/suites/load_p0/tvf/ddl/dup_tbl_basic_tvf.sql
@@ -48,7 +48,7 @@ CREATE TABLE dup_tbl_basic_tvf
INDEX idx_ngrambf_k117 (`k17`) USING NGRAM_BF PROPERTIES("gram_size"="3",
"bf_size"="256"),
INDEX idx_bitmap_k104 (`k02`) USING BITMAP,
- INDEX idx_bitmap_k110 (`kd01`) USING BITMAP,
+ INDEX idx_bitmap_k110 (`kd01`) USING BITMAP
)
DUPLICATE KEY(k00)
diff --git a/regression-test/suites/load_p0/tvf/ddl/uniq_tbl_array_tvf.sql
b/regression-test/suites/load_p0/tvf/ddl/uniq_tbl_array_tvf.sql
index b38a1b0a3d3..1cb4d338207 100644
--- a/regression-test/suites/load_p0/tvf/ddl/uniq_tbl_array_tvf.sql
+++ b/regression-test/suites/load_p0/tvf/ddl/uniq_tbl_array_tvf.sql
@@ -34,7 +34,7 @@ CREATE TABLE uniq_tbl_array_tvf
kd14 array<DATETIMEV2> NOT NULL DEFAULT "[]",
kd15 array<CHAR> NOT NULL DEFAULT "[]",
kd16 array<VARCHAR> NOT NULL DEFAULT "[]",
- kd17 array<STRING> NOT NULL DEFAULT "[]",
+ kd17 array<STRING> NOT NULL DEFAULT "[]"
)
UNIQUE KEY(k00)
DISTRIBUTED BY HASH(k00) BUCKETS 32
diff --git
a/regression-test/suites/nereids_rules_p0/partition_prune/test_date_function_prune.groovy
b/regression-test/suites/nereids_rules_p0/partition_prune/test_date_function_prune.groovy
index 583bb48e837..965983596a0 100644
---
a/regression-test/suites/nereids_rules_p0/partition_prune/test_date_function_prune.groovy
+++
b/regression-test/suites/nereids_rules_p0/partition_prune/test_date_function_prune.groovy
@@ -25,7 +25,7 @@ suite("test_date_function_prune") {
sql """
CREATE TABLE `dp` (
`node_name` varchar(100) NULL COMMENT '',
- `date_time` datetime NULL COMMENT '',
+ `date_time` datetime NULL COMMENT ''
) ENGINE=OLAP
DUPLICATE KEY(`node_name`)
COMMENT ''
diff --git
a/regression-test/suites/partition_p0/auto_partition/test_auto_list_partition.groovy
b/regression-test/suites/partition_p0/auto_partition/test_auto_list_partition.groovy
index 76fd866d66f..02a16da8884 100644
---
a/regression-test/suites/partition_p0/auto_partition/test_auto_list_partition.groovy
+++
b/regression-test/suites/partition_p0/auto_partition/test_auto_list_partition.groovy
@@ -255,7 +255,7 @@ suite("test_auto_list_partition") {
CREATE TABLE test_list_many_column2 (
id int not null,
k largeint not null,
- str varchar not null,
+ str varchar not null
)
AUTO PARTITION BY LIST (`id`, `k`, `str`)
(
@@ -276,7 +276,7 @@ suite("test_auto_list_partition") {
CREATE TABLE test_list_many_column3 (
id int not null,
k largeint not null,
- str varchar not null,
+ str varchar not null
)
AUTO PARTITION BY LIST (`id`, `k`, `str`)
(
diff --git a/regression-test/suites/point_query_p0/test_rowstore.groovy
b/regression-test/suites/point_query_p0/test_rowstore.groovy
index e1284931045..c7c2b763637 100644
--- a/regression-test/suites/point_query_p0/test_rowstore.groovy
+++ b/regression-test/suites/point_query_p0/test_rowstore.groovy
@@ -21,7 +21,7 @@ suite("test_rowstore", "p0") {
sql """
CREATE TABLE IF NOT EXISTS ${tableName} (
`k1` int(11) NULL COMMENT "",
- `k2` text NULL COMMENT "",
+ `k2` text NULL COMMENT ""
) ENGINE=OLAP
UNIQUE KEY(`k1`)
DISTRIBUTED BY HASH(`k1`) BUCKETS 1
diff --git a/regression-test/suites/query_p0/aggregate/array_agg.groovy
b/regression-test/suites/query_p0/aggregate/array_agg.groovy
index 1463eed6470..ee4fcb9d455 100644
--- a/regression-test/suites/query_p0/aggregate/array_agg.groovy
+++ b/regression-test/suites/query_p0/aggregate/array_agg.groovy
@@ -23,7 +23,7 @@ suite("array_agg") {
CREATE TABLE `test_array_agg` (
`id` int(11) NOT NULL,
`label_name` varchar(32) default null,
- `value_field` string default null,
+ `value_field` string default null
) ENGINE=OLAP
DUPLICATE KEY(`id`)
COMMENT 'OLAP'
diff --git
a/regression-test/suites/query_p0/limit/test_map_select_with_limit.groovy
b/regression-test/suites/query_p0/limit/test_map_select_with_limit.groovy
index 43d340fce99..5a37b7b9bc1 100644
--- a/regression-test/suites/query_p0/limit/test_map_select_with_limit.groovy
+++ b/regression-test/suites/query_p0/limit/test_map_select_with_limit.groovy
@@ -22,7 +22,7 @@ suite("test_map_select_with_limit", "query") {
sql """
CREATE TABLE IF NOT EXISTS ${testTable} (
`k1` INT(11) NULL,
- `k2` MAP<SMALLINT(6), STRING> NULL,
+ `k2` MAP<SMALLINT(6), STRING> NULL
) ENGINE=OLAP
DUPLICATE KEY(`k1`)
COMMENT 'OLAP'
diff --git a/regression-test/suites/query_p0/sort/sort.groovy
b/regression-test/suites/query_p0/sort/sort.groovy
index a7f096b330e..7742bdcd766 100644
--- a/regression-test/suites/query_p0/sort/sort.groovy
+++ b/regression-test/suites/query_p0/sort/sort.groovy
@@ -169,7 +169,7 @@ suite("sort") {
`col_varchar` VARCHAR(10) NOT NULL,
`col_varchar_null` VARCHAR(10) NULL,
`col_char` CHAR(10) NOT NULL,
- `col_char_null` CHAR(10) NULL,
+ `col_char_null` CHAR(10) NULL
) ENGINE=OLAP
DUPLICATE KEY(`row_id`)
DISTRIBUTED BY HASH(`row_id`) BUCKETS 1
diff --git a/regression-test/suites/query_p0/test_array_orderby_limit.groovy
b/regression-test/suites/query_p0/test_array_orderby_limit.groovy
index b63d936dfc6..c573b1c7986 100644
--- a/regression-test/suites/query_p0/test_array_orderby_limit.groovy
+++ b/regression-test/suites/query_p0/test_array_orderby_limit.groovy
@@ -22,7 +22,7 @@ suite("test_array_char_orderby", "query") {
sql """
CREATE TABLE IF NOT EXISTS ${testTable} (
`k1` INT(11) NULL,
- `k2` array<array<char(50)>> NULL,
+ `k2` array<array<char(50)>> NULL
) ENGINE=OLAP
DUPLICATE KEY(`k1`)
COMMENT 'OLAP'
diff --git
a/regression-test/suites/show_p0/test_show_create_table_and_views.groovy
b/regression-test/suites/show_p0/test_show_create_table_and_views.groovy
index 89670aa434f..ff98d09f9f4 100644
--- a/regression-test/suites/show_p0/test_show_create_table_and_views.groovy
+++ b/regression-test/suites/show_p0/test_show_create_table_and_views.groovy
@@ -36,7 +36,7 @@ suite("test_show_create_table_and_views", "show") {
CREATE TABLE ${dbName}.${tableName} (
`user_id` LARGEINT NOT NULL,
`good_id` LARGEINT NOT NULL,
- `cost` BIGINT SUM DEFAULT "0",
+ `cost` BIGINT SUM DEFAULT "0"
)
AGGREGATE KEY(`user_id`, `good_id`)
PARTITION BY RANGE(`good_id`)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
