This is an automated email from the ASF dual-hosted git repository.
morningman pushed a commit to branch branch-2.1
in repository https://gitbox.apache.org/repos/asf/doris.git
The following commit(s) were added to refs/heads/branch-2.1 by this push:
new 51bb4e93313 [fix](test-case) fix unstable test case about
table_options sys table(#41006) (#41121)
51bb4e93313 is described below
commit 51bb4e93313009f606e7ee77fe447ae437d33260
Author: Mingyu Chen <[email protected]>
AuthorDate: Mon Sep 23 17:00:51 2024 +0800
[fix](test-case) fix unstable test case about table_options sys
table(#41006) (#41121)
bp #41006
---
regression-test/data/query_p0/system/test_table_properties.out | 6 ------
.../suites/query_p0/system/test_table_properties.groovy | 10 +++++-----
2 files changed, 5 insertions(+), 11 deletions(-)
diff --git a/regression-test/data/query_p0/system/test_table_properties.out
b/regression-test/data/query_p0/system/test_table_properties.out
index f69fd14aea5..dc18e504c45 100644
--- a/regression-test/data/query_p0/system/test_table_properties.out
+++ b/regression-test/data/query_p0/system/test_table_properties.out
@@ -12,7 +12,6 @@ internal test_table_properties_db duplicate_table
compaction_policy size_based
internal test_table_properties_db duplicate_table compression
LZ4F
internal test_table_properties_db duplicate_table
data_sort.col_num 3
internal test_table_properties_db duplicate_table
data_sort.sort_type LEXICAL
-internal test_table_properties_db duplicate_table
default.replication_allocation tag.location.default: 1
internal test_table_properties_db duplicate_table
disable_auto_compaction false
internal test_table_properties_db duplicate_table
enable_mow_light_delete false
internal test_table_properties_db duplicate_table
enable_single_replica_compaction false
@@ -43,7 +42,6 @@ internal test_table_properties_db listtable
compaction_policy size_based
internal test_table_properties_db listtable compression
LZ4F
internal test_table_properties_db listtable
data_sort.col_num 6
internal test_table_properties_db listtable
data_sort.sort_type LEXICAL
-internal test_table_properties_db listtable
default.replication_allocation tag.location.default: 1
internal test_table_properties_db listtable
disable_auto_compaction false
internal test_table_properties_db listtable
enable_mow_light_delete false
internal test_table_properties_db listtable
enable_single_replica_compaction false
@@ -74,7 +72,6 @@ internal test_table_properties_db unique_table
compaction_policy size_based
internal test_table_properties_db unique_table compression
LZ4F
internal test_table_properties_db unique_table
data_sort.col_num 2
internal test_table_properties_db unique_table
data_sort.sort_type LEXICAL
-internal test_table_properties_db unique_table
default.replication_allocation tag.location.default: 1
internal test_table_properties_db unique_table
disable_auto_compaction false
internal test_table_properties_db unique_table
enable_mow_light_delete false
internal test_table_properties_db unique_table
enable_single_replica_compaction false
@@ -107,7 +104,6 @@ internal test_table_properties_db duplicate_table
compaction_policy size_based
internal test_table_properties_db duplicate_table compression
LZ4F
internal test_table_properties_db duplicate_table
data_sort.col_num 3
internal test_table_properties_db duplicate_table
data_sort.sort_type LEXICAL
-internal test_table_properties_db duplicate_table
default.replication_allocation tag.location.default: 1
internal test_table_properties_db duplicate_table
disable_auto_compaction false
internal test_table_properties_db duplicate_table
enable_mow_light_delete false
internal test_table_properties_db duplicate_table
enable_single_replica_compaction false
@@ -138,7 +134,6 @@ internal test_table_properties_db unique_table
compaction_policy size_based
internal test_table_properties_db unique_table compression
LZ4F
internal test_table_properties_db unique_table
data_sort.col_num 2
internal test_table_properties_db unique_table
data_sort.sort_type LEXICAL
-internal test_table_properties_db unique_table
default.replication_allocation tag.location.default: 1
internal test_table_properties_db unique_table
disable_auto_compaction false
internal test_table_properties_db unique_table
enable_mow_light_delete false
internal test_table_properties_db unique_table
enable_single_replica_compaction false
@@ -173,7 +168,6 @@ internal test_table_properties_db duplicate_table
compaction_policy size_based
internal test_table_properties_db duplicate_table compression
LZ4F
internal test_table_properties_db duplicate_table
data_sort.col_num 3
internal test_table_properties_db duplicate_table
data_sort.sort_type LEXICAL
-internal test_table_properties_db duplicate_table
default.replication_allocation tag.location.default: 1
internal test_table_properties_db duplicate_table
disable_auto_compaction false
internal test_table_properties_db duplicate_table
enable_mow_light_delete false
internal test_table_properties_db duplicate_table
enable_single_replica_compaction false
diff --git
a/regression-test/suites/query_p0/system/test_table_properties.groovy
b/regression-test/suites/query_p0/system/test_table_properties.groovy
index 7dd55d4fb78..3314975d689 100644
--- a/regression-test/suites/query_p0/system/test_table_properties.groovy
+++ b/regression-test/suites/query_p0/system/test_table_properties.groovy
@@ -84,11 +84,11 @@ suite("test_table_properties") {
"""
qt_select_check_1 """select count(*) from
information_schema.table_properties where table_schema=\"${dbName}\"; """
- qt_select_check_2 """select * from information_schema.table_properties
where table_schema=\"${dbName}\" ORDER BY
TABLE_CATALOG,TABLE_SCHEMA,TABLE_NAME,PROPERTY_NAME,PROPERTY_VALUE; """
+ qt_select_check_2 """select * from information_schema.table_properties
where table_schema=\"${dbName}\" and PROPERTY_NAME !=
"default.replication_allocation" ORDER BY
TABLE_CATALOG,TABLE_SCHEMA,TABLE_NAME,PROPERTY_NAME,PROPERTY_VALUE"""
sql """
drop table listtable;
"""
- qt_select_check_3 """select * from information_schema.table_properties
where table_schema=\"${dbName}\" ORDER BY
TABLE_CATALOG,TABLE_SCHEMA,TABLE_NAME,PROPERTY_NAME,PROPERTY_VALUE; """
+ qt_select_check_3 """select * from information_schema.table_properties
where table_schema=\"${dbName}\" and PROPERTY_NAME !=
"default.replication_allocation" ORDER BY
TABLE_CATALOG,TABLE_SCHEMA,TABLE_NAME,PROPERTY_NAME,PROPERTY_VALUE"""
def user = "table_properties_user"
sql "DROP USER IF EXISTS ${user}"
@@ -106,17 +106,17 @@ suite("test_table_properties") {
def url=tokens[0] + "//" + tokens[2] + "/" + "information_schema" + "?"
connect(user=user, password='123abc!@#', url=url) {
- qt_select_check_4 """select * from information_schema.table_properties
ORDER BY TABLE_CATALOG,TABLE_SCHEMA,TABLE_NAME,PROPERTY_NAME,PROPERTY_VALUE;
"""
+ qt_select_check_4 """select * from information_schema.table_properties
where PROPERTY_NAME != "default.replication_allocation" ORDER BY
TABLE_CATALOG,TABLE_SCHEMA,TABLE_NAME,PROPERTY_NAME,PROPERTY_VALUE"""
}
sql "GRANT SELECT_PRIV ON ${dbName}.duplicate_table TO ${user}"
connect(user=user, password='123abc!@#', url=url) {
- qt_select_check_5 """select * from information_schema.table_properties
ORDER BY TABLE_CATALOG,TABLE_SCHEMA,TABLE_NAME,PROPERTY_NAME,PROPERTY_VALUE;
"""
+ qt_select_check_5 """select * from information_schema.table_properties
where PROPERTY_NAME != "default.replication_allocation" ORDER BY
TABLE_CATALOG,TABLE_SCHEMA,TABLE_NAME,PROPERTY_NAME,PROPERTY_VALUE"""
}
sql "REVOKE SELECT_PRIV ON ${dbName}.duplicate_table FROM ${user}"
connect(user=user, password='123abc!@#', url=url) {
- qt_select_check_6 """select * from information_schema.table_properties
ORDER BY TABLE_CATALOG,TABLE_SCHEMA,TABLE_NAME,PROPERTY_NAME,PROPERTY_VALUE;
"""
+ qt_select_check_6 """select * from information_schema.table_properties
where PROPERTY_NAME != "default.replication_allocation" ORDER BY
TABLE_CATALOG,TABLE_SCHEMA,TABLE_NAME,PROPERTY_NAME,PROPERTY_VALUE"""
}
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
