diff options
Diffstat (limited to 'mysql-test/main/column_compression.test')
| -rw-r--r-- | mysql-test/main/column_compression.test | 29 |
1 files changed, 29 insertions, 0 deletions
diff --git a/mysql-test/main/column_compression.test b/mysql-test/main/column_compression.test index c9d0014ab9e..183fc38151c 100644 --- a/mysql-test/main/column_compression.test +++ b/mysql-test/main/column_compression.test @@ -181,3 +181,32 @@ SHOW CREATE TABLE t1; SELECT COLUMN_TYPE FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA='test' AND TABLE_NAME='t1'; DROP TABLE t1; + +--echo # +--echo # End of 10.3 tests +--echo # + + +--echo # +--echo # Start of 10.5 tests +--echo # + +--echo # +--echo # MDEV-19727 Add Type_handler::Key_part_spec_init_ft +--echo # + +# +# Indexes on COMPRESSED columns are generally prohibited, so we don't have +# to override Type_handler_xxx_compressed::Key_part_spec_init_ft(). +# Note, we could support FULLTEXT indexes on compressed columns eventually. +# + +--error ER_COMPRESSED_COLUMN_USED_AS_KEY +CREATE TABLE t1 (a VARCHAR(1000) COMPRESSED, FULLTEXT INDEX(a)); + +--error ER_COMPRESSED_COLUMN_USED_AS_KEY +CREATE TABLE t1 (a TEXT COMPRESSED, FULLTEXT INDEX(a)); + +--echo # +--echo # End of 10.5 tests +--echo # |