SET STORAGE_ENGINE='Falcon';
#---- Bug 191 ----
DROP TABLE IF EXISTS t1;
CREATE TABLE t1 (EMPNUM    CHAR(3) NOT NULL,
EMPNAME  CHAR(20) DEFAULT NULL,
GRADE DECIMAL(4) NOT NULL ,
CITY   CHAR(15), PRIMARY KEY (GRADE));
INSERT INTO t1 (EMPNUM,EMPNAME,GRADE)
VALUES ('E3','Bill',151);
SELECT * FROM t1;
EMPNUM	EMPNAME	GRADE	CITY
E3	Bill	151	NULL
SELECT * FROM t1 WHERE GRADE= 151;
EMPNUM	EMPNAME	GRADE	CITY
E3	Bill	151	NULL
ALTER TABLE t1 DROP PRIMARY KEY;
SELECT * FROM t1;
EMPNUM	EMPNAME	GRADE	CITY
E3	Bill	151	NULL
SELECT * FROM t1 WHERE GRADE= 151;
EMPNUM	EMPNAME	GRADE	CITY
E3	Bill	151	NULL
DROP TABLE t1;
