# Bug#30310 : wrong result on SELECT * FROM INFORMATION_SCHEMA.SCHEMATA WHERE ...
# testcase derived from NIST yts776, test simplified, names are changed etc.

--disable_warnings
DROP SCHEMA IF EXISTS mysqltest;
--enable_warnings

CREATE SCHEMA mysqltest;

SELECT *
FROM INFORMATION_SCHEMA.SCHEMATA
WHERE SCHEMA_NAME = 'mysqltest';

DROP SCHEMA mysqltest;

# Here comes the bug
# There must be no record with SCHEMA_NAME = 'mysqltest'
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA
WHERE SCHEMA_NAME = 'mysqltest';
#
# Here comes the bug again (NIST testcase uses COUNT(*) )
SELECT COUNT(*) FROM INFORMATION_SCHEMA.SCHEMATA
WHERE SCHEMA_NAME = 'mysqltest';

# Here comes a surprising correct result.
SELECT * FROM INFORMATION_SCHEMA.SCHEMATA;