EVOLUTION-MANAGER

Edit File: change_column_int.test

source include/have_tokudb.inc; # this test is generated by change_int.py # test int expansion is hot --disable_warnings DROP TABLE IF EXISTS t, ti; --enable_warnings SET SESSION DEFAULT_STORAGE_ENGINE="TokuDB"; SET SESSION TOKUDB_DISABLE_SLOW_ALTER=1; CREATE TABLE t (a TINYINT); INSERT INTO t VALUES ( -128 ); INSERT INTO t VALUES ( -1 ); INSERT INTO t VALUES ( 0 ); INSERT INTO t VALUES ( 1 ); INSERT INTO t VALUES ( 127 ); CREATE TABLE ti LIKE t; ALTER TABLE ti ENGINE=myisam; INSERT INTO ti SELECT * from t; ALTER TABLE ti CHANGE COLUMN a a TINYINT; ALTER TABLE t CHANGE COLUMN a a TINYINT; let $diff_tables = test.t, test.ti; source include/diff_tables.inc; DROP TABLE ti; DROP TABLE t; CREATE TABLE t (a TINYINT); INSERT INTO t VALUES ( -128 ); INSERT INTO t VALUES ( -1 ); INSERT INTO t VALUES ( 0 ); INSERT INTO t VALUES ( 1 ); INSERT INTO t VALUES ( 127 ); CREATE TABLE ti LIKE t; ALTER TABLE ti ENGINE=myisam; INSERT INTO ti SELECT * from t; ALTER TABLE ti CHANGE COLUMN a a SMALLINT; ALTER TABLE t CHANGE COLUMN a a SMALLINT; let $diff_tables = test.t, test.ti; source include/diff_tables.inc; DROP TABLE ti; DROP TABLE t; CREATE TABLE t (a TINYINT); INSERT INTO t VALUES ( -128 ); INSERT INTO t VALUES ( -1 ); INSERT INTO t VALUES ( 0 ); INSERT INTO t VALUES ( 1 ); INSERT INTO t VALUES ( 127 ); CREATE TABLE ti LIKE t; ALTER TABLE ti ENGINE=myisam; INSERT INTO ti SELECT * from t; ALTER TABLE ti CHANGE COLUMN a a MEDIUMINT; ALTER TABLE t CHANGE COLUMN a a MEDIUMINT; let $diff_tables = test.t, test.ti; source include/diff_tables.inc; DROP TABLE ti; DROP TABLE t; CREATE TABLE t (a TINYINT); INSERT INTO t VALUES ( -128 ); INSERT INTO t VALUES ( -1 ); INSERT INTO t VALUES ( 0 ); INSERT INTO t VALUES ( 1 ); INSERT INTO t VALUES ( 127 ); CREATE TABLE ti LIKE t; ALTER TABLE ti ENGINE=myisam; INSERT INTO ti SELECT * from t; ALTER TABLE ti CHANGE COLUMN a a INT; ALTER TABLE t CHANGE COLUMN a a INT; let $diff_tables = test.t, test.ti; source include/diff_tables.inc; DROP TABLE ti; DROP TABLE t; CREATE TABLE t (a TINYINT); INSERT INTO t VALUES ( -128 ); INSERT INTO t VALUES ( -1 ); INSERT INTO t VALUES ( 0 ); INSERT INTO t VALUES ( 1 ); INSERT INTO t VALUES ( 127 ); CREATE TABLE ti LIKE t; ALTER TABLE ti ENGINE=myisam; INSERT INTO ti SELECT * from t; ALTER TABLE ti CHANGE COLUMN a a BIGINT; ALTER TABLE t CHANGE COLUMN a a BIGINT; let $diff_tables = test.t, test.ti; source include/diff_tables.inc; DROP TABLE ti; DROP TABLE t; CREATE TABLE t (a SMALLINT); --replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ --error ER_UNSUPPORTED_EXTENSION ALTER TABLE t CHANGE COLUMN a a TINYINT; DROP TABLE t; CREATE TABLE t (a SMALLINT); INSERT INTO t VALUES ( -32768 ); INSERT INTO t VALUES ( -1 ); INSERT INTO t VALUES ( 0 ); INSERT INTO t VALUES ( 1 ); INSERT INTO t VALUES ( 32767 ); CREATE TABLE ti LIKE t; ALTER TABLE ti ENGINE=myisam; INSERT INTO ti SELECT * from t; ALTER TABLE ti CHANGE COLUMN a a SMALLINT; ALTER TABLE t CHANGE COLUMN a a SMALLINT; let $diff_tables = test.t, test.ti; source include/diff_tables.inc; DROP TABLE ti; DROP TABLE t; CREATE TABLE t (a SMALLINT); INSERT INTO t VALUES ( -32768 ); INSERT INTO t VALUES ( -1 ); INSERT INTO t VALUES ( 0 ); INSERT INTO t VALUES ( 1 ); INSERT INTO t VALUES ( 32767 ); CREATE TABLE ti LIKE t; ALTER TABLE ti ENGINE=myisam; INSERT INTO ti SELECT * from t; ALTER TABLE ti CHANGE COLUMN a a MEDIUMINT; ALTER TABLE t CHANGE COLUMN a a MEDIUMINT; let $diff_tables = test.t, test.ti; source include/diff_tables.inc; DROP TABLE ti; DROP TABLE t; CREATE TABLE t (a SMALLINT); INSERT INTO t VALUES ( -32768 ); INSERT INTO t VALUES ( -1 ); INSERT INTO t VALUES ( 0 ); INSERT INTO t VALUES ( 1 ); INSERT INTO t VALUES ( 32767 ); CREATE TABLE ti LIKE t; ALTER TABLE ti ENGINE=myisam; INSERT INTO ti SELECT * from t; ALTER TABLE ti CHANGE COLUMN a a INT; ALTER TABLE t CHANGE COLUMN a a INT; let $diff_tables = test.t, test.ti; source include/diff_tables.inc; DROP TABLE ti; DROP TABLE t; CREATE TABLE t (a SMALLINT); INSERT INTO t VALUES ( -32768 ); INSERT INTO t VALUES ( -1 ); INSERT INTO t VALUES ( 0 ); INSERT INTO t VALUES ( 1 ); INSERT INTO t VALUES ( 32767 ); CREATE TABLE ti LIKE t; ALTER TABLE ti ENGINE=myisam; INSERT INTO ti SELECT * from t; ALTER TABLE ti CHANGE COLUMN a a BIGINT; ALTER TABLE t CHANGE COLUMN a a BIGINT; let $diff_tables = test.t, test.ti; source include/diff_tables.inc; DROP TABLE ti; DROP TABLE t; CREATE TABLE t (a MEDIUMINT); --replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ --error ER_UNSUPPORTED_EXTENSION ALTER TABLE t CHANGE COLUMN a a TINYINT; DROP TABLE t; CREATE TABLE t (a MEDIUMINT); --replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ --error ER_UNSUPPORTED_EXTENSION ALTER TABLE t CHANGE COLUMN a a SMALLINT; DROP TABLE t; CREATE TABLE t (a MEDIUMINT); INSERT INTO t VALUES ( -8388608 ); INSERT INTO t VALUES ( -1 ); INSERT INTO t VALUES ( 0 ); INSERT INTO t VALUES ( 1 ); INSERT INTO t VALUES ( 8388607 ); CREATE TABLE ti LIKE t; ALTER TABLE ti ENGINE=myisam; INSERT INTO ti SELECT * from t; ALTER TABLE ti CHANGE COLUMN a a MEDIUMINT; ALTER TABLE t CHANGE COLUMN a a MEDIUMINT; let $diff_tables = test.t, test.ti; source include/diff_tables.inc; DROP TABLE ti; DROP TABLE t; CREATE TABLE t (a MEDIUMINT); INSERT INTO t VALUES ( -8388608 ); INSERT INTO t VALUES ( -1 ); INSERT INTO t VALUES ( 0 ); INSERT INTO t VALUES ( 1 ); INSERT INTO t VALUES ( 8388607 ); CREATE TABLE ti LIKE t; ALTER TABLE ti ENGINE=myisam; INSERT INTO ti SELECT * from t; ALTER TABLE ti CHANGE COLUMN a a INT; ALTER TABLE t CHANGE COLUMN a a INT; let $diff_tables = test.t, test.ti; source include/diff_tables.inc; DROP TABLE ti; DROP TABLE t; CREATE TABLE t (a MEDIUMINT); INSERT INTO t VALUES ( -8388608 ); INSERT INTO t VALUES ( -1 ); INSERT INTO t VALUES ( 0 ); INSERT INTO t VALUES ( 1 ); INSERT INTO t VALUES ( 8388607 ); CREATE TABLE ti LIKE t; ALTER TABLE ti ENGINE=myisam; INSERT INTO ti SELECT * from t; ALTER TABLE ti CHANGE COLUMN a a BIGINT; ALTER TABLE t CHANGE COLUMN a a BIGINT; let $diff_tables = test.t, test.ti; source include/diff_tables.inc; DROP TABLE ti; DROP TABLE t; CREATE TABLE t (a INT); --replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ --error ER_UNSUPPORTED_EXTENSION ALTER TABLE t CHANGE COLUMN a a TINYINT; DROP TABLE t; CREATE TABLE t (a INT); --replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ --error ER_UNSUPPORTED_EXTENSION ALTER TABLE t CHANGE COLUMN a a SMALLINT; DROP TABLE t; CREATE TABLE t (a INT); --replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ --error ER_UNSUPPORTED_EXTENSION ALTER TABLE t CHANGE COLUMN a a MEDIUMINT; DROP TABLE t; CREATE TABLE t (a INT); INSERT INTO t VALUES ( -2147483648 ); INSERT INTO t VALUES ( 0 ); INSERT INTO t VALUES ( 1 ); INSERT INTO t VALUES ( 2147483647 ); CREATE TABLE ti LIKE t; ALTER TABLE ti ENGINE=myisam; INSERT INTO ti SELECT * from t; ALTER TABLE ti CHANGE COLUMN a a INT; ALTER TABLE t CHANGE COLUMN a a INT; let $diff_tables = test.t, test.ti; source include/diff_tables.inc; DROP TABLE ti; DROP TABLE t; CREATE TABLE t (a INT); INSERT INTO t VALUES ( -2147483648 ); INSERT INTO t VALUES ( 0 ); INSERT INTO t VALUES ( 1 ); INSERT INTO t VALUES ( 2147483647 ); CREATE TABLE ti LIKE t; ALTER TABLE ti ENGINE=myisam; INSERT INTO ti SELECT * from t; ALTER TABLE ti CHANGE COLUMN a a BIGINT; ALTER TABLE t CHANGE COLUMN a a BIGINT; let $diff_tables = test.t, test.ti; source include/diff_tables.inc; DROP TABLE ti; DROP TABLE t; CREATE TABLE t (a BIGINT); --replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ --error ER_UNSUPPORTED_EXTENSION ALTER TABLE t CHANGE COLUMN a a TINYINT; DROP TABLE t; CREATE TABLE t (a BIGINT); --replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ --error ER_UNSUPPORTED_EXTENSION ALTER TABLE t CHANGE COLUMN a a SMALLINT; DROP TABLE t; CREATE TABLE t (a BIGINT); --replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ --error ER_UNSUPPORTED_EXTENSION ALTER TABLE t CHANGE COLUMN a a MEDIUMINT; DROP TABLE t; CREATE TABLE t (a BIGINT); --replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ --error ER_UNSUPPORTED_EXTENSION ALTER TABLE t CHANGE COLUMN a a INT; DROP TABLE t; CREATE TABLE t (a BIGINT); INSERT INTO t VALUES ( -9223372036854775808 ); INSERT INTO t VALUES ( 0 ); INSERT INTO t VALUES ( 1 ); INSERT INTO t VALUES ( 9223372036854775807 ); CREATE TABLE ti LIKE t; ALTER TABLE ti ENGINE=myisam; INSERT INTO ti SELECT * from t; ALTER TABLE ti CHANGE COLUMN a a BIGINT; ALTER TABLE t CHANGE COLUMN a a BIGINT; let $diff_tables = test.t, test.ti; source include/diff_tables.inc; DROP TABLE ti; DROP TABLE t; CREATE TABLE t (a TINYINT UNSIGNED); INSERT INTO t VALUES ( 0 ); INSERT INTO t VALUES ( 1 ); INSERT INTO t VALUES ( 255 ); CREATE TABLE ti LIKE t; ALTER TABLE ti ENGINE=myisam; INSERT INTO ti SELECT * from t; ALTER TABLE ti CHANGE COLUMN a a TINYINT UNSIGNED; ALTER TABLE t CHANGE COLUMN a a TINYINT UNSIGNED; let $diff_tables = test.t, test.ti; source include/diff_tables.inc; DROP TABLE ti; DROP TABLE t; CREATE TABLE t (a TINYINT UNSIGNED); INSERT INTO t VALUES ( 0 ); INSERT INTO t VALUES ( 1 ); INSERT INTO t VALUES ( 255 ); CREATE TABLE ti LIKE t; ALTER TABLE ti ENGINE=myisam; INSERT INTO ti SELECT * from t; ALTER TABLE ti CHANGE COLUMN a a SMALLINT UNSIGNED; ALTER TABLE t CHANGE COLUMN a a SMALLINT UNSIGNED; let $diff_tables = test.t, test.ti; source include/diff_tables.inc; DROP TABLE ti; DROP TABLE t; CREATE TABLE t (a TINYINT UNSIGNED); INSERT INTO t VALUES ( 0 ); INSERT INTO t VALUES ( 1 ); INSERT INTO t VALUES ( 255 ); CREATE TABLE ti LIKE t; ALTER TABLE ti ENGINE=myisam; INSERT INTO ti SELECT * from t; ALTER TABLE ti CHANGE COLUMN a a MEDIUMINT UNSIGNED; ALTER TABLE t CHANGE COLUMN a a MEDIUMINT UNSIGNED; let $diff_tables = test.t, test.ti; source include/diff_tables.inc; DROP TABLE ti; DROP TABLE t; CREATE TABLE t (a TINYINT UNSIGNED); INSERT INTO t VALUES ( 0 ); INSERT INTO t VALUES ( 1 ); INSERT INTO t VALUES ( 255 ); CREATE TABLE ti LIKE t; ALTER TABLE ti ENGINE=myisam; INSERT INTO ti SELECT * from t; ALTER TABLE ti CHANGE COLUMN a a INT UNSIGNED; ALTER TABLE t CHANGE COLUMN a a INT UNSIGNED; let $diff_tables = test.t, test.ti; source include/diff_tables.inc; DROP TABLE ti; DROP TABLE t; CREATE TABLE t (a TINYINT UNSIGNED); INSERT INTO t VALUES ( 0 ); INSERT INTO t VALUES ( 1 ); INSERT INTO t VALUES ( 255 ); CREATE TABLE ti LIKE t; ALTER TABLE ti ENGINE=myisam; INSERT INTO ti SELECT * from t; ALTER TABLE ti CHANGE COLUMN a a BIGINT UNSIGNED; ALTER TABLE t CHANGE COLUMN a a BIGINT UNSIGNED; let $diff_tables = test.t, test.ti; source include/diff_tables.inc; DROP TABLE ti; DROP TABLE t; CREATE TABLE t (a SMALLINT UNSIGNED); --replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ --error ER_UNSUPPORTED_EXTENSION ALTER TABLE t CHANGE COLUMN a a TINYINT UNSIGNED; DROP TABLE t; CREATE TABLE t (a SMALLINT UNSIGNED); INSERT INTO t VALUES ( 0 ); INSERT INTO t VALUES ( 1 ); INSERT INTO t VALUES ( 65535 ); CREATE TABLE ti LIKE t; ALTER TABLE ti ENGINE=myisam; INSERT INTO ti SELECT * from t; ALTER TABLE ti CHANGE COLUMN a a SMALLINT UNSIGNED; ALTER TABLE t CHANGE COLUMN a a SMALLINT UNSIGNED; let $diff_tables = test.t, test.ti; source include/diff_tables.inc; DROP TABLE ti; DROP TABLE t; CREATE TABLE t (a SMALLINT UNSIGNED); INSERT INTO t VALUES ( 0 ); INSERT INTO t VALUES ( 1 ); INSERT INTO t VALUES ( 65535 ); CREATE TABLE ti LIKE t; ALTER TABLE ti ENGINE=myisam; INSERT INTO ti SELECT * from t; ALTER TABLE ti CHANGE COLUMN a a MEDIUMINT UNSIGNED; ALTER TABLE t CHANGE COLUMN a a MEDIUMINT UNSIGNED; let $diff_tables = test.t, test.ti; source include/diff_tables.inc; DROP TABLE ti; DROP TABLE t; CREATE TABLE t (a SMALLINT UNSIGNED); INSERT INTO t VALUES ( 0 ); INSERT INTO t VALUES ( 1 ); INSERT INTO t VALUES ( 65535 ); CREATE TABLE ti LIKE t; ALTER TABLE ti ENGINE=myisam; INSERT INTO ti SELECT * from t; ALTER TABLE ti CHANGE COLUMN a a INT UNSIGNED; ALTER TABLE t CHANGE COLUMN a a INT UNSIGNED; let $diff_tables = test.t, test.ti; source include/diff_tables.inc; DROP TABLE ti; DROP TABLE t; CREATE TABLE t (a SMALLINT UNSIGNED); INSERT INTO t VALUES ( 0 ); INSERT INTO t VALUES ( 1 ); INSERT INTO t VALUES ( 65535 ); CREATE TABLE ti LIKE t; ALTER TABLE ti ENGINE=myisam; INSERT INTO ti SELECT * from t; ALTER TABLE ti CHANGE COLUMN a a BIGINT UNSIGNED; ALTER TABLE t CHANGE COLUMN a a BIGINT UNSIGNED; let $diff_tables = test.t, test.ti; source include/diff_tables.inc; DROP TABLE ti; DROP TABLE t; CREATE TABLE t (a MEDIUMINT UNSIGNED); --replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ --error ER_UNSUPPORTED_EXTENSION ALTER TABLE t CHANGE COLUMN a a TINYINT UNSIGNED; DROP TABLE t; CREATE TABLE t (a MEDIUMINT UNSIGNED); --replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ --error ER_UNSUPPORTED_EXTENSION ALTER TABLE t CHANGE COLUMN a a SMALLINT UNSIGNED; DROP TABLE t; CREATE TABLE t (a MEDIUMINT UNSIGNED); INSERT INTO t VALUES ( 0 ); INSERT INTO t VALUES ( 1 ); INSERT INTO t VALUES ( 16777215 ); CREATE TABLE ti LIKE t; ALTER TABLE ti ENGINE=myisam; INSERT INTO ti SELECT * from t; ALTER TABLE ti CHANGE COLUMN a a MEDIUMINT UNSIGNED; ALTER TABLE t CHANGE COLUMN a a MEDIUMINT UNSIGNED; let $diff_tables = test.t, test.ti; source include/diff_tables.inc; DROP TABLE ti; DROP TABLE t; CREATE TABLE t (a MEDIUMINT UNSIGNED); INSERT INTO t VALUES ( 0 ); INSERT INTO t VALUES ( 1 ); INSERT INTO t VALUES ( 16777215 ); CREATE TABLE ti LIKE t; ALTER TABLE ti ENGINE=myisam; INSERT INTO ti SELECT * from t; ALTER TABLE ti CHANGE COLUMN a a INT UNSIGNED; ALTER TABLE t CHANGE COLUMN a a INT UNSIGNED; let $diff_tables = test.t, test.ti; source include/diff_tables.inc; DROP TABLE ti; DROP TABLE t; CREATE TABLE t (a MEDIUMINT UNSIGNED); INSERT INTO t VALUES ( 0 ); INSERT INTO t VALUES ( 1 ); INSERT INTO t VALUES ( 16777215 ); CREATE TABLE ti LIKE t; ALTER TABLE ti ENGINE=myisam; INSERT INTO ti SELECT * from t; ALTER TABLE ti CHANGE COLUMN a a BIGINT UNSIGNED; ALTER TABLE t CHANGE COLUMN a a BIGINT UNSIGNED; let $diff_tables = test.t, test.ti; source include/diff_tables.inc; DROP TABLE ti; DROP TABLE t; CREATE TABLE t (a INT UNSIGNED); --replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ --error ER_UNSUPPORTED_EXTENSION ALTER TABLE t CHANGE COLUMN a a TINYINT UNSIGNED; DROP TABLE t; CREATE TABLE t (a INT UNSIGNED); --replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ --error ER_UNSUPPORTED_EXTENSION ALTER TABLE t CHANGE COLUMN a a SMALLINT UNSIGNED; DROP TABLE t; CREATE TABLE t (a INT UNSIGNED); --replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ --error ER_UNSUPPORTED_EXTENSION ALTER TABLE t CHANGE COLUMN a a MEDIUMINT UNSIGNED; DROP TABLE t; CREATE TABLE t (a INT UNSIGNED); INSERT INTO t VALUES ( 0 ); INSERT INTO t VALUES ( 1 ); INSERT INTO t VALUES ( 4294967295 ); CREATE TABLE ti LIKE t; ALTER TABLE ti ENGINE=myisam; INSERT INTO ti SELECT * from t; ALTER TABLE ti CHANGE COLUMN a a INT UNSIGNED; ALTER TABLE t CHANGE COLUMN a a INT UNSIGNED; let $diff_tables = test.t, test.ti; source include/diff_tables.inc; DROP TABLE ti; DROP TABLE t; CREATE TABLE t (a INT UNSIGNED); INSERT INTO t VALUES ( 0 ); INSERT INTO t VALUES ( 1 ); INSERT INTO t VALUES ( 4294967295 ); CREATE TABLE ti LIKE t; ALTER TABLE ti ENGINE=myisam; INSERT INTO ti SELECT * from t; ALTER TABLE ti CHANGE COLUMN a a BIGINT UNSIGNED; ALTER TABLE t CHANGE COLUMN a a BIGINT UNSIGNED; let $diff_tables = test.t, test.ti; source include/diff_tables.inc; DROP TABLE ti; DROP TABLE t; CREATE TABLE t (a BIGINT UNSIGNED); --replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ --error ER_UNSUPPORTED_EXTENSION ALTER TABLE t CHANGE COLUMN a a TINYINT UNSIGNED; DROP TABLE t; CREATE TABLE t (a BIGINT UNSIGNED); --replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ --error ER_UNSUPPORTED_EXTENSION ALTER TABLE t CHANGE COLUMN a a SMALLINT UNSIGNED; DROP TABLE t; CREATE TABLE t (a BIGINT UNSIGNED); --replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ --error ER_UNSUPPORTED_EXTENSION ALTER TABLE t CHANGE COLUMN a a MEDIUMINT UNSIGNED; DROP TABLE t; CREATE TABLE t (a BIGINT UNSIGNED); --replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ --error ER_UNSUPPORTED_EXTENSION ALTER TABLE t CHANGE COLUMN a a INT UNSIGNED; DROP TABLE t; CREATE TABLE t (a BIGINT UNSIGNED); INSERT INTO t VALUES ( 0 ); INSERT INTO t VALUES ( 1 ); INSERT INTO t VALUES ( 18446744073709551615 ); CREATE TABLE ti LIKE t; ALTER TABLE ti ENGINE=myisam; INSERT INTO ti SELECT * from t; ALTER TABLE ti CHANGE COLUMN a a BIGINT UNSIGNED; ALTER TABLE t CHANGE COLUMN a a BIGINT UNSIGNED; let $diff_tables = test.t, test.ti; source include/diff_tables.inc; DROP TABLE ti; DROP TABLE t;