bzr commit into mysql-6.0-falcon-team branch (lars-erik.bjork:3025) Bug#33719

[lars-erik.bjork]

#At file:///home/lb200670/mysql/33719/ based on revid:vvaintroub@stripped

 3025 lars-erik.bjork@stripped	2009-02-17
      Added a test for bug#33719 CREATE TABLE only accepts falcon_user
      tablespace in uppercase
      
      === added file 'mysql-test/suite/falcon/r/falcon_bug_33719.result'
      Expected result
      
      
      === added file 'mysql-test/suite/falcon/t/falcon_bug_33719.test'
      Test file
added:
  mysql-test/suite/falcon/r/falcon_bug_33719.result
  mysql-test/suite/falcon/t/falcon_bug_33719.test

=== added file 'mysql-test/suite/falcon/r/falcon_bug_33719.result'
--- a/mysql-test/suite/falcon/r/falcon_bug_33719.result	1970-01-01 00:00:00 +0000
+++ b/mysql-test/suite/falcon/r/falcon_bug_33719.result	2009-02-17 08:23:56 +0000
@@ -0,0 +1,10 @@
+*** Bug #33719 ***
+SET @@storage_engine = 'Falcon';
+DROP TABLE IF EXISTS t1;
+CREATE TABLE t1 (f1 integer) tablespace falcon_user;
+DROP TABLE t1;
+CREATE TABLE t1 (f1 integer) tablespace FALCON_USER;
+SELECT count(*) FROM t1;
+count(*)
+0
+DROP TABLE t1;

=== added file 'mysql-test/suite/falcon/t/falcon_bug_33719.test'
--- a/mysql-test/suite/falcon/t/falcon_bug_33719.test	1970-01-01 00:00:00 +0000
+++ b/mysql-test/suite/falcon/t/falcon_bug_33719.test	2009-02-17 08:23:56 +0000
@@ -0,0 +1,38 @@
+--source include/have_falcon.inc
+
+#
+# Bug #33719: CREATE TABLE only accepts falcon_user tablespace in uppercase
+#
+--echo *** Bug #33719 ***
+
+# ----------------------------------------------------- #
+# --- Initialisation                                --- #
+# ----------------------------------------------------- #
+let $engine = 'Falcon';
+eval SET @@storage_engine = $engine;
+
+--disable_warnings
+DROP TABLE IF EXISTS t1;
+--enable_warnings
+
+# ----------------------------------------------------- #
+# --- Test                                          --- #
+# ----------------------------------------------------- #
+
+# Used to fail with Can't create table 'test.foo' (errno: 156)
+CREATE TABLE t1 (f1 integer) tablespace falcon_user;
+DROP TABLE t1;
+
+# Testing with all upper case as well
+CREATE TABLE t1 (f1 integer) tablespace FALCON_USER;
+
+
+# ----------------------------------------------------- #
+# --- Check                                         --- #
+# ----------------------------------------------------- #
+SELECT count(*) FROM t1;
+
+# ----------------------------------------------------- #
+# --- Final cleanup                                 --- #
+# ----------------------------------------------------- #
+DROP TABLE t1;