EVOLUTION-MANAGER

Edit File: change_column_text_data.result

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;