This is an automated email from the ASF dual-hosted git repository.
hellostephen 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 927c6f1af8e [test](case) add system table simple query test (#47651)
927c6f1af8e is described below
commit 927c6f1af8e1269769a0e982bdd9a90ab1f9a476
Author: wangbo <[email protected]>
AuthorDate: Mon Feb 10 10:32:06 2025 +0800
[test](case) add system table simple query test (#47651)
### What problem does this PR solve?
Issue Number: close #xxx
Related PR: #xxx
Problem Summary:
add system table simple query test
---
.../suites/query_p0/system/test_query_sys_tables.groovy | 7 +++++++
1 file changed, 7 insertions(+)
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 a0f246f03f6..2e1826b4eaa 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
@@ -253,4 +253,11 @@ suite("test_query_sys_tables", "query,p0") {
qt_sql "select * from triggers"
qt_sql "select * from parameters"
qt_sql "select * from profiling"
+
+ // test systable is queryable
+ String[][] systabs = sql "USE information_schema;show tables"
+ System.out.println(systabs)
+ for (String[] tab : systabs) {
+ sql "select * from ${tab[0]} limit 10"
+ }
}
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
