summaryrefslogtreecommitdiff
path: root/mysql-test/t/innodb_bug44369.test
diff options
context:
space:
mode:
authorunknown <knielsen@knielsen-hq.org>2009-11-30 22:37:27 +0100
committerunknown <knielsen@knielsen-hq.org>2009-11-30 22:37:27 +0100
commit7af12a0d7234777d7dc01ebf114cdfbf09dcd072 (patch)
tree4a9d9e50072d36ee917a570f8bf83a0117e971db /mysql-test/t/innodb_bug44369.test
parentf12371c8601774eba10d42ddaf6399334f3378e1 (diff)
parentdc51f0e1ebf14233025f2723289d238bf43041cf (diff)
downloadmariadb-git-7af12a0d7234777d7dc01ebf114cdfbf09dcd072.tar.gz
Merge MySQL 5.1.41 into MariaDB trunk, including a number of after-merge fixes.
Also merge charset patch.
Diffstat (limited to 'mysql-test/t/innodb_bug44369.test')
-rw-r--r--mysql-test/t/innodb_bug44369.test21
1 files changed, 21 insertions, 0 deletions
diff --git a/mysql-test/t/innodb_bug44369.test b/mysql-test/t/innodb_bug44369.test
new file mode 100644
index 00000000000..238dc3d8fb1
--- /dev/null
+++ b/mysql-test/t/innodb_bug44369.test
@@ -0,0 +1,21 @@
+# This is the test for bug 44369. We should
+# block table creation with columns match
+# some innodb internal reserved key words,
+# both case sensitively and insensitely.
+
+--source include/have_innodb.inc
+
+# This create table operation should fail.
+--error ER_CANT_CREATE_TABLE
+create table bug44369 (DB_ROW_ID int) engine=innodb;
+
+# This create should fail as well
+--error ER_CANT_CREATE_TABLE
+create table bug44369 (db_row_id int) engine=innodb;
+
+show warnings;
+
+--error ER_CANT_CREATE_TABLE
+create table bug44369 (db_TRX_Id int) engine=innodb;
+
+show warnings;