1--let $MYSQLD_DATADIR= `select @@datadir` 2 3--echo # 4--echo # MDEV-19906 Port show_old_temporals from MySQL 5.6 5--echo # 6 7--copy_file $MYSQL_TEST_DIR/std_data/mariadb53_temporal/mariadb5312_datetime.frm $MYSQLD_DATADIR/test/mariadb5312_datetime.frm 8TRUNCATE TABLE mariadb5312_datetime; 9SHOW CREATE TABLE mariadb5312_datetime; 10--vertical_results 11SELECT COLUMN_NAME, DATA_TYPE, COLUMN_TYPE FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME='mariadb5312_datetime'; 12DESCRIBE mariadb5312_datetime; 13--horizontal_results 14DROP TABLE mariadb5312_datetime; 15 16--copy_file $MYSQL_TEST_DIR/std_data/mariadb53_temporal/mariadb5312_timestamp.frm $MYSQLD_DATADIR/test/mariadb5312_timestamp.frm 17TRUNCATE TABLE mariadb5312_timestamp; 18SHOW CREATE TABLE mariadb5312_timestamp; 19--vertical_results 20SELECT COLUMN_NAME, DATA_TYPE, COLUMN_TYPE FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME='mariadb5312_timestamp'; 21DESCRIBE mariadb5312_timestamp; 22--horizontal_results 23DROP TABLE mariadb5312_timestamp; 24 25--copy_file $MYSQL_TEST_DIR/std_data/mariadb53_temporal/mariadb5312_time.frm $MYSQLD_DATADIR/test/mariadb5312_time.frm 26TRUNCATE TABLE mariadb5312_time; 27SHOW CREATE TABLE mariadb5312_time; 28--vertical_results 29SELECT COLUMN_NAME, DATA_TYPE, COLUMN_TYPE FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME='mariadb5312_time'; 30DESCRIBE mariadb5312_time; 31--horizontal_results 32DROP TABLE mariadb5312_time; 33