diff options
author | Sergei Golubchik <sergii@pisem.net> | 2013-09-09 13:59:38 +0200 |
---|---|---|
committer | Sergei Golubchik <sergii@pisem.net> | 2013-09-09 13:59:38 +0200 |
commit | 9a3b9a541659f9d2637614df417a39d5508abeaa (patch) | |
tree | 5df6de4ffdeae387d6610f8b8462ca292b97cd7a /storage/tokudb/mysql-test/tokudb/t/change_column_blob.test | |
parent | d29f874db18068926ee899c532b25d0c8872f5dd (diff) | |
download | mariadb-git-9a3b9a541659f9d2637614df417a39d5508abeaa.tar.gz |
tokudb test suites
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 | 503 |
1 files changed, 503 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..7139f530962 --- /dev/null +++ b/storage/tokudb/mysql-test/tokudb/t/change_column_blob.test @@ -0,0 +1,503 @@ +# 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; +--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 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; +--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 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 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; +--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 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 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; +--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 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; +--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 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; +--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 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 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; +--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 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; +--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 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; +--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 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; |