innodb.innodb_information_schema 'innodb_plugin' w1 [ fail ]

        Test ended at 2016-09-04 18:11:31

CURRENT_TEST: innodb.innodb_information_schema

--- /mnt/buildbot/build/mariadb-10.2.2/mysql-test/suite/innodb/r/innodb_information_schema.result	2016-09-04 15:32:48.000000000 +0300

+++ /mnt/buildbot/build/mariadb-10.2.2/mysql-test/suite/innodb/r/innodb_information_schema.reject	2016-09-04 18:11:29.000000000 +0300

@@ -51,4 +51,4 @@

 trx_isolation_level	trx_unique_checks	trx_foreign_key_checks

 SERIALIZABLE	0	0

 trx_state	trx_isolation_level	trx_last_foreign_key_error

-RUNNING	REPEATABLE READ	`test`.`t2`, CONSTRAINT `fk1` FOREIGN KEY (`c02`) REFERENCES `t1` (`c01`)

+RUNNING	SERIALIZABLE	`test`.`t2`, CONSTRAINT `fk1` FOREIGN KEY (`c02`) REFERENCES `t1` (`c01`)

main.commit 'xtradb'                     w3 [ fail ]

        Test ended at 2016-09-04 18:15:34

CURRENT_TEST: main.commit

innodb_open_files should not be greater than the open_files_limit.

mysqltest: At line 486: query 'CREATE FUNCTION f1() RETURNS INT

BEGIN

DELETE FROM t1;

RETURN 1;

END' failed: 1792: Cannot execute statement in a READ ONLY transaction.

The result from queries just before the failure was:

< snip >

HANDLER t1 READ FIRST;

a

HANDLER t1 CLOSE;

HANDLER temp_t2 OPEN;

HANDLER temp_t2 READ FIRST;

a

HANDLER temp_t2 CLOSE;

# 5: Prepared statements

PREPARE stmt FROM "DELETE FROM t1";

ERROR 25006: Cannot execute statement in a READ ONLY transaction.

PREPARE stmt FROM "DELETE FROM temp_t2";

EXECUTE stmt;

DEALLOCATE PREPARE stmt;

COMMIT;

# 6: Stored routines

CREATE FUNCTION f1() RETURNS INT

BEGIN

DELETE FROM t1;

RETURN 1;

END|