You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by yi...@apache.org on 2024/02/24 08:27:22 UTC
(doris) branch branch-2.1 updated (8001f73e521 -> 93cbc96141c)
This is an automated email from the ASF dual-hosted git repository.
yiguolei pushed a change to branch branch-2.1
in repository https://gitbox.apache.org/repos/asf/doris.git
from 8001f73e521 [pipelineX](file scan) Improve parallel tasks if ignore data distribution (#31328)
new 09efc92d46e [Fix](regression) make test_index_compaction_with_multi_index_segments nonConcurrent to avoid concurrent be config modify (#31344)
new 93cbc96141c [regression test]Opt Test UniqueModel Schema Key Change (#31262)
The 2 revisions listed above as "new" are entirely new to this
repository and will be described in separate emails. The revisions
listed as "add" were already present in the repository and have only
been added to this reference.
Summary of changes:
.../test_unique_model_schema_key_change.out | 10 -------
...dex_compaction_with_multi_index_segments.groovy | 2 +-
.../test_unique_model_schema_key_change.groovy | 31 +++++++---------------
3 files changed, 10 insertions(+), 33 deletions(-)
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
(doris) 01/02: [Fix](regression) make test_index_compaction_with_multi_index_segments nonConcurrent to avoid concurrent be config modify (#31344)
Posted by yi...@apache.org.
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 09efc92d46e8bbecdb399209d6072bddd91705be
Author: airborne12 <ai...@gmail.com>
AuthorDate: Sat Feb 24 11:55:47 2024 +0800
[Fix](regression) make test_index_compaction_with_multi_index_segments nonConcurrent to avoid concurrent be config modify (#31344)
---
.../test_index_compaction_with_multi_index_segments.groovy | 2 +-
1 file changed, 1 insertion(+), 1 deletion(-)
diff --git a/regression-test/suites/inverted_index_p0/index_compaction/test_index_compaction_with_multi_index_segments.groovy b/regression-test/suites/inverted_index_p0/index_compaction/test_index_compaction_with_multi_index_segments.groovy
index 693e4aac1b4..4023715c612 100644
--- a/regression-test/suites/inverted_index_p0/index_compaction/test_index_compaction_with_multi_index_segments.groovy
+++ b/regression-test/suites/inverted_index_p0/index_compaction/test_index_compaction_with_multi_index_segments.groovy
@@ -17,7 +17,7 @@
import org.codehaus.groovy.runtime.IOGroovyMethods
-suite("test_index_compaction_with_multi_index_segments", "p0") {
+suite("test_index_compaction_with_multi_index_segments", "nonConcurrent") {
def tableName = "test_index_compaction_with_multi_index_segments"
def backendId_to_backendIP = [:]
def backendId_to_backendHttpPort = [:]
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
(doris) 02/02: [regression test]Opt Test UniqueModel Schema Key Change (#31262)
Posted by yi...@apache.org.
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 93cbc96141cafce81fb6941b4d1f6a63a45ace07
Author: kkop <45...@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-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org