summaryrefslogtreecommitdiff
path: root/mysql-test/t/isam.test
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/t/isam.test')
-rw-r--r--mysql-test/t/isam.test19
1 files changed, 19 insertions, 0 deletions
diff --git a/mysql-test/t/isam.test b/mysql-test/t/isam.test
new file mode 100644
index 00000000000..1cf068b42ba
--- /dev/null
+++ b/mysql-test/t/isam.test
@@ -0,0 +1,19 @@
+#
+# Test possible problem with rows that are about 65535 bytes long
+#
+
+create table t1 (a tinyint not null auto_increment, b blob not null, primary key (a));
+
+let $1=100;
+while ($1)
+{
+ eval insert into t1 (b) values(repeat(char(65+$1),65540-$1));
+ dec $1;
+}
+check table t1;
+repair table t1;
+delete from t1 where (a & 1);
+check table t1;
+repair table t1;
+check table t1;
+drop table t1;