SET storage_engine = Falcon;
#
# Bug #22847: Falcon: Unnecessary blockage for nulls
#
--echo *** Bug #22847 ***
--disable_warnings
DROP TABLE IF EXISTS t1;
--enable_warnings

--echo # Establish connection conn1 (user = root)
connect (conn1,localhost,root,,);
SET storage_engine = Falcon;

--echo # Switch to connection default
connection default;
CREATE TABLE t1 (a int, unique (a));
START TRANSACTION;
INSERT INTO t1 VALUES (null);

--echo # Switch to connection conn1
connection conn1;
START TRANSACTION;
INSERT INTO t1 VALUES (null);
COMMIT;

--echo # Switch to connection default
connection default;
SELECT COUNT(*) FROM t1 WHERE a IS NULL;
COMMIT;

# Final cleanup.
disconnect conn1;
DROP TABLE t1;
