Bug #28040 Falcon CREATE TABLE in new SCHEMA crashes server
Submitted: 23 Apr 2007 20:29
Reporter: Hakan Küçükyılmaz Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Falcon storage engine Severity:S3 (Non-critical)
Version:6.0.0-alpha OS:Any
Assigned to: CPU Architecture:Any

[23 Apr 2007 20:29] Hakan Küçükyılmaz
Description:
CREATE TABLE in new SCHEMA crashes server

How to repeat:
# testcase derived from the NIST tests
SET GLOBAL STORAGE_ENGINE=Falcon;
DROP USER test_db@localhost;
CREATE USER test_db@localhost identified by 'PWD';
grant ALL ON test_db.* to test_db@localhost with grant option;
DROP SCHEMA IF EXISTS test_db;
connect (test_db,localhost,test_db,PWD,test);
CREATE SCHEMA test_db ;
USE test_db ;
# This create table causes a crash
CREATE TABLE BASE_TESTREPORT
(TESTNO CHAR(4),
RESULT CHAR(4),
TESTTYPE CHAR(3));
      CRASH
[23 Apr 2007 20:30] Hakan Küçükyılmaz
Test case is falcon_bug_28040.test.
[10 Jul 2007 10:09] Giuseppe Maxia
Fails in Mac OS X. See Bug#29686