SET storage_engine = Falcon;
#
# Bug #22564: auto_increment column gets automatically incremented
#
--echo *** Bug #22564 ***
--disable_warnings
DROP TABLE IF EXISTS t1;
--enable_warnings

CREATE TABLE t1 (a int, b int auto_increment, key (a, b));

INSERT INTO t1 VALUES (1, null);
INSERT INTO t1 (a) VALUES (1), (2), (3);
SELECT * FROM t1 ORDER BY a;

# Final cleanup.
DROP TABLE t1;
