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