diff options
Diffstat (limited to 'mysql-test/suite/storage_engine/misc.result')
-rw-r--r-- | mysql-test/suite/storage_engine/misc.result | 100 |
1 files changed, 100 insertions, 0 deletions
diff --git a/mysql-test/suite/storage_engine/misc.result b/mysql-test/suite/storage_engine/misc.result new file mode 100644 index 00000000..43d6a131 --- /dev/null +++ b/mysql-test/suite/storage_engine/misc.result @@ -0,0 +1,100 @@ +INSERT INTO mysql.event ( +db, +name, +body, +definer, +interval_value, +interval_field, +originator, +character_set_client, +collation_connection, +db_collation, +body_utf8) +values ( +database(), +"ev1", +"select 1", +user(), +100, +"SECOND_MICROSECOND", +1, +'utf8', +'utf8_general_ci', +'utf8_general_ci', +'select 1'); +SHOW EVENTS; +ERROR 42000: This version of MariaDB doesn't yet support 'MICROSECOND' +DROP EVENT ev1; +SELECT TABLE_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME +FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE ORDER BY TABLE_NAME; +TABLE_NAME COLUMN_NAME REFERENCED_TABLE_NAME REFERENCED_COLUMN_NAME +column_stats column_name NULL NULL +column_stats db_name NULL NULL +column_stats table_name NULL NULL +columns_priv Column_name NULL NULL +columns_priv Db NULL NULL +columns_priv Host NULL NULL +columns_priv Table_name NULL NULL +columns_priv User NULL NULL +db Db NULL NULL +db Host NULL NULL +db User NULL NULL +event db NULL NULL +event name NULL NULL +func name NULL NULL +gtid_slave_pos domain_id NULL NULL +gtid_slave_pos sub_id NULL NULL +help_category help_category_id NULL NULL +help_category name NULL NULL +help_keyword help_keyword_id NULL NULL +help_keyword name NULL NULL +help_relation help_keyword_id NULL NULL +help_relation help_topic_id NULL NULL +help_topic help_topic_id NULL NULL +help_topic name NULL NULL +host Db NULL NULL +host Host NULL NULL +index_stats db_name NULL NULL +index_stats index_name NULL NULL +index_stats prefix_arity NULL NULL +index_stats table_name NULL NULL +innodb_index_stats database_name NULL NULL +innodb_index_stats index_name NULL NULL +innodb_index_stats stat_name NULL NULL +innodb_index_stats table_name NULL NULL +innodb_table_stats database_name NULL NULL +innodb_table_stats table_name NULL NULL +plugin name NULL NULL +proc db NULL NULL +proc name NULL NULL +proc type NULL NULL +procs_priv Db NULL NULL +procs_priv Host NULL NULL +procs_priv Routine_name NULL NULL +procs_priv Routine_type NULL NULL +procs_priv User NULL NULL +proxies_priv Host NULL NULL +proxies_priv Proxied_host NULL NULL +proxies_priv Proxied_user NULL NULL +proxies_priv User NULL NULL +roles_mapping Host NULL NULL +roles_mapping Role NULL NULL +roles_mapping User NULL NULL +servers Server_name NULL NULL +table_stats db_name NULL NULL +table_stats table_name NULL NULL +tables_priv Db NULL NULL +tables_priv Host NULL NULL +tables_priv Table_name NULL NULL +tables_priv User NULL NULL +time_zone Time_zone_id NULL NULL +time_zone_leap_second Transition_time NULL NULL +time_zone_name Name NULL NULL +time_zone_transition Time_zone_id NULL NULL +time_zone_transition Transition_time NULL NULL +time_zone_transition_type Time_zone_id NULL NULL +time_zone_transition_type Transition_type_id NULL NULL +transaction_registry commit_id NULL NULL +transaction_registry transaction_id NULL NULL +user Host NULL NULL +user User NULL NULL |