# shrinked testcase derived from NIST tests : schema8, schema9,  sultab1
#    schema SUN, tables: STAFF_P (-> mysqltest.t1), PROJ_P (not really needed)
#    schema SULLIVAN, table: WORKS_P (-> test.t2)

--source include/have_innodb.inc
let $engine_type=InnoDB;

--error 0,ER_CANNOT_USER
DROP USER mysqltest@localhost;
CREATE USER mysqltest@localhost identified by 'PWD';

--disable_warnings
DROP TABLE IF EXISTS test.t2;
DROP SCHEMA IF EXISTS mysqltest;
--enable_warnings
CREATE SCHEMA mysqltest ;

grant ALL ON mysqltest.* to mysqltest@localhost;
grant ALL ON test.* to mysqltest@localhost;

--echo # Establish connection mysqltest (user = mysqltest)
# crash disappears, if connection default (user = root) runs the following statements
--replace_result $MASTER_MYPORT MYSQL_PORT $MASTER_MYSOCK MYSQL_SOCK
connect (mysqltest,localhost,mysqltest,PWD,test);
USE mysqltest;

eval CREATE TABLE t1
           (f1   CHAR(3) NOT NULL,
            UNIQUE  (f1)) ENGINE = $engine_type;

eval CREATE TABLE test.t2
   (f1   CHAR(3),
    f2     CHAR(3),
    FOREIGN KEY (f1) REFERENCES mysqltest.t1(f1)) ENGINE = $engine_type;

# Cleanup
--echo # Switch to connection default (user = root)
connection default;
REVOKE ALL PRIVILEGES, GRANT OPTION FROM mysqltest@localhost;
disconnect mysqltest;
DROP USER mysqltest@localhost;
DROP SCHEMA mysqltest;
DROP TABLE test.t2;