[MDEV-7255] Failures in engines/* and storage_engine/* tests - Jira

XML

Word

Printable

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Affects Version/s: 10.0(EOL), 10.1(EOL)
Fix Version/s: 10.0.16, 10.1.3
Component/s: Tests
Labels:
- tests

Description

10.1

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

same for col_opt_null, col_opt_unsigned, col_opt_zerofill, type_float, for all engines

10.0

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()

-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()

-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()

-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()

-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()

-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()

-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()

-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()

-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()

-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()

-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()

-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()

-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()

-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()

-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()

-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()

-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()

-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()

-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()

-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()

-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()

-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()

-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()

-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()

-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()

-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()

-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()

-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()

-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()

-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()

-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()

-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()

-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()

-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()

-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()

-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()

-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()

-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()

-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()

-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()

-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()

-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()

-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()

-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()

-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()

-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()

-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()

-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()

-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()

-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

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

 SELECT * FROM t1 ORDER BY id;

 id	data

1	1

@@ -6681,8 +6242,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

@@ -6748,8 +6307,6 @@

 SELECT sf1();

 sf1()

-Warnings:

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

 SELECT * FROM t1 ORDER BY id;

 id	data

1	1

@@ -6767,8 +6324,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

@@ -6789,9 +6344,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

@@ -6818,8 +6370,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

@@ -6885,8 +6435,6 @@

 SELECT sf1();

 sf1()

-Warnings:

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

 SELECT * FROM t1 ORDER BY id;

 id	data

1	1

@@ -6904,8 +6452,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

@@ -6926,9 +6472,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

@@ -6955,8 +6498,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

@@ -7022,8 +6563,6 @@

 SELECT sf1();

 sf1()

-Warnings:

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

 SELECT * FROM t1 ORDER BY id;

 id	data

1	1

@@ -7041,8 +6580,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

@@ -7063,9 +6600,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

@@ -7092,8 +6626,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

@@ -7159,8 +6691,6 @@

 SELECT sf1();

 sf1()

-Warnings:

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

 SELECT * FROM t1 ORDER BY id;

 id	data

1	1

@@ -7178,8 +6708,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

@@ -7200,9 +6728,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

@@ -7229,8 +6754,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

@@ -7296,8 +6819,6 @@

 SELECT sf1();

 sf1()

-Warnings:

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

 SELECT * FROM t1 ORDER BY id;

 id	data

1	1

@@ -7315,8 +6836,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

@@ -7337,9 +6856,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

@@ -7366,8 +6882,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

@@ -7433,8 +6947,6 @@

 SELECT sf1();

 sf1()

-Warnings:

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

 SELECT * FROM t1 ORDER BY id;

 id	data

1	1

@@ -7452,8 +6964,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

@@ -7474,9 +6984,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

@@ -7503,8 +7010,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

@@ -7570,8 +7075,6 @@

 SELECT sf1();

 sf1()

-Warnings:

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

 SELECT * FROM t1 ORDER BY id;

 id	data

1	1

@@ -7589,8 +7092,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

@@ -7611,9 +7112,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

@@ -7640,8 +7138,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

@@ -7707,8 +7203,6 @@

 SELECT sf1();

 sf1()

-Warnings:

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

 SELECT * FROM t1 ORDER BY id;

 id	data

1	1

@@ -7726,8 +7220,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

@@ -7748,9 +7240,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

@@ -7777,8 +7266,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

@@ -7844,8 +7331,6 @@

 SELECT sf1();

 sf1()

-Warnings:

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

 SELECT * FROM t1 ORDER BY id;

 id	data

1	1

@@ -7863,8 +7348,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

@@ -7885,9 +7368,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

@@ -7914,8 +7394,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

@@ -7981,8 +7459,6 @@

 SELECT sf1();

 sf1()

-Warnings:

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

 SELECT * FROM t1 ORDER BY id;

 id	data

1	1

@@ -8000,8 +7476,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

@@ -8022,9 +7496,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

@@ -8051,8 +7522,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

@@ -8118,8 +7587,6 @@

 SELECT sf1();

 sf1()

-Warnings:

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

 SELECT * FROM t1 ORDER BY id;

 id	data

1	1

@@ -8137,8 +7604,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

@@ -8159,9 +7624,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

@@ -8188,8 +7650,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

mysqltest: Result length mismatch

engines/funcs.sf_cursor                  [ fail ]

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

CURRENT_TEST: engines/funcs.sf_cursor

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

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

@@ -34,8 +34,6 @@

 SELECT sf1();

 sf1()

-Warnings:

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

 SELECT * FROM t1 ORDER BY id;

 id	data

1	1

@@ -53,8 +51,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

@@ -75,9 +71,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

@@ -104,8 +97,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

mysqltest: Result length mismatch

engines/funcs.sp_alter                   [ fail ]

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

CURRENT_TEST: engines/funcs.sp_alter

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

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

@@ -31,8 +31,6 @@

 END//

 ALTER PROCEDURE sp1    #DET#       ;

 CALL sp1();

-Warnings:

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

 SELECT * FROM t1 ORDER BY id;

 id	data

1	1

@@ -82,8 +80,6 @@

 END//

 ALTER PROCEDURE sp1    #DET# CONTAINS SQL     ;

 CALL sp1();

-Warnings:

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

 SELECT * FROM t1 ORDER BY id;

 id	data

1	1

@@ -133,8 +129,6 @@

 END//

 ALTER PROCEDURE sp1    #DET# NO SQL     ;

 CALL sp1();

-Warnings:

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

 SELECT * FROM t1 ORDER BY id;

 id	data

1	1

@@ -184,8 +178,6 @@

 END//

 ALTER PROCEDURE sp1    #DET# READS SQL DATA     ;

 CALL sp1();

-Warnings:

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

 SELECT * FROM t1 ORDER BY id;

 id	data

1	1

@@ -235,8 +227,6 @@

 END//

 ALTER PROCEDURE sp1    #DET# MODIFIES SQL DATA     ;

 CALL sp1();

-Warnings:

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

 SELECT * FROM t1 ORDER BY id;

 id	data

1	1

@@ -286,8 +276,6 @@

 END//

 ALTER PROCEDURE sp1    #DET#     COMMENT 'comment' ;

 CALL sp1();

-Warnings:

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

 SELECT * FROM t1 ORDER BY id;

 id	data

1	1

@@ -337,8 +325,6 @@

 END//

 ALTER PROCEDURE sp1    #DET# CONTAINS SQL   COMMENT 'comment' ;

 CALL sp1();

-Warnings:

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

 SELECT * FROM t1 ORDER BY id;

 id	data

1	1

@@ -388,8 +374,6 @@

 END//

 ALTER PROCEDURE sp1    #DET# NO SQL   COMMENT 'comment' ;

 CALL sp1();

-Warnings:

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

 SELECT * FROM t1 ORDER BY id;

 id	data

1	1

@@ -439,8 +423,6 @@

 END//

 ALTER PROCEDURE sp1    #DET# READS SQL DATA   COMMENT 'comment' ;

 CALL sp1();

-Warnings:

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

 SELECT * FROM t1 ORDER BY id;

 id	data

1	1

@@ -490,8 +472,6 @@

 END//

 ALTER PROCEDURE sp1    #DET# MODIFIES SQL DATA   COMMENT 'comment' ;

 CALL sp1();

-Warnings:

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

 SELECT * FROM t1 ORDER BY id;

 id	data

1	1

@@ -541,8 +521,6 @@

 END//

 ALTER PROCEDURE sp1  LANGUAGE SQL #DET#       ;

 CALL sp1();

-Warnings:

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

 SELECT * FROM t1 ORDER BY id;

 id	data

1	1

@@ -592,8 +570,6 @@

 END//

 ALTER PROCEDURE sp1  LANGUAGE SQL #DET# CONTAINS SQL     ;

 CALL sp1();

-Warnings:

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

 SELECT * FROM t1 ORDER BY id;

 id	data

1	1

@@ -643,8 +619,6 @@

 END//

 ALTER PROCEDURE sp1  LANGUAGE SQL #DET# NO SQL     ;

 CALL sp1();

-Warnings:

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

 SELECT * FROM t1 ORDER BY id;

 id	data

1	1

@@ -694,8 +668,6 @@

 END//

 ALTER PROCEDURE sp1  LANGUAGE SQL #DET# READS SQL DATA     ;

 CALL sp1();

-Warnings:

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

 SELECT * FROM t1 ORDER BY id;

 id	data

1	1

@@ -745,8 +717,6 @@

 END//

 ALTER PROCEDURE sp1  LANGUAGE SQL #DET# MODIFIES SQL DATA     ;

 CALL sp1();

-Warnings:

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

 SELECT * FROM t1 ORDER BY id;

 id	data

1	1

@@ -796,8 +766,6 @@

 END//

 ALTER PROCEDURE sp1  LANGUAGE SQL #DET#     COMMENT 'comment' ;

 CALL sp1();

-Warnings:

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

 SELECT * FROM t1 ORDER BY id;

 id	data

1	1

@@ -847,8 +815,6 @@

 END//

 ALTER PROCEDURE sp1  LANGUAGE SQL #DET# CONTAINS SQL   COMMENT 'comment' ;

 CALL sp1();

-Warnings:

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

 SELECT * FROM t1 ORDER BY id;

 id	data

1	1

@@ -898,8 +864,6 @@

 END//

 ALTER PROCEDURE sp1  LANGUAGE SQL #DET# NO SQL   COMMENT 'comment' ;

 CALL sp1();

-Warnings:

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

 SELECT * FROM t1 ORDER BY id;

 id	data

1	1

@@ -949,8 +913,6 @@

 END//

 ALTER PROCEDURE sp1  LANGUAGE SQL #DET# READS SQL DATA   COMMENT 'comment' ;

 CALL sp1();

-Warnings:

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

 SELECT * FROM t1 ORDER BY id;

 id	data

1	1

@@ -1000,8 +962,6 @@

 END//

 ALTER PROCEDURE sp1  LANGUAGE SQL #DET# MODIFIES SQL DATA   COMMENT 'comment' ;

 CALL sp1();

-Warnings:

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

 SELECT * FROM t1 ORDER BY id;

 id	data

1	1

@@ -1051,8 +1011,6 @@

 END//

 ALTER PROCEDURE sp1    #DET#   SQL SECURITY INVOKER   ;

 CALL sp1();

-Warnings:

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

 SELECT * FROM t1 ORDER BY id;

 id	data

1	1

@@ -1102,8 +1060,6 @@

 END//

 ALTER PROCEDURE sp1    #DET# CONTAINS SQL SQL SECURITY INVOKER   ;

 CALL sp1();

-Warnings:

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

 SELECT * FROM t1 ORDER BY id;

 id	data

1	1

@@ -1153,8 +1109,6 @@

 END//

 ALTER PROCEDURE sp1    #DET# NO SQL SQL SECURITY INVOKER   ;

 CALL sp1();

-Warnings:

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

 SELECT * FROM t1 ORDER BY id;

 id	data

1	1

@@ -1204,8 +1158,6 @@

 END//

 ALTER PROCEDURE sp1    #DET# READS SQL DATA SQL SECURITY INVOKER   ;

 CALL sp1();

-Warnings:

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

 SELECT * FROM t1 ORDER BY id;

 id	data

1	1

@@ -1255,8 +1207,6 @@

 END//

 ALTER PROCEDURE sp1    #DET# MODIFIES SQL DATA SQL SECURITY INVOKER   ;

 CALL sp1();

-Warnings:

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

 SELECT * FROM t1 ORDER BY id;

 id	data

1	1

@@ -1306,8 +1256,6 @@

 END//

 ALTER PROCEDURE sp1    #DET#   SQL SECURITY INVOKER COMMENT 'comment' ;

 CALL sp1();

-Warnings:

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

 SELECT * FROM t1 ORDER BY id;

 id	data

1	1

@@ -1357,8 +1305,6 @@

 END//

 ALTER PROCEDURE sp1    #DET# CONTAINS SQL SQL SECURITY INVOKER COMMENT 'comment' ;

 CALL sp1();

-Warnings:

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

 SELECT * FROM t1 ORDER BY id;

 id	data

1	1

@@ -1408,8 +1354,6 @@

 END//

 ALTER PROCEDURE sp1    #DET# NO SQL SQL SECURITY INVOKER COMMENT 'comment' ;

 CALL sp1();

-Warnings:

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

 SELECT * FROM t1 ORDER BY id;

 id	data

1	1

@@ -1459,8 +1403,6 @@

 END//

 ALTER PROCEDURE sp1    #DET# READS SQL DATA SQL SECURITY INVOKER COMMENT 'comment' ;

 CALL sp1();

-Warnings:

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

 SELECT * FROM t1 ORDER BY id;

 id	data

1	1

@@ -1510,8 +1452,6 @@

 END//

 ALTER PROCEDURE sp1    #DET# MODIFIES SQL DATA SQL SECURITY INVOKER COMMENT 'comment' ;

 CALL sp1();

-Warnings:

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

 SELECT * FROM t1 ORDER BY id;

 id	data

1	1

@@ -1561,8 +1501,6 @@

 END//

 ALTER PROCEDURE sp1  LANGUAGE SQL #DET#   SQL SECURITY INVOKER   ;

 CALL sp1();

-Warnings:

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

 SELECT * FROM t1 ORDER BY id;

 id	data

1	1

@@ -1612,8 +1550,6 @@

 END//

 ALTER PROCEDURE sp1  LANGUAGE SQL #DET# CONTAINS SQL SQL SECURITY INVOKER   ;

 CALL sp1();

-Warnings:

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

 SELECT * FROM t1 ORDER BY id;

 id	data

1	1

@@ -1663,8 +1599,6 @@

 END//

 ALTER PROCEDURE sp1  LANGUAGE SQL #DET# NO SQL SQL SECURITY INVOKER   ;

 CALL sp1();

-Warnings:

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

 SELECT * FROM t1 ORDER BY id;

 id	data

1	1

@@ -1714,8 +1648,6 @@

 END//

 ALTER PROCEDURE sp1  LANGUAGE SQL #DET# READS SQL DATA SQL SECURITY INVOKER   ;

 CALL sp1();

-Warnings:

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

 SELECT * FROM t1 ORDER BY id;

 id	data

1	1

@@ -1765,8 +1697,6 @@

 END//

 ALTER PROCEDURE sp1  LANGUAGE SQL #DET# MODIFIES SQL DATA SQL SECURITY INVOKER   ;

 CALL sp1();

-Warnings:

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

 SELECT * FROM t1 ORDER BY id;

 id	data

1	1

@@ -1816,8 +1746,6 @@

 END//

 ALTER PROCEDURE sp1  LANGUAGE SQL #DET#   SQL SECURITY INVOKER COMMENT 'comment' ;

 CALL sp1();

-Warnings:

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

 SELECT * FROM t1 ORDER BY id;

 id	data

1	1

@@ -1867,8 +1795,6 @@

 END//

 ALTER PROCEDURE sp1  LANGUAGE SQL #DET# CONTAINS SQL SQL SECURITY INVOKER COMMENT 'comment' ;

 CALL sp1();

-Warnings:

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

 SELECT * FROM t1 ORDER BY id;

 id	data

1	1

@@ -1918,8 +1844,6 @@

 END//

 ALTER PROCEDURE sp1  LANGUAGE SQL #DET# NO SQL SQL SECURITY INVOKER COMMENT 'comment' ;

 CALL sp1();

-Warnings:

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

 SELECT * FROM t1 ORDER BY id;

 id	data

1	1

@@ -1969,8 +1893,6 @@

 END//

 ALTER PROCEDURE sp1  LANGUAGE SQL #DET# READS SQL DATA SQL SECURITY INVOKER COMMENT 'comment' ;

 CALL sp1();

-Warnings:

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

 SELECT * FROM t1 ORDER BY id;

 id	data

1	1

@@ -2020,8 +1942,6 @@

 END//

 ALTER PROCEDURE sp1  LANGUAGE SQL #DET# MODIFIES SQL DATA SQL SECURITY INVOKER COMMENT 'comment' ;

 CALL sp1();

-Warnings:

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

 SELECT * FROM t1 ORDER BY id;

 id	data

1	1

@@ -2071,8 +1991,6 @@

 END//

 ALTER PROCEDURE sp1    #DET#    SQL SECURITY DEFINER   ;

 CALL sp1();

-Warnings:

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

 SELECT * FROM t1 ORDER BY id;

 id	data

1	1

@@ -2122,8 +2040,6 @@

 END//

 ALTER PROCEDURE sp1    #DET# CONTAINS SQL  SQL SECURITY DEFINER   ;

 CALL sp1();

-Warnings:

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

 SELECT * FROM t1 ORDER BY id;

 id	data

1	1

@@ -2173,8 +2089,6 @@

 END//

 ALTER PROCEDURE sp1    #DET# NO SQL  SQL SECURITY DEFINER   ;

 CALL sp1();

-Warnings:

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

 SELECT * FROM t1 ORDER BY id;

 id	data

1	1

@@ -2224,8 +2138,6 @@

 END//

 ALTER PROCEDURE sp1    #DET# READS SQL DATA  SQL SECURITY DEFINER   ;

 CALL sp1();

-Warnings:

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

 SELECT * FROM t1 ORDER BY id;

 id	data

1	1

@@ -2275,8 +2187,6 @@

 END//

 ALTER PROCEDURE sp1    #DET# MODIFIES SQL DATA  SQL SECURITY DEFINER   ;

 CALL sp1();

-Warnings:

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

 SELECT * FROM t1 ORDER BY id;

 id	data

1	1

@@ -2326,8 +2236,6 @@

 END//

 ALTER PROCEDURE sp1    #DET#    SQL SECURITY DEFINER COMMENT 'comment' ;

 CALL sp1();

-Warnings:

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

 SELECT * FROM t1 ORDER BY id;

 id	data

1	1

@@ -2377,8 +2285,6 @@

 END//

 ALTER PROCEDURE sp1    #DET# CONTAINS SQL  SQL SECURITY DEFINER COMMENT 'comment' ;

 CALL sp1();

-Warnings:

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

 SELECT * FROM t1 ORDER BY id;

 id	data

1	1

@@ -2428,8 +2334,6 @@

 END//

 ALTER PROCEDURE sp1    #DET# NO SQL  SQL SECURITY DEFINER COMMENT 'comment' ;

 CALL sp1();

-Warnings:

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

 SELECT * FROM t1 ORDER BY id;

 id	data

1	1

@@ -2479,8 +2383,6 @@

 END//

 ALTER PROCEDURE sp1    #DET# READS SQL DATA  SQL SECURITY DEFINER COMMENT 'comment' ;

 CALL sp1();

-Warnings:

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

 SELECT * FROM t1 ORDER BY id;

 id	data

1	1

@@ -2530,8 +2432,6 @@

 END//

 ALTER PROCEDURE sp1    #DET# MODIFIES SQL DATA  SQL SECURITY DEFINER COMMENT 'comment' ;

 CALL sp1();

-Warnings:

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

 SELECT * FROM t1 ORDER BY id;

 id	data

1	1

@@ -2581,8 +2481,6 @@

 END//

 ALTER PROCEDURE sp1  LANGUAGE SQL #DET#    SQL SECURITY DEFINER   ;

 CALL sp1();

-Warnings:

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

 SELECT * FROM t1 ORDER BY id;

 id	data

1	1

@@ -2632,8 +2530,6 @@

 END//

 ALTER PROCEDURE sp1  LANGUAGE SQL #DET# CONTAINS SQL  SQL SECURITY DEFINER   ;

 CALL sp1();

-Warnings:

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

 SELECT * FROM t1 ORDER BY id;

 id	data

1	1

@@ -2683,8 +2579,6 @@

 END//

 ALTER PROCEDURE sp1  LANGUAGE SQL #DET# NO SQL  SQL SECURITY DEFINER   ;

 CALL sp1();

-Warnings:

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

 SELECT * FROM t1 ORDER BY id;

 id	data

1	1

@@ -2734,8 +2628,6 @@

 END//

 ALTER PROCEDURE sp1  LANGUAGE SQL #DET# READS SQL DATA  SQL SECURITY DEFINER   ;

 CALL sp1();

-Warnings:

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

 SELECT * FROM t1 ORDER BY id;

 id	data

1	1

@@ -2785,8 +2677,6 @@

 END//

 ALTER PROCEDURE sp1  LANGUAGE SQL #DET# MODIFIES SQL DATA  SQL SECURITY DEFINER   ;

 CALL sp1();

-Warnings:

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

 SELECT * FROM t1 ORDER BY id;

 id	data

1	1

@@ -2836,8 +2726,6 @@

 END//

 ALTER PROCEDURE sp1  LANGUAGE SQL #DET#    SQL SECURITY DEFINER COMMENT 'comment' ;

 CALL sp1();

-Warnings:

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

 SELECT * FROM t1 ORDER BY id;

 id	data

1	1

@@ -2887,8 +2775,6 @@

 END//

 ALTER PROCEDURE sp1  LANGUAGE SQL #DET# CONTAINS SQL  SQL SECURITY DEFINER COMMENT 'comment' ;

 CALL sp1();

-Warnings:

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

 SELECT * FROM t1 ORDER BY id;

 id	data

1	1

@@ -2938,8 +2824,6 @@

 END//

 ALTER PROCEDURE sp1  LANGUAGE SQL #DET# NO SQL  SQL SECURITY DEFINER COMMENT 'comment' ;

 CALL sp1();

-Warnings:

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

 SELECT * FROM t1 ORDER BY id;

 id	data

1	1

@@ -2989,8 +2873,6 @@

 END//

 ALTER PROCEDURE sp1  LANGUAGE SQL #DET# READS SQL DATA  SQL SECURITY DEFINER COMMENT 'comment' ;

 CALL sp1();

-Warnings:

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

 SELECT * FROM t1 ORDER BY id;

 id	data

1	1

@@ -3040,8 +2922,6 @@

 END//

 ALTER PROCEDURE sp1  LANGUAGE SQL #DET# MODIFIES SQL DATA  SQL SECURITY DEFINER COMMENT 'comment' ;

 CALL sp1();

-Warnings:

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

 SELECT * FROM t1 ORDER BY id;

 id	data

1	1

mysqltest: Result length mismatch

engines/funcs.sp_cursor                  [ fail ]

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

CURRENT_TEST: engines/funcs.sp_cursor

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

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

@@ -30,8 +30,6 @@

 CLOSE cur2;

 END//

 CALL sp1();

-Warnings:

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

 SELECT * FROM t1 ORDER BY id;

 id	data

1	1

mysqltest: Result length mismatch

engines/funcs.sq_error                   [ fail ]

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

CURRENT_TEST: engines/funcs.sq_error

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

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

@@ -16,7 +16,7 @@

 ERROR 21000: Subquery returns more than 1 row

 UPDATE t1 SET c2 = (SELECT MAX(c1) FROM t2);

 UPDATE t1 SET c1 = (SELECT MAX(c1) FROM t1);

-ERROR HY000: You can't specify target table 't1' for update in FROM clause

+ERROR HY000: Table 't1' is specified twice, both as a target for 'UPDATE' and as a separate source for data

 DROP TABLE t1;

 DROP TABLE t2;

 CREATE TABLE t1 (c1 INT, c2 VARCHAR(100),c3 FLOAT);

@@ -35,7 +35,7 @@

 ERROR 21000: Subquery returns more than 1 row

 UPDATE t1 SET c2 = (SELECT MAX(c1) FROM t2);

 UPDATE t1 SET c1 = (SELECT MAX(c1) FROM t1);

-ERROR HY000: You can't specify target table 't1' for update in FROM clause

+ERROR HY000: Table 't1' is specified twice, both as a target for 'UPDATE' and as a separate source for data

 DROP TABLE t1;

 DROP TABLE t2;

 CREATE TABLE t1 (c1 INT, c2 BINARY(100),c3 FLOAT);

@@ -54,7 +54,7 @@

 ERROR 21000: Subquery returns more than 1 row

 UPDATE t1 SET c2 = (SELECT MAX(c1) FROM t2);

 UPDATE t1 SET c1 = (SELECT MAX(c1) FROM t1);

-ERROR HY000: You can't specify target table 't1' for update in FROM clause

+ERROR HY000: Table 't1' is specified twice, both as a target for 'UPDATE' and as a separate source for data

 DROP TABLE t1;

 DROP TABLE t2;

 CREATE TABLE t1 (c1 INT, c2 VARBINARY(100),c3 FLOAT);

@@ -73,6 +73,6 @@

 ERROR 21000: Subquery returns more than 1 row

 UPDATE t1 SET c2 = (SELECT MAX(c1) FROM t2);

 UPDATE t1 SET c1 = (SELECT MAX(c1) FROM t1);

-ERROR HY000: You can't specify target table 't1' for update in FROM clause

+ERROR HY000: Table 't1' is specified twice, both as a target for 'UPDATE' and as a separate source for data

 DROP TABLE t1;

 DROP TABLE t2;

mysqltest: Result length mismatch

engines/funcs.ta_rename                  [ fail ]

        Test ended at 2014-12-03 04:19:50

CURRENT_TEST: engines/funcs.ta_rename

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

+++ /data/repo/bzr/10.0/mysql-test/suite/engines/funcs/r/ta_rename.reject	2014-12-03 04:19:50.000000000 +0400

@@ -14,7 +14,7 @@

 Tables_in_test

t2

 DROP TABLE t1;

-ERROR 42S02: Unknown table 't1'

+ERROR 42S02: Unknown table 'test.t1'

 SHOW CREATE TABLE t2;

 Table	Create Table

 t2	CREATE TABLE `t2` (

@@ -39,7 +39,7 @@

 Tables_in_test

t2

 DROP TABLE t1;

-ERROR 42S02: Unknown table 't1'

+ERROR 42S02: Unknown table 'test.t1'

 SHOW CREATE TABLE t2;

 Table	Create Table

 t2	CREATE TABLE `t2` (

@@ -64,7 +64,7 @@

 Tables_in_test

t2

 DROP TABLE t1;

-ERROR 42S02: Unknown table 't1'

+ERROR 42S02: Unknown table 'test.t1'

 SHOW CREATE TABLE t2;

 Table	Create Table

 t2	CREATE TABLE `t2` (

@@ -89,7 +89,7 @@

 Tables_in_test

t2

 DROP TABLE t1;

-ERROR 42S02: Unknown table 't1'

+ERROR 42S02: Unknown table 'test.t1'

 SHOW CREATE TABLE t2;

 Table	Create Table

 t2	CREATE TABLE `t2` (

@@ -114,7 +114,7 @@

 Tables_in_test

t2

 DROP TABLE t1;

-ERROR 42S02: Unknown table 't1'

+ERROR 42S02: Unknown table 'test.t1'

 SHOW CREATE TABLE t2;

 Table	Create Table

 t2	CREATE TABLE `t2` (

@@ -139,7 +139,7 @@

 Tables_in_test

t2

 DROP TABLE t1;

-ERROR 42S02: Unknown table 't1'

+ERROR 42S02: Unknown table 'test.t1'

 SHOW CREATE TABLE t2;

 Table	Create Table

 t2	CREATE TABLE `t2` (

@@ -164,7 +164,7 @@

 Tables_in_test

t2

 DROP TABLE t1;

-ERROR 42S02: Unknown table 't1'

+ERROR 42S02: Unknown table 'test.t1'

 SHOW CREATE TABLE t2;

 Table	Create Table

 t2	CREATE TABLE `t2` (

@@ -189,7 +189,7 @@

 Tables_in_test

t2

 DROP TABLE t1;

-ERROR 42S02: Unknown table 't1'

+ERROR 42S02: Unknown table 'test.t1'

 SHOW CREATE TABLE t2;

 Table	Create Table

 t2	CREATE TABLE `t2` (

@@ -214,7 +214,7 @@

 Tables_in_test

t2

 DROP TABLE t1;

-ERROR 42S02: Unknown table 't1'

+ERROR 42S02: Unknown table 'test.t1'

 SHOW CREATE TABLE t2;

 Table	Create Table

 t2	CREATE TABLE `t2` (

@@ -239,7 +239,7 @@

 Tables_in_test

t2

 DROP TABLE t1;

-ERROR 42S02: Unknown table 't1'

+ERROR 42S02: Unknown table 'test.t1'

 SHOW CREATE TABLE t2;

 Table	Create Table

 t2	CREATE TABLE `t2` (

@@ -264,7 +264,7 @@

 Tables_in_test

t2

 DROP TABLE t1;

-ERROR 42S02: Unknown table 't1'

+ERROR 42S02: Unknown table 'test.t1'

 SHOW CREATE TABLE t2;

 Table	Create Table

 t2	CREATE TABLE `t2` (

@@ -289,7 +289,7 @@

 Tables_in_test

t2

 DROP TABLE t1;

-ERROR 42S02: Unknown table 't1'

+ERROR 42S02: Unknown table 'test.t1'

 SHOW CREATE TABLE t2;

 Table	Create Table

 t2	CREATE TABLE `t2` (

@@ -314,7 +314,7 @@

 Tables_in_test

t2

 DROP TABLE t1;

-ERROR 42S02: Unknown table 't1'

+ERROR 42S02: Unknown table 'test.t1'

 SHOW CREATE TABLE t2;

 Table	Create Table

 t2	CREATE TABLE `t2` (

@@ -339,7 +339,7 @@

 Tables_in_test

t2

 DROP TABLE t1;

-ERROR 42S02: Unknown table 't1'

+ERROR 42S02: Unknown table 'test.t1'

 SHOW CREATE TABLE t2;

 Table	Create Table

 t2	CREATE TABLE `t2` (

@@ -364,7 +364,7 @@

 Tables_in_test

t2

 DROP TABLE t1;

-ERROR 42S02: Unknown table 't1'

+ERROR 42S02: Unknown table 'test.t1'

 SHOW CREATE TABLE t2;

 Table	Create Table

 t2	CREATE TABLE `t2` (

@@ -389,7 +389,7 @@

 Tables_in_test

t2

 DROP TABLE t1;

-ERROR 42S02: Unknown table 't1'

+ERROR 42S02: Unknown table 'test.t1'

 SHOW CREATE TABLE t2;

 Table	Create Table

 t2	CREATE TABLE `t2` (

@@ -414,7 +414,7 @@

 Tables_in_test

t2

 DROP TABLE t1;

-ERROR 42S02: Unknown table 't1'

+ERROR 42S02: Unknown table 'test.t1'

 SHOW CREATE TABLE t2;

 Table	Create Table

 t2	CREATE TABLE `t2` (

@@ -439,7 +439,7 @@

 Tables_in_test

t2

 DROP TABLE t1;

-ERROR 42S02: Unknown table 't1'

+ERROR 42S02: Unknown table 'test.t1'

 SHOW CREATE TABLE t2;

 Table	Create Table

 t2	CREATE TABLE `t2` (

@@ -464,7 +464,7 @@

 Tables_in_test

t2

 DROP TABLE t1;

-ERROR 42S02: Unknown table 't1'

+ERROR 42S02: Unknown table 'test.t1'

 SHOW CREATE TABLE t2;

 Table	Create Table

 t2	CREATE TABLE `t2` (

@@ -489,7 +489,7 @@

 Tables_in_test

t2

 DROP TABLE t1;

-ERROR 42S02: Unknown table 't1'

+ERROR 42S02: Unknown table 'test.t1'

 SHOW CREATE TABLE t2;

 Table	Create Table

 t2	CREATE TABLE `t2` (

@@ -514,7 +514,7 @@

 Tables_in_test

t2

 DROP TABLE t1;

-ERROR 42S02: Unknown table 't1'

+ERROR 42S02: Unknown table 'test.t1'

 SHOW CREATE TABLE t2;

 Table	Create Table

 t2	CREATE TABLE `t2` (

@@ -539,7 +539,7 @@

 Tables_in_test

t2

 DROP TABLE t1;

-ERROR 42S02: Unknown table 't1'

+ERROR 42S02: Unknown table 'test.t1'

 SHOW CREATE TABLE t2;

 Table	Create Table

 t2	CREATE TABLE `t2` (

@@ -564,7 +564,7 @@

 Tables_in_test

t2

 DROP TABLE t1;

-ERROR 42S02: Unknown table 't1'

+ERROR 42S02: Unknown table 'test.t1'

 SHOW CREATE TABLE t2;

 Table	Create Table

 t2	CREATE TABLE `t2` (

@@ -589,7 +589,7 @@

 Tables_in_test

t2

 DROP TABLE t1;

-ERROR 42S02: Unknown table 't1'

+ERROR 42S02: Unknown table 'test.t1'

 SHOW CREATE TABLE t2;

 Table	Create Table

 t2	CREATE TABLE `t2` (

@@ -614,7 +614,7 @@

 Tables_in_test

t2

 DROP TABLE t1;

-ERROR 42S02: Unknown table 't1'

+ERROR 42S02: Unknown table 'test.t1'

 SHOW CREATE TABLE t2;

 Table	Create Table

 t2	CREATE TABLE `t2` (

@@ -639,7 +639,7 @@

 Tables_in_test

t2

 DROP TABLE t1;

-ERROR 42S02: Unknown table 't1'

+ERROR 42S02: Unknown table 'test.t1'

 SHOW CREATE TABLE t2;

 Table	Create Table

 t2	CREATE TABLE `t2` (

@@ -664,7 +664,7 @@

 Tables_in_test

t2

 DROP TABLE t1;

-ERROR 42S02: Unknown table 't1'

+ERROR 42S02: Unknown table 'test.t1'

 SHOW CREATE TABLE t2;

 Table	Create Table

 t2	CREATE TABLE `t2` (

@@ -689,7 +689,7 @@

 Tables_in_test

t2

 DROP TABLE t1;

-ERROR 42S02: Unknown table 't1'

+ERROR 42S02: Unknown table 'test.t1'

 SHOW CREATE TABLE t2;

 Table	Create Table

 t2	CREATE TABLE `t2` (

@@ -714,7 +714,7 @@

 Tables_in_test

t2

 DROP TABLE t1;

-ERROR 42S02: Unknown table 't1'

+ERROR 42S02: Unknown table 'test.t1'

 SHOW CREATE TABLE t2;

 Table	Create Table

 t2	CREATE TABLE `t2` (

@@ -739,7 +739,7 @@

 Tables_in_test

t2

 DROP TABLE t1;

-ERROR 42S02: Unknown table 't1'

+ERROR 42S02: Unknown table 'test.t1'

 SHOW CREATE TABLE t2;

 Table	Create Table

 t2	CREATE TABLE `t2` (

@@ -764,7 +764,7 @@

 Tables_in_test

t2

 DROP TABLE t1;

-ERROR 42S02: Unknown table 't1'

+ERROR 42S02: Unknown table 'test.t1'

 SHOW CREATE TABLE t2;

 Table	Create Table

 t2	CREATE TABLE `t2` (

@@ -789,7 +789,7 @@

 Tables_in_test

t2

 DROP TABLE t1;

-ERROR 42S02: Unknown table 't1'

+ERROR 42S02: Unknown table 'test.t1'

 SHOW CREATE TABLE t2;

 Table	Create Table

 t2	CREATE TABLE `t2` (

mysqltest: Result length mismatch

engines/funcs.tc_rename_error            [ fail ]

        Test ended at 2014-12-03 04:20:26

CURRENT_TEST: engines/funcs.tc_rename_error

mysqltest: At line 15: query 'RENAME TABLE t3 TO doesnotexist.t1' failed with wrong errno 1146: 'Table 'test.t3' doesn't exist', instead of 1017...

The result from queries just before the failure was:

DROP TABLE IF EXISTS t1,t2;

CREATE TABLE t1(c1 INTEGER NULL);

CREATE TABLE t2(c1 INTEGER NULL);

SHOW TABLES;

Tables_in_test

t1

t2

SHOW CREATE TABLE t1;

Table	Create Table

t1	CREATE TABLE `t1` (

  `c1` int(11) DEFAULT NULL

) ENGINE=ENGINE DEFAULT CHARSET=latin1

RENAME TABLE t2 TO t1;

ERROR 42S01: Table 't1' already exists

RENAME TABLE t3 TO t1;

ERROR 42S01: Table 't1' already exists

RENAME TABLE t3 TO doesnotexist.t1;

engines/iuds.strings_charsets_update_delete [ fail ]

        Test ended at 2014-12-03 04:20:51

CURRENT_TEST: engines/iuds.strings_charsets_update_delete

Binary files /data/repo/bzr/10.0/mysql-test/suite/engines/iuds/r/strings_charsets_update_delete.result and /data/repo/bzr/10.0/mysql-test/suite/engines/iuds/r/strings_charsets_update_delete.reject differ

The two files differ but it was not possible to execute 'diff' in

order to show only the difference. Instead the whole content of the

two files was shown for you to diff manually.

To get a better report you should install 'diff' on your system, which you

for example can get from http://www.gnu.org/software/diffutils/diffutils.html

 --- /data/repo/bzr/10.0/mysql-test/suite/engines/iuds/r/strings_charsets_update_delete.result >>>

DROP TABLE IF EXISTS t1,t2,t3,t4,t5,t6,t7,t8,t9,t10,t11,t12,t13,t14,t15,t16,t17,t18;

Warnings:

Note	1051	Unknown table 't1'

Note	1051	Unknown table 't2'

Note	1051	Unknown table 't3'

Note	1051	Unknown table 't4'

Note	1051	Unknown table 't5'

Note	1051	Unknown table 't6'

Note	1051	Unknown table 't7'

Note	1051	Unknown table 't8'

Note	1051	Unknown table 't9'

Note	1051	Unknown table 't10'

Note	1051	Unknown table 't11'

Note	1051	Unknown table 't12'

Note	1051	Unknown table 't13'

Note	1051	Unknown table 't14'

Note	1051	Unknown table 't15'

Note	1051	Unknown table 't16'

Note	1051	Unknown table 't17'

Note	1051	Unknown table 't18'

CREATE TABLE t5(c1 CHAR(1) CHARACTER SET latin1);

INSERT INTO t5 VALUES (0x00),(0x01),(0x02),(0x03),(0x04),(0x05),(0x06),(0x07);

INSERT INTO t5 VALUES (0x08),(0x09),(0x0A),(0x0B),(0x0C),(0x0D),(0x0E),(0x0F);

INSERT INTO t5 VALUES (0x10),(0x11),(0x12),(0x13),(0x14),(0x15),(0x16),(0x17);

INSERT INTO t5 VALUES (0x18),(0x19),(0x1A),(0x1B),(0x1C),(0x1D),(0x1E),(0x1F);

INSERT INTO t5 VALUES (0x20),(0x21),(0x22),(0x23),(0x24),(0x25),(0x26),(0x27);

INSERT INTO t5 VALUES (0x28),(0x29),(0x2A),(0x2B),(0x2C),(0x2D),(0x2E),(0x2F);

INSERT INTO t5 VALUES (0x30),(0x31),(0x32),(0x33),(0x34),(0x35),(0x36),(0x37);

INSERT INTO t5 VALUES (0x38),(0x39),(0x3A),(0x3B),(0x3C),(0x3D),(0x3E),(0x3F);

INSERT INTO t5 VALUES (0x40),(0x41),(0x42),(0x43),(0x44),(0x45),(0x46),(0x47);

INSERT INTO t5 VALUES (0x48),(0x49),(0x4A),(0x4B),(0x4C),(0x4D),(0x4E),(0x4F);

INSERT INTO t5 VALUES (0x50),(0x51),(0x52),(0x53),(0x54),(0x55),(0x56),(0x57);

INSERT INTO t5 VALUES (0x58),(0x59),(0x5A),(0x5B),(0x5C),(0x5D),(0x5E),(0x5F);

INSERT INTO t5 VALUES (0x60),(0x61),(0x62),(0x63),(0x64),(0x65),(0x66),(0x67);

INSERT INTO t5 VALUES (0x68),(0x69),(0x6A),(0x6B),(0x6C),(0x6D),(0x6E),(0x6F);

INSERT INTO t5 VALUES (0x70),(0x71),(0x72),(0x73),(0x74),(0x75),(0x76),(0x77);

INSERT INTO t5 VALUES (0x78),(0x79),(0x7A),(0x7B),(0x7C),(0x7D),(0x7E),(0x7F);

INSERT INTO t5 VALUES (0x80),(0x81),(0x82),(0x83),(0x84),(0x85),(0x86),(0x87);

INSERT INTO t5 VALUES (0x88),(0x89),(0x8A),(0x8B),(0x8C),(0x8D),(0x8E),(0x8F);

INSERT INTO t5 VALUES (0x90),(0x91),(0x92),(0x93),(0x94),(0x95),(0x96),(0x97);

INSERT INTO t5 VALUES (0x98),(0x99),(0x9A),(0x9B),(0x9C),(0x9D),(0x9E),(0x9F);

INSERT INTO t5 VALUES (0xA0),(0xA1),(0xA2),(0xA3),(0xA4),(0xA5),(0xA6),(0xA7);

INSERT INTO t5 VALUES (0xA8),(0xA9),(0xAA),(0xAB),(0xAC),(0xAD),(0xAE),(0xAF);

INSERT INTO t5 VALUES (0xB0),(0xB1),(0xB2),(0xB3),(0xB4),(0xB5),(0xB6),(0xB7);

INSERT INTO t5 VALUES (0xB8),(0xB9),(0xBA),(0xBB),(0xBC),(0xBD),(0xBE),(0xBF);

INSERT INTO t5 VALUES (0xC0),(0xC1),(0xC2),(0xC3),(0xC4),(0xC5),(0xC6),(0xC7);

INSERT INTO t5 VALUES (0xC8),(0xC9),(0xCA),(0xCB),(0xCC),(0xCD),(0xCE),(0xCF);

INSERT INTO t5 VALUES (0xD0),(0xD1),(0xD2),(0xD3),(0xD4),(0xD5),(0xD6),(0xD7);

INSERT INTO t5 VALUES (0xD8),(0xD9),(0xDA),(0xDB),(0xDC),(0xDD),(0xDE),(0xDF);

INSERT INTO t5 VALUES (0xE0),(0xE1),(0xE2),(0xE3),(0xE4),(0xE5),(0xE6),(0xE7);

INSERT INTO t5 VALUES (0xE8),(0xE9),(0xEA),(0xEB),(0xEC),(0xED),(0xEE),(0xEF);

INSERT INTO t5 VALUES (0xF0),(0xF1),(0xF2),(0xF3),(0xF4),(0xF5),(0xF6),(0xF7);

INSERT INTO t5 VALUES (0xF8),(0xF9),(0xFA),(0xFB),(0xFC),(0xFD),(0xFE),(0xFF);

SELECT c1 FROM t5;

c1

mysqltest: Result length mismatch

Warnings from just before the error:

Note 1051 Unknown table 'test.t1'

Note 1051 Unknown table 'test.t2'

Note 1051 Unknown table 'test.t3'

Note 1051 Unknown table 'test.t4'

Note 1051 Unknown table 'test.t8'

Note 1051 Unknown table 'test.t9'

Note 1051 Unknown table 'test.t10'

Note 1051 Unknown table 'test.t11'

Note 1051 Unknown table 'test.t12'

Note 1051 Unknown table 'test.t13'

Note 1051 Unknown table 'test.t14'

Note 1051 Unknown table 'test.t15'

Note 1051 Unknown table 'test.t16'

Note 1051 Unknown table 'test.t17'

engines/iuds.strings_update_delete       [ fail ]

        Test ended at 2014-12-03 04:20:59

CURRENT_TEST: engines/iuds.strings_update_delete

--- /data/repo/bzr/10.0/mysql-test/suite/engines/iuds/r/strings_update_delete.result	2014-11-12 04:27:00.000000000 +0300

+++ /data/repo/bzr/10.0/mysql-test/suite/engines/iuds/r/strings_update_delete.reject	2014-12-03 03:20:59.000000000 +0300

@@ -70471,17 +70471,17 @@

 DROP TABLE t17,t18;

 DROP TABLE IF EXISTS t1,t2,t3,t4,t5,t6,t7,t8,t9,t10,t11,t12,t13,t14,t15,t16,t17,t18;

 Warnings:

-Note	1051	Unknown table 't3'

-Note	1051	Unknown table 't4'

-Note	1051	Unknown table 't5'

-Note	1051	Unknown table 't6'

-Note	1051	Unknown table 't7'

-Note	1051	Unknown table 't8'

-Note	1051	Unknown table 't9'

-Note	1051	Unknown table 't10'

-Note	1051	Unknown table 't11'

-Note	1051	Unknown table 't13'

-Note	1051	Unknown table 't14'

-Note	1051	Unknown table 't15'

-Note	1051	Unknown table 't17'

-Note	1051	Unknown table 't18'

+Note	1051	Unknown table 'test.t3'

+Note	1051	Unknown table 'test.t4'

+Note	1051	Unknown table 'test.t5'

+Note	1051	Unknown table 'test.t6'

+Note	1051	Unknown table 'test.t7'

+Note	1051	Unknown table 'test.t8'

+Note	1051	Unknown table 'test.t9'

+Note	1051	Unknown table 'test.t10'

+Note	1051	Unknown table 'test.t11'

+Note	1051	Unknown table 'test.t13'

+Note	1051	Unknown table 'test.t14'

+Note	1051	Unknown table 'test.t15'

+Note	1051	Unknown table 'test.t17'

+Note	1051	Unknown table 'test.t18'

mysqltest: Result length mismatch

Warnings from just before the error:

Note 1051 Unknown table 'test.t3'

Note 1051 Unknown table 'test.t4'

Note 1051 Unknown table 'test.t5'

Note 1051 Unknown table 'test.t6'

Note 1051 Unknown table 'test.t7'

Note 1051 Unknown table 'test.t8'

Note 1051 Unknown table 'test.t9'

Note 1051 Unknown table 'test.t10'

Note 1051 Unknown table 'test.t11'

Note 1051 Unknown table 'test.t13'

Note 1051 Unknown table 'test.t14'

Note 1051 Unknown table 'test.t15'

Note 1051 Unknown table 'test.t17'

engines/iuds.type_bit_iuds               [ fail ]

        Test ended at 2014-12-03 04:21:22

CURRENT_TEST: engines/iuds.type_bit_iuds

--- /data/repo/bzr/10.0/mysql-test/suite/engines/iuds/r/type_bit_iuds.result	2014-11-12 04:27:00.000000000 +0300

+++ /data/repo/bzr/10.0/mysql-test/suite/engines/iuds/r/type_bit_iuds.reject	2014-12-03 03:21:22.000000000 +0300

@@ -780,7 +780,7 @@

 DELETE t5,t6 FROM t5,t6 WHERE  t5.c1=t6.c1 AND t5.c2=t6.c2;

 DROP TABLE IF EXISTS t1,t2,t3,t4,t5,t6,t7;

 Warnings:

-Note	1051	Unknown table 't3'

+Note	1051	Unknown table 'test.t3'

 SELECT 0 + b'0';

 0 + b'0'

@@ -1611,7 +1611,7 @@

 DELETE t5,t6 FROM t5,t6 WHERE  t5.c1=t6.c1 AND t5.c2=t6.c2;

 DROP TABLE IF EXISTS t1,t2,t3,t4,t5,t6,t7;

 Warnings:

-Note	1051	Unknown table 't3'

+Note	1051	Unknown table 'test.t3'

 SELECT 0 + b'0';

 0 + b'0'

@@ -2461,7 +2461,7 @@

 DELETE t5,t6 FROM t5,t6 WHERE  t5.c1=t6.c1 AND t5.c2=t6.c2;

 DROP TABLE IF EXISTS t1,t2,t3,t4,t5,t6,t7;

 Warnings:

-Note	1051	Unknown table 't3'

+Note	1051	Unknown table 'test.t3'

 SELECT 0 + b'0';

 0 + b'0'

@@ -3375,7 +3375,7 @@

 DELETE t5,t6 FROM t5,t6 WHERE  t5.c1=t6.c1 AND t5.c2=t6.c2;

 DROP TABLE IF EXISTS t1,t2,t3,t4,t5,t6,t7;

 Warnings:

-Note	1051	Unknown table 't3'

+Note	1051	Unknown table 'test.t3'

 SELECT 0 + b'0';

 0 + b'0'

@@ -4574,7 +4574,7 @@

 DELETE t5,t6 FROM t5,t6 WHERE  t5.c1=t6.c1 AND t5.c2=t6.c2;

 DROP TABLE IF EXISTS t1,t2,t3,t4,t5,t6,t7;

 Warnings:

-Note	1051	Unknown table 't3'

+Note	1051	Unknown table 'test.t3'

 SELECT 0 + b'0';

 0 + b'0'

@@ -5978,7 +5978,7 @@

 DELETE t5,t6 FROM t5,t6 WHERE  t5.c1=t6.c1 AND t5.c2=t6.c2;

 DROP TABLE IF EXISTS t1,t2,t3,t4,t5,t6,t7;

 Warnings:

-Note	1051	Unknown table 't3'

+Note	1051	Unknown table 'test.t3'

 SELECT 0 + b'0';

 0 + b'0'

@@ -8049,7 +8049,7 @@

 DELETE t5,t6 FROM t5,t6 WHERE  t5.c1=t6.c1 AND t5.c2=t6.c2;

 DROP TABLE IF EXISTS t1,t2,t3,t4,t5,t6,t7;

 Warnings:

-Note	1051	Unknown table 't3'

+Note	1051	Unknown table 'test.t3'

 SELECT 0 + b'0';

 0 + b'0'

@@ -11227,7 +11227,7 @@

 DELETE t5,t6 FROM t5,t6 WHERE  t5.c1=t6.c1 AND t5.c2=t6.c2;

 DROP TABLE IF EXISTS t1,t2,t3,t4,t5,t6,t7;

 Warnings:

-Note	1051	Unknown table 't3'

+Note	1051	Unknown table 'test.t3'

 SELECT 0 + b'1';

 0 + b'1'

@@ -12009,7 +12009,7 @@

 DELETE t5,t6 FROM t5,t6 WHERE  t5.c1=t6.c1 AND t5.c2=t6.c2;

 DROP TABLE IF EXISTS t1,t2,t3,t4,t5,t6,t7;

 Warnings:

-Note	1051	Unknown table 't3'

+Note	1051	Unknown table 'test.t3'

 SELECT 0 + b'1';

 0 + b'1'

@@ -12840,7 +12840,7 @@

 DELETE t5,t6 FROM t5,t6 WHERE  t5.c1=t6.c1 AND t5.c2=t6.c2;

 DROP TABLE IF EXISTS t1,t2,t3,t4,t5,t6,t7;

 Warnings:

-Note	1051	Unknown table 't3'

+Note	1051	Unknown table 'test.t3'

 SELECT 0 + b'1';

 0 + b'1'

@@ -13690,7 +13690,7 @@

 DELETE t5,t6 FROM t5,t6 WHERE  t5.c1=t6.c1 AND t5.c2=t6.c2;

 DROP TABLE IF EXISTS t1,t2,t3,t4,t5,t6,t7;

 Warnings:

-Note	1051	Unknown table 't3'

+Note	1051	Unknown table 'test.t3'

 SELECT 0 + b'1';

 0 + b'1'

@@ -14604,7 +14604,7 @@

 DELETE t5,t6 FROM t5,t6 WHERE  t5.c1=t6.c1 AND t5.c2=t6.c2;

 DROP TABLE IF EXISTS t1,t2,t3,t4,t5,t6,t7;

 Warnings:

-Note	1051	Unknown table 't3'

+Note	1051	Unknown table 'test.t3'

 SELECT 0 + b'1';

 0 + b'1'

@@ -15803,7 +15803,7 @@

 DELETE t5,t6 FROM t5,t6 WHERE  t5.c1=t6.c1 AND t5.c2=t6.c2;

 DROP TABLE IF EXISTS t1,t2,t3,t4,t5,t6,t7;

 Warnings:

-Note	1051	Unknown table 't3'

+Note	1051	Unknown table 'test.t3'

 SELECT 0 + b'1';

 0 + b'1'

@@ -17207,7 +17207,7 @@

 DELETE t5,t6 FROM t5,t6 WHERE  t5.c1=t6.c1 AND t5.c2=t6.c2;

 DROP TABLE IF EXISTS t1,t2,t3,t4,t5,t6,t7;

 Warnings:

-Note	1051	Unknown table 't3'

+Note	1051	Unknown table 'test.t3'

 SELECT 0 + b'1';

 0 + b'1'

@@ -19278,7 +19278,7 @@

 DELETE t5,t6 FROM t5,t6 WHERE  t5.c1=t6.c1 AND t5.c2=t6.c2;

 DROP TABLE IF EXISTS t1,t2,t3,t4,t5,t6,t7;

 Warnings:

-Note	1051	Unknown table 't3'

+Note	1051	Unknown table 'test.t3'

 SELECT 0 + b'1';

 0 + b'1'

@@ -22456,7 +22456,7 @@

 DELETE t5,t6 FROM t5,t6 WHERE  t5.c1=t6.c1 AND t5.c2=t6.c2;

 DROP TABLE IF EXISTS t1,t2,t3,t4,t5,t6,t7;

 Warnings:

-Note	1051	Unknown table 't3'

+Note	1051	Unknown table 'test.t3'

 SELECT 0 + b'10';

 0 + b'10'

@@ -23244,7 +23244,7 @@

 DELETE t5,t6 FROM t5,t6 WHERE  t5.c1=t6.c1 AND t5.c2=t6.c2;

 DROP TABLE IF EXISTS t1,t2,t3,t4,t5,t6,t7;

 Warnings:

-Note	1051	Unknown table 't3'

+Note	1051	Unknown table 'test.t3'

 SELECT 0 + b'10';

 0 + b'10'

@@ -24081,7 +24081,7 @@

 DELETE t5,t6 FROM t5,t6 WHERE  t5.c1=t6.c1 AND t5.c2=t6.c2;

 DROP TABLE IF EXISTS t1,t2,t3,t4,t5,t6,t7;

 Warnings:

-Note	1051	Unknown table 't3'

+Note	1051	Unknown table 'test.t3'

 SELECT 0 + b'10';

 0 + b'10'

@@ -24931,7 +24931,7 @@

 DELETE t5,t6 FROM t5,t6 WHERE  t5.c1=t6.c1 AND t5.c2=t6.c2;

 DROP TABLE IF EXISTS t1,t2,t3,t4,t5,t6,t7;

 Warnings:

-Note	1051	Unknown table 't3'

+Note	1051	Unknown table 'test.t3'

 SELECT 0 + b'10';

 0 + b'10'

@@ -25845,7 +25845,7 @@

 DELETE t5,t6 FROM t5,t6 WHERE  t5.c1=t6.c1 AND t5.c2=t6.c2;

 DROP TABLE IF EXISTS t1,t2,t3,t4,t5,t6,t7;

 Warnings:

-Note	1051	Unknown table 't3'

+Note	1051	Unknown table 'test.t3'

 SELECT 0 + b'10';

 0 + b'10'

@@ -27044,7 +27044,7 @@

 DELETE t5,t6 FROM t5,t6 WHERE  t5.c1=t6.c1 AND t5.c2=t6.c2;

 DROP TABLE IF EXISTS t1,t2,t3,t4,t5,t6,t7;

 Warnings:

-Note	1051	Unknown table 't3'

+Note	1051	Unknown table 'test.t3'

 SELECT 0 + b'10';

 0 + b'10'

@@ -28448,7 +28448,7 @@

 DELETE t5,t6 FROM t5,t6 WHERE  t5.c1=t6.c1 AND t5.c2=t6.c2;

 DROP TABLE IF EXISTS t1,t2,t3,t4,t5,t6,t7;

 Warnings:

-Note	1051	Unknown table 't3'

+Note	1051	Unknown table 'test.t3'

 SELECT 0 + b'10';

 0 + b'10'

@@ -30519,7 +30519,7 @@

 DELETE t5,t6 FROM t5,t6 WHERE  t5.c1=t6.c1 AND t5.c2=t6.c2;

 DROP TABLE IF EXISTS t1,t2,t3,t4,t5,t6,t7;

 Warnings:

-Note	1051	Unknown table 't3'

+Note	1051	Unknown table 'test.t3'

 SELECT 0 + b'10';

 0 + b'10'

@@ -33697,7 +33697,7 @@

 DELETE t5,t6 FROM t5,t6 WHERE  t5.c1=t6.c1 AND t5.c2=t6.c2;

 DROP TABLE IF EXISTS t1,t2,t3,t4,t5,t6,t7;

 Warnings:

-Note	1051	Unknown table 't3'

+Note	1051	Unknown table 'test.t3'

 SELECT 0 + b'1010';

 0 + b'1010'

@@ -34485,7 +34485,7 @@

 DELETE t5,t6 FROM t5,t6 WHERE  t5.c1=t6.c1 AND t5.c2=t6.c2;

 DROP TABLE IF EXISTS t1,t2,t3,t4,t5,t6,t7;

 Warnings:

-Note	1051	Unknown table 't3'

+Note	1051	Unknown table 'test.t3'

 SELECT 0 + b'1010';

 0 + b'1010'

@@ -35322,7 +35322,7 @@

 DELETE t5,t6 FROM t5,t6 WHERE  t5.c1=t6.c1 AND t5.c2=t6.c2;

 DROP TABLE IF EXISTS t1,t2,t3,t4,t5,t6,t7;

 Warnings:

-Note	1051	Unknown table 't3'

+Note	1051	Unknown table 'test.t3'

 SELECT 0 + b'1010';

 0 + b'1010'

@@ -36178,7 +36178,7 @@

 DELETE t5,t6 FROM t5,t6 WHERE  t5.c1=t6.c1 AND t5.c2=t6.c2;

 DROP TABLE IF EXISTS t1,t2,t3,t4,t5,t6,t7;

 Warnings:

-Note	1051	Unknown table 't3'

+Note	1051	Unknown table 'test.t3'

 SELECT 0 + b'1010';

 0 + b'1010'

@@ -37092,7 +37092,7 @@

 DELETE t5,t6 FROM t5,t6 WHERE  t5.c1=t6.c1 AND t5.c2=t6.c2;

 DROP TABLE IF EXISTS t1,t2,t3,t4,t5,t6,t7;

 Warnings:

-Note	1051	Unknown table 't3'

+Note	1051	Unknown table 'test.t3'

 SELECT 0 + b'1010';

 0 + b'1010'

@@ -38291,7 +38291,7 @@

 DELETE t5,t6 FROM t5,t6 WHERE  t5.c1=t6.c1 AND t5.c2=t6.c2;

 DROP TABLE IF EXISTS t1,t2,t3,t4,t5,t6,t7;

 Warnings:

-Note	1051	Unknown table 't3'

+Note	1051	Unknown table 'test.t3'

 SELECT 0 + b'1010';

 0 + b'1010'

@@ -39695,7 +39695,7 @@

 DELETE t5,t6 FROM t5,t6 WHERE  t5.c1=t6.c1 AND t5.c2=t6.c2;

 DROP TABLE IF EXISTS t1,t2,t3,t4,t5,t6,t7;

 Warnings:

-Note	1051	Unknown table 't3'

+Note	1051	Unknown table 'test.t3'

 SELECT 0 + b'1010';

 0 + b'1010'

@@ -41766,7 +41766,7 @@

 DELETE t5,t6 FROM t5,t6 WHERE  t5.c1=t6.c1 AND t5.c2=t6.c2;

 DROP TABLE IF EXISTS t1,t2,t3,t4,t5,t6,t7;

 Warnings:

-Note	1051	Unknown table 't3'

+Note	1051	Unknown table 'test.t3'

 SELECT 0 + b'1010';

 0 + b'1010'

@@ -44944,7 +44944,7 @@

 DELETE t5,t6 FROM t5,t6 WHERE  t5.c1=t6.c1 AND t5.c2=t6.c2;

 DROP TABLE IF EXISTS t1,t2,t3,t4,t5,t6,t7;

 Warnings:

-Note	1051	Unknown table 't3'

+Note	1051	Unknown table 'test.t3'

 SELECT 0 + b'1010101010101010';

 0 + b'1010101010101010'

@@ -45732,7 +45732,7 @@

 DELETE t5,t6 FROM t5,t6 WHERE  t5.c1=t6.c1 AND t5.c2=t6.c2;

 DROP TABLE IF EXISTS t1,t2,t3,t4,t5,t6,t7;

 Warnings:

-Note	1051	Unknown table 't3'

+Note	1051	Unknown table 'test.t3'

 SELECT 0 + b'1010101010101010';

 0 + b'1010101010101010'

@@ -46569,7 +46569,7 @@

 DELETE t5,t6 FROM t5,t6 WHERE  t5.c1=t6.c1 AND t5.c2=t6.c2;

 DROP TABLE IF EXISTS t1,t2,t3,t4,t5,t6,t7;

 Warnings:

-Note	1051	Unknown table 't3'

+Note	1051	Unknown table 'test.t3'

 SELECT 0 + b'1010101010101010';

 0 + b'1010101010101010'

@@ -47425,7 +47425,7 @@

 DELETE t5,t6 FROM t5,t6 WHERE  t5.c1=t6.c1 AND t5.c2=t6.c2;

 DROP TABLE IF EXISTS t1,t2,t3,t4,t5,t6,t7;

 Warnings:

-Note	1051	Unknown table 't3'

+Note	1051	Unknown table 'test.t3'

 SELECT 0 + b'1010101010101010';

 0 + b'1010101010101010'

@@ -48345,7 +48345,7 @@

 DELETE t5,t6 FROM t5,t6 WHERE  t5.c1=t6.c1 AND t5.c2=t6.c2;

 DROP TABLE IF EXISTS t1,t2,t3,t4,t5,t6,t7;

 Warnings:

-Note	1051	Unknown table 't3'

+Note	1051	Unknown table 'test.t3'

 SELECT 0 + b'1010101010101010';

 0 + b'1010101010101010'

@@ -49550,7 +49550,7 @@

 DELETE t5,t6 FROM t5,t6 WHERE  t5.c1=t6.c1 AND t5.c2=t6.c2;

 DROP TABLE IF EXISTS t1,t2,t3,t4,t5,t6,t7;

 Warnings:

-Note	1051	Unknown table 't3'

+Note	1051	Unknown table 'test.t3'

 SELECT 0 + b'1010101010101010';

 0 + b'1010101010101010'

@@ -50954,7 +50954,7 @@

 DELETE t5,t6 FROM t5,t6 WHERE  t5.c1=t6.c1 AND t5.c2=t6.c2;

 DROP TABLE IF EXISTS t1,t2,t3,t4,t5,t6,t7;

 Warnings:

-Note	1051	Unknown table 't3'

+Note	1051	Unknown table 'test.t3'

 SELECT 0 + b'1010101010101010';

 0 + b'1010101010101010'

@@ -53025,7 +53025,7 @@

 DELETE t5,t6 FROM t5,t6 WHERE  t5.c1=t6.c1 AND t5.c2=t6.c2;

 DROP TABLE IF EXISTS t1,t2,t3,t4,t5,t6,t7;

 Warnings:

-Note	1051	Unknown table 't3'

+Note	1051	Unknown table 'test.t3'

 SELECT 0 + b'1010101010101010';

 0 + b'1010101010101010'

@@ -56203,7 +56203,7 @@

 DELETE t5,t6 FROM t5,t6 WHERE  t5.c1=t6.c1 AND t5.c2=t6.c2;

 DROP TABLE IF EXISTS t1,t2,t3,t4,t5,t6,t7;

 Warnings:

-Note	1051	Unknown table 't3'

+Note	1051	Unknown table 'test.t3'

 SELECT 0 + b'101010101010101010101010101010';

 0 + b'101010101010101010101010101010'

715827882

@@ -56993,7 +56993,7 @@

 DELETE t5,t6 FROM t5,t6 WHERE  t5.c1=t6.c1 AND t5.c2=t6.c2;

 DROP TABLE IF EXISTS t1,t2,t3,t4,t5,t6,t7;

 Warnings:

-Note	1051	Unknown table 't3'

+Note	1051	Unknown table 'test.t3'

 SELECT 0 + b'101010101010101010101010101010';

 0 + b'101010101010101010101010101010'

715827882

@@ -57832,7 +57832,7 @@

 DELETE t5,t6 FROM t5,t6 WHERE  t5.c1=t6.c1 AND t5.c2=t6.c2;

 DROP TABLE IF EXISTS t1,t2,t3,t4,t5,t6,t7;

 Warnings:

-Note	1051	Unknown table 't3'

+Note	1051	Unknown table 'test.t3'

 SELECT 0 + b'101010101010101010101010101010';

 0 + b'101010101010101010101010101010'

715827882

@@ -58690,7 +58690,7 @@

 DELETE t5,t6 FROM t5,t6 WHERE  t5.c1=t6.c1 AND t5.c2=t6.c2;

 DROP TABLE IF EXISTS t1,t2,t3,t4,t5,t6,t7;

 Warnings:

-Note	1051	Unknown table 't3'

+Note	1051	Unknown table 'test.t3'

 SELECT 0 + b'101010101010101010101010101010';

 0 + b'101010101010101010101010101010'

715827882

@@ -59612,7 +59612,7 @@

 DELETE t5,t6 FROM t5,t6 WHERE  t5.c1=t6.c1 AND t5.c2=t6.c2;

 DROP TABLE IF EXISTS t1,t2,t3,t4,t5,t6,t7;

 Warnings:

-Note	1051	Unknown table 't3'

+Note	1051	Unknown table 'test.t3'

 SELECT 0 + b'101010101010101010101010101010';

 0 + b'101010101010101010101010101010'

715827882

@@ -60819,7 +60819,7 @@

 DELETE t5,t6 FROM t5,t6 WHERE  t5.c1=t6.c1 AND t5.c2=t6.c2;

 DROP TABLE IF EXISTS t1,t2,t3,t4,t5,t6,t7;

 Warnings:

-Note	1051	Unknown table 't3'

+Note	1051	Unknown table 'test.t3'

 SELECT 0 + b'101010101010101010101010101010';

 0 + b'101010101010101010101010101010'

715827882

@@ -62231,7 +62231,7 @@

 DELETE t5,t6 FROM t5,t6 WHERE  t5.c1=t6.c1 AND t5.c2=t6.c2;

 DROP TABLE IF EXISTS t1,t2,t3,t4,t5,t6,t7;

 Warnings:

-Note	1051	Unknown table 't3'

+Note	1051	Unknown table 'test.t3'

 SELECT 0 + b'101010101010101010101010101010';

 0 + b'101010101010101010101010101010'

715827882

@@ -64304,7 +64304,7 @@

 DELETE t5,t6 FROM t5,t6 WHERE  t5.c1=t6.c1 AND t5.c2=t6.c2;

 DROP TABLE IF EXISTS t1,t2,t3,t4,t5,t6,t7;

 Warnings:

-Note	1051	Unknown table 't3'

+Note	1051	Unknown table 'test.t3'

 SELECT 0 + b'101010101010101010101010101010';

 0 + b'101010101010101010101010101010'

715827882

@@ -67484,7 +67484,7 @@

 DELETE t5,t6 FROM t5,t6 WHERE  t5.c1=t6.c1 AND t5.c2=t6.c2;

 DROP TABLE IF EXISTS t1,t2,t3,t4,t5,t6,t7;

 Warnings:

-Note	1051	Unknown table 't3'

+Note	1051	Unknown table 'test.t3'

 SELECT 0 + (1010101010101010101010101010101010101010101010101010101010101010<<0);

 0 + (1010101010101010101010101010101010101010101010101010101010101010<<0)

 9223372036854775807

@@ -68271,7 +68271,7 @@

 DELETE t5,t6 FROM t5,t6 WHERE  t5.c1=t6.c1 AND t5.c2=t6.c2;

 DROP TABLE IF EXISTS t1,t2,t3,t4,t5,t6,t7;

 Warnings:

-Note	1051	Unknown table 't3'

+Note	1051	Unknown table 'test.t3'

 SELECT 0 + (1010101010101010101010101010101010101010101010101010101010101010<<1);

 0 + (1010101010101010101010101010101010101010101010101010101010101010<<1)

 18446744073709551614

@@ -69107,7 +69107,7 @@

 DELETE t5,t6 FROM t5,t6 WHERE  t5.c1=t6.c1 AND t5.c2=t6.c2;

 DROP TABLE IF EXISTS t1,t2,t3,t4,t5,t6,t7;

 Warnings:

-Note	1051	Unknown table 't3'

+Note	1051	Unknown table 'test.t3'

 SELECT 0 + (1010101010101010101010101010101010101010101010101010101010101010<<2);

 0 + (1010101010101010101010101010101010101010101010101010101010101010<<2)

 18446744073709551612

@@ -69962,7 +69962,7 @@

 DELETE t5,t6 FROM t5,t6 WHERE  t5.c1=t6.c1 AND t5.c2=t6.c2;

 DROP TABLE IF EXISTS t1,t2,t3,t4,t5,t6,t7;

 Warnings:

-Note	1051	Unknown table 't3'

+Note	1051	Unknown table 'test.t3'

 SELECT 0 + (1010101010101010101010101010101010101010101010101010101010101010<<4);

 0 + (1010101010101010101010101010101010101010101010101010101010101010<<4)

 18446744073709551600

@@ -70881,7 +70881,7 @@

 DELETE t5,t6 FROM t5,t6 WHERE  t5.c1=t6.c1 AND t5.c2=t6.c2;

 DROP TABLE IF EXISTS t1,t2,t3,t4,t5,t6,t7;

 Warnings:

-Note	1051	Unknown table 't3'

+Note	1051	Unknown table 'test.t3'

 SELECT 0 + (1010101010101010101010101010101010101010101010101010101010101010<<8);

 0 + (1010101010101010101010101010101010101010101010101010101010101010<<8)

 18446744073709551360

@@ -72085,7 +72085,7 @@

 DELETE t5,t6 FROM t5,t6 WHERE  t5.c1=t6.c1 AND t5.c2=t6.c2;

 DROP TABLE IF EXISTS t1,t2,t3,t4,t5,t6,t7;

 Warnings:

-Note	1051	Unknown table 't3'

+Note	1051	Unknown table 'test.t3'

 SELECT 0 + (1010101010101010101010101010101010101010101010101010101010101010<<16);

 0 + (1010101010101010101010101010101010101010101010101010101010101010<<16)

 18446744073709486080

@@ -73494,7 +73494,7 @@

 DELETE t5,t6 FROM t5,t6 WHERE  t5.c1=t6.c1 AND t5.c2=t6.c2;

 DROP TABLE IF EXISTS t1,t2,t3,t4,t5,t6,t7;

 Warnings:

-Note	1051	Unknown table 't3'

+Note	1051	Unknown table 'test.t3'

 SELECT 0 + (1010101010101010101010101010101010101010101010101010101010101010<<32);

 0 + (1010101010101010101010101010101010101010101010101010101010101010<<32)

 18446744069414584320

@@ -75570,7 +75570,7 @@

 DELETE t5,t6 FROM t5,t6 WHERE  t5.c1=t6.c1 AND t5.c2=t6.c2;

 DROP TABLE IF EXISTS t1,t2,t3,t4,t5,t6,t7;

 Warnings:

-Note	1051	Unknown table 't3'

+Note	1051	Unknown table 'test.t3'

 SELECT 0 + (1010101010101010101010101010101010101010101010101010101010101010<<64);

 0 + (1010101010101010101010101010101010101010101010101010101010101010<<64)

@@ -78747,7 +78747,7 @@

 DELETE t5,t6 FROM t5,t6 WHERE  t5.c1=t6.c1 AND t5.c2=t6.c2;

 DROP TABLE IF EXISTS t1,t2,t3,t4,t5,t6,t7;

 Warnings:

-Note	1051	Unknown table 't3'

+Note	1051	Unknown table 'test.t3'

 SELECT 0 + (10101010101010101010101010101010101010101010101010101010101010101<<0);

 0 + (10101010101010101010101010101010101010101010101010101010101010101<<0)

 9223372036854775807

@@ -79534,7 +79534,7 @@

 DELETE t5,t6 FROM t5,t6 WHERE  t5.c1=t6.c1 AND t5.c2=t6.c2;

 DROP TABLE IF EXISTS t1,t2,t3,t4,t5,t6,t7;

 Warnings:

-Note	1051	Unknown table 't3'

+Note	1051	Unknown table 'test.t3'

 SELECT 0 + (10101010101010101010101010101010101010101010101010101010101010101<<1);

 0 + (10101010101010101010101010101010101010101010101010101010101010101<<1)

 18446744073709551614

@@ -80370,7 +80370,7 @@

 DELETE t5,t6 FROM t5,t6 WHERE  t5.c1=t6.c1 AND t5.c2=t6.c2;

 DROP TABLE IF EXISTS t1,t2,t3,t4,t5,t6,t7;

 Warnings:

-Note	1051	Unknown table 't3'

+Note	1051	Unknown table 'test.t3'

 SELECT 0 + (10101010101010101010101010101010101010101010101010101010101010101<<2);

 0 + (10101010101010101010101010101010101010101010101010101010101010101<<2)

 18446744073709551612

@@ -81225,7 +81225,7 @@

 DELETE t5,t6 FROM t5,t6 WHERE  t5.c1=t6.c1 AND t5.c2=t6.c2;

 DROP TABLE IF EXISTS t1,t2,t3,t4,t5,t6,t7;

 Warnings:

-Note	1051	Unknown table 't3'

+Note	1051	Unknown table 'test.t3'

 SELECT 0 + (10101010101010101010101010101010101010101010101010101010101010101<<4);

 0 + (10101010101010101010101010101010101010101010101010101010101010101<<4)

 18446744073709551600

@@ -82144,7 +82144,7 @@

 DELETE t5,t6 FROM t5,t6 WHERE  t5.c1=t6.c1 AND t5.c2=t6.c2;

 DROP TABLE IF EXISTS t1,t2,t3,t4,t5,t6,t7;

 Warnings:

-Note	1051	Unknown table 't3'

+Note	1051	Unknown table 'test.t3'

 SELECT 0 + (10101010101010101010101010101010101010101010101010101010101010101<<8);

 0 + (10101010101010101010101010101010101010101010101010101010101010101<<8)

 18446744073709551360

@@ -83348,7 +83348,7 @@

 DELETE t5,t6 FROM t5,t6 WHERE  t5.c1=t6.c1 AND t5.c2=t6.c2;

 DROP TABLE IF EXISTS t1,t2,t3,t4,t5,t6,t7;

 Warnings:

-Note	1051	Unknown table 't3'

+Note	1051	Unknown table 'test.t3'

 SELECT 0 + (10101010101010101010101010101010101010101010101010101010101010101<<16);

 0 + (10101010101010101010101010101010101010101010101010101010101010101<<16)

 18446744073709486080

@@ -84757,7 +84757,7 @@

 DELETE t5,t6 FROM t5,t6 WHERE  t5.c1=t6.c1 AND t5.c2=t6.c2;

 DROP TABLE IF EXISTS t1,t2,t3,t4,t5,t6,t7;

 Warnings:

-Note	1051	Unknown table 't3'

+Note	1051	Unknown table 'test.t3'

 SELECT 0 + (10101010101010101010101010101010101010101010101010101010101010101<<32);

 0 + (10101010101010101010101010101010101010101010101010101010101010101<<32)

 18446744069414584320

@@ -86833,7 +86833,7 @@

 DELETE t5,t6 FROM t5,t6 WHERE  t5.c1=t6.c1 AND t5.c2=t6.c2;

 DROP TABLE IF EXISTS t1,t2,t3,t4,t5,t6,t7;

 Warnings:

-Note	1051	Unknown table 't3'

+Note	1051	Unknown table 'test.t3'

 SELECT 0 + (10101010101010101010101010101010101010101010101010101010101010101<<64);

 0 + (10101010101010101010101010101010101010101010101010101010101010101<<64)

@@ -90016,4 +90016,4 @@

 DELETE t5,t6 FROM t5,t6 WHERE  t5.c1=t6.c1 AND t5.c2=t6.c2;

 DROP TABLE IF EXISTS t1,t2,t3,t4,t5,t6,t7;

 Warnings:

-Note	1051	Unknown table 't3'

+Note	1051	Unknown table 'test.t3'

mysqltest: Result length mismatch

engines/iuds.update_delete_number        [ fail ]

        Test ended at 2014-12-03 04:21:34

CURRENT_TEST: engines/iuds.update_delete_number

--- /data/repo/bzr/10.0/mysql-test/suite/engines/iuds/r/update_delete_number.result	2014-11-12 04:27:00.000000000 +0300

+++ /data/repo/bzr/10.0/mysql-test/suite/engines/iuds/r/update_delete_number.reject	2014-12-03 03:21:34.000000000 +0300

@@ -740,7 +740,7 @@

 SELECT * FROM t1,t2 WHERE t2.c1=t1.c2;

 c1	c2	c3	c1	c2	c3

 DELETE FROM t1,t2 using t1,t2 where t1.c1=(select c1 from t1);

-ERROR HY000: You can't specify target table 't1' for update in FROM clause

+ERROR HY000: Table 't1' is specified twice, both as a target for 'DELETE' and as a separate source for data

 CREATE TABLE t3(c1 INT UNSIGNED NOT NULL PRIMARY KEY, c2 INT SIGNED NULL, c3 INT);

 CREATE TABLE t4(c1 INT UNSIGNED, c2 INT);

 INSERT INTO t3 VALUES(200,126,1),(250,-127,2);

@@ -980,9 +980,9 @@

 create table mt1 (col1 int);

 create table mt2 (col1 int);

 update mt1,mt2 set mt1.col1 = (select max(col1) from mt1) where mt1.col1 = mt2.col1;

-ERROR HY000: You can't specify target table 'mt1' for update in FROM clause

+ERROR HY000: Table 'mt1' is specified twice, both as a target for 'UPDATE' and as a separate source for data

 delete mt1 from mt1,mt2 where mt1.col1 < (select max(col1) from mt1) and mt1.col1 = mt2.col1;

-ERROR HY000: You can't specify target table 'mt1' for update in FROM clause

+ERROR HY000: Table 'mt1' is specified twice, both as a target for 'DELETE' and as a separate source for data

 drop table mt1,mt2;

 CREATE TABLE IF NOT EXISTS `mt1` (`id` int(11) NOT NULL auto_increment, `tst` text, `tsmt1` text, PRIMARY KEY  (`id`));

 CREATE TABLE IF NOT EXISTS `mt2` (`ID` int(11) NOT NULL auto_increment, `ParId` int(11) default NULL, `tst` text, `tsmt1` text, PRIMARY KEY  (`ID`), KEY `IX_ParId_mt2` (`ParId`),  FOREIGN KEY (`ParId`) REFERENCES `mt1` (`id`));

@@ -1853,7 +1853,7 @@

 SELECT * FROM t1,t2 WHERE t2.c1=t1.c2;

 c1	c2	c3	c1	c2	c3

 DELETE FROM t1,t2 using t1,t2 where t1.c1=(select c1 from t1);

-ERROR HY000: You can't specify target table 't1' for update in FROM clause

+ERROR HY000: Table 't1' is specified twice, both as a target for 'DELETE' and as a separate source for data

 CREATE TABLE t3(c1 TINYINT UNSIGNED NOT NULL PRIMARY KEY, c2 TINYINT SIGNED NULL, c3 INT);

 CREATE TABLE t4(c1 TINYINT UNSIGNED, c2 INT);

 INSERT INTO t3 VALUES(200,126,1),(250,-127,2);

@@ -2600,7 +2600,7 @@

 SELECT * FROM t1,t2 WHERE t2.c1=t1.c2;

 c1	c2	c3	c1	c2	c3

 DELETE FROM t1,t2 using t1,t2 where t1.c1=(select c1 from t1);

-ERROR HY000: You can't specify target table 't1' for update in FROM clause

+ERROR HY000: Table 't1' is specified twice, both as a target for 'DELETE' and as a separate source for data

 CREATE TABLE t3(c1 SMALLINT UNSIGNED NOT NULL PRIMARY KEY, c2 SMALLINT SIGNED NULL, c3 INT);

 CREATE TABLE t4(c1 SMALLINT UNSIGNED, c2 INT);

 INSERT INTO t3 VALUES(200,126,1),(250,-127,2);

@@ -3347,7 +3347,7 @@

 SELECT * FROM t1,t2 WHERE t2.c1=t1.c2;

 c1	c2	c3	c1	c2	c3

 DELETE FROM t1,t2 using t1,t2 where t1.c1=(select c1 from t1);

-ERROR HY000: You can't specify target table 't1' for update in FROM clause

+ERROR HY000: Table 't1' is specified twice, both as a target for 'DELETE' and as a separate source for data

 CREATE TABLE t3(c1 MEDIUMINT UNSIGNED NOT NULL PRIMARY KEY, c2 MEDIUMINT SIGNED NULL, c3 INT);

 CREATE TABLE t4(c1 MEDIUMINT UNSIGNED, c2 INT);

 INSERT INTO t3 VALUES(200,126,1),(250,-127,2);

@@ -4077,7 +4077,7 @@

 SELECT * FROM t1,t2 WHERE t2.c1=t1.c2;

 c1	c2	c3	c1	c2	c3

 DELETE FROM t1,t2 using t1,t2 where t1.c1=(select c1 from t1);

-ERROR HY000: You can't specify target table 't1' for update in FROM clause

+ERROR HY000: Table 't1' is specified twice, both as a target for 'DELETE' and as a separate source for data

 CREATE TABLE t3(c1 BIGINT UNSIGNED NOT NULL PRIMARY KEY, c2 BIGINT SIGNED NULL, c3 INT);

 CREATE TABLE t4(c1 BIGINT UNSIGNED, c2 INT);

 INSERT INTO t3 VALUES(200,126,1),(250,-127,2);

mysqltest: Result length mismatch

engines/funcs.rpl_row_until 'row'        [ fail ]

        Test ended at 2014-12-03 04:21:40

CURRENT_TEST: engines/funcs.rpl_row_until

mysqltest: In included file "./include/check_slave_param.inc":

included from /data/repo/bzr/10.0/mysql-test/suite/engines/funcs/t/rpl_row_until.test at line 58:

At line 31: Wrong value for slave parameter

The result from queries just before the failure was:

< snip >

master-bin.000001	669	Gtid	1	707	GTID 0-1-3

master-bin.000001	707	Query	1	811	use `test`; DROP TABLE `t1` /* generated by server */

master-bin.000001	811	Gtid	1	849	GTID 0-1-4

master-bin.000001	849	Query	1	970	use `test`; CREATE TABLE t2(n INT NOT NULL AUTO_INCREMENT PRIMARY KEY)

master-bin.000001	970	Gtid	1	1008	BEGIN GTID 0-1-5

master-bin.000001	1008	Table_map	1	1049	table_id: 83 (test.t2)

master-bin.000001	1049	Write_rows_v1	1	1088	table_id: 83 flags: STMT_END_F

master-bin.000001	1088	Query	1	1157	COMMIT

master-bin.000001	1157	Gtid	1	1195	BEGIN GTID 0-1-6

master-bin.000001	1195	Table_map	1	1236	table_id: 83 (test.t2)

master-bin.000001	1236	Write_rows_v1	1	1275	table_id: 83 flags: STMT_END_F

master-bin.000001	1275	Query	1	1344	COMMIT

master-bin.000001	1344	Gtid	1	1382	GTID 0-1-7

master-bin.000001	1382	Query	1	1486	use `test`; DROP TABLE `t2` /* generated by server */

**** SHOW RELAYLOG EVENTS on server_1 ****

relaylog_name = 'No such row'

SHOW RELAYLOG EVENTS IN 'No such row';

Log_name	Pos	Event_type	Server_id	End_log_pos	Info

Wrong value for Exec_Master_Log_Pos. Expected '510', got '669'

Attachments

Activity

People

Assignee:: Elena Stepanova

Reporter:: Elena Stepanova

Votes:: 0 Vote for this issue

Watchers:: 2 Start watching this issue

Dates

Created:: 2014-12-03 02:28

Updated:: 2015-02-08 13:37

Resolved:: 2015-02-08 13:37

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.