hubgeter commented on code in PR #26238:
URL: https://github.com/apache/doris/pull/26238#discussion_r1380243265
##########
regression-test/suites/query_p0/system/test_query_sys_tables.groovy:
##########
@@ -87,12 +87,53 @@ suite("test_query_sys_tables", "query,p0") {
// test files
// have no impl
+ qt_desc_files """desc `information_schema`.`files` """
+ qt_query_files """ select * from `information_schema`.`files` """
+
+ // test schema_privileges
+ // have no impl
+ qt_desc_schema_privileges """desc `information_schema`.`schema_privileges`
"""
+ qt_select_schema_privileges """ select * from
information_schema.schema_privileges where GRANTEE = "root%" """
+
+ // test table_privileges
+ // have no impl(fe:listTablePrivilegeStatus)
+ qt_desc_table_privileges """desc `information_schema`.`table_privileges`
"""
+ qt_select_schema_privileges """ select * from
information_schema.table_privileges """
+
// test partitions
// have no impl
+ qt_desc_partitions """ desc `information_schema`.`partitions` """
+ qt_select_partitions """ select * from `information_schema`.`partitions`;
"""
+
+
// test rowsets
- // have no tablet system table, add this later
+ qt_desc_rowsets """ desc information_schema.rowsets """
+ def rowsets_table_name = """ test_query_sys_db_1.test_query_rowset """
+ sql """ drop table if exists ${rowsets_table_name} """
+
+ sql """
+ create table ${rowsets_table_name}(
+ a int ,
+ b boolean ,
+ c string )
+ DISTRIBUTED BY HASH(`a`) BUCKETS 1
+ PROPERTIES (
+ "replication_num" = "1",
+ "disable_auto_compaction" = "true",
+ "enable_single_replica_compaction"="true"
+ );
+ """
+
+ List<List<Object>> rowsets_table_name_tablts = sql """ show tablets from
${rowsets_table_name} """
Review Comment:
Only the two tables information_schema.statistics and
information_schema.table_constraints have no test case.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
