summaryrefslogtreecommitdiff
path: root/mysql-test/r/auto_increment.result
diff options
context:
space:
mode:
authorunknown <monty@mysql.com>2005-05-13 23:08:29 +0300
committerunknown <monty@mysql.com>2005-05-13 23:08:29 +0300
commitcdd6bc9bfeb1a82e7c7cfd8880f8e014ca5d9ff8 (patch)
treeb6fa522b4fdc511f6bdce8096b9424cf6704e153 /mysql-test/r/auto_increment.result
parent7c441dd1157c8ad525babb3fbbd43daff86a50ec (diff)
downloadmariadb-git-cdd6bc9bfeb1a82e7c7cfd8880f8e014ca5d9ff8.tar.gz
Fixed wrong buffer usage for auto-increment key with blob part that caused CHECK TABLE to report that the table was wrong. (Bug #10045)
myisam/mi_key.c: Fixed wrong buffer usage for auto-increment key with blob part that caused CHECK TABLE to report that the table was wrong. (Bug #10045) mysql-test/r/auto_increment.result: New test case mysql-test/t/auto_increment.test: New test case
Diffstat (limited to 'mysql-test/r/auto_increment.result')
-rw-r--r--mysql-test/r/auto_increment.result14
1 files changed, 14 insertions, 0 deletions
diff --git a/mysql-test/r/auto_increment.result b/mysql-test/r/auto_increment.result
index 2d6b058d9c5..9345c029127 100644
--- a/mysql-test/r/auto_increment.result
+++ b/mysql-test/r/auto_increment.result
@@ -131,3 +131,17 @@ a
1
2
drop table t1;
+CREATE TABLE t1 ( a INT AUTO_INCREMENT, b BLOB, PRIMARY KEY (a,b(10)));
+INSERT INTO t1 (b) VALUES ('aaaa');
+CHECK TABLE t1;
+Table Op Msg_type Msg_text
+test.t1 check status OK
+INSERT INTO t1 (b) VALUES ('');
+CHECK TABLE t1;
+Table Op Msg_type Msg_text
+test.t1 check status OK
+INSERT INTO t1 (b) VALUES ('bbbb');
+CHECK TABLE t1;
+Table Op Msg_type Msg_text
+test.t1 check status OK
+DROP TABLE IF EXISTS t1;