Debian Codegraph @

mysql-test/suite/storage_engine/misc.result

raw
1 INSERT INTO mysql.event (
2 db,
3 name,
4 body,
5 definer,
6 interval_value,
7 interval_field,
8 originator,
9 character_set_client,
10 collation_connection,
11 db_collation,
12 body_utf8)
13 values (
14 database(),
15 "ev1",
16 "select 1",
17 user(),
18 100,
19 "SECOND_MICROSECOND",
20 1,
21 'utf8',
22 'utf8_general_ci',
23 'utf8_general_ci',
24 'select 1');
25 SHOW EVENTS;
26 ERROR 42000: This version of MariaDB doesn't yet support 'MICROSECOND'
27 DROP EVENT ev1;
28 SELECT TABLE_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME
29 FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE ORDER BY TABLE_NAME;
30 TABLE_NAME COLUMN_NAME REFERENCED_TABLE_NAME REFERENCED_COLUMN_NAME
31 column_stats column_name NULL NULL
32 column_stats db_name NULL NULL
33 column_stats table_name NULL NULL
34 columns_priv Column_name NULL NULL
35 columns_priv Db NULL NULL
36 columns_priv Host NULL NULL
37 columns_priv Table_name NULL NULL
38 columns_priv User NULL NULL
39 db Db NULL NULL
40 db Host NULL NULL
41 db User NULL NULL
42 event db NULL NULL
43 event name NULL NULL
44 func name NULL NULL
45 gtid_slave_pos domain_id NULL NULL
46 gtid_slave_pos sub_id NULL NULL
47 help_category help_category_id NULL NULL
48 help_category name NULL NULL
49 help_keyword help_keyword_id NULL NULL
50 help_keyword name NULL NULL
51 help_relation help_keyword_id NULL NULL
52 help_relation help_topic_id NULL NULL
53 help_topic help_topic_id NULL NULL
54 help_topic name NULL NULL
55 host Db NULL NULL
56 host Host NULL NULL
57 index_stats db_name NULL NULL
58 index_stats index_name NULL NULL
59 index_stats prefix_arity NULL NULL
60 index_stats table_name NULL NULL
61 innodb_index_stats database_name NULL NULL
62 innodb_index_stats index_name NULL NULL
63 innodb_index_stats stat_name NULL NULL
64 innodb_index_stats table_name NULL NULL
65 innodb_table_stats database_name NULL NULL
66 innodb_table_stats table_name NULL NULL
67 plugin name NULL NULL
68 proc db NULL NULL
69 proc name NULL NULL
70 proc type NULL NULL
71 procs_priv Db NULL NULL
72 procs_priv Host NULL NULL
73 procs_priv Routine_name NULL NULL
74 procs_priv Routine_type NULL NULL
75 procs_priv User NULL NULL
76 proxies_priv Host NULL NULL
77 proxies_priv Proxied_host NULL NULL
78 proxies_priv Proxied_user NULL NULL
79 proxies_priv User NULL NULL
80 roles_mapping Host NULL NULL
81 roles_mapping Role NULL NULL
82 roles_mapping User NULL NULL
83 servers Server_name NULL NULL
84 table_stats db_name NULL NULL
85 table_stats table_name NULL NULL
86 tables_priv Db NULL NULL
87 tables_priv Host NULL NULL
88 tables_priv Table_name NULL NULL
89 tables_priv User NULL NULL
90 time_zone Time_zone_id NULL NULL
91 time_zone_leap_second Transition_time NULL NULL
92 time_zone_name Name NULL NULL
93 time_zone_transition Time_zone_id NULL NULL
94 time_zone_transition Transition_time NULL NULL
95 time_zone_transition_type Time_zone_id NULL NULL
96 time_zone_transition_type Transition_type_id NULL NULL
97 transaction_registry commit_id NULL NULL
98 transaction_registry transaction_id NULL NULL
99 user Host NULL NULL
100 user User NULL NULL