diff options
author | Marko Mäkelä <marko.makela@mariadb.com> | 2018-09-11 21:31:47 +0300 |
---|---|---|
committer | Marko Mäkelä <marko.makela@mariadb.com> | 2018-09-11 21:31:47 +0300 |
commit | 67fa97dc2c44f974bb26bba8a0efa3bb409e6bc5 (patch) | |
tree | 5bbb79933755b9c8b8ea79af304e7d196f64e809 /mysql-test/suite/innodb_fts | |
parent | 1bf3e8ab43e982953d7534db902020d321364afb (diff) | |
parent | 6b61f1bbad1a57509d1cd0c09e80e31fffcfc67d (diff) | |
download | mariadb-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.result | 31 | ||||
-rw-r--r-- | mysql-test/suite/innodb_fts/t/truncate.opt | 1 | ||||
-rw-r--r-- | mysql-test/suite/innodb_fts/t/truncate.test | 50 |
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; |