github.com/matrixorigin/matrixone@v0.7.0/test/distributed/cases/table/system_table_cases.sql (about)

     1  -- @suit
     2  -- @case
     3  -- @desc:test for Some System tables status, content, availability, and so on...
     4  -- @label:bvt
     5  
     6  -- tables in system
     7  USE system;
     8  -- statement_info
     9  SELECT COUNT(*) FROM (SELECT * FROM statement_info LIMIT 10) AS temp;
    10  SELECT COUNT(0) FROM (SELECT * FROM statement_info LIMIT 10) AS temp;
    11  SELECT COUNT('') FROM (SELECT * FROM statement_info LIMIT 10) AS temp;
    12  SELECT COUNT(NULL) FROM (SELECT * FROM statement_info LIMIT 10) AS temp;
    13  
    14  -- @bvt:issue#5895
    15  (SELECT * FROM statement_info LIMIT 1) UNION ALL (SELECT * FROM statement_info LIMIT 1);
    16  -- @bvt:issue
    17  
    18  -- rawlog
    19  SELECT COUNT(*) FROM (SELECT * FROM rawlog LIMIT 10) AS temp;
    20  SELECT COUNT(0) FROM (SELECT * FROM rawlog LIMIT 10) AS temp;
    21  SELECT COUNT('') FROM (SELECT * FROM rawlog LIMIT 10) AS temp;
    22  SELECT COUNT(NULL) FROM (SELECT * FROM rawlog LIMIT 10) AS temp;
    23  
    24  
    25  -- log_info
    26  SELECT COUNT(*) FROM (SELECT * FROM log_info LIMIT 10) AS temp;
    27  SELECT COUNT(0) FROM (SELECT * FROM log_info LIMIT 10) AS temp;
    28  SELECT COUNT('') FROM (SELECT * FROM log_info LIMIT 10) AS temp;
    29  SELECT COUNT(NULL) FROM (SELECT * FROM log_info LIMIT 10) AS temp;
    30  
    31  -- @bvt:issue#5901
    32  SELECT COUNT(*) FROM (SELECT * FROM error_info LIMIT 10) AS temp;
    33  SELECT COUNT(0) FROM (SELECT * FROM error_info LIMIT 10) AS temp;
    34  SELECT COUNT('') FROM (SELECT * FROM error_info LIMIT 10) AS temp;
    35  SELECT COUNT(NULL) FROM (SELECT * FROM error_info LIMIT 10) AS temp;
    36  -- @bvt:issue
    37  
    38  -- span_info
    39  SELECT COUNT(*) FROM (SELECT * FROM span_info LIMIT 10) AS temp;
    40  SELECT COUNT(0) FROM (SELECT * FROM span_info LIMIT 10) AS temp;
    41  SELECT COUNT('') FROM (SELECT * FROM span_info LIMIT 10) AS temp;
    42  SELECT COUNT(NULL) FROM (SELECT * FROM span_info LIMIT 10) AS temp;
    43  
    44  -- tables in system_metrics
    45  USE system_metrics;
    46  -- metric
    47  SELECT COUNT(*) FROM (SELECT * FROM metric LIMIT 10) AS temp;
    48  SELECT COUNT(0) FROM (SELECT * FROM metric LIMIT 10) AS temp;
    49  SELECT COUNT('') FROM (SELECT * FROM metric LIMIT 10) AS temp;
    50  SELECT COUNT(NULL) FROM (SELECT * FROM metric LIMIT 10) AS temp;
    51  
    52  -- sql_statement_total
    53  SELECT COUNT(*) FROM (SELECT * FROM sql_statement_total LIMIT 10) AS temp;
    54  SELECT COUNT(0) FROM (SELECT * FROM sql_statement_total LIMIT 10) AS temp;
    55  SELECT COUNT('') FROM (SELECT * FROM sql_statement_total LIMIT 10) AS temp;
    56  SELECT COUNT(NULL) FROM (SELECT * FROM sql_statement_total LIMIT 10) AS temp;
    57  
    58  -- sql_statement_errors
    59  SELECT COUNT(NULL) FROM (SELECT * FROM sql_statement_errors LIMIT 10) AS temp;
    60  
    61  -- sql_transaction_total
    62  SELECT COUNT(*) FROM (SELECT * FROM sql_transaction_total LIMIT 10) AS temp;
    63  SELECT COUNT(0) FROM (SELECT * FROM sql_transaction_total LIMIT 10) AS temp;
    64  SELECT COUNT('') FROM (SELECT * FROM sql_transaction_total LIMIT 10) AS temp;
    65  SELECT COUNT(NULL) FROM (SELECT * FROM sql_transaction_total LIMIT 10) AS temp;
    66  
    67  -- sql_transaction_errors
    68  SELECT COUNT(*) FROM (SELECT * FROM sql_transaction_errors LIMIT 10) AS temp;
    69  SELECT COUNT(0) FROM (SELECT * FROM sql_transaction_errors LIMIT 10) AS temp;
    70  SELECT COUNT('') FROM (SELECT * FROM sql_transaction_errors LIMIT 10) AS temp;
    71  SELECT COUNT(NULL) FROM (SELECT * FROM sql_transaction_errors LIMIT 10) AS temp;
    72  
    73  -- server_connections
    74  SELECT COUNT(*) FROM (SELECT * FROM server_connections LIMIT 10) AS temp;
    75  SELECT COUNT(0) FROM (SELECT * FROM server_connections LIMIT 10) AS temp;
    76  SELECT COUNT('') FROM (SELECT * FROM server_connections LIMIT 10) AS temp;
    77  SELECT COUNT(NULL) FROM (SELECT * FROM server_connections LIMIT 10) AS temp;
    78  
    79  -- process_cpu_percent
    80  SELECT COUNT(*) FROM (SELECT * FROM process_cpu_percent LIMIT 10) AS temp;
    81  SELECT COUNT(0) FROM (SELECT * FROM process_cpu_percent LIMIT 10) AS temp;
    82  SELECT COUNT('') FROM (SELECT * FROM process_cpu_percent LIMIT 10) AS temp;
    83  SELECT COUNT(NULL) FROM (SELECT * FROM process_cpu_percent LIMIT 10) AS temp;
    84  
    85  -- process_resident_memory_bytes
    86  SELECT COUNT(*) FROM (SELECT * FROM process_resident_memory_bytes LIMIT 10) AS temp;
    87  SELECT COUNT(0) FROM (SELECT * FROM process_resident_memory_bytes LIMIT 10) AS temp;
    88  SELECT COUNT('') FROM (SELECT * FROM process_resident_memory_bytes LIMIT 10) AS temp;
    89  SELECT COUNT(NULL) FROM (SELECT * FROM process_resident_memory_bytes LIMIT 10) AS temp;
    90  
    91  -- sys_cpu_seconds_total
    92  SELECT COUNT(*) FROM (SELECT * FROM sys_cpu_seconds_total LIMIT 10) AS temp;
    93  SELECT COUNT(0) FROM (SELECT * FROM sys_cpu_seconds_total LIMIT 10) AS temp;
    94  SELECT COUNT('') FROM (SELECT * FROM sys_cpu_seconds_total LIMIT 10) AS temp;
    95  SELECT COUNT(NULL) FROM (SELECT * FROM sys_cpu_seconds_total LIMIT 10) AS temp;
    96  
    97  -- sys_cpu_combined_percent
    98  SELECT COUNT(*) FROM (SELECT * FROM sys_cpu_combined_percent LIMIT 10) AS temp;
    99  SELECT COUNT(0) FROM (SELECT * FROM sys_cpu_combined_percent LIMIT 10) AS temp;
   100  SELECT COUNT('') FROM (SELECT * FROM sys_cpu_combined_percent LIMIT 10) AS temp;
   101  SELECT COUNT(NULL) FROM (SELECT * FROM sys_cpu_combined_percent LIMIT 10) AS temp;
   102  
   103  -- sys_memory_used
   104  SELECT COUNT(*) FROM (SELECT * FROM sys_memory_used LIMIT 10) AS temp;
   105  SELECT COUNT(0) FROM (SELECT * FROM sys_memory_used LIMIT 10) AS temp;
   106  SELECT COUNT('') FROM (SELECT * FROM sys_memory_used LIMIT 10) AS temp;
   107  SELECT COUNT(NULL) FROM (SELECT * FROM sys_memory_used LIMIT 10) AS temp;
   108  
   109  -- sys_memory_available
   110  SELECT COUNT(*) FROM (SELECT * FROM sys_memory_available LIMIT 10) AS temp;
   111  SELECT COUNT(0) FROM (SELECT * FROM sys_memory_available LIMIT 10) AS temp;
   112  SELECT COUNT('') FROM (SELECT * FROM sys_memory_available LIMIT 10) AS temp;
   113  SELECT COUNT(NULL) FROM (SELECT * FROM sys_memory_available LIMIT 10) AS temp;
   114  
   115  -- sys_disk_read_bytes
   116  SELECT COUNT(*) FROM (SELECT * FROM sys_disk_read_bytes LIMIT 10) AS temp;
   117  SELECT COUNT(0) FROM (SELECT * FROM sys_disk_read_bytes LIMIT 10) AS temp;
   118  SELECT COUNT('') FROM (SELECT * FROM sys_disk_read_bytes LIMIT 10) AS temp;
   119  SELECT COUNT(NULL) FROM (SELECT * FROM sys_disk_read_bytes LIMIT 10) AS temp;
   120  
   121  -- sys_disk_write_bytes
   122  SELECT COUNT(*) FROM (SELECT * FROM sys_disk_write_bytes LIMIT 10) AS temp;
   123  SELECT COUNT(0) FROM (SELECT * FROM sys_disk_write_bytes LIMIT 10) AS temp;
   124  SELECT COUNT('') FROM (SELECT * FROM sys_disk_write_bytes LIMIT 10) AS temp;
   125  SELECT COUNT(NULL) FROM (SELECT * FROM sys_disk_write_bytes LIMIT 10) AS temp;
   126  
   127  -- sys_net_recv_bytes
   128  SELECT COUNT(*) FROM (SELECT * FROM sys_net_recv_bytes LIMIT 10) AS temp;
   129  SELECT COUNT(0) FROM (SELECT * FROM sys_net_recv_bytes LIMIT 10) AS temp;
   130  SELECT COUNT('') FROM (SELECT * FROM sys_net_recv_bytes LIMIT 10) AS temp;
   131  SELECT COUNT(NULL) FROM (SELECT * FROM sys_net_recv_bytes LIMIT 10) AS temp;
   132  
   133  -- sys_net_sent_bytes
   134  SELECT COUNT(*) FROM (SELECT * FROM sys_net_sent_bytes LIMIT 10) AS temp;
   135  SELECT COUNT(0) FROM (SELECT * FROM sys_net_sent_bytes LIMIT 10) AS temp;
   136  SELECT COUNT('') FROM (SELECT * FROM sys_net_sent_bytes LIMIT 10) AS temp;
   137  SELECT COUNT(NULL) FROM (SELECT * FROM sys_net_sent_bytes LIMIT 10) AS temp;
   138  
   139  -- tables in mysql
   140  USE mysql;
   141  -- user
   142  SELECT COUNT(*) FROM (SELECT * FROM user LIMIT 10) AS temp;
   143  SELECT COUNT(0) FROM (SELECT * FROM user LIMIT 10) AS temp;
   144  SELECT COUNT('') FROM (SELECT * FROM user LIMIT 10) AS temp;
   145  SELECT COUNT(NULL) FROM (SELECT * FROM user LIMIT 10) AS temp;
   146  
   147  -- db
   148  SELECT COUNT(*) FROM (SELECT * FROM db LIMIT 10) AS temp;
   149  SELECT COUNT(0) FROM (SELECT * FROM db LIMIT 10) AS temp;
   150  SELECT COUNT('') FROM (SELECT * FROM db LIMIT 10) AS temp;
   151  SELECT COUNT(NULL) FROM (SELECT * FROM db LIMIT 10) AS temp;
   152  
   153  -- procs_priv
   154  SELECT COUNT(*) FROM (SELECT * FROM procs_priv LIMIT 10) AS temp;
   155  SELECT COUNT(0) FROM (SELECT * FROM procs_priv LIMIT 10) AS temp;
   156  SELECT COUNT('') FROM (SELECT * FROM procs_priv LIMIT 10) AS temp;
   157  SELECT COUNT(NULL) FROM (SELECT * FROM procs_priv LIMIT 10) AS temp;
   158  
   159  -- columns_priv
   160  SELECT COUNT(*) FROM (SELECT * FROM columns_priv LIMIT 10) AS temp;
   161  SELECT COUNT(0) FROM (SELECT * FROM columns_priv LIMIT 10) AS temp;
   162  SELECT COUNT('') FROM (SELECT * FROM columns_priv LIMIT 10) AS temp;
   163  SELECT COUNT(NULL) FROM (SELECT * FROM columns_priv LIMIT 10) AS temp;
   164  
   165  -- tables_priv
   166  SELECT COUNT(*) FROM (SELECT * FROM tables_priv LIMIT 10) AS temp;
   167  SELECT COUNT(0) FROM (SELECT * FROM tables_priv LIMIT 10) AS temp;
   168  SELECT COUNT('') FROM (SELECT * FROM tables_priv LIMIT 10) AS temp;
   169  SELECT COUNT(NULL) FROM (SELECT * FROM tables_priv LIMIT 10) AS temp;
   170  
   171  -- tables in information_schema
   172  USE information_schema;
   173  -- key_column_usage
   174  SELECT COUNT(*) FROM (SELECT * FROM key_column_usage LIMIT 10) AS temp;
   175  SELECT COUNT(0) FROM (SELECT * FROM key_column_usage LIMIT 10) AS temp;
   176  SELECT COUNT('') FROM (SELECT * FROM key_column_usage LIMIT 10) AS temp;
   177  SELECT COUNT(NULL) FROM (SELECT * FROM key_column_usage LIMIT 10) AS temp;
   178  
   179  -- columns
   180  SELECT COUNT(*) FROM (SELECT * FROM columns LIMIT 10) AS temp;
   181  SELECT COUNT(0) FROM (SELECT * FROM columns LIMIT 10) AS temp;
   182  SELECT COUNT('') FROM (SELECT * FROM columns LIMIT 10) AS temp;
   183  SELECT COUNT(NULL) FROM (SELECT * FROM columns LIMIT 10) AS temp;
   184  
   185  -- profiling
   186  SELECT COUNT(*) FROM (SELECT * FROM profiling LIMIT 10) AS temp;
   187  SELECT COUNT(0) FROM (SELECT * FROM profiling LIMIT 10) AS temp;
   188  SELECT COUNT('') FROM (SELECT * FROM profiling LIMIT 10) AS temp;
   189  SELECT COUNT(NULL) FROM (SELECT * FROM profiling LIMIT 10) AS temp;
   190  
   191  -- user_privileges
   192  SELECT COUNT(*) FROM (SELECT * FROM user_privileges LIMIT 10) AS temp;
   193  SELECT COUNT(0) FROM (SELECT * FROM user_privileges LIMIT 10) AS temp;
   194  SELECT COUNT('') FROM (SELECT * FROM user_privileges LIMIT 10) AS temp;
   195  SELECT COUNT(NULL) FROM (SELECT * FROM user_privileges LIMIT 10) AS temp;
   196  
   197  -- schemata
   198  SELECT COUNT(*) FROM (SELECT * FROM schemata where schema_name = 'mo_catalog' or schema_name = 'mo_task' LIMIT 10) AS temp;
   199  SELECT COUNT(0) FROM (SELECT * FROM schemata where schema_name = 'mo_catalog' or schema_name = 'mo_task' LIMIT 10) AS temp;
   200  SELECT COUNT('') FROM (SELECT * FROM schemata where schema_name = 'mo_catalog' or schema_name = 'mo_task' LIMIT 10) AS temp;
   201  SELECT COUNT(NULL) FROM (SELECT * FROM schemata where schema_name = 'mo_catalog' or schema_name = 'mo_task' LIMIT 10) AS temp;
   202  
   203  -- character_sets
   204  SELECT COUNT(*) FROM (SELECT * FROM character_sets LIMIT 10) AS temp;
   205  SELECT COUNT(0) FROM (SELECT * FROM character_sets LIMIT 10) AS temp;
   206  SELECT COUNT('') FROM (SELECT * FROM character_sets LIMIT 10) AS temp;
   207  SELECT COUNT(NULL) FROM (SELECT * FROM character_sets LIMIT 10) AS temp;
   208  
   209  -- triggers
   210  SELECT COUNT(*) FROM (SELECT * FROM triggers LIMIT 10) AS temp;
   211  SELECT COUNT(0) FROM (SELECT * FROM triggers LIMIT 10) AS temp;
   212  SELECT COUNT('') FROM (SELECT * FROM triggers LIMIT 10) AS temp;
   213  SELECT COUNT(NULL) FROM (SELECT * FROM triggers LIMIT 10) AS temp;
   214  
   215  -- tables
   216  SELECT COUNT(*) FROM (SELECT * FROM tables LIMIT 10) AS temp;
   217  SELECT COUNT(0) FROM (SELECT * FROM tables LIMIT 10) AS temp;
   218  SELECT COUNT('') FROM (SELECT * FROM tables LIMIT 10) AS temp;
   219  SELECT COUNT(NULL) FROM (SELECT * FROM tables LIMIT 10) AS temp;
   220  
   221  -- tables in mo_catalog
   222  USE mo_catalog;
   223  SHOW CREATE TABLE mo_columns;
   224  SHOW CREATE TABLE mo_database;
   225  SHOW CREATE TABLE mo_tables;