This is an automated email from the ASF dual-hosted git repository.
kxiao pushed a commit to branch branch-2.0
in repository https://gitbox.apache.org/repos/asf/doris.git
The following commit(s) were added to refs/heads/branch-2.0 by this push:
new ed729cd9606 [fix](information_schema) fix test_query_sys_tables
schema_privileges regression case #26753 (#26800)
ed729cd9606 is described below
commit ed729cd9606cdbad6f38fa42ef80848f5d8d8592
Author: daidai <[email protected]>
AuthorDate: Sat Nov 11 15:50:36 2023 +0800
[fix](information_schema) fix test_query_sys_tables schema_privileges
regression case #26753 (#26800)
---
regression-test/suites/query_p0/system/test_query_sys_tables.groovy | 6 +++---
1 file changed, 3 insertions(+), 3 deletions(-)
diff --git
a/regression-test/suites/query_p0/system/test_query_sys_tables.groovy
b/regression-test/suites/query_p0/system/test_query_sys_tables.groovy
index ad4a5f12bb1..7d943894168 100644
--- a/regression-test/suites/query_p0/system/test_query_sys_tables.groovy
+++ b/regression-test/suites/query_p0/system/test_query_sys_tables.groovy
@@ -114,7 +114,7 @@ suite("test_query_sys_tables", "query,p0") {
// test table_privileges
sql """ DROP USER if exists 'cywtable'; """
qt_desc_table_privileges """desc `information_schema`.`table_privileges`
"""
- order_qt_table_privileges """ select * from
information_schema.table_privileges """
+ order_qt_table_privileges """ select * from
information_schema.table_privileges where GRANTEE = "'cywtable'@'%'" ; """
sql """ CREATE USER 'cywtable'; """
sql """ CREATE DATABASE IF NOT EXISTS table_privileges_demo """
sql """ create table IF NOT EXISTS
table_privileges_demo.test_table_privileges(
@@ -129,9 +129,9 @@ suite("test_query_sys_tables", "query,p0") {
);"""
sql """ GRANT SELECT_PRIV,ALTER_PRIV,LOAD_PRIV ON
table_privileges_demo.test_table_privileges TO 'cywtable'@'%'; """
- order_qt_table_privileges2 """ select * from
information_schema.table_privileges order by PRIVILEGE_TYPE ; """
+ order_qt_table_privileges2 """ select * from
information_schema.table_privileges where GRANTEE = "'cywtable'@'%'" order by
PRIVILEGE_TYPE ; """
sql """ REVOKE SELECT_PRIV ON table_privileges_demo.test_table_privileges
FROM 'cywtable'@'%'; """
- order_qt_table_privileges3 """ select * from
information_schema.table_privileges order by PRIVILEGE_TYPE ; """
+ order_qt_table_privileges3 """ select * from
information_schema.table_privileges where GRANTEE = "'cywtable'@'%'" order by
PRIVILEGE_TYPE ; """
// test partitions
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
