DROP TABLE IF EXISTS t, ti;
SET SESSION DEFAULT_STORAGE_ENGINE="TokuDB";
SET SESSION TOKUDB_DISABLE_SLOW_ALTER=1;
CREATE TABLE t (a TINYTEXT , b TINYTEXT );
INSERT INTO t (a, b) VALUES ('8WPikf','NncLFE7');
INSERT INTO t (a, b) VALUES ('b5u4x0oGQ','x6RJHM6SPsczuiSMneMy23veyjvsPjHCqNfokW2AsiSZBVE3mp7NA5wf0UAwhWd4dwn4nc11P5RLTpTT4o4Wwdf8h0JJ6qQV99ns6LEeLJ5ZI');
INSERT INTO t (a, b) VALUES ('ObPOoXqFyK9PjPwXUp1iXjEcEPvW0DIO','GDWDp3EQNTrnvSM3Sely8IKdaZsMCxBkUcUZvBKpxou5U30Eipxfc3CjHIYGaRwWPG8DAwZROrT9Nf7hsDMCOg01lcPBXlEDZgm1lRBzRhTSwXMIzbDOSp2EpdT12HZ3PYsVXk0ZSYG9');
CREATE TABLE ti LIKE t;
ALTER TABLE ti ENGINE=myisam;
INSERT INTO ti SELECT * FROM t;
ALTER TABLE t CHANGE COLUMN a a TINYTEXT ;
ALTER TABLE ti CHANGE COLUMN a a TINYTEXT ;
ALTER TABLE t CHANGE COLUMN a a TEXT ;
ALTER TABLE ti CHANGE COLUMN a a TEXT ;
ALTER TABLE t CHANGE COLUMN a a MEDIUMTEXT ;
ALTER TABLE ti CHANGE COLUMN a a MEDIUMTEXT ;
ALTER TABLE t CHANGE COLUMN a a LONGTEXT ;
ALTER TABLE ti CHANGE COLUMN a a LONGTEXT ;
ALTER TABLE t CHANGE COLUMN b b TINYTEXT ;
ALTER TABLE ti CHANGE COLUMN b b TINYTEXT ;
ALTER TABLE t CHANGE COLUMN b b TEXT ;
ALTER TABLE ti CHANGE COLUMN b b TEXT ;
ALTER TABLE t CHANGE COLUMN b b MEDIUMTEXT ;
ALTER TABLE ti CHANGE COLUMN b b MEDIUMTEXT ;
ALTER TABLE t CHANGE COLUMN b b LONGTEXT ;
ALTER TABLE ti CHANGE COLUMN b b LONGTEXT ;
include/diff_tables.inc [test.t, test.ti]
DROP TABLE t, ti;
CREATE TABLE t (a TINYTEXT NOT NULL, b TINYTEXT NOT NULL);
INSERT INTO t (a, b) VALUES ('T3V0h0kB7Z43jqSTiaI','czB9GVLA611e55NpukvYdrc4UOTWiIFEfvtvXcTMbn8TFqhie2D3gRzU5AjZoxtSSMMMcsWl0wnsoWtK2tfGQCRgayc9pv0t4NRCFwlH2Un3cpiiQdW59gYphjYXlE1q5ABTuPPv32nb0Ws5deOTxIc11qWPfYnHeuZ91SG94wXYxQLKAqMx1EHaUssU8N6cz8JKrJTVvp5cA4nbGgFLZKOEvqFuHq1mgcaFm71NvcOui2BaVRfUbl64shd');
INSERT INTO t (a, b) VALUES ('8q5sLEUIhKJ0BNIaZpOUfV243Rpc9','1MLR6uDgHb6svgtcsukdEx9GV6DTmSo3bnVgf2aIbQD0d77p1H0PzzWEX7IW2j6JhKymA59w8s3aEjH5Ta3CSVw5ks0yezu5woSjcxDslNVUs4L8YR8ckJWL11YvkZuWepkxwTMzYgujdJOZLNOX9rgqRFk5JabNZ9QePdbTjbthHQ1SXsdK6');
INSERT INTO t (a, b) VALUES ('OuS6FKVN8GvFSetNwujNG6Z4jv3bNrfS','8VZPpTjiHG0wwu1YuCm4GkaSiIyQMBHzI806VRXXi1VqL50IeFFoRQUeYunmRotO46Iyv3i8syseHo2zP2TzHFdueH');
CREATE TABLE ti LIKE t;
ALTER TABLE ti ENGINE=myisam;
INSERT INTO ti SELECT * FROM t;
ALTER TABLE t CHANGE COLUMN a a TINYTEXT NOT NULL;
ALTER TABLE ti CHANGE COLUMN a a TINYTEXT NOT NULL;
ALTER TABLE t CHANGE COLUMN a a TEXT NOT NULL;
ALTER TABLE ti CHANGE COLUMN a a TEXT NOT NULL;
ALTER TABLE t CHANGE COLUMN a a MEDIUMTEXT NOT NULL;
ALTER TABLE ti CHANGE COLUMN a a MEDIUMTEXT NOT NULL;
ALTER TABLE t CHANGE COLUMN a a LONGTEXT NOT NULL;
ALTER TABLE ti CHANGE COLUMN a a LONGTEXT NOT NULL;
ALTER TABLE t CHANGE COLUMN b b TINYTEXT NOT NULL;
ALTER TABLE ti CHANGE COLUMN b b TINYTEXT NOT NULL;
ALTER TABLE t CHANGE COLUMN b b TEXT NOT NULL;
ALTER TABLE ti CHANGE COLUMN b b TEXT NOT NULL;
ALTER TABLE t CHANGE COLUMN b b MEDIUMTEXT NOT NULL;
ALTER TABLE ti CHANGE COLUMN b b MEDIUMTEXT NOT NULL;
ALTER TABLE t CHANGE COLUMN b b LONGTEXT NOT NULL;
ALTER TABLE ti CHANGE COLUMN b b LONGTEXT NOT NULL;
include/diff_tables.inc [test.t, test.ti]
DROP TABLE t, ti;
CREATE TABLE t (v VARCHAR(32) DEFAULT '', a TINYTEXT , b TINYTEXT );
INSERT INTO t (a, b) VALUES ('1pR3ukt4Ue1ddcv7l7cdLUtIvUrc','3KWeNropDQVN59sEvm1JNuyNGawl467fqCbpsyxZi9SsxJ8D0WLw6TdCCs2E7TOwtSD5g5rvVFelfdMCe59d9jJ06jpriiPl');
INSERT INTO t (a, b) VALUES ('ijiiau1MlZKqMXrw','WLZn5o7znhPvNfzfszV41k0YDE0Sb0MDV79qrdp3d');
INSERT INTO t (a, b) VALUES ('qmty3prkW0culdhbxFQ','WblIKvRYbVjNyKbpCbft2hDCLuPjmFTzz2lZg9VUklZ1bWQ4OpSCGDZuZ5q0LeBzVrqkO91P0puZECeuUX6jfTyBR7piwkR77yyaMfK7Vm9435Qswmknye6h7zo');
CREATE TABLE ti LIKE t;
ALTER TABLE ti ENGINE=myisam;
INSERT INTO ti SELECT * FROM t;
ALTER TABLE t CHANGE COLUMN a a TINYTEXT ;
ALTER TABLE ti CHANGE COLUMN a a TINYTEXT ;
ALTER TABLE t CHANGE COLUMN a a TEXT ;
ALTER TABLE ti CHANGE COLUMN a a TEXT ;
ALTER TABLE t CHANGE COLUMN a a MEDIUMTEXT ;
ALTER TABLE ti CHANGE COLUMN a a MEDIUMTEXT ;
ALTER TABLE t CHANGE COLUMN a a LONGTEXT ;
ALTER TABLE ti CHANGE COLUMN a a LONGTEXT ;
ALTER TABLE t CHANGE COLUMN b b TINYTEXT ;
ALTER TABLE ti CHANGE COLUMN b b TINYTEXT ;
ALTER TABLE t CHANGE COLUMN b b TEXT ;
ALTER TABLE ti CHANGE COLUMN b b TEXT ;
ALTER TABLE t CHANGE COLUMN b b MEDIUMTEXT ;
ALTER TABLE ti CHANGE COLUMN b b MEDIUMTEXT ;
ALTER TABLE t CHANGE COLUMN b b LONGTEXT ;
ALTER TABLE ti CHANGE COLUMN b b LONGTEXT ;
include/diff_tables.inc [test.t, test.ti]
DROP TABLE t, ti;
CREATE TABLE t (v VARCHAR(32) DEFAULT '', a TINYTEXT NOT NULL, b TINYTEXT NOT NULL);
INSERT INTO t (a, b) VALUES ('ZCcIgA','TgeHsGJbqV0cK6PHoJXwkuk3KeExgjHUouDUAHtuyIrkkegjoIkgZk8Ue77o3Rb4bLsf674Xs0OuzlXFOcaSqU');
INSERT INTO t (a, b) VALUES ('ZdomEveQpjAySuPD3PO3xgGsZ82U','2iF9na7SSX8ORsRIzJ41RPC0chuPNa1BmL5QJfAX5OZJqhQ0SEB3MxDkZTmlc21F10A7nhqug9Y9Dei4B7Sg5AHvVa1AUUiUBDIk5pJ51rixI8iF3gTfp9drR9JKDQLVzCEtyROSCeHIjFT8bInB6i24c9kSUE4JkLrvA1wEPuN5Pxnu9kOscnn6PGJLIthj8J1z9ghydfn1H8meLLgV6hMdfN');
INSERT INTO t (a, b) VALUES ('4wf92gh8AJAyUPIPDQYR47xk','bl9CVOgsrrEAjEC4UZgeDHy17IqbI6LQha5ec0t5igrw8RBf84rmgr');
CREATE TABLE ti LIKE t;
ALTER TABLE ti ENGINE=myisam;
INSERT INTO ti SELECT * FROM t;
ALTER TABLE t CHANGE COLUMN a a TINYTEXT NOT NULL;
ALTER TABLE ti CHANGE COLUMN a a TINYTEXT NOT NULL;
ALTER TABLE t CHANGE COLUMN a a TEXT NOT NULL;
ALTER TABLE ti CHANGE COLUMN a a TEXT NOT NULL;
ALTER TABLE t CHANGE COLUMN a a MEDIUMTEXT NOT NULL;
ALTER TABLE ti CHANGE COLUMN a a MEDIUMTEXT NOT NULL;
ALTER TABLE t CHANGE COLUMN a a LONGTEXT NOT NULL;
ALTER TABLE ti CHANGE COLUMN a a LONGTEXT NOT NULL;
ALTER TABLE t CHANGE COLUMN b b TINYTEXT NOT NULL;
ALTER TABLE ti CHANGE COLUMN b b TINYTEXT NOT NULL;
ALTER TABLE t CHANGE COLUMN b b TEXT NOT NULL;
ALTER TABLE ti CHANGE COLUMN b b TEXT NOT NULL;
ALTER TABLE t CHANGE COLUMN b b MEDIUMTEXT NOT NULL;
ALTER TABLE ti CHANGE COLUMN b b MEDIUMTEXT NOT NULL;
ALTER TABLE t CHANGE COLUMN b b LONGTEXT NOT NULL;
ALTER TABLE ti CHANGE COLUMN b b LONGTEXT NOT NULL;
include/diff_tables.inc [test.t, test.ti]
DROP TABLE t, ti;
CREATE TABLE t (v VARCHAR(32) DEFAULT '' NOT NULL, a TINYTEXT , b TINYTEXT );
INSERT INTO t (a, b) VALUES ('4','8COJIsoEwzuFuY0XobeNMr1uhHotDoFksHC4sKkv3MLMI0Rm1XHKUKkEfnFYeog0y1qbkhyM5OhUhczN4uUH2rwA3BZb00rHLE5cxCFsQqGr3RlAX4uDGshnxozQfi7DL3IlRqYjwy0ItkISRHGYwPpW3CuC3cMSOidb48kt1cqqzy7XWtA93KNpBJhcYxAyPO1on5U5N4fgOl0JOZRvzxR5m5yma378hXl3C5W');
INSERT INTO t (a, b) VALUES ('dGzO9u7KQt3XM2ZkwHRRQkt','eQzl1IBr7VSdb1fgb8xKREQVgXVxhkCtdNpQstvAdPYMipmmgZTtheuiOwnYjSc');
INSERT INTO t (a, b) VALUES ('P1bQAeV4','bf4KDOM79ZLUg5qJd0zchNwdAm6v2AbOd');
CREATE TABLE ti LIKE t;
ALTER TABLE ti ENGINE=myisam;
INSERT INTO ti SELECT * FROM t;
ALTER TABLE t CHANGE COLUMN a a TINYTEXT ;
ALTER TABLE ti CHANGE COLUMN a a TINYTEXT ;
ALTER TABLE t CHANGE COLUMN a a TEXT ;
ALTER TABLE ti CHANGE COLUMN a a TEXT ;
ALTER TABLE t CHANGE COLUMN a a MEDIUMTEXT ;
ALTER TABLE ti CHANGE COLUMN a a MEDIUMTEXT ;
ALTER TABLE t CHANGE COLUMN a a LONGTEXT ;
ALTER TABLE ti CHANGE COLUMN a a LONGTEXT ;
ALTER TABLE t CHANGE COLUMN b b TINYTEXT ;
ALTER TABLE ti CHANGE COLUMN b b TINYTEXT ;
ALTER TABLE t CHANGE COLUMN b b TEXT ;
ALTER TABLE ti CHANGE COLUMN b b TEXT ;
ALTER TABLE t CHANGE COLUMN b b MEDIUMTEXT ;
ALTER TABLE ti CHANGE COLUMN b b MEDIUMTEXT ;
ALTER TABLE t CHANGE COLUMN b b LONGTEXT ;
ALTER TABLE ti CHANGE COLUMN b b LONGTEXT ;
include/diff_tables.inc [test.t, test.ti]
DROP TABLE t, ti;
CREATE TABLE t (v VARCHAR(32) DEFAULT '' NOT NULL, a TINYTEXT NOT NULL, b TINYTEXT NOT NULL);
INSERT INTO t (a, b) VALUES ('zhUb9Hu5Wlv2kL3j9w','C4AQe2AZNlGu8CVuqp7Cygd1bF9pm7W6dBTdd6tAfe6Ac1GscSl');
INSERT INTO t (a, b) VALUES ('jimRpHhtrsTxQ2TW99uPgPtLp51Xam7w','cFZ7PbSsyswGd5YmgsK6v0A0TkZwzzAQAy5hrRjFl6ik88GJxoeRNqjUsrKowaKjZPw5ae3LuRFNgBlobkWT60Qm9Wh4PGjTVsEdssmt2Q0vAVpw9WPxsb9aDA9Il7ya5cchLPAivle7bk8Y5lBL8Q7Vc90JrJ0ueClS1ag');
INSERT INTO t (a, b) VALUES ('zo7kaZFbvZW9XpHmq5bBY9dwRn5','6HjHkuaHhufqwPrEONNEZSdJTKVFC2egT4vA1SK4BV81knPBmVDmIrosYgMAEpl0fLtnsROepeggWvqblGbNhjbzU8cDZZ5284nTRUXbZG2T1kLhNcMwJu00JdU9PpLQuEWw7dAbR5vcHGnTsttJwLW80ko1tdPycGMYeguqiCefW4yBEn');
CREATE TABLE ti LIKE t;
ALTER TABLE ti ENGINE=myisam;
INSERT INTO ti SELECT * FROM t;
ALTER TABLE t CHANGE COLUMN a a TINYTEXT NOT NULL;
ALTER TABLE ti CHANGE COLUMN a a TINYTEXT NOT NULL;
ALTER TABLE t CHANGE COLUMN a a TEXT NOT NULL;
ALTER TABLE ti CHANGE COLUMN a a TEXT NOT NULL;
ALTER TABLE t CHANGE COLUMN a a MEDIUMTEXT NOT NULL;
ALTER TABLE ti CHANGE COLUMN a a MEDIUMTEXT NOT NULL;
ALTER TABLE t CHANGE COLUMN a a LONGTEXT NOT NULL;
ALTER TABLE ti CHANGE COLUMN a a LONGTEXT NOT NULL;
ALTER TABLE t CHANGE COLUMN b b TINYTEXT NOT NULL;
ALTER TABLE ti CHANGE COLUMN b b TINYTEXT NOT NULL;
ALTER TABLE t CHANGE COLUMN b b TEXT NOT NULL;
ALTER TABLE ti CHANGE COLUMN b b TEXT NOT NULL;
ALTER TABLE t CHANGE COLUMN b b MEDIUMTEXT NOT NULL;
ALTER TABLE ti CHANGE COLUMN b b MEDIUMTEXT NOT NULL;
ALTER TABLE t CHANGE COLUMN b b LONGTEXT NOT NULL;
ALTER TABLE ti CHANGE COLUMN b b LONGTEXT NOT NULL;
include/diff_tables.inc [test.t, test.ti]
DROP TABLE t, ti;
CREATE TABLE t (f INT DEFAULT 0, a TINYTEXT , b TINYTEXT );
INSERT INTO t (a, b) VALUES ('WdaEkmCiDOrvN5RGfjGGD17','Rv7pU4m11NDa2H2mE89d6ztify9OAlmPs');
INSERT INTO t (a, b) VALUES ('bXfE3gz','j7TeWw2dIoiw0Z1VjwWpJ82dao3TS6zuiMARW2rEPYecSP1FsMRpCB2iXn8Gt89pBreJ9jKJPEQ1OTlEY1lfvYjUbpSKYp6MsR0RbTOitJbdHPKL7BmxZj4iCGmYMBoxTqEoxBU954RXa3EOoXGpYlNbWvncVrqQhwNi71p5O9bUAR5imiRQkNkSbMEF8gWXPjZ');
INSERT INTO t (a, b) VALUES ('hS2f2J1vjF8G','GPbTuMoMkKdNqMiVkhjuBdFwnSxLLLTaM1tpp0vWNbZMJyLSI5JEJVr27UnDEqgAajCMh1TmGghnmvUD6xfYrUDRbar80bSvQtiAkfunQHibMZ8Wjao24adjeSXHGB2fSNbCGWm9AlLE0qamKoazjXhSpcrhHJZPJmEBI9yGxthevepsNVASlNlNUOLNAc1d1GkNUzXtoxN6AYgZb5Ao2');
CREATE TABLE ti LIKE t;
ALTER TABLE ti ENGINE=myisam;
INSERT INTO ti SELECT * FROM t;
ALTER TABLE t CHANGE COLUMN a a TINYTEXT ;
ALTER TABLE ti CHANGE COLUMN a a TINYTEXT ;
ALTER TABLE t CHANGE COLUMN a a TEXT ;
ALTER TABLE ti CHANGE COLUMN a a TEXT ;
ALTER TABLE t CHANGE COLUMN a a MEDIUMTEXT ;
ALTER TABLE ti CHANGE COLUMN a a MEDIUMTEXT ;
ALTER TABLE t CHANGE COLUMN a a LONGTEXT ;
ALTER TABLE ti CHANGE COLUMN a a LONGTEXT ;
ALTER TABLE t CHANGE COLUMN b b TINYTEXT ;
ALTER TABLE ti CHANGE COLUMN b b TINYTEXT ;
ALTER TABLE t CHANGE COLUMN b b TEXT ;
ALTER TABLE ti CHANGE COLUMN b b TEXT ;
ALTER TABLE t CHANGE COLUMN b b MEDIUMTEXT ;
ALTER TABLE ti CHANGE COLUMN b b MEDIUMTEXT ;
ALTER TABLE t CHANGE COLUMN b b LONGTEXT ;
ALTER TABLE ti CHANGE COLUMN b b LONGTEXT ;
include/diff_tables.inc [test.t, test.ti]
DROP TABLE t, ti;
CREATE TABLE t (f INT DEFAULT 0, a TINYTEXT NOT NULL, b TINYTEXT NOT NULL);
INSERT INTO t (a, b) VALUES ('2ajs1f82ZmqPhqXBpaH','N8Xvw6uv9i7oZJZ');
INSERT INTO t (a, b) VALUES ('0av8oRjJwXqtBhMVMcUw','Y95YaQZc7Td');
INSERT INTO t (a, b) VALUES ('MI5GfQLpDFr75U3rz','RTd6Lve0ZNbBe1fqkWK4j7SKbxJpeyvkdNllf0Y1gu9uVs21W6LB23A8Uhx3K7rFHDJUAl01RpCDAhLFDvAAD66UOtNv8fCw0c1cjlbel');
CREATE TABLE ti LIKE t;
ALTER TABLE ti ENGINE=myisam;
INSERT INTO ti SELECT * FROM t;
ALTER TABLE t CHANGE COLUMN a a TINYTEXT NOT NULL;
ALTER TABLE ti CHANGE COLUMN a a TINYTEXT NOT NULL;
ALTER TABLE t CHANGE COLUMN a a TEXT NOT NULL;
ALTER TABLE ti CHANGE COLUMN a a TEXT NOT NULL;
ALTER TABLE t CHANGE COLUMN a a MEDIUMTEXT NOT NULL;
ALTER TABLE ti CHANGE COLUMN a a MEDIUMTEXT NOT NULL;
ALTER TABLE t CHANGE COLUMN a a LONGTEXT NOT NULL;
ALTER TABLE ti CHANGE COLUMN a a LONGTEXT NOT NULL;
ALTER TABLE t CHANGE COLUMN b b TINYTEXT NOT NULL;
ALTER TABLE ti CHANGE COLUMN b b TINYTEXT NOT NULL;
ALTER TABLE t CHANGE COLUMN b b TEXT NOT NULL;
ALTER TABLE ti CHANGE COLUMN b b TEXT NOT NULL;
ALTER TABLE t CHANGE COLUMN b b MEDIUMTEXT NOT NULL;
ALTER TABLE ti CHANGE COLUMN b b MEDIUMTEXT NOT NULL;
ALTER TABLE t CHANGE COLUMN b b LONGTEXT NOT NULL;
ALTER TABLE ti CHANGE COLUMN b b LONGTEXT NOT NULL;
include/diff_tables.inc [test.t, test.ti]
DROP TABLE t, ti;
CREATE TABLE t (f INT DEFAULT 0, v VARCHAR(32) DEFAULT '', a TINYTEXT , b TINYTEXT );
INSERT INTO t (a, b) VALUES ('EznArw','vo6j2j3be9KBIlTHlP4bUwWKoZhbVrl6y8utY7cLGtoAMNy7xQSUjbQk7q1eWkzqjhbNqxWcROhC3YNQpizFk8rKTX9cCMuiGrDVBaVnHEaIQ5xhOrao1RDIYctYYn');
INSERT INTO t (a, b) VALUES ('d9gNCvqIg4MO2iMp','2XKg4Jwh0TjwQGHo4jlYKKQxiL6qUbFdIyvYKNGUseZoW0HVTX2mqJ4lAIgzOWK83miQgQ2D3WyA3cNXmUl5h72AQsdHGaYmYWrQCX8AFZy1EWCuPocm0K2uSOLvB');
INSERT INTO t (a, b) VALUES ('9','BWWKSYPaVdjrRK');
CREATE TABLE ti LIKE t;
ALTER TABLE ti ENGINE=myisam;
INSERT INTO ti SELECT * FROM t;
ALTER TABLE t CHANGE COLUMN a a TINYTEXT ;
ALTER TABLE ti CHANGE COLUMN a a TINYTEXT ;
ALTER TABLE t CHANGE COLUMN a a TEXT ;
ALTER TABLE ti CHANGE COLUMN a a TEXT ;
ALTER TABLE t CHANGE COLUMN a a MEDIUMTEXT ;
ALTER TABLE ti CHANGE COLUMN a a MEDIUMTEXT ;
ALTER TABLE t CHANGE COLUMN a a LONGTEXT ;
ALTER TABLE ti CHANGE COLUMN a a LONGTEXT ;
ALTER TABLE t CHANGE COLUMN b b TINYTEXT ;
ALTER TABLE ti CHANGE COLUMN b b TINYTEXT ;
ALTER TABLE t CHANGE COLUMN b b TEXT ;
ALTER TABLE ti CHANGE COLUMN b b TEXT ;
ALTER TABLE t CHANGE COLUMN b b MEDIUMTEXT ;
ALTER TABLE ti CHANGE COLUMN b b MEDIUMTEXT ;
ALTER TABLE t CHANGE COLUMN b b LONGTEXT ;
ALTER TABLE ti CHANGE COLUMN b b LONGTEXT ;
include/diff_tables.inc [test.t, test.ti]
DROP TABLE t, ti;
CREATE TABLE t (f INT DEFAULT 0, v VARCHAR(32) DEFAULT '', a TINYTEXT NOT NULL, b TINYTEXT NOT NULL);
INSERT INTO t (a, b) VALUES ('lL','MjEImtvTwSkiFTBkVCjUv7ns1KFK6e7SQucDDCrKxVF9DLGnhNP1a4nnT9ix3PfdlCn08iu9FbMV0mVCisdmGhXgXxzjohZwBGrN54fLsg7L6h5O3KMvv2XeUB6AenAmZsKa6ZpRKYJiWmq64XLLocD9vjLDnRQ1Op10YuqBe08eNi0QU8oNJuMqnCrVLbw1a8bVrX6CvTRGETBPj4BWb2nyLCIQLZ2brn');
INSERT INTO t (a, b) VALUES ('oMIeJPUVsv8QB6l70BX7yMC','Le4iLiDZtvn6FhBSvlign3Z5w0EwGr2I1q1p7jgrLzrEIcoBzOeIB1WVxoOp4ap8iTwAAelm5ceZVdvGzTT3Sd9wMkrMVW0hRw6MmEo3Fug42SPo0ZshF21Lz5F2seYEBCVt0qCZeZ5lslwWkfJaPZ6pkQMkOx2F858U1efHqDYlphj3NyvAnDHJc6lr7qDPt');
INSERT INTO t (a, b) VALUES ('zJt9LaCnNRQ','mk7xoElj1vePgkHeANO7pF9pTBYPGT0VWqoObtqyrzJ6HL8qPuL48UScNJ0E4Gg4VKs8q2N8XFv5IE');
CREATE TABLE ti LIKE t;
ALTER TABLE ti ENGINE=myisam;
INSERT INTO ti SELECT * FROM t;
ALTER TABLE t CHANGE COLUMN a a TINYTEXT NOT NULL;
ALTER TABLE ti CHANGE COLUMN a a TINYTEXT NOT NULL;
ALTER TABLE t CHANGE COLUMN a a TEXT NOT NULL;
ALTER TABLE ti CHANGE COLUMN a a TEXT NOT NULL;
ALTER TABLE t CHANGE COLUMN a a MEDIUMTEXT NOT NULL;
ALTER TABLE ti CHANGE COLUMN a a MEDIUMTEXT NOT NULL;
ALTER TABLE t CHANGE COLUMN a a LONGTEXT NOT NULL;
ALTER TABLE ti CHANGE COLUMN a a LONGTEXT NOT NULL;
ALTER TABLE t CHANGE COLUMN b b TINYTEXT NOT NULL;
ALTER TABLE ti CHANGE COLUMN b b TINYTEXT NOT NULL;
ALTER TABLE t CHANGE COLUMN b b TEXT NOT NULL;
ALTER TABLE ti CHANGE COLUMN b b TEXT NOT NULL;
ALTER TABLE t CHANGE COLUMN b b MEDIUMTEXT NOT NULL;
ALTER TABLE ti CHANGE COLUMN b b MEDIUMTEXT NOT NULL;
ALTER TABLE t CHANGE COLUMN b b LONGTEXT NOT NULL;
ALTER TABLE ti CHANGE COLUMN b b LONGTEXT NOT NULL;
include/diff_tables.inc [test.t, test.ti]
DROP TABLE t, ti;
CREATE TABLE t (f INT DEFAULT 0, v VARCHAR(32) DEFAULT '' NOT NULL, a TINYTEXT , b TINYTEXT );
INSERT INTO t (a, b) VALUES ('1N585BBQh0iEW93L','l6Rgi1dWfXEDfaibVhy8R3DvrDLuelXzLrwGW1FEQx2BgWGfzomHJfhGfzSVSqszNdifYmCyRheks');
INSERT INTO t (a, b) VALUES ('cxMQyKae772Lb9L4JI9UlKHTgaKg','pTSl4p1LPHIEaR4PjEwij');
INSERT INTO t (a, b) VALUES ('rzrD','DWqVXqVdfvcbaSwHdGejTyDcz7hfTFxI3dGAnx4kW5W9w63zywUaHJmlBLHBHYnhQdgjTfyocZoq03klA97YgFBz6DoTwmiXi5TEPjIcfLrW0m3B97CLCxXP52SO98ue31Ye3CGS520HeaQ4QhTTsZe60Th748zXpwP5w9azS4FdRE7EFptHcE9HThEVdUWqqzcLgq9oV6xaM4VZfsNoyvD1o034Y5Nk');
CREATE TABLE ti LIKE t;
ALTER TABLE ti ENGINE=myisam;
INSERT INTO ti SELECT * FROM t;
ALTER TABLE t CHANGE COLUMN a a TINYTEXT ;
ALTER TABLE ti CHANGE COLUMN a a TINYTEXT ;
ALTER TABLE t CHANGE COLUMN a a TEXT ;
ALTER TABLE ti CHANGE COLUMN a a TEXT ;
ALTER TABLE t CHANGE COLUMN a a MEDIUMTEXT ;
ALTER TABLE ti CHANGE COLUMN a a MEDIUMTEXT ;
ALTER TABLE t CHANGE COLUMN a a LONGTEXT ;
ALTER TABLE ti CHANGE COLUMN a a LONGTEXT ;
ALTER TABLE t CHANGE COLUMN b b TINYTEXT ;
ALTER TABLE ti CHANGE COLUMN b b TINYTEXT ;
ALTER TABLE t CHANGE COLUMN b b TEXT ;
ALTER TABLE ti CHANGE COLUMN b b TEXT ;
ALTER TABLE t CHANGE COLUMN b b MEDIUMTEXT ;
ALTER TABLE ti CHANGE COLUMN b b MEDIUMTEXT ;
ALTER TABLE t CHANGE COLUMN b b LONGTEXT ;
ALTER TABLE ti CHANGE COLUMN b b LONGTEXT ;
include/diff_tables.inc [test.t, test.ti]
DROP TABLE t, ti;
CREATE TABLE t (f INT DEFAULT 0, v VARCHAR(32) DEFAULT '' NOT NULL, a TINYTEXT NOT NULL, b TINYTEXT NOT NULL);
INSERT INTO t (a, b) VALUES ('HhNGpHAPWQ8','0Q5hSkbZLKKzavHJ7sZ7S9GKzds4BhnE');
INSERT INTO t (a, b) VALUES ('ml','XyUksmKLHMjoW0lpB3tcpSLTIhOP0slD62f81zkxgX38ec3gNAYOS6CwzAoQO14RYiWSogY4WF3xZDqrhYtFp5rvmILv6KWiFy1qivIYlim3LvOfmEb6hFXCjeENyAlTPmQgucWetoK96IhJo3DkPeWqI0tGKENsyKLhD1gXRghIj081Z6VA1GusGHZWSYCYH80RTGypEZtE4kDo69yQHyBCzGzTZKg');
INSERT INTO t (a, b) VALUES ('g','evftctLEjTtiV2ug5CDuqVlORXTrmfEhaiy2j3PWNgLhzDlWqp6zmzzqZUQrlJ3Z6yYOYLaxvdnYGToHsvBHlwD13DaJKPAS3hGAYIR1efumgFBkBQjVc97zcC5aaCZzL7bEpxViveWKYRAbruyH5Nid3CsaLlJEt');
CREATE TABLE ti LIKE t;
ALTER TABLE ti ENGINE=myisam;
INSERT INTO ti SELECT * FROM t;
ALTER TABLE t CHANGE COLUMN a a TINYTEXT NOT NULL;
ALTER TABLE ti CHANGE COLUMN a a TINYTEXT NOT NULL;
ALTER TABLE t CHANGE COLUMN a a TEXT NOT NULL;
ALTER TABLE ti CHANGE COLUMN a a TEXT NOT NULL;
ALTER TABLE t CHANGE COLUMN a a MEDIUMTEXT NOT NULL;
ALTER TABLE ti CHANGE COLUMN a a MEDIUMTEXT NOT NULL;
ALTER TABLE t CHANGE COLUMN a a LONGTEXT NOT NULL;
ALTER TABLE ti CHANGE COLUMN a a LONGTEXT NOT NULL;
ALTER TABLE t CHANGE COLUMN b b TINYTEXT NOT NULL;
ALTER TABLE ti CHANGE COLUMN b b TINYTEXT NOT NULL;
ALTER TABLE t CHANGE COLUMN b b TEXT NOT NULL;
ALTER TABLE ti CHANGE COLUMN b b TEXT NOT NULL;
ALTER TABLE t CHANGE COLUMN b b MEDIUMTEXT NOT NULL;
ALTER TABLE ti CHANGE COLUMN b b MEDIUMTEXT NOT NULL;
ALTER TABLE t CHANGE COLUMN b b LONGTEXT NOT NULL;
ALTER TABLE ti CHANGE COLUMN b b LONGTEXT NOT NULL;
include/diff_tables.inc [test.t, test.ti]
DROP TABLE t, ti;
CREATE TABLE t (f INT DEFAULT 0 NOT NULL, a TINYTEXT , b TINYTEXT );
INSERT INTO t (a, b) VALUES ('8P49xApofl0PNKnNcmj','DhRrz27wl2mOIoYOvZb6UCzr4u4rxwCoAFrMuM92y3hFjIu0iLUa7xUUZe1F8doEg9nBHcFo5NY4DMm0PNYKpkerTYPmIwE2gnTcCq77SgqgyeM60MdFsnO34MLEEA35Zr3MjeuJ37oGjf6vfSNUpiL0UAmhfWwfO6tLqrHtUtJhNVMvIS1pdahZJTV');
INSERT INTO t (a, b) VALUES ('FsBSfn4R7aEpUck7HhRk8w3Vt','Zrve2K');
INSERT INTO t (a, b) VALUES ('JR8yYX4uaWqC3IYfRJPOgvvz6','wzLOzhTNHY4GqRXOSWuUpYfvg5vDjL');
CREATE TABLE ti LIKE t;
ALTER TABLE ti ENGINE=myisam;
INSERT INTO ti SELECT * FROM t;
ALTER TABLE t CHANGE COLUMN a a TINYTEXT ;
ALTER TABLE ti CHANGE COLUMN a a TINYTEXT ;
ALTER TABLE t CHANGE COLUMN a a TEXT ;
ALTER TABLE ti CHANGE COLUMN a a TEXT ;
ALTER TABLE t CHANGE COLUMN a a MEDIUMTEXT ;
ALTER TABLE ti CHANGE COLUMN a a MEDIUMTEXT ;
ALTER TABLE t CHANGE COLUMN a a LONGTEXT ;
ALTER TABLE ti CHANGE COLUMN a a LONGTEXT ;
ALTER TABLE t CHANGE COLUMN b b TINYTEXT ;
ALTER TABLE ti CHANGE COLUMN b b TINYTEXT ;
ALTER TABLE t CHANGE COLUMN b b TEXT ;
ALTER TABLE ti CHANGE COLUMN b b TEXT ;
ALTER TABLE t CHANGE COLUMN b b MEDIUMTEXT ;
ALTER TABLE ti CHANGE COLUMN b b MEDIUMTEXT ;
ALTER TABLE t CHANGE COLUMN b b LONGTEXT ;
ALTER TABLE ti CHANGE COLUMN b b LONGTEXT ;
include/diff_tables.inc [test.t, test.ti]
DROP TABLE t, ti;
CREATE TABLE t (f INT DEFAULT 0 NOT NULL, a TINYTEXT NOT NULL, b TINYTEXT NOT NULL);
INSERT INTO t (a, b) VALUES ('hPDlpbufOe8shVHIYUo','W6SMefVaBzMArHmqFdw3Z9OAuZHMjfyQ');
INSERT INTO t (a, b) VALUES ('O3Z8ZebVhd5IXWs8iE9','2wrVG5FdWqidL69kmRynY2qQEKIukkauagG2iejdI1JaRs2yxwsSF2NsUnLn8VztEfEh');
INSERT INTO t (a, b) VALUES ('Vmsynq5mDAoM4IJxVziyJkMKuz','Y3qGnF35eYocIzn5F3FXEGWX1Wr1fQ6zk54n2h0B3PKYRLVerjk');
CREATE TABLE ti LIKE t;
ALTER TABLE ti ENGINE=myisam;
INSERT INTO ti SELECT * FROM t;
ALTER TABLE t CHANGE COLUMN a a TINYTEXT NOT NULL;
ALTER TABLE ti CHANGE COLUMN a a TINYTEXT NOT NULL;
ALTER TABLE t CHANGE COLUMN a a TEXT NOT NULL;
ALTER TABLE ti CHANGE COLUMN a a TEXT NOT NULL;
ALTER TABLE t CHANGE COLUMN a a MEDIUMTEXT NOT NULL;
ALTER TABLE ti CHANGE COLUMN a a MEDIUMTEXT NOT NULL;
ALTER TABLE t CHANGE COLUMN a a LONGTEXT NOT NULL;
ALTER TABLE ti CHANGE COLUMN a a LONGTEXT NOT NULL;
ALTER TABLE t CHANGE COLUMN b b TINYTEXT NOT NULL;
ALTER TABLE ti CHANGE COLUMN b b TINYTEXT NOT NULL;
ALTER TABLE t CHANGE COLUMN b b TEXT NOT NULL;
ALTER TABLE ti CHANGE COLUMN b b TEXT NOT NULL;
ALTER TABLE t CHANGE COLUMN b b MEDIUMTEXT NOT NULL;
ALTER TABLE ti CHANGE COLUMN b b MEDIUMTEXT NOT NULL;
ALTER TABLE t CHANGE COLUMN b b LONGTEXT NOT NULL;
ALTER TABLE ti CHANGE COLUMN b b LONGTEXT NOT NULL;
include/diff_tables.inc [test.t, test.ti]
DROP TABLE t, ti;
CREATE TABLE t (f INT DEFAULT 0 NOT NULL, v VARCHAR(32) DEFAULT '', a TINYTEXT , b TINYTEXT );
INSERT INTO t (a, b) VALUES ('rmCC1RZ8fu9Zq6DwO','0vLyV4LMJuHlwPG5245J5yVDuapHQWy3vqHdlTQkQGqJWcFUz0kDWL38DeyT8nQ5WLbDqGHREisps27bINC3Ew5p7Uuf4XBleBD12f6K7g59gWBnYxd6ZsYcwcphcMWq2c8bQmbwLy1fHQ2IJaCTTAjWGd4wBHcXyg5ogi9lomnebSeI1ox1HfjWI0H6GAdsHGibXcY7QPUgVOKA5BB7jrIVpj92YSW1YAbIJLSfncht4iUlSRdyA');
INSERT INTO t (a, b) VALUES ('TNRqYm8EcJq5FPYZVG','3ucsPU7FCarudjiggvea0gjmR7OhidgIqNR4oGKzuaGxNcbxoqx8MrFGARPTE4YYyJln2HJkL9t161aLwAyJfka3PVSqScYEq8qiqt7QLAOEOa8vZYzIob3He5XBQVpC4voPO9JUblGXL9jxj56M5EjhalzF3RWM2QKcAdPg7m');
INSERT INTO t (a, b) VALUES ('3a4oOgf661u4JDOTIoGBWVpJtLi7ZM','JpTFN1KqC8cgYHjIyZWnC9tETzpvMMvLCM92u0sUpKEJagqrTThSCiHPuPWiP8kH45n6dbZPedVYv1OBZ501sPzo0dPt7ykLLemlT4aTx22AxnEGpk6LYoDmMrSWJdhbq3rhVU7QqgzmwWBGDPRyNfvdc15YROPXLohUVG2taIpNfV4km8JugoBRdy5OKDzP512JOysxUxFMgSgv2nd0nJzo9AzH8BGP7EnqXmxj40JfioAmCuGQRt8kkZi6e9l20');
Warnings:
Warning	1265	Data truncated for column 'b' at row 1
CREATE TABLE ti LIKE t;
ALTER TABLE ti ENGINE=myisam;
INSERT INTO ti SELECT * FROM t;
ALTER TABLE t CHANGE COLUMN a a TINYTEXT ;
ALTER TABLE ti CHANGE COLUMN a a TINYTEXT ;
ALTER TABLE t CHANGE COLUMN a a TEXT ;
ALTER TABLE ti CHANGE COLUMN a a TEXT ;
ALTER TABLE t CHANGE COLUMN a a MEDIUMTEXT ;
ALTER TABLE ti CHANGE COLUMN a a MEDIUMTEXT ;
ALTER TABLE t CHANGE COLUMN a a LONGTEXT ;
ALTER TABLE ti CHANGE COLUMN a a LONGTEXT ;
ALTER TABLE t CHANGE COLUMN b b TINYTEXT ;
ALTER TABLE ti CHANGE COLUMN b b TINYTEXT ;
ALTER TABLE t CHANGE COLUMN b b TEXT ;
ALTER TABLE ti CHANGE COLUMN b b TEXT ;
ALTER TABLE t CHANGE COLUMN b b MEDIUMTEXT ;
ALTER TABLE ti CHANGE COLUMN b b MEDIUMTEXT ;
ALTER TABLE t CHANGE COLUMN b b LONGTEXT ;
ALTER TABLE ti CHANGE COLUMN b b LONGTEXT ;
include/diff_tables.inc [test.t, test.ti]
DROP TABLE t, ti;
CREATE TABLE t (f INT DEFAULT 0 NOT NULL, v VARCHAR(32) DEFAULT '', a TINYTEXT NOT NULL, b TINYTEXT NOT NULL);
INSERT INTO t (a, b) VALUES ('84XkENBIpBOSIA9X','LLq2mrmKvbMURprQVllY6xdk1TyqLir7dVBLIcXMsroq60cdRUdMKNHhsMReUaIovhRPz9K20MJ45FRldiEcPig0YPQpPRchf8or8X9FDk4dnLBstqPdWPRN4yKcpQQ8d');
INSERT INTO t (a, b) VALUES ('PQhihnoGkj','aWJwkEEahH8DcGLc6hDEwqoVdz7N0dS7aVqr8y2iGR08uF4iRrskP9hm17GBgU3oJwtFNCd6PgaqILMmgOaFxIKdwl6L830lHqIP8QGxgt9YOj1jnTbNC8oacra2C4RlEneP7RXUNnLiUltyOqg8iOS2AElrpsqg5AITkU5lhzEcu1OzvILTQmILr7fwOWGafQnumBLLf4FV1XEQehYYCQznGVO5AC4AqxljiVTm2VKwgHK');
INSERT INTO t (a, b) VALUES ('Wp7SRNSBTdZ5FMy','L7CJ7KHDvKZREFq0NoHwbeQv7Gp9S68J4fvTSVSOKXmB3XqleUZTUrWaB9UsXzSSv4uiUucM25pIWXIkGKY1k8FVopLD5l2rewYrWtSWiZ6kD9k4dVzR3hbBgapWc2mimRwBS4gpD2AVCrpZAI');
CREATE TABLE ti LIKE t;
ALTER TABLE ti ENGINE=myisam;
INSERT INTO ti SELECT * FROM t;
ALTER TABLE t CHANGE COLUMN a a TINYTEXT NOT NULL;
ALTER TABLE ti CHANGE COLUMN a a TINYTEXT NOT NULL;
ALTER TABLE t CHANGE COLUMN a a TEXT NOT NULL;
ALTER TABLE ti CHANGE COLUMN a a TEXT NOT NULL;
ALTER TABLE t CHANGE COLUMN a a MEDIUMTEXT NOT NULL;
ALTER TABLE ti CHANGE COLUMN a a MEDIUMTEXT NOT NULL;
ALTER TABLE t CHANGE COLUMN a a LONGTEXT NOT NULL;
ALTER TABLE ti CHANGE COLUMN a a LONGTEXT NOT NULL;
ALTER TABLE t CHANGE COLUMN b b TINYTEXT NOT NULL;
ALTER TABLE ti CHANGE COLUMN b b TINYTEXT NOT NULL;
ALTER TABLE t CHANGE COLUMN b b TEXT NOT NULL;
ALTER TABLE ti CHANGE COLUMN b b TEXT NOT NULL;
ALTER TABLE t CHANGE COLUMN b b MEDIUMTEXT NOT NULL;
ALTER TABLE ti CHANGE COLUMN b b MEDIUMTEXT NOT NULL;
ALTER TABLE t CHANGE COLUMN b b LONGTEXT NOT NULL;
ALTER TABLE ti CHANGE COLUMN b b LONGTEXT NOT NULL;
include/diff_tables.inc [test.t, test.ti]
DROP TABLE t, ti;
CREATE TABLE t (f INT DEFAULT 0 NOT NULL, v VARCHAR(32) DEFAULT '' NOT NULL, a TINYTEXT , b TINYTEXT );
INSERT INTO t (a, b) VALUES ('9jLJ0ZIO55FP61poxeO4L','qDlG0rPg6pQ7scksQFOqxTGZIaOHz90VSV78nGu0wQQzXIEBiNp4Kq7hDgs1eW5ot9uKyvz');
INSERT INTO t (a, b) VALUES ('OoVm8w69Ktnc','Qj2yRoLmXbGrTk5IP0rzJ5x7T5NnVjEISVkei0Ed5b29Fx2f2DkxWdPByyHmTZ0V60rd4z6ivkGLfiSpqoIGyOLsvuKd5zywn3tmwiBN211n4g9lol8TGqczWGMVAtcxgkzYnprghq1MfGAkmr8hzCqFcmZPkTNmTcXDhAK9Uzmhr6EUysjNHiXwMYXDqnLu7tFEmaBa5s1SFIXapUFcF');
INSERT INTO t (a, b) VALUES ('UNTOvmwoyYR3vytsxjYXIzNe3uNSZGXy','tud2Ue9TqNmenuidjnFqU3blsesSRJnZnsgW3ZxqfbM8EHWfrdmIu7LiOBgUxmQEWXmCOh1j8ycxhDfuGGtZ56RxCSk2lmHFPj3mdroOf2ftB3PHOV9Jga257NjIuR75nItrdTEseUrxnoRAfN0ZtDVAQjnA7ZjMiKh1E7kUZioBoKqdbP306aeN5bENlRZt9UJ3vE4w5nbRsJfId5');
CREATE TABLE ti LIKE t;
ALTER TABLE ti ENGINE=myisam;
INSERT INTO ti SELECT * FROM t;
ALTER TABLE t CHANGE COLUMN a a TINYTEXT ;
ALTER TABLE ti CHANGE COLUMN a a TINYTEXT ;
ALTER TABLE t CHANGE COLUMN a a TEXT ;
ALTER TABLE ti CHANGE COLUMN a a TEXT ;
ALTER TABLE t CHANGE COLUMN a a MEDIUMTEXT ;
ALTER TABLE ti CHANGE COLUMN a a MEDIUMTEXT ;
ALTER TABLE t CHANGE COLUMN a a LONGTEXT ;
ALTER TABLE ti CHANGE COLUMN a a LONGTEXT ;
ALTER TABLE t CHANGE COLUMN b b TINYTEXT ;
ALTER TABLE ti CHANGE COLUMN b b TINYTEXT ;
ALTER TABLE t CHANGE COLUMN b b TEXT ;
ALTER TABLE ti CHANGE COLUMN b b TEXT ;
ALTER TABLE t CHANGE COLUMN b b MEDIUMTEXT ;
ALTER TABLE ti CHANGE COLUMN b b MEDIUMTEXT ;
ALTER TABLE t CHANGE COLUMN b b LONGTEXT ;
ALTER TABLE ti CHANGE COLUMN b b LONGTEXT ;
include/diff_tables.inc [test.t, test.ti]
DROP TABLE t, ti;
CREATE TABLE t (f INT DEFAULT 0 NOT NULL, v VARCHAR(32) DEFAULT '' NOT NULL, a TINYTEXT NOT NULL, b TINYTEXT NOT NULL);
INSERT INTO t (a, b) VALUES ('Id','eKhtNKGQb2m0JpvyzVayefC7fAbhKzbR0wVzLCarlBdjxgEfVx4Fbm8C0uzQn9UuSsL5unnHgR2DQ9bzpbXY1ib7q5');
INSERT INTO t (a, b) VALUES ('F109GMWyA6Bo4KDr1eAoLdMbm5pAJf','6aN1H6jHsqeidqmzMLnj95JHX0nV2Xn1CNFwVYOHkLpuySrmbRUS8rzSTXTB5yuaMjr8fsSVpnakiiMBtTf5oCPue6J2VCvIn3ujshgM3YNp851bZ3pY3iaQpzLPYBFP3MHdtzJfM9kYZjn8FCYZqYEVEzvhmJb6H5Oqroue8qemeTdZOpq7cg3LWMkH6gJxUTnBv6K');
INSERT INTO t (a, b) VALUES ('TFKZn3C86JoZFMJ','w0veu9pqoguz7U0AUnbK6cN7nk0VKHVcnnNDbKKDOvjbkzQoqHaHK3Vzice2nj53vyggmMFnGM8A9CWkMggifctRCQxm1XfFf5ilzvyv7uxBlA3yo1Eozl3tL4Dt5WcDx4zvJrzG9Cs1cvHKcbYEdqipr3Tl9iEPZQLPWDMPWPhbbZHrFmdkYLTj7SV4KjW21jPCk0o2zUXh6N8Vk');
CREATE TABLE ti LIKE t;
ALTER TABLE ti ENGINE=myisam;
INSERT INTO ti SELECT * FROM t;
ALTER TABLE t CHANGE COLUMN a a TINYTEXT NOT NULL;
ALTER TABLE ti CHANGE COLUMN a a TINYTEXT NOT NULL;
ALTER TABLE t CHANGE COLUMN a a TEXT NOT NULL;
ALTER TABLE ti CHANGE COLUMN a a TEXT NOT NULL;
ALTER TABLE t CHANGE COLUMN a a MEDIUMTEXT NOT NULL;
ALTER TABLE ti CHANGE COLUMN a a MEDIUMTEXT NOT NULL;
ALTER TABLE t CHANGE COLUMN a a LONGTEXT NOT NULL;
ALTER TABLE ti CHANGE COLUMN a a LONGTEXT NOT NULL;
ALTER TABLE t CHANGE COLUMN b b TINYTEXT NOT NULL;
ALTER TABLE ti CHANGE COLUMN b b TINYTEXT NOT NULL;
ALTER TABLE t CHANGE COLUMN b b TEXT NOT NULL;
ALTER TABLE ti CHANGE COLUMN b b TEXT NOT NULL;
ALTER TABLE t CHANGE COLUMN b b MEDIUMTEXT NOT NULL;
ALTER TABLE ti CHANGE COLUMN b b MEDIUMTEXT NOT NULL;
ALTER TABLE t CHANGE COLUMN b b LONGTEXT NOT NULL;
ALTER TABLE ti CHANGE COLUMN b b LONGTEXT NOT NULL;
include/diff_tables.inc [test.t, test.ti]
DROP TABLE t, ti;