1drop view if exists test.user_view; 2"Testing mysql_upgrade with VIEW performance_schema.user_view" 3create view test.user_view as select "Not supposed to be here"; 4use performance_schema; 5show tables like "user_view"; 6Tables_in_performance_schema (user_view) 7user_view 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 164: Table 'cond_instances' already exists 12ERROR 1050 (42S01) at line 189: Table 'events_waits_current' already exists 13ERROR 1050 (42S01) at line 214: Table 'events_waits_history' already exists 14ERROR 1050 (42S01) at line 239: Table 'events_waits_history_long' already exists 15ERROR 1050 (42S01) at line 252: Table 'events_waits_summary_by_instance' already exists 16ERROR 1050 (42S01) at line 265: Table 'events_waits_summary_by_host_by_event_name' already exists 17ERROR 1050 (42S01) at line 278: Table 'events_waits_summary_by_user_by_event_name' already exists 18ERROR 1050 (42S01) at line 292: Table 'events_waits_summary_by_account_by_event_name' already exists 19ERROR 1050 (42S01) at line 305: Table 'events_waits_summary_by_thread_by_event_name' already exists 20ERROR 1050 (42S01) at line 317: Table 'events_waits_summary_global_by_event_name' already exists 21ERROR 1050 (42S01) at line 326: Table 'file_instances' already exists 22ERROR 1050 (42S01) at line 355: Table 'file_summary_by_event_name' already exists 23ERROR 1050 (42S01) at line 386: Table 'file_summary_by_instance' already exists 24ERROR 1050 (42S01) at line 399: Table 'socket_instances' already exists 25ERROR 1050 (42S01) at line 429: Table 'socket_summary_by_instance' already exists 26ERROR 1050 (42S01) at line 458: Table 'socket_summary_by_event_name' already exists 27ERROR 1050 (42S01) at line 493: Table 'host_cache' already exists 28ERROR 1050 (42S01) at line 502: Table 'mutex_instances' already exists 29ERROR 1050 (42S01) at line 516: Table 'objects_summary_global_by_type' already exists 30ERROR 1050 (42S01) at line 526: Table 'performance_timers' already exists 31ERROR 1050 (42S01) at line 536: Table 'rwlock_instances' already exists 32ERROR 1050 (42S01) at line 545: Table 'setup_actors' already exists 33ERROR 1050 (42S01) at line 553: Table 'setup_consumers' already exists 34ERROR 1050 (42S01) at line 562: Table 'setup_instruments' already exists 35ERROR 1050 (42S01) at line 573: Table 'setup_objects' already exists 36ERROR 1050 (42S01) at line 581: Table 'setup_timers' already exists 37ERROR 1050 (42S01) at line 626: Table 'table_io_waits_summary_by_index_usage' already exists 38ERROR 1050 (42S01) at line 670: Table 'table_io_waits_summary_by_table' already exists 39ERROR 1050 (42S01) at line 749: Table 'table_lock_waits_summary_by_table' already exists 40ERROR 1050 (42S01) at line 769: Table 'threads' already exists 41ERROR 1050 (42S01) at line 785: Table 'events_stages_current' already exists 42ERROR 1050 (42S01) at line 801: Table 'events_stages_history' already exists 43ERROR 1050 (42S01) at line 817: Table 'events_stages_history_long' already exists 44ERROR 1050 (42S01) at line 830: Table 'events_stages_summary_by_thread_by_event_name' already exists 45ERROR 1050 (42S01) at line 843: Table 'events_stages_summary_by_host_by_event_name' already exists 46ERROR 1050 (42S01) at line 856: Table 'events_stages_summary_by_user_by_event_name' already exists 47ERROR 1050 (42S01) at line 870: Table 'events_stages_summary_by_account_by_event_name' already exists 48ERROR 1050 (42S01) at line 882: Table 'events_stages_summary_global_by_event_name' already exists 49ERROR 1050 (42S01) at line 928: Table 'events_statements_current' already exists 50ERROR 1050 (42S01) at line 974: Table 'events_statements_history' already exists 51ERROR 1050 (42S01) at line 1020: Table 'events_statements_history_long' already exists 52ERROR 1050 (42S01) at line 1052: Table 'events_statements_summary_by_thread_by_event_name' already exists 53ERROR 1050 (42S01) at line 1084: Table 'events_statements_summary_by_host_by_event_name' already exists 54ERROR 1050 (42S01) at line 1116: Table 'events_statements_summary_by_user_by_event_name' already exists 55ERROR 1050 (42S01) at line 1149: Table 'events_statements_summary_by_account_by_event_name' already exists 56ERROR 1050 (42S01) at line 1180: Table 'events_statements_summary_global_by_event_name' already exists 57ERROR 1050 (42S01) at line 1189: Table 'hosts' already exists 58ERROR 1050 (42S01) at line 1198: Table 'users' already exists 59ERROR 1050 (42S01) at line 1208: Table 'accounts' already exists 60ERROR 1050 (42S01) at line 1243: Table 'events_statements_summary_by_digest' already exists 61ERROR 1050 (42S01) at line 1253: Table 'session_connect_attrs' already exists 62ERROR 1050 (42S01) at line 1259: Table 'session_account_connect_attrs' already exists 63ERROR 1644 (HY000) at line 1852: Unexpected content found in the performance_schema database. 64FATAL ERROR: Upgrade failed 65show tables like "user_view"; 66Tables_in_performance_schema (user_view) 67user_view 68use test; 69drop view test.user_view; 70