1let $MYSQLD_DATADIR= `select @@datadir`; 2 3--echo # 4--echo # MDEV-4819 Upgrade from MySQL 5.6 does not work 5--echo # Testing that we can open system tables created in MySQL-5.6 (5.6.13) 6--echo # 7 8 9--copy_file std_data/mysql5613mysql/columns_priv.frm $MYSQLD_DATADIR/test/columns_priv.frm 10--copy_file std_data/mysql5613mysql/columns_priv.MYD $MYSQLD_DATADIR/test/columns_priv.MYD 11--copy_file std_data/mysql5613mysql/columns_priv.MYI $MYSQLD_DATADIR/test/columns_priv.MYI 12SHOW CREATE TABLE columns_priv; 13SELECT * FROM columns_priv LIMIT 0; 14DROP TABLE columns_priv; 15 16--copy_file std_data/mysql5613mysql/db.frm $MYSQLD_DATADIR/test/db.frm 17--copy_file std_data/mysql5613mysql/db.MYD $MYSQLD_DATADIR/test/db.MYD 18--copy_file std_data/mysql5613mysql/db.MYI $MYSQLD_DATADIR/test/db.MYI 19SHOW CREATE TABLE db; 20SELECT * FROM db LIMIT 0; 21DROP TABLE db; 22 23 24--copy_file std_data/mysql5613mysql/event.frm $MYSQLD_DATADIR/test/event.frm 25--copy_file std_data/mysql5613mysql/event.MYD $MYSQLD_DATADIR/test/event.MYD 26--copy_file std_data/mysql5613mysql/event.MYI $MYSQLD_DATADIR/test/event.MYI 27SHOW CREATE TABLE event; 28SELECT * FROM event LIMIT 0; 29DROP TABLE event; 30 31--copy_file std_data/mysql5613mysql/func.frm $MYSQLD_DATADIR/test/func.frm 32--copy_file std_data/mysql5613mysql/func.MYD $MYSQLD_DATADIR/test/func.MYD 33--copy_file std_data/mysql5613mysql/func.MYI $MYSQLD_DATADIR/test/func.MYI 34SHOW CREATE TABLE func; 35SELECT * FROM func LIMIT 0; 36DROP TABLE func; 37 38--copy_file std_data/mysql5613mysql/plugin.frm $MYSQLD_DATADIR/test/plugin.frm 39--copy_file std_data/mysql5613mysql/plugin.MYD $MYSQLD_DATADIR/test/plugin.MYD 40--copy_file std_data/mysql5613mysql/plugin.MYI $MYSQLD_DATADIR/test/plugin.MYI 41SHOW CREATE TABLE plugin; 42SELECT * FROM plugin LIMIT 0; 43DROP TABLE plugin; 44 45--copy_file std_data/mysql5613mysql/proc.frm $MYSQLD_DATADIR/test/proc.frm 46--copy_file std_data/mysql5613mysql/proc.MYD $MYSQLD_DATADIR/test/proc.MYD 47--copy_file std_data/mysql5613mysql/proc.MYI $MYSQLD_DATADIR/test/proc.MYI 48SHOW CREATE TABLE proc; 49SELECT * FROM proc LIMIT 0; 50DROP TABLE proc; 51 52--copy_file std_data/mysql5613mysql/procs_priv.frm $MYSQLD_DATADIR/test/procs_priv.frm 53--copy_file std_data/mysql5613mysql/procs_priv.MYD $MYSQLD_DATADIR/test/procs_priv.MYD 54--copy_file std_data/mysql5613mysql/procs_priv.MYI $MYSQLD_DATADIR/test/procs_priv.MYI 55SHOW CREATE TABLE procs_priv; 56SELECT * FROM procs_priv LIMIT 0; 57DROP TABLE procs_priv; 58 59--copy_file std_data/mysql5613mysql/proxies_priv.frm $MYSQLD_DATADIR/test/proxies_priv.frm 60--copy_file std_data/mysql5613mysql/proxies_priv.MYD $MYSQLD_DATADIR/test/proxies_priv.MYD 61--copy_file std_data/mysql5613mysql/proxies_priv.MYI $MYSQLD_DATADIR/test/proxies_priv.MYI 62SHOW CREATE TABLE proxies_priv; 63SELECT * FROM proxies_priv LIMIT 0; 64DROP TABLE proxies_priv; 65 66--copy_file std_data/mysql5613mysql/servers.frm $MYSQLD_DATADIR/test/servers.frm 67--copy_file std_data/mysql5613mysql/servers.MYD $MYSQLD_DATADIR/test/servers.MYD 68--copy_file std_data/mysql5613mysql/servers.MYI $MYSQLD_DATADIR/test/servers.MYI 69SHOW CREATE TABLE servers; 70SELECT * FROM servers LIMIT 0; 71DROP TABLE servers; 72 73--copy_file std_data/mysql5613mysql/tables_priv.frm $MYSQLD_DATADIR/test/tables_priv.frm 74--copy_file std_data/mysql5613mysql/tables_priv.MYD $MYSQLD_DATADIR/test/tables_priv.MYD 75--copy_file std_data/mysql5613mysql/tables_priv.MYI $MYSQLD_DATADIR/test/tables_priv.MYI 76SHOW CREATE TABLE tables_priv; 77SELECT * FROM tables_priv LIMIT 0; 78DROP TABLE tables_priv; 79 80--copy_file std_data/mysql5613mysql/time_zone_leap_second.frm $MYSQLD_DATADIR/test/time_zone_leap_second.frm 81--copy_file std_data/mysql5613mysql/time_zone_leap_second.MYD $MYSQLD_DATADIR/test/time_zone_leap_second.MYD 82--copy_file std_data/mysql5613mysql/time_zone_leap_second.MYI $MYSQLD_DATADIR/test/time_zone_leap_second.MYI 83SHOW CREATE TABLE time_zone_leap_second; 84SELECT * FROM time_zone_leap_second LIMIT 0; 85DROP TABLE time_zone_leap_second; 86 87--copy_file std_data/mysql5613mysql/time_zone.frm $MYSQLD_DATADIR/test/time_zone.frm 88--copy_file std_data/mysql5613mysql/time_zone.MYD $MYSQLD_DATADIR/test/time_zone.MYD 89--copy_file std_data/mysql5613mysql/time_zone.MYI $MYSQLD_DATADIR/test/time_zone.MYI 90SHOW CREATE TABLE time_zone; 91SELECT * FROM time_zone LIMIT 0; 92DROP TABLE time_zone; 93 94--copy_file std_data/mysql5613mysql/time_zone_name.frm $MYSQLD_DATADIR/test/time_zone_name.frm 95--copy_file std_data/mysql5613mysql/time_zone_name.MYD $MYSQLD_DATADIR/test/time_zone_name.MYD 96--copy_file std_data/mysql5613mysql/time_zone_name.MYI $MYSQLD_DATADIR/test/time_zone_name.MYI 97SHOW CREATE TABLE time_zone_name; 98SELECT * FROM time_zone_name LIMIT 0; 99DROP TABLE time_zone_name; 100 101--copy_file std_data/mysql5613mysql/time_zone_transition.frm $MYSQLD_DATADIR/test/time_zone_transition.frm 102--copy_file std_data/mysql5613mysql/time_zone_transition.MYD $MYSQLD_DATADIR/test/time_zone_transition.MYD 103--copy_file std_data/mysql5613mysql/time_zone_transition.MYI $MYSQLD_DATADIR/test/time_zone_transition.MYI 104SHOW CREATE TABLE time_zone_transition; 105SELECT * FROM time_zone_transition LIMIT 0; 106DROP TABLE time_zone_transition; 107 108--copy_file std_data/mysql5613mysql/time_zone_transition_type.frm $MYSQLD_DATADIR/test/time_zone_transition_type.frm 109--copy_file std_data/mysql5613mysql/time_zone_transition_type.MYD $MYSQLD_DATADIR/test/time_zone_transition_type.MYD 110--copy_file std_data/mysql5613mysql/time_zone_transition_type.MYI $MYSQLD_DATADIR/test/time_zone_transition_type.MYI 111SHOW CREATE TABLE time_zone_transition_type; 112SELECT * FROM time_zone_transition_type LIMIT 0; 113DROP TABLE time_zone_transition_type; 114 115--copy_file std_data/mysql5613mysql/user.frm $MYSQLD_DATADIR/test/user.frm 116--copy_file std_data/mysql5613mysql/user.MYD $MYSQLD_DATADIR/test/user.MYD 117--copy_file std_data/mysql5613mysql/user.MYI $MYSQLD_DATADIR/test/user.MYI 118SHOW CREATE TABLE user; 119SELECT * FROM user LIMIT 0; 120DROP TABLE user; 121