EVOLUTION-MANAGER

Edit File: change_column_blob.result

DROP TABLE IF EXISTS t; SET SESSION DEFAULT_STORAGE_ENGINE="TokuDB"; SET SESSION TOKUDB_DISABLE_SLOW_ALTER=1; CREATE TABLE t (a TINYBLOB NULL); ALTER TABLE t CHANGE COLUMN a a TINYTEXT NULL; ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version ALTER TABLE t CHANGE COLUMN a a TINYBLOB NULL; DROP TABLE t; CREATE TABLE t (a TINYBLOB NULL); ALTER TABLE t CHANGE COLUMN a a TINYTEXT NOT NULL; ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version ALTER TABLE t CHANGE COLUMN a a TINYBLOB NOT NULL; ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version DROP TABLE t; CREATE TABLE t (a TINYBLOB NOT NULL); ALTER TABLE t CHANGE COLUMN a a TINYTEXT NULL; ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version ALTER TABLE t CHANGE COLUMN a a TINYBLOB NULL; ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version DROP TABLE t; CREATE TABLE t (a TINYBLOB NOT NULL); ALTER TABLE t CHANGE COLUMN a a TINYTEXT NOT NULL; ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version ALTER TABLE t CHANGE COLUMN a a TINYBLOB NOT NULL; DROP TABLE t; CREATE TABLE t (a TINYBLOB NULL); ALTER TABLE t CHANGE COLUMN a a TEXT NULL; ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version ALTER TABLE t CHANGE COLUMN a a BLOB NULL; DROP TABLE t; CREATE TABLE t (a TINYBLOB NULL); ALTER TABLE t CHANGE COLUMN a a TEXT NOT NULL; ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version ALTER TABLE t CHANGE COLUMN a a BLOB NOT NULL; ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version DROP TABLE t; CREATE TABLE t (a TINYBLOB NOT NULL); ALTER TABLE t CHANGE COLUMN a a TEXT NULL; ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version ALTER TABLE t CHANGE COLUMN a a BLOB NULL; ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version DROP TABLE t; CREATE TABLE t (a TINYBLOB NOT NULL); ALTER TABLE t CHANGE COLUMN a a TEXT NOT NULL; ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version ALTER TABLE t CHANGE COLUMN a a BLOB NOT NULL; DROP TABLE t; CREATE TABLE t (a TINYBLOB NULL); ALTER TABLE t CHANGE COLUMN a a MEDIUMTEXT NULL; ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version ALTER TABLE t CHANGE COLUMN a a MEDIUMBLOB NULL; DROP TABLE t; CREATE TABLE t (a TINYBLOB NULL); ALTER TABLE t CHANGE COLUMN a a MEDIUMTEXT NOT NULL; ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version ALTER TABLE t CHANGE COLUMN a a MEDIUMBLOB NOT NULL; ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version DROP TABLE t; CREATE TABLE t (a TINYBLOB NOT NULL); ALTER TABLE t CHANGE COLUMN a a MEDIUMTEXT NULL; ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version ALTER TABLE t CHANGE COLUMN a a MEDIUMBLOB NULL; ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version DROP TABLE t; CREATE TABLE t (a TINYBLOB NOT NULL); ALTER TABLE t CHANGE COLUMN a a MEDIUMTEXT NOT NULL; ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version ALTER TABLE t CHANGE COLUMN a a MEDIUMBLOB NOT NULL; DROP TABLE t; CREATE TABLE t (a TINYBLOB NULL); ALTER TABLE t CHANGE COLUMN a a LONGTEXT NULL; ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version ALTER TABLE t CHANGE COLUMN a a LONGBLOB NULL; DROP TABLE t; CREATE TABLE t (a TINYBLOB NULL); ALTER TABLE t CHANGE COLUMN a a LONGTEXT NOT NULL; ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version ALTER TABLE t CHANGE COLUMN a a LONGBLOB NOT NULL; ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version DROP TABLE t; CREATE TABLE t (a TINYBLOB NOT NULL); ALTER TABLE t CHANGE COLUMN a a LONGTEXT NULL; ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version ALTER TABLE t CHANGE COLUMN a a LONGBLOB NULL; ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version DROP TABLE t; CREATE TABLE t (a TINYBLOB NOT NULL); ALTER TABLE t CHANGE COLUMN a a LONGTEXT NOT NULL; ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version ALTER TABLE t CHANGE COLUMN a a LONGBLOB NOT NULL; DROP TABLE t; CREATE TABLE t (a BLOB NULL); ALTER TABLE t CHANGE COLUMN a a TINYTEXT NULL; ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version ALTER TABLE t CHANGE COLUMN a a TINYBLOB NULL; ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version DROP TABLE t; CREATE TABLE t (a BLOB NULL); ALTER TABLE t CHANGE COLUMN a a TINYTEXT NOT NULL; ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version ALTER TABLE t CHANGE COLUMN a a TINYBLOB NOT NULL; ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version DROP TABLE t; CREATE TABLE t (a BLOB NOT NULL); ALTER TABLE t CHANGE COLUMN a a TINYTEXT NULL; ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version ALTER TABLE t CHANGE COLUMN a a TINYBLOB NULL; ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version DROP TABLE t; CREATE TABLE t (a BLOB NOT NULL); ALTER TABLE t CHANGE COLUMN a a TINYTEXT NOT NULL; ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version ALTER TABLE t CHANGE COLUMN a a TINYBLOB NOT NULL; ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version DROP TABLE t; CREATE TABLE t (a BLOB NULL); ALTER TABLE t CHANGE COLUMN a a TEXT NULL; ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version ALTER TABLE t CHANGE COLUMN a a BLOB NULL; DROP TABLE t; CREATE TABLE t (a BLOB NULL); ALTER TABLE t CHANGE COLUMN a a TEXT NOT NULL; ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version ALTER TABLE t CHANGE COLUMN a a BLOB NOT NULL; ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version DROP TABLE t; CREATE TABLE t (a BLOB NOT NULL); ALTER TABLE t CHANGE COLUMN a a TEXT NULL; ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version ALTER TABLE t CHANGE COLUMN a a BLOB NULL; ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version DROP TABLE t; CREATE TABLE t (a BLOB NOT NULL); ALTER TABLE t CHANGE COLUMN a a TEXT NOT NULL; ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version ALTER TABLE t CHANGE COLUMN a a BLOB NOT NULL; DROP TABLE t; CREATE TABLE t (a BLOB NULL); ALTER TABLE t CHANGE COLUMN a a MEDIUMTEXT NULL; ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version ALTER TABLE t CHANGE COLUMN a a MEDIUMBLOB NULL; DROP TABLE t; CREATE TABLE t (a BLOB NULL); ALTER TABLE t CHANGE COLUMN a a MEDIUMTEXT NOT NULL; ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version ALTER TABLE t CHANGE COLUMN a a MEDIUMBLOB NOT NULL; ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version DROP TABLE t; CREATE TABLE t (a BLOB NOT NULL); ALTER TABLE t CHANGE COLUMN a a MEDIUMTEXT NULL; ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version ALTER TABLE t CHANGE COLUMN a a MEDIUMBLOB NULL; ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version DROP TABLE t; CREATE TABLE t (a BLOB NOT NULL); ALTER TABLE t CHANGE COLUMN a a MEDIUMTEXT NOT NULL; ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version ALTER TABLE t CHANGE COLUMN a a MEDIUMBLOB NOT NULL; DROP TABLE t; CREATE TABLE t (a BLOB NULL); ALTER TABLE t CHANGE COLUMN a a LONGTEXT NULL; ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version ALTER TABLE t CHANGE COLUMN a a LONGBLOB NULL; DROP TABLE t; CREATE TABLE t (a BLOB NULL); ALTER TABLE t CHANGE COLUMN a a LONGTEXT NOT NULL; ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version ALTER TABLE t CHANGE COLUMN a a LONGBLOB NOT NULL; ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version DROP TABLE t; CREATE TABLE t (a BLOB NOT NULL); ALTER TABLE t CHANGE COLUMN a a LONGTEXT NULL; ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version ALTER TABLE t CHANGE COLUMN a a LONGBLOB NULL; ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version DROP TABLE t; CREATE TABLE t (a BLOB NOT NULL); ALTER TABLE t CHANGE COLUMN a a LONGTEXT NOT NULL; ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version ALTER TABLE t CHANGE COLUMN a a LONGBLOB NOT NULL; DROP TABLE t; CREATE TABLE t (a MEDIUMBLOB NULL); ALTER TABLE t CHANGE COLUMN a a TINYTEXT NULL; ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version ALTER TABLE t CHANGE COLUMN a a TINYBLOB NULL; ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version DROP TABLE t; CREATE TABLE t (a MEDIUMBLOB NULL); ALTER TABLE t CHANGE COLUMN a a TINYTEXT NOT NULL; ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version ALTER TABLE t CHANGE COLUMN a a TINYBLOB NOT NULL; ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version DROP TABLE t; CREATE TABLE t (a MEDIUMBLOB NOT NULL); ALTER TABLE t CHANGE COLUMN a a TINYTEXT NULL; ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version ALTER TABLE t CHANGE COLUMN a a TINYBLOB NULL; ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version DROP TABLE t; CREATE TABLE t (a MEDIUMBLOB NOT NULL); ALTER TABLE t CHANGE COLUMN a a TINYTEXT NOT NULL; ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version ALTER TABLE t CHANGE COLUMN a a TINYBLOB NOT NULL; ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version DROP TABLE t; CREATE TABLE t (a MEDIUMBLOB NULL); ALTER TABLE t CHANGE COLUMN a a TEXT NULL; ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version ALTER TABLE t CHANGE COLUMN a a BLOB NULL; ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version DROP TABLE t; CREATE TABLE t (a MEDIUMBLOB NULL); ALTER TABLE t CHANGE COLUMN a a TEXT NOT NULL; ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version ALTER TABLE t CHANGE COLUMN a a BLOB NOT NULL; ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version DROP TABLE t; CREATE TABLE t (a MEDIUMBLOB NOT NULL); ALTER TABLE t CHANGE COLUMN a a TEXT NULL; ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version ALTER TABLE t CHANGE COLUMN a a BLOB NULL; ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version DROP TABLE t; CREATE TABLE t (a MEDIUMBLOB NOT NULL); ALTER TABLE t CHANGE COLUMN a a TEXT NOT NULL; ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version ALTER TABLE t CHANGE COLUMN a a BLOB NOT NULL; ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version DROP TABLE t; CREATE TABLE t (a MEDIUMBLOB NULL); ALTER TABLE t CHANGE COLUMN a a MEDIUMTEXT NULL; ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version ALTER TABLE t CHANGE COLUMN a a MEDIUMBLOB NULL; DROP TABLE t; CREATE TABLE t (a MEDIUMBLOB NULL); ALTER TABLE t CHANGE COLUMN a a MEDIUMTEXT NOT NULL; ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version ALTER TABLE t CHANGE COLUMN a a MEDIUMBLOB NOT NULL; ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version DROP TABLE t; CREATE TABLE t (a MEDIUMBLOB NOT NULL); ALTER TABLE t CHANGE COLUMN a a MEDIUMTEXT NULL; ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version ALTER TABLE t CHANGE COLUMN a a MEDIUMBLOB NULL; ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version DROP TABLE t; CREATE TABLE t (a MEDIUMBLOB NOT NULL); ALTER TABLE t CHANGE COLUMN a a MEDIUMTEXT NOT NULL; ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version ALTER TABLE t CHANGE COLUMN a a MEDIUMBLOB NOT NULL; DROP TABLE t; CREATE TABLE t (a MEDIUMBLOB NULL); ALTER TABLE t CHANGE COLUMN a a LONGTEXT NULL; ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version ALTER TABLE t CHANGE COLUMN a a LONGBLOB NULL; DROP TABLE t; CREATE TABLE t (a MEDIUMBLOB NULL); ALTER TABLE t CHANGE COLUMN a a LONGTEXT NOT NULL; ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version ALTER TABLE t CHANGE COLUMN a a LONGBLOB NOT NULL; ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version DROP TABLE t; CREATE TABLE t (a MEDIUMBLOB NOT NULL); ALTER TABLE t CHANGE COLUMN a a LONGTEXT NULL; ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version ALTER TABLE t CHANGE COLUMN a a LONGBLOB NULL; ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version DROP TABLE t; CREATE TABLE t (a MEDIUMBLOB NOT NULL); ALTER TABLE t CHANGE COLUMN a a LONGTEXT NOT NULL; ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version ALTER TABLE t CHANGE COLUMN a a LONGBLOB NOT NULL; DROP TABLE t; CREATE TABLE t (a LONGBLOB NULL); ALTER TABLE t CHANGE COLUMN a a TINYTEXT NULL; ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version ALTER TABLE t CHANGE COLUMN a a TINYBLOB NULL; ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version DROP TABLE t; CREATE TABLE t (a LONGBLOB NULL); ALTER TABLE t CHANGE COLUMN a a TINYTEXT NOT NULL; ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version ALTER TABLE t CHANGE COLUMN a a TINYBLOB NOT NULL; ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version DROP TABLE t; CREATE TABLE t (a LONGBLOB NOT NULL); ALTER TABLE t CHANGE COLUMN a a TINYTEXT NULL; ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version ALTER TABLE t CHANGE COLUMN a a TINYBLOB NULL; ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version DROP TABLE t; CREATE TABLE t (a LONGBLOB NOT NULL); ALTER TABLE t CHANGE COLUMN a a TINYTEXT NOT NULL; ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version ALTER TABLE t CHANGE COLUMN a a TINYBLOB NOT NULL; ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version DROP TABLE t; CREATE TABLE t (a LONGBLOB NULL); ALTER TABLE t CHANGE COLUMN a a TEXT NULL; ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version ALTER TABLE t CHANGE COLUMN a a BLOB NULL; ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version DROP TABLE t; CREATE TABLE t (a LONGBLOB NULL); ALTER TABLE t CHANGE COLUMN a a TEXT NOT NULL; ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version ALTER TABLE t CHANGE COLUMN a a BLOB NOT NULL; ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version DROP TABLE t; CREATE TABLE t (a LONGBLOB NOT NULL); ALTER TABLE t CHANGE COLUMN a a TEXT NULL; ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version ALTER TABLE t CHANGE COLUMN a a BLOB NULL; ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version DROP TABLE t; CREATE TABLE t (a LONGBLOB NOT NULL); ALTER TABLE t CHANGE COLUMN a a TEXT NOT NULL; ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version ALTER TABLE t CHANGE COLUMN a a BLOB NOT NULL; ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version DROP TABLE t; CREATE TABLE t (a LONGBLOB NULL); ALTER TABLE t CHANGE COLUMN a a MEDIUMTEXT NULL; ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version ALTER TABLE t CHANGE COLUMN a a MEDIUMBLOB NULL; ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version DROP TABLE t; CREATE TABLE t (a LONGBLOB NULL); ALTER TABLE t CHANGE COLUMN a a MEDIUMTEXT NOT NULL; ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version ALTER TABLE t CHANGE COLUMN a a MEDIUMBLOB NOT NULL; ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version DROP TABLE t; CREATE TABLE t (a LONGBLOB NOT NULL); ALTER TABLE t CHANGE COLUMN a a MEDIUMTEXT NULL; ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version ALTER TABLE t CHANGE COLUMN a a MEDIUMBLOB NULL; ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version DROP TABLE t; CREATE TABLE t (a LONGBLOB NOT NULL); ALTER TABLE t CHANGE COLUMN a a MEDIUMTEXT NOT NULL; ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version ALTER TABLE t CHANGE COLUMN a a MEDIUMBLOB NOT NULL; ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version DROP TABLE t; CREATE TABLE t (a LONGBLOB NULL); ALTER TABLE t CHANGE COLUMN a a LONGTEXT NULL; ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version ALTER TABLE t CHANGE COLUMN a a LONGBLOB NULL; DROP TABLE t; CREATE TABLE t (a LONGBLOB NULL); ALTER TABLE t CHANGE COLUMN a a LONGTEXT NOT NULL; ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version ALTER TABLE t CHANGE COLUMN a a LONGBLOB NOT NULL; ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version DROP TABLE t; CREATE TABLE t (a LONGBLOB NOT NULL); ALTER TABLE t CHANGE COLUMN a a LONGTEXT NULL; ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version ALTER TABLE t CHANGE COLUMN a a LONGBLOB NULL; ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version DROP TABLE t; CREATE TABLE t (a LONGBLOB NOT NULL); ALTER TABLE t CHANGE COLUMN a a LONGTEXT NOT NULL; ERROR 42000: Table 't' uses an extension that doesn't exist in this XYZ version ALTER TABLE t CHANGE COLUMN a a LONGBLOB NOT NULL; DROP TABLE t;