You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by du...@apache.org on 2023/08/04 05:38:45 UTC
[shardingsphere] branch master updated: Move system tables e2e to tbl (#27905)
This is an automated email from the ASF dual-hosted git repository.
duanzhengqiang pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/shardingsphere.git
The following commit(s) were added to refs/heads/master by this push:
new adcf0761204 Move system tables e2e to tbl (#27905)
adcf0761204 is described below
commit adcf076120405d4c307519ffa089c5e03af16a1e
Author: ZhangCheng <ch...@apache.org>
AuthorDate: Fri Aug 4 13:38:37 2023 +0800
Move system tables e2e to tbl (#27905)
* Move system table e2e to tbl
* Support jdbc adapter to get databaseName from sql
* Support jdbc adapter to get databaseName from sql
* Support jdbc adapter to get databaseName from sql
---
.../dql-integration-select-system-schema-mysql.xml | 914 +++++------
...-integration-select-system-schema-opengauss.xml | 1622 ++++++++------------
...integration-select-system-schema-postgresql.xml | 808 +++-------
3 files changed, 1172 insertions(+), 2172 deletions(-)
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dql-integration-select-system-schema-mysql.xml b/test/e2e/sql/src/test/resources/cases/dql/dql-integration-select-system-schema-mysql.xml
index e5caa7956d2..beaa4dc0bfd 100644
--- a/test/e2e/sql/src/test/resources/cases/dql/dql-integration-select-system-schema-mysql.xml
+++ b/test/e2e/sql/src/test/resources/cases/dql/dql-integration-select-system-schema-mysql.xml
@@ -17,915 +17,739 @@
-->
<integration-test-cases>
- <test-case sql="SELECT * FROM information_schema.innodb_buffer_page" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_information_schema_innodb_buffer_page.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM information_schema.innodb_buffer_page_lru" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_information_schema_innodb_buffer_page_lru.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM information_schema.innodb_buffer_pool_stats" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_information_schema_innodb_buffer_pool_stats.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM information_schema.innodb_cmp" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_information_schema_innodb_cmp.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM information_schema.innodb_cmp_per_index" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_information_schema_innodb_cmp_per_index.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM information_schema.innodb_cmp_per_index_reset" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_information_schema_innodb_cmp_per_index_reset.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM information_schema.innodb_cmp_reset" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_information_schema_innodb_cmp_reset.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM information_schema.innodb_buffer_page" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_information_schema_innodb_buffer_page.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM information_schema.innodb_buffer_page_lru" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_information_schema_innodb_buffer_page_lru.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM information_schema.innodb_buffer_pool_stats" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_information_schema_innodb_buffer_pool_stats.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM information_schema.innodb_cmp" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_information_schema_innodb_cmp.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM information_schema.innodb_cmp_per_index" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_information_schema_innodb_cmp_per_index.xml" />
+ <test-case sql="SELECT * FROM information_schema.innodb_buffer_page_lru limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM information_schema.innodb_cmp_per_index_reset" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_information_schema_innodb_cmp_per_index_reset.xml" />
+ <test-case sql="SELECT * FROM information_schema.innodb_cmp limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM information_schema.innodb_cmp_reset" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_information_schema_innodb_cmp_reset.xml" />
+ <test-case sql="SELECT * FROM information_schema.innodb_cmp_per_index limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM information_schema.innodb_cmpmem" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_information_schema_innodb_cmpmem.xml" />
+ <test-case sql="SELECT * FROM information_schema.innodb_cmp_per_index_reset limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM information_schema.innodb_cmpmem_reset" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_information_schema_innodb_cmpmem_reset.xml" />
+ <test-case sql="SELECT * FROM information_schema.innodb_cmp_reset limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM information_schema.innodb_ft_being_deleted" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_information_schema_innodb_ft_being_deleted.xml" />
+ <test-case sql="SELECT * FROM information_schema.innodb_buffer_page limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM information_schema.innodb_ft_config" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_information_schema_innodb_ft_config.xml" />
+ <test-case sql="SELECT * FROM information_schema.innodb_buffer_page_lru limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM information_schema.innodb_ft_default_stopword" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_information_schema_innodb_ft_default_stopword.xml" />
+ <test-case sql="SELECT * FROM information_schema.innodb_cmp limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM information_schema.innodb_ft_deleted" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_information_schema_innodb_ft_deleted.xml" />
+ <test-case sql="SELECT * FROM information_schema.innodb_cmp_per_index limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM information_schema.innodb_ft_index_cache" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_information_schema_innodb_ft_index_cache.xml" />
+ <test-case sql="SELECT * FROM information_schema.innodb_cmp_per_index_reset limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM information_schema.innodb_ft_index_table" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_information_schema_innodb_ft_index_table.xml" />
+ <test-case sql="SELECT * FROM information_schema.innodb_cmp_reset limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM information_schema.innodb_lock_waits" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_information_schema_innodb_lock_waits.xml" />
+ <test-case sql="SELECT * FROM information_schema.innodb_cmpmem limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM information_schema.innodb_locks" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_information_schema_innodb_locks.xml" />
+ <test-case sql="SELECT * FROM information_schema.innodb_cmpmem_reset limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM information_schema.innodb_metrics" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_information_schema_innodb_metrics.xml" />
+ <test-case sql="SELECT * FROM information_schema.innodb_ft_being_deleted limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM information_schema.innodb_sys_columns" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_information_schema_innodb_sys_columns.xml" />
+ <test-case sql="SELECT * FROM information_schema.innodb_ft_config limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM information_schema.innodb_sys_datafiles" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_information_schema_innodb_sys_datafiles.xml" />
+ <test-case sql="SELECT * FROM information_schema.innodb_ft_default_stopword limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM information_schema.innodb_sys_fields" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_information_schema_innodb_sys_fields.xml" />
+ <test-case sql="SELECT * FROM information_schema.innodb_ft_deleted limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM information_schema.innodb_sys_foreign" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_information_schema_innodb_sys_foreign.xml" />
+ <test-case sql="SELECT * FROM information_schema.innodb_ft_index_cache limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM information_schema.innodb_sys_foreign_cols" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_information_schema_innodb_sys_foreign_cols.xml" />
+ <test-case sql="SELECT * FROM information_schema.innodb_ft_index_table limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM information_schema.innodb_sys_indexes" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_information_schema_innodb_sys_indexes.xml" />
+ <test-case sql="SELECT * FROM information_schema.innodb_lock_waits limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM information_schema.innodb_sys_tables" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_information_schema_innodb_sys_tables.xml" />
+ <test-case sql="SELECT * FROM information_schema.innodb_locks limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM information_schema.innodb_sys_tablespaces" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_information_schema_innodb_sys_tablespaces.xml" />
+ <test-case sql="SELECT * FROM information_schema.innodb_metrics limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM information_schema.innodb_sys_tablestats" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_information_schema_innodb_sys_tablestats.xml" />
+ <test-case sql="SELECT * FROM information_schema.innodb_sys_columns limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM information_schema.innodb_sys_virtual" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_information_schema_innodb_sys_virtual.xml" />
+ <test-case sql="SELECT * FROM information_schema.innodb_sys_datafiles limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM information_schema.innodb_temp_table_info" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_information_schema_innodb_temp_table_info.xml" />
+ <test-case sql="SELECT * FROM information_schema.innodb_sys_fields limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM information_schema.innodb_trx" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_information_schema_innodb_trx.xml" />
+ <test-case sql="SELECT * FROM information_schema.innodb_sys_foreign limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM information_schema.key_column_usage" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_information_schema_key_column_usage.xml" />
+ <test-case sql="SELECT * FROM information_schema.innodb_sys_foreign_cols limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM information_schema.optimizer_trace" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_information_schema_optimizer_trace.xml" />
+ <test-case sql="SELECT * FROM information_schema.innodb_sys_indexes limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM information_schema.parameters" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_information_schema_parameters.xml" />
+ <test-case sql="SELECT * FROM information_schema.innodb_sys_tables limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM information_schema.partitions limit 10" db-types="MySQL" scenario-types="db">
+ <test-case sql="SELECT * FROM information_schema.innodb_sys_tablespaces limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
<assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM information_schema.plugins" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_information_schema_plugins.xml" />
+ <test-case sql="SELECT * FROM information_schema.innodb_sys_tablestats limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM information_schema.processlist" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_information_schema_processlist.xml" />
+ <test-case sql="SELECT * FROM information_schema.innodb_sys_virtual limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM information_schema.profiling" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_information_schema_profiling.xml" />
+ <test-case sql="SELECT * FROM information_schema.innodb_temp_table_info limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM information_schema.referential_constraints" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_information_schema_referential_constraints.xml" />
+ <test-case sql="SELECT * FROM information_schema.innodb_trx limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM information_schema.routines" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_information_schema_routines.xml" />
+ <test-case sql="SELECT * FROM information_schema.key_column_usage limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM information_schema.schema_privileges" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_information_schema_schema_privileges.xml" />
+ <test-case sql="SELECT * FROM information_schema.optimizer_trace limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM information_schema.schemata" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_information_schema_schemata.xml" />
+ <test-case sql="SELECT * FROM information_schema.parameters limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM information_schema.session_status" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_information_schema_session_status.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM information_schema.session_variables" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_information_schema_session_variables.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM information_schema.statistics" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_information_schema_statistics.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM information_schema.table_constraints" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_information_schema_table_constraints.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM information_schema.table_privileges" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_information_schema_table_privileges.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM information_schema.tables" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_information_schema_tables.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM information_schema.tablespaces" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_information_schema_tablespaces.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM information_schema.triggers" db-types="MySQL" scenario-types="db">
+ <test-case sql="SELECT * FROM information_schema.plugins limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
<assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM information_schema.user_privileges" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_information_schema_user_privileges.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM mysql.columns_priv" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_mysql_columns_priv.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM mysql.db" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_mysql_db.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM mysql.engine_cost" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_mysql_engine_cost.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM mysql.event" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_mysql_event.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM mysql.func" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_mysql_func.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM mysql.general_log" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_mysql_general_log.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM mysql.gtid_executed" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_mysql_gtid_executed.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM mysql.help_category" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_mysql_help_category.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM mysql.help_keyword" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_mysql_help_keyword.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM mysql.help_relation" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_mysql_help_relation.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM mysql.help_topic" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_mysql_help_topic.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM mysql.innodb_index_stats" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_mysql_innodb_index_stats.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM mysql.innodb_table_stats" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_mysql_innodb_table_stats.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM mysql.ndb_binlog_index" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_mysql_ndb_binlog_index.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM mysql.plugin" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_mysql_plugin.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM mysql.proc" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_mysql_proc.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM mysql.procs_priv" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_mysql_procs_priv.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM mysql.proxies_priv" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_mysql_proxies_priv.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM mysql.server_cost" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_mysql_server_cost.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM mysql.servers" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_mysql_servers.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM mysql.slave_master_info" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_mysql_slave_master_info.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM mysql.slave_relay_log_info" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_mysql_slave_relay_log_info.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM mysql.slave_worker_info" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_mysql_slave_worker_info.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM mysql.slow_log" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_mysql_slow_log.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM mysql.tables_priv" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_mysql_tables_priv.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM mysql.time_zone" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_mysql_time_zone.xml" />
+ <test-case sql="SELECT * FROM information_schema.profiling limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM mysql.time_zone_leap_second" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_mysql_time_zone_leap_second.xml" />
+ <test-case sql="SELECT * FROM information_schema.referential_constraints limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM mysql.time_zone_name" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_mysql_time_zone_name.xml" />
+ <test-case sql="SELECT * FROM information_schema.routines limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM mysql.time_zone_transition" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_mysql_time_zone_transition.xml" />
+ <test-case sql="SELECT * FROM information_schema.schema_privileges limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM mysql.time_zone_transition_type" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_mysql_time_zone_transition_type.xml" />
+ <test-case sql="SELECT * FROM information_schema.statistics limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM mysql.user" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_mysql_user.xml" />
+ <test-case sql="SELECT * FROM information_schema.table_constraints limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM performance_schema.accounts" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_performance_schema_accounts.xml" />
+ <test-case sql="SELECT * FROM information_schema.table_privileges limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM performance_schema.cond_instances" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_performance_schema_cond_instances.xml" />
+ <test-case sql="SELECT TABLE_NAME FROM information_schema.tables where TABLE_NAME='time_zone' limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM performance_schema.events_stages_current" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_performance_schema_events_stages_current.xml" />
+ <test-case sql="SELECT * FROM information_schema.tablespaces limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM performance_schema.events_stages_history" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_performance_schema_events_stages_history.xml" />
+ <test-case sql="SELECT * FROM information_schema.triggers limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM performance_schema.events_stages_history_long" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_performance_schema_events_stages_history_long.xml" />
+ <test-case sql="SELECT * FROM information_schema.user_privileges limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM performance_schema.events_stages_summary_by_account_by_event_name" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_performance_schema_events_stages_summary_by_account_by_event_name.xml" />
+ <test-case sql="SELECT * FROM mysql.columns_priv limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM performance_schema.events_stages_summary_by_host_by_event_name" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_performance_schema_events_stages_summary_by_host_by_event_name.xml" />
+ <test-case sql="SELECT * FROM mysql.db limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM performance_schema.events_stages_summary_by_thread_by_event_name" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_performance_schema_events_stages_summary_by_thread_by_event_name.xml" />
+ <test-case sql="SELECT * FROM mysql.engine_cost limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM performance_schema.events_stages_summary_by_user_by_event_name" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_performance_schema_events_stages_summary_by_user_by_event_name.xml" />
+ <test-case sql="SELECT * FROM mysql.event limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM performance_schema.events_stages_summary_global_by_event_name" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_performance_schema_events_stages_summary_global_by_event_name.xml" />
+ <test-case sql="SELECT * FROM mysql.func limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM performance_schema.events_statements_current" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_performance_schema_events_statements_current.xml" />
+ <test-case sql="SELECT * FROM mysql.general_log limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM performance_schema.events_statements_history" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_performance_schema_events_statements_history.xml" />
+ <test-case sql="SELECT * FROM mysql.gtid_executed limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM performance_schema.events_statements_history_long" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_performance_schema_events_statements_history_long.xml" />
+ <test-case sql="SELECT * FROM mysql.help_category limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM performance_schema.events_statements_summary_by_account_by_event_name" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_performance_schema_events_statements_summary_by_account_by_event_name.xml" />
+ <test-case sql="SELECT * FROM mysql.help_keyword limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM performance_schema.events_statements_summary_by_digest" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_performance_schema_events_statements_summary_by_digest.xml" />
+ <test-case sql="SELECT * FROM mysql.help_relation limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM performance_schema.events_statements_summary_by_host_by_event_name" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_performance_schema_events_statements_summary_by_host_by_event_name.xml" />
+ <test-case sql="SELECT * FROM mysql.help_topic limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM performance_schema.events_statements_summary_by_program" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_performance_schema_events_statements_summary_by_program.xml" />
+ <test-case sql="SELECT * FROM mysql.innodb_index_stats limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM performance_schema.events_statements_summary_by_thread_by_event_name" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_performance_schema_events_statements_summary_by_thread_by_event_name.xml" />
+ <test-case sql="SELECT * FROM mysql.innodb_table_stats limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM performance_schema.events_statements_summary_by_user_by_event_name" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_performance_schema_events_statements_summary_by_user_by_event_name.xml" />
+ <test-case sql="SELECT * FROM mysql.ndb_binlog_index limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM performance_schema.events_statements_summary_global_by_event_name" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_performance_schema_events_statements_summary_global_by_event_name.xml" />
+ <test-case sql="SELECT * FROM mysql.plugin limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM performance_schema.events_transactions_current" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_performance_schema_events_transactions_current.xml" />
+ <test-case sql="SELECT * FROM mysql.procs_priv limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM performance_schema.events_transactions_history" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_performance_schema_events_transactions_history.xml" />
+ <test-case sql="SELECT * FROM mysql.server_cost limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM performance_schema.events_transactions_history_long" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_performance_schema_events_transactions_history_long.xml" />
+ <test-case sql="SELECT * FROM mysql.servers limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM performance_schema.events_transactions_summary_by_account_by_event_name" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_performance_schema_events_transactions_summary_by_account_by_event_name.xml" />
+ <test-case sql="SELECT * FROM mysql.slave_master_info limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM performance_schema.events_transactions_summary_by_host_by_event_name" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_performance_schema_events_transactions_summary_by_host_by_event_name.xml" />
+ <test-case sql="SELECT * FROM mysql.slave_relay_log_info limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM performance_schema.events_transactions_summary_by_thread_by_event_name" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_performance_schema_events_transactions_summary_by_thread_by_event_name.xml" />
+ <test-case sql="SELECT * FROM mysql.slave_worker_info limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM performance_schema.events_transactions_summary_by_user_by_event_name" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_performance_schema_events_transactions_summary_by_user_by_event_name.xml" />
+ <test-case sql="SELECT * FROM mysql.slow_log limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM performance_schema.events_transactions_summary_global_by_event_name" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_performance_schema_events_transactions_summary_global_by_event_name.xml" />
+ <test-case sql="SELECT * FROM mysql.time_zone limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM performance_schema.events_waits_current" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_performance_schema_events_waits_current.xml" />
+ <test-case sql="SELECT * FROM mysql.time_zone_leap_second limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM performance_schema.events_waits_history" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_performance_schema_events_waits_history.xml" />
+ <test-case sql="SELECT * FROM mysql.time_zone_name limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM performance_schema.events_waits_history_long" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_performance_schema_events_waits_history_long.xml" />
+ <test-case sql="SELECT * FROM mysql.time_zone_transition limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM performance_schema.events_waits_summary_by_account_by_event_name" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_performance_schema_events_waits_summary_by_account_by_event_name.xml" />
+ <test-case sql="SELECT * FROM mysql.time_zone_transition_type limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM performance_schema.events_waits_summary_by_host_by_event_name" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_performance_schema_events_waits_summary_by_host_by_event_name.xml" />
+ <test-case sql="SELECT * FROM performance_schema.accounts limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM performance_schema.events_waits_summary_by_instance" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_performance_schema_events_waits_summary_by_instance.xml" />
+ <test-case sql="SELECT * FROM performance_schema.cond_instances limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM performance_schema.events_waits_summary_by_thread_by_event_name" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_performance_schema_events_waits_summary_by_thread_by_event_name.xml" />
+ <test-case sql="SELECT * FROM performance_schema.events_stages_current limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM performance_schema.events_waits_summary_by_user_by_event_name" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_performance_schema_events_waits_summary_by_user_by_event_name.xml" />
+ <test-case sql="SELECT * FROM performance_schema.events_stages_history limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM performance_schema.events_waits_summary_global_by_event_name" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_performance_schema_events_waits_summary_global_by_event_name.xml" />
+ <test-case sql="SELECT * FROM performance_schema.events_stages_history_long limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM performance_schema.file_instances" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_performance_schema_file_instances.xml" />
+ <test-case sql="SELECT * FROM performance_schema.events_stages_summary_by_account_by_event_name limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM performance_schema.file_summary_by_event_name" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_performance_schema_file_summary_by_event_name.xml" />
+ <test-case sql="SELECT * FROM performance_schema.events_stages_summary_by_host_by_event_name limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM performance_schema.file_summary_by_instance" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_performance_schema_file_summary_by_instance.xml" />
+ <test-case sql="SELECT * FROM performance_schema.events_stages_summary_by_thread_by_event_name limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM performance_schema.global_status" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_performance_schema_global_status.xml" />
+ <test-case sql="SELECT * FROM performance_schema.events_stages_summary_by_user_by_event_name limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM performance_schema.global_variables" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_performance_schema_global_variables.xml" />
+ <test-case sql="SELECT * FROM performance_schema.events_stages_summary_global_by_event_name limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM performance_schema.host_cache" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_performance_schema_host_cache.xml" />
+ <test-case sql="SELECT * FROM performance_schema.events_statements_history_long limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM performance_schema.hosts" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_performance_schema_hosts.xml" />
+ <test-case sql="SELECT * FROM performance_schema.events_statements_summary_by_digest limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM performance_schema.memory_summary_by_account_by_event_name" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_performance_schema_memory_summary_by_account_by_event_name.xml" />
+ <test-case sql="SELECT * FROM performance_schema.events_statements_summary_by_program limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM performance_schema.memory_summary_by_host_by_event_name" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_performance_schema_memory_summary_by_host_by_event_name.xml" />
+ <test-case sql="SELECT * FROM performance_schema.events_statements_summary_by_user_by_event_name limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM performance_schema.memory_summary_by_thread_by_event_name" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_performance_schema_memory_summary_by_thread_by_event_name.xml" />
+
+ <test-case sql="SELECT * FROM performance_schema.events_transactions_current limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM performance_schema.memory_summary_by_user_by_event_name" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_performance_schema_memory_summary_by_user_by_event_name.xml" />
+ <test-case sql="SELECT * FROM performance_schema.events_transactions_history limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM performance_schema.memory_summary_global_by_event_name" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_performance_schema_memory_summary_global_by_event_name.xml" />
+ <test-case sql="SELECT * FROM performance_schema.events_transactions_history_long limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM performance_schema.metadata_locks" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_performance_schema_metadata_locks.xml" />
+ <test-case sql="SELECT * FROM performance_schema.events_transactions_summary_by_account_by_event_name limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM performance_schema.mutex_instances" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_performance_schema_mutex_instances.xml" />
+ <test-case sql="SELECT * FROM performance_schema.events_transactions_summary_by_host_by_event_name limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM performance_schema.objects_summary_global_by_type" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_performance_schema_objects_summary_global_by_type.xml" />
+ <test-case sql="SELECT * FROM performance_schema.events_transactions_summary_by_thread_by_event_name limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM performance_schema.performance_timers" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_performance_schema_performance_timers.xml" />
+ <test-case sql="SELECT * FROM performance_schema.events_transactions_summary_by_user_by_event_name limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM performance_schema.prepared_statements_instances" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_performance_schema_prepared_statements_instances.xml" />
+ <test-case sql="SELECT * FROM performance_schema.events_transactions_summary_global_by_event_name limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM performance_schema.replication_applier_configuration" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_performance_schema_replication_applier_configuration.xml" />
+ <test-case sql="SELECT * FROM performance_schema.events_waits_current limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM performance_schema.replication_applier_status" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_performance_schema_replication_applier_status.xml" />
+ <test-case sql="SELECT * FROM performance_schema.events_waits_history limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM performance_schema.replication_applier_status_by_coordinator" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_performance_schema_replication_applier_status_by_coordinator.xml" />
+ <test-case sql="SELECT * FROM performance_schema.events_waits_history_long limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM performance_schema.replication_applier_status_by_worker" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_performance_schema_replication_applier_status_by_worker.xml" />
+ <test-case sql="SELECT * FROM performance_schema.events_waits_summary_by_instance limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM performance_schema.replication_connection_configuration" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_performance_schema_replication_connection_configuration.xml" />
+ <test-case sql="SELECT * FROM performance_schema.file_instances limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM performance_schema.replication_connection_status" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_performance_schema_replication_connection_status.xml" />
+ <test-case sql="SELECT * FROM performance_schema.file_summary_by_event_name limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM performance_schema.replication_group_member_stats" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_performance_schema_replication_group_member_stats.xml" />
+ <test-case sql="SELECT * FROM performance_schema.file_summary_by_instance limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM performance_schema.replication_group_members" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_performance_schema_replication_group_members.xml" />
+ <test-case sql="SELECT * FROM performance_schema.global_status limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM performance_schema.rwlock_instances" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_performance_schema_rwlock_instances.xml" />
+ <test-case sql="SELECT * FROM performance_schema.global_variables limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM performance_schema.session_account_connect_attrs" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_performance_schema_session_account_connect_attrs.xml" />
+ <test-case sql="SELECT * FROM performance_schema.host_cache limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM performance_schema.session_connect_attrs" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_performance_schema_session_connect_attrs.xml" />
+ <test-case sql="SELECT * FROM performance_schema.hosts limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM performance_schema.session_status" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_performance_schema_session_status.xml" />
+ <test-case sql="SELECT * FROM performance_schema.memory_summary_by_account_by_event_name limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM performance_schema.session_variables" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_performance_schema_session_variables.xml" />
+ <test-case sql="SELECT * FROM performance_schema.memory_summary_by_host_by_event_name limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM performance_schema.setup_actors" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_performance_schema_setup_actors.xml" />
+ <test-case sql="SELECT * FROM performance_schema.memory_summary_by_thread_by_event_name limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM performance_schema.setup_consumers" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_performance_schema_setup_consumers.xml" />
+ <test-case sql="SELECT * FROM performance_schema.memory_summary_by_user_by_event_name limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM performance_schema.setup_instruments" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_performance_schema_setup_instruments.xml" />
+ <test-case sql="SELECT * FROM performance_schema.memory_summary_global_by_event_name limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM performance_schema.setup_objects" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_performance_schema_setup_objects.xml" />
+ <test-case sql="SELECT * FROM performance_schema.metadata_locks limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM performance_schema.setup_timers" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_performance_schema_setup_timers.xml" />
+ <test-case sql="SELECT * FROM performance_schema.mutex_instances limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM performance_schema.socket_instances" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_performance_schema_socket_instances.xml" />
+ <test-case sql="SELECT * FROM performance_schema.objects_summary_global_by_type limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM performance_schema.socket_summary_by_event_name" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_performance_schema_socket_summary_by_event_name.xml" />
+ <test-case sql="SELECT * FROM performance_schema.performance_timers limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM performance_schema.socket_summary_by_instance" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_performance_schema_socket_summary_by_instance.xml" />
+ <test-case sql="SELECT * FROM performance_schema.replication_applier_configuration limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM performance_schema.status_by_account" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_performance_schema_status_by_account.xml" />
+ <test-case sql="SELECT * FROM performance_schema.replication_applier_status limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM performance_schema.status_by_host" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_performance_schema_status_by_host.xml" />
+ <test-case sql="SELECT * FROM performance_schema.replication_applier_status_by_coordinator limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM performance_schema.status_by_thread" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_performance_schema_status_by_thread.xml" />
+ <test-case sql="SELECT * FROM performance_schema.replication_applier_status_by_worker limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM performance_schema.status_by_user" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_performance_schema_status_by_user.xml" />
+ <test-case sql="SELECT * FROM performance_schema.replication_connection_configuration limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM performance_schema.table_handles" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_performance_schema_table_handles.xml" />
+ <test-case sql="SELECT * FROM performance_schema.replication_connection_status limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM performance_schema.table_io_waits_summary_by_index_usage" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_performance_schema_table_io_waits_summary_by_index_usage.xml" />
+ <test-case sql="SELECT * FROM performance_schema.replication_group_member_stats limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM performance_schema.table_io_waits_summary_by_table" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_performance_schema_table_io_waits_summary_by_table.xml" />
+ <test-case sql="SELECT * FROM performance_schema.replication_group_members limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM performance_schema.table_lock_waits_summary_by_table" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_performance_schema_table_lock_waits_summary_by_table.xml" />
+ <test-case sql="SELECT * FROM performance_schema.rwlock_instances limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM performance_schema.threads" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_performance_schema_threads.xml" />
+ <test-case sql="SELECT * FROM performance_schema.session_connect_attrs limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM performance_schema.user_variables_by_thread" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_performance_schema_user_variables_by_thread.xml" />
+ <test-case sql="SELECT * FROM performance_schema.session_status limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM performance_schema.users" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_performance_schema_users.xml" />
+ <test-case sql="SELECT * FROM performance_schema.setup_actors limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM performance_schema.variables_by_thread" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_performance_schema_variables_by_thread.xml" />
+ <test-case sql="SELECT * FROM performance_schema.setup_consumers limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM sys.host_summary" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_sys_host_summary.xml" />
+ <test-case sql="SELECT * FROM performance_schema.setup_instruments limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM sys.host_summary_by_file_io" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_sys_host_summary_by_file_io.xml" />
+ <test-case sql="SELECT * FROM performance_schema.setup_objects limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM sys.host_summary_by_file_io_type" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_sys_host_summary_by_file_io_type.xml" />
+ <test-case sql="SELECT * FROM performance_schema.setup_timers limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM sys.host_summary_by_stages" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_sys_host_summary_by_stages.xml" />
+ <test-case sql="SELECT * FROM performance_schema.socket_summary_by_event_name limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM sys.host_summary_by_statement_latency" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_sys_host_summary_by_statement_latency.xml" />
+ <test-case sql="SELECT * FROM performance_schema.socket_summary_by_instance limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM sys.host_summary_by_statement_type" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_sys_host_summary_by_statement_type.xml" />
+ <test-case sql="SELECT * FROM performance_schema.status_by_thread limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM sys.innodb_buffer_stats_by_schema" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_sys_innodb_buffer_stats_by_schema.xml" />
+
+ <test-case sql="SELECT * FROM performance_schema.table_handles limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM sys.innodb_buffer_stats_by_table" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_sys_innodb_buffer_stats_by_table.xml" />
+ <test-case sql="SELECT * FROM performance_schema.table_io_waits_summary_by_index_usage limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM sys.innodb_lock_waits" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_sys_innodb_lock_waits.xml" />
+ <test-case sql="SELECT * FROM performance_schema.table_io_waits_summary_by_table limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM sys.io_by_thread_by_latency" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_sys_io_by_thread_by_latency.xml" />
+ <test-case sql="SELECT * FROM performance_schema.table_lock_waits_summary_by_table limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM sys.io_global_by_file_by_bytes" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_sys_io_global_by_file_by_bytes.xml" />
+ <test-case sql="SELECT * FROM performance_schema.users limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM sys.io_global_by_file_by_latency" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_sys_io_global_by_file_by_latency.xml" />
+ <test-case sql="SELECT * FROM sys.host_summary_by_file_io_type limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM sys.io_global_by_wait_by_bytes" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_sys_io_global_by_wait_by_bytes.xml" />
+ <test-case sql="SELECT * FROM sys.host_summary_by_stages limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM sys.io_global_by_wait_by_latency" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_sys_io_global_by_wait_by_latency.xml" />
+ <test-case sql="SELECT * FROM sys.host_summary_by_statement_latency limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM sys.latest_file_io" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_sys_latest_file_io.xml" />
+ <test-case sql="SELECT * FROM sys.host_summary_by_statement_type limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM sys.memory_by_host_by_current_bytes" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_sys_memory_by_host_by_current_bytes.xml" />
+ <test-case sql="SELECT * FROM sys.innodb_lock_waits limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM sys.memory_by_thread_by_current_bytes" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_sys_memory_by_thread_by_current_bytes.xml" />
+ <test-case sql="SELECT * FROM sys.io_by_thread_by_latency limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM sys.memory_by_user_by_current_bytes" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_sys_memory_by_user_by_current_bytes.xml" />
+ <test-case sql="SELECT * FROM sys.io_global_by_file_by_bytes limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM sys.memory_global_by_current_bytes" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_sys_memory_global_by_current_bytes.xml" />
+ <test-case sql="SELECT * FROM sys.io_global_by_file_by_latency limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM sys.memory_global_total" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_sys_memory_global_total.xml" />
+ <test-case sql="SELECT * FROM sys.io_global_by_wait_by_bytes limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM sys.metrics" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_sys_metrics.xml" />
+ <test-case sql="SELECT * FROM sys.io_global_by_wait_by_latency limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM sys.processlist" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_sys_processlist.xml" />
+ <test-case sql="SELECT * FROM sys.latest_file_io limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM sys.ps_check_lost_instrumentation" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_sys_ps_check_lost_instrumentation.xml" />
+ <test-case sql="SELECT * FROM sys.memory_global_by_current_bytes limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM sys.schema_auto_increment_columns" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_sys_schema_auto_increment_columns.xml" />
+ <test-case sql="SELECT * FROM sys.memory_global_total limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM sys.schema_index_statistics" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_sys_schema_index_statistics.xml" />
+ <test-case sql="SELECT * FROM sys.metrics limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM sys.schema_object_overview" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_sys_schema_object_overview.xml" />
+ <test-case sql="SELECT * FROM sys.ps_check_lost_instrumentation limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM sys.schema_redundant_indexes" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_sys_schema_redundant_indexes.xml" />
+ <test-case sql="SELECT * FROM sys.schema_auto_increment_columns limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM sys.schema_table_lock_waits" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_sys_schema_table_lock_waits.xml" />
+ <test-case sql="SELECT * FROM sys.schema_index_statistics limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM sys.schema_table_statistics" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_sys_schema_table_statistics.xml" />
+ <test-case sql="SELECT * FROM sys.schema_object_overview limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM sys.schema_table_statistics_with_buffer" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_sys_schema_table_statistics_with_buffer.xml" />
+ <test-case sql="SELECT * FROM sys.schema_redundant_indexes limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM sys.schema_tables_with_full_table_scans" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_sys_schema_tables_with_full_table_scans.xml" />
+ <test-case sql="SELECT * FROM sys.schema_table_lock_waits limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM sys.schema_unused_indexes" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_sys_schema_unused_indexes.xml" />
+ <test-case sql="SELECT * FROM sys.schema_table_statistics limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM sys.session" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_sys_session.xml" />
+ <test-case sql="SELECT * FROM sys.schema_table_statistics_with_buffer limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM sys.session_ssl_status" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_sys_session_ssl_status.xml" />
+ <test-case sql="SELECT * FROM sys.schema_tables_with_full_table_scans limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM sys.statement_analysis" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_sys_statement_analysis.xml" />
+ <test-case sql="SELECT * FROM sys.schema_unused_indexes limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM sys.statements_with_errors_or_warnings" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_sys_statements_with_errors_or_warnings.xml" />
+
+ <test-case sql="SELECT * FROM sys.session_ssl_status limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM sys.statements_with_full_table_scans" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_sys_statements_with_full_table_scans.xml" />
+ <test-case sql="SELECT * FROM sys.statement_analysis limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM sys.statements_with_runtimes_in_95th_percentile" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_sys_statements_with_runtimes_in_95th_percentile.xml" />
+ <test-case sql="SELECT * FROM sys.statements_with_errors_or_warnings limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM sys.statements_with_sorting" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_sys_statements_with_sorting.xml" />
+ <test-case sql="SELECT * FROM sys.statements_with_full_table_scans limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM sys.statements_with_temp_tables" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_sys_statements_with_temp_tables.xml" />
+ <test-case sql="SELECT * FROM sys.statements_with_runtimes_in_95th_percentile limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM sys.sys_config" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_sys_sys_config.xml" />
+ <test-case sql="SELECT * FROM sys.statements_with_sorting limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM sys.user_summary" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_sys_user_summary.xml" />
+ <test-case sql="SELECT * FROM sys.statements_with_temp_tables limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM sys.user_summary_by_file_io" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_sys_user_summary_by_file_io.xml" />
+ <test-case sql="SELECT * FROM sys.sys_config limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM sys.user_summary_by_file_io_type" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_sys_user_summary_by_file_io_type.xml" />
+ <test-case sql="SELECT * FROM sys.user_summary_by_file_io limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM sys.user_summary_by_stages" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_sys_user_summary_by_stages.xml" />
+ <test-case sql="SELECT * FROM sys.user_summary_by_file_io_type limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM sys.user_summary_by_statement_latency" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_sys_user_summary_by_statement_latency.xml" />
+ <test-case sql="SELECT * FROM sys.user_summary_by_stages limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM sys.user_summary_by_statement_type" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_sys_user_summary_by_statement_type.xml" />
+ <test-case sql="SELECT * FROM sys.user_summary_by_statement_type limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM sys.version" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_sys_version.xml" />
+ <test-case sql="SELECT * FROM sys.version limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM sys.wait_classes_global_by_avg_latency" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_sys_wait_classes_global_by_avg_latency.xml" />
+ <test-case sql="SELECT * FROM sys.wait_classes_global_by_avg_latency limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM sys.wait_classes_global_by_latency" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_sys_wait_classes_global_by_latency.xml" />
+ <test-case sql="SELECT * FROM sys.wait_classes_global_by_latency limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM sys.waits_by_host_by_latency" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_sys_waits_by_host_by_latency.xml" />
+ <test-case sql="SELECT * FROM sys.waits_by_host_by_latency limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM sys.waits_by_user_by_latency" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_sys_waits_by_user_by_latency.xml" />
+ <test-case sql="SELECT * FROM sys.waits_by_user_by_latency limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM sys.waits_global_by_latency" db-types="MySQL" scenario-types="db">
- <assertion expected-data-file="select_mysql_sys_waits_global_by_latency.xml" />
+ <test-case sql="SELECT * FROM sys.waits_global_by_latency limit 1" db-types="MySQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
</integration-test-cases>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dql-integration-select-system-schema-opengauss.xml b/test/e2e/sql/src/test/resources/cases/dql/dql-integration-select-system-schema-opengauss.xml
index 36c33c7771b..04908a6ac62 100644
--- a/test/e2e/sql/src/test/resources/cases/dql/dql-integration-select-system-schema-opengauss.xml
+++ b/test/e2e/sql/src/test/resources/cases/dql/dql-integration-select-system-schema-opengauss.xml
@@ -17,1227 +17,807 @@
-->
<integration-test-cases>
- <test-case sql="SELECT * FROM information_schema._pg_foreign_data_wrappers" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_information_schema__pg_foreign_data_wrappers.xml" />
+ <test-case sql="SELECT * FROM information_schema._pg_foreign_table_columns limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM information_schema._pg_foreign_servers" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_information_schema__pg_foreign_servers.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM information_schema._pg_foreign_table_columns" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_information_schema__pg_foreign_table_columns.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM information_schema._pg_foreign_tables" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_information_schema__pg_foreign_tables.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM information_schema._pg_user_mappings" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_information_schema__pg_user_mappings.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM information_schema.administrable_role_authorizations" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_information_schema_administrable_role_authorizations.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM information_schema.applicable_roles" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_information_schema_applicable_roles.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM information_schema.attributes" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_information_schema_attributes.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM information_schema.character_sets" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_information_schema_character_sets.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM information_schema.check_constraint_routine_usage" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_information_schema_check_constraint_routine_usage.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM information_schema.check_constraints" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_information_schema_check_constraints.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM information_schema.collation_character_set_applicability" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_information_schema_collation_character_set_applicability.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM information_schema.collations" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_information_schema_collations.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM information_schema.column_domain_usage" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_information_schema_column_domain_usage.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM information_schema.column_options" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_information_schema_column_options.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM information_schema.column_privileges" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_information_schema_column_privileges.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM information_schema.column_udt_usage" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_information_schema_column_udt_usage.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM information_schema.columns" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_information_schema_columns.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM information_schema.constraint_column_usage" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_information_schema_constraint_column_usage.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM information_schema.constraint_table_usage" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_information_schema_constraint_table_usage.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM information_schema.data_type_privileges" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_information_schema_data_type_privileges.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM information_schema.domain_constraints" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_information_schema_domain_constraints.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM information_schema.domain_udt_usage" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_information_schema_domain_udt_usage.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM information_schema.domains" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_information_schema_domains.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM information_schema.element_types" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_information_schema_element_types.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM information_schema.enabled_roles" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_information_schema_enabled_roles.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM information_schema.foreign_data_wrapper_options" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_information_schema_foreign_data_wrapper_options.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM information_schema.foreign_data_wrappers" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_information_schema_foreign_data_wrappers.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM information_schema.foreign_server_options" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_information_schema_foreign_server_options.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM information_schema.foreign_servers" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_information_schema_foreign_servers.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM information_schema.foreign_table_options" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_information_schema_foreign_table_options.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM information_schema.foreign_tables" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_information_schema_foreign_tables.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM information_schema.information_schema_catalog_name" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_information_schema_information_schema_catalog_name.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM information_schema.key_column_usage" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_information_schema_key_column_usage.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM information_schema.parameters" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_information_schema_parameters.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM information_schema.referential_constraints" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_information_schema_referential_constraints.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM information_schema.role_column_grants" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_information_schema_role_column_grants.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM information_schema.role_routine_grants" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_information_schema_role_routine_grants.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM information_schema.role_table_grants" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_information_schema_role_table_grants.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM information_schema.role_udt_grants" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_information_schema_role_udt_grants.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM information_schema.role_usage_grants" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_information_schema_role_usage_grants.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM information_schema.routine_privileges" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_information_schema_routine_privileges.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM information_schema.routines" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_information_schema_routines.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM information_schema.schemata" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_information_schema_schemata.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM information_schema.sequences" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_information_schema_sequences.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM information_schema.sql_features" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_information_schema_sql_features.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM information_schema.sql_implementation_info" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_information_schema_sql_implementation_info.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM information_schema.sql_languages" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_information_schema_sql_languages.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM information_schema.sql_packages" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_information_schema_sql_packages.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM information_schema.sql_parts" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_information_schema_sql_parts.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM information_schema.sql_sizing" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_information_schema_sql_sizing.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM information_schema.sql_sizing_profiles" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_information_schema_sql_sizing_profiles.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM information_schema.table_constraints" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_information_schema_table_constraints.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM information_schema.table_privileges" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_information_schema_table_privileges.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM information_schema.tables" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_information_schema_tables.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM information_schema.triggered_update_columns" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_information_schema_triggered_update_columns.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM information_schema.triggers" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_information_schema_triggers.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM information_schema.udt_privileges" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_information_schema_udt_privileges.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM information_schema.usage_privileges" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_information_schema_usage_privileges.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM information_schema.user_defined_types" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_information_schema_user_defined_types.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM information_schema.user_mapping_options" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_information_schema_user_mapping_options.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM information_schema.user_mappings" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_information_schema_user_mappings.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM information_schema.view_column_usage" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_information_schema_view_column_usage.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM information_schema.view_routine_usage" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_information_schema_view_routine_usage.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM information_schema.view_table_usage" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_information_schema_view_table_usage.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM information_schema.views" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_information_schema_views.xml" />
- </test-case>
- <test-case sql="SELECT * FROM pg_catalog.get_global_prepared_xacts" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_get_global_prepared_xacts.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.gs_all_control_group_info" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_gs_all_control_group_info.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.gs_asp" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_gs_asp.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.gs_auditing" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_gs_auditing.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.gs_auditing_access" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_gs_auditing_access.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.gs_auditing_policy" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_gs_auditing_policy.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.gs_auditing_policy_access" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_gs_auditing_policy_access.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.gs_auditing_policy_filters" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_gs_auditing_policy_filters.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.gs_auditing_policy_privileges" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_gs_auditing_policy_privileges.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.gs_auditing_privilege" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_gs_auditing_privilege.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.gs_client_global_keys" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_gs_client_global_keys.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.gs_client_global_keys_args" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_gs_client_global_keys_args.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.gs_cluster_resource_info" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_gs_cluster_resource_info.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.gs_column_keys" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_gs_column_keys.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.gs_column_keys_args" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_gs_column_keys_args.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.gs_comm_proxy_thread_status" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_gs_comm_proxy_thread_status.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.gs_db_privilege" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_gs_db_privilege.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.gs_db_privileges" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_gs_db_privileges.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.gs_encrypted_columns" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_gs_encrypted_columns.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.gs_encrypted_proc" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_gs_encrypted_proc.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.gs_file_stat" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_gs_file_stat.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.gs_get_control_group_info" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_gs_get_control_group_info.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.gs_global_chain" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_gs_global_chain.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.gs_global_config" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_gs_global_config.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.gs_gsc_memory_detail" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_gs_gsc_memory_detail.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.gs_instance_time" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_gs_instance_time.xml" />
+
+ <test-case sql="SELECT * FROM information_schema._pg_foreign_tables limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.gs_job_argument" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_gs_job_argument.xml" />
+
+ <test-case sql="SELECT * FROM information_schema._pg_user_mappings limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.gs_job_attribute" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_gs_job_attribute.xml" />
+
+ <test-case sql="SELECT * FROM information_schema.administrable_role_authorizations limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.gs_labels" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_gs_labels.xml" />
+
+ <test-case sql="SELECT * FROM information_schema.applicable_roles limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.gs_lsc_memory_detail" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_gs_lsc_memory_detail.xml" />
+
+ <test-case sql="SELECT * FROM information_schema.check_constraint_routine_usage limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.gs_masking" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_gs_masking.xml" />
+
+ <test-case sql="SELECT * FROM information_schema.column_options limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.gs_masking_policy" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_gs_masking_policy.xml" />
+
+ <test-case sql="SELECT * FROM information_schema.enabled_roles limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.gs_masking_policy_actions" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_gs_masking_policy_actions.xml" />
+
+ <test-case sql="SELECT * FROM information_schema.foreign_data_wrapper_options limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.gs_masking_policy_filters" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_gs_masking_policy_filters.xml" />
+
+ <test-case sql="SELECT * FROM information_schema.foreign_server_options limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.gs_matview" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_gs_matview.xml" />
+
+ <test-case sql="SELECT * FROM information_schema.foreign_table_options limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.gs_matview_dependency" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_gs_matview_dependency.xml" />
+
+ <test-case sql="SELECT * FROM information_schema.foreign_tables limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.gs_matviews" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_gs_matviews.xml" />
+
+ <test-case sql="SELECT * FROM information_schema.referential_constraints limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.gs_model_warehouse" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_gs_model_warehouse.xml" />
+
+ <test-case sql="SELECT * FROM information_schema.sequences limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.gs_obsscaninfo" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_gs_obsscaninfo.xml" />
+
+ <test-case sql="SELECT * FROM information_schema.sql_features limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.gs_opt_model" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_gs_opt_model.xml" />
+
+ <test-case sql="SELECT * FROM information_schema.sql_implementation_info limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.gs_os_run_info" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_gs_os_run_info.xml" />
+
+ <test-case sql="SELECT * FROM information_schema.sql_languages limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.gs_package" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_gs_package.xml" />
+
+ <test-case sql="SELECT * FROM information_schema.sql_packages limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.gs_policy_label" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_gs_policy_label.xml" />
+
+ <test-case sql="SELECT * FROM information_schema.sql_parts limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.gs_recyclebin" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_gs_recyclebin.xml" />
+
+ <test-case sql="SELECT * FROM information_schema.sql_sizing limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.gs_redo_stat" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_gs_redo_stat.xml" />
+
+ <test-case sql="SELECT * FROM information_schema.sql_sizing_profiles limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.gs_session_cpu_statistics" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_gs_session_cpu_statistics.xml" />
+
+ <test-case sql="SELECT * FROM information_schema.triggers limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.gs_session_memory" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_gs_session_memory.xml" />
+
+ <test-case sql="SELECT * FROM information_schema.user_mapping_options limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.gs_session_memory_context" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_gs_session_memory_context.xml" />
+
+ <test-case sql="SELECT * FROM information_schema.user_mappings limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.gs_session_memory_detail" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_gs_session_memory_detail.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.gs_asp limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.gs_session_memory_statistics" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_gs_session_memory_statistics.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.gs_auditing limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.gs_session_stat" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_gs_session_stat.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.gs_auditing_access limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.gs_session_time" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_gs_session_time.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.gs_auditing_policy limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.gs_shared_memory_detail" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_gs_shared_memory_detail.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.gs_auditing_policy_access limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.gs_sql_count" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_gs_sql_count.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.gs_auditing_policy_filters limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.gs_stat_session_cu" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_gs_stat_session_cu.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.gs_auditing_policy_privileges limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.gs_thread_memory_context" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_gs_thread_memory_context.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.gs_auditing_privilege limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.gs_total_memory_detail" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_gs_total_memory_detail.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.gs_client_global_keys limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.gs_total_nodegroup_memory_detail" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_gs_total_nodegroup_memory_detail.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.gs_client_global_keys_args limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.gs_txn_snapshot" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_gs_txn_snapshot.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.gs_column_keys limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.gs_uid" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_gs_uid.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.gs_column_keys_args limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.gs_wlm_cgroup_info" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_gs_wlm_cgroup_info.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.gs_db_privilege limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.gs_wlm_ec_operator_history" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_gs_wlm_ec_operator_history.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.gs_db_privileges limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.gs_wlm_ec_operator_info" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_gs_wlm_ec_operator_info.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.gs_encrypted_columns limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.gs_wlm_ec_operator_statistics" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_gs_wlm_ec_operator_statistics.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.gs_encrypted_proc limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.gs_wlm_instance_history" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_gs_wlm_instance_history.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.gs_file_stat limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.gs_wlm_operator_history" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_gs_wlm_operator_history.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.gs_get_control_group_info limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.gs_wlm_operator_info" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_gs_wlm_operator_info.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.gs_global_chain limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.gs_wlm_operator_statistics" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_gs_wlm_operator_statistics.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.gs_global_config limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.gs_wlm_plan_encoding_table" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_gs_wlm_plan_encoding_table.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.gs_gsc_memory_detail limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.gs_wlm_plan_operator_history" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_gs_wlm_plan_operator_history.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.gs_job_argument limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.gs_wlm_plan_operator_info" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_gs_wlm_plan_operator_info.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.gs_job_attribute limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.gs_wlm_rebuild_user_resource_pool" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_gs_wlm_rebuild_user_resource_pool.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.gs_labels limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.gs_wlm_resource_pool" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_gs_wlm_resource_pool.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.gs_lsc_memory_detail limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.gs_wlm_session_history" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_gs_wlm_session_history.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.gs_masking limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.gs_wlm_session_info" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_gs_wlm_session_info.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.gs_masking_policy limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.gs_wlm_session_info_all" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_gs_wlm_session_info_all.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.gs_masking_policy_actions limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.gs_wlm_session_query_info_all" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_gs_wlm_session_query_info_all.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.gs_masking_policy_filters limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.gs_wlm_session_statistics" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_gs_wlm_session_statistics.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.gs_matview limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.gs_wlm_user_info" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_gs_wlm_user_info.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.gs_matview_dependency limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.gs_wlm_user_resource_history" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_gs_wlm_user_resource_history.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.gs_matviews limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.gs_wlm_workload_records" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_gs_wlm_workload_records.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.gs_model_warehouse limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.mpp_tables" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_mpp_tables.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.gs_obsscaninfo limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_aggregate" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_pg_aggregate.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.gs_opt_model limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_am" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_pg_am.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.gs_package limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_amop" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_pg_amop.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.gs_policy_label limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_amproc" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_pg_amproc.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.gs_recyclebin limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_app_workloadgroup_mapping" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_pg_app_workloadgroup_mapping.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.gs_redo_stat limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_attrdef" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_pg_attrdef.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.gs_session_cpu_statistics limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_attribute" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_pg_attribute.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.gs_session_memory limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_auth_history" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_pg_auth_history.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.gs_session_memory_context limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_auth_members" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_pg_auth_members.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.gs_session_memory_detail limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_authid" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_pg_authid.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.gs_session_memory_statistics limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_available_extension_versions" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_pg_available_extension_versions.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.gs_session_stat limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_available_extensions" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_pg_available_extensions.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.gs_session_time limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_cast" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_pg_cast.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.gs_sql_count limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_class" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_pg_class.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.gs_stat_session_cu limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_collation" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_pg_collation.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.gs_thread_memory_context limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_comm_delay" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_pg_comm_delay.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.gs_total_memory_detail limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_comm_recv_stream" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_pg_comm_recv_stream.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.gs_total_nodegroup_memory_detail limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_comm_send_stream" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_pg_comm_send_stream.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.gs_txn_snapshot limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_comm_status" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_pg_comm_status.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.gs_uid limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_constraint" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_pg_constraint.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.gs_wlm_cgroup_info limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_control_group_config" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_pg_control_group_config.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.gs_wlm_ec_operator_history limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_conversion" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_pg_conversion.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.gs_wlm_ec_operator_info limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_cursors" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_pg_cursors.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.gs_wlm_ec_operator_statistics limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_database" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_pg_database.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.gs_wlm_instance_history limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_db_role_setting" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_pg_db_role_setting.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.gs_wlm_operator_history limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_default_acl" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_pg_default_acl.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.gs_wlm_operator_info limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_depend" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_pg_depend.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.gs_wlm_operator_statistics limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_description" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_pg_description.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.gs_wlm_plan_encoding_table limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_directory" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_pg_directory.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.gs_wlm_plan_operator_history limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_enum" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_pg_enum.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.gs_wlm_plan_operator_info limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_ext_stats" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_pg_ext_stats.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.gs_wlm_resource_pool limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_extension" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_pg_extension.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.gs_wlm_session_history limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_extension_data_source" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_pg_extension_data_source.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.gs_wlm_session_info limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_foreign_data_wrapper" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_pg_foreign_data_wrapper.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.gs_wlm_session_info_all limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_foreign_server" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_pg_foreign_server.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.gs_wlm_session_query_info_all limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_foreign_table" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_pg_foreign_table.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.gs_wlm_session_statistics limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_get_invalid_backends" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_pg_get_invalid_backends.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.gs_wlm_user_resource_history limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_get_senders_catchup_time" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_pg_get_senders_catchup_time.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.mpp_tables limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_group" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_pg_group.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.pg_aggregate limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_gtt_attached_pids" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_pg_gtt_attached_pids.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.pg_amop limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_gtt_relstats" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_pg_gtt_relstats.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.pg_amproc limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_gtt_stats" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_pg_gtt_stats.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.pg_app_workloadgroup_mapping limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_hashbucket" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_pg_hashbucket.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.pg_attrdef limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_index" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_pg_index.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.pg_auth_members limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_indexes" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_pg_indexes.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.pg_available_extensions limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_inherits" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_pg_inherits.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.pg_cast limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_job" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_pg_job.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.pg_collation limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_job_proc" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_pg_job_proc.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.pg_comm_delay limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_language" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_pg_language.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.pg_comm_recv_stream limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_largeobject" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_pg_largeobject.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.pg_comm_send_stream limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_largeobject_metadata" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_pg_largeobject_metadata.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.pg_comm_status limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_locks" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_pg_locks.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.pg_control_group_config limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_namespace" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_pg_namespace.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.pg_db_role_setting limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_node_env" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_pg_node_env.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.pg_default_acl limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_object" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_pg_object.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.pg_depend limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_obsscaninfo" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_pg_obsscaninfo.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.pg_description limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_opclass" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_pg_opclass.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.pg_directory limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_operator" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_pg_operator.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.pg_enum limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_opfamily" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_pg_opfamily.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.pg_ext_stats limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_os_threads" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_pg_os_threads.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.pg_extension_data_source limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_partition" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_pg_partition.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.pg_foreign_data_wrapper limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_pltemplate" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_pg_pltemplate.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.pg_foreign_server limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_prepared_statements" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_pg_prepared_statements.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.pg_foreign_table limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_prepared_xacts" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_pg_prepared_xacts.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.pg_get_invalid_backends limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_proc" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_pg_proc.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.pg_get_senders_catchup_time limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_publication" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_pg_publication.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.pg_group limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_publication_rel" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_pg_publication_rel.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.pg_gtt_attached_pids limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_publication_tables" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_pg_publication_tables.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.pg_gtt_relstats limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_range" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_pg_range.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.pg_gtt_stats limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_replication_origin" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_pg_replication_origin.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.pg_hashbucket limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_replication_origin_status" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_pg_replication_origin_status.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.pg_indexes limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_replication_slots" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_pg_replication_slots.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.pg_inherits limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_resource_pool" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_pg_resource_pool.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.pg_job limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_rewrite" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_pg_rewrite.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.pg_job_proc limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_rlspolicies" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_pg_rlspolicies.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.pg_largeobject limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_rlspolicy" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_pg_rlspolicy.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.pg_largeobject_metadata limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_roles" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_pg_roles.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.pg_node_env limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_rules" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_pg_rules.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.pg_obsscaninfo limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_running_xacts" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_pg_running_xacts.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.pg_opfamily limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_seclabel" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_pg_seclabel.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.pg_partition limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_seclabels" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_pg_seclabels.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.pg_prepared_xacts limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_session_iostat" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_pg_session_iostat.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.pg_publication limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_session_wlmstat" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_pg_session_wlmstat.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.pg_publication_rel limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_settings" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_pg_settings.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.pg_publication_tables limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_shadow" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_pg_shadow.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.pg_range limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_shdepend" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_pg_shdepend.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.pg_replication_origin limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_shdescription" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_pg_shdescription.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.pg_replication_origin_status limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_shseclabel" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_pg_shseclabel.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.pg_replication_slots limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_stat_activity" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_pg_stat_activity.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.pg_rlspolicies limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_stat_activity_ng" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_pg_stat_activity_ng.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.pg_rlspolicy limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_stat_all_indexes" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_pg_stat_all_indexes.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.pg_rules limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_stat_all_tables" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_pg_stat_all_tables.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.pg_seclabel limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_stat_bad_block" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_pg_stat_bad_block.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.pg_seclabels limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_stat_bgwriter" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_pg_stat_bgwriter.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.pg_session_iostat limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_stat_database" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_pg_stat_database.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.pg_settings limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_stat_database_conflicts" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_pg_stat_database_conflicts.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.pg_shdepend limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_stat_replication" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_pg_stat_replication.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.pg_shdescription limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_stat_subscription" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_pg_stat_subscription.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.pg_shseclabel limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_stat_sys_indexes" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_pg_stat_sys_indexes.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.pg_stat_all_tables limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_stat_sys_tables" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_pg_stat_sys_tables.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.pg_stat_bad_block limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_stat_user_functions" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_pg_stat_user_functions.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.pg_stat_database_conflicts limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_stat_user_indexes" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_pg_stat_user_indexes.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.pg_stat_replication limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_stat_user_tables" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_pg_stat_user_tables.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.pg_stat_subscription limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_stat_xact_all_tables" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_pg_stat_xact_all_tables.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.pg_stat_sys_tables limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_stat_xact_sys_tables" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_pg_stat_xact_sys_tables.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.pg_stat_user_functions limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_stat_xact_user_functions" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_pg_stat_xact_user_functions.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.pg_stat_user_tables limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_stat_xact_user_tables" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_pg_stat_xact_user_tables.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.pg_stat_xact_all_tables limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_statio_all_indexes" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_pg_statio_all_indexes.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.pg_stat_xact_sys_tables limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_statio_all_sequences" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_pg_statio_all_sequences.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.pg_stat_xact_user_functions limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_statio_all_tables" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_pg_statio_all_tables.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.pg_stat_xact_user_tables limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_statio_sys_indexes" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_pg_statio_sys_indexes.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.pg_statio_all_sequences limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_statio_sys_sequences" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_pg_statio_sys_sequences.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.pg_statio_all_tables limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_statio_sys_tables" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_pg_statio_sys_tables.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.pg_statio_sys_sequences limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_statio_user_indexes" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_pg_statio_user_indexes.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.pg_statio_user_sequences limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_statio_user_sequences" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_pg_statio_user_sequences.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.pg_statistic_ext limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_statio_user_tables" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_pg_statio_user_tables.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.pg_subscription limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_statistic" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_pg_statistic.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.pg_synonym limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_statistic_ext" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_pg_statistic_ext.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.pg_thread_wait_status limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_stats" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_pg_stats.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.pg_total_memory_detail limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_subscription" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_pg_subscription.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.pg_trigger limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_synonym" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_pg_synonym.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.pg_ts_config limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <!-- TODO ERROR: Index 10 out of bounds for length 10 -->
- <!-- <test-case sql="SELECT * FROM pg_catalog.pg_tables" db-types="openGauss" scenario-types="db">-->
- <!-- <assertion expected-data-file="select_opengauss_pg_catalog_pg_tables.xml" />-->
- <!-- </test-case>-->
- <test-case sql="SELECT * FROM pg_catalog.pg_tablespace" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_pg_tablespace.xml" />
+ <test-case sql="SELECT * FROM pg_catalog.pg_ts_config_map limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_tde_info" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_pg_tde_info.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.pg_ts_dict limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_thread_wait_status" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_pg_thread_wait_status.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.pg_ts_parser limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_timezone_abbrevs" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_pg_timezone_abbrevs.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.pg_ts_template limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_timezone_names" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_pg_timezone_names.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.pg_user_mapping limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_total_memory_detail" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_pg_total_memory_detail.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.pg_user_mappings limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_total_user_resource_info" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_pg_total_user_resource_info.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.pg_variable_info limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_total_user_resource_info_oid" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_pg_total_user_resource_info_oid.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.pg_views limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_trigger" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_pg_trigger.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.pg_wlm_statistics limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_ts_config" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_pg_ts_config.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.pg_workload_group limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_ts_config_map" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_pg_ts_config_map.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_ts_dict" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_pg_ts_dict.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_ts_parser" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_pg_ts_parser.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_ts_template" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_pg_ts_template.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_type" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_pg_type.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_user" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_pg_user.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_user_mapping" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_pg_user_mapping.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_user_mappings" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_pg_user_mappings.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_user_status" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_pg_user_status.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_variable_info" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_pg_variable_info.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_views" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_pg_views.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_wlm_statistics" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_pg_wlm_statistics.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_workload_group" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_pg_workload_group.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pgxc_class" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_pgxc_class.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pgxc_group" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_pgxc_group.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.pgxc_class limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pgxc_node" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_pgxc_node.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.pgxc_group limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pgxc_prepared_xacts" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_pgxc_prepared_xacts.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.pgxc_node limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pgxc_slice" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_pgxc_slice.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.pgxc_prepared_xacts limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pgxc_thread_wait_status" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_pgxc_thread_wait_status.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.pgxc_slice limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.plan_table" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_plan_table.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.plan_table limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.plan_table_data" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_plan_table_data.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.plan_table_data limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.statement_history" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_statement_history.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.statement_history limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.streaming_cont_query" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_streaming_cont_query.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.streaming_cont_query limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.streaming_reaper_status" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_streaming_reaper_status.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.streaming_reaper_status limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.streaming_stream" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_streaming_stream.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.streaming_stream limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.sys_dummy" db-types="openGauss" scenario-types="db">
- <assertion expected-data-file="select_opengauss_pg_catalog_sys_dummy.xml" />
+
+ <test-case sql="SELECT * FROM pg_catalog.sys_dummy limit 1" db-types="openGauss" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
</integration-test-cases>
diff --git a/test/e2e/sql/src/test/resources/cases/dql/dql-integration-select-system-schema-postgresql.xml b/test/e2e/sql/src/test/resources/cases/dql/dql-integration-select-system-schema-postgresql.xml
index ca0c477cd24..6ad5cee3aa2 100644
--- a/test/e2e/sql/src/test/resources/cases/dql/dql-integration-select-system-schema-postgresql.xml
+++ b/test/e2e/sql/src/test/resources/cases/dql/dql-integration-select-system-schema-postgresql.xml
@@ -17,811 +17,407 @@
-->
<integration-test-cases>
- <test-case sql="SELECT * FROM information_schema._pg_foreign_data_wrappers" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_information_schema__pg_foreign_data_wrappers.xml" />
+ <test-case sql="SELECT * FROM information_schema._pg_foreign_data_wrappers limit 1" db-types="PostgreSQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM information_schema._pg_foreign_servers" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_information_schema__pg_foreign_servers.xml" />
+ <test-case sql="SELECT * FROM information_schema._pg_foreign_servers limit 1" db-types="PostgreSQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM information_schema._pg_foreign_table_columns" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_information_schema__pg_foreign_table_columns.xml" />
+ <test-case sql="SELECT * FROM information_schema._pg_foreign_table_columns limit 1" db-types="PostgreSQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM information_schema._pg_foreign_tables" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_information_schema__pg_foreign_tables.xml" />
+ <test-case sql="SELECT * FROM information_schema._pg_foreign_tables limit 1" db-types="PostgreSQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM information_schema._pg_user_mappings" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_information_schema__pg_user_mappings.xml" />
+ <test-case sql="SELECT * FROM information_schema._pg_user_mappings limit 1" db-types="PostgreSQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM information_schema.administrable_role_authorizations" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_information_schema_administrable_role_authorizations.xml" />
+ <test-case sql="SELECT * FROM information_schema.administrable_role_authorizations limit 1" db-types="PostgreSQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM information_schema.applicable_roles" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_information_schema_applicable_roles.xml" />
+ <test-case sql="SELECT * FROM information_schema.applicable_roles limit 1" db-types="PostgreSQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM information_schema.attributes" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_information_schema_attributes.xml" />
+ <test-case sql="SELECT * FROM information_schema.attributes limit 1" db-types="PostgreSQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM information_schema.character_sets" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_information_schema_character_sets.xml" />
+ <test-case sql="SELECT * FROM information_schema.check_constraint_routine_usage limit 1" db-types="PostgreSQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM information_schema.check_constraint_routine_usage" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_information_schema_check_constraint_routine_usage.xml" />
+ <test-case sql="SELECT * FROM information_schema.column_column_usage limit 1" db-types="PostgreSQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM information_schema.check_constraints" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_information_schema_check_constraints.xml" />
+ <test-case sql="SELECT * FROM information_schema.column_options limit 1" db-types="PostgreSQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM information_schema.collation_character_set_applicability" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_information_schema_collation_character_set_applicability.xml" />
+ <test-case sql="SELECT * FROM information_schema.enabled_roles limit 1" db-types="PostgreSQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM information_schema.collations" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_information_schema_collations.xml" />
+ <test-case sql="SELECT * FROM information_schema.foreign_data_wrapper_options limit 1" db-types="PostgreSQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM information_schema.column_column_usage" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_information_schema_column_column_usage.xml" />
+ <test-case sql="SELECT * FROM information_schema.foreign_data_wrappers limit 1" db-types="PostgreSQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM information_schema.column_domain_usage" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_information_schema_column_domain_usage.xml" />
+ <test-case sql="SELECT * FROM information_schema.foreign_server_options limit 1" db-types="PostgreSQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM information_schema.column_options" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_information_schema_column_options.xml" />
+ <test-case sql="SELECT * FROM information_schema.foreign_servers limit 1" db-types="PostgreSQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM information_schema.column_privileges" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_information_schema_column_privileges.xml" />
+ <test-case sql="SELECT * FROM information_schema.foreign_table_options limit 1" db-types="PostgreSQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM information_schema.column_udt_usage" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_information_schema_column_udt_usage.xml" />
+ <test-case sql="SELECT * FROM information_schema.foreign_tables limit 1" db-types="PostgreSQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM information_schema.columns" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_information_schema_columns.xml" />
+ <test-case sql="SELECT * FROM information_schema.referential_constraints limit 1" db-types="PostgreSQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM information_schema.constraint_column_usage" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_information_schema_constraint_column_usage.xml" />
+ <test-case sql="SELECT * FROM information_schema.sequences limit 1" db-types="PostgreSQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM information_schema.constraint_table_usage" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_information_schema_constraint_table_usage.xml" />
+ <test-case sql="SELECT * FROM information_schema.sql_features limit 1" db-types="PostgreSQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM information_schema.data_type_privileges" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_information_schema_data_type_privileges.xml" />
+ <test-case sql="SELECT * FROM information_schema.sql_implementation_info limit 1" db-types="PostgreSQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM information_schema.domain_constraints" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_information_schema_domain_constraints.xml" />
+ <test-case sql="SELECT * FROM information_schema.sql_parts limit 1" db-types="PostgreSQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM information_schema.domain_udt_usage" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_information_schema_domain_udt_usage.xml" />
+ <test-case sql="SELECT * FROM information_schema.sql_sizing limit 1" db-types="PostgreSQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM information_schema.domains" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_information_schema_domains.xml" />
+ <test-case sql="SELECT * FROM information_schema.transforms limit 1" db-types="PostgreSQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM information_schema.element_types" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_information_schema_element_types.xml" />
+ <test-case sql="SELECT * FROM information_schema.triggered_update_columns limit 1" db-types="PostgreSQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM information_schema.enabled_roles" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_information_schema_enabled_roles.xml" />
+ <test-case sql="SELECT * FROM information_schema.triggers limit 1" db-types="PostgreSQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM information_schema.foreign_data_wrapper_options" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_information_schema_foreign_data_wrapper_options.xml" />
+ <test-case sql="SELECT * FROM information_schema.user_defined_types limit 1" db-types="PostgreSQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM information_schema.foreign_data_wrappers" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_information_schema_foreign_data_wrappers.xml" />
+ <test-case sql="SELECT * FROM information_schema.user_mapping_options limit 1" db-types="PostgreSQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM information_schema.foreign_server_options" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_information_schema_foreign_server_options.xml" />
+ <test-case sql="SELECT * FROM information_schema.user_mappings limit 1" db-types="PostgreSQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM information_schema.foreign_servers" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_information_schema_foreign_servers.xml" />
+ <test-case sql="SELECT * FROM pg_catalog.pg_am limit 1" db-types="PostgreSQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM information_schema.foreign_table_options" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_information_schema_foreign_table_options.xml" />
+ <test-case sql="SELECT * FROM pg_catalog.pg_amop limit 1" db-types="PostgreSQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM information_schema.foreign_tables" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_information_schema_foreign_tables.xml" />
+ <test-case sql="SELECT * FROM pg_catalog.pg_amproc limit 1" db-types="PostgreSQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM information_schema.information_schema_catalog_name" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_information_schema_information_schema_catalog_name.xml" />
+ <test-case sql="SELECT * FROM pg_catalog.pg_attrdef limit 1" db-types="PostgreSQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM information_schema.key_column_usage" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_information_schema_key_column_usage.xml" />
+ <test-case sql="SELECT * FROM pg_catalog.pg_available_extensions limit 1" db-types="PostgreSQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM information_schema.parameters" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_information_schema_parameters.xml" />
+ <test-case sql="SELECT * FROM pg_catalog.pg_cast limit 1" db-types="PostgreSQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM information_schema.referential_constraints" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_information_schema_referential_constraints.xml" />
+ <test-case sql="SELECT * FROM pg_catalog.pg_config limit 1" db-types="PostgreSQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM information_schema.role_column_grants" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_information_schema_role_column_grants.xml" />
+ <test-case sql="SELECT * FROM pg_catalog.pg_db_role_setting limit 1" db-types="PostgreSQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM information_schema.role_routine_grants" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_information_schema_role_routine_grants.xml" />
+ <test-case sql="SELECT * FROM pg_catalog.pg_default_acl limit 1" db-types="PostgreSQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM information_schema.role_table_grants" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_information_schema_role_table_grants.xml" />
+ <test-case sql="SELECT * FROM pg_catalog.pg_depend limit 1" db-types="PostgreSQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM information_schema.role_udt_grants" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_information_schema_role_udt_grants.xml" />
+ <test-case sql="SELECT * FROM pg_catalog.pg_description limit 1" db-types="PostgreSQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM information_schema.role_usage_grants" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_information_schema_role_usage_grants.xml" />
+ <test-case sql="SELECT * FROM pg_catalog.pg_enum limit 1" db-types="PostgreSQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM information_schema.routine_column_usage" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_information_schema_routine_column_usage.xml" />
+ <test-case sql="SELECT * FROM pg_catalog.pg_event_trigger limit 1" db-types="PostgreSQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM information_schema.routine_privileges" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_information_schema_routine_privileges.xml" />
+ <test-case sql="SELECT * FROM pg_catalog.pg_foreign_data_wrapper limit 1" db-types="PostgreSQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM information_schema.routine_routine_usage" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_information_schema_routine_routine_usage.xml" />
+ <test-case sql="SELECT * FROM pg_catalog.pg_foreign_server limit 1" db-types="PostgreSQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM information_schema.routine_sequence_usage" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_information_schema_routine_sequence_usage.xml" />
+ <test-case sql="SELECT * FROM pg_catalog.pg_foreign_table limit 1" db-types="PostgreSQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM information_schema.routine_table_usage" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_information_schema_routine_table_usage.xml" />
+ <test-case sql="SELECT * FROM pg_catalog.pg_group limit 1" db-types="PostgreSQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM information_schema.routines" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_information_schema_routines.xml" />
+ <test-case sql="SELECT * FROM pg_catalog.pg_hba_file_rules limit 1" db-types="PostgreSQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM information_schema.schemata" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_information_schema_schemata.xml" />
+ <test-case sql="SELECT * FROM pg_catalog.pg_inherits limit 1" db-types="PostgreSQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM information_schema.sequences" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_information_schema_sequences.xml" />
+ <test-case sql="SELECT * FROM pg_catalog.pg_init_privs limit 1" db-types="PostgreSQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM information_schema.sql_features" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_information_schema_sql_features.xml" />
+ <test-case sql="SELECT * FROM pg_catalog.pg_largeobject_metadata limit 1" db-types="PostgreSQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM information_schema.sql_implementation_info" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_information_schema_sql_implementation_info.xml" />
+ <test-case sql="SELECT * FROM pg_catalog.pg_matviews limit 1" db-types="PostgreSQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM information_schema.sql_parts" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_information_schema_sql_parts.xml" />
+ <test-case sql="SELECT * FROM pg_catalog.pg_opfamily limit 1" db-types="PostgreSQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM information_schema.sql_sizing" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_information_schema_sql_sizing.xml" />
+ <test-case sql="SELECT * FROM pg_catalog.pg_partitioned_table limit 1" db-types="PostgreSQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM information_schema.table_constraints" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_information_schema_table_constraints.xml" />
+ <test-case sql="SELECT * FROM pg_catalog.pg_policies limit 1" db-types="PostgreSQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM information_schema.table_privileges" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_information_schema_table_privileges.xml" />
+ <test-case sql="SELECT * FROM pg_catalog.pg_policy limit 1" db-types="PostgreSQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM information_schema.tables" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_information_schema_tables.xml" />
+ <test-case sql="SELECT * FROM pg_catalog.pg_prepared_xacts limit 1" db-types="PostgreSQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM information_schema.transforms" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_information_schema_transforms.xml" />
+ <test-case sql="SELECT * FROM pg_catalog.pg_publication limit 1" db-types="PostgreSQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM information_schema.triggered_update_columns" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_information_schema_triggered_update_columns.xml" />
+ <test-case sql="SELECT * FROM pg_catalog.pg_publication_rel limit 1" db-types="PostgreSQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM information_schema.triggers" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_information_schema_triggers.xml" />
+ <test-case sql="SELECT * FROM pg_catalog.pg_publication_tables limit 1" db-types="PostgreSQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM information_schema.udt_privileges" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_information_schema_udt_privileges.xml" />
+ <test-case sql="SELECT * FROM pg_catalog.pg_range limit 1" db-types="PostgreSQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM information_schema.usage_privileges" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_information_schema_usage_privileges.xml" />
+ <test-case sql="SELECT * FROM pg_catalog.pg_replication_origin limit 1" db-types="PostgreSQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM information_schema.user_defined_types" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_information_schema_user_defined_types.xml" />
+ <test-case sql="SELECT * FROM pg_catalog.pg_replication_origin_status limit 1" db-types="PostgreSQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM information_schema.user_mapping_options" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_information_schema_user_mapping_options.xml" />
+ <test-case sql="SELECT * FROM pg_catalog.pg_replication_slots limit 1" db-types="PostgreSQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM information_schema.user_mappings" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_information_schema_user_mappings.xml" />
+ <test-case sql="SELECT * FROM pg_catalog.pg_rules limit 1" db-types="PostgreSQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM information_schema.view_column_usage" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_information_schema_view_column_usage.xml" />
+ <test-case sql="SELECT * FROM pg_catalog.pg_seclabel limit 1" db-types="PostgreSQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM information_schema.view_routine_usage" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_information_schema_view_routine_usage.xml" />
+ <test-case sql="SELECT * FROM pg_catalog.pg_seclabels limit 1" db-types="PostgreSQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM information_schema.view_table_usage" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_information_schema_view_table_usage.xml" />
+ <test-case sql="SELECT * FROM pg_catalog.pg_sequence limit 1" db-types="PostgreSQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM information_schema.views" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_information_schema_views.xml" />
+ <test-case sql="SELECT * FROM pg_catalog.pg_sequences limit 1" db-types="PostgreSQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM pg_catalog.pg_aggregate" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_pg_catalog_pg_aggregate.xml" />
+ <test-case sql="SELECT * FROM pg_catalog.pg_shdepend limit 1" db-types="PostgreSQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM pg_catalog.pg_am" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_pg_catalog_pg_am.xml" />
+ <test-case sql="SELECT * FROM pg_catalog.pg_shdescription limit 1" db-types="PostgreSQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM pg_catalog.pg_amop" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_pg_catalog_pg_amop.xml" />
+ <test-case sql="SELECT * FROM pg_catalog.pg_shseclabel limit 1" db-types="PostgreSQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM pg_catalog.pg_amproc" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_pg_catalog_pg_amproc.xml" />
+ <test-case sql="SELECT * FROM pg_catalog.pg_stat_all_tables limit 1" db-types="PostgreSQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM pg_catalog.pg_attrdef" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_pg_catalog_pg_attrdef.xml" />
+ <test-case sql="SELECT * FROM pg_catalog.pg_stat_database_conflicts limit 1" db-types="PostgreSQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM pg_catalog.pg_attribute" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_pg_catalog_pg_attribute.xml" />
+ <test-case sql="SELECT * FROM pg_catalog.pg_stat_progress_cluster limit 1" db-types="PostgreSQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM pg_catalog.pg_auth_members" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_pg_catalog_pg_auth_members.xml" />
+ <test-case sql="SELECT * FROM pg_catalog.pg_stat_progress_create_index limit 1" db-types="PostgreSQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM pg_catalog.pg_authid" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_pg_catalog_pg_authid.xml" />
+ <test-case sql="SELECT * FROM pg_catalog.pg_stat_progress_vacuum limit 1" db-types="PostgreSQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM pg_catalog.pg_available_extension_versions" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_pg_catalog_pg_available_extension_versions.xml" />
+ <test-case sql="SELECT * FROM pg_catalog.pg_stat_replication limit 1" db-types="PostgreSQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM pg_catalog.pg_available_extensions" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_pg_catalog_pg_available_extensions.xml" />
+ <test-case sql="SELECT * FROM pg_catalog.pg_stat_subscription limit 1" db-types="PostgreSQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM pg_catalog.pg_backend_memory_contexts" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_pg_catalog_pg_backend_memory_contexts.xml" />
+ <test-case sql="SELECT * FROM pg_catalog.pg_stat_user_functions limit 1" db-types="PostgreSQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM pg_catalog.pg_cast" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_pg_catalog_pg_cast.xml" />
+ <test-case sql="SELECT * FROM pg_catalog.pg_stat_wal_receiver limit 1" db-types="PostgreSQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM pg_catalog.pg_collation" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_pg_catalog_pg_collation.xml" />
+ <test-case sql="SELECT * FROM pg_catalog.pg_stat_xact_all_tables limit 1" db-types="PostgreSQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM pg_catalog.pg_config" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_pg_catalog_pg_config.xml" />
+ <test-case sql="SELECT * FROM pg_catalog.pg_stat_xact_user_functions limit 1" db-types="PostgreSQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM pg_catalog.pg_constraint" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_pg_catalog_pg_constraint.xml" />
+ <test-case sql="SELECT * FROM pg_catalog.pg_statio_all_sequences limit 1" db-types="PostgreSQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM pg_catalog.pg_conversion" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_pg_catalog_pg_conversion.xml" />
+ <test-case sql="SELECT * FROM pg_catalog.pg_statio_sys_sequences limit 1" db-types="PostgreSQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM pg_catalog.pg_cursors" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_pg_catalog_pg_cursors.xml" />
+ <test-case sql="SELECT * FROM pg_catalog.pg_statio_user_sequences limit 1" db-types="PostgreSQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM pg_catalog.pg_database" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_pg_catalog_pg_database.xml" />
+ <test-case sql="SELECT * FROM pg_catalog.pg_statistic_ext limit 1" db-types="PostgreSQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM pg_catalog.pg_db_role_setting" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_pg_catalog_pg_db_role_setting.xml" />
+ <test-case sql="SELECT * FROM pg_catalog.pg_statistic_ext_data limit 1" db-types="PostgreSQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM pg_catalog.pg_default_acl" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_pg_catalog_pg_default_acl.xml" />
+ <test-case sql="SELECT * FROM pg_catalog.pg_stats_ext limit 1" db-types="PostgreSQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM pg_catalog.pg_depend" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_pg_catalog_pg_depend.xml" />
+ <test-case sql="SELECT * FROM pg_catalog.pg_subscription limit 1" db-types="PostgreSQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM pg_catalog.pg_description" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_pg_catalog_pg_description.xml" />
+ <test-case sql="SELECT * FROM pg_catalog.pg_subscription_rel limit 1" db-types="PostgreSQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM pg_catalog.pg_enum" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_pg_catalog_pg_enum.xml" />
+ <test-case sql="SELECT * FROM pg_catalog.pg_tablespace limit 1" db-types="PostgreSQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM pg_catalog.pg_event_trigger" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_pg_catalog_pg_event_trigger.xml" />
+ <test-case sql="SELECT * FROM pg_catalog.pg_transform limit 1" db-types="PostgreSQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM pg_catalog.pg_extension" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_pg_catalog_pg_extension.xml" />
+ <test-case sql="SELECT * FROM pg_catalog.pg_ts_config limit 1" db-types="PostgreSQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM pg_catalog.pg_file_settings" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_pg_catalog_pg_file_settings.xml" />
+ <test-case sql="SELECT * FROM pg_catalog.pg_ts_config_map limit 1" db-types="PostgreSQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM pg_catalog.pg_foreign_data_wrapper" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_pg_catalog_pg_foreign_data_wrapper.xml" />
+ <test-case sql="SELECT * FROM pg_catalog.pg_ts_dict limit 1" db-types="PostgreSQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM pg_catalog.pg_foreign_server" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_pg_catalog_pg_foreign_server.xml" />
+ <test-case sql="SELECT * FROM pg_catalog.pg_ts_parser limit 1" db-types="PostgreSQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM pg_catalog.pg_foreign_table" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_pg_catalog_pg_foreign_table.xml" />
+ <test-case sql="SELECT * FROM pg_catalog.pg_ts_template limit 1" db-types="PostgreSQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM pg_catalog.pg_group" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_pg_catalog_pg_group.xml" />
+ <test-case sql="SELECT * FROM pg_catalog.pg_user_mapping limit 1" db-types="PostgreSQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM pg_catalog.pg_hba_file_rules" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_pg_catalog_pg_hba_file_rules.xml" />
+ <test-case sql="SELECT * FROM pg_catalog.pg_user_mappings limit 1" db-types="PostgreSQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
- <test-case sql="SELECT * FROM pg_catalog.pg_index" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_pg_catalog_pg_index.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_indexes" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_pg_catalog_pg_indexes.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_inherits" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_pg_catalog_pg_inherits.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_init_privs" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_pg_catalog_pg_init_privs.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_language" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_pg_catalog_pg_language.xml" />
- </test-case>
-
- <!-- TODO ERROR: Can not find JDBC type `-3` in PostgreSQL column type -->
- <!-- <test-case sql="SELECT * FROM pg_catalog.pg_largeobject" db-types="PostgreSQL" scenario-types="db">-->
- <!-- <assertion expected-data-file="select_postgresql_pg_catalog_pg_largeobject.xml" />-->
- <!-- </test-case>-->
-
- <test-case sql="SELECT * FROM pg_catalog.pg_largeobject_metadata" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_pg_catalog_pg_largeobject_metadata.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_locks" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_pg_catalog_pg_locks.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_matviews" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_pg_catalog_pg_matviews.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_opclass" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_pg_catalog_pg_opclass.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_operator" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_pg_catalog_pg_operator.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_opfamily" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_pg_catalog_pg_opfamily.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_partitioned_table" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_pg_catalog_pg_partitioned_table.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_policies" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_pg_catalog_pg_policies.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_policy" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_pg_catalog_pg_policy.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_prepared_statements" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_pg_catalog_pg_prepared_statements.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_prepared_xacts" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_pg_catalog_pg_prepared_xacts.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_proc" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_pg_catalog_pg_proc.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_publication" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_pg_catalog_pg_publication.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_publication_rel" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_pg_catalog_pg_publication_rel.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_publication_tables" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_pg_catalog_pg_publication_tables.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_range" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_pg_catalog_pg_range.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_replication_origin" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_pg_catalog_pg_replication_origin.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_replication_origin_status" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_pg_catalog_pg_replication_origin_status.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_replication_slots" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_pg_catalog_pg_replication_slots.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_rewrite" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_pg_catalog_pg_rewrite.xml" />
- </test-case>
-
- <!-- TODO ERROR: Index 24 out of bounds for length 24 -->
- <!-- <test-case sql="SELECT * FROM pg_catalog.pg_roles" db-types="PostgreSQL" scenario-types="db">-->
- <!-- <assertion expected-data-file="select_postgresql_pg_catalog_pg_roles.xml" />-->
- <!-- </test-case>-->
-
- <test-case sql="SELECT * FROM pg_catalog.pg_rules" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_pg_catalog_pg_rules.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_seclabel" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_pg_catalog_pg_seclabel.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_seclabels" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_pg_catalog_pg_seclabels.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_sequence" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_pg_catalog_pg_sequence.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_sequences" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_pg_catalog_pg_sequences.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_settings" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_pg_catalog_pg_settings.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_shadow" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_pg_catalog_pg_shadow.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_shdepend" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_pg_catalog_pg_shdepend.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_shdescription" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_pg_catalog_pg_shdescription.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_shmem_allocations" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_pg_catalog_pg_shmem_allocations.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_shseclabel" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_pg_catalog_pg_shseclabel.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_stat_activity" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_pg_catalog_pg_stat_activity.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_stat_all_indexes" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_pg_catalog_pg_stat_all_indexes.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_stat_all_tables" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_pg_catalog_pg_stat_all_tables.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_stat_archiver" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_pg_catalog_pg_stat_archiver.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_stat_bgwriter" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_pg_catalog_pg_stat_bgwriter.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_stat_database" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_pg_catalog_pg_stat_database.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_stat_database_conflicts" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_pg_catalog_pg_stat_database_conflicts.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_stat_gssapi" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_pg_catalog_pg_stat_gssapi.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_stat_progress_analyze" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_pg_catalog_pg_stat_progress_analyze.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_stat_progress_basebackup" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_pg_catalog_pg_stat_progress_basebackup.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_stat_progress_cluster" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_pg_catalog_pg_stat_progress_cluster.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_stat_progress_copy" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_pg_catalog_pg_stat_progress_copy.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_stat_progress_create_index" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_pg_catalog_pg_stat_progress_create_index.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_stat_progress_vacuum" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_pg_catalog_pg_stat_progress_vacuum.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_stat_replication" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_pg_catalog_pg_stat_replication.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_stat_replication_slots" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_pg_catalog_pg_stat_replication_slots.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_stat_slru" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_pg_catalog_pg_stat_slru.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_stat_ssl" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_pg_catalog_pg_stat_ssl.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_stat_subscription" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_pg_catalog_pg_stat_subscription.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_stat_sys_indexes" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_pg_catalog_pg_stat_sys_indexes.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_stat_sys_tables" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_pg_catalog_pg_stat_sys_tables.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_stat_user_functions" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_pg_catalog_pg_stat_user_functions.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_stat_user_indexes" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_pg_catalog_pg_stat_user_indexes.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_stat_user_tables" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_pg_catalog_pg_stat_user_tables.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_stat_wal" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_pg_catalog_pg_stat_wal.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_stat_wal_receiver" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_pg_catalog_pg_stat_wal_receiver.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_stat_xact_all_tables" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_pg_catalog_pg_stat_xact_all_tables.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_stat_xact_sys_tables" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_pg_catalog_pg_stat_xact_sys_tables.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_stat_xact_user_functions" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_pg_catalog_pg_stat_xact_user_functions.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_stat_xact_user_tables" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_pg_catalog_pg_stat_xact_user_tables.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_statio_all_indexes" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_pg_catalog_pg_statio_all_indexes.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_statio_all_sequences" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_pg_catalog_pg_statio_all_sequences.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_statio_all_tables" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_pg_catalog_pg_statio_all_tables.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_statio_sys_indexes" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_pg_catalog_pg_statio_sys_indexes.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_statio_sys_sequences" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_pg_catalog_pg_statio_sys_sequences.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_statio_sys_tables" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_pg_catalog_pg_statio_sys_tables.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_statio_user_indexes" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_pg_catalog_pg_statio_user_indexes.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_statio_user_sequences" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_pg_catalog_pg_statio_user_sequences.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_statio_user_tables" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_pg_catalog_pg_statio_user_tables.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_statistic" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_pg_catalog_pg_statistic.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_statistic_ext" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_pg_catalog_pg_statistic_ext.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_statistic_ext_data" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_pg_catalog_pg_statistic_ext_data.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_stats" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_pg_catalog_pg_stats.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_stats_ext" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_pg_catalog_pg_stats_ext.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_stats_ext_exprs" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_pg_catalog_pg_stats_ext_exprs.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_subscription" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_pg_catalog_pg_subscription.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_subscription_rel" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_pg_catalog_pg_subscription_rel.xml" />
- </test-case>
-
- <!-- TODO ERROR: Index: 10, size: 10 -->
-<!-- <test-case sql="SELECT * FROM pg_catalog.pg_tables" db-types="PostgreSQL" scenario-types="db">-->
-<!-- <assertion expected-data-file="select_postgresql_pg_catalog_pg_tables.xml" />-->
-<!-- </test-case>-->
-
- <test-case sql="SELECT * FROM pg_catalog.pg_tablespace" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_pg_catalog_pg_tablespace.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_timezone_abbrevs" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_pg_catalog_pg_timezone_abbrevs.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_timezone_names" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_pg_catalog_pg_timezone_names.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_transform" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_pg_catalog_pg_transform.xml" />
- </test-case>
-
- <!-- TODO ERROR: Can not find JDBC type `-3` in PostgreSQL column type -->
- <!-- <test-case sql="SELECT * FROM pg_catalog.pg_trigger" db-types="PostgreSQL" scenario-types="db">-->
- <!-- <assertion expected-data-file="select_postgresql_pg_catalog_pg_trigger.xml" />-->
- <!-- </test-case>-->
-
- <test-case sql="SELECT * FROM pg_catalog.pg_ts_config" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_pg_catalog_pg_ts_config.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_ts_config_map" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_pg_catalog_pg_ts_config_map.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_ts_dict" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_pg_catalog_pg_ts_dict.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_ts_parser" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_pg_catalog_pg_ts_parser.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_ts_template" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_pg_catalog_pg_ts_template.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_type" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_pg_catalog_pg_type.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_user" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_pg_catalog_pg_user.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_user_mapping" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_pg_catalog_pg_user_mapping.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_user_mappings" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_pg_catalog_pg_user_mappings.xml" />
- </test-case>
-
- <test-case sql="SELECT * FROM pg_catalog.pg_views" db-types="PostgreSQL" scenario-types="db">
- <assertion expected-data-file="select_postgresql_pg_catalog_pg_views.xml" />
+ <test-case sql="SELECT * FROM pg_catalog.pg_views limit 1" db-types="PostgreSQL" scenario-types="tbl" adapters="proxy">
+ <assertion expected-data-source-name="read_dataset" />
</test-case>
</integration-test-cases>