diff options
Diffstat (limited to 'mysql-test/suite/engines/funcs/r/sf_alter.result')
-rw-r--r-- | mysql-test/suite/engines/funcs/r/sf_alter.result | 540 |
1 files changed, 0 insertions, 540 deletions
diff --git a/mysql-test/suite/engines/funcs/r/sf_alter.result b/mysql-test/suite/engines/funcs/r/sf_alter.result index 8885b20d557..e89f529ba09 100644 --- a/mysql-test/suite/engines/funcs/r/sf_alter.result +++ b/mysql-test/suite/engines/funcs/r/sf_alter.result @@ -35,8 +35,6 @@ ALTER FUNCTION sf1 #DET# ; SELECT sf1(); sf1() 0 -Warnings: -Error 1329 No data - zero rows fetched, selected, or processed SELECT * FROM t1 ORDER BY id; id data 1 1 @@ -54,8 +52,6 @@ id data 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 @@ id data 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 @@ id data 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 @@ ALTER FUNCTION sf1 #DET# CONTAINS SQL ; SELECT sf1(); sf1() 0 -Warnings: -Error 1329 No data - zero rows fetched, selected, or processed SELECT * FROM t1 ORDER BY id; id data 1 1 @@ -191,8 +180,6 @@ id data 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 @@ id data 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 @@ id data 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 @@ ALTER FUNCTION sf1 #DET# NO SQL ; SELECT sf1(); sf1() 0 -Warnings: -Error 1329 No data - zero rows fetched, selected, or processed SELECT * FROM t1 ORDER BY id; id data 1 1 @@ -328,8 +308,6 @@ id data 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 @@ id data 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 @@ id data 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 @@ ALTER FUNCTION sf1 #DET# READS SQL DATA ; SELECT sf1(); sf1() 0 -Warnings: -Error 1329 No data - zero rows fetched, selected, or processed SELECT * FROM t1 ORDER BY id; id data 1 1 @@ -465,8 +436,6 @@ id data 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 @@ id data 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 @@ id data 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 @@ ALTER FUNCTION sf1 #DET# MODIFIES SQL DATA ; SELECT sf1(); sf1() 0 -Warnings: -Error 1329 No data - zero rows fetched, selected, or processed SELECT * FROM t1 ORDER BY id; id data 1 1 @@ -602,8 +564,6 @@ id data 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 @@ id data 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 @@ id data 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 @@ ALTER FUNCTION sf1 #DET# COMMENT 'comment' ; SELECT sf1(); sf1() 0 -Warnings: -Error 1329 No data - zero rows fetched, selected, or processed SELECT * FROM t1 ORDER BY id; id data 1 1 @@ -739,8 +692,6 @@ id data 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 @@ id data 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 @@ id data 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 @@ ALTER FUNCTION sf1 #DET# CONTAINS SQL COMMENT 'comment' ; SELECT sf1(); sf1() 0 -Warnings: -Error 1329 No data - zero rows fetched, selected, or processed SELECT * FROM t1 ORDER BY id; id data 1 1 @@ -876,8 +820,6 @@ id data 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 @@ id data 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 @@ id data 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 @@ ALTER FUNCTION sf1 #DET# NO SQL COMMENT 'comment' ; SELECT sf1(); sf1() 0 -Warnings: -Error 1329 No data - zero rows fetched, selected, or processed SELECT * FROM t1 ORDER BY id; id data 1 1 @@ -1013,8 +948,6 @@ id data 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 @@ id data 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 @@ id data 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 @@ ALTER FUNCTION sf1 #DET# READS SQL DATA COMMENT 'comment' ; SELECT sf1(); sf1() 0 -Warnings: -Error 1329 No data - zero rows fetched, selected, or processed SELECT * FROM t1 ORDER BY id; id data 1 1 @@ -1150,8 +1076,6 @@ id data 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 @@ id data 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 @@ id data 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 @@ ALTER FUNCTION sf1 #DET# MODIFIES SQL DATA COMMENT 'comment' ; SELECT sf1(); sf1() 0 -Warnings: -Error 1329 No data - zero rows fetched, selected, or processed SELECT * FROM t1 ORDER BY id; id data 1 1 @@ -1287,8 +1204,6 @@ id data 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 @@ id data 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 @@ id data 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 @@ ALTER FUNCTION sf1 LANGUAGE SQL #DET# ; SELECT sf1(); sf1() 0 -Warnings: -Error 1329 No data - zero rows fetched, selected, or processed SELECT * FROM t1 ORDER BY id; id data 1 1 @@ -1424,8 +1332,6 @@ id data 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 @@ id data 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 @@ id data 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 @@ ALTER FUNCTION sf1 LANGUAGE SQL #DET# CONTAINS SQL ; SELECT sf1(); sf1() 0 -Warnings: -Error 1329 No data - zero rows fetched, selected, or processed SELECT * FROM t1 ORDER BY id; id data 1 1 @@ -1561,8 +1460,6 @@ id data 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 @@ id data 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 @@ id data 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 @@ ALTER FUNCTION sf1 LANGUAGE SQL #DET# NO SQL ; SELECT sf1(); sf1() 0 -Warnings: -Error 1329 No data - zero rows fetched, selected, or processed SELECT * FROM t1 ORDER BY id; id data 1 1 @@ -1698,8 +1588,6 @@ id data 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 @@ id data 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 @@ id data 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 @@ ALTER FUNCTION sf1 LANGUAGE SQL #DET# READS SQL DATA ; SELECT sf1(); sf1() 0 -Warnings: -Error 1329 No data - zero rows fetched, selected, or processed SELECT * FROM t1 ORDER BY id; id data 1 1 @@ -1835,8 +1716,6 @@ id data 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 @@ id data 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 @@ id data 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 @@ ALTER FUNCTION sf1 LANGUAGE SQL #DET# MODIFIES SQL DATA ; SELECT sf1(); sf1() 0 -Warnings: -Error 1329 No data - zero rows fetched, selected, or processed SELECT * FROM t1 ORDER BY id; id data 1 1 @@ -1972,8 +1844,6 @@ id data 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 @@ id data 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 @@ id data 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 @@ ALTER FUNCTION sf1 LANGUAGE SQL #DET# COMMENT 'comment' ; SELECT sf1(); sf1() 0 -Warnings: -Error 1329 No data - zero rows fetched, selected, or processed SELECT * FROM t1 ORDER BY id; id data 1 1 @@ -2109,8 +1972,6 @@ id data 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 @@ id data 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 @@ id data 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 @@ ALTER FUNCTION sf1 LANGUAGE SQL #DET# CONTAINS SQL COMMENT 'comment' ; SELECT sf1(); sf1() 0 -Warnings: -Error 1329 No data - zero rows fetched, selected, or processed SELECT * FROM t1 ORDER BY id; id data 1 1 @@ -2246,8 +2100,6 @@ id data 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 @@ id data 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 @@ id data 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 @@ ALTER FUNCTION sf1 LANGUAGE SQL #DET# NO SQL COMMENT 'comment' ; SELECT sf1(); sf1() 0 -Warnings: -Error 1329 No data - zero rows fetched, selected, or processed SELECT * FROM t1 ORDER BY id; id data 1 1 @@ -2383,8 +2228,6 @@ id data 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 @@ id data 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 @@ id data 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 @@ ALTER FUNCTION sf1 LANGUAGE SQL #DET# READS SQL DATA COMMENT 'comment' ; SELECT sf1(); sf1() 0 -Warnings: -Error 1329 No data - zero rows fetched, selected, or processed SELECT * FROM t1 ORDER BY id; id data 1 1 @@ -2520,8 +2356,6 @@ id data 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 @@ id data 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 @@ id data 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 @@ ALTER FUNCTION sf1 LANGUAGE SQL #DET# MODIFIES SQL DATA COMMENT 'comment' ; SELECT sf1(); sf1() 0 -Warnings: -Error 1329 No data - zero rows fetched, selected, or processed SELECT * FROM t1 ORDER BY id; id data 1 1 @@ -2657,8 +2484,6 @@ id data 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 @@ id data 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 @@ id data 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 @@ ALTER FUNCTION sf1 #DET# SQL SECURITY INVOKER ; SELECT sf1(); sf1() 0 -Warnings: -Error 1329 No data - zero rows fetched, selected, or processed SELECT * FROM t1 ORDER BY id; id data 1 1 @@ -2794,8 +2612,6 @@ id data 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 @@ id data 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 @@ id data 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 @@ ALTER FUNCTION sf1 #DET# CONTAINS SQL SQL SECURITY INVOKER ; SELECT sf1(); sf1() 0 -Warnings: -Error 1329 No data - zero rows fetched, selected, or processed SELECT * FROM t1 ORDER BY id; id data 1 1 @@ -2931,8 +2740,6 @@ id data 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 @@ id data 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 @@ id data 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 @@ ALTER FUNCTION sf1 #DET# NO SQL SQL SECURITY INVOKER ; SELECT sf1(); sf1() 0 -Warnings: -Error 1329 No data - zero rows fetched, selected, or processed SELECT * FROM t1 ORDER BY id; id data 1 1 @@ -3068,8 +2868,6 @@ id data 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 @@ id data 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 @@ id data 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 @@ ALTER FUNCTION sf1 #DET# READS SQL DATA SQL SECURITY INVOKER ; SELECT sf1(); sf1() 0 -Warnings: -Error 1329 No data - zero rows fetched, selected, or processed SELECT * FROM t1 ORDER BY id; id data 1 1 @@ -3205,8 +2996,6 @@ id data 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 @@ id data 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 @@ id data 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 @@ ALTER FUNCTION sf1 #DET# MODIFIES SQL DATA SQL SECURITY INVOKER ; SELECT sf1(); sf1() 0 -Warnings: -Error 1329 No data - zero rows fetched, selected, or processed SELECT * FROM t1 ORDER BY id; id data 1 1 @@ -3342,8 +3124,6 @@ id data 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 @@ id data 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 @@ id data 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 @@ ALTER FUNCTION sf1 #DET# SQL SECURITY INVOKER COMMENT 'comment' ; SELECT sf1(); sf1() 0 -Warnings: -Error 1329 No data - zero rows fetched, selected, or processed SELECT * FROM t1 ORDER BY id; id data 1 1 @@ -3479,8 +3252,6 @@ id data 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 @@ id data 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 @@ id data 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 @@ ALTER FUNCTION sf1 #DET# CONTAINS SQL SQL SECURITY INVOKER COMMENT 'comment' SELECT sf1(); sf1() 0 -Warnings: -Error 1329 No data - zero rows fetched, selected, or processed SELECT * FROM t1 ORDER BY id; id data 1 1 @@ -3616,8 +3380,6 @@ id data 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 @@ id data 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 @@ id data 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 @@ ALTER FUNCTION sf1 #DET# NO SQL SQL SECURITY INVOKER COMMENT 'comment' ; SELECT sf1(); sf1() 0 -Warnings: -Error 1329 No data - zero rows fetched, selected, or processed SELECT * FROM t1 ORDER BY id; id data 1 1 @@ -3753,8 +3508,6 @@ id data 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 @@ id data 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 @@ id data 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 @@ ALTER FUNCTION sf1 #DET# READS SQL DATA SQL SECURITY INVOKER COMMENT 'comment SELECT sf1(); sf1() 0 -Warnings: -Error 1329 No data - zero rows fetched, selected, or processed SELECT * FROM t1 ORDER BY id; id data 1 1 @@ -3890,8 +3636,6 @@ id data 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 @@ id data 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 @@ id data 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 @@ ALTER FUNCTION sf1 #DET# MODIFIES SQL DATA SQL SECURITY INVOKER COMMENT 'comm SELECT sf1(); sf1() 0 -Warnings: -Error 1329 No data - zero rows fetched, selected, or processed SELECT * FROM t1 ORDER BY id; id data 1 1 @@ -4027,8 +3764,6 @@ id data 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 @@ id data 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 @@ id data 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 @@ ALTER FUNCTION sf1 LANGUAGE SQL #DET# SQL SECURITY INVOKER ; SELECT sf1(); sf1() 0 -Warnings: -Error 1329 No data - zero rows fetched, selected, or processed SELECT * FROM t1 ORDER BY id; id data 1 1 @@ -4164,8 +3892,6 @@ id data 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 @@ id data 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 @@ id data 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 @@ ALTER FUNCTION sf1 LANGUAGE SQL #DET# CONTAINS SQL SQL SECURITY INVOKER ; SELECT sf1(); sf1() 0 -Warnings: -Error 1329 No data - zero rows fetched, selected, or processed SELECT * FROM t1 ORDER BY id; id data 1 1 @@ -4301,8 +4020,6 @@ id data 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 @@ id data 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 @@ id data 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 @@ ALTER FUNCTION sf1 LANGUAGE SQL #DET# NO SQL SQL SECURITY INVOKER ; SELECT sf1(); sf1() 0 -Warnings: -Error 1329 No data - zero rows fetched, selected, or processed SELECT * FROM t1 ORDER BY id; id data 1 1 @@ -4438,8 +4148,6 @@ id data 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 @@ id data 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 @@ id data 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 @@ ALTER FUNCTION sf1 LANGUAGE SQL #DET# READS SQL DATA SQL SECURITY INVOKER ; SELECT sf1(); sf1() 0 -Warnings: -Error 1329 No data - zero rows fetched, selected, or processed SELECT * FROM t1 ORDER BY id; id data 1 1 @@ -4575,8 +4276,6 @@ id data 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 @@ id data 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 @@ id data 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 @@ ALTER FUNCTION sf1 LANGUAGE SQL #DET# MODIFIES SQL DATA SQL SECURITY INVOKER SELECT sf1(); sf1() 0 -Warnings: -Error 1329 No data - zero rows fetched, selected, or processed SELECT * FROM t1 ORDER BY id; id data 1 1 @@ -4712,8 +4404,6 @@ id data 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 @@ id data 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 @@ id data 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 @@ ALTER FUNCTION sf1 LANGUAGE SQL #DET# SQL SECURITY INVOKER COMMENT 'comment' SELECT sf1(); sf1() 0 -Warnings: -Error 1329 No data - zero rows fetched, selected, or processed SELECT * FROM t1 ORDER BY id; id data 1 1 @@ -4849,8 +4532,6 @@ id data 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 @@ id data 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 @@ id data 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 @@ ALTER FUNCTION sf1 LANGUAGE SQL #DET# CONTAINS SQL SQL SECURITY INVOKER COMMENT SELECT sf1(); sf1() 0 -Warnings: -Error 1329 No data - zero rows fetched, selected, or processed SELECT * FROM t1 ORDER BY id; id data 1 1 @@ -4986,8 +4660,6 @@ id data 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 @@ id data 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 @@ id data 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 @@ ALTER FUNCTION sf1 LANGUAGE SQL #DET# NO SQL SQL SECURITY INVOKER COMMENT 'comm SELECT sf1(); sf1() 0 -Warnings: -Error 1329 No data - zero rows fetched, selected, or processed SELECT * FROM t1 ORDER BY id; id data 1 1 @@ -5123,8 +4788,6 @@ id data 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 @@ id data 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 @@ id data 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 @@ ALTER FUNCTION sf1 LANGUAGE SQL #DET# READS SQL DATA SQL SECURITY INVOKER COMME SELECT sf1(); sf1() 0 -Warnings: -Error 1329 No data - zero rows fetched, selected, or processed SELECT * FROM t1 ORDER BY id; id data 1 1 @@ -5260,8 +4916,6 @@ id data 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 @@ id data 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 @@ id data 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 @@ ALTER FUNCTION sf1 LANGUAGE SQL #DET# MODIFIES SQL DATA SQL SECURITY INVOKER CO SELECT sf1(); sf1() 0 -Warnings: -Error 1329 No data - zero rows fetched, selected, or processed SELECT * FROM t1 ORDER BY id; id data 1 1 @@ -5397,8 +5044,6 @@ id data 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 @@ id data 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 @@ id data 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 @@ ALTER FUNCTION sf1 #DET# SQL SECURITY DEFINER ; SELECT sf1(); sf1() 0 -Warnings: -Error 1329 No data - zero rows fetched, selected, or processed SELECT * FROM t1 ORDER BY id; id data 1 1 @@ -5534,8 +5172,6 @@ id data 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 @@ id data 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 @@ id data 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 @@ ALTER FUNCTION sf1 #DET# CONTAINS SQL SQL SECURITY DEFINER ; SELECT sf1(); sf1() 0 -Warnings: -Error 1329 No data - zero rows fetched, selected, or processed SELECT * FROM t1 ORDER BY id; id data 1 1 @@ -5671,8 +5300,6 @@ id data 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 @@ id data 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 @@ id data 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 @@ ALTER FUNCTION sf1 #DET# NO SQL SQL SECURITY DEFINER ; SELECT sf1(); sf1() 0 -Warnings: -Error 1329 No data - zero rows fetched, selected, or processed SELECT * FROM t1 ORDER BY id; id data 1 1 @@ -5808,8 +5428,6 @@ id data 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 @@ id data 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 @@ id data 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 @@ ALTER FUNCTION sf1 #DET# READS SQL DATA SQL SECURITY DEFINER ; SELECT sf1(); sf1() 0 -Warnings: -Error 1329 No data - zero rows fetched, selected, or processed SELECT * FROM t1 ORDER BY id; id data 1 1 @@ -5945,8 +5556,6 @@ id data 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 @@ id data 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 @@ id data 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 @@ ALTER FUNCTION sf1 #DET# MODIFIES SQL DATA SQL SECURITY DEFINER ; SELECT sf1(); sf1() 0 -Warnings: -Error 1329 No data - zero rows fetched, selected, or processed SELECT * FROM t1 ORDER BY id; id data 1 1 @@ -6082,8 +5684,6 @@ id data 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 @@ id data 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 @@ id data 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 @@ ALTER FUNCTION sf1 #DET# SQL SECURITY DEFINER COMMENT 'comment' ; SELECT sf1(); sf1() 0 -Warnings: -Error 1329 No data - zero rows fetched, selected, or processed SELECT * FROM t1 ORDER BY id; id data 1 1 @@ -6219,8 +5812,6 @@ id data 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 @@ id data 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 @@ id data 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 @@ ALTER FUNCTION sf1 #DET# CONTAINS SQL SQL SECURITY DEFINER COMMENT 'comment' SELECT sf1(); sf1() 0 -Warnings: -Error 1329 No data - zero rows fetched, selected, or processed SELECT * FROM t1 ORDER BY id; id data 1 1 @@ -6356,8 +5940,6 @@ id data 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 @@ id data 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 @@ id data 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 @@ ALTER FUNCTION sf1 #DET# NO SQL SQL SECURITY DEFINER COMMENT 'comment' ; SELECT sf1(); sf1() 0 -Warnings: -Error 1329 No data - zero rows fetched, selected, or processed SELECT * FROM t1 ORDER BY id; id data 1 1 @@ -6493,8 +6068,6 @@ id data 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 @@ id data 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 @@ id data 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 @@ ALTER FUNCTION sf1 #DET# READS SQL DATA SQL SECURITY DEFINER COMMENT 'commen SELECT sf1(); sf1() 0 -Warnings: -Error 1329 No data - zero rows fetched, selected, or processed SELECT * FROM t1 ORDER BY id; id data 1 1 @@ -6630,8 +6196,6 @@ id data 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 @@ id data 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 @@ id data 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 @@ ALTER FUNCTION sf1 #DET# MODIFIES SQL DATA SQL SECURITY DEFINER COMMENT 'com SELECT sf1(); sf1() 0 -Warnings: -Error 1329 No data - zero rows fetched, selected, or processed SELECT * FROM t1 ORDER BY id; id data 1 1 @@ -6767,8 +6324,6 @@ id data 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 @@ id data 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 @@ id data 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 @@ ALTER FUNCTION sf1 LANGUAGE SQL #DET# SQL SECURITY DEFINER ; SELECT sf1(); sf1() 0 -Warnings: -Error 1329 No data - zero rows fetched, selected, or processed SELECT * FROM t1 ORDER BY id; id data 1 1 @@ -6904,8 +6452,6 @@ id data 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 @@ id data 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 @@ id data 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 @@ ALTER FUNCTION sf1 LANGUAGE SQL #DET# CONTAINS SQL SQL SECURITY DEFINER ; SELECT sf1(); sf1() 0 -Warnings: -Error 1329 No data - zero rows fetched, selected, or processed SELECT * FROM t1 ORDER BY id; id data 1 1 @@ -7041,8 +6580,6 @@ id data 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 @@ id data 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 @@ id data 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 @@ ALTER FUNCTION sf1 LANGUAGE SQL #DET# NO SQL SQL SECURITY DEFINER ; SELECT sf1(); sf1() 0 -Warnings: -Error 1329 No data - zero rows fetched, selected, or processed SELECT * FROM t1 ORDER BY id; id data 1 1 @@ -7178,8 +6708,6 @@ id data 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 @@ id data 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 @@ id data 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 @@ ALTER FUNCTION sf1 LANGUAGE SQL #DET# READS SQL DATA SQL SECURITY DEFINER ; SELECT sf1(); sf1() 0 -Warnings: -Error 1329 No data - zero rows fetched, selected, or processed SELECT * FROM t1 ORDER BY id; id data 1 1 @@ -7315,8 +6836,6 @@ id data 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 @@ id data 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 @@ id data 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 @@ ALTER FUNCTION sf1 LANGUAGE SQL #DET# MODIFIES SQL DATA SQL SECURITY DEFINER SELECT sf1(); sf1() 0 -Warnings: -Error 1329 No data - zero rows fetched, selected, or processed SELECT * FROM t1 ORDER BY id; id data 1 1 @@ -7452,8 +6964,6 @@ id data 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 @@ id data 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 @@ id data 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 @@ ALTER FUNCTION sf1 LANGUAGE SQL #DET# SQL SECURITY DEFINER COMMENT 'comment' SELECT sf1(); sf1() 0 -Warnings: -Error 1329 No data - zero rows fetched, selected, or processed SELECT * FROM t1 ORDER BY id; id data 1 1 @@ -7589,8 +7092,6 @@ id data 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 @@ id data 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 @@ id data 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 @@ ALTER FUNCTION sf1 LANGUAGE SQL #DET# CONTAINS SQL SQL SECURITY DEFINER COMMEN SELECT sf1(); sf1() 0 -Warnings: -Error 1329 No data - zero rows fetched, selected, or processed SELECT * FROM t1 ORDER BY id; id data 1 1 @@ -7726,8 +7220,6 @@ id data 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 @@ id data 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 @@ id data 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 @@ ALTER FUNCTION sf1 LANGUAGE SQL #DET# NO SQL SQL SECURITY DEFINER COMMENT 'com SELECT sf1(); sf1() 0 -Warnings: -Error 1329 No data - zero rows fetched, selected, or processed SELECT * FROM t1 ORDER BY id; id data 1 1 @@ -7863,8 +7348,6 @@ id data 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 @@ id data 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 @@ id data 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 @@ ALTER FUNCTION sf1 LANGUAGE SQL #DET# READS SQL DATA SQL SECURITY DEFINER COMM SELECT sf1(); sf1() 0 -Warnings: -Error 1329 No data - zero rows fetched, selected, or processed SELECT * FROM t1 ORDER BY id; id data 1 1 @@ -8000,8 +7476,6 @@ id data 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 @@ id data 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 @@ id data 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 @@ ALTER FUNCTION sf1 LANGUAGE SQL #DET# MODIFIES SQL DATA SQL SECURITY DEFINER C SELECT sf1(); sf1() 0 -Warnings: -Error 1329 No data - zero rows fetched, selected, or processed SELECT * FROM t1 ORDER BY id; id data 1 1 @@ -8137,8 +7604,6 @@ id data 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 @@ id data 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 @@ id data 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 |