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 a71d3a566cc [regression test]Opt Test UniqueModel Schema Key Change
(#31262)
a71d3a566cc is described below
commit a71d3a566cc271b79abbb0425be247454c9a5169
Author: kkop <45192870+cjj2...@users.noreply.github.com>
AuthorDate: Sat Feb 24 16:19:42 2024 +0800
[regression test]Opt Test UniqueModel Schema Key Change (#31262)
* Opt Test UniqueModel Schema Key Change
* Opt Test UniqueModel Schema key Change
---
.../test_unique_model_schema_key_change.out | 10 -------
.../test_unique_model_schema_key_change.groovy | 31 +++++++---------------
2 files changed, 9 insertions(+), 32 deletions(-)
diff --git
a/regression-test/data/schema_change_p0/test_unique_model_schema_key_change.out
b/regression-test/data/schema_change_p0/test_unique_model_schema_key_change.out
index b8e5753aff9..2419cdd18de 100644
---
a/regression-test/data/schema_change_p0/test_unique_model_schema_key_change.out
+++
b/regression-test/data/schema_change_p0/test_unique_model_schema_key_change.out
@@ -99,16 +99,6 @@
789012345 Grace 1997-01-01T00:00 Xian 29 0
13333333333 No. 222 Street, Xian 2022-07-07T22:00
123456689 Alice 2024-01-04T09:00 Yaan 25 0
13812345678 No. 123 Street, Beijing 2022-01-01T10:00
--- ! --
-123456789 Alice 1997-01-01T00:00 Beijing 25 0
13812345678 No. 123 Street, Beijing 2022-01-01T10:00
-234567890 Bob 1997-01-01T00:00 Shanghai 30 1
13998765432 No. 456 Street, Shanghai 2022-02-02T12:00
-345678901 Carol 1997-01-01T00:00 Guangzhou 28 0
13724681357 No. 789 Street, Guangzhou 2022-03-03T14:00
-456789012 Dave 1997-01-01T00:00 Shenzhen 35 1
13680864279 No. 987 Street, Shenzhen 2022-04-04T16:00
-567890123 Eve 1997-01-01T00:00 Chengdu 27 0
13572468091 No. 654 Street, Chengdu 2022-05-05T18:00
-678901234 Frank 1997-01-01T00:00 Hangzhou 32 1
13467985213 No. 321 Street, Hangzhou 2022-06-06T20:00
-789012345 Grace 1997-01-01T00:00 Xian 29 0
13333333333 No. 222 Street, Xian 2022-07-07T22:00
-123456689 Alice 2024-01-04T09:00 Yaan 25 0
13812345678 No. 123 Street, Beijing 2022-01-01T10:00
-
-- ! --
123456789 Alice F Beijing 25 0 13812345678 No. 123
Street, Beijing 2022-01-01T10:00
234567890 Bob F Shanghai 30 1 13998765432
No. 456 Street, Shanghai 2022-02-02T12:00
diff --git
a/regression-test/suites/schema_change_p0/test_unique_model_schema_key_change.groovy
b/regression-test/suites/schema_change_p0/test_unique_model_schema_key_change.groovy
index deb094fc284..52f211a98e7 100644
---
a/regression-test/suites/schema_change_p0/test_unique_model_schema_key_change.groovy
+++
b/regression-test/suites/schema_change_p0/test_unique_model_schema_key_change.groovy
@@ -46,6 +46,7 @@ suite("test_unique_model_schema_key_change","p0") {
" (678901234, 'Frank', 'Hangzhou', 32, 1,
13467985213, 'No. 321 Street, Hangzhou', '2022-06-06 20:00:00')," +
" (789012345, 'Grace', 'Xian', 29, 0, 13333333333,
'No. 222 Street, Xian', '2022-07-07 22:00:00');"
+ //Test the unique model by adding a key column with VARCHAR
sql initTable
sql initTableData
sql """ alter table ${tbName} add column province VARCHAR(20) KEY
DEFAULT "广东省" AFTER username """
@@ -127,8 +128,7 @@ suite("test_unique_model_schema_key_change","p0") {
-
- //Test the unique model by adding a key column with FLOAT
+ //TODO Test the unique model by adding a key column with FLOAT
//java.sql.SQLException: errCode = 2, detailMessage = Float or double can
not used as a key, use decimal instead.
/* sql initTable
sql initTableData
@@ -141,12 +141,11 @@ suite("test_unique_model_schema_key_change","p0") {
-
- //Test the unique model by adding a key column with DOUBLE
+ //TODO Test the unique model by adding a key column with DOUBLE
//java.sql.SQLException: errCode = 2, detailMessage = Float or double can
not used as a key, use decimal instead.
/* sql initTable
sql initTableData
- sql """ alter table ${tbName} add column watch FLOAT KEY DEFAULT
"166.689" AFTER username """
+ sql """ alter table ${tbName} add column watch DOUBLE KEY DEFAULT
"166.689" AFTER username """
insertSql = " insert into ${tbName} values(123456689, 'Alice', 189.479,
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00');
"
waitForSchemaChangeDone({
sql getTableStatusSql
@@ -193,23 +192,11 @@ suite("test_unique_model_schema_key_change","p0") {
- //Test the unique model by adding a key column with DATETIME
- sql initTable
- sql initTableData
- sql """ alter table ${tbName} add column anniversary DATETIME KEY
DEFAULT "1997-01-01 00:00:00" AFTER username """
- insertSql = " insert into ${tbName} values(123456689, 'Alice',
\"2024-01-04 09:00:00\", 'Yaan', 25, 0, 13812345678, 'No. 123 Street,
Beijing', '2022-01-01 10:00:00'); "
- waitForSchemaChangeDone({
- sql getTableStatusSql
- time 60
- }, insertSql, true,"${tbName}")
-
-
-
//Test the unique model by adding a key column with CHAR
sql initTable
sql initTableData
sql """ alter table ${tbName} add column teacher CHAR KEY DEFAULT "F"
AFTER username """
- insertSql = " insert into ${tbName} values(123456689, 'Alice', \"T\",
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00');
"
+ insertSql = " insert into ${tbName} values(123456689, 'Alice', 'T',
'Yaan', 25, 0, 13812345678, 'No. 123 Street, Beijing', '2022-01-01 10:00:00');
"
waitForSchemaChangeDone({
sql getTableStatusSql
time 60
@@ -217,7 +204,7 @@ suite("test_unique_model_schema_key_change","p0") {
- //Test the unique model by adding a key column with STRING
+ //TODO Test the unique model by adding a key column with STRING
//java.sql.SQLException: errCode = 2, detailMessage = String Type should
not be used in key column[comment].
/* sql initTable
sql initTableData
@@ -229,7 +216,7 @@ suite("test_unique_model_schema_key_change","p0") {
}, insertSql, true,"${tbName}")*/
- //Test the unique model by adding a key column with bitmap
+ //TODO Test the unique model by adding a key column with bitmap
//java.sql.SQLException: errCode = 2, detailMessage = Key column can not
set complex type:device_id
/* sql initTable
sql initTableData
@@ -242,7 +229,7 @@ suite("test_unique_model_schema_key_change","p0") {
- //Test the unique model by adding a key column with Map
+ //TODO Test the unique model by adding a key column with Map
//java.sql.SQLException: errCode = 2, detailMessage = Map can only be
used in the non-key column of the duplicate table at present.
/* sql initTable
sql initTableData
@@ -255,7 +242,7 @@ suite("test_unique_model_schema_key_change","p0") {
- //Test the unique model by adding a key column with JSON
+ //TODO Test the unique model by adding a key column with JSON
//java.sql.SQLException: errCode = 2, detailMessage = JSONB type should
not be used in key column[j].
/* sql initTable
sql initTableData
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
