Failures in engines/* and storage_engine/* tests

storage_engine-innobase.col_opt_not_null [ fail ]

        Test ended at 2015-02-04 23:21:14

CURRENT_TEST: storage_engine-innobase.col_opt_not_null

--- /data/repo/git/10.1/mysql-test/suite/storage_engine/col_opt_not_null.result	2014-12-12 03:38:35.000000000 +0300

+++ /data/repo/git/10.1/mysql-test/suite/storage_engine/col_opt_not_null.reject	2015-02-04 23:21:13.000000000 +0300

@@ -1482,7 +1482,15 @@

 r1_1	0.9

 r1_1	0.9

 ALTER TABLE t1 ADD COLUMN d0_0 DOUBLE(0,0);

-ERROR 42000: Display width out of range for 'd0_0' (max = 255)

+# ERROR: Statement succeeded (expected results: ER_TOO_BIG_DISPLAYWIDTH)

+# ------------ UNEXPECTED RESULT ------------

+# [ ALTER TABLE t1 ADD COLUMN d0_0 DOUBLE(0,0) ]

+# The statement|command succeeded unexpectedly.

+# ALTER TABLE or the mix could be unsupported|malfunctioning, or the problem was caused by previous errors. 

+# You can change the engine code, or create an rdiff, or disable the test by adding it to disabled.def.

+# Further in this test, the message might sometimes be suppressed; a part of the test might be skipped.

+# Also, this problem may cause a chain effect (more errors of different kinds in the test).

+# -------------------------------------------

 ALTER TABLE t1 ADD COLUMN n66_6 DECIMAL(256,1);

 ERROR 42000: Too big precision 256 specified for 'n66_6'. Maximum is 65.

 ALTER TABLE t1 ADD COLUMN n66_66 DECIMAL(40,35);

mysqltest: Result length mismatch

engines/funcs.db_create_drop             [ fail ]

        Test ended at 2014-12-03 04:15:08

CURRENT_TEST: engines/funcs.db_create_drop

--- /data/repo/bzr/10.0/mysql-test/suite/engines/funcs/r/db_create_drop.result	2014-11-12 05:27:00.000000000 +0400

+++ /data/repo/bzr/10.0/mysql-test/suite/engines/funcs/r/db_create_drop.reject	2014-12-03 04:15:08.000000000 +0400

@@ -2,8 +2,8 @@

 CREATE DATABASE d1;

 SHOW DATABASES;

 Database

-information_schema

 d1

+information_schema

 mtr

 mysql

 performance_schema

@@ -13,8 +13,8 @@

 d1

 SHOW DATABASES LIKE '%';

 Database (%)

-information_schema

 d1

+information_schema

 mtr

 mysql

 performance_schema

@@ -24,8 +24,8 @@

 CREATE SCHEMA d1;

 SHOW SCHEMAS;

 Database

-information_schema

 d1

+information_schema

 mtr

 mysql

 performance_schema

@@ -35,8 +35,8 @@

 d1

 SHOW SCHEMAS LIKE '%';

 Database (%)

-information_schema

 d1

+information_schema

 mtr

 mysql

 performance_schema

mysqltest: Result content mismatch

engines/funcs.db_create_error            [ fail ]

        Test ended at 2014-12-03 04:15:09

CURRENT_TEST: engines/funcs.db_create_error

--- /data/repo/bzr/10.0/mysql-test/suite/engines/funcs/r/db_create_error.result	2014-11-12 05:27:00.000000000 +0400

+++ /data/repo/bzr/10.0/mysql-test/suite/engines/funcs/r/db_create_error.reject	2014-12-03 04:15:08.000000000 +0400

@@ -2,8 +2,8 @@

 CREATE DATABASE d4;

 SHOW DATABASES;

 Database

-information_schema

 d4

+information_schema

 mtr

 mysql

 performance_schema

mysqltest: Result content mismatch

engines/funcs.db_create_if_not_exists    [ fail ]

        Test ended at 2014-12-03 04:15:10

CURRENT_TEST: engines/funcs.db_create_if_not_exists

--- /data/repo/bzr/10.0/mysql-test/suite/engines/funcs/r/db_create_if_not_exists.result	2014-11-12 05:27:00.000000000 +0400

+++ /data/repo/bzr/10.0/mysql-test/suite/engines/funcs/r/db_create_if_not_exists.reject	2014-12-03 04:15:09.000000000 +0400

@@ -5,8 +5,8 @@

 Note	1007	Can't create database 'd2'; database exists

 SHOW DATABASES;

 Database

-information_schema

 d2

+information_schema

 mtr

 mysql

 performance_schema

@@ -22,8 +22,8 @@

 Note	1007	Can't create database 'd2'; database exists

 SHOW DATABASES;

 Database

-information_schema

 d2

+information_schema

 mtr

 mysql

 performance_schema

mysqltest: Result content mismatch

engines/funcs.db_drop_error              [ fail ]

        Test ended at 2014-12-03 04:15:10

CURRENT_TEST: engines/funcs.db_drop_error

--- /data/repo/bzr/10.0/mysql-test/suite/engines/funcs/r/db_drop_error.result	2014-11-12 05:27:00.000000000 +0400

+++ /data/repo/bzr/10.0/mysql-test/suite/engines/funcs/r/db_drop_error.reject	2014-12-03 04:15:10.000000000 +0400

@@ -2,8 +2,8 @@

 CREATE DATABASE d5;

 SHOW DATABASES;

 Database

-information_schema

 d5

+information_schema

 mtr

 mysql

 performance_schema

mysqltest: Result content mismatch

engines/funcs.db_use_error               [ fail ]

        Test ended at 2014-12-03 04:15:13

CURRENT_TEST: engines/funcs.db_use_error

--- /data/repo/bzr/10.0/mysql-test/suite/engines/funcs/r/db_use_error.result	2014-11-12 05:27:00.000000000 +0400

+++ /data/repo/bzr/10.0/mysql-test/suite/engines/funcs/r/db_use_error.reject	2014-12-03 04:15:13.000000000 +0400

@@ -2,8 +2,8 @@

 CREATE DATABASE d6;

 SHOW DATABASES;

 Database

-information_schema

 d6

+information_schema

 mtr

 mysql

 performance_schema

mysqltest: Result content mismatch

engines/funcs.sf_alter                   [ fail ]

        Test ended at 2014-12-03 04:18:18

CURRENT_TEST: engines/funcs.sf_alter

--- /data/repo/bzr/10.0/mysql-test/suite/engines/funcs/r/sf_alter.result	2014-11-12 05:27:00.000000000 +0400

+++ /data/repo/bzr/10.0/mysql-test/suite/engines/funcs/r/sf_alter.reject	2014-12-03 04:18:18.000000000 +0400

@@ -35,8 +35,6 @@

 SELECT sf1();

 sf1()

 0

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -54,8 +52,6 @@

 2	1

 3	3

 INSERT INTO t4 VALUES(sf1());

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -76,9 +72,6 @@

 3	3

 3	3

 UPDATE t4 SET i = sf1() + 1 WHERE i = sf1();

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -105,8 +98,6 @@

 3	3

 3	3

 DELETE FROM t4 WHERE i = sf1() + 1;

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -172,8 +163,6 @@

 SELECT sf1();

 sf1()

 0

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -191,8 +180,6 @@

 2	1

 3	3

 INSERT INTO t4 VALUES(sf1());

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -213,9 +200,6 @@

 3	3

 3	3

 UPDATE t4 SET i = sf1() + 1 WHERE i = sf1();

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -242,8 +226,6 @@

 3	3

 3	3

 DELETE FROM t4 WHERE i = sf1() + 1;

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -309,8 +291,6 @@

 SELECT sf1();

 sf1()

 0

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -328,8 +308,6 @@

 2	1

 3	3

 INSERT INTO t4 VALUES(sf1());

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -350,9 +328,6 @@

 3	3

 3	3

 UPDATE t4 SET i = sf1() + 1 WHERE i = sf1();

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -379,8 +354,6 @@

 3	3

 3	3

 DELETE FROM t4 WHERE i = sf1() + 1;

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -446,8 +419,6 @@

 SELECT sf1();

 sf1()

 0

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -465,8 +436,6 @@

 2	1

 3	3

 INSERT INTO t4 VALUES(sf1());

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -487,9 +456,6 @@

 3	3

 3	3

 UPDATE t4 SET i = sf1() + 1 WHERE i = sf1();

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -516,8 +482,6 @@

 3	3

 3	3

 DELETE FROM t4 WHERE i = sf1() + 1;

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -583,8 +547,6 @@

 SELECT sf1();

 sf1()

 0

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -602,8 +564,6 @@

 2	1

 3	3

 INSERT INTO t4 VALUES(sf1());

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -624,9 +584,6 @@

 3	3

 3	3

 UPDATE t4 SET i = sf1() + 1 WHERE i = sf1();

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -653,8 +610,6 @@

 3	3

 3	3

 DELETE FROM t4 WHERE i = sf1() + 1;

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -720,8 +675,6 @@

 SELECT sf1();

 sf1()

 0

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -739,8 +692,6 @@

 2	1

 3	3

 INSERT INTO t4 VALUES(sf1());

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -761,9 +712,6 @@

 3	3

 3	3

 UPDATE t4 SET i = sf1() + 1 WHERE i = sf1();

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -790,8 +738,6 @@

 3	3

 3	3

 DELETE FROM t4 WHERE i = sf1() + 1;

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -857,8 +803,6 @@

 SELECT sf1();

 sf1()

 0

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -876,8 +820,6 @@

 2	1

 3	3

 INSERT INTO t4 VALUES(sf1());

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -898,9 +840,6 @@

 3	3

 3	3

 UPDATE t4 SET i = sf1() + 1 WHERE i = sf1();

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -927,8 +866,6 @@

 3	3

 3	3

 DELETE FROM t4 WHERE i = sf1() + 1;

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -994,8 +931,6 @@

 SELECT sf1();

 sf1()

 0

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -1013,8 +948,6 @@

 2	1

 3	3

 INSERT INTO t4 VALUES(sf1());

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -1035,9 +968,6 @@

 3	3

 3	3

 UPDATE t4 SET i = sf1() + 1 WHERE i = sf1();

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -1064,8 +994,6 @@

 3	3

 3	3

 DELETE FROM t4 WHERE i = sf1() + 1;

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -1131,8 +1059,6 @@

 SELECT sf1();

 sf1()

 0

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -1150,8 +1076,6 @@

 2	1

 3	3

 INSERT INTO t4 VALUES(sf1());

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -1172,9 +1096,6 @@

 3	3

 3	3

 UPDATE t4 SET i = sf1() + 1 WHERE i = sf1();

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -1201,8 +1122,6 @@

 3	3

 3	3

 DELETE FROM t4 WHERE i = sf1() + 1;

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -1268,8 +1187,6 @@

 SELECT sf1();

 sf1()

 0

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -1287,8 +1204,6 @@

 2	1

 3	3

 INSERT INTO t4 VALUES(sf1());

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -1309,9 +1224,6 @@

 3	3

 3	3

 UPDATE t4 SET i = sf1() + 1 WHERE i = sf1();

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -1338,8 +1250,6 @@

 3	3

 3	3

 DELETE FROM t4 WHERE i = sf1() + 1;

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -1405,8 +1315,6 @@

 SELECT sf1();

 sf1()

 0

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -1424,8 +1332,6 @@

 2	1

 3	3

 INSERT INTO t4 VALUES(sf1());

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -1446,9 +1352,6 @@

 3	3

 3	3

 UPDATE t4 SET i = sf1() + 1 WHERE i = sf1();

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -1475,8 +1378,6 @@

 3	3

 3	3

 DELETE FROM t4 WHERE i = sf1() + 1;

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -1542,8 +1443,6 @@

 SELECT sf1();

 sf1()

 0

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -1561,8 +1460,6 @@

 2	1

 3	3

 INSERT INTO t4 VALUES(sf1());

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -1583,9 +1480,6 @@

 3	3

 3	3

 UPDATE t4 SET i = sf1() + 1 WHERE i = sf1();

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -1612,8 +1506,6 @@

 3	3

 3	3

 DELETE FROM t4 WHERE i = sf1() + 1;

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -1679,8 +1571,6 @@

 SELECT sf1();

 sf1()

 0

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -1698,8 +1588,6 @@

 2	1

 3	3

 INSERT INTO t4 VALUES(sf1());

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -1720,9 +1608,6 @@

 3	3

 3	3

 UPDATE t4 SET i = sf1() + 1 WHERE i = sf1();

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -1749,8 +1634,6 @@

 3	3

 3	3

 DELETE FROM t4 WHERE i = sf1() + 1;

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -1816,8 +1699,6 @@

 SELECT sf1();

 sf1()

 0

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -1835,8 +1716,6 @@

 2	1

 3	3

 INSERT INTO t4 VALUES(sf1());

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -1857,9 +1736,6 @@

 3	3

 3	3

 UPDATE t4 SET i = sf1() + 1 WHERE i = sf1();

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -1886,8 +1762,6 @@

 3	3

 3	3

 DELETE FROM t4 WHERE i = sf1() + 1;

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -1953,8 +1827,6 @@

 SELECT sf1();

 sf1()

 0

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -1972,8 +1844,6 @@

 2	1

 3	3

 INSERT INTO t4 VALUES(sf1());

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -1994,9 +1864,6 @@

 3	3

 3	3

 UPDATE t4 SET i = sf1() + 1 WHERE i = sf1();

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -2023,8 +1890,6 @@

 3	3

 3	3

 DELETE FROM t4 WHERE i = sf1() + 1;

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -2090,8 +1955,6 @@

 SELECT sf1();

 sf1()

 0

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -2109,8 +1972,6 @@

 2	1

 3	3

 INSERT INTO t4 VALUES(sf1());

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -2131,9 +1992,6 @@

 3	3

 3	3

 UPDATE t4 SET i = sf1() + 1 WHERE i = sf1();

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -2160,8 +2018,6 @@

 3	3

 3	3

 DELETE FROM t4 WHERE i = sf1() + 1;

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -2227,8 +2083,6 @@

 SELECT sf1();

 sf1()

 0

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -2246,8 +2100,6 @@

 2	1

 3	3

 INSERT INTO t4 VALUES(sf1());

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -2268,9 +2120,6 @@

 3	3

 3	3

 UPDATE t4 SET i = sf1() + 1 WHERE i = sf1();

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -2297,8 +2146,6 @@

 3	3

 3	3

 DELETE FROM t4 WHERE i = sf1() + 1;

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -2364,8 +2211,6 @@

 SELECT sf1();

 sf1()

 0

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -2383,8 +2228,6 @@

 2	1

 3	3

 INSERT INTO t4 VALUES(sf1());

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -2405,9 +2248,6 @@

 3	3

 3	3

 UPDATE t4 SET i = sf1() + 1 WHERE i = sf1();

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -2434,8 +2274,6 @@

 3	3

 3	3

 DELETE FROM t4 WHERE i = sf1() + 1;

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -2501,8 +2339,6 @@

 SELECT sf1();

 sf1()

 0

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -2520,8 +2356,6 @@

 2	1

 3	3

 INSERT INTO t4 VALUES(sf1());

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -2542,9 +2376,6 @@

 3	3

 3	3

 UPDATE t4 SET i = sf1() + 1 WHERE i = sf1();

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -2571,8 +2402,6 @@

 3	3

 3	3

 DELETE FROM t4 WHERE i = sf1() + 1;

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -2638,8 +2467,6 @@

 SELECT sf1();

 sf1()

 0

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -2657,8 +2484,6 @@

 2	1

 3	3

 INSERT INTO t4 VALUES(sf1());

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -2679,9 +2504,6 @@

 3	3

 3	3

 UPDATE t4 SET i = sf1() + 1 WHERE i = sf1();

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -2708,8 +2530,6 @@

 3	3

 3	3

 DELETE FROM t4 WHERE i = sf1() + 1;

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -2775,8 +2595,6 @@

 SELECT sf1();

 sf1()

 0

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -2794,8 +2612,6 @@

 2	1

 3	3

 INSERT INTO t4 VALUES(sf1());

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -2816,9 +2632,6 @@

 3	3

 3	3

 UPDATE t4 SET i = sf1() + 1 WHERE i = sf1();

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -2845,8 +2658,6 @@

 3	3

 3	3

 DELETE FROM t4 WHERE i = sf1() + 1;

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -2912,8 +2723,6 @@

 SELECT sf1();

 sf1()

 0

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -2931,8 +2740,6 @@

 2	1

 3	3

 INSERT INTO t4 VALUES(sf1());

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -2953,9 +2760,6 @@

 3	3

 3	3

 UPDATE t4 SET i = sf1() + 1 WHERE i = sf1();

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -2982,8 +2786,6 @@

 3	3

 3	3

 DELETE FROM t4 WHERE i = sf1() + 1;

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -3049,8 +2851,6 @@

 SELECT sf1();

 sf1()

 0

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -3068,8 +2868,6 @@

 2	1

 3	3

 INSERT INTO t4 VALUES(sf1());

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -3090,9 +2888,6 @@

 3	3

 3	3

 UPDATE t4 SET i = sf1() + 1 WHERE i = sf1();

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -3119,8 +2914,6 @@

 3	3

 3	3

 DELETE FROM t4 WHERE i = sf1() + 1;

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -3186,8 +2979,6 @@

 SELECT sf1();

 sf1()

 0

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -3205,8 +2996,6 @@

 2	1

 3	3

 INSERT INTO t4 VALUES(sf1());

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -3227,9 +3016,6 @@

 3	3

 3	3

 UPDATE t4 SET i = sf1() + 1 WHERE i = sf1();

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -3256,8 +3042,6 @@

 3	3

 3	3

 DELETE FROM t4 WHERE i = sf1() + 1;

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -3323,8 +3107,6 @@

 SELECT sf1();

 sf1()

 0

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -3342,8 +3124,6 @@

 2	1

 3	3

 INSERT INTO t4 VALUES(sf1());

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -3364,9 +3144,6 @@

 3	3

 3	3

 UPDATE t4 SET i = sf1() + 1 WHERE i = sf1();

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -3393,8 +3170,6 @@

 3	3

 3	3

 DELETE FROM t4 WHERE i = sf1() + 1;

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -3460,8 +3235,6 @@

 SELECT sf1();

 sf1()

 0

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -3479,8 +3252,6 @@

 2	1

 3	3

 INSERT INTO t4 VALUES(sf1());

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -3501,9 +3272,6 @@

 3	3

 3	3

 UPDATE t4 SET i = sf1() + 1 WHERE i = sf1();

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -3530,8 +3298,6 @@

 3	3

 3	3

 DELETE FROM t4 WHERE i = sf1() + 1;

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -3597,8 +3363,6 @@

 SELECT sf1();

 sf1()

 0

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -3616,8 +3380,6 @@

 2	1

 3	3

 INSERT INTO t4 VALUES(sf1());

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -3638,9 +3400,6 @@

 3	3

 3	3

 UPDATE t4 SET i = sf1() + 1 WHERE i = sf1();

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -3667,8 +3426,6 @@

 3	3

 3	3

 DELETE FROM t4 WHERE i = sf1() + 1;

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -3734,8 +3491,6 @@

 SELECT sf1();

 sf1()

 0

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -3753,8 +3508,6 @@

 2	1

 3	3

 INSERT INTO t4 VALUES(sf1());

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -3775,9 +3528,6 @@

 3	3

 3	3

 UPDATE t4 SET i = sf1() + 1 WHERE i = sf1();

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -3804,8 +3554,6 @@

 3	3

 3	3

 DELETE FROM t4 WHERE i = sf1() + 1;

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -3871,8 +3619,6 @@

 SELECT sf1();

 sf1()

 0

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -3890,8 +3636,6 @@

 2	1

 3	3

 INSERT INTO t4 VALUES(sf1());

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -3912,9 +3656,6 @@

 3	3

 3	3

 UPDATE t4 SET i = sf1() + 1 WHERE i = sf1();

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -3941,8 +3682,6 @@

 3	3

 3	3

 DELETE FROM t4 WHERE i = sf1() + 1;

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -4008,8 +3747,6 @@

 SELECT sf1();

 sf1()

 0

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -4027,8 +3764,6 @@

 2	1

 3	3

 INSERT INTO t4 VALUES(sf1());

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -4049,9 +3784,6 @@

 3	3

 3	3

 UPDATE t4 SET i = sf1() + 1 WHERE i = sf1();

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -4078,8 +3810,6 @@

 3	3

 3	3

 DELETE FROM t4 WHERE i = sf1() + 1;

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -4145,8 +3875,6 @@

 SELECT sf1();

 sf1()

 0

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -4164,8 +3892,6 @@

 2	1

 3	3

 INSERT INTO t4 VALUES(sf1());

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -4186,9 +3912,6 @@

 3	3

 3	3

 UPDATE t4 SET i = sf1() + 1 WHERE i = sf1();

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -4215,8 +3938,6 @@

 3	3

 3	3

 DELETE FROM t4 WHERE i = sf1() + 1;

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -4282,8 +4003,6 @@

 SELECT sf1();

 sf1()

 0

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -4301,8 +4020,6 @@

 2	1

 3	3

 INSERT INTO t4 VALUES(sf1());

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -4323,9 +4040,6 @@

 3	3

 3	3

 UPDATE t4 SET i = sf1() + 1 WHERE i = sf1();

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -4352,8 +4066,6 @@

 3	3

 3	3

 DELETE FROM t4 WHERE i = sf1() + 1;

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -4419,8 +4131,6 @@

 SELECT sf1();

 sf1()

 0

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -4438,8 +4148,6 @@

 2	1

 3	3

 INSERT INTO t4 VALUES(sf1());

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -4460,9 +4168,6 @@

 3	3

 3	3

 UPDATE t4 SET i = sf1() + 1 WHERE i = sf1();

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -4489,8 +4194,6 @@

 3	3

 3	3

 DELETE FROM t4 WHERE i = sf1() + 1;

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -4556,8 +4259,6 @@

 SELECT sf1();

 sf1()

 0

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -4575,8 +4276,6 @@

 2	1

 3	3

 INSERT INTO t4 VALUES(sf1());

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -4597,9 +4296,6 @@

 3	3

 3	3

 UPDATE t4 SET i = sf1() + 1 WHERE i = sf1();

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -4626,8 +4322,6 @@

 3	3

 3	3

 DELETE FROM t4 WHERE i = sf1() + 1;

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -4693,8 +4387,6 @@

 SELECT sf1();

 sf1()

 0

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -4712,8 +4404,6 @@

 2	1

 3	3

 INSERT INTO t4 VALUES(sf1());

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -4734,9 +4424,6 @@

 3	3

 3	3

 UPDATE t4 SET i = sf1() + 1 WHERE i = sf1();

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -4763,8 +4450,6 @@

 3	3

 3	3

 DELETE FROM t4 WHERE i = sf1() + 1;

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -4830,8 +4515,6 @@

 SELECT sf1();

 sf1()

 0

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -4849,8 +4532,6 @@

 2	1

 3	3

 INSERT INTO t4 VALUES(sf1());

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -4871,9 +4552,6 @@

 3	3

 3	3

 UPDATE t4 SET i = sf1() + 1 WHERE i = sf1();

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -4900,8 +4578,6 @@

 3	3

 3	3

 DELETE FROM t4 WHERE i = sf1() + 1;

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -4967,8 +4643,6 @@

 SELECT sf1();

 sf1()

 0

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -4986,8 +4660,6 @@

 2	1

 3	3

 INSERT INTO t4 VALUES(sf1());

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -5008,9 +4680,6 @@

 3	3

 3	3

 UPDATE t4 SET i = sf1() + 1 WHERE i = sf1();

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -5037,8 +4706,6 @@

 3	3

 3	3

 DELETE FROM t4 WHERE i = sf1() + 1;

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -5104,8 +4771,6 @@

 SELECT sf1();

 sf1()

 0

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -5123,8 +4788,6 @@

 2	1

 3	3

 INSERT INTO t4 VALUES(sf1());

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -5145,9 +4808,6 @@

 3	3

 3	3

 UPDATE t4 SET i = sf1() + 1 WHERE i = sf1();

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -5174,8 +4834,6 @@

 3	3

 3	3

 DELETE FROM t4 WHERE i = sf1() + 1;

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -5241,8 +4899,6 @@

 SELECT sf1();

 sf1()

 0

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -5260,8 +4916,6 @@

 2	1

 3	3

 INSERT INTO t4 VALUES(sf1());

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -5282,9 +4936,6 @@

 3	3

 3	3

 UPDATE t4 SET i = sf1() + 1 WHERE i = sf1();

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -5311,8 +4962,6 @@

 3	3

 3	3

 DELETE FROM t4 WHERE i = sf1() + 1;

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -5378,8 +5027,6 @@

 SELECT sf1();

 sf1()

 0

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -5397,8 +5044,6 @@

 2	1

 3	3

 INSERT INTO t4 VALUES(sf1());

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -5419,9 +5064,6 @@

 3	3

 3	3

 UPDATE t4 SET i = sf1() + 1 WHERE i = sf1();

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -5448,8 +5090,6 @@

 3	3

 3	3

 DELETE FROM t4 WHERE i = sf1() + 1;

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -5515,8 +5155,6 @@

 SELECT sf1();

 sf1()

 0

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -5534,8 +5172,6 @@

 2	1

 3	3

 INSERT INTO t4 VALUES(sf1());

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -5556,9 +5192,6 @@

 3	3

 3	3

 UPDATE t4 SET i = sf1() + 1 WHERE i = sf1();

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -5585,8 +5218,6 @@

 3	3

 3	3

 DELETE FROM t4 WHERE i = sf1() + 1;

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -5652,8 +5283,6 @@

 SELECT sf1();

 sf1()

 0

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -5671,8 +5300,6 @@

 2	1

 3	3

 INSERT INTO t4 VALUES(sf1());

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -5693,9 +5320,6 @@

 3	3

 3	3

 UPDATE t4 SET i = sf1() + 1 WHERE i = sf1();

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -5722,8 +5346,6 @@

 3	3

 3	3

 DELETE FROM t4 WHERE i = sf1() + 1;

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -5789,8 +5411,6 @@

 SELECT sf1();

 sf1()

 0

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -5808,8 +5428,6 @@

 2	1

 3	3

 INSERT INTO t4 VALUES(sf1());

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -5830,9 +5448,6 @@

 3	3

 3	3

 UPDATE t4 SET i = sf1() + 1 WHERE i = sf1();

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -5859,8 +5474,6 @@

 3	3

 3	3

 DELETE FROM t4 WHERE i = sf1() + 1;

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -5926,8 +5539,6 @@

 SELECT sf1();

 sf1()

 0

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -5945,8 +5556,6 @@

 2	1

 3	3

 INSERT INTO t4 VALUES(sf1());

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -5967,9 +5576,6 @@

 3	3

 3	3

 UPDATE t4 SET i = sf1() + 1 WHERE i = sf1();

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -5996,8 +5602,6 @@

 3	3

 3	3

 DELETE FROM t4 WHERE i = sf1() + 1;

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -6063,8 +5667,6 @@

 SELECT sf1();

 sf1()

 0

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -6082,8 +5684,6 @@

 2	1

 3	3

 INSERT INTO t4 VALUES(sf1());

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -6104,9 +5704,6 @@

 3	3

 3	3

 UPDATE t4 SET i = sf1() + 1 WHERE i = sf1();

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -6133,8 +5730,6 @@

 3	3

 3	3

 DELETE FROM t4 WHERE i = sf1() + 1;

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -6200,8 +5795,6 @@

 SELECT sf1();

 sf1()

 0

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -6219,8 +5812,6 @@

 2	1

 3	3

 INSERT INTO t4 VALUES(sf1());

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -6241,9 +5832,6 @@

 3	3

 3	3

 UPDATE t4 SET i = sf1() + 1 WHERE i = sf1();

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -6270,8 +5858,6 @@

 3	3

 3	3

 DELETE FROM t4 WHERE i = sf1() + 1;

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -6337,8 +5923,6 @@

 SELECT sf1();

 sf1()

 0

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -6356,8 +5940,6 @@

 2	1

 3	3

 INSERT INTO t4 VALUES(sf1());

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -6378,9 +5960,6 @@

 3	3

 3	3

 UPDATE t4 SET i = sf1() + 1 WHERE i = sf1();

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -6407,8 +5986,6 @@

 3	3

 3	3

 DELETE FROM t4 WHERE i = sf1() + 1;

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -6474,8 +6051,6 @@

 SELECT sf1();

 sf1()

 0

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -6493,8 +6068,6 @@

 2	1

 3	3

 INSERT INTO t4 VALUES(sf1());

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -6515,9 +6088,6 @@

 3	3

 3	3

 UPDATE t4 SET i = sf1() + 1 WHERE i = sf1();

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -6544,8 +6114,6 @@

 3	3

 3	3

 DELETE FROM t4 WHERE i = sf1() + 1;

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -6611,8 +6179,6 @@

 SELECT sf1();

 sf1()

 0

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -6630,8 +6196,6 @@

 2	1

 3	3

 INSERT INTO t4 VALUES(sf1());

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed

 SELECT * FROM t1 ORDER BY id;

 id	data

 1	1

@@ -6652,9 +6216,6 @@

 3	3

 3	3

 UPDATE t4 SET i = sf1() + 1 WHERE i = sf1();

-Warnings:

-Error	1329	No data - zero rows fetched, selected, or processed