1drop table if exists test.user_table;
2"Testing mysql_upgrade with TABLE performance_schema.user_table"
3create table test.user_table(a int);
4use performance_schema;
5show tables like "user_table";
6Tables_in_performance_schema (user_table)
7user_table
8Warning: Using a password on the command line interface can be insecure.
9Warning: Using a password on the command line interface can be insecure.
10Warning: Using a password on the command line interface can be insecure.
11ERROR 1050 (42S01) at line 163: Table 'cond_instances' already exists
12ERROR 1050 (42S01) at line 188: Table 'events_waits_current' already exists
13ERROR 1050 (42S01) at line 213: Table 'events_waits_history' already exists
14ERROR 1050 (42S01) at line 238: Table 'events_waits_history_long' already exists
15ERROR 1050 (42S01) at line 251: Table 'events_waits_summary_by_instance' already exists
16ERROR 1050 (42S01) at line 264: Table 'events_waits_summary_by_host_by_event_name' already exists
17ERROR 1050 (42S01) at line 277: Table 'events_waits_summary_by_user_by_event_name' already exists
18ERROR 1050 (42S01) at line 291: Table 'events_waits_summary_by_account_by_event_name' already exists
19ERROR 1050 (42S01) at line 304: Table 'events_waits_summary_by_thread_by_event_name' already exists
20ERROR 1050 (42S01) at line 316: Table 'events_waits_summary_global_by_event_name' already exists
21ERROR 1050 (42S01) at line 325: Table 'file_instances' already exists
22ERROR 1050 (42S01) at line 354: Table 'file_summary_by_event_name' already exists
23ERROR 1050 (42S01) at line 385: Table 'file_summary_by_instance' already exists
24ERROR 1050 (42S01) at line 398: Table 'socket_instances' already exists
25ERROR 1050 (42S01) at line 428: Table 'socket_summary_by_instance' already exists
26ERROR 1050 (42S01) at line 457: Table 'socket_summary_by_event_name' already exists
27ERROR 1050 (42S01) at line 492: Table 'host_cache' already exists
28ERROR 1050 (42S01) at line 501: Table 'mutex_instances' already exists
29ERROR 1050 (42S01) at line 515: Table 'objects_summary_global_by_type' already exists
30ERROR 1050 (42S01) at line 525: Table 'performance_timers' already exists
31ERROR 1050 (42S01) at line 535: Table 'rwlock_instances' already exists
32ERROR 1050 (42S01) at line 544: Table 'setup_actors' already exists
33ERROR 1050 (42S01) at line 552: Table 'setup_consumers' already exists
34ERROR 1050 (42S01) at line 561: Table 'setup_instruments' already exists
35ERROR 1050 (42S01) at line 572: Table 'setup_objects' already exists
36ERROR 1050 (42S01) at line 580: Table 'setup_timers' already exists
37ERROR 1050 (42S01) at line 625: Table 'table_io_waits_summary_by_index_usage' already exists
38ERROR 1050 (42S01) at line 669: Table 'table_io_waits_summary_by_table' already exists
39ERROR 1050 (42S01) at line 748: Table 'table_lock_waits_summary_by_table' already exists
40ERROR 1050 (42S01) at line 768: Table 'threads' already exists
41ERROR 1050 (42S01) at line 784: Table 'events_stages_current' already exists
42ERROR 1050 (42S01) at line 800: Table 'events_stages_history' already exists
43ERROR 1050 (42S01) at line 816: Table 'events_stages_history_long' already exists
44ERROR 1050 (42S01) at line 829: Table 'events_stages_summary_by_thread_by_event_name' already exists
45ERROR 1050 (42S01) at line 842: Table 'events_stages_summary_by_host_by_event_name' already exists
46ERROR 1050 (42S01) at line 855: Table 'events_stages_summary_by_user_by_event_name' already exists
47ERROR 1050 (42S01) at line 869: Table 'events_stages_summary_by_account_by_event_name' already exists
48ERROR 1050 (42S01) at line 881: Table 'events_stages_summary_global_by_event_name' already exists
49ERROR 1050 (42S01) at line 927: Table 'events_statements_current' already exists
50ERROR 1050 (42S01) at line 973: Table 'events_statements_history' already exists
51ERROR 1050 (42S01) at line 1019: Table 'events_statements_history_long' already exists
52ERROR 1050 (42S01) at line 1051: Table 'events_statements_summary_by_thread_by_event_name' already exists
53ERROR 1050 (42S01) at line 1083: Table 'events_statements_summary_by_host_by_event_name' already exists
54ERROR 1050 (42S01) at line 1115: Table 'events_statements_summary_by_user_by_event_name' already exists
55ERROR 1050 (42S01) at line 1148: Table 'events_statements_summary_by_account_by_event_name' already exists
56ERROR 1050 (42S01) at line 1179: Table 'events_statements_summary_global_by_event_name' already exists
57ERROR 1050 (42S01) at line 1188: Table 'hosts' already exists
58ERROR 1050 (42S01) at line 1197: Table 'users' already exists
59ERROR 1050 (42S01) at line 1207: Table 'accounts' already exists
60ERROR 1050 (42S01) at line 1242: Table 'events_statements_summary_by_digest' already exists
61ERROR 1050 (42S01) at line 1252: Table 'session_connect_attrs' already exists
62ERROR 1050 (42S01) at line 1258: Table 'session_account_connect_attrs' already exists
63ERROR 1644 (HY000) at line 1851: Unexpected content found in the performance_schema database.
64FATAL ERROR: Upgrade failed
65show tables like "user_table";
66Tables_in_performance_schema (user_table)
67user_table
68use test;
69drop table test.user_table;
70