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