This is an automated email from the ASF dual-hosted git repository. yiguolei pushed a commit to branch branch-2.1 in repository https://gitbox.apache.org/repos/asf/doris.git
commit 02876511149799c2ceae813fa9d5abcd9e8f68de Author: xueweizhang <[email protected]> AuthorDate: Wed Jan 24 20:33:12 2024 +0800 [fix](char) fix char column type not check lenght (#30266) --- .../java/org/apache/doris/analysis/TypeDef.java | 1 - .../plans/commands/info/ColumnDefinition.java | 1 - .../datatype_p0/string/test_string_basic.groovy | 29 ++++++++++++++++++++++ .../load_p0/broker_load/ddl/agg_tbl_basic.sql | 4 +-- .../load_p0/broker_load/ddl/dup_tbl_basic.sql | 2 +- .../load_p0/broker_load/ddl/mow_tbl_basic.sql | 2 +- .../load_p0/broker_load/ddl/uniq_tbl_basic.sql | 2 +- .../load_p0/broker_load/test_seq_load.groovy | 2 +- .../routine_load/ddl/agg_tbl_basic_create.sql | 4 +-- .../routine_load/ddl/dup_tbl_basic_create.sql | 2 +- .../routine_load/ddl/mow_tbl_basic_create.sql | 2 +- .../routine_load/ddl/uniq_tbl_basic_create.sql | 2 +- .../ddl/uniq_tbl_basic_create_sequence.sql | 2 +- .../stream_load/ddl/agg_tbl_basic_create.sql | 4 +-- .../stream_load/ddl/dup_tbl_basic_create.sql | 2 +- .../ddl/dup_tbl_basic_create_random_bucket.sql | 2 +- .../stream_load/ddl/mow_tbl_basic_create.sql | 2 +- .../stream_load/ddl/uniq_tbl_basic_create.sql | 2 +- .../ddl/uniq_tbl_basic_create_sequence.sql | 2 +- .../suites/load_p0/tvf/ddl/agg_tbl_basic_tvf.sql | 4 +-- .../suites/load_p0/tvf/ddl/dup_tbl_basic_tvf.sql | 2 +- .../suites/load_p0/tvf/ddl/mow_tbl_basic_tvf.sql | 2 +- .../suites/load_p0/tvf/ddl/uniq_tbl_basic_tvf.sql | 2 +- 23 files changed, 53 insertions(+), 26 deletions(-) diff --git a/fe/fe-core/src/main/java/org/apache/doris/analysis/TypeDef.java b/fe/fe-core/src/main/java/org/apache/doris/analysis/TypeDef.java index 2e8c1291b8b..19a000e2a58 100644 --- a/fe/fe-core/src/main/java/org/apache/doris/analysis/TypeDef.java +++ b/fe/fe-core/src/main/java/org/apache/doris/analysis/TypeDef.java @@ -196,7 +196,6 @@ public class TypeDef implements ParseNode { } else { name = "CHAR"; maxLen = ScalarType.MAX_CHAR_LENGTH; - return; } int len = scalarType.getLength(); // len is decided by child, when it is -1. diff --git a/fe/fe-core/src/main/java/org/apache/doris/nereids/trees/plans/commands/info/ColumnDefinition.java b/fe/fe-core/src/main/java/org/apache/doris/nereids/trees/plans/commands/info/ColumnDefinition.java index bf85d405503..cd551cbbf4b 100644 --- a/fe/fe-core/src/main/java/org/apache/doris/nereids/trees/plans/commands/info/ColumnDefinition.java +++ b/fe/fe-core/src/main/java/org/apache/doris/nereids/trees/plans/commands/info/ColumnDefinition.java @@ -446,7 +446,6 @@ public class ColumnDefinition { } else { name = "CHAR"; maxLen = ScalarType.MAX_CHAR_LENGTH; - return; } int len = scalarType.getLength(); // len is decided by child, when it is -1. diff --git a/regression-test/suites/datatype_p0/string/test_string_basic.groovy b/regression-test/suites/datatype_p0/string/test_string_basic.groovy index c6527a48514..2aa9f9e86e4 100644 --- a/regression-test/suites/datatype_p0/string/test_string_basic.groovy +++ b/regression-test/suites/datatype_p0/string/test_string_basic.groovy @@ -349,5 +349,34 @@ suite("test_string_basic") { sql "drop view if exists char_view;" sql "create view char_view as select cast('a' as CHARACTER);" qt_test "select * from char_view"; + + def table_too_long = "fail" + sql "drop table if exists char_table_too_long;" + try { + sql """ + CREATE TABLE IF NOT EXISTS char_table_too_long (k1 VARCHAR(10) NULL, v1 CHAR(300) NULL) + UNIQUE KEY(k1) DISTRIBUTED BY HASH(k1) BUCKETS 5 properties("replication_num" = "1") + """ + table_too_long = "success" + } catch(Exception e) { + logger.info(e.getMessage()) + assertTrue(e.getMessage().contains("size must be <= 255")) + } + assertEquals(table_too_long, "fail") + sql "drop table if exists char_table_too_long;" + + sql "drop table if exists varchar_table_too_long;" + try { + sql """ + CREATE TABLE IF NOT EXISTS varchar_table_too_long (k1 VARCHAR(10) NULL, v1 VARCHAR(65599) NULL) + UNIQUE KEY(k1) DISTRIBUTED BY HASH(k1) BUCKETS 5 properties("replication_num" = "1") + """ + table_too_long = "success" + } catch(Exception e) { + logger.info(e.getMessage()) + assertTrue(e.getMessage().contains("size must be <= 65533")) + } + assertEquals(table_too_long, "fail") + sql "drop table if exists varchar_table_too_long;" } diff --git a/regression-test/suites/load_p0/broker_load/ddl/agg_tbl_basic.sql b/regression-test/suites/load_p0/broker_load/ddl/agg_tbl_basic.sql index 23a061b254d..12df89b16df 100644 --- a/regression-test/suites/load_p0/broker_load/ddl/agg_tbl_basic.sql +++ b/regression-test/suites/load_p0/broker_load/ddl/agg_tbl_basic.sql @@ -15,7 +15,7 @@ CREATE TABLE agg_tbl_basic k12 DATETIME REPLACE NULL, k13 DATEV2 REPLACE NULL, k14 DATETIMEV2 REPLACE NULL, - k15 CHAR(300) REPLACE NULL, + k15 CHAR(255) REPLACE NULL, k16 VARCHAR(300) REPLACE NULL, k17 STRING REPLACE NULL, k18 JSON REPLACE NULL, @@ -36,7 +36,7 @@ CREATE TABLE agg_tbl_basic kd12 DATETIME REPLACE NOT NULL DEFAULT CURRENT_TIMESTAMP, kd13 DATEV2 REPLACE NOT NULL DEFAULT "2023-08-24", kd14 DATETIMEV2 REPLACE NOT NULL DEFAULT CURRENT_TIMESTAMP, - kd15 CHAR(300) REPLACE NOT NULL DEFAULT "我能吞下玻璃而不伤身体", + kd15 CHAR(255) REPLACE NOT NULL DEFAULT "我能吞下玻璃而不伤身体", kd16 VARCHAR(300) REPLACE NOT NULL DEFAULT "我能吞下玻璃而不伤身体", kd17 STRING REPLACE NOT NULL DEFAULT "我能吞下玻璃而不伤身体", kd18 JSON REPLACE NULL, 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 cd0ea4b0e80..b5568edcd0f 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 @@ -33,7 +33,7 @@ CREATE TABLE dup_tbl_basic kd12 DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, kd13 DATEV2 NOT NULL DEFAULT "2023-08-24", kd14 DATETIMEV2 NOT NULL DEFAULT CURRENT_TIMESTAMP, - kd15 CHAR(300) NOT NULL DEFAULT "我能吞下玻璃而不伤身体", + kd15 CHAR(255) NOT NULL DEFAULT "我能吞下玻璃而不伤身体", kd16 VARCHAR(300) NOT NULL DEFAULT "我能吞下玻璃而不伤身体", kd17 STRING NOT NULL DEFAULT "我能吞下玻璃而不伤身体", kd18 JSON NULL, diff --git a/regression-test/suites/load_p0/broker_load/ddl/mow_tbl_basic.sql b/regression-test/suites/load_p0/broker_load/ddl/mow_tbl_basic.sql index 8002f235f47..dbb45d263f0 100644 --- a/regression-test/suites/load_p0/broker_load/ddl/mow_tbl_basic.sql +++ b/regression-test/suites/load_p0/broker_load/ddl/mow_tbl_basic.sql @@ -33,7 +33,7 @@ CREATE TABLE mow_tbl_basic kd12 DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, kd13 DATEV2 NOT NULL DEFAULT "2023-08-24", kd14 DATETIMEV2 NOT NULL DEFAULT CURRENT_TIMESTAMP, - kd15 CHAR(300) NOT NULL DEFAULT "我能吞下玻璃而不伤身体", + kd15 CHAR(255) NOT NULL DEFAULT "我能吞下玻璃而不伤身体", kd16 VARCHAR(300) NOT NULL DEFAULT "我能吞下玻璃而不伤身体", kd17 STRING NOT NULL DEFAULT "我能吞下玻璃而不伤身体", kd18 JSON NULL, diff --git a/regression-test/suites/load_p0/broker_load/ddl/uniq_tbl_basic.sql b/regression-test/suites/load_p0/broker_load/ddl/uniq_tbl_basic.sql index e111e957214..993e7046ec9 100644 --- a/regression-test/suites/load_p0/broker_load/ddl/uniq_tbl_basic.sql +++ b/regression-test/suites/load_p0/broker_load/ddl/uniq_tbl_basic.sql @@ -33,7 +33,7 @@ CREATE TABLE uniq_tbl_basic kd12 DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, kd13 DATEV2 NOT NULL DEFAULT "2023-08-24", kd14 DATETIMEV2 NOT NULL DEFAULT CURRENT_TIMESTAMP, - kd15 CHAR(300) NOT NULL DEFAULT "我能吞下玻璃而不伤身体", + kd15 CHAR(255) NOT NULL DEFAULT "我能吞下玻璃而不伤身体", kd16 VARCHAR(300) NOT NULL DEFAULT "我能吞下玻璃而不伤身体", kd17 STRING NOT NULL DEFAULT "我能吞下玻璃而不伤身体", kd18 JSON NULL, diff --git a/regression-test/suites/load_p0/broker_load/test_seq_load.groovy b/regression-test/suites/load_p0/broker_load/test_seq_load.groovy index afb955cb32e..0c94467c6a5 100644 --- a/regression-test/suites/load_p0/broker_load/test_seq_load.groovy +++ b/regression-test/suites/load_p0/broker_load/test_seq_load.groovy @@ -57,7 +57,7 @@ suite("test_seq_load", "load_p0") { kd12 DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, kd13 DATEV2 NOT NULL DEFAULT "2023-08-24", kd14 DATETIMEV2 NOT NULL DEFAULT CURRENT_TIMESTAMP, - kd15 CHAR(300) NOT NULL DEFAULT "我能吞下玻璃而不伤身体", + kd15 CHAR(255) NOT NULL DEFAULT "我能吞下玻璃而不伤身体", kd16 VARCHAR(300) NOT NULL DEFAULT "我能吞下玻璃而不伤身体", kd17 STRING NOT NULL DEFAULT "我能吞下玻璃而不伤身体", kd18 JSON NULL, diff --git a/regression-test/suites/load_p0/routine_load/ddl/agg_tbl_basic_create.sql b/regression-test/suites/load_p0/routine_load/ddl/agg_tbl_basic_create.sql index a0012997487..56d18a32b4e 100644 --- a/regression-test/suites/load_p0/routine_load/ddl/agg_tbl_basic_create.sql +++ b/regression-test/suites/load_p0/routine_load/ddl/agg_tbl_basic_create.sql @@ -15,7 +15,7 @@ CREATE TABLE routine_load_agg_tbl_basic k12 DATETIME REPLACE NULL, k13 DATEV2 REPLACE NULL, k14 DATETIMEV2 REPLACE NULL, - k15 CHAR(300) REPLACE NULL, + k15 CHAR(255) REPLACE NULL, k16 VARCHAR(300) REPLACE NULL, k17 STRING REPLACE NULL, k18 JSON REPLACE NULL, @@ -36,7 +36,7 @@ CREATE TABLE routine_load_agg_tbl_basic kd12 DATETIME REPLACE NOT NULL DEFAULT "2023-08-24 12:00:00", kd13 DATEV2 REPLACE NOT NULL DEFAULT "2023-08-24", kd14 DATETIMEV2 REPLACE NOT NULL DEFAULT "2023-08-24 12:00:00", - kd15 CHAR(300) REPLACE NOT NULL DEFAULT "我能吞下玻璃而不伤身体", + kd15 CHAR(255) REPLACE NOT NULL DEFAULT "我能吞下玻璃而不伤身体", kd16 VARCHAR(300) REPLACE NOT NULL DEFAULT "我能吞下玻璃而不伤身体", kd17 STRING REPLACE NOT NULL DEFAULT "我能吞下玻璃而不伤身体", kd18 JSON REPLACE NULL, 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 561f3e66b1d..982befa8b18 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 @@ -33,7 +33,7 @@ CREATE TABLE routine_load_dup_tbl_basic kd12 DATETIME NOT NULL DEFAULT "2023-08-24 12:00:00", kd13 DATEV2 NOT NULL DEFAULT "2023-08-24", kd14 DATETIMEV2 NOT NULL DEFAULT "2023-08-24 12:00:00", - kd15 CHAR(300) NOT NULL DEFAULT "我能吞下玻璃而不伤身体", + kd15 CHAR(255) NOT NULL DEFAULT "我能吞下玻璃而不伤身体", kd16 VARCHAR(300) NOT NULL DEFAULT "我能吞下玻璃而不伤身体", kd17 STRING NOT NULL DEFAULT "我能吞下玻璃而不伤身体", kd18 JSON NULL, diff --git a/regression-test/suites/load_p0/routine_load/ddl/mow_tbl_basic_create.sql b/regression-test/suites/load_p0/routine_load/ddl/mow_tbl_basic_create.sql index 2c9b472cdaf..c2398b9d038 100644 --- a/regression-test/suites/load_p0/routine_load/ddl/mow_tbl_basic_create.sql +++ b/regression-test/suites/load_p0/routine_load/ddl/mow_tbl_basic_create.sql @@ -33,7 +33,7 @@ CREATE TABLE routine_load_mow_tbl_basic kd12 DATETIME NOT NULL DEFAULT "2023-08-24 12:00:00", kd13 DATEV2 NOT NULL DEFAULT "2023-08-24", kd14 DATETIMEV2 NOT NULL DEFAULT "2023-08-24 12:00:00", - kd15 CHAR(300) NOT NULL DEFAULT "我能吞下玻璃而不伤身体", + kd15 CHAR(255) NOT NULL DEFAULT "我能吞下玻璃而不伤身体", kd16 VARCHAR(300) NOT NULL DEFAULT "我能吞下玻璃而不伤身体", kd17 STRING NOT NULL DEFAULT "我能吞下玻璃而不伤身体", kd18 JSON NULL, diff --git a/regression-test/suites/load_p0/routine_load/ddl/uniq_tbl_basic_create.sql b/regression-test/suites/load_p0/routine_load/ddl/uniq_tbl_basic_create.sql index 97b8cfd1471..68a78e9b755 100644 --- a/regression-test/suites/load_p0/routine_load/ddl/uniq_tbl_basic_create.sql +++ b/regression-test/suites/load_p0/routine_load/ddl/uniq_tbl_basic_create.sql @@ -33,7 +33,7 @@ CREATE TABLE routine_load_uniq_tbl_basic kd12 DATETIME NOT NULL DEFAULT "2023-08-24 12:00:00", kd13 DATEV2 NOT NULL DEFAULT "2023-08-24", kd14 DATETIMEV2 NOT NULL DEFAULT "2023-08-24 12:00:00", - kd15 CHAR(300) NOT NULL DEFAULT "我能吞下玻璃而不伤身体", + kd15 CHAR(255) NOT NULL DEFAULT "我能吞下玻璃而不伤身体", kd16 VARCHAR(300) NOT NULL DEFAULT "我能吞下玻璃而不伤身体", kd17 STRING NOT NULL DEFAULT "我能吞下玻璃而不伤身体", kd18 JSON NULL, diff --git a/regression-test/suites/load_p0/routine_load/ddl/uniq_tbl_basic_create_sequence.sql b/regression-test/suites/load_p0/routine_load/ddl/uniq_tbl_basic_create_sequence.sql index 07141576dec..75339f842dd 100644 --- a/regression-test/suites/load_p0/routine_load/ddl/uniq_tbl_basic_create_sequence.sql +++ b/regression-test/suites/load_p0/routine_load/ddl/uniq_tbl_basic_create_sequence.sql @@ -33,7 +33,7 @@ CREATE TABLE routine_load_uniq_tbl_basic_sequence kd12 DATETIME NOT NULL DEFAULT "2023-08-24 12:00:00", kd13 DATEV2 NOT NULL DEFAULT "2023-08-24", kd14 DATETIMEV2 NOT NULL DEFAULT "2023-08-24 12:00:00", - kd15 CHAR(300) NOT NULL DEFAULT "我能吞下玻璃而不伤身体", + kd15 CHAR(255) NOT NULL DEFAULT "我能吞下玻璃而不伤身体", kd16 VARCHAR(300) NOT NULL DEFAULT "我能吞下玻璃而不伤身体", kd17 STRING NOT NULL DEFAULT "我能吞下玻璃而不伤身体", kd18 JSON NULL, diff --git a/regression-test/suites/load_p0/stream_load/ddl/agg_tbl_basic_create.sql b/regression-test/suites/load_p0/stream_load/ddl/agg_tbl_basic_create.sql index bb5e1a534ef..6d09c8115c7 100644 --- a/regression-test/suites/load_p0/stream_load/ddl/agg_tbl_basic_create.sql +++ b/regression-test/suites/load_p0/stream_load/ddl/agg_tbl_basic_create.sql @@ -15,7 +15,7 @@ CREATE TABLE stream_load_agg_tbl_basic k12 DATETIME REPLACE NULL, k13 DATEV2 REPLACE NULL, k14 DATETIMEV2 REPLACE NULL, - k15 CHAR(300) REPLACE NULL, + k15 CHAR(255) REPLACE NULL, k16 VARCHAR(300) REPLACE NULL, k17 STRING REPLACE NULL, k18 JSON REPLACE NULL, @@ -36,7 +36,7 @@ CREATE TABLE stream_load_agg_tbl_basic kd12 DATETIME REPLACE NOT NULL DEFAULT "2023-08-24 12:00:00", kd13 DATEV2 REPLACE NOT NULL DEFAULT "2023-08-24", kd14 DATETIMEV2 REPLACE NOT NULL DEFAULT "2023-08-24 12:00:00", - kd15 CHAR(300) REPLACE NOT NULL DEFAULT "我能吞下玻璃而不伤身体", + kd15 CHAR(255) REPLACE NOT NULL DEFAULT "我能吞下玻璃而不伤身体", kd16 VARCHAR(300) REPLACE NOT NULL DEFAULT "我能吞下玻璃而不伤身体", kd17 STRING REPLACE NOT NULL DEFAULT "我能吞下玻璃而不伤身体", kd18 JSON REPLACE NULL, 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 f81ae5e20ea..c07b249031d 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 @@ -33,7 +33,7 @@ CREATE TABLE stream_load_dup_tbl_basic kd12 DATETIME NOT NULL DEFAULT "2023-08-24 12:00:00", kd13 DATEV2 NOT NULL DEFAULT "2023-08-24", kd14 DATETIMEV2 NOT NULL DEFAULT "2023-08-24 12:00:00", - kd15 CHAR(300) NOT NULL DEFAULT "我能吞下玻璃而不伤身体", + kd15 CHAR(255) NOT NULL DEFAULT "我能吞下玻璃而不伤身体", kd16 VARCHAR(300) NOT NULL DEFAULT "我能吞下玻璃而不伤身体", kd17 STRING NOT NULL DEFAULT "我能吞下玻璃而不伤身体", kd18 JSON NULL, 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 9c86eb64745..68be543b314 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 @@ -33,7 +33,7 @@ CREATE TABLE stream_load_dup_tbl_basic_random_bucket kd12 DATETIME NOT NULL DEFAULT "2023-08-24 12:00:00", kd13 DATEV2 NOT NULL DEFAULT "2023-08-24", kd14 DATETIMEV2 NOT NULL DEFAULT "2023-08-24 12:00:00", - kd15 CHAR(300) NOT NULL DEFAULT "我能吞下玻璃而不伤身体", + kd15 CHAR(255) NOT NULL DEFAULT "我能吞下玻璃而不伤身体", kd16 VARCHAR(300) NOT NULL DEFAULT "我能吞下玻璃而不伤身体", kd17 STRING NOT NULL DEFAULT "我能吞下玻璃而不伤身体", kd18 JSON NULL, diff --git a/regression-test/suites/load_p0/stream_load/ddl/mow_tbl_basic_create.sql b/regression-test/suites/load_p0/stream_load/ddl/mow_tbl_basic_create.sql index 94695908f87..b64602b2e7f 100644 --- a/regression-test/suites/load_p0/stream_load/ddl/mow_tbl_basic_create.sql +++ b/regression-test/suites/load_p0/stream_load/ddl/mow_tbl_basic_create.sql @@ -33,7 +33,7 @@ CREATE TABLE stream_load_mow_tbl_basic kd12 DATETIME NOT NULL DEFAULT "2023-08-24 12:00:00", kd13 DATEV2 NOT NULL DEFAULT "2023-08-24", kd14 DATETIMEV2 NOT NULL DEFAULT "2023-08-24 12:00:00", - kd15 CHAR(300) NOT NULL DEFAULT "我能吞下玻璃而不伤身体", + kd15 CHAR(255) NOT NULL DEFAULT "我能吞下玻璃而不伤身体", kd16 VARCHAR(300) NOT NULL DEFAULT "我能吞下玻璃而不伤身体", kd17 STRING NOT NULL DEFAULT "我能吞下玻璃而不伤身体", kd18 JSON NULL, diff --git a/regression-test/suites/load_p0/stream_load/ddl/uniq_tbl_basic_create.sql b/regression-test/suites/load_p0/stream_load/ddl/uniq_tbl_basic_create.sql index 5acd984cc71..44d6ff98b2e 100644 --- a/regression-test/suites/load_p0/stream_load/ddl/uniq_tbl_basic_create.sql +++ b/regression-test/suites/load_p0/stream_load/ddl/uniq_tbl_basic_create.sql @@ -33,7 +33,7 @@ CREATE TABLE stream_load_uniq_tbl_basic kd12 DATETIME NOT NULL DEFAULT "2023-08-24 12:00:00", kd13 DATEV2 NOT NULL DEFAULT "2023-08-24", kd14 DATETIMEV2 NOT NULL DEFAULT "2023-08-24 12:00:00", - kd15 CHAR(300) NOT NULL DEFAULT "我能吞下玻璃而不伤身体", + kd15 CHAR(255) NOT NULL DEFAULT "我能吞下玻璃而不伤身体", kd16 VARCHAR(300) NOT NULL DEFAULT "我能吞下玻璃而不伤身体", kd17 STRING NOT NULL DEFAULT "我能吞下玻璃而不伤身体", kd18 JSON NULL, diff --git a/regression-test/suites/load_p0/stream_load/ddl/uniq_tbl_basic_create_sequence.sql b/regression-test/suites/load_p0/stream_load/ddl/uniq_tbl_basic_create_sequence.sql index 7598d8a636b..4695b0fc2c8 100644 --- a/regression-test/suites/load_p0/stream_load/ddl/uniq_tbl_basic_create_sequence.sql +++ b/regression-test/suites/load_p0/stream_load/ddl/uniq_tbl_basic_create_sequence.sql @@ -33,7 +33,7 @@ CREATE TABLE stream_load_uniq_tbl_basic_sequence kd12 DATETIME NOT NULL DEFAULT "2023-08-24 12:00:00", kd13 DATEV2 NOT NULL DEFAULT "2023-08-24", kd14 DATETIMEV2 NOT NULL DEFAULT "2023-08-24 12:00:00", - kd15 CHAR(300) NOT NULL DEFAULT "我能吞下玻璃而不伤身体", + kd15 CHAR(255) NOT NULL DEFAULT "我能吞下玻璃而不伤身体", kd16 VARCHAR(300) NOT NULL DEFAULT "我能吞下玻璃而不伤身体", kd17 STRING NOT NULL DEFAULT "我能吞下玻璃而不伤身体", kd18 JSON NULL, diff --git a/regression-test/suites/load_p0/tvf/ddl/agg_tbl_basic_tvf.sql b/regression-test/suites/load_p0/tvf/ddl/agg_tbl_basic_tvf.sql index 2a7b109a94d..aaae1f1c787 100644 --- a/regression-test/suites/load_p0/tvf/ddl/agg_tbl_basic_tvf.sql +++ b/regression-test/suites/load_p0/tvf/ddl/agg_tbl_basic_tvf.sql @@ -15,7 +15,7 @@ CREATE TABLE agg_tbl_basic_tvf k12 DATETIME REPLACE NULL, k13 DATEV2 REPLACE NULL, k14 DATETIMEV2 REPLACE NULL, - k15 CHAR(300) REPLACE NULL, + k15 CHAR(255) REPLACE NULL, k16 VARCHAR(300) REPLACE NULL, k17 STRING REPLACE NULL, k18 JSON REPLACE NULL, @@ -36,7 +36,7 @@ CREATE TABLE agg_tbl_basic_tvf kd12 DATETIME REPLACE NOT NULL DEFAULT CURRENT_TIMESTAMP, kd13 DATEV2 REPLACE NOT NULL DEFAULT "2023-08-24", kd14 DATETIMEV2 REPLACE NOT NULL DEFAULT CURRENT_TIMESTAMP, - kd15 CHAR(300) REPLACE NOT NULL DEFAULT "我能吞下玻璃而不伤身体", + kd15 CHAR(255) REPLACE NOT NULL DEFAULT "我能吞下玻璃而不伤身体", kd16 VARCHAR(300) REPLACE NOT NULL DEFAULT "我能吞下玻璃而不伤身体", kd17 STRING REPLACE NOT NULL DEFAULT "我能吞下玻璃而不伤身体", kd18 JSON REPLACE NULL, 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 95950d3b388..c0acfa76ba5 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 @@ -33,7 +33,7 @@ CREATE TABLE dup_tbl_basic_tvf kd12 DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, kd13 DATEV2 NOT NULL DEFAULT "2023-08-24", kd14 DATETIMEV2 NOT NULL DEFAULT CURRENT_TIMESTAMP, - kd15 CHAR(300) NOT NULL DEFAULT "我能吞下玻璃而不伤身体", + kd15 CHAR(255) NOT NULL DEFAULT "我能吞下玻璃而不伤身体", kd16 VARCHAR(300) NOT NULL DEFAULT "我能吞下玻璃而不伤身体", kd17 STRING NOT NULL DEFAULT "我能吞下玻璃而不伤身体", kd18 JSON NULL, diff --git a/regression-test/suites/load_p0/tvf/ddl/mow_tbl_basic_tvf.sql b/regression-test/suites/load_p0/tvf/ddl/mow_tbl_basic_tvf.sql index f17bbf6a83f..b34e7749317 100644 --- a/regression-test/suites/load_p0/tvf/ddl/mow_tbl_basic_tvf.sql +++ b/regression-test/suites/load_p0/tvf/ddl/mow_tbl_basic_tvf.sql @@ -33,7 +33,7 @@ CREATE TABLE mow_tbl_basic_tvf kd12 DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, kd13 DATEV2 NOT NULL DEFAULT "2023-08-24", kd14 DATETIMEV2 NOT NULL DEFAULT CURRENT_TIMESTAMP, - kd15 CHAR(300) NOT NULL DEFAULT "我能吞下玻璃而不伤身体", + kd15 CHAR(255) NOT NULL DEFAULT "我能吞下玻璃而不伤身体", kd16 VARCHAR(300) NOT NULL DEFAULT "我能吞下玻璃而不伤身体", kd17 STRING NOT NULL DEFAULT "我能吞下玻璃而不伤身体", kd18 JSON NULL, diff --git a/regression-test/suites/load_p0/tvf/ddl/uniq_tbl_basic_tvf.sql b/regression-test/suites/load_p0/tvf/ddl/uniq_tbl_basic_tvf.sql index b2554951301..8af1681fec8 100644 --- a/regression-test/suites/load_p0/tvf/ddl/uniq_tbl_basic_tvf.sql +++ b/regression-test/suites/load_p0/tvf/ddl/uniq_tbl_basic_tvf.sql @@ -33,7 +33,7 @@ CREATE TABLE uniq_tbl_basic_tvf kd12 DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, kd13 DATEV2 NOT NULL DEFAULT "2023-08-24", kd14 DATETIMEV2 NOT NULL DEFAULT CURRENT_TIMESTAMP, - kd15 CHAR(300) NOT NULL DEFAULT "我能吞下玻璃而不伤身体", + kd15 CHAR(255) NOT NULL DEFAULT "我能吞下玻璃而不伤身体", kd16 VARCHAR(300) NOT NULL DEFAULT "我能吞下玻璃而不伤身体", kd17 STRING NOT NULL DEFAULT "我能吞下玻璃而不伤身体", kd18 JSON NULL, --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
