This is an automated email from the ASF dual-hosted git repository.
yiguolei 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 7f843294359 [fix](char) fix char column type not check lenght (#30266)
7f843294359 is described below
commit 7f84329435943191a700c44ed024bcf37cf6186f
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]
