diff options
Diffstat (limited to 'storage/tokudb/mysql-test/tokudb/t/change_column_blob.test')
| -rw-r--r-- | storage/tokudb/mysql-test/tokudb/t/change_column_blob.test | 480 |
1 files changed, 480 insertions, 0 deletions
diff --git a/storage/tokudb/mysql-test/tokudb/t/change_column_blob.test b/storage/tokudb/mysql-test/tokudb/t/change_column_blob.test new file mode 100644 index 00000000000..585c943766f --- /dev/null +++ b/storage/tokudb/mysql-test/tokudb/t/change_column_blob.test @@ -0,0 +1,480 @@ +source include/have_tokudb.inc; +# this test is generated by change_blob.py +# generate hot blob expansion test cases +--disable_warnings +DROP TABLE IF EXISTS t; +--enable_warnings +SET SESSION DEFAULT_STORAGE_ENGINE="TokuDB"; +SET SESSION TOKUDB_DISABLE_SLOW_ALTER=1; +CREATE TABLE t (a TINYBLOB NULL); +--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ +--error ER_UNSUPPORTED_EXTENSION +ALTER TABLE t CHANGE COLUMN a a TINYTEXT NULL; +ALTER TABLE t CHANGE COLUMN a a TINYBLOB NULL; +DROP TABLE t; +CREATE TABLE t (a TINYBLOB NULL); +--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ +--error ER_UNSUPPORTED_EXTENSION +ALTER TABLE t CHANGE COLUMN a a TINYTEXT NOT NULL; +--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ +--error ER_UNSUPPORTED_EXTENSION +ALTER TABLE t CHANGE COLUMN a a TINYBLOB NOT NULL; +DROP TABLE t; +CREATE TABLE t (a TINYBLOB NOT NULL); +--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ +--error ER_UNSUPPORTED_EXTENSION +ALTER TABLE t CHANGE COLUMN a a TINYTEXT NULL; +--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ +--error ER_UNSUPPORTED_EXTENSION +ALTER TABLE t CHANGE COLUMN a a TINYBLOB NULL; +DROP TABLE t; +CREATE TABLE t (a TINYBLOB NOT NULL); +--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ +--error ER_UNSUPPORTED_EXTENSION +ALTER TABLE t CHANGE COLUMN a a TINYTEXT NOT NULL; +ALTER TABLE t CHANGE COLUMN a a TINYBLOB NOT NULL; +DROP TABLE t; +CREATE TABLE t (a TINYBLOB NULL); +--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ +--error ER_UNSUPPORTED_EXTENSION +ALTER TABLE t CHANGE COLUMN a a TEXT NULL; +ALTER TABLE t CHANGE COLUMN a a BLOB NULL; +DROP TABLE t; +CREATE TABLE t (a TINYBLOB NULL); +--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ +--error ER_UNSUPPORTED_EXTENSION +ALTER TABLE t CHANGE COLUMN a a TEXT NOT NULL; +--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ +--error ER_UNSUPPORTED_EXTENSION +ALTER TABLE t CHANGE COLUMN a a BLOB NOT NULL; +DROP TABLE t; +CREATE TABLE t (a TINYBLOB NOT NULL); +--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ +--error ER_UNSUPPORTED_EXTENSION +ALTER TABLE t CHANGE COLUMN a a TEXT NULL; +--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ +--error ER_UNSUPPORTED_EXTENSION +ALTER TABLE t CHANGE COLUMN a a BLOB NULL; +DROP TABLE t; +CREATE TABLE t (a TINYBLOB NOT NULL); +--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ +--error ER_UNSUPPORTED_EXTENSION +ALTER TABLE t CHANGE COLUMN a a TEXT NOT NULL; +ALTER TABLE t CHANGE COLUMN a a BLOB NOT NULL; +DROP TABLE t; +CREATE TABLE t (a TINYBLOB NULL); +--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ +--error ER_UNSUPPORTED_EXTENSION +ALTER TABLE t CHANGE COLUMN a a MEDIUMTEXT NULL; +ALTER TABLE t CHANGE COLUMN a a MEDIUMBLOB NULL; +DROP TABLE t; +CREATE TABLE t (a TINYBLOB NULL); +--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ +--error ER_UNSUPPORTED_EXTENSION +ALTER TABLE t CHANGE COLUMN a a MEDIUMTEXT NOT NULL; +--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ +--error ER_UNSUPPORTED_EXTENSION +ALTER TABLE t CHANGE COLUMN a a MEDIUMBLOB NOT NULL; +DROP TABLE t; +CREATE TABLE t (a TINYBLOB NOT NULL); +--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ +--error ER_UNSUPPORTED_EXTENSION +ALTER TABLE t CHANGE COLUMN a a MEDIUMTEXT NULL; +--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ +--error ER_UNSUPPORTED_EXTENSION +ALTER TABLE t CHANGE COLUMN a a MEDIUMBLOB NULL; +DROP TABLE t; +CREATE TABLE t (a TINYBLOB NOT NULL); +--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ +--error ER_UNSUPPORTED_EXTENSION +ALTER TABLE t CHANGE COLUMN a a MEDIUMTEXT NOT NULL; +ALTER TABLE t CHANGE COLUMN a a MEDIUMBLOB NOT NULL; +DROP TABLE t; +CREATE TABLE t (a TINYBLOB NULL); +--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ +--error ER_UNSUPPORTED_EXTENSION +ALTER TABLE t CHANGE COLUMN a a LONGTEXT NULL; +ALTER TABLE t CHANGE COLUMN a a LONGBLOB NULL; +DROP TABLE t; +CREATE TABLE t (a TINYBLOB NULL); +--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ +--error ER_UNSUPPORTED_EXTENSION +ALTER TABLE t CHANGE COLUMN a a LONGTEXT NOT NULL; +--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ +--error ER_UNSUPPORTED_EXTENSION +ALTER TABLE t CHANGE COLUMN a a LONGBLOB NOT NULL; +DROP TABLE t; +CREATE TABLE t (a TINYBLOB NOT NULL); +--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ +--error ER_UNSUPPORTED_EXTENSION +ALTER TABLE t CHANGE COLUMN a a LONGTEXT NULL; +--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ +--error ER_UNSUPPORTED_EXTENSION +ALTER TABLE t CHANGE COLUMN a a LONGBLOB NULL; +DROP TABLE t; +CREATE TABLE t (a TINYBLOB NOT NULL); +--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ +--error ER_UNSUPPORTED_EXTENSION +ALTER TABLE t CHANGE COLUMN a a LONGTEXT NOT NULL; +ALTER TABLE t CHANGE COLUMN a a LONGBLOB NOT NULL; +DROP TABLE t; +CREATE TABLE t (a BLOB NULL); +--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ +--error ER_UNSUPPORTED_EXTENSION +ALTER TABLE t CHANGE COLUMN a a TINYTEXT NULL; +--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ +--error ER_UNSUPPORTED_EXTENSION +ALTER TABLE t CHANGE COLUMN a a TINYBLOB NULL; +DROP TABLE t; +CREATE TABLE t (a BLOB NULL); +--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ +--error ER_UNSUPPORTED_EXTENSION +ALTER TABLE t CHANGE COLUMN a a TINYTEXT NOT NULL; +--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ +--error ER_UNSUPPORTED_EXTENSION +ALTER TABLE t CHANGE COLUMN a a TINYBLOB NOT NULL; +DROP TABLE t; +CREATE TABLE t (a BLOB NOT NULL); +--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ +--error ER_UNSUPPORTED_EXTENSION +ALTER TABLE t CHANGE COLUMN a a TINYTEXT NULL; +--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ +--error ER_UNSUPPORTED_EXTENSION +ALTER TABLE t CHANGE COLUMN a a TINYBLOB NULL; +DROP TABLE t; +CREATE TABLE t (a BLOB NOT NULL); +--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ +--error ER_UNSUPPORTED_EXTENSION +ALTER TABLE t CHANGE COLUMN a a TINYTEXT NOT NULL; +--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ +--error ER_UNSUPPORTED_EXTENSION +ALTER TABLE t CHANGE COLUMN a a TINYBLOB NOT NULL; +DROP TABLE t; +CREATE TABLE t (a BLOB NULL); +--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ +--error ER_UNSUPPORTED_EXTENSION +ALTER TABLE t CHANGE COLUMN a a TEXT NULL; +ALTER TABLE t CHANGE COLUMN a a BLOB NULL; +DROP TABLE t; +CREATE TABLE t (a BLOB NULL); +--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ +--error ER_UNSUPPORTED_EXTENSION +ALTER TABLE t CHANGE COLUMN a a TEXT NOT NULL; +--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ +--error ER_UNSUPPORTED_EXTENSION +ALTER TABLE t CHANGE COLUMN a a BLOB NOT NULL; +DROP TABLE t; +CREATE TABLE t (a BLOB NOT NULL); +--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ +--error ER_UNSUPPORTED_EXTENSION +ALTER TABLE t CHANGE COLUMN a a TEXT NULL; +--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ +--error ER_UNSUPPORTED_EXTENSION +ALTER TABLE t CHANGE COLUMN a a BLOB NULL; +DROP TABLE t; +CREATE TABLE t (a BLOB NOT NULL); +--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ +--error ER_UNSUPPORTED_EXTENSION +ALTER TABLE t CHANGE COLUMN a a TEXT NOT NULL; +ALTER TABLE t CHANGE COLUMN a a BLOB NOT NULL; +DROP TABLE t; +CREATE TABLE t (a BLOB NULL); +--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ +--error ER_UNSUPPORTED_EXTENSION +ALTER TABLE t CHANGE COLUMN a a MEDIUMTEXT NULL; +ALTER TABLE t CHANGE COLUMN a a MEDIUMBLOB NULL; +DROP TABLE t; +CREATE TABLE t (a BLOB NULL); +--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ +--error ER_UNSUPPORTED_EXTENSION +ALTER TABLE t CHANGE COLUMN a a MEDIUMTEXT NOT NULL; +--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ +--error ER_UNSUPPORTED_EXTENSION +ALTER TABLE t CHANGE COLUMN a a MEDIUMBLOB NOT NULL; +DROP TABLE t; +CREATE TABLE t (a BLOB NOT NULL); +--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ +--error ER_UNSUPPORTED_EXTENSION +ALTER TABLE t CHANGE COLUMN a a MEDIUMTEXT NULL; +--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ +--error ER_UNSUPPORTED_EXTENSION +ALTER TABLE t CHANGE COLUMN a a MEDIUMBLOB NULL; +DROP TABLE t; +CREATE TABLE t (a BLOB NOT NULL); +--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ +--error ER_UNSUPPORTED_EXTENSION +ALTER TABLE t CHANGE COLUMN a a MEDIUMTEXT NOT NULL; +ALTER TABLE t CHANGE COLUMN a a MEDIUMBLOB NOT NULL; +DROP TABLE t; +CREATE TABLE t (a BLOB NULL); +--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ +--error ER_UNSUPPORTED_EXTENSION +ALTER TABLE t CHANGE COLUMN a a LONGTEXT NULL; +ALTER TABLE t CHANGE COLUMN a a LONGBLOB NULL; +DROP TABLE t; +CREATE TABLE t (a BLOB NULL); +--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ +--error ER_UNSUPPORTED_EXTENSION +ALTER TABLE t CHANGE COLUMN a a LONGTEXT NOT NULL; +--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ +--error ER_UNSUPPORTED_EXTENSION +ALTER TABLE t CHANGE COLUMN a a LONGBLOB NOT NULL; +DROP TABLE t; +CREATE TABLE t (a BLOB NOT NULL); +--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ +--error ER_UNSUPPORTED_EXTENSION +ALTER TABLE t CHANGE COLUMN a a LONGTEXT NULL; +--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ +--error ER_UNSUPPORTED_EXTENSION +ALTER TABLE t CHANGE COLUMN a a LONGBLOB NULL; +DROP TABLE t; +CREATE TABLE t (a BLOB NOT NULL); +--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ +--error ER_UNSUPPORTED_EXTENSION +ALTER TABLE t CHANGE COLUMN a a LONGTEXT NOT NULL; +ALTER TABLE t CHANGE COLUMN a a LONGBLOB NOT NULL; +DROP TABLE t; +CREATE TABLE t (a MEDIUMBLOB NULL); +--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ +--error ER_UNSUPPORTED_EXTENSION +ALTER TABLE t CHANGE COLUMN a a TINYTEXT NULL; +--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ +--error ER_UNSUPPORTED_EXTENSION +ALTER TABLE t CHANGE COLUMN a a TINYBLOB NULL; +DROP TABLE t; +CREATE TABLE t (a MEDIUMBLOB NULL); +--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ +--error ER_UNSUPPORTED_EXTENSION +ALTER TABLE t CHANGE COLUMN a a TINYTEXT NOT NULL; +--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ +--error ER_UNSUPPORTED_EXTENSION +ALTER TABLE t CHANGE COLUMN a a TINYBLOB NOT NULL; +DROP TABLE t; +CREATE TABLE t (a MEDIUMBLOB NOT NULL); +--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ +--error ER_UNSUPPORTED_EXTENSION +ALTER TABLE t CHANGE COLUMN a a TINYTEXT NULL; +--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ +--error ER_UNSUPPORTED_EXTENSION +ALTER TABLE t CHANGE COLUMN a a TINYBLOB NULL; +DROP TABLE t; +CREATE TABLE t (a MEDIUMBLOB NOT NULL); +--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ +--error ER_UNSUPPORTED_EXTENSION +ALTER TABLE t CHANGE COLUMN a a TINYTEXT NOT NULL; +--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ +--error ER_UNSUPPORTED_EXTENSION +ALTER TABLE t CHANGE COLUMN a a TINYBLOB NOT NULL; +DROP TABLE t; +CREATE TABLE t (a MEDIUMBLOB NULL); +--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ +--error ER_UNSUPPORTED_EXTENSION +ALTER TABLE t CHANGE COLUMN a a TEXT NULL; +--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ +--error ER_UNSUPPORTED_EXTENSION +ALTER TABLE t CHANGE COLUMN a a BLOB NULL; +DROP TABLE t; +CREATE TABLE t (a MEDIUMBLOB NULL); +--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ +--error ER_UNSUPPORTED_EXTENSION +ALTER TABLE t CHANGE COLUMN a a TEXT NOT NULL; +--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ +--error ER_UNSUPPORTED_EXTENSION +ALTER TABLE t CHANGE COLUMN a a BLOB NOT NULL; +DROP TABLE t; +CREATE TABLE t (a MEDIUMBLOB NOT NULL); +--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ +--error ER_UNSUPPORTED_EXTENSION +ALTER TABLE t CHANGE COLUMN a a TEXT NULL; +--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ +--error ER_UNSUPPORTED_EXTENSION +ALTER TABLE t CHANGE COLUMN a a BLOB NULL; +DROP TABLE t; +CREATE TABLE t (a MEDIUMBLOB NOT NULL); +--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ +--error ER_UNSUPPORTED_EXTENSION +ALTER TABLE t CHANGE COLUMN a a TEXT NOT NULL; +--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ +--error ER_UNSUPPORTED_EXTENSION +ALTER TABLE t CHANGE COLUMN a a BLOB NOT NULL; +DROP TABLE t; +CREATE TABLE t (a MEDIUMBLOB NULL); +--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ +--error ER_UNSUPPORTED_EXTENSION +ALTER TABLE t CHANGE COLUMN a a MEDIUMTEXT NULL; +ALTER TABLE t CHANGE COLUMN a a MEDIUMBLOB NULL; +DROP TABLE t; +CREATE TABLE t (a MEDIUMBLOB NULL); +--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ +--error ER_UNSUPPORTED_EXTENSION +ALTER TABLE t CHANGE COLUMN a a MEDIUMTEXT NOT NULL; +--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ +--error ER_UNSUPPORTED_EXTENSION +ALTER TABLE t CHANGE COLUMN a a MEDIUMBLOB NOT NULL; +DROP TABLE t; +CREATE TABLE t (a MEDIUMBLOB NOT NULL); +--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ +--error ER_UNSUPPORTED_EXTENSION +ALTER TABLE t CHANGE COLUMN a a MEDIUMTEXT NULL; +--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ +--error ER_UNSUPPORTED_EXTENSION +ALTER TABLE t CHANGE COLUMN a a MEDIUMBLOB NULL; +DROP TABLE t; +CREATE TABLE t (a MEDIUMBLOB NOT NULL); +--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ +--error ER_UNSUPPORTED_EXTENSION +ALTER TABLE t CHANGE COLUMN a a MEDIUMTEXT NOT NULL; +ALTER TABLE t CHANGE COLUMN a a MEDIUMBLOB NOT NULL; +DROP TABLE t; +CREATE TABLE t (a MEDIUMBLOB NULL); +--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ +--error ER_UNSUPPORTED_EXTENSION +ALTER TABLE t CHANGE COLUMN a a LONGTEXT NULL; +ALTER TABLE t CHANGE COLUMN a a LONGBLOB NULL; +DROP TABLE t; +CREATE TABLE t (a MEDIUMBLOB NULL); +--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ +--error ER_UNSUPPORTED_EXTENSION +ALTER TABLE t CHANGE COLUMN a a LONGTEXT NOT NULL; +--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ +--error ER_UNSUPPORTED_EXTENSION +ALTER TABLE t CHANGE COLUMN a a LONGBLOB NOT NULL; +DROP TABLE t; +CREATE TABLE t (a MEDIUMBLOB NOT NULL); +--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ +--error ER_UNSUPPORTED_EXTENSION +ALTER TABLE t CHANGE COLUMN a a LONGTEXT NULL; +--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ +--error ER_UNSUPPORTED_EXTENSION +ALTER TABLE t CHANGE COLUMN a a LONGBLOB NULL; +DROP TABLE t; +CREATE TABLE t (a MEDIUMBLOB NOT NULL); +--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ +--error ER_UNSUPPORTED_EXTENSION +ALTER TABLE t CHANGE COLUMN a a LONGTEXT NOT NULL; +ALTER TABLE t CHANGE COLUMN a a LONGBLOB NOT NULL; +DROP TABLE t; +CREATE TABLE t (a LONGBLOB NULL); +--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ +--error ER_UNSUPPORTED_EXTENSION +ALTER TABLE t CHANGE COLUMN a a TINYTEXT NULL; +--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ +--error ER_UNSUPPORTED_EXTENSION +ALTER TABLE t CHANGE COLUMN a a TINYBLOB NULL; +DROP TABLE t; +CREATE TABLE t (a LONGBLOB NULL); +--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ +--error ER_UNSUPPORTED_EXTENSION +ALTER TABLE t CHANGE COLUMN a a TINYTEXT NOT NULL; +--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ +--error ER_UNSUPPORTED_EXTENSION +ALTER TABLE t CHANGE COLUMN a a TINYBLOB NOT NULL; +DROP TABLE t; +CREATE TABLE t (a LONGBLOB NOT NULL); +--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ +--error ER_UNSUPPORTED_EXTENSION +ALTER TABLE t CHANGE COLUMN a a TINYTEXT NULL; +--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ +--error ER_UNSUPPORTED_EXTENSION +ALTER TABLE t CHANGE COLUMN a a TINYBLOB NULL; +DROP TABLE t; +CREATE TABLE t (a LONGBLOB NOT NULL); +--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ +--error ER_UNSUPPORTED_EXTENSION +ALTER TABLE t CHANGE COLUMN a a TINYTEXT NOT NULL; +--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ +--error ER_UNSUPPORTED_EXTENSION +ALTER TABLE t CHANGE COLUMN a a TINYBLOB NOT NULL; +DROP TABLE t; +CREATE TABLE t (a LONGBLOB NULL); +--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ +--error ER_UNSUPPORTED_EXTENSION +ALTER TABLE t CHANGE COLUMN a a TEXT NULL; +--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ +--error ER_UNSUPPORTED_EXTENSION +ALTER TABLE t CHANGE COLUMN a a BLOB NULL; +DROP TABLE t; +CREATE TABLE t (a LONGBLOB NULL); +--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ +--error ER_UNSUPPORTED_EXTENSION +ALTER TABLE t CHANGE COLUMN a a TEXT NOT NULL; +--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ +--error ER_UNSUPPORTED_EXTENSION +ALTER TABLE t CHANGE COLUMN a a BLOB NOT NULL; +DROP TABLE t; +CREATE TABLE t (a LONGBLOB NOT NULL); +--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ +--error ER_UNSUPPORTED_EXTENSION +ALTER TABLE t CHANGE COLUMN a a TEXT NULL; +--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ +--error ER_UNSUPPORTED_EXTENSION +ALTER TABLE t CHANGE COLUMN a a BLOB NULL; +DROP TABLE t; +CREATE TABLE t (a LONGBLOB NOT NULL); +--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ +--error ER_UNSUPPORTED_EXTENSION +ALTER TABLE t CHANGE COLUMN a a TEXT NOT NULL; +--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ +--error ER_UNSUPPORTED_EXTENSION +ALTER TABLE t CHANGE COLUMN a a BLOB NOT NULL; +DROP TABLE t; +CREATE TABLE t (a LONGBLOB NULL); +--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ +--error ER_UNSUPPORTED_EXTENSION +ALTER TABLE t CHANGE COLUMN a a MEDIUMTEXT NULL; +--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ +--error ER_UNSUPPORTED_EXTENSION +ALTER TABLE t CHANGE COLUMN a a MEDIUMBLOB NULL; +DROP TABLE t; +CREATE TABLE t (a LONGBLOB NULL); +--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ +--error ER_UNSUPPORTED_EXTENSION +ALTER TABLE t CHANGE COLUMN a a MEDIUMTEXT NOT NULL; +--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ +--error ER_UNSUPPORTED_EXTENSION +ALTER TABLE t CHANGE COLUMN a a MEDIUMBLOB NOT NULL; +DROP TABLE t; +CREATE TABLE t (a LONGBLOB NOT NULL); +--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ +--error ER_UNSUPPORTED_EXTENSION +ALTER TABLE t CHANGE COLUMN a a MEDIUMTEXT NULL; +--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ +--error ER_UNSUPPORTED_EXTENSION +ALTER TABLE t CHANGE COLUMN a a MEDIUMBLOB NULL; +DROP TABLE t; +CREATE TABLE t (a LONGBLOB NOT NULL); +--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ +--error ER_UNSUPPORTED_EXTENSION +ALTER TABLE t CHANGE COLUMN a a MEDIUMTEXT NOT NULL; +--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ +--error ER_UNSUPPORTED_EXTENSION +ALTER TABLE t CHANGE COLUMN a a MEDIUMBLOB NOT NULL; +DROP TABLE t; +CREATE TABLE t (a LONGBLOB NULL); +--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ +--error ER_UNSUPPORTED_EXTENSION +ALTER TABLE t CHANGE COLUMN a a LONGTEXT NULL; +ALTER TABLE t CHANGE COLUMN a a LONGBLOB NULL; +DROP TABLE t; +CREATE TABLE t (a LONGBLOB NULL); +--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ +--error ER_UNSUPPORTED_EXTENSION +ALTER TABLE t CHANGE COLUMN a a LONGTEXT NOT NULL; +--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ +--error ER_UNSUPPORTED_EXTENSION +ALTER TABLE t CHANGE COLUMN a a LONGBLOB NOT NULL; +DROP TABLE t; +CREATE TABLE t (a LONGBLOB NOT NULL); +--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ +--error ER_UNSUPPORTED_EXTENSION +ALTER TABLE t CHANGE COLUMN a a LONGTEXT NULL; +--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ +--error ER_UNSUPPORTED_EXTENSION +ALTER TABLE t CHANGE COLUMN a a LONGBLOB NULL; +DROP TABLE t; +CREATE TABLE t (a LONGBLOB NOT NULL); +--replace_regex /MariaDB/XYZ/ /MySQL/XYZ/ +--error ER_UNSUPPORTED_EXTENSION +ALTER TABLE t CHANGE COLUMN a a LONGTEXT NOT NULL; +ALTER TABLE t CHANGE COLUMN a a LONGBLOB NOT NULL; +DROP TABLE t; |