diff options
Diffstat (limited to 'storage/tokudb/mysql-test/tokudb_add_index/r/falcon_bug_23818_2.result')
-rw-r--r-- | storage/tokudb/mysql-test/tokudb_add_index/r/falcon_bug_23818_2.result | 21 |
1 files changed, 21 insertions, 0 deletions
diff --git a/storage/tokudb/mysql-test/tokudb_add_index/r/falcon_bug_23818_2.result b/storage/tokudb/mysql-test/tokudb_add_index/r/falcon_bug_23818_2.result new file mode 100644 index 00000000000..f935df7fb21 --- /dev/null +++ b/storage/tokudb/mysql-test/tokudb_add_index/r/falcon_bug_23818_2.result @@ -0,0 +1,21 @@ +SET @@DEFAULT_STORAGE_ENGINE = tokudb; +*** Bug #23818_II *** +DROP TABLE IF EXISTS t1; +DROP PROCEDURE IF EXISTS p1; +CREATE TABLE t1 (a int, b varchar(1100) character set latin1, c varchar(10000)); +INSERT INTO t1 VALUES (null,null,null),(1,'',''),(2,'a','a'); +CREATE INDEX i1 ON t1 (b); +CREATE PROCEDURE p1 () +BEGIN +declare v int default 0; +while v < 1000 do +SET @x = concat('update t1 set a = ', v,', b = repeat(0x', hex(rand()*255),',rand()*999), c = repeat(0x', hex(rand()*255), ',rand()*9999)'); +/* select v,@x; */ +PREPARE stmt1 FROM @x; +EXECUTE stmt1; +SET v = v + 1; +END while; +END// +CALL p1()// +DROP TABLE t1; +DROP PROCEDURE p1; |