This is an automated email from the ASF dual-hosted git repository.
duanzhengqiang pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/shardingsphere.git
The following commit(s) were added to refs/heads/master by this push:
new d38ace2 fix create function with set var (#16549)
d38ace2 is described below
commit d38ace200c95a7e71c384cb0b91daec2a308d43b
Author: Chuxin Chen <chuxinche...@qq.com>
AuthorDate: Sat Apr 2 10:14:25 2022 +0800
fix create function with set var (#16549)
---
.../src/main/antlr4/imports/mysql/DALStatement.g4 | 12 +-
.../main/resources/case/ddl/create-function.xml | 1 +
.../sql/supported/ddl/create-function.xml | 2 +
.../main/resources/sql/unsupported/unsupported.xml | 249 ---------------------
4 files changed, 11 insertions(+), 253 deletions(-)
diff --git
a/shardingsphere-sql-parser/shardingsphere-sql-parser-dialect/shardingsphere-sql-parser-mysql/src/main/antlr4/imports/mysql/DALStatement.g4
b/shardingsphere-sql-parser/shardingsphere-sql-parser-dialect/shardingsphere-sql-parser-mysql/src/main/antlr4/imports/mysql/DALStatement.g4
index 2f7f223..697c2d6 100644
---
a/shardingsphere-sql-parser/shardingsphere-sql-parser-dialect/shardingsphere-sql-parser-mysql/src/main/antlr4/imports/mysql/DALStatement.g4
+++
b/shardingsphere-sql-parser/shardingsphere-sql-parser-dialect/shardingsphere-sql-parser-mysql/src/main/antlr4/imports/mysql/DALStatement.g4
@@ -68,12 +68,16 @@ optionValueList
;
optionValueNoOptionType
- : internalVariableName EQ_ setExprOrDefault
- | userVariable EQ_ expr
- | setSystemVariable EQ_ setExprOrDefault
- | NAMES (EQ_ expr | charsetName collateClause? | DEFAULT)
+ : internalVariableName equal setExprOrDefault
+ | userVariable equal expr
+ | setSystemVariable equal setExprOrDefault
+ | NAMES (equal expr | charsetName collateClause? | DEFAULT)
;
+equal
+ : EQ_ | ASSIGNMENT_
+ ;
+
optionValue
: optionType internalVariableName EQ_ setExprOrDefault |
optionValueNoOptionType
;
diff --git
a/shardingsphere-test/shardingsphere-parser-test/src/main/resources/case/ddl/create-function.xml
b/shardingsphere-test/shardingsphere-parser-test/src/main/resources/case/ddl/create-function.xml
index e7b9112..ac508b7 100644
---
a/shardingsphere-test/shardingsphere-parser-test/src/main/resources/case/ddl/create-function.xml
+++
b/shardingsphere-test/shardingsphere-parser-test/src/main/resources/case/ddl/create-function.xml
@@ -26,4 +26,5 @@
<create-function sql-case-id="create_function_declare_without_at" />
<create-function sql-case-id="create_function_call_spec_java" />
<create-function sql-case-id="create_function_call_spec_c" />
+ <create-function sql-case-id="create_function_with_set_var" />
</sql-parser-test-cases>
diff --git
a/shardingsphere-test/shardingsphere-parser-test/src/main/resources/sql/supported/ddl/create-function.xml
b/shardingsphere-test/shardingsphere-parser-test/src/main/resources/sql/supported/ddl/create-function.xml
index 813ee16..5847df3 100644
---
a/shardingsphere-test/shardingsphere-parser-test/src/main/resources/sql/supported/ddl/create-function.xml
+++
b/shardingsphere-test/shardingsphere-parser-test/src/main/resources/sql/supported/ddl/create-function.xml
@@ -69,4 +69,6 @@
NAME "c_get_val"
LIBRARY c_utils
PARAMETERS (CONTEXT)" db-types="Oracle" />
+
+ <sql-case id="create_function_with_set_var" value="CREATE DEFINER =
u1@localhost FUNCTION f2() RETURNS int BEGIN DECLARE n int; DECLARE m int; SET
n:= (SELECT min(a) FROM t1); SET m:= (SELECT max(a) FROM t1); RETURN n < m;
END ;" db-types="MySQL"/>
</sql-cases>
diff --git
a/shardingsphere-test/shardingsphere-parser-test/src/main/resources/sql/unsupported/unsupported.xml
b/shardingsphere-test/shardingsphere-parser-test/src/main/resources/sql/unsupported/unsupported.xml
index 0bc0c75..d06f92e 100644
---
a/shardingsphere-test/shardingsphere-parser-test/src/main/resources/sql/unsupported/unsupported.xml
+++
b/shardingsphere-test/shardingsphere-parser-test/src/main/resources/sql/unsupported/unsupported.xml
@@ -58,12 +58,10 @@
<sql-case id="create_publication" value="create publication pub1 for table
alter1.t1, all tables in schema alter2" db-types="PostgreSQL" />
<sql-case id="create_by_mysql_source_test_case1" value="CREATE VIEW v1 AS
SELECT GROUPING(`߸߸߸߸߸߸߸߸߸߸0123456789012345678901234567890123456789`.a),
GROUPING(`߸߸߸߸߸߸߸߸߸߸0123456789012345678901234567890123456789`.a),
GROUPING(`߸߸߸߸߸߸߸߸߸߸0123456789012345678901234567890123456789`.a) FROM t1 AS
`߸߸߸߸߸߸߸߸߸߸0123456789012345678901234567890123456789` GROUP BY a WITH ROLLUP"
db-types="MySQL"/>
<sql-case id="create_by_mysql_source_test_case2" value="CREATE DEFINER =
u1@192.129.12.11 VIEW v3 as SELECT * FROM t1" db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case3" value="CREATE DEFINER =
u1@localhost FUNCTION f2() RETURNS int BEGIN DECLARE n int; DECLARE m int; SET
n:= (SELECT min(a) FROM t1); SET m:= (SELECT max(a) FROM t1); RETURN n < m;
END ;" db-types="MySQL"/>
<sql-case id="create_by_mysql_source_test_case4" value="CREATE
DEFINER=CURRENT_USER() FUNCTION should_not_parse RETURNS STRING SONAME
"should_not_parse.so"" db-types="MySQL"/>
<sql-case id="create_by_mysql_source_test_case5" value="CREATE
DEFINER=baz@localhost PROCEDURE my_db.baz_proc() BEGIN set ROLE all; INSERT
into my_db.t1 values(4) on duplicate key UPDATE id = values(id) + 400; END"
db-types="MySQL"/>
<sql-case id="create_by_mysql_source_test_case6" value="CREATE
DEFINER=event_u2@192.1.1.140 EVENT e3 ON SCHEDULE AT '2037-01-01
00:00:00' DISABLE DO SET @a = 5" db-types="MySQL"/>
<sql-case id="create_by_mysql_source_test_case7" value="CREATE
DEFINER=event_u2@192.1.1.140 EVENT e4 ON SCHEDULE AT '2037-01-01
00:00:00' DISABLE DO SET @a = 5" db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case8" value="CREATE
DEFINER=mysqltest_u1@localhost FUNCTION f_evil () RETURNS INT SQL SECURITY
INVOKER BEGIN SET @a:= CURRENT_USER(); SET @b:= (SELECT COUNT(*) FROM t1);
RETURN @b; END" db-types="MySQL"/>
<sql-case id="create_by_mysql_source_test_case9" value="CREATE
DEFINER=root@localhost PROCEDURE p1() BEGIN UPDATE t1, t2 SET a = 1 WHERE
regexp_like(t1.subject, t2.pattern); END|" db-types="MySQL"/>
<sql-case id="create_by_mysql_source_test_case10" value="CREATE
DEFINER=someone@somewhere FUNCTION should_not_parse RETURNS STRING SONAME
"should_not_parse.so"" db-types="MySQL"/>
<sql-case id="create_by_mysql_source_test_case11" value="CREATE
DEFINER=trig...@xyz.com TRIGGER trig3 BEFORE INSERT ON t1 FOR EACH ROW SET @sum
= 1" db-types="MySQL"/>
@@ -85,7 +83,6 @@
<sql-case id="create_by_mysql_source_test_case29" value="CREATE FUNCTION
bug21975() returns int BEGIN grant select on t1 to 'mysqltest_1';
return 1; END" db-types="MySQL"/>
<sql-case id="create_by_mysql_source_test_case30" value="CREATE FUNCTION
bug21975() returns int BEGIN revoke all privileges on *.* from
'mysqltest_1'; return 1; END" db-types="MySQL"/>
<sql-case id="create_by_mysql_source_test_case31" value="CREATE FUNCTION
bug21975() returns int BEGIN revoke select on t1 from 'mysqltest_1';
return 1; END" db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case32" value="CREATE FUNCTION
bug27563() RETURNS INT(11) DETERMINISTIC BEGIN DECLARE CONTINUE HANDLER FOR
SQLSTATE '70100' SET @a:= 'killed'; DECLARE CONTINUE
HANDLER FOR SQLEXCEPTION SET @a:= 'exception'; SET DEBUG_SYNC=
'now SIGNAL in_sync WAIT_FOR kill'; RETURN 1; END" db-types="MySQL"/>
<sql-case id="create_by_mysql_source_test_case33" value="CREATE FUNCTION
bug_13627_f() returns int BEGIN DROP TRIGGER test1; return 1; END"
db-types="MySQL"/>
<sql-case id="create_by_mysql_source_test_case34" value="CREATE FUNCTION
bug_13627_f() returns int BEGIN LOCK TABLE t1 READ; return 1; END"
db-types="MySQL"/>
<sql-case id="create_by_mysql_source_test_case35" value="CREATE FUNCTION
bug_13627_f() returns int BEGIN alter view v1 as select 1; return 1; END"
db-types="MySQL"/>
@@ -113,7 +110,6 @@
<sql-case id="create_by_mysql_source_test_case59" value="CREATE FUNCTION
f1() RETURNS INT BEGIN SET SESSION TRANSACTION ISOLATION LEVEL SERIALIZABLE,
READ ONLY; RETURN 1; END" db-types="MySQL"/>
<sql-case id="create_by_mysql_source_test_case60" value="CREATE FUNCTION
f1() RETURNS INT BEGIN SET SESSION TRANSACTION READ ONLY; RETURN 1; END"
db-types="MySQL"/>
<sql-case id="create_by_mysql_source_test_case61" value="CREATE FUNCTION
f1() RETURNS INTEGER BEGIN CALL db1.p1(); RETURN 1; END" db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case78" value="CREATE FUNCTION
f3() RETURNS int BEGIN DECLARE a, b int; DROP TEMPORARY TABLE IF EXISTS t3;
CREATE TEMPORARY TABLE t3 (id INT); INSERT INTO t3 VALUES (1), (2), (3); SET
a:= (SELECT COUNT(*) FROM t3); SET b:= (SELECT COUNT(*) FROM t3 t3_alias);
RETURN a + b; END" db-types="MySQL"/>
<sql-case id="create_by_mysql_source_test_case80" value="CREATE FUNCTION
f4_show_warnings() RETURNS TEXT BEGIN SHOW WARNINGS; RETURN "yeah, not so
much"; END" db-types="MySQL"/>
<sql-case id="create_by_mysql_source_test_case81" value="CREATE FUNCTION
fn(a int) RETURNS int DETERMINISTIC BEGIN RETURN a; END |" db-types="MySQL"/>
<sql-case id="create_by_mysql_source_test_case91" value="CREATE FUNCTION
service_get_write_locks RETURNS INT SONAME "$LOCKING_SERVICE""
db-types="MySQL"/>
@@ -175,7 +171,6 @@
<sql-case id="create_by_mysql_source_test_case216" value="CREATE PROCEDURE
p1() CREATE VIEW v1 AS SELECT * FROM t1" db-types="MySQL"/>
<sql-case id="create_by_mysql_source_test_case217" value="CREATE PROCEDURE
p1() LOAD DATA INFILE '../../std_data/loaddata_utf8.dat' INTO TABLE
t1" db-types="MySQL"/>
<sql-case id="create_by_mysql_source_test_case218" value="CREATE PROCEDURE
p1() RENAME TABLE t2 TO t3" db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case219" value="CREATE PROCEDURE
p1() SET @a :=1" db-types="MySQL"/>
<sql-case id="create_by_mysql_source_test_case220" value="CREATE PROCEDURE
p1() SET PASSWORD FOR u1@h = '12345'" db-types="MySQL"/>
<sql-case id="create_by_mysql_source_test_case221" value="CREATE PROCEDURE
p1() SET SESSION TRANSACTION READ ONLY" db-types="MySQL"/>
<sql-case id="create_by_mysql_source_test_case222" value="CREATE PROCEDURE
p1() SET SESSION TRANSACTION READ ONLY, ISOLATION LEVEL SERIALIZABLE"
db-types="MySQL"/>
@@ -197,21 +192,17 @@
<sql-case id="create_by_mysql_source_test_case250" value="CREATE PROCEDURE
p3() BEGIN DECLARE CONTINUE HANDLER FOR SQLEXCEPTION SELECT 'H1' AS
HandlerId; DECLARE CONTINUE HANDLER FOR SQLWARNING SELECT 'H2' AS
HandlerId; DECLARE CONTINUE HANDLER FOR SQLSTATE '01000' SELECT
'H3' AS HandlerId; SIGNAL SQLSTATE '01000'; # Should be
handled by H3. END" db-types="MySQL"/>
<sql-case id="create_by_mysql_source_test_case252" value="CREATE PROCEDURE
p3(n INT) DO LAG(1, n) OVER()" db-types="MySQL"/>
<sql-case id="create_by_mysql_source_test_case253" value="CREATE PROCEDURE
p4() BEGIN DECLARE CONTINUE HANDLER FOR SQLEXCEPTION SELECT 'H1' AS
HandlerId; DECLARE CONTINUE HANDLER FOR SQLSTATE '01000' SELECT
'H2' AS HandlerId; DECLARE CONTINUE HANDLER FOR SQLWARNING SELECT
'H3' AS HandlerId; SIGNAL SQLSTATE '01000'; # Should be
handled by H2. END" db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case254" value="CREATE PROCEDURE
p4(arg VARCHAR(2)) BEGIN DECLARE var VARCHAR(1); SET var := arg; SELECT arg,
var; END" db-types="MySQL"/>
<sql-case id="create_by_mysql_source_test_case255" value="CREATE PROCEDURE
p5() BEGIN DECLARE CONTINUE HANDLER FOR SQLEXCEPTION SELECT 'H1' AS
HandlerId; DECLARE CONTINUE HANDLER FOR SQLSTATE '01000' SELECT
'H2' AS HandlerId; BEGIN DECLARE CONTINUE HANDLER FOR SQLWARNING
SELECT 'H3' AS HandlerId; SIGNAL SQLSTATE '01000'; # Should
be handled by H3. END; END" db-types="MySQL"/>
<sql-case id="create_by_mysql_source_test_case256" value="CREATE PROCEDURE
p5() BEGIN DECLARE EXIT HANDLER FOR 1292 BEGIN SELECT 'Handler for
1292' AS Msg; SIGNAL SQLSTATE '01000' SET MYSQL_ERRNO = 1234;
SHOW WARNINGS; END; INSERT INTO t2 SELECT CAST(999999 AS SIGNED INTEGER),
CAST(CONCAT(CAST('2X' AS UNSIGNED INTEGER), '999999XX') AS
SIGNED INTEGER), CAST(CONCAT(CAST('3X' AS UNSIGNED INTEGER),
'999999XX') AS SIGNED INTEGER) [...]
- <sql-case id="create_by_mysql_source_test_case257" value="CREATE PROCEDURE
p5(arg CHAR(2)) BEGIN DECLARE var CHAR(1); SET var := arg; SELECT arg, var;
END" db-types="MySQL"/>
<sql-case id="create_by_mysql_source_test_case259" value="CREATE PROCEDURE
p6() BEGIN DECLARE CONTINUE HANDLER FOR 1292 BEGIN SHOW WARNINGS; SELECT
'Handler for 1292' Msg; END; INSERT INTO t2 SELECT
CAST(CONCAT(CAST('1X' AS UNSIGNED INTEGER), '999999XX') AS
SIGNED INTEGER), CAST(CONCAT(CAST('2X' AS UNSIGNED INTEGER),
'999999XX') AS SIGNED INTEGER), CAST(CONCAT(CAST('3X' AS
UNSIGNED INTEGER), '999999XX') AS SIGNED I [...]
<sql-case id="create_by_mysql_source_test_case260" value="CREATE PROCEDURE
p6() BEGIN DECLARE CONTINUE HANDLER FOR SQLEXCEPTION BEGIN SELECT
'H1' AS HandlerId; SIGNAL SQLSTATE 'HY000'; # Should *not*
be handled by H1. END; SELECT 'S1' AS SignalId; SIGNAL SQLSTATE
'HY000'; # Should be handled by H1. END" db-types="MySQL"/>
<sql-case id="create_by_mysql_source_test_case261" value="CREATE PROCEDURE
p6() BEGIN SELECT CAST('6x' as unsigned integer); SHOW WARNINGS; END"
db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case262" value="CREATE PROCEDURE
p6(arg DECIMAL(2)) BEGIN DECLARE var DECIMAL(1); SET var := arg; SELECT arg,
var; END" db-types="MySQL"/>
<sql-case id="create_by_mysql_source_test_case263" value="CREATE PROCEDURE
p7() BEGIN DECLARE CONTINUE HANDLER FOR SQLWARNING BEGIN SELECT 'H1'
AS HandlerId; SIGNAL SQLSTATE '01000'; # Should *not* be handled by
H1. END; SELECT 'S1' AS SignalId; SIGNAL SQLSTATE '01000';
# Should be handled by H1. END" db-types="MySQL"/>
<sql-case id="create_by_mysql_source_test_case265" value="CREATE PROCEDURE
p7_show_warnings () BEGIN SHOW VARIABLES LIKE 'foo'; SHOW WARNINGS;
SELECT "(SHOW WARNINGS does not have to come last)"; END"
db-types="MySQL"/>
<sql-case id="create_by_mysql_source_test_case266" value="CREATE PROCEDURE
p8() BEGIN DECLARE CONTINUE HANDLER FOR SQLWARNING SELECT 'H1' AS
HandlerId; DECLARE CONTINUE HANDLER FOR SQLEXCEPTION BEGIN SELECT
'H2' AS HandlerId; SIGNAL SQLSTATE '01000'; # Should *not*
be handled by H1. END; SELECT 'S1' AS SignalId; SIGNAL SQLSTATE
'HY000'; # Should be handled by H2. END" db-types="MySQL"/>
<sql-case id="create_by_mysql_source_test_case267" value="CREATE PROCEDURE
p8b_show_warnings () BEGIN SHOW WARNINGS; END" db-types="MySQL"/>
<sql-case id="create_by_mysql_source_test_case268" value="CREATE PROCEDURE
p9() BEGIN DECLARE CONTINUE HANDLER FOR SQLSTATE '01000' SELECT
'Wrong:H1:1' AS HandlerId; DECLARE CONTINUE HANDLER FOR SQLWARNING
SELECT 'Wrong:H1:2' AS HandlerId; DECLARE CONTINUE HANDLER FOR
SQLEXCEPTION BEGIN DECLARE CONTINUE HANDLER FOR SQLSTATE '01000'
SELECT 'Wrong:H2:1' AS HandlerId; DECLARE CONTINUE HANDLER FOR
SQLWARNING SELECT 'Wrong:H2:2' [...]
<sql-case id="create_by_mysql_source_test_case269" value="CREATE PROCEDURE
p_install() BEGIN INSTALL PLUGIN no_such_plugin SONAME
'no_such_object'; END" db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case270" value="CREATE PROCEDURE
p_suid(IN i INT) SQL SECURITY DEFINER SET @c:= 0" db-types="MySQL"/>
<sql-case id="create_by_mysql_source_test_case271" value="CREATE PROCEDURE
peter1 () BEGIN DECLARE v INTEGER DEFAULT 1234; DECLARE CONTINUE HANDLER FOR
SQLWARNING BEGIN SHOW WARNINGS; SELECT "handler done: ",v; END;
CREATE TABLE gg (smallint_column SMALLINT); CALL peter2(v); END"
db-types="MySQL"/>
<sql-case id="create_by_mysql_source_test_case274" value="CREATE PROCEDURE
peter_p1 () BEGIN DECLARE x CONDITION FOR SQLSTATE '42000'; DECLARE
EXIT HANDLER FOR x BEGIN SHOW WARNINGS; RESIGNAL x SET MYSQL_ERRNO = 9999; END;
BEGIN DECLARE EXIT HANDLER FOR x BEGIN SHOW WARNINGS; RESIGNAL x SET
SCHEMA_NAME = 'test', MYSQL_ERRNO= 1232; END; /* Raises
ER_WRONG_VALUE_FOR_VAR : 1231, SQLSTATE 42000 */ SET @@sql_mode=NULL; END; END"
db-types="MySQL"/>
<sql-case id="create_by_mysql_source_test_case275" value="CREATE PROCEDURE
peter_p2 () BEGIN DECLARE x CONDITION for SQLSTATE '42000'; DECLARE
EXIT HANDLER FOR x BEGIN SHOW WARNINGS; RESIGNAL x SET MESSAGE_TEXT = 'Hi,
I am a useless error message', MYSQL_ERRNO = 9999; END; CALL peter_p1();
END" db-types="MySQL"/>
@@ -227,7 +218,6 @@
<sql-case id="create_by_mysql_source_test_case312" value="CREATE PROCEDURE
test_hint (hint_str VARCHAR(255), var_str VARCHAR(64)) BEGIN SET @orig_q=
CONCAT("SELECT VARIABLE_VALUE FROM performance_schema.session_variables
where VARIABLE_NAME = '", var_str, "'"); SET @hint_q=
CONCAT("SELECT /*+ ", hint_str, "*/ VARIABLE_VALUE" ,
" FROM performance_schema.session_variables where VARIABLE_NAME =
'", var_str, "'& [...]
<sql-case id="create_by_mysql_source_test_case313" value="CREATE PROCEDURE
test_if_commit() BEGIN ROLLBACK; SELECT IF (COUNT(*) > 0, "YES",
"NO") AS "IMPLICIT COMMIT" FROM trans; DELETE FROM trans;
COMMIT; END" db-types="MySQL"/>
<sql-case id="create_by_mysql_source_test_case314" value="CREATE PROCEDURE
test_round(in arg bigint) BEGIN DECLARE i int; SET i = 0; WHILE (i >= -20)
DO BEGIN DECLARE CONTINUE HANDLER FOR SQLSTATE '22003' SHOW ERRORS;
SELECT arg, i, round(arg, i); END; SET i = i - 1; END WHILE; END"
db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case315" value="CREATE PROCEDURE
test_round_fn() BEGIN DECLARE num_digits int; SET num_digits := 3; CREATE
TEMPORARY TABLE tmp_test ( number double ); INSERT INTO tmp_test VALUES
(1),(0); SELECT number, Round(number, num_digits) > 0, Round(number, 3) >
0 FROM tmp_test; SELECT number, Round(number, num_digits) > 0, Round(number,
3) > 0 FROM tmp_test WHERE Round(number, 3) >= 0; SELECT number,
Round(number, num_digits) > 0, Ro [...]
<sql-case id="create_by_mysql_source_test_case316" value="CREATE PROCEDURE
test_round_unsigned(in arg bigint unsigned) BEGIN DECLARE i int; SET i = 0;
WHILE (i >= -20) DO BEGIN DECLARE CONTINUE HANDLER FOR SQLSTATE
'22003' SHOW ERRORS; SELECT arg, i, round(arg, i); END; SET i = i -
1; END WHILE; END" db-types="MySQL"/>
<sql-case id="create_by_mysql_source_test_case321" value="CREATE ROLE of"
db-types="MySQL"/>
<sql-case id="create_by_mysql_source_test_case322" value="CREATE ROLE r1
IDENTIFIED BY 'test'" db-types="MySQL"/>
@@ -470,26 +460,16 @@
<sql-case id="create_by_mysql_source_test_case673" value="CREATE TEMPORARY
TABLE t1 (f1 INT) START TRANSACTION" db-types="MySQL"/>
<sql-case id="create_by_mysql_source_test_case674" value="CREATE TEMPORARY
TABLE t6(a INT) ENGINE = MERGE UNION = ()" db-types="MySQL"/>
<sql-case id="create_by_mysql_source_test_case675" value="CREATE TRIGGER
BUG_12490 BEFORE UPDATE ON t_bug_12490 FOR EACH ROW HELP CONTENTS"
db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case676" value="CREATE TRIGGER
ai AFTER INSERT ON t1 FOR EACH ROW SET @a:= NEW.at" db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case677" value="CREATE TRIGGER
bi_t5 BEFORE INSERT ON t5 FOR EACH ROW SET @a:= (SELECT COUNT(*) FROM t1)"
db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case678" value="CREATE TRIGGER
bi_t6 BEFORE INSERT ON t6 FOR EACH ROW SET @a:= (SELECT COUNT(*) FROM t2)"
db-types="MySQL"/>
<sql-case id="create_by_mysql_source_test_case679" value="CREATE TRIGGER
bug21975 BEFORE INSERT ON t1 FOR EACH ROW BEGIN grant select on t1 to
'mysqltest_1'; END" db-types="MySQL"/>
<sql-case id="create_by_mysql_source_test_case680" value="CREATE TRIGGER
bug21975 BEFORE INSERT ON t1 FOR EACH ROW BEGIN revoke all privileges on *.*
from 'mysqltest_1'; END" db-types="MySQL"/>
<sql-case id="create_by_mysql_source_test_case681" value="CREATE TRIGGER
bug21975 BEFORE INSERT ON t1 FOR EACH ROW BEGIN revoke select on t1 from
'mysqltest_1'; END" db-types="MySQL"/>
<sql-case id="create_by_mysql_source_test_case682" value="CREATE TRIGGER f
BEFORE INSERT ON t1 FOR EACH ROW BEGIN INSERT INTO t1 ( `int` ) VALUES (4 ),( 8
),( 2 )" db-types="MySQL"/>
<sql-case id="create_by_mysql_source_test_case683" value="CREATE TRIGGER f
BEFORE INSERT ON t1 FOR EACH ROW BEGIN UPDATE A SET `pk`=1 WHERE `pk`=0"
db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case684" value="CREATE TRIGGER
t1_BI BEFORE INSERT ON t1 FOR EACH ROW SET NEW.id := -1" db-types="MySQL"/>
<sql-case id="create_by_mysql_source_test_case685" value="CREATE TRIGGER
t1_au AFTER UPDATE ON t1 FOR EACH ROW CREATE SERVER s FOREIGN DATA WRAPPER
mysql OPTIONS (USER 'Remote', HOST '192.168.1.106',
DATABASE 'test')" db-types="MySQL"/>
<sql-case id="create_by_mysql_source_test_case686" value="CREATE TRIGGER
t1_au AFTER UPDATE ON t1 FOR EACH ROW START SLAVE" db-types="MySQL"/>
<sql-case id="create_by_mysql_source_test_case687" value="CREATE TRIGGER
t1_au AFTER UPDATE ON t1 FOR EACH ROW STOP SLAVE" db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case689" value="CREATE TRIGGER
t1_bi BEFORE INSERT ON t1 FOR EACH ROW SET @a:= (SELECT COUNT(*) FROM t1)"
db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case690" value="CREATE TRIGGER
t1_bi BEFORE INSERT ON t1 FOR EACH ROW SET @a:=0" db-types="MySQL"/>
<sql-case id="create_by_mysql_source_test_case691" value="CREATE TRIGGER
t1_bu BEFORE UPDATE ON t1 FOR EACH ROW ALTER SERVER s OPTIONS (password
'1')" db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case692" value="CREATE TRIGGER
t1_trg_after_del AFTER DELETE ON t1 FOR EACH ROW SET @a := 1" db-types="MySQL"/>
<sql-case id="create_by_mysql_source_test_case693" value="CREATE TRIGGER
t1bu BEFORE UPDATE ON bug22580_t1 FOR EACH ROW BEGIN CALL bug22580_proc_1();
END|" db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case694" value="CREATE TRIGGER
testtrigger_1 BEFORE INSERT ON testtable_1 FOR EACH ROW SET @a:=1"
db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case695" value="CREATE TRIGGER
testtrigger_1 BEFORE INSERT ON testtable_1 FOR EACH ROW SET @a:=1"
db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case696" value="CREATE TRIGGER
tr0_bi BEFORE INSERT ON t1 FOR EACH ROW PRECEDES tr1_bi SET @a:=0"
db-types="MySQL"/>
<sql-case id="create_by_mysql_source_test_case697" value="CREATE TRIGGER
tr1 AFTER DELETE ON t1 FOR EACH ROW BEGIN INSERT INTO t1 SELECT * FROM t1 AS A"
db-types="MySQL"/>
<sql-case id="create_by_mysql_source_test_case698" value="CREATE TRIGGER
tr1 AFTER UPDATE ON t1 FOR EACH ROW ALTER DATABASE db1 CHARACTER SET latin1"
db-types="MySQL"/>
<sql-case id="create_by_mysql_source_test_case699" value="CREATE TRIGGER
tr1 AFTER UPDATE ON t1 FOR EACH ROW ALTER USER
'u1'@'localhost' PASSWORD EXPIRE" db-types="MySQL"/>
@@ -512,51 +492,7 @@
<sql-case id="create_by_mysql_source_test_case716" value="CREATE TRIGGER
tr1 BEFORE INSERT ON t1 FOR EACH ROW BEGIN rename table t1 to t2; END"
db-types="MySQL"/>
<sql-case id="create_by_mysql_source_test_case717" value="CREATE TRIGGER
tr1 BEFORE INSERT ON t1 FOR EACH ROW BEGIN rename user 'mysqltest_2'
to 'mysqltest_1'; END" db-types="MySQL"/>
<sql-case id="create_by_mysql_source_test_case718" value="CREATE TRIGGER
tr1 BEFORE INSERT ON t1 FOR EACH ROW BEGIN unlock tables; END"
db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case719" value="CREATE TRIGGER
tr1_1_bi BEFORE INSERT ON t1 FOR EACH ROW FOLLOWS tr1_bi SET @a:=0"
db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case720" value="CREATE TRIGGER
tr1_ai AFTER INSERT ON t1 FOR EACH ROW FOLLOWS tr1_bi SET @a:=3"
db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case721" value="CREATE TRIGGER
tr1_au AFTER UPDATE ON t1 FOR EACH ROW FOLLOWS tr1_bu SET @a:=3"
db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case722" value="CREATE TRIGGER
tr1_bi BEFORE INSERT ON t1 FOR EACH ROW SET @a:=1" db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case723" value="CREATE TRIGGER
tr1_bi BEFORE INSERT ON t1 FOR EACH ROW SET @a:=1" db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case724" value="CREATE TRIGGER
tr1_bi BEFORE INSERT ON t1 FOR EACH ROW SET @a:=1" db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case725" value="CREATE TRIGGER
tr1_bi BEFORE INSERT ON t1 FOR EACH ROW SET @a:=1" db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case726" value="CREATE TRIGGER
tr1_bi BEFORE INSERT ON t1 FOR EACH ROW SET @a:=1" db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case727" value="CREATE TRIGGER
tr1_bi BEFORE INSERT ON t1 FOR EACH ROW SET @a:=1" db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case728" value="CREATE TRIGGER
tr1_bi BEFORE INSERT ON t1 FOR EACH ROW SET @a:=1" db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case729" value="CREATE TRIGGER
tr1_bi BEFORE INSERT ON t1 FOR EACH ROW SET @a:=1" db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case730" value="CREATE TRIGGER
tr1_bi BEFORE INSERT ON t1 FOR EACH ROW SET @a:=1" db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case731" value="CREATE TRIGGER
tr1_bi BEFORE INSERT ON t1 FOR EACH ROW SET @a:=1" db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case732" value="CREATE TRIGGER
tr1_bi BEFORE INSERT ON t1 FOR EACH ROW SET @a:=1" db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case733" value="CREATE TRIGGER
tr1_bi BEFORE INSERT ON t1 FOR EACH ROW SET @a:=1" db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case734" value="CREATE TRIGGER
tr1_bi BEFORE INSERT ON t1 FOR EACH ROW SET @a:=1" db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case735" value="CREATE TRIGGER
tr1_bi BEFORE INSERT ON t1 FOR EACH ROW SET @a:=2" db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case736" value="CREATE TRIGGER
tr1_bu BEFORE UPDATE ON t1 FOR EACH ROW SET @a:=3" db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case737" value="CREATE TRIGGER
tr1_bu BEFORE UPDATE ON t1 FOR EACH ROW SET @a:=3" db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case738" value="CREATE TRIGGER
tr1_bu BEFORE UPDATE ON t1 FOR EACH ROW SET @a:=3" db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case739" value="CREATE TRIGGER
tr1_bu BEFORE UPDATE ON t1 FOR EACH ROW SET @a:=3" db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case740" value="CREATE TRIGGER
tr2_au AFTER UPDATE ON t1 FOR EACH ROW FOLLOWS tr1_bi SET @a:=3"
db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case741" value="CREATE TRIGGER
tr2_bi BEFORE INSERT ON t1 FOR EACH ROW FOLLOWS tr0_bi SET @a:=2"
db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case742" value="CREATE TRIGGER
tr2_bi BEFORE INSERT ON t1 FOR EACH ROW PRECEDES tr0_bi SET @a:=2"
db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case743" value="CREATE TRIGGER
tr2_bi BEFORE INSERT ON t1 FOR EACH ROW SET @a:=2" db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case744" value="CREATE TRIGGER
tr2_bi BEFORE INSERT ON t1 FOR EACH ROW SET @a:=2" db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case745" value="CREATE TRIGGER
tr2_bi BEFORE INSERT ON t1 FOR EACH ROW SET @a:=2" db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case746" value="CREATE TRIGGER
tr2_bi BEFORE INSERT ON t1 FOR EACH ROW SET @a:=2" db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case747" value="CREATE TRIGGER
tr2_bi BEFORE INSERT ON t1 FOR EACH ROW SET @a:=2" db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case748" value="CREATE TRIGGER
tr2_bi BEFORE INSERT ON t1 FOR EACH ROW SET @a:=2" db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case749" value="CREATE TRIGGER
tr2_bu BEFORE UPDATE ON t1 FOR EACH ROW FOLLOWS tr1_bi SET @a:=3"
db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case750" value="CREATE TRIGGER
tr2_bu BEFORE UPDATE ON t1 FOR EACH ROW FOLLOWS tr1_bu SET @a:=3"
db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case751" value="CREATE TRIGGER
tr3_bi BEFORE INSERT ON t1 FOR EACH ROW FOLLOWS tr2_bi SET @a:=3"
db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case752" value="CREATE TRIGGER
tr3_bi BEFORE INSERT ON t1 FOR EACH ROW SET @a:=3" db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case753" value="CREATE TRIGGER
tr3_bi BEFORE INSERT ON t1 FOR EACH ROW SET @a:=3" db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case759" value="CREATE TRIGGER
trg27563 BEFORE INSERT ON t1 FOR EACH ROW BEGIN DECLARE CONTINUE HANDLER FOR
SQLSTATE '70100' SET @a:= 'killed'; DECLARE CONTINUE
HANDLER FOR SQLEXCEPTION SET @a:= 'exception'; INSERT INTO t2
VALUES(0); SET DEBUG_SYNC= 'now SIGNAL in_sync WAIT_FOR kill'; INSERT
INTO t2 VALUES(1); END" db-types="MySQL"/>
<sql-case id="create_by_mysql_source_test_case760" value="CREATE TRIGGER
trig_t1_ins BEFORE INSERT ON t1 FOR EACH ROW BEGIN SET @aux = GET_LOCK(2,1)"
db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case761" value="CREATE TRIGGER
trigger_before_update BEFORE UPDATE ON t1 FOR EACH ROW SET @x:= NEW.a"
db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case762" value="CREATE TRIGGER
trigger_before_update BEFORE UPDATE ON t1 FOR EACH ROW SET @x:= NEW.a"
db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case763" value="CREATE TRIGGER
trigger_before_update_with_join BEFORE UPDATE ON t1 FOR EACH ROW SET @x:=
NEW.a" db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case764" value="CREATE TRIGGER
trigger_for_insert_select BEFORE INSERT ON t1 FOR EACH ROW SET @x:= NEW.a"
db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case765" value="CREATE TRIGGER
trigger_for_load_infile BEFORE INSERT ON t1 FOR EACH ROW SET @x:= NEW.a"
db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case766" value="CREATE TRIGGER
trigger_for_normal_insert BEFORE INSERT ON t1 FOR EACH ROW SET @x:= NEW.a"
db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case767" value="CREATE TRIGGER
trigger_for_normal_replace BEFORE INSERT ON t1 FOR EACH ROW SET @x:= NEW.a"
db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case768" value="CREATE TRIGGER
trigger_for_replace_select BEFORE INSERT ON t1 FOR EACH ROW SET @x:= NEW.a"
db-types="MySQL"/>
<sql-case id="create_by_mysql_source_test_case774" value="CREATE USER
ACCOUNT LOCK user6@localhost" db-types="MySQL"/>
<sql-case id="create_by_mysql_source_test_case775" value="CREATE USER
ACCOUNT UNLOCK user5@localhost" db-types="MySQL"/>
<sql-case id="create_by_mysql_source_test_case776" value="CREATE USER IF
NOT EXISTS event_u2@192.1.1.140" db-types="MySQL"/>
@@ -628,9 +564,6 @@
<sql-case id="create_by_mysql_source_test_case856" value="create aggregate
function bug16896() returns int return 1" db-types="MySQL"/>
<sql-case id="create_by_mysql_source_test_case858" value="create
definer=some_user@`` sql security invoker view v1 as select 1"
db-types="MySQL"/>
<sql-case id="create_by_mysql_source_test_case865" value="create function
`f``1` () returns int return 5" db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case866" value="create function
bug10015_2() returns int begin declare i, s int; set i:= (select min(id) from
t1); set s:= (select max(id) from t1); return (s - i); end" db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case867" value="create function
bug10015_4(i int) returns int begin declare m int; set m:= (select max(id) from
t2); insert into t2 values (i, m); return m; end" db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case868" value="create function
bug10015_6(i int) returns int begin declare continue handler for sqlexception
set @error_in_func:= 1; if (i = 5) then insert into t2 values (4, 0), (1, 0);
end if; return i; end" db-types="MySQL"/>
<sql-case id="create_by_mysql_source_test_case869" value="create function
bug10015_7() returns int begin commit; return 1; end" db-types="MySQL"/>
<sql-case id="create_by_mysql_source_test_case870" value="create function
bug10015_7() returns int begin start transaction; return 1; end"
db-types="MySQL"/>
<sql-case id="create_by_mysql_source_test_case872" value="create function
bug13825_0() returns int begin rollback to savepoint x; return 1; end"
db-types="MySQL"/>
@@ -659,16 +592,8 @@
<sql-case id="create_by_mysql_source_test_case912" value="create function
f1() returns int begin declare res int" db-types="MySQL"/>
<sql-case id="create_by_mysql_source_test_case915" value="create function
f1() returns int begin drop event e2; return 1; end" db-types="MySQL"/>
<sql-case id="create_by_mysql_source_test_case916" value="create function
f1() returns int begin show create event e1; return 1; end" db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case930" value="create function
f3() returns int begin declare n int; declare m int; set n:= (select min(data)
from t1); set m:= (select max(data) from t1); return n < m; end"
db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case934" value="create function
f6() returns int begin declare n int; set n:= f1(); return (select count(*)
from t1 where data <= f7() and data <= n); end" db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case939" value="create function
f9() returns int begin declare a, b int; drop temporary table if exists t3;
create temporary table t3 (id int); insert into t3 values (1), (2), (3); set
a:= (select count(*) from t3); set b:= (select count(*) from t3 t3_alias);
return a + b; end" db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case946" value="create function
func_20713_a() returns int(11) begin declare id int; declare continue handler
for sqlexception set id=null; set @in_func := 1; set id = (select id from
bogus_table_20713 where id = 3); set @in_func := 2; return id; end"
db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case947" value="create function
func_20713_b() returns int(11) begin declare id int; declare continue handler
for sqlstate value '42S02' set id=null; set @in_func := 1; set id =
(select id from bogus_table_20713 where id = 3); set @in_func := 2; return id;
end" db-types="MySQL"/>
<sql-case id="create_by_mysql_source_test_case948" value="create function
func_25345() returns int(11) begin call proc_25345(); return 1; end |"
db-types="MySQL"/>
<sql-case id="create_by_mysql_source_test_case949" value="create function
func_25345_b() returns int(11) begin declare c1 cursor for select a from
table_25345_a; declare c2 cursor for select b from table_25345_b; return 1; end
|" db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case950" value="create function
func_26093_a(x int) returns int begin set @invoked := @invoked + 1; return x;
end" db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case951" value="create function
func_26093_b(x int, y int) returns int begin set @invoked := @invoked + 1;
return x; end" db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case953" value="create function
func_8407_b() returns int begin declare x int default 0; declare continue
handler for sqlstate '42S02' begin set x:= x+1000; end; case (select
1 from no_such_view limit 1) when 1 then set x:= x+1; when 2 then set x:= x+2;
else set x:= x+100; end case; set x:=x + 500; return x; end" db-types="MySQL"/>
<sql-case id="create_by_mysql_source_test_case956" value="create function
p(x int, x char(10)) begin end" db-types="MySQL"/>
<sql-case id="create_by_mysql_source_test_case961" value="create or
replace view v1 (c,d,e,f) as select a,b, a in (select a+2 from t1), a = all
(select a from t1) from t1" db-types="MySQL"/>
<sql-case id="create_by_mysql_source_test_case962" value="create procedure
``() select 1" db-types="MySQL"/>
@@ -785,8 +710,6 @@
<sql-case id="create_by_mysql_source_test_case1184" value="create
procedure p_create() begin declare i int default 1; set
@lock_table_stmt="lock table "; set @drop_table_stmt="drop table
"; while i < @@global.table_definition_cache + 1 do set
@table_name=concat("t_", i); set @opt_comma=if(i=1, "",
", "); set @lock_table_stmt=concat(@lock_table_stmt, @opt_comma,
@table_name, " read"); set @drop_table_stmt=concat(@drop_tabl [...]
<sql-case id="create_by_mysql_source_test_case1188" value="create
procedure proc_1() install plugin my_plug soname
'\\root\\some_plugin.dll'" db-types="MySQL"/>
<sql-case id="create_by_mysql_source_test_case1193" value="create
procedure proc_25345() begin declare c1 cursor for select a from table_25345_a;
declare c2 cursor for select b from table_25345_b; select 1 as result; end |"
db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case1200" value="create
procedure proc_33618_c(num int) begin declare count1 int default '0';
declare vb varchar(30); declare last_row int; while(num>=1) do set
num=num-1; begin declare cur1 cursor for select `a` from t_33618; declare
continue handler for not found set last_row = 1; set last_row:=0; open cur1;
rep1: repeat begin declare cur2 cursor for select `b` from t_33618; fetch cur1
into vb; if (last_row = 1) then leave rep1 [...]
- <sql-case id="create_by_mysql_source_test_case1201" value="create
procedure proc_33618_h(num int) begin declare count1 int default '0';
declare vb varchar(30); declare last_row int; while(num>=1) do set
num=num-1; begin declare cur1 cursor for select `a` from t_33618; declare
continue handler for not found set last_row = 1; set last_row:=0; open cur1;
rep1: repeat begin declare exit handler for 1062 begin end; fetch cur1 into vb;
if (last_row = 1) then leave rep1; end if [...]
<sql-case id="create_by_mysql_source_test_case1202" value="create
procedure proc_bug19733() begin declare v int default 0; while v < 100 do
create index i on t3 (s1); drop index i on t3; set v = v + 1; end while; end"
db-types="MySQL"/>
<sql-case id="create_by_mysql_source_test_case1208" value="create
procedure solver(initial_leftm varchar(200), initial_rightm varchar(200)) begin
declare initial_leftm_j json; declare initial_rightm_j json; set
initial_leftm_j = cast(initial_leftm as json), initial_rightm_j =
cast(initial_rightm as json); with recursive number_of_lines (value) as (select
json_length(initial_rightm_j)), number_of_columns (value) as (select
json_length(json_extract(initial_leftm_j,"$[0]"))) [...]
<sql-case id="create_by_mysql_source_test_case1213" value="create
procedure syntaxerror(t int)" db-types="MySQL"/>
@@ -880,13 +803,6 @@
<sql-case id="create_by_mysql_source_test_case1333" value="create table
test_reserved (resignal int)" db-types="MySQL"/>
<sql-case id="create_by_mysql_source_test_case1334" value="create table
test_reserved (signal int)" db-types="MySQL"/>
<sql-case id="create_by_mysql_source_test_case1345" value="create
temporary table tg (i int not null) engine=merge union=()" db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case1346" value="create trigger
ad after delete on t1 for each row set @a:= old.at" db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case1347" value="create trigger
ai after insert on t1 for each row set @a:= new.at" db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case1348" value="create trigger
au after update on t1 for each row set @a:= new.at" db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case1349" value="create trigger
bd before delete on t1 for each row set @a:= old.bt" db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case1350" value="create trigger
bi before insert on t1 for each row set @a:= new.bt" db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case1351" value="create trigger
bu before update on t1 for each row set @a:= new.bt" db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case1352" value="create trigger
t1_ad after delete on t1 for each row set @log:= concat(@log,
"(AFTER_DELETE: old=(id=", old.id, ", data=",
old.data,"))")" db-types="MySQL"/>
<sql-case id="create_by_mysql_source_test_case1357" value="create trigger
t1_ai after insert on t1 for each row flush hosts" db-types="MySQL"/>
<sql-case id="create_by_mysql_source_test_case1358" value="create trigger
t1_ai after insert on t1 for each row flush logs" db-types="MySQL"/>
<sql-case id="create_by_mysql_source_test_case1359" value="create trigger
t1_ai after insert on t1 for each row flush privileges" db-types="MySQL"/>
@@ -896,94 +812,14 @@
<sql-case id="create_by_mysql_source_test_case1363" value="create trigger
t1_ai after insert on t1 for each row flush user_resources" db-types="MySQL"/>
<sql-case id="create_by_mysql_source_test_case1364" value="create trigger
t1_ai after insert on t1 for each row reset master" db-types="MySQL"/>
<sql-case id="create_by_mysql_source_test_case1365" value="create trigger
t1_ai after insert on t1 for each row reset slave" db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case1366" value="create trigger
t1_ai after insert on t1 for each row set @a := 7" db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case1367" value="create trigger
t1_ai after insert on t1 for each row set @a:= (select max(a) from t1)"
db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case1368" value="create trigger
t1_ai after insert on t1 for each row set @a:=bug11555_1()" db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case1369" value="create trigger
t1_ai after insert on t1 for each row set @log:= concat(@log,
"(AFTER_INSERT: new=(id=", new.id, ", data=",
new.data,"))")" db-types="MySQL"/>
<sql-case id="create_by_mysql_source_test_case1370" value="create trigger
t1_ai after insert on t1 for each row show create event e1" db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case1371" value="create trigger
t1_ai after insert on test.t1 for each row set @b:=new.id" db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case1372" value="create trigger
t1_au after update on t1 for each row set @log:= concat(@log,
"(AFTER_UPDATE: old=(id=", old.id, ", data=", old.data,
") new=(id=", new.id, ", data=", new.data,"))")"
db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case1373" value="create trigger
t1_bd before delete on t1 for each row set @log:= concat(@log,
"(BEFORE_DELETE: old=(id=", old.id, ", data=",
old.data,"))")" db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case1374" value="create trigger
t1_bi before insert on t1 for each row begin if new.id > f1() then set
new.id:= f1(); end if; end" db-types="MySQL"/>
<sql-case id="create_by_mysql_source_test_case1375" value="create trigger
t1_bi before insert on t1 for each row begin insert into t2 values (new.id,
new.v); update t2 set v=v+1 where id= new.id; replace t3 values (new.id, 0);
update t2, t3 set t2.v=new.v, t3.v=new.v where t2.id=t3.id; create temporary
table t5 select * from t1; delete from t5; insert into t5 select * from t1;
insert into t4 values (0); set @check= (select count(*) from t5); update t4 set
c= @check; drop temporary ta [...]
- <sql-case id="create_by_mysql_source_test_case1376" value="create trigger
t1_bi before insert on t1 for each row begin set new.a := upper(new.a); set
new.b := new.b + 3; end" db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case1377" value="create trigger
t1_bi before insert on t1 for each row set @a:= f1() + 10" db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case1378" value="create trigger
t1_bi before insert on t1 for each row set @a:=1" db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case1379" value="create trigger
t1_bi before insert on t1 for each row set @a:=1" db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case1380" value="create trigger
t1_bi before insert on t1 for each row set @a:=1/0" db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case1381" value="create trigger
t1_bi before insert on t1 for each row set @a:=new.id" db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case1382" value="create trigger
t1_bi before insert on t1 for each row set @a:=new.id" db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case1383" value="create trigger
t1_bi before insert on t1 for each row set @log:= concat(@log,
"(BEFORE_INSERT: new=(id=", new.id, ", data=",
new.data,"))")" db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case1384" value="create trigger
t1_bi before insert on t1 for each row set NEW.b := "In trigger
t1_bi"" db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case1385" value="create trigger
t1_bi before insert on t1 for each row set new.udt:= convert_tz(new.ldt,
'Europe/Moscow', 'UTC')" db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case1386" value="create trigger
t1_bi before insert on test.t1 for each row set @a:=0" db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case1387" value="create trigger
t1_bu before update on t1 for each row set @log:= concat(@log,
"(BEFORE_UPDATE: old=(id=", old.id, ", data=", old.data,
") new=(id=", new.id, ", data=", new.data,"))")"
db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case1388" value="create trigger
t1_trg before insert on t1 for each row set NEW.id:= 1" db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case1390" value="create trigger
t2_ai after insert on t2 for each row set @a:= (select max(a) from t2)"
db-types="MySQL"/>
<sql-case id="create_by_mysql_source_test_case1391" value="create trigger
t2_bd before delete on t2 for each row begin insert into t1 values (2);
savepoint x; insert into t1 values (3); rollback to savepoint x; insert into t1
values (4); end" db-types="MySQL"/>
<sql-case id="create_by_mysql_source_test_case1392" value="create trigger
t2_bi before insert on t2 for each row rollback to savepoint x"
db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case1393" value="create trigger
t2_bi before insert on t2 for each row set @a:=1" db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case1394" value="create trigger
t2_bi before insert on t2 for each row set @a:=1" db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case1395" value="create trigger
t2_bi before insert on t2 for each row set @a:=1" db-types="MySQL"/>
<sql-case id="create_by_mysql_source_test_case1396" value="create trigger
t2_bu before update on t2 for each row release savepoint x" db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case1399" value="create trigger
t4_bi before insert on t4 for each row set @t4_bi_called:=1" db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case1400" value="create trigger
t4_bu before update on t4 for each row set @t4_bu_called:=1" db-types="MySQL"/>
<sql-case id="create_by_mysql_source_test_case1403" value="create trigger
t_16_bi before insert on t_16 for each row create event e_16 on schedule every
1 second do set @a=5" db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case1404" value="create trigger
test.t1_bi before insert on t1 for each row set @a:=0" db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case1405" value="create trigger
test.trg1 before insert on t1 for each row set @a:= 1" db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case1406" value="create trigger
trg after delete on t1 for each row set @del:= 1" db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case1407" value="create trigger
trg after insert on t1 for each row set @a:= if(@a,concat(@a, ":",
new.i), new.i)" db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case1408" value="create trigger
trg after insert on t1 for each row set @a:=1" db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case1409" value="create trigger
trg after update on t1 for each row set @total_change:=@total_change + new.i -
old.i" db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case1410" value="create trigger
trg after update on t1 for each row set new.i:=1" db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case1411" value="create trigger
trg before delete on t1 for each row set @a:= new.i" db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case1412" value="create trigger
trg before delete on t1 for each row set @del_sum:= @del_sum + old.i"
db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case1413" value="create trigger
trg before delete on t1 for each row set new.i:=1" db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case1415" value="create trigger
trg before insert on t1 for each row begin if isnull(new.j) then set new.j:=
new.i * 10; end if; end" db-types="MySQL"/>
<sql-case id="create_by_mysql_source_test_case1416" value="create trigger
trg before insert on t1 for each row begin select event_name from
information_schema.events; end|
--error ER_EVENT_RECURSION_FORBIDDEN create function f1()
returns int begin create event e2 on schedule every 10 hour do select 1; return
1; end" db-types="MySQL"/>
<sql-case id="create_by_mysql_source_test_case1417" value="create trigger
trg before insert on t1 for each row begin show create event e1; end"
db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case1418" value="create trigger
trg before insert on t1 for each row set @a:= old.i" db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case1419" value="create trigger
trg before insert on t1 for each row set @a:=1" db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case1420" value="create trigger
trg before insert on t1 for each row set @a:=1" db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case1421" value="create trigger
trg before insert on t1 for each row set @a:=1" db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case1422" value="create trigger
trg before insert on t1 for each row set @a:=new.i" db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case1423" value="create trigger
trg before insert on t2 for each row set @a:=1" db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case1424" value="create trigger
trg before insert on t3 for each row set @a:=1" db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case1425" value="create trigger
trg before insert on v1 for each row set @a:=1" db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case1426" value="create trigger
trg before update on t1 for each row begin declare loc_err varchar(255); if
abs(new.balance - old.balance) > 1000 then set new.balance:= old.balance;
set loc_err := concat("Too big change for aid = ", new.aid); set
@update_failed:= if(@update_failed, concat(@a, ":", loc_err),
loc_err); end if; end" db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case1427" value="create trigger
trg before update on t1 for each row set @a:=old.j" db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case1428" value="create trigger
trg before update on t1 for each row set new.j:=1" db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case1429" value="create trigger
trg before update on t1 for each row set old.i:=1" db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case1430" value="create trigger
trg1 before delete on t1 for each row set @del_before:= @del_before + old.i"
db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case1431" value="create trigger
trg1 before insert on mysqltest.t1 for each row set @a:= 1" db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case1432" value="create trigger
trg1 before insert on t1 for each row begin if new.a > 10 then set new.a :=
10; set new.a := 11; end if; end" db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case1433" value="create trigger
trg1 before insert on t1 for each row begin if new.i = 1 then set new.j := 1;
end if; end" db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case1434" value="create trigger
trg1 before insert on t1 for each row begin if new.j > 10 then set new.j :=
10; end if; end" db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case1435" value="create trigger
trg1 before insert on t1 for each row begin if new.j > 10 then set new.j :=
10; end if; end" db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case1436" value="create trigger
trg1 before insert on t1 for each row set @a:= 1" db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case1437" value="create trigger
trg1 before insert on t1 for each row set @a:=1" db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case1438" value="create trigger
trg1 before update on t1 for each row set @a:= @a + new.j - old.j"
db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case1439" value="create trigger
trg2 after delete on t1 for each row set @del_after:= @del_after + old.i"
db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case1440" value="create trigger
trg2 after insert on t1 for each row set @a:= 1" db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case1441" value="create trigger
trg2 after insert on t1 for each row set @b:= "Fired""
db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case1442" value="create trigger
trg2 after update on t1 for each row set @b:= "Fired""
db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case1443" value="create trigger
trg2 before insert on t3 for each row set @a:=1" db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case1444" value="create trigger
trg2 before update on t1 for each row begin if old.a % 2 = 0 then set new.b :=
12; end if; end" db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case1445" value="create trigger
trg2 before update on t1 for each row begin if old.i % 2 = 0 then set new.j :=
-1; end if; end" db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case1446" value="create trigger
trg2 before update on t1 for each row begin if old.i % 2 = 0 then set new.j :=
-1; end if; end" db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case1447" value="create trigger
trg3 after update on t1 for each row begin if new.a = -1 then set @fired:=
"Yes"; end if; end" db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case1448" value="create trigger
trg3 after update on t1 for each row begin if new.j = -1 then set @fired:=
"Yes"; end if; end" db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case1449" value="create trigger
trg3 after update on t1 for each row begin if new.j = -1 then set @fired:=
"Yes"; end if; end" db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case1450" value="create trigger
trg3 before delete on t1 for each row set @c:= @c + old.j" db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case1451" value="create trigger
trg4 before delete on t2 for each row set @d:= @d + old.i" db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case1452" value="create trigger
trg4 before insert on t2 for each row begin if new.a > 10 then set @fired:=
"No"; end if; end" db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case1453" value="create trigger
trg5 after delete on t1 for each row set @e:= "After delete t1
fired"" db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case1454" value="create trigger
trg6 after delete on t2 for each row set @f:= "After delete t2
fired"" db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case1455" value="create trigger
trigger_overflow before insert on table_overflow for each row BEGIN BEGIN BEGIN
BEGIN BEGIN BEGIN BEGIN BEGIN BEGIN BEGIN BEGIN BEGIN BEGIN BEGIN BEGIN BEGIN
BEGIN BEGIN BEGIN BEGIN BEGIN BEGIN BEGIN BEGIN BEGIN BEGIN BEGIN BEGIN BEGIN
BEGIN BEGIN BEGIN BEGIN BEGIN BEGIN BEGIN BEGIN BEGIN BEGIN BEGIN BEGIN BEGIN
BEGIN BEGIN BEGIN BEGIN BEGIN BEGIN BEGIN BEGIN BEGIN BEGIN BEGIN BEGIN BEGIN
BEGIN BEGIN BEGIN BEGI [...]
- <sql-case id="create_by_mysql_source_test_case1456" value="create trigger
wont_work after update on event for each row begin set @a:= 1; end"
db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case1457" value="create trigger
wont_work after update on mysql.user for each row begin set @a:= 1; end"
db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case1458" value="create trigger
имя_триггера_в_кодировке_утф8_длиной_больше_чем_49 before insert on
имя_таблицы_в_кодировке_утф8_длиной_больше_чем_48 for each row set @a:=1"
db-types="MySQL"/>
- <sql-case id="create_by_mysql_source_test_case1459" value="create trigger
очень_очень_очень_очень_очень_очень_очень_очень_длинная_строка_66 before insert
on имя_таблицы_в_кодировке_утф8_длиной_больше_чем_48 for each row set @a:=1"
db-types="MySQL"/>
<sql-case id="create_by_mysql_source_test_case1460" value="create user
test@127.0.0.1 identified by "gambling"" db-types="MySQL"/>
<sql-case id="create_by_mysql_source_test_case1461" value="create view
bug12602983_v1 as select mysqltest_db.f1()" db-types="MySQL"/>
<sql-case id="create_by_mysql_source_test_case1462" value="create view
bug12602983_v1 as select mysqltest_db.f_does_not_exist()" db-types="MySQL"/>
@@ -3409,9 +3245,6 @@
<sql-case id="resignal_by_mysql_source_test_case3" value="RESIGNAL
SQLSTATE VALUE '12345'" db-types="MySQL"/>
<sql-case id="resignal_by_mysql_source_test_case4" value="RESIGNAL foo"
db-types="MySQL"/>
<sql-case id="set_by_mysql_source_test_case1" value="SET
@@global.dragnet.log_error_filter_rules= REPEAT("IF prio>9 THEN drop.
", 1025)" db-types="MySQL"/>
- <sql-case id="set_by_mysql_source_test_case2" value="SET
@@global.max_allowed_packet:= @tmp_max" db-types="MySQL"/>
- <sql-case id="set_by_mysql_source_test_case3" value="SET
@@global.max_allowed_packet:= @tmp_max" db-types="MySQL"/>
- <sql-case id="set_by_mysql_source_test_case4" value="SET
@@global.max_allowed_packet:= DEFAULT" db-types="MySQL"/>
<sql-case id="set_by_mysql_source_test_case5" value="SET
@@myisam_mmap_size= 500M" db-types="MySQL"/>
<sql-case id="set_by_mysql_source_test_case6" value="SET
@ENCSTR=REPEAT('J',255)" db-types="MySQL"/>
<sql-case id="set_by_mysql_source_test_case7" value="SET
@ENCSTR=REPEAT('K',100)" db-types="MySQL"/>
@@ -3422,43 +3255,14 @@
<sql-case id="set_by_mysql_source_test_case12" value="SET
@KEYS=RANDOM_BYTES(1024)" db-types="MySQL"/>
<sql-case id="set_by_mysql_source_test_case13" value="SET
@KEYS=REPEAT('c', 16)" db-types="MySQL"/>
<sql-case id="set_by_mysql_source_test_case14" value="SET
@`tcontent`:=_binary 0x50434B000900000000000000E9000000 COLLATE `binary`/*!*/"
db-types="MySQL"/>
- <sql-case id="set_by_mysql_source_test_case15" value="SET @a := (SELECT
COUNT(*) FROM t1)" db-types="MySQL"/>
- <sql-case id="set_by_mysql_source_test_case16" value="SET @a := (SELECT
afield FROM bigfailure)" db-types="MySQL"/>
- <sql-case id="set_by_mysql_source_test_case17" value="SET @a := (select *
from bigfailure where afield = (SELECT afield FROM bigfailure))"
db-types="MySQL"/>
- <sql-case id="set_by_mysql_source_test_case18" value="SET @a := (select
afield from (SELECT afield FROM bigfailure) as b)" db-types="MySQL"/>
<sql-case id="set_by_mysql_source_test_case19" value="SET @a =
REPEAT('a',1048576)" db-types="MySQL"/>
<sql-case id="set_by_mysql_source_test_case20" value="SET @a =
REPEAT('a',1048576)" db-types="MySQL"/>
<sql-case id="set_by_mysql_source_test_case21" value="SET @a =
REPEAT('a',2147483647)" db-types="MySQL"/>
<sql-case id="set_by_mysql_source_test_case22" value="SET @a =
REPEAT('a',2147483647)" db-types="MySQL"/>
- <sql-case id="set_by_mysql_source_test_case23" value="SET @a:=
b'1010010001000010000010000001000000010000000010000000001000000000010000000000010000000000001'"
db-types="MySQL"/>
- <sql-case id="set_by_mysql_source_test_case24" value="SET @a:=
b'1010010001000010000010000001000000010000000010000000001000000000010000000000010000000000001'"
db-types="MySQL"/>
- <sql-case id="set_by_mysql_source_test_case25" value="SET
@a:='-77777'" db-types="MySQL"/>
- <sql-case id="set_by_mysql_source_test_case26" value="SET
@a:='11'" db-types="MySQL"/>
- <sql-case id="set_by_mysql_source_test_case27" value="SET
@a:='77777'" db-types="MySQL"/>
- <sql-case id="set_by_mysql_source_test_case28" value="SET
@a:='abcd'" db-types="MySQL"/>
- <sql-case id="set_by_mysql_source_test_case29" value="SET @a:=(SELECT
ROW(1, 2)= ROW((SELECT 1 FROM t1 LEFT JOIN t1 t2 ON 1), 1))" db-types="MySQL"/>
- <sql-case id="set_by_mysql_source_test_case30" value="SET @a:=0"
db-types="MySQL"/>
- <sql-case id="set_by_mysql_source_test_case31" value="SET @a:=34"
db-types="MySQL"/>
- <sql-case id="set_by_mysql_source_test_case32" value="SET @a:=5"
db-types="MySQL"/>
- <sql-case id="set_by_mysql_source_test_case33" value="SET
@a:=999999999999999999999999999999999999999999999999999999999999999999999999999999999"
db-types="MySQL"/>
- <sql-case id="set_by_mysql_source_test_case34" value="SET @a:=_binary
'abcd'" db-types="MySQL"/>
- <sql-case id="set_by_mysql_source_test_case35" value="SET @after:= (SELECT
MAX_DATA_LENGTH FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME='t1'
AND TABLE_SCHEMA='test')" db-types="MySQL"/>
- <sql-case id="set_by_mysql_source_test_case36" value="SET @b := _latin1
'a'" db-types="MySQL"/>
<sql-case id="set_by_mysql_source_test_case37" value="SET @before:=
(SELECT MAX_DATA_LENGTH FROM INFORMATION_SCHEMA.TABLES WHERE
TABLE_NAME='t1' AND TABLE_SCHEMA='test')" db-types="MySQL"/>
- <sql-case id="set_by_mysql_source_test_case38" value="SET @c :=
FROM_UNIXTIME(1537002029)" db-types="MySQL"/>
- <sql-case id="set_by_mysql_source_test_case40" value="SET @d:='
'" db-types="MySQL"/>
<sql-case id="set_by_mysql_source_test_case41" value="SET @decimal= 1.1"
db-types="MySQL"/>
<sql-case id="set_by_mysql_source_test_case42" value="SET @drop =
IF(@have_ndb = 0, @drop_cmd, 'SET @dummy = 0')" db-types="MySQL"/>
- <sql-case id="set_by_mysql_source_test_case43" value="SET
@old_50915_lc_time_names := @@lc_time_names" db-types="MySQL"/>
- <sql-case id="set_by_mysql_source_test_case44" value="SET
@old_default_week_format := @@default_week_format" db-types="MySQL"/>
- <sql-case id="set_by_mysql_source_test_case45" value="SET
@old_innodb_thread_concurrency := @@innodb_thread_concurrency"
db-types="MySQL"/>
- <sql-case id="set_by_mysql_source_test_case46" value="SET
@old_innodb_thread_sleep_delay := @@innodb_thread_sleep_delay"
db-types="MySQL"/>
- <sql-case id="set_by_mysql_source_test_case47" value="SET @old_sql_mode :=
@@sql_mode" db-types="MySQL"/>
- <sql-case id="set_by_mysql_source_test_case48" value="SET
@old_transaction_isolation := @@session.transaction_isolation"
db-types="MySQL"/>
<sql-case id="set_by_mysql_source_test_case49" value="SET @rules=
CONCAT("IF ", REPEAT("x", 20000), ">9 THEN
drop.")" db-types="MySQL"/>
- <sql-case id="set_by_mysql_source_test_case50" value="SET @s :=
"SELECT regexp_like( '', '', ? / '' )""
db-types="MySQL"/>
- <sql-case id="set_by_mysql_source_test_case51" value="SET @s1:='do
length(concat(1,bit_xor(aes_encrypt(1,1,1))));'" db-types="MySQL"/>
- <sql-case id="set_by_mysql_source_test_case52" value="SET @s:="do
field('1',monthname(now()),bit_and(export_set(1,'',1,0x29,186)))""
db-types="MySQL"/>
<sql-case id="set_by_mysql_source_test_case53" value="SET @sav_big=
(SELECT COALESCE(@session.big_tables, 0))" db-types="MySQL"/>
<sql-case id="set_by_mysql_source_test_case54" value="SET @save_filters=
@@global.dragnet.log_error_filter_rules" db-types="MySQL"/>
<sql-case id="set_by_mysql_source_test_case55" value="SET @save_filters=
@@global.dragnet.log_error_filter_rules" db-types="MySQL"/>
@@ -3468,7 +3272,6 @@
<sql-case id="set_by_mysql_source_test_case59" value="SET @start_value=
@@global.syseventlog.include_pid" db-types="MySQL"/>
<sql-case id="set_by_mysql_source_test_case60" value="SET @start_value=
@@global.syseventlog.tag" db-types="MySQL"/>
<sql-case id="set_by_mysql_source_test_case61" value="SET
@str_ascii=_ASCII'abcxyz'" db-types="MySQL"/>
- <sql-case id="set_by_mysql_source_test_case62" value="SET @x:= (SELECT h
FROM t1 WHERE (a,b,c,d,e,f,g)=(1,2,3,4,5,6,7))" db-types="MySQL"/>
<sql-case id="show_by_mysql_source_test_case12" value="SHOW CREATE TABLE
```a`" db-types="MySQL"/>
<sql-case id="show_by_mysql_source_test_case13" value="SHOW CREATE TABLE
```ab````cd```" db-types="MySQL"/>
<sql-case id="show_by_mysql_source_test_case14" value="SHOW CREATE TABLE
```ab``cd```" db-types="MySQL"/>
@@ -4064,27 +3867,6 @@
<sql-case id="low_release_by_mysql_source_test_case2" value="release
savepoint sv1" db-types="MySQL"/>
<sql-case id="low_release_by_mysql_source_test_case3" value="release
savepoint x" db-types="MySQL"/>
<sql-case id="low_set_by_mysql_source_test_case1" value="set @``=
"illegal"" db-types="MySQL"/>
- <sql-case id="low_set_by_mysql_source_test_case2" value="set @a :=
connection_id() + 3" db-types="MySQL"/>
- <sql-case id="low_set_by_mysql_source_test_case3" value="set @a := foo"
db-types="MySQL"/>
- <sql-case id="low_set_by_mysql_source_test_case4" value="set @a:=
'.'" db-types="MySQL"/>
- <sql-case id="low_set_by_mysql_source_test_case5" value="set @a:= 0"
db-types="MySQL"/>
- <sql-case id="low_set_by_mysql_source_test_case6" value="set @a:= 0, @b:=
""" db-types="MySQL"/>
- <sql-case id="low_set_by_mysql_source_test_case7" value="set @a:= 0, @b:=
""" db-types="MySQL"/>
- <sql-case id="low_set_by_mysql_source_test_case8" value="set @a:=
bug13825_0()" db-types="MySQL"/>
- <sql-case id="low_set_by_mysql_source_test_case9" value="set @a:=
bug13825_1()" db-types="MySQL"/>
- <sql-case id="low_set_by_mysql_source_test_case10" value="set @a:=
bug13825_2()" db-types="MySQL"/>
- <sql-case id="low_set_by_mysql_source_test_case11" value="set @a:=
bug13825_2()" db-types="MySQL"/>
- <sql-case id="low_set_by_mysql_source_test_case12" value="set @a:=
bug13825_4()" db-types="MySQL"/>
- <sql-case id="low_set_by_mysql_source_test_case13" value="set
@a:=""" db-types="MySQL"/>
- <sql-case id="low_set_by_mysql_source_test_case14" value="set
@a:=""" db-types="MySQL"/>
- <sql-case id="low_set_by_mysql_source_test_case15" value="set @a:=0"
db-types="MySQL"/>
- <sql-case id="low_set_by_mysql_source_test_case16" value="set @a:=0"
db-types="MySQL"/>
- <sql-case id="low_set_by_mysql_source_test_case17" value="set @a:=0"
db-types="MySQL"/>
- <sql-case id="low_set_by_mysql_source_test_case18" value="set @a:=0"
db-types="MySQL"/>
- <sql-case id="low_set_by_mysql_source_test_case19" value="set @a:=0"
db-types="MySQL"/>
- <sql-case id="low_set_by_mysql_source_test_case20" value="set @a:=0"
db-types="MySQL"/>
- <sql-case id="low_set_by_mysql_source_test_case21" value="set @a:=1"
db-types="MySQL"/>
- <sql-case id="low_set_by_mysql_source_test_case22" value="set @a:=1/0"
db-types="MySQL"/>
<sql-case id="low_set_by_mysql_source_test_case23" value="set @a= _binary
0xFDFE0000000000005A55CAFFFEFA9089" db-types="MySQL"/>
<sql-case id="low_set_by_mysql_source_test_case24" value="set @a= date
"2001-01-02"" db-types="MySQL"/>
<sql-case id="low_set_by_mysql_source_test_case25" value="set @a= time
"01:02:00"" db-types="MySQL"/>
@@ -4096,48 +3878,17 @@
<sql-case id="low_set_by_mysql_source_test_case31" value="set @a=date
"2001-01-02"" db-types="MySQL"/>
<sql-case id="low_set_by_mysql_source_test_case32" value="set
@a=repeat("x",1000000)" db-types="MySQL"/>
<sql-case id="low_set_by_mysql_source_test_case33" value="set
@a=repeat(' ',20)" db-types="MySQL"/>
- <sql-case id="low_set_by_mysql_source_test_case34" value="set @b := 1"
db-types="MySQL"/>
- <sql-case id="low_set_by_mysql_source_test_case35" value="set
@b:=""" db-types="MySQL"/>
- <sql-case id="low_set_by_mysql_source_test_case36" value="set
@b:=""" db-types="MySQL"/>
- <sql-case id="low_set_by_mysql_source_test_case37" value="set
@b:='test'" db-types="MySQL"/>
<sql-case id="low_set_by_mysql_source_test_case38" value="set
@b=repeat("y",1000000)" db-types="MySQL"/>
<sql-case id="low_set_by_mysql_source_test_case39" value="set
@b=repeat('A',24000)" db-types="MySQL"/>
- <sql-case id="low_set_by_mysql_source_test_case40" value="set @c:= 0, @d:=
0, @e:= "", @f:= """ db-types="MySQL"/>
- <sql-case id="low_set_by_mysql_source_test_case41" value="set @c:=123"
db-types="MySQL"/>
<sql-case id="low_set_by_mysql_source_test_case42" value="set @check=0,
@t4_bi_called=0, @t4_bu_called=0" db-types="MySQL"/>
<sql-case id="low_set_by_mysql_source_test_case43" value="set @dec=5"
db-types="MySQL"/>
- <sql-case id="low_set_by_mysql_source_test_case44" value="set @del:= 0"
db-types="MySQL"/>
- <sql-case id="low_set_by_mysql_source_test_case45" value="set
@del_before:=0, @del_after:= 0" db-types="MySQL"/>
- <sql-case id="low_set_by_mysql_source_test_case46" value="set @del_sum:=
0" db-types="MySQL"/>
- <sql-case id="low_set_by_mysql_source_test_case47" value="set
@e:=_latin1'77'" db-types="MySQL"/>
- <sql-case id="low_set_by_mysql_source_test_case48" value="set
@error_in_func:= 0" db-types="MySQL"/>
- <sql-case id="low_set_by_mysql_source_test_case49" value="set
@fired:=""" db-types="MySQL"/>
- <sql-case id="low_set_by_mysql_source_test_case50" value="set @id := 1"
db-types="MySQL"/>
- <sql-case id="low_set_by_mysql_source_test_case51" value="set @id:=
connection_id()" db-types="MySQL"/>
- <sql-case id="low_set_by_mysql_source_test_case52" value="set @in_func :=
0" db-types="MySQL"/>
- <sql-case id="low_set_by_mysql_source_test_case53" value="set @in_func :=
0" db-types="MySQL"/>
- <sql-case id="low_set_by_mysql_source_test_case54" value="set @in_func :=
0" db-types="MySQL"/>
- <sql-case id="low_set_by_mysql_source_test_case55" value="set @in_func :=
0" db-types="MySQL"/>
- <sql-case id="low_set_by_mysql_source_test_case56" value="set @invoked :=
0" db-types="MySQL"/>
- <sql-case id="low_set_by_mysql_source_test_case57" value="set @invoked :=
0" db-types="MySQL"/>
- <sql-case id="low_set_by_mysql_source_test_case58" value="set @log:=
""" db-types="MySQL"/>
- <sql-case id="low_set_by_mysql_source_test_case59" value="set @log:=
""" db-types="MySQL"/>
- <sql-case id="low_set_by_mysql_source_test_case60" value="set @log:=
""" db-types="MySQL"/>
- <sql-case id="low_set_by_mysql_source_test_case61" value="set @log:=
""" db-types="MySQL"/>
- <sql-case id="low_set_by_mysql_source_test_case62" value="set @log:=
""" db-types="MySQL"/>
- <sql-case id="low_set_by_mysql_source_test_case63" value="set @prev_score
:= NULL" db-types="MySQL"/>
<sql-case id="low_set_by_mysql_source_test_case64" value="set @q =
repeat('q', 256)" db-types="MySQL"/>
<sql-case id="low_set_by_mysql_source_test_case65" value="set @rank := 0"
db-types="MySQL"/>
- <sql-case id="low_set_by_mysql_source_test_case66" value="set @rownum :=
0" db-types="MySQL"/>
<sql-case id="low_set_by_mysql_source_test_case67" value="set
@select=2,@t5=1.23456" db-types="MySQL"/>
<sql-case id="low_set_by_mysql_source_test_case68" value="set
@test_int=10,@test_double=1e-10,@test_string="abcdeghi",@test_string2="abcdefghij",@select=NULL"
db-types="MySQL"/>
- <sql-case id="low_set_by_mysql_source_test_case69" value="set
@total_change:=0" db-types="MySQL"/>
- <sql-case id="low_set_by_mysql_source_test_case70" value="set
@update_failed:=""" db-types="MySQL"/>
- <sql-case id="low_set_by_mysql_source_test_case71" value="set @var := 0"
db-types="MySQL"/>
<sql-case id="low_set_by_mysql_source_test_case72" value="set charset
default,@dummy='A'" db-types="MySQL"/>
<sql-case id="low_set_by_mysql_source_test_case73" value="set global
init_connect="create procedure p1(x int)\ begin\ select count(*) from t1;\
select * from t1;\ set @x = x" db-types="MySQL"/>
<sql-case id="low_set_by_mysql_source_test_case74" value="set global
sql_mode=repeat('a',80)" db-types="MySQL"/>
- <sql-case id="low_set_by_mysql_source_test_case75" value="set res:=
(select count(*) from t1)" db-types="MySQL"/>
<sql-case id="low_set_by_mysql_source_test_case76" value="set session
@honk=99" db-types="MySQL"/>
<sql-case id="low_show_by_mysql_source_test_case54" value="show local
variables like 'SQL_MODE'" db-types="MySQL"/>
<sql-case id="low_show_by_mysql_source_test_case55" value="show local
variables like 'SQL_MODE'" db-types="MySQL"/>
