summaryrefslogtreecommitdiff
path: root/mysql-test/suite/innodb_fts/t/create.test
diff options
context:
space:
mode:
authorMarko Mäkelä <marko.makela@mariadb.com>2018-12-07 15:07:09 +0200
committerMarko Mäkelä <marko.makela@mariadb.com>2018-12-07 15:07:09 +0200
commit6fb963be9dc000ef4ee3e002a01e25beb1d01e3a (patch)
tree34afe6f3ea9173a0ef494d4a92246ce55b4f46a2 /mysql-test/suite/innodb_fts/t/create.test
parenta00f8bc3ad3b04b543e2af400289f283fee5427c (diff)
parent06401b6818d4f67d3e416785749dcbb8ea3230fb (diff)
downloadmariadb-git-10.4-broken-merge.tar.gz
WIP broken merge of 10.3 into 10.410.4-broken-merge
Some conflicts in sql/sql_acl.cc were incorrectly resolved, causing various test failures. Here are some examples: main.invisible_field_grant_system main.invisible_field_grant_completely main.read_only main.sp-security main.view_grant
Diffstat (limited to 'mysql-test/suite/innodb_fts/t/create.test')
-rw-r--r--mysql-test/suite/innodb_fts/t/create.test16
1 files changed, 16 insertions, 0 deletions
diff --git a/mysql-test/suite/innodb_fts/t/create.test b/mysql-test/suite/innodb_fts/t/create.test
index fe0273af750..4e522994fcc 100644
--- a/mysql-test/suite/innodb_fts/t/create.test
+++ b/mysql-test/suite/innodb_fts/t/create.test
@@ -90,3 +90,19 @@ ENGINE=InnoDB;
# The column length should be 84 bytes (84 characters * 1 byte/character).
SELECT len,COUNT(*) FROM INFORMATION_SCHEMA.INNODB_SYS_COLUMNS where name='word' GROUP BY len;
DROP TABLE t;
+
+--echo #
+--echo # MDEV-17923 Assertion memcmp(field, field_ref_zero, 7) failed in
+--echo # trx_undo_page_report_modify upon optimizing table
+--echo # under innodb_optimize_fulltext_only
+--echo #
+
+CREATE TABLE t1 (f1 TEXT, f2 TEXT, FULLTEXT KEY (f2)) ENGINE=InnoDB;
+INSERT INTO t1 (f1) VALUES ('foo'),('bar');
+DELETE FROM t1 LIMIT 1;
+ALTER TABLE t1 ADD FULLTEXT KEY (f1);
+SET @optimize_fulltext.save= @@innodb_optimize_fulltext_only;
+SET GLOBAL innodb_optimize_fulltext_only= 1;
+OPTIMIZE TABLE t1;
+DROP TABLE t1;
+SET GLOBAL innodb_optimize_fulltext_only= @optimize_fulltext.save;