summaryrefslogtreecommitdiff
path: root/mysql-test/t/innodb.test
diff options
context:
space:
mode:
authorunknown <aivanov@mysql.com>2005-12-13 16:49:24 +0300
committerunknown <aivanov@mysql.com>2005-12-13 16:49:24 +0300
commitad4d8773506e1c13d39f7b89a4ce4dce63b9ad49 (patch)
tree2b49f5bf8c4bd1ae14a7c9930b7364deb447f530 /mysql-test/t/innodb.test
parent2309be62e54ac54877645e0c264797646a379b32 (diff)
downloadmariadb-git-ad4d8773506e1c13d39f7b89a4ce4dce63b9ad49.tar.gz
Changes from the innodb-5.1-ss28 snapshot.
Removed include/Makefile.am and the reference to it. Deleted db/db0err.h and db directory. Check index column sizes in a better way (bug 13315). Fixed comments for memory allocation functions and added some extra checks. Adapted callers. BitKeeper/deleted/.del-Makefile.am~ab5c84d46412dc2e: Delete: storage/innobase/include/Makefile.am BitKeeper/deleted/.del-db0err.h~bfeec2efe86ac48b: Delete: storage/innobase/db/db0err.h mysql-test/r/innodb.result: Changes from the innodb-5.1-ss28 snapshot. mysql-test/t/innodb.test: Changes from the innodb-5.1-ss28 snapshot. sql/ha_innodb.cc: Changes from the innodb-5.1-ss28 snapshot. sql/ha_innodb.h: Changes from the innodb-5.1-ss28 snapshot. storage/innobase/Makefile.am: Changes from the innodb-5.1-ss28 snapshot. storage/innobase/configure.in: Changes from the innodb-5.1-ss28 snapshot. storage/innobase/ha/ha0ha.c: Changes from the innodb-5.1-ss28 snapshot. storage/innobase/include/ha0ha.h: Changes from the innodb-5.1-ss28 snapshot. storage/innobase/include/ha0ha.ic: Changes from the innodb-5.1-ss28 snapshot. storage/innobase/include/mem0mem.h: Changes from the innodb-5.1-ss28 snapshot. storage/innobase/include/mem0mem.ic: Changes from the innodb-5.1-ss28 snapshot. storage/innobase/lock/lock0lock.c: Changes from the innodb-5.1-ss28 snapshot. storage/innobase/mem/mem0mem.c: Changes from the innodb-5.1-ss28 snapshot.
Diffstat (limited to 'mysql-test/t/innodb.test')
-rw-r--r--mysql-test/t/innodb.test38
1 files changed, 26 insertions, 12 deletions
diff --git a/mysql-test/t/innodb.test b/mysql-test/t/innodb.test
index a73ecf7c3eb..4b97f27ebe6 100644
--- a/mysql-test/t/innodb.test
+++ b/mysql-test/t/innodb.test
@@ -1356,8 +1356,8 @@ source include/varchar.inc;
# Clean up filename -- embedded server reports whole path without .frm,
# regular server reports relative path with .frm (argh!)
--replace_result \\ / $MYSQL_TEST_DIR . /var/master-data/ / t1.frm t1
---error 1005
create table t1 (v varchar(65530), key(v));
+drop table t1;
create table t1 (v varchar(65536));
show create table t1;
drop table t1;
@@ -1485,7 +1485,7 @@ CREATE TEMPORARY TABLE t2
DROP TABLE t1;
#
-# Test that index column max sizes are checked (bug #13315)
+# Test that index column max sizes are honored (bug #13315)
#
# prefix index
@@ -1512,22 +1512,36 @@ create table t8 (col1 blob, index(col1(767)))
create table t9 (col1 varchar(512), col2 varchar(512), index(col1, col2))
character set = latin1 engine = innodb;
+show create table t9;
+
drop table t1, t2, t3, t4, t5, t6, t7, t8, t9;
---error 1005
-create table t1 (col1 varchar(768), index (col1))
+# these should have their index length trimmed
+create table t1 (col1 varchar(768), index(col1))
character set = latin1 engine = innodb;
---error 1005
-create table t2 (col1 varchar(768) primary key)
+create table t2 (col1 varbinary(768), index(col1))
character set = latin1 engine = innodb;
---error 1005
-create table t3 (col1 varbinary(768) primary key)
+create table t3 (col1 text, index(col1(768)))
character set = latin1 engine = innodb;
---error 1005
-create table t4 (col1 text, index(col1(768)))
+create table t4 (col1 blob, index(col1(768)))
character set = latin1 engine = innodb;
---error 1005
-create table t5 (col1 blob, index(col1(768)))
+
+show create table t1;
+
+drop table t1, t2, t3, t4;
+
+# these should be refused
+--error 1071
+create table t1 (col1 varchar(768) primary key)
+ character set = latin1 engine = innodb;
+--error 1071
+create table t2 (col1 varbinary(768) primary key)
+ character set = latin1 engine = innodb;
+--error 1071
+create table t3 (col1 text, primary key(col1(768)))
+ character set = latin1 engine = innodb;
+--error 1071
+create table t4 (col1 blob, primary key(col1(768)))
character set = latin1 engine = innodb;
#