diff options
| author | unknown <monty@mysql.com> | 2005-05-13 23:08:29 +0300 |
|---|---|---|
| committer | unknown <monty@mysql.com> | 2005-05-13 23:08:29 +0300 |
| commit | cdd6bc9bfeb1a82e7c7cfd8880f8e014ca5d9ff8 (patch) | |
| tree | b6fa522b4fdc511f6bdce8096b9424cf6704e153 /mysql-test/t/auto_increment.test | |
| parent | 7c441dd1157c8ad525babb3fbbd43daff86a50ec (diff) | |
| download | mariadb-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/t/auto_increment.test')
| -rw-r--r-- | mysql-test/t/auto_increment.test | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/mysql-test/t/auto_increment.test b/mysql-test/t/auto_increment.test index c26983b5eec..e699415a838 100644 --- a/mysql-test/t/auto_increment.test +++ b/mysql-test/t/auto_increment.test @@ -89,3 +89,15 @@ select last_insert_id(); insert into t1 values (NULL); select * from t1; drop table t1; + +# +# BUG #10045: Problem with composite AUTO_INCREMENT + BLOB key + +CREATE TABLE t1 ( a INT AUTO_INCREMENT, b BLOB, PRIMARY KEY (a,b(10))); +INSERT INTO t1 (b) VALUES ('aaaa'); +CHECK TABLE t1; +INSERT INTO t1 (b) VALUES (''); +CHECK TABLE t1; +INSERT INTO t1 (b) VALUES ('bbbb'); +CHECK TABLE t1; +DROP TABLE IF EXISTS t1; |