summaryrefslogtreecommitdiff
path: root/storage/tokudb/mysql-test/tokudb_add_index/r/falcon_bug_23818_2.result
diff options
context:
space:
mode:
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.result21
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;