summaryrefslogtreecommitdiff
path: root/mysql-test/r/auto_increment.result
diff options
context:
space:
mode:
authormonty@mysql.com <>2005-05-14 18:31:22 +0300
committermonty@mysql.com <>2005-05-14 18:31:22 +0300
commit9db45adb608d7f4229f026cfdbbcc185f58b8c7b (patch)
treec08ee86cd9f77c3a7dc13b02b09371ccd19f2b88 /mysql-test/r/auto_increment.result
parent6b90352eacab0314ad33ef4e0d37dadb4688fd97 (diff)
parent6588997eb8218233b664fbbb32b130e832387daa (diff)
downloadmariadb-git-9db45adb608d7f4229f026cfdbbcc185f58b8c7b.tar.gz
Merge with 4.1
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 13007c30607..4587c675150 100644
--- a/mysql-test/r/auto_increment.result
+++ b/mysql-test/r/auto_increment.result
@@ -341,3 +341,17 @@ a b
2 3
3 4
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;