This is an automated email from the ASF dual-hosted git repository.
morningman 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 8160a04b351 [fix](information_schema) fix test_query_sys_tables
schema_privileges regression case. (#26753)
8160a04b351 is described below
commit 8160a04b351ffffdbbdf54a68ac74723eaed77cc
Author: daidai <2017501...@qq.com>
AuthorDate: Mon Nov 13 16:04:30 2023 +0800
[fix](information_schema) fix test_query_sys_tables schema_privileges
regression case. (#26753)
---
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: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
