# 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,1396
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)
--replace_result $MASTER_MYPORT MYSQL_PORT $MASTER_MYSOCK MYSQL_SOCK
connect (mysqltest,localhost,mysqltest,PWD,test);
USE mysqltest;

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

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

###################################################################
#                                                                 #
# This statement crashes the server                               #
#                                                                 #
###################################################################
INSERT INTO test.t2 VALUES  ('E1','P1');

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