summaryrefslogtreecommitdiff
path: root/mysql-test/t/innodb_bug44369.test
diff options
context:
space:
mode:
authorSatya B <satya.bn@sun.com>2009-10-16 17:28:02 +0530
committerSatya B <satya.bn@sun.com>2009-10-16 17:28:02 +0530
commitd63eb541f51648050467201ee4e148b087174ac6 (patch)
treed800c318519c4be386c9f5b47428b6790b8addb2 /mysql-test/t/innodb_bug44369.test
parent12c7d0cf33b20dfcd548af594542b8a7bda601d2 (diff)
downloadmariadb-git-d63eb541f51648050467201ee4e148b087174ac6.tar.gz
Merging Innodb plugin 1.0.5 revisions from 5.1-main from revisions 3149 to 3163
also merged missing Innodb plugin revisions r5636,r5635 manually
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..495059eb5e6
--- /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 errors;
+
+--error ER_CANT_CREATE_TABLE
+create table bug44369 (db_TRX_Id int) engine=innodb;
+
+show errors;