summaryrefslogtreecommitdiff
path: root/mysql-test/suite/innodb_fts
diff options
context:
space:
mode:
authorMarko Mäkelä <marko.makela@mariadb.com>2018-09-11 21:31:47 +0300
committerMarko Mäkelä <marko.makela@mariadb.com>2018-09-11 21:31:47 +0300
commit67fa97dc2c44f974bb26bba8a0efa3bb409e6bc5 (patch)
tree5bbb79933755b9c8b8ea79af304e7d196f64e809 /mysql-test/suite/innodb_fts
parent1bf3e8ab43e982953d7534db902020d321364afb (diff)
parent6b61f1bbad1a57509d1cd0c09e80e31fffcfc67d (diff)
downloadmariadb-git-67fa97dc2c44f974bb26bba8a0efa3bb409e6bc5.tar.gz
Merge 10.3 into 10.4
Diffstat (limited to 'mysql-test/suite/innodb_fts')
-rw-r--r--mysql-test/suite/innodb_fts/r/truncate.result31
-rw-r--r--mysql-test/suite/innodb_fts/t/truncate.opt1
-rw-r--r--mysql-test/suite/innodb_fts/t/truncate.test50
3 files changed, 0 insertions, 82 deletions
diff --git a/mysql-test/suite/innodb_fts/r/truncate.result b/mysql-test/suite/innodb_fts/r/truncate.result
deleted file mode 100644
index 0e21717a4d3..00000000000
--- a/mysql-test/suite/innodb_fts/r/truncate.result
+++ /dev/null
@@ -1,31 +0,0 @@
-#
-# Bug#25053705 - INVALID I/O ON TABLE AFTER TRUNCATE
-#
-CREATE TABLE t1 (a INT, d INT, b VARCHAR(198), c CHAR(158), FULLTEXT fts1(c,b),
-FULLTEXT fts2(c));
-TRUNCATE TABLE t1;
-INSERT INTO t1 (a,d,b,c) VALUES (
-'79795','6',repeat('uololoaroolccaaruolraloouuoocorrcorurlu','1'),
-repeat('orouculcaocuocloooolooloooaorlroclouulrrucclulalouaulrluorooaclllluuorc
-cuullucocraloracurooulrooauuar','1'));
-CREATE TABLE t2 (a INT, d INT, b VARCHAR(198), c CHAR(158), FULLTEXT fts1(c,b));
-INSERT INTO t2 VALUES (1, 1, repeat('uololoaroolccaaruolraloouuoocorrcorurlu','1'),
-repeat('orouculcaocuocloooolooloooaorlroclouulrrucclulalouaulrluorooaclllluuorccuullucocraloracurooulrooauuar','1'));
-create procedure insert_t2(IN total int)
-begin
-declare i int default 1;
-while (i <= total) DO
-insert into t2 select * from t2;
-set i = i + 1;
-end while;
-end|
-CALL insert_t2(15);
-SET @save_dbug = @@SESSION.DEBUG_DBUG;
-SET DEBUG_DBUG = '+d,innodb_invalid_read_after_truncate';
-INSERT INTO t1 (a,d,b,c) VALUES (
-'7795','6',repeat('uololoaroolccaaruolraloouuoocorrcorurlu','1'),
-repeat('orouculcaocuocloooolooloooaorlroclouulrrucclulalouaulrluorooaclllluuorc
-cuullucocraloracurooulrooauuar','1'));
-SET DEBUG_DBUG = @save_dbug;
-DROP PROCEDURE insert_t2;
-DROP TABLE t1,t2;
diff --git a/mysql-test/suite/innodb_fts/t/truncate.opt b/mysql-test/suite/innodb_fts/t/truncate.opt
deleted file mode 100644
index d143088d352..00000000000
--- a/mysql-test/suite/innodb_fts/t/truncate.opt
+++ /dev/null
@@ -1 +0,0 @@
---innodb-random-read-ahead=1
diff --git a/mysql-test/suite/innodb_fts/t/truncate.test b/mysql-test/suite/innodb_fts/t/truncate.test
deleted file mode 100644
index 46ba732b019..00000000000
--- a/mysql-test/suite/innodb_fts/t/truncate.test
+++ /dev/null
@@ -1,50 +0,0 @@
---source include/have_innodb.inc
---source include/have_debug.inc
-
---echo #
---echo # Bug#25053705 - INVALID I/O ON TABLE AFTER TRUNCATE
---echo #
-
-CREATE TABLE t1 (a INT, d INT, b VARCHAR(198), c CHAR(158), FULLTEXT fts1(c,b),
-FULLTEXT fts2(c));
-
-TRUNCATE TABLE t1;
-
-INSERT INTO t1 (a,d,b,c) VALUES (
-'79795','6',repeat('uololoaroolccaaruolraloouuoocorrcorurlu','1'),
-repeat('orouculcaocuocloooolooloooaorlroclouulrrucclulalouaulrluorooaclllluuorc
-cuullucocraloracurooulrooauuar','1'));
-
-# The following CREATE TABLE and INSERTs are used to remove the pages related to table t1
-# from the buffer pool.
-CREATE TABLE t2 (a INT, d INT, b VARCHAR(198), c CHAR(158), FULLTEXT fts1(c,b));
-
-INSERT INTO t2 VALUES (1, 1, repeat('uololoaroolccaaruolraloouuoocorrcorurlu','1'),
-repeat('orouculcaocuocloooolooloooaorlroclouulrrucclulalouaulrluorooaclllluuorccuullucocraloracurooulrooauuar','1'));
-
-delimiter |;
-create procedure insert_t2(IN total int)
-begin
- declare i int default 1;
- while (i <= total) DO
- insert into t2 select * from t2;
- set i = i + 1;
- end while;
-end|
-delimiter ;|
-
-CALL insert_t2(15);
-
-SET @save_dbug = @@SESSION.DEBUG_DBUG;
-SET DEBUG_DBUG = '+d,innodb_invalid_read_after_truncate';
-
-INSERT INTO t1 (a,d,b,c) VALUES (
-'7795','6',repeat('uololoaroolccaaruolraloouuoocorrcorurlu','1'),
-repeat('orouculcaocuocloooolooloooaorlroclouulrrucclulalouaulrluorooaclllluuorc
-cuullucocraloracurooulrooauuar','1'));
-
-SET DEBUG_DBUG = @save_dbug;
-
-DROP PROCEDURE insert_t2;
-
-DROP TABLE t1,t2;