You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by du...@apache.org on 2021/12/31 09:48:53 UTC
[shardingsphere] branch master updated: add unsupported sql for mysql (#14466)
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 04af5eb add unsupported sql for mysql (#14466)
04af5eb is described below
commit 04af5eb6f12f47cb2603a10c6e06f64f10602f9d
Author: tuichenchuxin <86...@users.noreply.github.com>
AuthorDate: Fri Dec 31 17:48:11 2021 +0800
add unsupported sql for mysql (#14466)
---
.../main/resources/sql/unsupported/unsupported.xml | 1366 ++++++++++++++++++++
1 file changed, 1366 insertions(+)
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 591c2fb..4803a08 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
@@ -1530,4 +1530,1370 @@
<sql-case id="create_by_mysql_source_test_case1467" value="create view v1 as select test.`f``1` ()" db-types="MySQL"/>
<sql-case id="create_by_mysql_source_test_case1468" value="create view v3 as select bug23491_original.f1()" db-types="MySQL"/>
<sql-case id="create_by_mysql_source_test_case1469" value="create view имя_вью_кодировке_утф8_длиной_больше_чем_42 as select имя_поля_в_кодировке_утф8_длиной_больше_чем_45 from имя_таблицы_в_кодировке_утф8_длиной_больше_чем_48" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case1" value="SELECT COUNTRY FROM t1 WHERE trim(trailing 'a' FROM COUNTRY)= 'Australi'" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case2" value="SELECT MAX(a) FROM t1 WHERE (b) IN (SELECT MIN(t2.b) FROM (SELECT b from t1) AS t2 GROUP BY t2.b WITH ROLLUP HAVING GROUPING (t2.b)=0)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case3" value="SELECT MAX(a) FROM t1 WHERE (b) IN (SELECT MIN(t2.b) FROM t1 AS t2 GROUP BY t2.b WITH ROLLUP HAVING GROUPING (t2.b)=0)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case4" value="SELECT '1' IN ('1', INET_NTOA(0))" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case5" value="SELECT '1' IN ('1', INET_NTOA(0))" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case6" value="SELECT '1' IN ('1', SUBSTRING(-9223372036854775809, 1))" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case7" value="SELECT '1' RLIKE RPAD('1', 10000, '(')" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case8" value="SELECT 'a' = AES_DECRYPT(AES_ENCRYPT('a', 'a'), 'a', REPEAT('a',100))" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case9" value="SELECT 'a' = AES_DECRYPT(AES_ENCRYPT('a', 'a'), 'a', REPEAT('a',16))" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case10" value="SELECT 'c373e9f5ad0791a0dab5444553544200' IN(SELECT t1.FOLDERID FROM t1 WHERE t1.PARENTID='2f6161e879db43c1a5b82c21ddc49089' AND t1.FOLDERNAME = 'Level1')" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case11" value="SELECT ( -1 BETWEEN 9223372036854775808 AND 1 )" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case12" value="SELECT ( 0 BETWEEN 9223372036854775808 AND 1 )" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case13" value="SELECT ( 1 BETWEEN 9223372036854775808 AND 1 )" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case14" value="SELECT ( 9223372036854775807 BETWEEN 9223372036854775808 AND 1 )" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case15" value="SELECT ( 9223372036854775808 BETWEEN 9223372036854775808 AND 9223372036854775808 )" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case16" value="SELECT (((@e:=`b`)) NOT BETWEEN 0x0b5f09 AND (CHAR(md5(@pub1), (CONNECTION_ID()+LEAD(5225.750000,110) RESPECT NULLS OVER(ORDER BY b, a))))) FROM t GROUP BY b,a WITH ROLLUP" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case17" value="SELECT ((+0) IN ((0b111111111111111111111111111111111111111111111111111),(rpad(1.0,2048,1)), (32767.1)))" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case18" value="SELECT ((127.1) not in ((rpad(1.0,2048,1)),(''),(-1.1)))" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case19" value="SELECT ((table1.col_int) * (table1.col_int)) AS field2 FROM (t1 AS table1) WHERE (table1.col_int != 1 OR table1.pk) GROUP BY field2 WITH ROLLUP HAVING (field2 <> 239 ) ORDER BY GROUPING(field2)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case20" value="SELECT (1 + CAST(JSON_OBJECTAGG(1,2) OVER () AS DECIMAL))" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case21" value="SELECT (184467440737095 BETWEEN 0 AND 18446744073709551500)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case22" value="SELECT (SELECT MAX(b) FROM t1) FROM t1 GROUP BY (SELECT MAX(b) FROM t1) WITH ROLLUP HAVING GROUPING((SELECT 1 FROM DUAL))=0" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case23" value="SELECT (SELECT MAX(b) FROM t1) FROM t1 GROUP BY (SELECT MAX(b) FROM t1) WITH ROLLUP HAVING GROUPING((SELECT MAX(b) FROM t1))=0" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case24" value="SELECT (VALUES ROW(1) ORDER BY t) AS a FROM t" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case25" value="SELECT (VALUES ROW(1) ORDER BY w) AS a FROM t" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case26" value="SELECT (_binary x'31' | NULL) + 0" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case27" value="SELECT (_binary x'31' | x'31')" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case28" value="SELECT (_binary x'31' | x'31') + 0" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case29" value="SELECT (a+1) IS NULL, GROUPING(a+1) FROM t1 GROUP BY a+1 WITH ROLLUP" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case30" value="SELECT (derived_1.`COUNT(*) + outer_t.a` + IFNULL(derived_0.`MAX(b)`,0)) + 1 + 5 AS mx FROM (SELECT STRAIGHT_JOIN MAX(outer_t.b) AS `MAX(b)`, outer_t.a AS d_1 FROM t1 outer_t GROUP BY outer_t.a) derived_0 LEFT JOIN LATERAL (SELECT (COUNT(0) + derived_0.d_1) AS `COUNT(*) + outer_t.a` FROM t1) derived_1 ON(true) WHERE true" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case31" value="SELECT (t1.a,t1.a) IN (('a','c'),('a','b')) END FROM t1" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case32" value="SELECT (~(REPEAT(0xb822, 0x5C9C380)))" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case33" value="SELECT * FROM ( SELECT a, JSON_ARRAYAGG(a) OVER () AS b FROM t1 ) AS d1 WHERE (a,b) IN ( SELECT a, JSON_ARRAYAGG(a) OVER () AS b FROM t1 )" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case34" value="SELECT * FROM (SELECT 1, 10 UNION VALUES ROW(2, 20), ROW(3, "30")) AS dt" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case35" value="SELECT * FROM (SELECT i, j, SUM(k) FROM t1 GROUP BY i, j WITH ROLLUP ORDER BY GROUPING(i),i, GROUPING(j),j) as tmp" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case36" value="SELECT * FROM (TABLE t0) AS dt" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case37" value="SELECT * FROM (VALUES ROW(1), ROW(2)) AS dt0 NATURAL JOIN (VALUES ROW(1, 10), ROW(1, 20)) AS dt1" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case38" value="SELECT * FROM (VALUES ROW(1), ROW(2)) AS dt0 NATURAL JOIN (VALUES ROW(1, 10), ROW(2, 20)) AS dt1" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case39" value="SELECT * FROM (VALUES ROW(1),ROW(1)) AS dt(a) WHERE EXISTS( WITH RECURSIVE qn AS (SELECT a*0 AS b UNION ALL SELECT b+1 FROM qn WHERE b=0) SELECT * FROM qn WHERE b=a )" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case40" value="SELECT * FROM (VALUES ROW(1),ROW(1)) AS dt(a) WHERE NOT EXISTS( WITH RECURSIVE qn AS (SELECT a*0 AS b UNION ALL SELECT b+1 FROM qn WHERE b=0) SELECT * FROM qn WHERE b=a )" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case41" value="SELECT * FROM (VALUES ROW(1, 10)) AS dt" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case42" value="SELECT * FROM (VALUES ROW(1, 10), ROW(2, "20") UNION SELECT 3, 30) AS dt" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case43" value="SELECT * FROM (VALUES ROW(1, 10), ROW(2, 20)) AS dt" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case44" value="SELECT * FROM (VALUES ROW(DEFAULT)) AS dt" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case45" value="SELECT * FROM json_table('[]', '$[*]' COLUMNS (p CHAR(1) CHARACTER SET "utf8" PATH '$.a')) AS t" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case46" value="SELECT * FROM json_table('[]', '$[*]' COLUMNS (p CHAR(1) CHARACTER SET 'utf8' PATH '$.a')) AS t" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case47" value="SELECT * FROM json_table('[]', '$[*]' COLUMNS (p CHAR(1) CHARACTER SET `utf8` PATH '$.a')) AS t" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case48" value="SELECT * FROM json_table('[]', '$[*]' COLUMNS (p CHAR(1) CHARACTER SET utf8 PATH '$.a')) AS t" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case49" value="SELECT * FROM json_table('[]', '$[*]' COLUMNS (p NATIONAL CHAR(1) PATH '$.a')) AS t" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case50" value="SELECT * FROM json_table('[]', '$[*]' COLUMNS (p NCHAR PATH '$.a')) AS t" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case51" value="SELECT * FROM json_table('[]', '$[*]' COLUMNS (p NCHAR(1) PATH '$.a')) AS t" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case52" value="SELECT * FROM json_table('[]', '$[*]' COLUMNS (p NVARCHAR(1) PATH '$.a')) AS t" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case53" value="SELECT * FROM nowhere else" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case54" value="SELECT * FROM t AS upper JOIN LATERAL (SELECT DISTINCT ROW_NUMBER() OVER () AS rn FROM t WHERE (t.a > upper.a)) der" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case55" value="SELECT * FROM t0 JOIN (VALUES ROW(2, 20)) AS dt" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case56" value="SELECT * FROM t0 JOIN (VALUES ROW(2, 20), ROW(3, 30)) AS dt" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case57" value="SELECT * FROM t0 LEFT JOIN (VALUES ROW(1, 20), ROW(1, 30)) AS dt ON t0.a = dt.column_0" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case58" value="SELECT * FROM t0 LEFT JOIN (VALUES ROW(2, 20), ROW(3, 30)) AS dt ON t0.a = dt.column_0" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case59" value="SELECT * FROM t0 RIGHT JOIN (VALUES ROW(1, 20), ROW(1, 30)) AS dt ON t0.a = dt.column_0" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case60" value="SELECT * FROM t0 RIGHT JOIN (VALUES ROW(2, 20), ROW(3, 30)) AS dt ON t0.a = dt.column_0" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case61" value="SELECT * FROM t0 WHERE (a, b) IN (VALUES ROW(1, 10))" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case62" value="SELECT * FROM t0 WHERE (a, b) IN (VALUES ROW(1, 10), ROW(2, 20))" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case63" value="SELECT * FROM t0 WHERE (a, b) IN (VALUES ROW(1, NULL))" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case64" value="SELECT * FROM t0 WHERE (a, b) NOT IN (VALUES ROW(1, 10))" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case65" value="SELECT * FROM t0 WHERE (a, b) NOT IN (VALUES ROW(1, 10), ROW(2, 20))" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case66" value="SELECT * FROM t0 WHERE a <ANY (VALUES ROW(1))" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case67" value="SELECT * FROM t0 WHERE a <ANY (VALUES ROW(1), ROW(2))" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case68" value="SELECT * FROM t0 WHERE a >ALL (VALUES ROW(1))" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case69" value="SELECT * FROM t0 WHERE a >ALL (VALUES ROW(1), ROW(2))" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case70" value="SELECT * FROM t0 WHERE a IN (VALUES ROW(1))" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case71" value="SELECT * FROM t0 WHERE a IN (VALUES ROW(1), ROW(2))" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case72" value="SELECT * FROM t0 WHERE a NOT IN (VALUES ROW(1))" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case73" value="SELECT * FROM t0 WHERE a NOT IN (VALUES ROW(1), ROW(2))" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case74" value="SELECT * FROM t0 WHERE b IN (VALUES ROW(a*10))" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case75" value="SELECT * FROM t1 AS tbl1 LEFT JOIN t1 AS tbl3 ON FALSE WHERE tbl1.id NOT IN (SELECT id FROM t1 AS tbl2 JOIN LATERAL (SELECT 1 FROM t2 WHERE id = tbl2.id LIMIT 10) AS d1)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case76" value="SELECT * FROM t1 JOIN LATERAL ( SELECT GROUP_CONCAT(t.id) AS c FROM t2 t WHERE (t.id = t1.id) ) d0 ON (1)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case77" value="SELECT * FROM t1 JOIN LATERAL (SELECT a+t1.a from t2 GROUP BY a) AS dt" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case78" value="SELECT * FROM t1 LEFT JOIN ( t1 AS t2 LEFT JOIN t1 AS t3 ON TRUE ) ON TRUE, LATERAL ( SELECT SUM(t1.a), t2.a FROM t1 ) AS d1" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case79" value="SELECT * FROM t1 LEFT JOIN ( t3, LATERAL ( SELECT * FROM t2 WHERE table_id = t3.id ) l1 ) ON TRUE" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case80" value="SELECT * FROM t1 LEFT JOIN t2 IGNORE INDEX(PRIMARY) ON t2.a = 'test1' AND t2.b = '20161213' WHERE t1.a = 'test1'" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case81" value="SELECT * FROM t1 USE INDEX (PRIMARY) WHERE c1=2" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case82" value="SELECT * FROM t1 WHERE a = NAME_CONST('reportDate', _binary'2009-01-09' COLLATE 'binary')" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case83" value="SELECT * FROM t1 WHERE c1 <= REPEAT( SUBSTR( UPPER('Rdlpikti') , 1 , 2 ), 8)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case84" value="SELECT * FROM t1 WHERE c1 <= REPEAT( SUBSTR( UPPER('Rdlpikti') , 1 , 2 ), 8)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case85" value="SELECT * FROM t1, LATERAL ( SELECT MAX(1) FROM t2 GROUP BY t1.f1 ) AS l1" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case86" value="SELECT * FROM t1, t2, LATERAL ( SELECT pk, blobfield GROUP BY pk, blobfield WITH ROLLUP ) AS d1 ORDER BY t1.f1, t2.pk" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case87" value="SELECT * FROM t11 LEFT JOIN t12 force index (idx) ON t12.t12b = t11.t11b JOIN LATERAL (SELECT t12a) dt" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case88" value="SELECT * FROM v1 FORCE INDEX (PRIMARY) WHERE c1=2" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case89" value="SELECT * FROM v1 IGNORE INDEX (PRIMARY) WHERE c1=2" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case90" value="SELECT * FROM v1 USE INDEX (PRIMARY) WHERE c1=2" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case91" value="SELECT /*+ JOIN_PREFIX(tbl1, tbl2) */ * FROM t1 AS tbl1 LEFT JOIN t1 AS tbl3 ON FALSE WHERE tbl1.id NOT IN (SELECT id FROM t1 AS tbl2 JOIN LATERAL (SELECT 1 FROM t2 WHERE id = tbl2.id LIMIT 10) AS d1)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case92" value="SELECT /*+ SET_VAR(optimizer_switch = 'materialization=off,semijoin=off') */ * FROM t1 AS ta, lateral (select 1 WHERE ta.a IN (SELECT b FROM t2 AS tb WHERE tb.b >= SOME(SELECT SUM(tc.a) as sg FROM t1 as tc GROUP BY tc.b HAVING ta.a=tc.b))) dt" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case93" value="SELECT /*+ SET_VAR(time_zone = '+04:00') */ TIMEDIFF(NOW(), UTC_TIMESTAMP)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case94" value="SELECT /*+ SET_VAR(time_zone = 'UTC') */ TIMEDIFF(NOW(), UTC_TIMESTAMP)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case95" value="SELECT /*+ no_merge() */ outr.pk AS x FROM ( SELECT * FROM t1 ) AS outr WHERE outr.col_int_key IN ( SELECT /*+ no_merge() no_semijoin() */ id FROM JSON_TABLE( IF(outr.col_date_key<>NOW(), '[{"a":"3"},{"a":2},{"b":1},{"a":0}]', '') , '$[*]' columns (id for ordinality, jpath varchar(100) path '$.a', jexst int exists path '$.b [...]
+ <sql-case id="select_by_mysql_source_test_case96" value="SELECT 0 & (JSON_ARRAYAGG(1) OVER w) FROM (select 1) as dt WINDOW w as ()" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case97" value="SELECT 1 /*!99999 /* */ */" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case98" value="SELECT 1 FROM (TABLE t1) AS table1 JOIN t2 AS table2 ON table1.x = table2.y WHERE table1.x IN (VALUES ROW('B'))" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case99" value="SELECT 1 FROM (TABLE t1) AS table1 JOIN t2 AS table2 ON table1.x = table2.y WHERE table1.x IN (VALUES ROW(NULL))" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case100" value="SELECT 1 FROM (TABLE t1) AS table1 JOIN t2 AS table2 ON table1.x = table2.y WHERE table1.x IN (VALUES ROW(NULL), ROW('B'))" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case101" value="SELECT 1 FROM t WHERE insert(a & 0x111111,'','','')" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case102" value="SELECT 1 FROM t WHERE insert(a & NULL,'','','')" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case103" value="SELECT 1 FROM t1 GROUP BY SUBSTRING(SYSDATE() FROM 'K' FOR 'jxW<')" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case104" value="SELECT 1 FROM t1 GROUP BY TRIM(LEADING RAND() FROM '')" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case105" value="SELECT 1 FROM t1 GROUP BY insert(a,'1','11','1')" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case106" value="SELECT 1 FROM v1 AS table1 RIGHT OUTER JOIN LATERAL (SELECT 1 FROM v1 AS table2 RIGHT OUTER JOIN LATERAL ( SELECT 1 FROM v1 AS table3 ) AS table4 ON table1.c1 = 1) AS table5 ON 1" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case107" value="SELECT 1 HAVING json_objectagg(utc_date(), 1416) <> 0" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case108" value="SELECT 1 IN (SELECT MAKE_SET(-1, 1, (SELECT 1 FROM t)) FROM t)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case109" value="SELECT 1 NOT IN (SELECT 1 FROM t1 as t1 GROUP BY 1 LIKE (SELECT 1 FROM t1 as t2)) AS col" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case110" value="SELECT 1 NOT IN (SELECT 1 FROM t1 as t1 ORDER BY 1 LIKE (SELECT 1 FROM t1 as t2)) AS col" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case111" value="SELECT 1 WHERE 1 = ANY (SELECT GROUPING(a) FROM t1 GROUP BY a WITH ROLLUP)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case112" value="SELECT 1 WHERE 2 > ALL (SELECT GROUPING(a) FROM t1 GROUP BY a WITH ROLLUP)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case113" value="SELECT 1.0 * (_binary x'312E35' | x'312E35')" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case114" value="SELECT 10,10.0,10.,.1e+2,100.0e-1" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case115" value="SELECT 1e1,1.e1,1.0e1,1e+1,1.e+1,1.0e+1,1e-1,1.e-1,1.0e-1" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case116" value="SELECT 2 /*!12345 /* */ */" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case117" value="SELECT 3 /*! /* */ */" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case118" value="SELECT 3 IN (SELECT MAX(a) FROM t1)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case119" value="SELECT @@GLOBAL.VALIDATE_PASSWORD.LENGTH" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case120" value="SELECT @@GLOBAL.VALIDATE_PASSWORD.LENGTH" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case121" value="SELECT @@GLOBAL.VALIDATE_PASSWORD.LENGTH" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case122" value="SELECT @@GLOBAL.VALIDATE_PASSWORD.LENGTH" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case123" value="SELECT @@GLOBAL.VALIDATE_PASSWORD.LENGTH" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case124" value="SELECT @@GLOBAL.VALIDATE_PASSWORD.LENGTH" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case125" value="SELECT @@GLOBAL.VALIDATE_PASSWORD.LENGTH" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case126" value="SELECT @@GLOBAL.VALIDATE_PASSWORD.LENGTH" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case127" value="SELECT @@GLOBAL.VALIDATE_PASSWORD.LENGTH" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case128" value="SELECT @@GLOBAL.VALIDATE_PASSWORD.LENGTH" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case129" value="SELECT @@GLOBAL.VALIDATE_PASSWORD.MIXED_CASE_COUNT" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case130" value="SELECT @@GLOBAL.VALIDATE_PASSWORD.MIXED_CASE_COUNT" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case131" value="SELECT @@GLOBAL.VALIDATE_PASSWORD.NUMBER_COUNT" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case132" value="SELECT @@GLOBAL.VALIDATE_PASSWORD.NUMBER_COUNT" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case133" value="SELECT @@GLOBAL.VALIDATE_PASSWORD.SPECIAL_CHAR_COUNT" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case134" value="SELECT @@GLOBAL.VALIDATE_PASSWORD.SPECIAL_CHAR_COUNT" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case135" value="SELECT @@GLOBAL.example_signed_long_var IN (-2147483648, -9223372036854775808)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case136" value="SELECT @@GLOBAL.example_signed_long_var IN (2147483647, 9223372036854775807)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case137" value="SELECT @@GLOBAL.example_signed_long_var IN (2147483647, 9223372036854775807)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case138" value="SELECT @@GLOBAL.example_signed_long_var IN (2147483647, 9223372036854775807)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case139" value="SELECT @@SESSION.example_signed_long_thdvar IN (-2147483648, -9223372036854775808)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case140" value="SELECT @@SESSION.example_signed_long_thdvar IN (2147483647, 9223372036854775807)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case141" value="SELECT @@SESSION.example_signed_long_thdvar IN (2147483647, 9223372036854775807)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case142" value="SELECT @@SESSION.example_signed_long_thdvar IN (2147483647, 9223372036854775807)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case143" value="SELECT @@default.key_buffer_size" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case144" value="SELECT @@global.`default`.`key_buffer_size`" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case145" value="SELECT @@global.default.`key_buffer_size`" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case146" value="SELECT @@global.default.key_buffer_size" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case147" value="SELECT @@global.dragnet.log_error_filter_rules" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case148" value="SELECT @@global.dragnet.log_error_filter_rules" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case149" value="SELECT @@global.dragnet.log_error_filter_rules" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case150" value="SELECT @@global.dragnet.log_error_filter_rules" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case151" value="SELECT @@global.syseventlog.facility" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case152" value="SELECT @@global.syseventlog.facility" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case153" value="SELECT @@global.syseventlog.facility" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case154" value="SELECT @@global.syseventlog.facility" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case155" value="SELECT @@global.syseventlog.facility" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case156" value="SELECT @@global.syseventlog.facility, @start_value" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case157" value="SELECT @@global.syseventlog.include_pid" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case158" value="SELECT @@global.syseventlog.include_pid" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case159" value="SELECT @@global.syseventlog.include_pid" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case160" value="SELECT @@global.syseventlog.include_pid" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case161" value="SELECT @@global.syseventlog.include_pid" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case162" value="SELECT @@global.syseventlog.include_pid" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case163" value="SELECT @@global.syseventlog.tag" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case164" value="SELECT @@global.syseventlog.tag" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case165" value="SELECT @@global.syseventlog.tag" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case166" value="SELECT @@global.syseventlog.tag" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case167" value="SELECT @@global.syseventlog.tag" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case168" value="SELECT @@global.syseventlog.tag" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case169" value="SELECT @@global.syseventlog.tag" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case170" value="SELECT @@global.syseventlog.tag" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case171" value="SELECT @@global.syseventlog.tag" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case172" value="SELECT @@global.syseventlog.tag" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case173" value="SELECT @@global.syseventlog.tag" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case174" value="SELECT @@global.validate_password.check_user_name" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case175" value="SELECT @@global.validate_password.length" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case176" value="SELECT @@global.validate_password.policy" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case177" value="SELECT @@global.validate_password.policy, @@global.validate_password.length" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case178" value="SELECT @@session.dragnet.log_error_filter_rules" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case179" value="SELECT @before=@after" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case180" value="SELECT @trace RLIKE "keypart_reference_from_where_clause"" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case181" value="SELECT ADDDATE('8112-06-20', REPEAT('1', 32))" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case182" value="SELECT ADDTIME(UTC_DATE, '23:28:14.014837') FROM dual" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case183" value="SELECT AES_DECRYPT(AES_ENCRYPT(@ENCSTR, @KEYS), @KEYS)=@ENCSTR" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case184" value="SELECT AES_DECRYPT(AES_ENCRYPT(@ENCSTR, @KEYS), @KEYS)=@ENCSTR" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case185" value="SELECT AES_DECRYPT(AES_ENCRYPT(@ENCSTR, @KEYS), @KEYS)=@ENCSTR" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case186" value="SELECT AES_DECRYPT(AES_ENCRYPT(@ENCSTR, @KEYS), @KEYS)=@ENCSTR FROM t1" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case187" value="SELECT AES_DECRYPT(AES_ENCRYPT(@ENCSTR, @KEYS), @KEYS)=@ENCSTR FROM t1" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case188" value="SELECT AES_DECRYPT(AES_ENCRYPT(@ENCSTR, @KEYS), @KEYS)=@ENCSTR FROM t1" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case189" value="SELECT AES_DECRYPT(AES_ENCRYPT(@ENCSTR, @KEYS), @KEYS)=@ENCSTR FROM t1" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case190" value="SELECT AES_DECRYPT(AES_ENCRYPT(@ENCSTR, @KEYS), @KEYS)=@ENCSTR FROM t1" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case191" value="SELECT AES_DECRYPT(AES_ENCRYPT(@ENCSTR, @KEYS), @KEYS)=@ENCSTR FROM t1" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case192" value="SELECT AES_DECRYPT(AES_ENCRYPT(@ENCSTR, @KEYS, @IV), @KEYS, @IV)=@ENCSTR" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case193" value="SELECT AES_DECRYPT(AES_ENCRYPT(@ENCSTR, @KEYS, @IV), @KEYS, @IV)=@ENCSTR" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case194" value="SELECT AES_DECRYPT(AES_ENCRYPT(@ENCSTR, @KEYS, @IV), @KEYS, @IV)=@ENCSTR" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case195" value="SELECT AES_DECRYPT(AES_ENCRYPT(@ENCSTR, @KEYS, @IV), @KEYS, @IV)=@ENCSTR FROM t1" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case196" value="SELECT AES_DECRYPT(AES_ENCRYPT(@ENCSTR, @KEYS, @IV), @KEYS, @IV)=@ENCSTR FROM t1" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case197" value="SELECT AES_DECRYPT(AES_ENCRYPT(@ENCSTR, @KEYS, @IV), @KEYS, @IV)=@ENCSTR FROM t1" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case198" value="SELECT AES_DECRYPT(AES_ENCRYPT(@ENCSTR, @KEYS, @IV), @KEYS, @IV)=@ENCSTR FROM t1" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case199" value="SELECT AES_DECRYPT(AES_ENCRYPT(@ENCSTR, @KEYS, @IV), @KEYS, @IV)=@ENCSTR FROM t1" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case200" value="SELECT AES_DECRYPT(AES_ENCRYPT(@ENCSTR, @KEYS, @IV), @KEYS, @IV)=@ENCSTR FROM t1" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case201" value="SELECT AES_DECRYPT(AES_ENCRYPT(_UTF8'Жоро', 'a'), 'a') = _UTF8'Жоро'" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case202" value="SELECT AES_DECRYPT(f1, @KEYS, @IV)=@ENCSTR FROM t1" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case203" value="SELECT AES_DECRYPT(f1, @KEYS, @IV)=@ENCSTR FROM t1" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case204" value="SELECT AES_DECRYPT(f1, @KEYS, @IV)=@ENCSTR FROM t1" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case205" value="SELECT AES_DECRYPT(f1, @KEYS, @IV)=@ENCSTR FROM t1" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case206" value="SELECT AES_DECRYPT(f1, @KEYS, @IV)=@ENCSTR FROM t1" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case207" value="SELECT AES_ENCRYPT('a', 'a') = AES_ENCRYPT('a', 'a', REPEAT('a', 16))" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case208" value="SELECT AES_ENCRYPT('a', 'a') = AES_ENCRYPT('a', 'a', REPEAT('b', 16))" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case209" value="SELECT AES_ENCRYPT('a', 'a') = AES_ENCRYPT('a', REPEAT('a',1000))" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case210" value="SELECT AES_ENCRYPT('a', 'a') = AES_ENCRYPT(REPEAT('a',1000), 'a')" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case211" value="SELECT BIN(MID(REPEAT('b',64),21,229))" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case212" value="SELECT BIN(RIGHT(REPEAT('b',64),30))" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case213" value="SELECT BIN(SUBSTRING(REPEAT('b',64),9))" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case214" value="SELECT BIT_COUNT(_binary 0x221040808040100200200100)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case215" value="SELECT CAST(0 AS UNSIGNED) BETWEEN 0 AND -1" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case216" value="SELECT CAST(0 AS UNSIGNED) NOT BETWEEN 0 AND -1" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case217" value="SELECT CAST(100 AS UNSIGNED) BETWEEN 1 AND -1" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case218" value="SELECT CAST(100 AS UNSIGNED) NOT BETWEEN 1 AND -1" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case219" value="SELECT CHARSET(mysqltest2.bug16211_f3())" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case220" value="SELECT CHARSET(mysqltest2.bug16211_f3())" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case221" value="SELECT CHARSET(mysqltest2.bug16211_f4())" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case222" value="SELECT CHARSET(mysqltest2.bug16211_f4())" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case223" value="SELECT CHAR_LENGTH(EXPORT_SET(1,1,1,REPEAT(1,100000000)))" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case224" value="SELECT COALESCE (AES_DECRYPT(f1, @KEYS, @IV)=@ENCSTR,0) FROM t1" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case225" value="SELECT CONCAT('"',CONCAT('";"',repeat('a',60), repeat('b',60), repeat('c',60), repeat ('d',100)),'"')" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case226" value="SELECT CONCAT('"',CONCAT('";"',repeat('a',60), repeat('b',60), repeat('c',60), repeat ('d',100)),'"')" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case227" value="SELECT CONCAT('"',CONCAT_WS('";"',repeat('a',60), repeat('b',60), repeat('c',60), repeat ('d',100)),'"')" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case228" value="SELECT CONCAT('"',CONCAT_WS('";"',repeat('a',60), repeat('b',60), repeat('c',60), repeat ('d',100)),'"')" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case229" value="SELECT CONCAT('"',CONCAT_WS('";"',repeat('a',60),repeat('b',60),repeat('c',60),repeat('d',100)), '"')" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case230" value="SELECT CONCAT(i,':',j) as ij, CONCAT(j,':',i) as ji FROM t1 GROUP BY ij, ji WITH ROLLUP ORDER BY GROUPING(ij),ij,GROUPING(ji),ji" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case231" value="SELECT CONCAT_WS('"',CONCAT_WS('";"',repeat('a',60), repeat('b',60), repeat('c',60), repeat ('d',100)),'"')" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case232" value="SELECT CONCAT_WS('"',CONCAT_WS('";"',repeat('a',60), repeat('b',60), repeat('c',60), repeat ('d',100)),'"')" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case233" value="SELECT COUNT(*) = 1 FROM information_schema.processlist WHERE state = 'Waiting for locking service lock' AND id =" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case234" value="SELECT COUNT(*) AS a, a IN (SELECT a FROM t2 WHERE a=FLOOR(COUNT(t1.a)/2)) AS s FROM t1" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case235" value="SELECT COUNT(*) FROM t1 GROUP BY t1.a HAVING t1.a IN (SELECT t3.a FROM t1 AS t3 WHERE t3.b IN (SELECT b FROM t2, lateral (select t1.a) dt))" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case236" value="SELECT COUNT(*) FROM t1 LEFT JOIN json_table( '{}','$[0][1]' COLUMNS(a FOR ORDINALITY) ) AS t2 ON TRUE GROUP BY e*from_unixtime(0)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case237" value="SELECT COUNT(*) FROM t1 WHERE c=REPEAT('a',256)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case238" value="SELECT COUNTRY FROM t1 WHERE trim(leading 'A' FROM COUNTRY) = 'ustralia' AND trim(trailing 'a' FROM COUNTRY) = 'Australi'" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case239" value="SELECT COUNTRY FROM t1 WHERE trim(leading 'A' FROM COUNTRY) = 'ustralia'" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case240" value="SELECT CRC32(INSERT('foodyear', 1, 4, 'good'))" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case241" value="SELECT CURRENT_TIME(6) RLIKE '^[0-9]{2}:[0-9]{2}:[0-9]{2}.[0-9]{6}$'" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case242" value="SELECT CURRENT_TIMESTAMP(6) RLIKE '^[0-9]{4}-[0-9]{2}-[0-9]{2} [0-9]{2}:[0-9]{2}:[0-9]{2}.[0-9]{6}$'" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case243" value="SELECT DATEDIFF((_binary '12012-05-19 09:06:07' | _binary '12012-05-19 09:06:07'), '2012-05-21 09:06:07')" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case244" value="SELECT DATEDIFF((_binary '2012-05-19 09:06:07' | _binary '2012-05-19 09:06:07'), '2012-05-21 09:06:07')" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case245" value="SELECT DEFAULT(c) from t3" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case246" value="SELECT DEFAULT(d) from t3" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case247" value="SELECT DISTINCT GROUPING(i), GROUPING(j) FROM t1 GROUP BY i,j WITH ROLLUP" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case248" value="SELECT DISTINCT GROUPING(i), GROUPING(j) FROM t1 GROUP BY i,j WITH ROLLUP ORDER BY GROUPING(i), GROUPING(j)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case249" value="SELECT DISTINCT SQL_BIG_RESULT col_json, col_char FROM ( VALUES ROW( 'xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx', NULL, NULL ), ROW( NULL, NULL, '"yyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyy"' ) ) AS t1 ( col_char, col_time, col_json ) GROUP BY col_tim [...]
+ <sql-case id="select_by_mysql_source_test_case250" value="SELECT DISTINCT i, GROUPING(i+j), AVG(k) from t1 GROUP BY i,i+j WITH ROLLUP HAVING AVG(k) + 20 < 35 ORDER BY i" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case251" value="SELECT DISTINCT i, GROUPING(i+j), AVG(k) from t1 GROUP BY i,i+j WITH ROLLUP HAVING AVG(k) > 10 ORDER BY i" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case252" value="SELECT DISTINCT i, i+j, GROUPING(i+j), AVG(k) from t1 GROUP BY i,i+j WITH ROLLUP HAVING i is NOT NULL ORDER BY i+j" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case253" value="SELECT DISTINCT j, GROUPING(j) FROM t1 GROUP BY i,j WITH ROLLUP" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case254" value="SELECT EXTRACT(DAY FROM (-0.1111111111)), EXTRACT(YEAR FROM (-0.1111111)), EXTRACT(YEAR_MONTH FROM (-0.1111111111)), EXTRACT(DAY FROM (-0.1111111)), EXTRACT(QUARTER FROM (-0.1111111111)), EXTRACT(MONTH FROM (-0.1111111)), EXTRACT(WEEK FROM (-0.1111111)), DATE(-0.1111111), QUARTER(-0.1111111111), TIMESTAMP(-0.1111111111), LAST_DAY(-0.1111111111), DAY(-0.1111111111), MONTH(-0.1111111111), YEAR(-0.1111111), DAYOFMONTH(-0.11111111 [...]
+ <sql-case id="select_by_mysql_source_test_case255" value="SELECT EXTRACT(HOUR_SECOND FROM CURRENT_DATE) FROM t1" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case256" value="SELECT EXTRACT(MINUTE_MICROSECOND FROM '0000-00-00 00:00:00.000000')" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case257" value="SELECT EXTRACT(MINUTE_MICROSECOND FROM a) FROM t1" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case258" value="SELECT FROM_UNIXTIME(FIRST_VALUE(@b)RESPECT NULLS OVER(), REPEAT('1',32))IS NOT FALSE" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case259" value="SELECT GET_LOCK(REPEAT('a', 64), 0) = 1 AS expect_1" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case260" value="SELECT GET_LOCK(REPEAT('a', 65), 0)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case261" value="SELECT GROUPING((SELECT MAX(b) FROM t1)) FROM t1 GROUP BY (SELECT MAX(b) FROM t1) WITH ROLLUP" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case262" value="SELECT GROUPING(1) FROM t1 GROUP BY 1 WITH ROLLUP" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case263" value="SELECT GROUPING(alias2.pk) AS field2 FROM t2 AS alias1 LEFT JOIN t1 AS alias2 ON 0 GROUP BY alias2.pk WITH ROLLUP ORDER BY GROUPING(alias2.pk)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case264" value="SELECT GROUPING(table2.col_time) AS field1 FROM t1 AS table1,t1 as table2 WHERE table2.pk = 1 GROUP BY table2.col_time WITH ROLLUP ORDER BY GROUPING(table2.col_time)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case265" value="SELECT HEX(LPAD('', 42, TRIM(BOTH c1 FROM x'ff'))) FROM t1" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case266" value="SELECT HEX(LPAD('', 42, TRIM(x'ffff' FROM c1))) FROM t1" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case267" value="SELECT HEX(_bin & _bin), HEX(_bin & _vbn), HEX(_vbn & _bin), HEX(_vbn & _vbn) FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case268" value="SELECT HEX(_bin ^ _bin), HEX(_bin ^ _vbn), HEX(_vbn ^ _bin), HEX(_vbn ^ _vbn) FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case269" value="SELECT HEX(_bin | _bin), HEX(_bin | _vbn), HEX(_vbn | _bin), HEX(_vbn | _vbn) FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case270" value="SELECT HEX(_binary 0x0003 << (_binary 0x38 | 0x38))" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case271" value="SELECT HEX(_binary 0x0003 << (_binary 0x38 | NULL))" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case272" value="SELECT HEX(_binary 0x0003 << (_binary 0x40 | 0x40))" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case273" value="SELECT IF(GROUPING(a)=1,'All Departments', a) as Department, IF(GROUPING(b)=1, 'All Employees', b) as Employees, SUM(c) as SUM FROM t1 GROUP BY a,b WITH ROLLUP" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case274" value="SELECT INSERT('a', 1, 1, YEAR(UNHEX('w')))" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case275" value="SELECT INSERT('abc', 3, 3, '1234')" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case276" value="SELECT INSERT('abc', 4, 3, '1234')" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case277" value="SELECT INSERT('abc', 5, 3, '1234')" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case278" value="SELECT INSERT('abc', 6, 3, '1234')" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case279" value="SELECT INSERT('𝌆テÀa', 2, 2, 'テb')" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case280" value="SELECT INSERT('𝌆テÀa', 2, 2, 'テb')" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case281" value="SELECT INSERT(1, 1, 2, _utf8mb4 x'E4B8ADE69687')" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case282" value="SELECT INSERT(`字段一`, 1, 1, ' ') FROM `表一`" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case283" value="SELECT INSERT(`字段一`, 1, 1, '㐊') FROM `表一`" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case284" value="SELECT INSERT(`字段一`, 1, 1, '岝') FROM `表一`" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case285" value="SELECT INSERT(`字段一`, 1, 2, ' ') FROM `表一`" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case286" value="SELECT INSERT(`字段一`, 1, 2, '㐊') FROM `表一`" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case287" value="SELECT INSERT(`字段一`, 1, 2, '岝岝') FROM `表一`" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case288" value="SELECT INSERT(`字段一`, 1, 3, ' ') FROM `表一`" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case289" value="SELECT INSERT(`字段一`, 1, 3, '㐊') FROM `表一`" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case290" value="SELECT INSERT(`字段一`, 1, 3, '岝岝岝') FROM `表一`" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case291" value="SELECT INSERT(`字段一`, 1, 4, ' ') FROM `表一`" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case292" value="SELECT INSERT(`字段一`, 1, 4, '㐊') FROM `表一`" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case293" value="SELECT INSERT(`字段一`, 1, 4, '岝岝岝岝') FROM `表一`" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case294" value="SELECT INSERT(`字段一`, 1, 5, ' ') FROM `表一`" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case295" value="SELECT INSERT(`字段一`, 1, 5, '㐊') FROM `表一`" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case296" value="SELECT INSERT(`字段一`, 1, 5, '岝岝岝岝岝') FROM `表一`" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case297" value="SELECT INSERT(`字段一`, 4, 1, ' ') FROM `表一`" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case298" value="SELECT INSERT(`字段一`, 4, 1, '𠀂') FROM `表一`" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case299" value="SELECT INSERT(`字段一`, 4, 1, '𠻠') FROM `表一`" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case300" value="SELECT INSERT(`字段一`, 4, 2, ' ') FROM `表一`" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case301" value="SELECT INSERT(`字段一`, 4, 2, '𠀂𠀂') FROM `表一`" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case302" value="SELECT INSERT(`字段一`, 4, 2, '𠻠') FROM `表一`" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case303" value="SELECT INSERT(`字段一`, 5, 1, ' ') FROM `表一`" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case304" value="SELECT INSERT(`字段一`, 5, 1, '𠀂') FROM `表一`" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case305" value="SELECT INSERT(`字段一`, 5, 1, '𠻠') FROM `表一`" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case306" value="SELECT INSERT(a, 1, 1, x'ff') FROM t1" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case307" value="SELECT INSERT(a, 1, 2, b) FROM t1" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case308" value="SELECT INSERT(a, 10, 2, b) FROM t1" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case309" value="SELECT IS_FREE_LOCK(REPEAT('a', 64)) = 0 AS expect_1" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case310" value="SELECT IS_FREE_LOCK(REPEAT('a', 65))" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case311" value="SELECT IS_USED_LOCK(REPEAT('a', 64)) = CONNECTION_ID() AS expect_1" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case312" value="SELECT IS_USED_LOCK(REPEAT('a', 65))" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case313" value="SELECT JSON_ARRAY(JSON_ARRAYAGG(CAST('' AS JSON)) OVER (), '')" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case314" value="SELECT JSON_OBJECTAGG(`key`, i) OVER w AS agg FROM t WINDOW w AS (ORDER BY `key` ROWS CURRENT ROW)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case315" value="SELECT JSON_OBJECTAGG(`key`, i) OVER w AS agg FROM t WINDOW w AS (ORDER BY i ROWS CURRENT ROW)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case316" value="SELECT LENGTH(TO_BASE64(REPEAT('a', @@max_allowed_packet-10)))" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case317" value="SELECT MAKETIME(((1)<=> (2*JSON_OBJECTAGG('1',1)OVER())),'1',1)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case318" value="SELECT MAKETIME(((1)<=> (JSON_OBJECTAGG('1',1)OVER())),'1',1)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case319" value="SELECT MAX( t2.i2 ) FROM t3 RIGHT JOIN t2 ON ( t2.i3 = 2 ) WHERE t2.i3 <> t1.i1 ) AS field1 FROM t1" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case320" value="SELECT MICROSECOND(CURRENT_TIME(6))=MICROSECOND(UTC_TIME(6))" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case321" value="SELECT NULL IN(SELECT (f1 between 0 and 1) FROM (SELECT f1 FROM t WHERE (@b:=NULL) - f2)as dt )" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case322" value="SELECT OCT(LEFT(REPEAT('b',64),15))" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case323" value="SELECT POLYGON((SELECT 1 FROM (SELECT 1 IN (GROUP_CONCAT(t1.f1)) FROM t1, t1 t GROUP BY t.f1 ) d))" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case324" value="SELECT POSITION(x'44' IN _utf8mb4'abcdef')" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case325" value="SELECT POSITION(x'64' IN _utf8mb4'abcdef')" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case326" value="SELECT POSITION(x'ff' IN _utf8mb4'abcdef')" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case327" value="SELECT REGEXP_INSTR(e, 'pattern') FROM (VALUES ROW('Find pattern'), ROW(NULL), ROW('Find pattern')) AS v(e)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case328" value="SELECT REGEXP_LIKE(e, 'pattern') FROM (VALUES ROW('Find pattern'), ROW(NULL), ROW('Find pattern')) AS v(e)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case329" value="SELECT REGEXP_REPLACE(e, 'pattern', 'xyz') FROM (VALUES ROW('Find pattern'), ROW(NULL), ROW('Find pattern')) AS v(e)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case330" value="SELECT REGEXP_SUBSTR(e, 'pattern') FROM (VALUES ROW('Find pattern'), ROW(NULL), ROW('Find pattern')) AS v(e)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case331" value="SELECT RELEASE_LOCK(REPEAT('a', 64)) = 1 AS expect_1" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case332" value="SELECT RELEASE_LOCK(REPEAT('a', 65))" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case333" value="SELECT REPEAT( '#', tire ) AS A, REPEAT( '#', tire % 999 ) AS B, tire FROM `t1`" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case334" value="SELECT REPEAT('0', -2)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case335" value="SELECT REPEAT('0', 2)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case336" value="SELECT REPEAT('0', CAST(0 AS UNSIGNED))" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case337" value="SELECT REPEAT('1', DAY(FROM_UNIXTIME(-1)))" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case338" value="SELECT REPEAT('T', 16777211)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case339" value="SELECT REPEAT(0x1111, 40000000) >> 1" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case340" value="SELECT ROW(1,ROW(2,3)) IN ((SELECT 1,1),ROW(1,ROW(2,3)))" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case341" value="SELECT ROW(1,ROW(2,3)) IN (ROW(1,ROW(2,3)),(SELECT 1,1))" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case342" value="SELECT ROW(1,ROW(2,3)) IN (ROW(1,ROW(2,3)),(SELECT 1,1),ROW(1,ROW(2,4)))" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case343" value="SELECT ROW(1,ROW(2,3)) IN (ROW(1,ROW(2,3)),ROW(1,1))" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case344" value="SELECT ROW(1,ROW(2,3)) IN (ROW(1,ROW(2,3)),ROW(1,1),ROW(1,ROW(2,3)))" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case345" value="SELECT ROW(1,ROW(2,3)) IN (ROW(1,ROW(2,3)),ROW(1,ROW(2,2,2)))" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case346" value="SELECT ROW(1,ROW(2,3,4)) IN (ROW(1,ROW(2,3,4)),ROW(1,ROW(2,2)))" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case347" value="SELECT ROW(2,1) IN (ROW(21,2),ROW(ROW(1,1,3),0))" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case348" value="SELECT ROW(2,1) IN (ROW(ROW(1,1,3),0),ROW(21,2))" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case349" value="SELECT ROW(a, 1) IN (SELECT SUM(b), 1) FROM t1 GROUP BY a" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case350" value="SELECT ROW(a, 1) IN (SELECT SUM(b), 3) FROM t1 GROUP BY a" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case351" value="SELECT SHA(pk) IN (SELECT * FROM (SELECT '' FROM t2) a) FROM t1" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case352" value="SELECT SPECIFIC_NAME, ROUTINE_CATALOG, ROUTINE_SCHEMA, ROUTINE_NAME, ROUTINE_TYPE, DTD_IDENTIFIER, ROUTINE_BODY, ROUTINE_DEFINITION, EXTERNAL_NAME, drop table if exists t1" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case353" value="SELECT STD(0) FROM t2, LATERAL ( SELECT f1 FROM t1 GROUP BY f2,f1 ) AS d1" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case354" value="SELECT STDDEV_SAMP(a) OVER ( ORDER BY a ROWS CURRENT ROW ) AS std_dev_samp FROM t" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case355" value="SELECT ST_AsText(ST_GeometryFromText(CONCAT( 'MULTIPOLYGON(((', REPEAT ('-0.00000000001234567890123456789012 -0.123456789012345678,', 1000), '-0.00000000001234567890123456789012 -0.123456789012345678', ')))' ))) AS a" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case356" value="SELECT ST_AsWKB(ST_GeomFromText('POINT(0 0)')) IN (SELECT b FROM t) AS result" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case357" value="SELECT ST_AsWKB(ST_GeomFromText('POINT(0 0)')) IN (SELECT b FROM t) AS result" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case358" value="SELECT ST_AsWKB(ST_GeomFromText('POINT(0 0)')) IN (SELECT b FROM t1) AS result" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case359" value="SELECT ST_AsWKB(ST_GeomFromText('POINT(0 0)')) IN (SELECT b FROM t1) AS result" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case360" value="SELECT ST_GeomFromText('POINT(0 0)') IN (SELECT b FROM t) AS result" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case361" value="SELECT ST_GeomFromText('POINT(0 0)') IN (SELECT b FROM t) AS result" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case362" value="SELECT ST_GeomFromText('POINT(0 0)') IN (SELECT b FROM t1) AS result" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case363" value="SELECT ST_GeomFromText('POINT(0 0)') IN (SELECT b FROM t1) AS result" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case364" value="SELECT SUBTIME((_binary '12007-12-31 23:59:59.999999' | _binary '12007-12-31 23:59:59.999999'),'1 1:1:1.000002')" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case365" value="SELECT SUBTIME((_binary '2012-05-19 09:06:07' | _binary '2012-05-19 09:06:07'),'1 1:1:1.000002')" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case366" value="SELECT SUBTIME(UTC_DATE, '04:44:03.014042') FROM dual" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case367" value="SELECT SUBTIME(col_timestamp_3_not_null_key , SYSDATE()) AS c1 FROM t1 WHERE col_timestamp_1_not_null_key NOT IN (col_datetime_4_key , GREATEST(DATE('2006-04-26'), UTC_DATE())) ORDER BY col_datetime_6 , col_time_2_not_null_key , col_time_5_not_null_key" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case368" value="SELECT SUM(1) OVER w FROM (SELECT * FROM t1,t2 WHERE t1.id=t2.user_id) t SELECT SUM(id) OVER (PARTITION BY sex ORDER BY id ROWS UNBOUNDED PRECEDING) summ, sex FROM t1" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case369" value="SELECT SUM(b) OVER (ORDER by a GROUPS 2 PRECEDING) FROM t" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case370" value="SELECT SUM(b) OVER (ORDER by a ROWS 2 PRECEDING EXCLUDE CURRENT ROW) FROM t" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case371" value="SELECT SUM(b) OVER (ORDER by a ROWS 2 PRECEDING EXCLUDE GROUP) FROM t" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case372" value="SELECT SUM(b) OVER (ORDER by a ROWS 2 PRECEDING EXCLUDE NO OTHERS) FROM t" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case373" value="SELECT SUM(b) OVER (ORDER by a ROWS 2 PRECEDING EXCLUDE TIES) FROM t" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case374" value="SELECT TIMEDIFF('0000-00-00 00:00:00.00000', UTC_DATE) FROM dual" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case375" value="SELECT TIMEDIFF(NOW(), UTC_TIMESTAMP)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case376" value="SELECT TO_BASE64(AES_ENCRYPT('a', 'a', REPEAT('a', 1024)))" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case377" value="SELECT TRACE NOT RLIKE '"final_filtering_effect": 1' AS OK FROM INFORMATION_SCHEMA.OPTIMIZER_TRACE" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case378" value="SELECT TRACE RLIKE 'disjuntive_predicate_present' AS OK FROM INFORMATION_SCHEMA.OPTIMIZER_TRACE" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case379" value="SELECT TRACE RLIKE 'disjuntive_predicate_present' AS OK FROM INFORMATION_SCHEMA.OPTIMIZER_TRACE" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case380" value="SELECT TRACE RLIKE 'have_both_agg_distinct_and_min_max' AS OK FROM INFORMATION_SCHEMA.OPTIMIZER_TRACE" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case381" value="SELECT TRACE RLIKE 'have_both_agg_distinct_and_min_max' AS OK FROM INFORMATION_SCHEMA.OPTIMIZER_TRACE" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case382" value="SELECT TRACE RLIKE 'have_both_agg_distinct_and_min_max' AS OK FROM INFORMATION_SCHEMA.OPTIMIZER_TRACE" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case383" value="SELECT TRACE RLIKE 'have_both_agg_distinct_and_min_max' AS OK FROM INFORMATION_SCHEMA.OPTIMIZER_TRACE" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case384" value="SELECT TRACE RLIKE 'have_both_agg_distinct_and_min_max' AS OK FROM INFORMATION_SCHEMA.OPTIMIZER_TRACE" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case385" value="SELECT TRACE RLIKE 'minmax_keypart_in_disjunctive_query' AS OK FROM INFORMATION_SCHEMA.OPTIMIZER_TRACE" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case386" value="SELECT TRACE RLIKE 'minmax_keypart_in_disjunctive_query' AS OK FROM INFORMATION_SCHEMA.OPTIMIZER_TRACE" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case387" value="SELECT TRACE RLIKE 'minmax_keypart_in_disjunctive_query' AS OK FROM INFORMATION_SCHEMA.OPTIMIZER_TRACE" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case388" value="SELECT TRACE RLIKE 'minmax_keypart_in_disjunctive_query' AS OK FROM INFORMATION_SCHEMA.OPTIMIZER_TRACE" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case389" value="SELECT TRACE RLIKE 'minmax_keypart_in_disjunctive_query' AS OK FROM INFORMATION_SCHEMA.OPTIMIZER_TRACE" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case390" value="SELECT TRACE RLIKE 'minmax_keypart_in_disjunctive_query' AS OK FROM INFORMATION_SCHEMA.OPTIMIZER_TRACE" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case391" value="SELECT TRACE RLIKE 'minmax_keypart_in_disjunctive_query' AS OK FROM INFORMATION_SCHEMA.OPTIMIZER_TRACE" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case392" value="SELECT TRACE RLIKE 'minmax_keypart_in_disjunctive_query' AS OK FROM INFORMATION_SCHEMA.OPTIMIZER_TRACE" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case393" value="SELECT TRACE RLIKE 'minmax_keypart_in_disjunctive_query' AS OK FROM INFORMATION_SCHEMA.OPTIMIZER_TRACE" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case394" value="SELECT TRACE RLIKE 'minmax_keypart_in_disjunctive_query' AS OK FROM INFORMATION_SCHEMA.OPTIMIZER_TRACE" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case395" value="SELECT TRACE RLIKE 'minmax_keypart_in_disjunctive_query' AS OK FROM INFORMATION_SCHEMA.OPTIMIZER_TRACE" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case396" value="SELECT TRACE RLIKE 'minmax_keypart_in_disjunctive_query' AS OK FROM INFORMATION_SCHEMA.OPTIMIZER_TRACE" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case397" value="SELECT TRACE RLIKE 'minmax_keypart_in_disjunctive_query' AS OK FROM INFORMATION_SCHEMA.OPTIMIZER_TRACE" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case398" value="SELECT TRIM(BOTH 'y' FROM s) FROM t1" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case399" value="SELECT TRIM(BOTH x'F09F8DA3' FROM _utf8mb4 x'F09F8DA3F09F8DA3')" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case400" value="SELECT TRIM(BOTH x'f0' FROM _utf8mb4 x'F09F8DA3F09F8DA3')" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case401" value="SELECT TRIM(LEADING '\t' FROM MID(argument,LOCATE('Query',argument)+5)) FROM test_log WHERE (argument LIKE '%BY %' OR argument LIKE '%AS %' OR argument LIKE '%PASSWORD %') AND argument NOT LIKE '%Prepare%'" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case402" value="SELECT TRIM(LEADING 'y' FROM s) FROM t1" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case403" value="SELECT TRIM(TRAILING 'y' FROM s) FROM t1" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case404" value="SELECT TRIM(_latin2 x'a3' from _latin1 "hello")" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case405" value="SELECT TRIM(leading _utf8mb4 x'F09F8DA3' from _gb18030 x'9439B9376181308B33')" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case406" value="SELECT UNIX_TIMESTAMP(col_datetime_4_not_null) AS c1 FROM t1 WHERE col_time_4_key NOT BETWEEN '2001-07-06' AND LEAST(FROM_DAYS(col_timestamp_key), col_timestamp_5) OR CONVERT_TZ(MAKETIME(24, 5, 7), 'Japan', 'Japan') IS NULL OR CURRENT_TIMESTAMP() IS NOT NULL OR col_datetime_not_null_key >= UTC_TIME() ORDER BY 1" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case407" value="SELECT UTC_DATE()" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case408" value="SELECT VALIDATE_PASSWORD_STRENGTH(REPEAT("aA1#", 26))" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case409" value="SELECT VARIANCE(b) over w `var`, AVG(b) OVER w `avg`, SUM(b) OVER w `sum`, b, COUNT(b) OVER w count FROM t1 WINDOW w as (ORDER BY b ROWS BETWEEN 1 PRECEDING AND 1 FOLLOWING)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case410" value="SELECT VARIANCE(b) over w `var`, AVG(b) OVER w `avg`, SUM(b) OVER w `sum`, b, count(b) OVER w count FROM t1 WINDOW w as (ORDER BY b ROWS BETWEEN 1 PRECEDING AND 1 FOLLOWING)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case411" value="SELECT VARIANCE(b) over w `var`, AVG(b) OVER w `avg`, SUM(b) OVER w `sum`, b, count(b) OVER w count, LAST_VALUE(b) OVER w lastval FROM t1 WINDOW w as (ORDER BY b ROWS BETWEEN 1 PRECEDING AND 1 FOLLOWING)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case412" value="SELECT VARIANCE(b) over w `var`, FIRST_VALUE(b) over w fv, AVG(b) OVER w `avg`, SUM(b) OVER w `sum`, b, count(b) OVER w count FROM t1 WINDOW w as (ORDER BY b ROWS BETWEEN 1 FOLLOWING AND 2 FOLLOWING)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case413" value="SELECT _bin & 2147483647 FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case414" value="SELECT _bin & x'cafebabe' FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case415" value="SELECT _bin ^ 2147483647 FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case416" value="SELECT _bin ^ x'cafebabe' FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case417" value="SELECT _bin | 2147483647 FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case418" value="SELECT _bin | x'cafebabe' FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case419" value="SELECT _binary '1' + 0" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case420" value="SELECT _binary '12' << 1" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case421" value="SELECT _binary '12' | '12'" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case422" value="SELECT _binary '12' | 0x0001" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case423" value="SELECT _binary '12' | 1" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case424" value="SELECT _binary '12' | _binary '12'" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case425" value="SELECT _bis & 2147483647 FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case426" value="SELECT _bis & x'cafebabe' FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case427" value="SELECT _bis ^ 2147483647 FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case428" value="SELECT _bis ^ x'cafebabe' FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case429" value="SELECT _bis | 2147483647 FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case430" value="SELECT _bis | x'cafebabe' FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case431" value="SELECT _bit & 2147483647 FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case432" value="SELECT _bit & x'cafebabe' FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case433" value="SELECT _bit ^ 2147483647 FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case434" value="SELECT _bit ^ x'cafebabe' FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case435" value="SELECT _bit | 2147483647 FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case436" value="SELECT _bit | x'cafebabe' FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case437" value="SELECT _biu & 2147483647 FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case438" value="SELECT _biu & x'cafebabe' FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case439" value="SELECT _biu ^ 2147483647 FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case440" value="SELECT _biu ^ x'cafebabe' FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case441" value="SELECT _biu | 2147483647 FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case442" value="SELECT _biu | x'cafebabe' FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case443" value="SELECT _blb & 2147483647 FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case444" value="SELECT _blb ^ 2147483647 FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case445" value="SELECT _blb | 2147483647 FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case446" value="SELECT _boo & 2147483647 FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case447" value="SELECT _boo & x'cafebabe' FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case448" value="SELECT _boo ^ 2147483647 FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case449" value="SELECT _boo ^ x'cafebabe' FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case450" value="SELECT _boo | 2147483647 FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case451" value="SELECT _boo | x'cafebabe' FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case452" value="SELECT _chr & 2147483647 FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case453" value="SELECT _chr & x'cafebabe' FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case454" value="SELECT _chr ^ 2147483647 FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case455" value="SELECT _chr ^ x'cafebabe' FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case456" value="SELECT _chr | 2147483647 FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case457" value="SELECT _chr | x'cafebabe' FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case458" value="SELECT _dat & 2147483647 FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case459" value="SELECT _dat & x'cafebabe' FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case460" value="SELECT _dat ^ 2147483647 FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case461" value="SELECT _dat ^ x'cafebabe' FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case462" value="SELECT _dat | 2147483647 FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case463" value="SELECT _dat | x'cafebabe' FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case464" value="SELECT _dec & 2147483647 FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case465" value="SELECT _dec & x'cafebabe' FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case466" value="SELECT _dec ^ 2147483647 FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case467" value="SELECT _dec ^ x'cafebabe' FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case468" value="SELECT _dec | 2147483647 FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case469" value="SELECT _dec | x'cafebabe' FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case470" value="SELECT _dou & 2147483647 FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case471" value="SELECT _dou & x'cafebabe' FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case472" value="SELECT _dou ^ 2147483647 FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case473" value="SELECT _dou ^ x'cafebabe' FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case474" value="SELECT _dou | 2147483647 FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case475" value="SELECT _dou | x'cafebabe' FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case476" value="SELECT _dtt & 2147483647 FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case477" value="SELECT _dtt & x'cafebabe' FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case478" value="SELECT _dtt ^ 2147483647 FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case479" value="SELECT _dtt ^ x'cafebabe' FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case480" value="SELECT _dtt | 2147483647 FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case481" value="SELECT _dtt | x'cafebabe' FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case482" value="SELECT _enu & 2147483647 FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case483" value="SELECT _enu & x'cafebabe' FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case484" value="SELECT _enu ^ 2147483647 FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case485" value="SELECT _enu ^ x'cafebabe' FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case486" value="SELECT _enu | 2147483647 FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case487" value="SELECT _enu | x'cafebabe' FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case488" value="SELECT _flo & 2147483647 FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case489" value="SELECT _flo & x'cafebabe' FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case490" value="SELECT _flo ^ 2147483647 FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case491" value="SELECT _flo ^ x'cafebabe' FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case492" value="SELECT _flo | 2147483647 FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case493" value="SELECT _flo | x'cafebabe' FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case494" value="SELECT _id FROM t1" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case495" value="SELECT _id FROM t1" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case496" value="SELECT _id FROM t1" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case497" value="SELECT _id FROM t1" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case498" value="SELECT _ins & 2147483647 FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case499" value="SELECT _ins & x'cafebabe' FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case500" value="SELECT _ins ^ 2147483647 FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case501" value="SELECT _ins ^ x'cafebabe' FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case502" value="SELECT _ins | 2147483647 FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case503" value="SELECT _ins | x'cafebabe' FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case504" value="SELECT _inu & 2147483647 FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case505" value="SELECT _inu & x'cafebabe' FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case506" value="SELECT _inu ^ 2147483647 FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case507" value="SELECT _inu ^ x'cafebabe' FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case508" value="SELECT _inu | 2147483647 FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case509" value="SELECT _inu | x'cafebabe' FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case510" value="SELECT _jsn & 2147483647 FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case511" value="SELECT _jsn & x'cafebabe' FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case512" value="SELECT _jsn ^ 2147483647 FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case513" value="SELECT _jsn ^ x'cafebabe' FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case514" value="SELECT _jsn | 2147483647 FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case515" value="SELECT _jsn | x'cafebabe' FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case516" value="SELECT _lbb & 2147483647 FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case517" value="SELECT _lbb ^ 2147483647 FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case518" value="SELECT _lbb | 2147483647 FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case519" value="SELECT _ltx & 2147483647 FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case520" value="SELECT _ltx & x'cafebabe' FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case521" value="SELECT _ltx ^ 2147483647 FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case522" value="SELECT _ltx ^ x'cafebabe' FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case523" value="SELECT _ltx | 2147483647 FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case524" value="SELECT _ltx | x'cafebabe' FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case525" value="SELECT _mbb & 2147483647 FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case526" value="SELECT _mbb ^ 2147483647 FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case527" value="SELECT _mbb | 2147483647 FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case528" value="SELECT _mes & 2147483647 FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case529" value="SELECT _mes & x'cafebabe' FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case530" value="SELECT _mes ^ 2147483647 FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case531" value="SELECT _mes ^ x'cafebabe' FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case532" value="SELECT _mes | 2147483647 FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case533" value="SELECT _mes | x'cafebabe' FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case534" value="SELECT _meu & 2147483647 FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case535" value="SELECT _meu & x'cafebabe' FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case536" value="SELECT _meu ^ 2147483647 FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case537" value="SELECT _meu ^ x'cafebabe' FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case538" value="SELECT _meu | 2147483647 FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case539" value="SELECT _meu | x'cafebabe' FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case540" value="SELECT _mtx & 2147483647 FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case541" value="SELECT _mtx & x'cafebabe' FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case542" value="SELECT _mtx ^ 2147483647 FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case543" value="SELECT _mtx ^ x'cafebabe' FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case544" value="SELECT _mtx | 2147483647 FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case545" value="SELECT _mtx | x'cafebabe' FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case546" value="SELECT _pnt & 2147483647 FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case547" value="SELECT _pnt & x'cafebabe' FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case548" value="SELECT _pnt ^ 2147483647 FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case549" value="SELECT _pnt ^ x'cafebabe' FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case550" value="SELECT _pnt | 2147483647 FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case551" value="SELECT _pnt | x'cafebabe' FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case552" value="SELECT _set & 2147483647 FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case553" value="SELECT _set & x'cafebabe' FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case554" value="SELECT _set ^ 2147483647 FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case555" value="SELECT _set ^ x'cafebabe' FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case556" value="SELECT _set | 2147483647 FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case557" value="SELECT _set | x'cafebabe' FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case558" value="SELECT _smp & 2147483647 FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case559" value="SELECT _smp & x'cafebabe' FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case560" value="SELECT _smp ^ 2147483647 FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case561" value="SELECT _smp ^ x'cafebabe' FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case562" value="SELECT _smp | 2147483647 FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case563" value="SELECT _smp | x'cafebabe' FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case564" value="SELECT _sms & 2147483647 FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case565" value="SELECT _sms & x'cafebabe' FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case566" value="SELECT _sms ^ 2147483647 FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case567" value="SELECT _sms ^ x'cafebabe' FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case568" value="SELECT _sms | 2147483647 FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case569" value="SELECT _sms | x'cafebabe' FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case570" value="SELECT _smu & 2147483647 FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case571" value="SELECT _smu & x'cafebabe' FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case572" value="SELECT _smu ^ 2147483647 FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case573" value="SELECT _smu ^ x'cafebabe' FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case574" value="SELECT _smu | 2147483647 FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case575" value="SELECT _smu | x'cafebabe' FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case576" value="SELECT _tbl & 2147483647 FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case577" value="SELECT _tbl & x'cafebabe' FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case578" value="SELECT _tbl ^ 2147483647 FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case579" value="SELECT _tbl ^ x'cafebabe' FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case580" value="SELECT _tbl | 2147483647 FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case581" value="SELECT _tbl | x'cafebabe' FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case582" value="SELECT _tim & 2147483647 FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case583" value="SELECT _tim & x'cafebabe' FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case584" value="SELECT _tim ^ 2147483647 FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case585" value="SELECT _tim ^ x'cafebabe' FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case586" value="SELECT _tim | 2147483647 FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case587" value="SELECT _tim | x'cafebabe' FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case588" value="SELECT _tin & 2147483647 FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case589" value="SELECT _tin & x'cafebabe' FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case590" value="SELECT _tin ^ 2147483647 FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case591" value="SELECT _tin ^ x'cafebabe' FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case592" value="SELECT _tin | 2147483647 FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case593" value="SELECT _tin | x'cafebabe' FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case594" value="SELECT _ttx & 2147483647 FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case595" value="SELECT _ttx & x'cafebabe' FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case596" value="SELECT _ttx ^ 2147483647 FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case597" value="SELECT _ttx ^ x'cafebabe' FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case598" value="SELECT _ttx | 2147483647 FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case599" value="SELECT _ttx | x'cafebabe' FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case600" value="SELECT _txt & 2147483647 FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case601" value="SELECT _txt & x'cafebabe' FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case602" value="SELECT _txt ^ 2147483647 FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case603" value="SELECT _txt ^ x'cafebabe' FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case604" value="SELECT _txt | 2147483647 FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case605" value="SELECT _txt | x'cafebabe' FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case606" value="SELECT _vbn & 2147483647 FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case607" value="SELECT _vbn & x'cafebabe' FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case608" value="SELECT _vbn ^ 2147483647 FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case609" value="SELECT _vbn ^ x'cafebabe' FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case610" value="SELECT _vbn | 2147483647 FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case611" value="SELECT _vbn | x'cafebabe' FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case612" value="SELECT _vch & 2147483647 FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case613" value="SELECT _vch & x'cafebabe' FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case614" value="SELECT _vch ^ 2147483647 FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case615" value="SELECT _vch ^ x'cafebabe' FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case616" value="SELECT _vch | 2147483647 FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case617" value="SELECT _vch | x'cafebabe' FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case618" value="SELECT _yea & 2147483647 FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case619" value="SELECT _yea & x'cafebabe' FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case620" value="SELECT _yea ^ 2147483647 FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case621" value="SELECT _yea ^ x'cafebabe' FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case622" value="SELECT _yea | 2147483647 FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case623" value="SELECT _yea | x'cafebabe' FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case624" value="SELECT `B30896461`.`testFn`()" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case625" value="SELECT `B30896461`.`testFn`()" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case626" value="SELECT `B30896461`.`testfn`()" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case627" value="SELECT `B30896461`.`testfn`()" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case628" value="SELECT `b30896461`.`testfn`()" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case629" value="SELECT `b30896461`.`testfn`()" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case630" value="SELECT `b30896461`.`testfn`()" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case631" value="SELECT `b30896461`.`testfn`()" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case632" value="SELECT a AS f1, 'w' AS f2 FROM t GROUP BY f1, f2 WITH ROLLUP HAVING GROUPING(f1)=0" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case633" value="SELECT a AS f1, 'w' AS f2 FROM t GROUP BY f1, f2 WITH ROLLUP HAVING GROUPING(f2)=0" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case634" value="SELECT a AS f1, 'w' AS f2 FROM t GROUP BY f1, f2 WITH ROLLUP HAVING GROUPING(f2)=1" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case635" value="SELECT a FROM t1 IGNORE INDEX FOR ORDER BY (PRIMARY,i2) ORDER BY a" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case636" value="SELECT a IN (SELECT a FROM t1) FROM t1 LIMIT 1" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case637" value="SELECT a IN (SELECT a FROM t2 WHERE a=FLOOR(COUNT(t1.a)/2)) AS s FROM t1" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case638" value="SELECT a as Department, b as Employees, SUM(c), GROUPING(a) as GP_A, GROUPING(b) as GP_B FROM t1 GROUP BY a,b WITH ROLLUP" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case639" value="SELECT a as Department, b as Employees, SUM(c), GROUPING(a) as GP_A, GROUPING(b) as GP_B FROM t1 GROUP BY a,b WITH ROLLUP HAVING (GP_A =1 AND GP_B=1) OR (GP_B=1)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case640" value="SELECT a as Department,b as Employees, SUM(c), GROUPING(a) as GP_A, GROUPING(b) as GP_B FROM t1 GROUP BY a,b WITH ROLLUP" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case641" value="SELECT a as Department,b as Employees, SUM(c), GROUPING(a) as GP_A, GROUPING(b) as GP_B FROM t1 GROUP BY a,b WITH ROLLUP HAVING GP_A=1 OR GP_B=1" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case642" value="SELECT a, COUNT(*) AS c, a IN (SELECT a FROM t2 WHERE a=COUNT(t1.a)) AS s FROM t1 GROUP BY a" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case643" value="SELECT a, GROUPING(1) FROM t1 GROUP BY 1 WITH ROLLUP" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case644" value="SELECT a, GROUPING(SUM(a)) FROM t1 GROUP BY (a) WITH ROLLUP" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case645" value="SELECT a, MAX(TRIM('1' FROM ~1)) FROM t GROUP BY a" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case646" value="SELECT a, SUM(a), SUM(a)+1, CONCAT(SUM(a),'x'), SUM(a)+SUM(a), SUM(a) FROM (SELECT 1 a, 2 b UNION SELECT 2,3 UNION SELECT 5,6 ) d GROUP BY a WITH ROLLUP ORDER BY GROUPING(a),a" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case647" value="SELECT a, b FROM t1 GROUP BY GROUPING(a),GROUPING(b) WITH ROLLUP" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case648" value="SELECT a, b FROM t1 GROUP BY a,b WITH ROLLUP HAVING GROUPING(b) = 1" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case649" value="SELECT a, b FROM t1 WHERE GROUPING(a)=1 GROUP BY a,b WITH ROLLUP" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case650" value="SELECT a, b, GROUPING(a) FROM t1" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case651" value="SELECT a, b, GROUPING(a) FROM t1 GROUP BY a,b" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case652" value="SELECT a, b, GROUPING(c + c) FROM t1 GROUP BY a,b WITH ROLLUP" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case653" value="SELECT a, b, GROUPING(c + c) FROM t1 GROUP BY a,b,(c + c) WITH ROLLUP" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case654" value="SELECT a, b, GROUPING(c) FROM t1 GROUP BY a,b WITH ROLLUP" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case655" value="SELECT a, b, a IN (SELECT 1 FROM t2 WHERE a=6) AS s FROM t1" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case656" value="SELECT a, b, a IN (SELECT COUNT(*) FROM t2) AS c FROM t1" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case657" value="SELECT a, b, c, GROUPING(1) FROM t1 GROUP BY a,b,c WITH ROLLUP" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case658" value="SELECT a, b, c, GROUPING(a) FROM t1 GROUP BY a,b,c WITH ROLLUP" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case659" value="SELECT a, b, c, GROUPING(a, b) FROM t1 GROUP BY a,b,c WITH ROLLUP" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case660" value="SELECT a, b, c, GROUPING(a, b, c) FROM t1 GROUP BY a,b WITH ROLLUP" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case661" value="SELECT a, b, c, GROUPING(a, b, c) FROM t1 GROUP BY a,b,c WITH ROLLUP" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case662" value="SELECT a, fn(MIN(b) xx) as c FROM t1 GROUP BY a" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case663" value="SELECT alias1.col_decimal_10_8 AS field1 , ( SELECT SUM(table1.col_smallint ) AS SQ1_field1 FROM ( t1 as table1 RIGHT JOIN t1 as table2 ON 1 ) ) AS field2 , GROUPING( LOG(alias1.col_int) ) AS field3 FROM ( t1 AS alias1 JOIN t1 AS alias2 ON 1 ) WHERE alias2.pk IN ( SELECT col_char_255 FROM t1 ) GROUP BY field1, field2, LOG(alias1.col_int) WITH ROLLUP ORDER BY alias1.col_datetime, field1, field2, LOG(alias1.col_int)" db-types=" [...]
+ <sql-case id="select_by_mysql_source_test_case664" value="SELECT alias2 . `col_int_nokey` AS field1 FROM ( CC AS alias1 INNER JOIN ( ( BB AS alias2 INNER JOIN ( SELECT SQ1_alias1 . * FROM C AS SQ1_alias1 ) AS alias3 ON (alias3 . `col_int_key` = alias2 . `col_int_nokey` ) ) ) ON (alias3 . `col_varchar_nokey` = alias2 . `col_varchar_key` ) ) WHERE ( ( alias2 . `pk` , alias3 . `col_int_nokey` ) IN ( SELECT 4 , 7 UNION SELECT 137, 6 ) ) AND alias1 . `pk` > 149 AND alias1 . `p [...]
+ <sql-case id="select_by_mysql_source_test_case665" value="SELECT attrs.* FROM t_json, JSON_TABLE(json_col, '$[*]' COLUMNS (nickname JSON PATH '$.nickname')) as attrs" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case666" value="SELECT b, b IN ('20161213'), b in ('20161213', 0) FROM t2" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case667" value="SELECT b, b in ('121314'), b in ('121314', 0) FROM t3" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case668" value="SELECT bin_to_uuid(_bin), bin_to_uuid(_vbn), bin_to_uuid(_tbl), bin_to_uuid(_ttx), bin_to_uuid(_blb) FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case669" value="SELECT bin_to_uuid(x'')" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case670" value="SELECT bin_to_uuid(x'', true)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case671" value="SELECT bug18589_f1(REPEAT("a", 767))" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case672" value="SELECT c1 <= REPEAT( SUBSTR( UPPER('Rdlpikti') , 1 , 2 ), 8 ) FROM t1" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case673" value="SELECT c1, TRIM(BOTH '𠻞' FROM c1) FROM `表一`" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case674" value="SELECT c1, TRIM(LEADING '𠻞' FROM c1) FROM `表一`" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case675" value="SELECT c1, TRIM(TRAILING '𠻞' FROM c1) FROM `表一`" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case676" value="SELECT cast( '2019-10-10 10:11' AT TIME ZONE 'UTC' AS DATETIME )" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case677" value="SELECT cast( '2019-10-10' AT TIME ZONE 'UTC' AS DATETIME )" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case678" value="SELECT cast( 123 AT TIME ZONE 'UTC' AS DATETIME )" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case679" value="SELECT cast( TIME'10:10' AT TIME ZONE 'UTC' AS DATETIME )" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case680" value="SELECT cast( a AT TIME ZONE '+00:00' AS DATETIME ) FROM t1" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case681" value="SELECT cast( a AT TIME ZONE '+00:00' AS DATETIME ) FROM t1" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case682" value="SELECT cast( b AT TIME ZONE '+00:00' AS DATETIME ) FROM t1" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case683" value="SELECT cast( b AT TIME ZONE '+00:00' AS DATETIME ) FROM t1" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case684" value="SELECT cast(TIMESTAMP'2019-10-10 10:11:12' AT TIME ZONE '+00:00' AS DATETIME)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case685" value="SELECT cast(TIMESTAMP'2019-10-10 10:11:12' AT TIME ZONE 'UTC' AS DATETIME)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case686" value="SELECT cast(TIMESTAMP'2019-10-10 10:11:12+00:00' AT TIME ZONE '+00:00' AS DATETIME)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case687" value="SELECT col_datetime_3_key , COUNT( col_timestamp_5_key ) FROM t1 FORCE KEY (PRIMARY, col_datetime_5_not_null_key, col_datetime_6_key, col_time_5_key, col_time_2_key) WHERE (col_time_4_not_null_key NOT BETWEEN '2002-01-01 21:50:38.023562' AND '20090504151448.022774' AND col_time_1_not_null_key IN ('2000-07-13 21:35:51.034786', '2004-10-13 19:51:18.029716', '2001-11-23 10:22:42.001689 [...]
+ <sql-case id="select_by_mysql_source_test_case688" value="SELECT col_datetime_5_not_null AS c1, col_time_1_not_null_key AS c2 FROM t1 WHERE col_time_4_not_null = MAKETIME(24, 60, 3 ) AND col_time_3 NOT IN ( col_datetime_5, UTC_DATE(), col_timestamp_5_key, ADDDATE('0000-00-00 00:00:00', DATEDIFF('2001-09-21',FROM_UNIXTIME(1018888192, CONCAT_WS('-','%s','%V','%u')))), col_timestamp_4) AND col_timestamp_2 NOT BETWEEN col_dateti [...]
+ <sql-case id="select_by_mysql_source_test_case689" value="SELECT col_datetime_5_not_null AS c1, col_time_1_not_null_key AS c2 FROM t1 WHERE col_time_4_not_null=MAKETIME(24,60, 3) AND col_time_3 NOT IN (col_datetime_5, UTC_DATE(), col_timestamp_5_key, col_timestamp_4) AND col_timestamp_2 NOT BETWEEN col_datetime AND '2005-09-12' ORDER BY 1" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case690" value="SELECT col_time_5_key AS c1, col_time_key AS c2, col_timestamp AS c3 FROM t1 WHERE col_time_not_null NOT BETWEEN EXTRACT(YEAR_MONTH FROM '0000-00-00 00:00:00') AND COALESCE (col_time_6_not_null_key, col_datetime_key) ORDER BY 1, 2" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case691" value="SELECT col_timestamp_3 AS c1, col_date AS c2, CURTIME() AS c3 FROM t1 WHERE col_time_3_not_null NOT IN (col_time_not_null, CAST(col_time_5 AS DATETIME(3)), MAKEDATE(DAYOFMONTH('2002-09-13'), DATEDIFF('2009-12-15', col_timestamp_6)), CURRENT_DATE()) AND col_time_3_key NOT BETWEEN LEAST(CURRENT_TIME(), TIMESTAMPADD(HOUR, 187, MAKETIME(209, 60, 1))) AND CURTIME() AND col_datetime_2_not_null NOT IN (DATE(' [...]
+ <sql-case id="select_by_mysql_source_test_case692" value="SELECT col_timestamp_6_not_null_key AS c1, col_datetime_key AS c2, UTC_DATE() AS c3 FROM t1 WHERE col_time_1_key BETWEEN TIMESTAMPADD(MONTH, 38 ,CONVERT_TZ( DATE(MAKEDATE(207, 38 )), '+00:00','+04:00')) AND LOCALTIMESTAMP() ORDER BY col_datetime_4_not_null_key , col_time_5 , col_time_3_not_null" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case693" value="SELECT col_timestamp_not_null AS c1, col_datetime_6_not_null_key AS c2 FROM t1 WHERE col_timestamp IS NOT NULL AND col_timestamp_2 <> col_time_1_not_null AND col_timestamp_key BETWEEN col_datetime_3_not_null AND CURRENT_TIME() OR col_time_6_not_null != LEAST(col_time_6, UTC_TIME())" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case694" value="SELECT current_date IN ( MAX(NULL), 1 )" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case695" value="SELECT current_time IN ( MAX(NULL), 1 )" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case696" value="SELECT db1.f1()" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case697" value="SELECT db1.f1()" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case698" value="SELECT db1.f1()" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case699" value="SELECT db1.f1(1)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case700" value="SELECT db1.f2()" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case701" value="SELECT db_name.very_long_fn_name_111111111111111111111111111111111111111111111111111111111111111111111111122222222222222222222222222222222222222222222222222222222222222222222222222222222222222222222222222222222222222222222222222222222222999999999999999999999()" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case702" value="SELECT derived0.cnct AS subq FROM t1 LEFT JOIN LATERAL (WITH RECURSIVE dt AS (SELECT t1.a AS a UNION SELECT (dt.a + 1) FROM dt WHERE dt.a < 10) SELECT t1.a * CONCAT(COUNT(0), '.', FLOOR(AVG(dt.a))) AS cnct FROM dt) derived0 ON TRUE" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case703" value="SELECT g.calc_var, g.if_var, g.case_var FROM ( SELECT unq_id, IF ( var_fld > 5000, ( 1 / var_fld ) , 5000 ) calc_var, IF ( var_fld > 5000, ( 00001 / var_fld ) , 5000 ) if_var, CASE var_fld > 5000 WHEN TRUE THEN ( 1 / var_fld ) ELSE 5000 END case_var FROM test_grids_1 ) g JOIN test_grid_dtl_1 d USING (unq_id) ORDER BY 1" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case704" value="SELECT hex(_bin & x'CAFEBABE000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 [...]
+ <sql-case id="select_by_mysql_source_test_case705" value="SELECT hex(_bin ^ x'CAFEBABE0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 [...]
+ <sql-case id="select_by_mysql_source_test_case706" value="SELECT hex(_bin | x'CAFEBABE0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 [...]
+ <sql-case id="select_by_mysql_source_test_case707" value="SELECT hex(_blb & x'cafebabe') FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case708" value="SELECT hex(_blb ^ x'cafebabe') FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case709" value="SELECT hex(_blb | x'cafebabe') FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case710" value="SELECT hex(_lbb & x'cafebabe') FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case711" value="SELECT hex(_lbb ^ x'cafebabe') FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case712" value="SELECT hex(_lbb | x'cafebabe') FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case713" value="SELECT hex(_mbb & x'cafebabe') FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case714" value="SELECT hex(_mbb ^ x'cafebabe') FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case715" value="SELECT hex(_mbb | x'cafebabe') FROM at" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case716" value="SELECT hex(_tbl & x'CAFEBABE000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 [...]
+ <sql-case id="select_by_mysql_source_test_case717" value="SELECT hex(_tbl ^ x'CAFEBABE0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 [...]
+ <sql-case id="select_by_mysql_source_test_case718" value="SELECT hex(_tbl | x'CAFEBABE0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 [...]
+ <sql-case id="select_by_mysql_source_test_case719" value="SELECT hex(_vbn & x'CAFEBABE000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 [...]
+ <sql-case id="select_by_mysql_source_test_case720" value="SELECT hex(_vbn ^ x'CAFEBABE0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 [...]
+ <sql-case id="select_by_mysql_source_test_case721" value="SELECT hex(_vbn | x'CAFEBABE0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 [...]
+ <sql-case id="select_by_mysql_source_test_case722" value="SELECT i FROM t1 WHERE EXISTS (SELECT i, j, SUM(k) FROM t1 AS t2 WHERE t1.i=t2.i GROUP BY i,j WITH ROLLUP HAVING SUM(k) > 40 ORDER BY GROUPING(i),i, GROUPING(j),j)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case723" value="SELECT i, 'sum' FROM (SELECT i, SUM(j) AS 'sum' FROM t1 GROUP BY i WITH ROLLUP ORDER BY GROUPING(i),i) AS tmp WHERE i is NULL" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case724" value="SELECT i, GROUPING(i+j), AVG(k) from t1 GROUP BY i,i+j WITH ROLLUP HAVING AVG(k) + 20 < 35 ORDER BY i" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case725" value="SELECT i, GROUPING(i+j), AVG(k) from t1 GROUP BY i,i+j WITH ROLLUP HAVING AVG(k) > 10 ORDER BY i" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case726" value="SELECT i, GROUPING(i+j), AVG(k) from t1 GROUP BY i,i+j WITH ROLLUP HAVING i is NOT NULL ORDER BY i+j" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case727" value="SELECT i, JSON_ARRAYAGG(i) OVER() FROM t1" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case728" value="SELECT i, JSON_OBJECTAGG(i,f) OVER w jobject_f FROM t1 GROUP BY i,f WITH ROLLUP HAVING GROUPING(f)=1 WINDOW w AS (ORDER BY f)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case729" value="SELECT i, JSON_OBJECTAGG(i,j) OVER() FROM t1" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case730" value="SELECT i, JSON_OBJECTAGG(i,j) OVER(PARTITION BY i) FROM t1" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case731" value="SELECT i, PERCENT_RANK() OVER (ORDER BY f) p_rank, JSON_ARRAYAGG(j) OVER (ORDER BY i,j ROWS UNBOUNDED PRECEDING) jarray_j FROM t1" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case732" value="SELECT i, f, JSON_ARRAYAGG(i) OVER w jarray_i, JSON_ARRAYAGG(f) OVER w jarray_f FROM t1 GROUP BY i,f WITH ROLLUP HAVING GROUPING(f)=1 WINDOW w AS (ORDER BY f)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case733" value="SELECT i, f, MAX(i) OVER w max, JSON_ARRAYAGG(i) OVER w jarray_i FROM t1 WINDOW w AS (PARTITION BY i ROWS UNBOUNDED PRECEDING)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case734" value="SELECT i, f, MIN(i) OVER w min, JSON_ARRAYAGG(i) OVER w jarray_i FROM t1 WINDOW w AS (PARTITION BY f)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case735" value="SELECT i, f, PERCENT_RANK() OVER (ORDER BY f) p_rank, JSON_OBJECTAGG(i,j) OVER (ORDER BY i,j ROWS UNBOUNDED PRECEDING) jobject_j FROM t1" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case736" value="SELECT i, f, PERCENT_RANK() OVER w p_rank, JSON_ARRAYAGG(i) OVER w jarray_i FROM t1 WINDOW w AS (PARTITION BY i ORDER BY f RANGE BETWEEN 2.1 FOLLOWING AND 4.5 FOLLOWING)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case737" value="SELECT i, f, RANK() OVER w rank1, NTH_VALUE(i,3) OVER w nth, LEAD(f, 2) OVER w lead1, LAG(f,2) OVER w lag1, JSON_ARRAYAGG(i) OVER w jarray_i FROM t1 WINDOW w AS (ORDER BY f)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case738" value="SELECT i, f, j, CUME_DIST() OVER w c_dist, JSON_ARRAYAGG(j) OVER w jarray_j FROM t1 WINDOW w AS (PARTITION BY i ORDER BY f RANGE BETWEEN 1 PRECEDING AND 10 FOLLOWING)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case739" value="SELECT i, j, AVG(k) FROM t1 GROUP BY i,j WITH ROLLUP ORDER BY GROUPING(i),i,GROUPING(j),j" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case740" value="SELECT i, j, AVG(k) FROM t1 GROUP BY i,j WITH ROLLUP ORDER BY GROUPING(i),i,GROUPING(j),j LIMIT 5" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case741" value="SELECT i, j, AVG(k) FROM t1 GROUP BY i,j+GROUPING(i) WITH ROLLUP" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case742" value="SELECT i, j, JSON_OBJECTAGG(j,f) OVER w jobject_i, JSON_OBJECTAGG(j,s) OVER w jobject_f FROM t1 WINDOW w AS (PARTITION BY i ORDER BY j)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case743" value="SELECT i, j, SUM(k) FROM t1 GROUP BY i,j WITH ROLLUP HAVING i > 10 and j < 1000 ORDER BY GROUPING(i),i,GROUPING(j),j" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case744" value="SELECT i, j, f, CUME_DIST() OVER w c_dist, JSON_ARRAYAGG(i) OVER w jarray_i FROM t1 WINDOW w AS (PARTITION BY i ORDER BY j ROWS BETWEEN 1 FOLLOWING AND 2 FOLLOWING)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case745" value="SELECT i, j, f, JSON_OBJECTAGG(f,j) OVER w jobject_i FROM t1 WINDOW w AS (PARTITION BY i ORDER BY f RANGE BETWEEN 2.1 FOLLOWING AND 4.5 FOLLOWING)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case746" value="SELECT i, j, f, JSON_OBJECTAGG(i,f) OVER w jobject_i FROM t1 WINDOW w AS (PARTITION BY i ORDER BY f RANGE BETWEEN 2.1 FOLLOWING AND 4.5 FOLLOWING)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case747" value="SELECT i, j, f, JSON_OBJECTAGG(i,j) OVER w jobject_i FROM t1 WINDOW w AS (PARTITION BY i ORDER BY j ROWS BETWEEN 1 FOLLOWING AND 5 FOLLOWING)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case748" value="SELECT i, j, f, JSON_OBJECTAGG(i,j) OVER w jobject_i, MAX(i) OVER w max FROM t1 WINDOW w AS (PARTITION BY f ROWS UNBOUNDED PRECEDING)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case749" value="SELECT i, j, f, JSON_OBJECTAGG(i,j) OVER w jobject_i, MIN(i) OVER w min FROM t1 WINDOW w AS (PARTITION BY i)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case750" value="SELECT i, j, f, JSON_OBJECTAGG(i,j) OVER w jobject_i, RANK() OVER w rank1 FROM t1 WINDOW w AS (PARTITION BY f ORDER BY j ROWS BETWEEN 2 PRECEDING AND 1 PRECEDING)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case751" value="SELECT i, j, f, JSON_OBJECTAGG(i,j) OVER w jobject_i, RANK() OVER w rank1 FROM t1 WINDOW w AS (PARTITION BY f ORDER BY j ROWS BETWEEN 2 PRECEDING AND CURRENT ROW)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case752" value="SELECT i, j, f, JSON_OBJECTAGG(i,j) OVER w jobject_i, RANK() OVER w rank1, NTH_VALUE(i,2) OVER w nth, LEAD(f, 1) OVER w lead1, LAG(f,1) OVER w lag1 FROM t1 WINDOW w AS (PARTITION BY i ORDER BY j)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case753" value="SELECT i, j, f, JSON_OBJECTAGG(j,f) OVER w jobject_f, RANK() OVER w rank1 FROM t1 WINDOW w AS (PARTITION BY i ORDER BY i)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case754" value="SELECT i, j, f, JSON_OBJECTAGG(j,f) OVER w jobject_j FROM t1 WINDOW w AS (PARTITION BY i ROWS BETWEEN 1 FOLLOWING AND UNBOUNDED FOLLOWING)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case755" value="SELECT i, j, f, JSON_OBJECTAGG(j,f) OVER w jobject_j FROM t1 WINDOW w AS (PARTITION BY i ROWS BETWEEN 2 PRECEDING AND 4 FOLLOWING)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case756" value="SELECT i, j, f, JSON_OBJECTAGG(j,f) OVER w jobject_j, CUME_DIST() OVER w c_dist FROM t1 WINDOW w AS (PARTITION BY i ORDER BY j ROWS BETWEEN 1 FOLLOWING AND 2 FOLLOWING)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case757" value="SELECT i, j, f, JSON_OBJECTAGG(j,f) OVER w jobject_j, CUME_DIST() OVER w c_dist FROM t1 WINDOW w AS (PARTITION BY i ORDER BY j,f ROWS BETWEEN 2 PRECEDING AND 2 FOLLOWING)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case758" value="SELECT i, j, f, JSON_OBJECTAGG(j,f) OVER w jobject_j, MAX(i) OVER w max FROM t1 WINDOW w AS (PARTITION BY f ROWS UNBOUNDED PRECEDING)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case759" value="SELECT i, j, f, JSON_OBJECTAGG(j,f) OVER w jobject_j, RANK() OVER w rank1 FROM t1 WINDOW w AS (PARTITION BY f ORDER BY j ROWS BETWEEN 2 PRECEDING AND 1 PRECEDING)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case760" value="SELECT i, j, f, JSON_OBJECTAGG(j,f) OVER w jobject_j, RANK() OVER w rank1 FROM t1 WINDOW w AS (PARTITION BY f ORDER BY j ROWS BETWEEN 2 PRECEDING AND CURRENT ROW)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case761" value="SELECT i, j, f, RANK() OVER w rank1, JSON_ARRAYAGG(i) OVER w jarray_i FROM t1 WINDOW w AS (PARTITION BY i ORDER BY j ROWS BETWEEN 2 PRECEDING AND 1 PRECEDING)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case762" value="SELECT i, j, i AS k, COUNT(*) AS count FROM t1 GROUP BY i, j, k WITH ROLLUP ORDER BY GROUPING(i),i, GROUPING(j),j, GROUPING(k),k" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case763" value="SELECT i, j, i+j, AVG(j) over () from t1 GROUP BY i,j WITH ROLLUP HAVING i+j is NULL ORDER BY GROUPING(i)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case764" value="SELECT i, j, i+j, AVG(j), AVG(j) over () from t1 GROUP BY i,j WITH ROLLUP HAVING GROUPING(j)+AVG(j) > 11 ORDER BY GROUPING(i)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case765" value="SELECT i, j, i+j, FIRST_VALUE(i) over () from t1 GROUP BY i,j WITH ROLLUP HAVING 1 + 2 - GROUPING(i) = 2 ORDER BY GROUPING(i)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case766" value="SELECT i, j, i+j, FIRST_VALUE(i) over () from t1 GROUP BY i,j WITH ROLLUP HAVING GROUPING(i) = 1 ORDER BY GROUPING(i)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case767" value="SELECT i, j, i+j, FIRST_VALUE(i) over () from t1 GROUP BY i,j WITH ROLLUP HAVING i+j is NULL ORDER BY GROUPING(i)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case768" value="SELECT i,j, SUM(k), GROUPING(i), GROUPING(j) FROM t1 GROUP BY i,j WITH ROLLUP HAVING GROUPING(i) = 1 OR GROUPING (j) = 1 ORDER BY GROUPING(i),i,GROUPING(j),j" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case769" value="SELECT id, CHAR_LENGTH(GROUP_CONCAT(body)) AS l FROM (SELECT 'a' AS id, REPEAT('foo bar', 100) AS body UNION ALL SELECT 'a' AS id, REPEAT('bla bla', 100) AS body) t1 GROUP BY id ORDER BY l DESC" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case770" value="SELECT id, CHAR_LENGTH(GROUP_CONCAT(body)) AS l FROM (SELECT 'a' AS id, REPEAT('foo bar', 100) AS body UNION ALL SELECT 'a' AS id, REPEAT('bla bla', 100) AS body) t1 GROUP BY id ORDER BY l DESC" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case771" value="SELECT insert( substring_index( 'a', 'a', 'b' ), 1, 0, 'x' )" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case772" value="SELECT insert(a,1,1,1) FROM t1" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case773" value="SELECT j, i, JSON_OBJECTAGG(j,i) OVER w jobject_i, JSON_OBJECTAGG(j,f) OVER w jobject_f FROM t1 WINDOW w AS (ORDER BY j DESC)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case774" value="SELECT j, i, f, JSON_ARRAYAGG(i) OVER w jarray_i, JSON_ARRAYAGG(f) OVER w jarray_f FROM t1 WINDOW w AS (ORDER BY j DESC)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case775" value="SELECT j, i, f, JSON_ARRAYAGG(i) OVER w jarray_i, JSON_ARRAYAGG(f) OVER w jarray_f FROM t1 WINDOW w AS (ORDER BY j)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case776" value="SELECT j, s, JSON_ARRAYAGG(s) OVER w jarray_s, JSON_ARRAYAGG(j) OVER w jarray_j FROM t1 WINDOW w AS (ORDER BY j)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case777" value="SELECT j, s, JSON_OBJECTAGG(j, s) OVER w jobject_s FROM t1 GROUP BY j,s WINDOW w AS (ORDER BY j)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case778" value="SELECT j, s, JSON_OBJECTAGG(j,s) OVER w jobject_s, JSON_OBJECTAGG(f,j) OVER w jobject_j FROM t1 WINDOW w AS (ORDER BY j) ORDER BY j DESC" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case779" value="SELECT j, s, f, JSON_OBJECTAGG(j,f) OVER w jobject_f, JSON_OBJECTAGG(j,s) OVER w jobject_s FROM t1 WINDOW w AS (ORDER BY j)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case780" value="SELECT j, s, f, JSON_OBJECTAGG(j,s) OVER w jobject_s, JSON_OBJECTAGG(f,j) OVER w jobject_j FROM t1 WINDOW w AS (PARTITION BY i ORDER BY s)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case781" value="SELECT length(data) AS len FROM ( SELECT repeat(_utf8mb4 0xE29883, 21844) AS data ) AS sub" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case782" value="SELECT length(data) AS len FROM ( SELECT repeat(_utf8mb4 0xE29883, 21846) AS data ) AS sub" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case783" value="SELECT length(regexp_replace( repeat('a', @buf_sz_utf16 + 1), 'a', 'b' ))" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case784" value="SELECT length(regexp_replace( repeat('a', @buf_sz_utf16), 'a', 'b' ))" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case785" value="SELECT length(regexp_replace( repeat('a', @buf_sz_utf16), 'a', 'bb' ))" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case786" value="SELECT length(repeat(_utf8mb4 0xE29883, 21844)) AS data" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case787" value="SELECT length(repeat(_utf8mb4 0xE29883, 21846)) AS data" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case788" value="SELECT myfunc_int(MIN(b) xx) as c FROM t1 GROUP BY a" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case789" value="SELECT myfunc_int(a AS attr_name) FROM t1" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case790" value="SELECT myfunc_int(fn(MIN(b) xx)) as c FROM t1 GROUP BY a" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case791" value="SELECT myfunc_int(fn(MIN(b)) xx) as c FROM t1 GROUP BY a" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case792" value="SELECT myfunc_int(test.fn(MIN(b)) xx) as c FROM t1 GROUP BY a" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case793" value="SELECT myfunc_int(test.fn(MIN(b))) as c FROM t1 GROUP BY a" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case794" value="SELECT mysqltest.f1()" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case795" value="SELECT mysqltest.f1()" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case796" value="SELECT mysqltest.f1()" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case797" value="SELECT mysqltest.f1()" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case798" value="SELECT point(1,1) IN ('1',1,'1') AS res" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case799" value="SELECT product, country_id , SUM(profit) FROM t1 GROUP BY product, country_id WITH ROLLUP ORDER BY product DESC, GROUPING (country_id), country_id" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case800" value="SELECT product, country_id , year, SUM(profit) FROM t1 EXPLAIN SELECT product, country_id , year, SUM(profit) FROM t1 SELECT product, country_id , year, SUM(profit) FROM t1 GROUP BY product, country_id, year WITH CUBE UNION ALL SELECT product, country_id , year, SUM(profit) FROM t1 drop table t1,t2" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case801" value="SELECT regexp_like( repeat(@v1, 'abc'), 'abc' )" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case802" value="SELECT right(a,1) FROM t1 WHERE b = repeat('0',257) ORDER BY a ASC" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case803" value="SELECT right(a,1) FROM t1 WHERE b = repeat('0',257) ORDER BY a ASC" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case804" value="SELECT right(a,1) FROM t1 WHERE b = repeat('0',257) ORDER BY a DESC" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case805" value="SELECT right(a,1) FROM t1 WHERE b = repeat('0',257) ORDER BY a DESC" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case806" value="SELECT s, 32 AS mi FROM t1 GROUP BY s HAVING DEFAULT(mi) IS NULL" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case807" value="SELECT s, j, JSON_ARRAYAGG(s) OVER w jarray_s, JSON_ARRAYAGG(j) OVER w jarray_j FROM t1 GROUP BY s,j WINDOW w AS (ORDER BY j)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case808" value="SELECT s, j, JSON_ARRAYAGG(s) OVER w jarray_s, JSON_ARRAYAGG(j) OVER w jarray_j FROM t1 WINDOW w AS (ORDER BY j) ORDER BY j DESC" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case809" value="SELECT s.Id FROM s WHERE Id=1 AND u IS NOT NULL) ORDER BY Id DESC" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case810" value="SELECT s.Id FROM s WHERE Id=1 AND u IS NULL)ORDER BY Id DESC" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case811" value="SELECT s.Id FROM s2 s WHERE Id=1 AND u IS NULL) ORDER BY Id DESC" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case812" value="SELECT s.Id FROM s3 s WHERE Id=1 AND u IS NOT NULL) ORDER BY Id DESC" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case813" value="SELECT s1.Id FROM s1 WHERE Id=1 AND u != 1) ORDER BY Id DESC" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case814" value="SELECT s1.Id FROM s1 WHERE Id=1 AND u IS NOT NULL) ORDER BY Id DESC" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case815" value="SELECT sex, AVG(id) FROM t1 GROUP BY sex WITH ROLLUP HAVING (sex='M' OR sex IS NULL) AND AVG(id)=3.0 ORDER BY GROUPING(sex), sex" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case816" value="SELECT st_centroid(point(1,1)) IN ('1',1,'1') AS res" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case817" value="SELECT t.*, MIN(t.rank) OVER (ROWS UNBOUNDED PRECEDING) min, MAX(t.rank) OVER (ROWS UNBOUNDED PRECEDING) max FROM (SELECT sex, id, date, ROW_NUMBER() OVER w AS row_no, RANK() OVER w AS `rank` FROM t1,t2 WHERE t1.id=t2.user_id WINDOW w AS (PARTITION BY date ORDER BY id) ) AS t" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case818" value="SELECT t1.a FROM t1, LATERAL ( SELECT t1.a FROM t1 AS inner_t1 LIMIT 1 ) AS d1 WHERE 1 IN ( SELECT a FROM t1 ) ORDER BY a" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case819" value="SELECT t1.col FROM (TABLE t) AS t1, (SELECT * FROM (VALUES ROW('Y')) AS sq_t1, t) AS t2" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case820" value="SELECT t2.f2 FROM t1 JOIN ( t1 AS t2 LEFT JOIN t1 AS t3 USING (f2) ) ON t3.f2 = t2.f2 WHERE t2.f1 > table1.f2 ) FROM t1 AS table1" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case821" value="SELECT t2.pk FROM t4 RIGHT JOIN t3 ON t4.col_int_key = t3.pk RIGHT JOIN t2 ON t3.col_int_key <> t2.pk )" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case822" value="SELECT test.bug12812()" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case823" value="SELECT test.fn(MIN(b)) as c FROM t1 GROUP BY a" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case824" value="SELECT very_long_db_name_111111111111111111111111111111111111111111111111111111111111111111111111122222222222222222222222222222222222222222222222222222222222222222222222222222222222222222222222222222222222222222222222222222222222222222222222222222222222222222222222222222222222222222222222222222222222222222222222222222222222222222222222222555555555555555555555555557777777777777777777777777777777777777777777777777777777777777777 [...]
+ <sql-case id="select_by_mysql_source_test_case825" value="SELECT world.func_plusone(1)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case826" value="SELECT world.func_plustwo(1)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case827" value="select !0,NOT 0=1,!(0=0),1 AND 1,1 && 0,0 OR 1,1 || NULL, 1=1 or 1=1 and 1=0" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case828" value="select 'b' between 'a' and 'c', 'B' between 'a' and 'c'" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case829" value="select (1,2,(3,4)) IN ((3,2,(3,4)), (1,2,(3,4)))" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case830" value="select (1,2,3) IN ((3,2,3), (1,2,3), (1,3,3))" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case831" value="select (NOT FALSE) AND FALSE, NOT (FALSE AND FALSE), NOT FALSE AND FALSE" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case832" value="select (NOT FALSE) OR TRUE, NOT (FALSE OR TRUE), NOT FALSE OR TRUE" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case833" value="select (NOT FALSE) XOR FALSE, NOT (FALSE XOR FALSE), NOT FALSE XOR FALSE" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case834" value="select (NOT NULL) IS FALSE, NOT (NULL IS FALSE), NOT NULL IS FALSE" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case835" value="select (NOT NULL) IS NOT FALSE, NOT (NULL IS NOT FALSE), NOT NULL IS NOT FALSE" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case836" value="select (NOT NULL) IS NOT TRUE, NOT (NULL IS NOT TRUE), NOT NULL IS NOT TRUE" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case837" value="select (NOT NULL) IS TRUE, NOT (NULL IS TRUE), NOT NULL IS TRUE" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case838" value="select (NOT TRUE) IS NOT NULL, NOT (TRUE IS NOT NULL), NOT TRUE IS NOT NULL" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case839" value="select (NOT TRUE) IS NOT UNKNOWN, NOT (TRUE IS NOT UNKNOWN), NOT TRUE IS NOT UNKNOWN" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case840" value="select (NOT TRUE) IS NULL, NOT (TRUE IS NULL), NOT TRUE IS NULL" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case841" value="select (NOT TRUE) IS UNKNOWN, NOT (TRUE IS UNKNOWN), NOT TRUE IS UNKNOWN" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case842" value="select (ST_aswkb(cast(st_union(multipoint( point(8,6), point(1,-17679), point(-9,-9)), linestring(point(91,12), point(-77,49), point(53,-81)))as char(18)))) in ('1','2')" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case843" value="select (case 1/0 when "a" then "true" END) + 0.0" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case844" value="select (case 1/0 when "a" then "true" END) | 0" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case845" value="select (select f from lateral (select max(t1.a) as f) as dt) as g from t1" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case846" value="select * from information_schema.views where TABLE_SCHEMA != 'sys' and TABLE_NAME rlike "v[0-4]{1}$" order by table_name" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case847" value="select * from t1 as t0, lateral (select dt3.* from t1, lateral (select * from (select * from (select t0.a from t2) as dt limit 1) dt2) dt3) dt4" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case848" value="select * from t1 ignore index (primary) where tt like 'AA%'" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case849" value="select * from t1 ignore index (primary) where tt like 'Aa%'" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case850" value="select * from t1 where MATCH(a,b) AGAINST ("indexes" IN BOOLEAN MODE WITH QUERY EXPANSION)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case851" value="select * from t1 where str <> default(str)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case852" value="select * from t1, lateral (select * from (select * from (select t1.a from t2) as dt limit 1) dt2) dt3" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case853" value="select * from t1, lateral (select * from (select 42) t1, (select t1.a) dt2) dt3" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case854" value="select * from t1, lateral (select t1.a from t2 as t3, t2 as t4) as dt, t2" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case855" value="select * from t1, lateral (select t1.a) as dt, t2" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case856" value="select * from t1, lateral (select t3.b from t3 where t3.a=t1.a) dt where dt.b=t1.a+9" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case857" value="select * from t1, lateral (with qn as (select t1.a) select (select max(a) from qn)) as dt" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case858" value="select * from t1, t2, lateral (select t1.a) as dt" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case859" value="select * from t2 left join t1 ignore index(primary) on t1.fooID = t2.fooID and t1.fooID = 30" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case860" value="select * from t2, t1, lateral (select t1.a) as dt" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case861" value="select * from t2, t1, lateral (select t1.a) as dt, lateral (select t1.a+1) as dt2" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case862" value="select * from t2, t1, lateral (select t1.a) as dt, lateral (select t2.a) as dt2" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case863" value="select * from t2, t1, lateral (select t1.a+t2.a) as dt" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case864" value="select * from t3, lateral (select t3.a+1) as dt" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case865" value="select * from имя_таблицы_в_кодировке_утф8_длиной_больше_чем_48" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case866" value="select *, mysqltest1.bug17199() from t3" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case867" value="select /*+ no_merge() */ * from t1 as t0, lateral (select dt3.* from t1, lateral (select * from (select * from (select t0.a from t2) as dt limit 1) dt2) dt3) dt4" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case868" value="select 0.1 in (1.0, 1.2, 1.1, a, 1.4, 0.5) from t1" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case869" value="select 0.5 IN (1.0, 1.2, NULL, 1.4, 0.5)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case870" value="select 1 IN (1.11, 1.2, 1.1, 1.4, 1, 0.5)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case871" value="select 1 IN (1.11, 1.2, 1.1, 1.4, NULL, 0.5)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case872" value="select 1 into a" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case873" value="select 1.1 IN (1.0, 1.2)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case874" value="select 1.1 IN (1.0, 1.2, 1.1, 1.4, 0.5)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case875" value="select 1.1 IN (1.0, 1.2, NULL, 1.4, 0.5)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case876" value="select 1ea10.1a20,1e+ 1e+10 from 1ea10" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case877" value="select 2 between 1 and 3, "monty" between "max" and "my",2=2 and "monty" between "max" and "my" and 3=3" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case878" value="select 2 between null and 1,2 between 3 AND NULL,NULL between 1 and 2,2 between NULL and 3, 2 between 1 AND null" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case879" value="select 2 in (3,2,5,9,5,1),"monty" in ("david","monty","allan"), 1.2 in (1.4,1.2,1.0)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case880" value="select 5 between 0 and 10 between 0 and 1,(5 between 0 and 10) between 0 and 1" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case881" value="select 5'abcd" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case882" value="select @1, @2" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case883" value="select @``" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case884" value="select @check, @t4_bi_called, @t4_bu_called" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case885" value="select @g1 between @g1 and ST_GeomFromText('POLYGON((30 30,40 40,50 50,30 50,30 40,30 30))')" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case886" value="select @rownum := @rownum + 1 as `row`, @rank := IF(@prev_score!=a, @rownum, @rank) as `rank`, @prev_score := a as score from t1 order by score desc" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case887" value="select @test_int,@test_double,@test_string,@test_string2,@select" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case888" value="select AES_ENCRYPT(@ENCSTR, @KEYS, @IV)=AES_ENCRYPT(@ENCSTR, @KEYS, @IV1)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case889" value="select HEX(0x19c9bbcce9e0a88f5212572b0c5b9e6d0 | _binary 0x13c19e5cfdf03b19518cbe3d65faf10d2), HEX(0x19c9bbcce9e0a88f5212572b0c5b9e6d0 ^ _binary 0x13c19e5cfdf03b19518cbe3d65faf10d2), HEX(0x19c9bbcce9e0a88f5212572b0c5b9e6d0 & _binary 0x13c19e5cfdf03b19518cbe3d65faf10d2), HEX(~ _binary 0x19c9bbcce9e0a88f5212572b0c5b9e6d0), HEX(~ _binary 0x13c19e5cfdf03b19518cbe3d65faf10d2)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case890" value="select MYSQLTEST.T1.* from MYSQLTEST.T1" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case891" value="select MYSQLTEST.T1.* from T1" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case892" value="select MYSQLTEST.t1.* from MYSQLTEST.t1" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case893" value="select MYSQLTEST.t1.* from MYSQLTEST.t1" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case894" value="select NOT NOT TRUE, NOT NOT NOT FALSE" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case895" value="select POSITION(_latin1'B' COLLATE latin1_bin IN _latin1'abcd')" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case896" value="select POSITION(_latin1'B' COLLATE latin1_general_ci IN _latin1'abcd' COLLATE latin1_bin)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case897" value="select POSITION(_latin1'B' IN _latin1'abcd' COLLATE latin1_bin)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case898" value="select ROW(1,2,3) IN(row(a,b,c), row(1,2,3)) from t1" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case899" value="select ROW(a,2,3) IN(row(1,b,c), row(2,3,1)) from t1" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case900" value="select ROW(a,b,c) IN(row(1,2,3), row(3,2,1)) from t1" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case901" value="select ROW(c,2,3) IN(row(1,b,a), row(2,3,1)) from t1" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case902" value="select S.ID as xID, S.ID1 as xID1, repeat('*',count(distinct yS.ID)) as Level from t1 as S left join t1 as yS on S.ID1 between yS.ID1 and yS.ID2 group by xID order by xID1" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case903" value="select UpdateXML('<a>a</a>',repeat('a b ',1000),'')" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case904" value="select _latin1'B' COLLATE latin1_general_ci in (_latin1'a' COLLATE latin1_bin,_latin1'b')" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case905" value="select _latin1'B' COLLATE latin1_general_ci in (_latin1'a',_latin1'b' COLLATE latin1_bin)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case906" value="select _latin1'B' between _latin1'a' and _latin1'c'" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case907" value="select _latin1'B' between _latin1'a' and _latin1'c' collate latin1_bin" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case908" value="select _latin1'B' between _latin1'a' and _latin2'b'" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case909" value="select _latin1'B' between _latin1'a' collate latin1_bin and _latin1'c'" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case910" value="select _latin1'B' between _latin2'a' and _latin1'b'" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case911" value="select _latin1'B' collate latin1_bin between _latin1'a' and _latin1'c'" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case912" value="select _latin1'B' collate latin1_bin in (_latin1'a',_latin1'b')" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case913" value="select _latin1'B' collate latin1_general_ci between _latin1'a' collate latin1_bin and _latin1'b'" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case914" value="select _latin1'B' in (_latin1'a' collate latin1_bin,_latin1'b')" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case915" value="select _latin1'B' in (_latin1'a',_latin1'b' collate latin1_bin)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case916" value="select _latin1'B' in (_latin1'a',_latin1'b')" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case917" value="select _latin1'B' in (_latin1'a',_latin2'b')" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case918" value="select _latin1'B' in (_latin2'a',_latin1'b')" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case919" value="select _latin2'B' between _latin1'a' and _latin1'b'" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case920" value="select _latin2'B' in (_latin1'a',_latin1'b')" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case921" value="select _rowid,t1._rowid,skey,sval from t1" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case922" value="select _rowid,t1._rowid,skey,sval from t1" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case923" value="select a, not(not(a)) from t1" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case924" value="select a.id, b.category as catid, b.state as stateid, b.county as countyid from t1 a, t2 b ignore index (primary) where (a.token ='a71250b7ed780f6ef3185bfffe027983') and (a.count = b.id)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case925" value="select abs(3 "three")" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case926" value="select abs(3 AS "three")" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case927" value="select abs(3 AS three)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case928" value="select abs(3 three)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case929" value="select abs(myfunc_double(3 AS three))" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case930" value="select abs(myfunc_double(3) AS wrong)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case931" value="select atan(10 "p1")" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case932" value="select atan(10 "p1", 20)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case933" value="select atan(10 AS "p1")" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case934" value="select atan(10 AS "p1", 20)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case935" value="select atan(10 AS p1)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case936" value="select atan(10 AS p1, 20 AS p2)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case937" value="select atan(10 AS p1, 20)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case938" value="select atan(10 p1)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case939" value="select atan(10 p1, 20)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case940" value="select atan(10, 20 "p2")" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case941" value="select atan(10, 20 AS "p2")" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case942" value="select atan(10, 20 AS p2)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case943" value="select atan(10, 20 p2)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case944" value="select b from v1 vq1, lateral (select count(*) from v1 vq2 having vq1.b = 3) dt" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case945" value="select c cb20 from t1 where c=repeat('b',20)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case946" value="select c, v2.table_name from v1 right join information_schema.TABLES v2 on (v1.c=v2.table_name) where v1.c rlike "t[1-5]{1}$" order by c" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case947" value="select c,table_name from v1 inner join information_schema.TABLES v2 on (v1.c=v2.table_name) where v1.c rlike "t[1-5]{1}$" order by c" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case948" value="select c,table_name from v1 left join information_schema.TABLES v2 on (v1.c=v2.table_name) where v1.c rlike "t[1-5]{1}$" order by c" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case949" value="select case 'str' when 'STR' then 'str' when null then 'null' end as c01, case 'str' when null then 'null' when 'STR' then 'str' end as c02, field(null, 'str1', 'str2') as c03, field('str1','STR1', null) as c04, field('str1', null, 'STR1') as c05, 'string' in ('STRING', [...]
+ <sql-case id="select_by_mysql_source_test_case950" value="select case 1/0 when "a" then "true" END" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case951" value="select case 1/0 when "a" then "true" else "false" END" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case952" value="select collation(insert(_latin2'abcd',2,3,_latin2'ef')), coercibility(insert(_latin2'abcd',2,3,_latin2'ef'))" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case953" value="select collation(repeat(_latin2'a',10)), coercibility(repeat(_latin2'a',10))" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case954" value="select collation(trim(BOTH _latin2' ' FROM _latin2'a')), coercibility(trim(BOTH _latin2'a' FROM _latin2'a'))" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case955" value="select collation(trim(LEADING _latin2' ' FROM _latin2'a')), coercibility(trim(LEADING _latin2'a' FROM _latin2'a'))" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case956" value="select collation(trim(TRAILING _latin2' ' FROM _latin2'a')), coercibility(trim(TRAILING _latin2'a' FROM _latin2'a'))" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case957" value="select concat("a",NULL),replace(NULL,"a","b"),replace("string","i",NULL),replace("string",NULL,"i"),insert("abc",1,1,NULL),left(NULL,1)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case958" value="select concat(c1, repeat('xx', 250)) as cc from t2 group by cc order by 1" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case959" value="select conv(255 "p1", 10, 16)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case960" value="select conv(255 AS "p1", 10, 16)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case961" value="select conv(255 AS p1, 10 AS p2, 16 AS p3)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case962" value="select conv(255 AS p1, 10, 16)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case963" value="select conv(255 p1, 10, 16)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case964" value="select conv(255, 10 "p2", 16)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case965" value="select conv(255, 10 AS "p2", 16)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case966" value="select conv(255, 10 AS p2, 16)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case967" value="select conv(255, 10 p2, 16)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case968" value="select conv(255, 10, 16 "p3")" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case969" value="select conv(255, 10, 16 AS "p3")" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case970" value="select conv(255, 10, 16 AS p3)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case971" value="select conv(255, 10, 16 p3)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case972" value="select count(distinct concat(c1, repeat('xx', 250))) as cc from t2 order by 1" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case973" value="select db1_secret.db()" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case974" value="select db1_secret.db()" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case975" value="select db1_secret.db()" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case976" value="select db1_secret.db()" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case977" value="select default(str), default(strnull), default(intg), default(rel) from t1" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case978" value="select distinct concat(c1, repeat('xx', 250)) as cc from t2 order by 1" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case979" value="select domain from t1 where concat('@', trim(leading '.' from concat('.', domain))) = '@hello.de'" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case980" value="select domain from t1 where concat('@', trim(leading '.' from concat('.', domain))) = '@test.de'" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case981" value="select extract(DAY_HOUR FROM "1999-01-02 10:11:12")" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case982" value="select extract(DAY_MICROSECOND FROM "1999-01-02 10:11:12.000123")" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case983" value="select extract(DAY_MINUTE FROM "02 10:11:12")" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case984" value="select extract(DAY_SECOND FROM "225 10:11:12")" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case985" value="select extract(HOUR_MICROSECOND FROM "1999-01-02 10:11:12.000123")" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case986" value="select extract(HOUR_MINUTE FROM "10:11:12")" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case987" value="select extract(HOUR_SECOND FROM "10:11:12")" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case988" value="select extract(MINUTE_MICROSECOND FROM "1999-01-02 10:11:12.000123")" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case989" value="select extract(MINUTE_SECOND FROM "10:11:12")" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case990" value="select extract(SECOND_MICROSECOND FROM "1999-01-02 10:11:12.000123")" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case991" value="select extract(YEAR_MONTH FROM "1999-01-02")" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case992" value="select format(pi(), @dec)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case993" value="select group_concat('3') over ()" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case994" value="select hex(weight_string('a' as char(-1)))" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case995" value="select i from t1 where a=repeat(_utf8 'a',200)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case996" value="select i from t1 where a=repeat(_utf8 0xD0B1,200)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case997" value="select i from t1 where b=repeat(_utf8 'b',310)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case998" value="select id, not (a=1 is false) from t1" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case999" value="select id, not (a=1 is true) from t1" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case1000" value="select id, not (a=1 is unknown) from t1" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case1001" value="select insert("aa",100,1,"b"),insert("aa",1,3,"b"),left("aa",-1),substring("a",1,2)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case1002" value="select insert('hello', -1, -1, 'hi')" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case1003" value="select insert('hello', -1, 1, 'hi')" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case1004" value="select insert('hello', -18446744073709551615, -18446744073709551615, 'hi')" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case1005" value="select insert('hello', -18446744073709551615, 1, 'hi')" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case1006" value="select insert('hello', -18446744073709551616, -18446744073709551616, 'hi')" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case1007" value="select insert('hello', -18446744073709551616, 1, 'hi')" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case1008" value="select insert('hello', -18446744073709551617, -18446744073709551617, 'hi')" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case1009" value="select insert('hello', -18446744073709551617, 1, 'hi')" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case1010" value="select insert('hello', -4294967295, -4294967295, 'hi')" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case1011" value="select insert('hello', -4294967295, 1, 'hi')" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case1012" value="select insert('hello', -4294967296, -4294967296, 'hi')" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case1013" value="select insert('hello', -4294967296, 1, 'hi')" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case1014" value="select insert('hello', -4294967297, -4294967297, 'hi')" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case1015" value="select insert('hello', -4294967297, 1, 'hi')" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case1016" value="select insert('hello', 1, -1, 'hi')" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case1017" value="select insert('hello', 1, -18446744073709551615, 'hi')" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case1018" value="select insert('hello', 1, -18446744073709551616, 'hi')" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case1019" value="select insert('hello', 1, -18446744073709551617, 'hi')" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case1020" value="select insert('hello', 1, -4294967295, 'hi')" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case1021" value="select insert('hello', 1, -4294967296, 'hi')" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case1022" value="select insert('hello', 1, -4294967297, 'hi')" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case1023" value="select insert('hello', 1, 18446744073709551615, 'hi')" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case1024" value="select insert('hello', 1, 18446744073709551616, 'hi')" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case1025" value="select insert('hello', 1, 18446744073709551617, 'hi')" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case1026" value="select insert('hello', 1, 4294967295, 'hi')" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case1027" value="select insert('hello', 1, 4294967296, 'hi')" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case1028" value="select insert('hello', 1, 4294967297, 'hi')" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case1029" value="select insert('hello', 18446744073709551615, 1, 'hi')" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case1030" value="select insert('hello', 18446744073709551615, 18446744073709551615, 'hi')" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case1031" value="select insert('hello', 18446744073709551616, 1, 'hi')" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case1032" value="select insert('hello', 18446744073709551616, 18446744073709551616, 'hi')" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case1033" value="select insert('hello', 18446744073709551617, 1, 'hi')" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case1034" value="select insert('hello', 18446744073709551617, 18446744073709551617, 'hi')" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case1035" value="select insert('hello', 4294967295, 1, 'hi')" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case1036" value="select insert('hello', 4294967295, 4294967295, 'hi')" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case1037" value="select insert('hello', 4294967296, 1, 'hi')" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case1038" value="select insert('hello', 4294967296, 4294967296, 'hi')" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case1039" value="select insert('hello', 4294967297, 1, 'hi')" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case1040" value="select insert('hello', 4294967297, 4294967297, 'hi')" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case1041" value="select insert('txs',2,1,'hi'),insert('is ',4,0,'a'),insert('txxxxt',2,4,'es')" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case1042" value="select insert('txs',2,null,'hi'),insert('txs',2,1,null)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case1043" value="select insert('txs',null,null,'hi'),insert(null,null,null,null)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case1044" value="select insert(_utf16 0x006100620063,1,2,_utf16 0x006400650066)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case1045" value="select insert(_utf16 0x006100620063,10,2,_utf16 0x006400650066)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case1046" value="select insert(_utf32 0x000000610000006200000063,1,2,_utf32 0x000000640000006500000066)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case1047" value="select insert(_utf32 0x000000610000006200000063,10,2,_utf32 0x000000640000006500000066)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case1048" value="select insert(null,2,1,'hi'),insert('txs',null,1,'hi')" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case1049" value="select instr("foobar" "p1", "bar")" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case1050" value="select instr("foobar" AS "p1", "bar")" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case1051" value="select instr("foobar" AS p1, "bar" AS p2)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case1052" value="select instr("foobar" AS p1, "bar")" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case1053" value="select instr("foobar" p1, "bar")" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case1054" value="select instr("foobar", "bar" "p2")" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case1055" value="select instr("foobar", "bar" AS "p2")" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case1056" value="select instr("foobar", "bar" AS p2)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case1057" value="select instr("foobar", "bar" p2)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case1058" value="select instr("foobar", @bar "p2")" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case1059" value="select instr(@foobar "p1", "bar")" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case1060" value="select length(repeat("",1)) as a" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case1061" value="select length(repeat("",1024*1024*1024)) as a" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case1062" value="select length(repeat("1",1024*1024)) as a" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case1063" value="select length(repeat("1",1024*1024*1024)) as a" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case1064" value="select length(repeat("a",1000000)),length(concat(repeat("a",32000),repeat("a",32000),repeat("a",32000))),length(replace("aaaaa","a",concat(repeat("a",32000)))),length(insert(repeat("a",48000),1,1000,repeat("a",48000)))" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case1065" value="select length(repeat("a",100000000)),length(repeat("a",1000*64))" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case1066" value="select length(repeat("a",65500)),length(concat(repeat("a",32000),repeat("a",32000))),length(replace("aaaaa","a",concat(repeat("a",10000)))),length(insert(repeat("a",40000),1,30000,repeat("b",50000)))" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case1067" value="select length(repeat('a',2000))" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case1068" value="select length(v) from t1 where v=repeat('a',65530)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case1069" value="select mail_id, if(folder.f_description!='', folder.f_description, folder.f_name) as folder_name, date, address_id, phrase, address, subject from folder, (select mail.mail_id as mail_id, date_format(mail.h_date, '%b %e, %Y %h:%i') as date, mail.folder_id, sender.address_id as address_id, sender.phrase as phrase, sender.address as address, mail.h_subject as subject from mail left join mxa as m [...]
+ <sql-case id="select_by_mysql_source_test_case1070" value="select myfunc_double(3 AS three)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case1071" value="select myfunc_double(abs(3 AS wrong))" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case1072" value="select myfunc_double(abs(3) AS named_param)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case1073" value="select mysqltest.t1.* from MYSQLTEST.t1" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case1074" value="select mysqltest1.bug18444(i) from t3" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case1075" value="select mysqltest_db.f1()" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case1076" value="select mysqltest_db.f_does_not_exist()" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case1077" value="select position("0" in "baaa" in (1)),position("0" in "1" in (1,2,3)),position("sql" in ("mysql"))" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case1078" value="select position(("1" in (1,2,3)) in "01")" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case1079" value="select position(binary 'll' in 'hello'),position('a' in binary 'hello')" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case1080" value="select repeat("a",0),repeat("ab",5+5),repeat("ab",-1),reverse(NULL)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case1081" value="select repeat('a', cast(2 as unsigned int))" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case1082" value="select repeat('a',2000)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case1083" value="select repeat('hello', -1)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case1084" value="select repeat('hello', -18446744073709551615)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case1085" value="select repeat('hello', -18446744073709551616)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case1086" value="select repeat('hello', -18446744073709551617)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case1087" value="select repeat('hello', -4294967295)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case1088" value="select repeat('hello', -4294967296)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case1089" value="select repeat('hello', -4294967297)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case1090" value="select repeat('hello', 18446744073709551615)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case1091" value="select repeat('hello', 18446744073709551616)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case1092" value="select repeat('hello', 18446744073709551617)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case1093" value="select repeat('hello', 4294967295)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case1094" value="select repeat('hello', 4294967296)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case1095" value="select repeat('hello', 4294967297)" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case1096" value="select repeat('monty',5),concat('*',space(5),'*')" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case1097" value="select row('a',0,3) IN (row(3,2,3), row('a','0','3'), row(1,3,3))" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case1098" value="select row('a',0,3) IN (row(3,2,3), row('a','a','3'), row(1,3,3))" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case1099" value="select row('a',1.5,3) IN (row(1,2,3), row('a',1.5,3), row('a','a','a'))" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case1100" value="select row('a',1.5,3) IN (row(3,NULL,3), row('a',1.5,3), row(1,3,3))" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case1101" value="select row('b',1.5,3) IN (row('b',NULL,3), row('a',1.5,3), row(1,3,3))" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case1102" value="select row('b',1.5,3) IN (row('b',NULL,4), row('a',1.5,3), row(1,3,3))" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case1103" value="select row('b',1.5,3) IN (row(3,NULL,3), row('a',1.5,3), row(1,3,3))" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case1104" value="select row(1,2,3) IN (row(3,NULL,3), row(1,2,3), row(1,3,3))" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case1105" value="select row(1,2,row(3,4)) IN (row(3,2,row(3,4)), row(1,2,4))" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case1106" value="select row(1,2,row(3,4)) IN (row(3,2,row(3,4)), row(1,2,row(3,NULL)))" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case1107" value="select row(1,2,row(3,null)) IN (row(3,2,row(3,4)), row(1,2,row(3,5)))" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case1108" value="select row(1,2,row(3,null)) IN (row(3,2,row(3,4)), row(1,2,row(4,5)))" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case1109" value="select row(10,2,3) IN (row(3,2,3), row(1,2,3), row(1,3,3))" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case1110" value="select row(10,2,3) IN (row(3,NULL,3), row(1,2,3), row(1,3,3))" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case1111" value="select straight_join * from t1, lateral (select t1.a) as dt, t2" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case1112" value="select straight_join * from t1, t2, lateral (select t1.a) as dt" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case1113" value="select straight_join * from t1,t2 force index (primary) where t1.a=t2.a" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case1114" value="select straight_join * from t1,t2 force index (primary) where t1.a=t2.a" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case1115" value="select straight_join * from t2, t1, lateral (select t1.a) as dt" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case1116" value="select strcmp(concat(utc_date(),' ',utc_time()),utc_timestamp())=0" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case1117" value="select strcmp(date_format(date_sub(localtimestamp(), interval 3 hour),"%T"), utc_time())=0" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case1118" value="select strcmp(date_format(date_sub(localtimestamp(), interval 3 hour),"%Y-%m-%d"), utc_date())=0" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case1119" value="select strcmp(date_format(utc_timestamp(),"%T"), utc_time())=0" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case1120" value="select strcmp(date_format(utc_timestamp(),"%Y-%m-%d"), utc_date())=0" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case1121" value="select sum(all a),count(all a),avg(all a),std(all a),variance(all a),bit_or(all a),bit_and(all a),min(all a),max(all a),min(all c),max(all c) from t1" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case1122" value="select sum(col1) as co12 from t1 group by col2 having col2 10" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case1123" value="select t1.*, dt.c from t t1 cross join lateral (select count(*) as c from t t2 left join t t3 on t3.a>t2.a-t1.a) as dt" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case1124" value="select t1.*, dt.c from t t1 join lateral (select count(*) as c from t t2 left join t t3 on t3.a>t2.a-t1.a) as dt on true" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case1125" value="select t1.*, dt.c from t t1, lateral (select count(*) as c from t t2 left join t t3 on t3.a>t2.a-t1.a) as dt" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case1126" value="select t1.a as str, length(t1.a) as str_length, t2.a as pos, t2.a + 10 as length, insert(t1.a, t2.a, t2.a + 10, '1234567') as 'insert' from t1, t2" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case1127" value="select t1.a, dt.a from t1, lateral (select t1.a+t2.a as a from t2) dt" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case1128" value="select t1.a, dt.a from t1, lateral (select t2.a as a from t2 having t1.a) dt" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case1129" value="select t1.a, f from t1, lateral (select max(t1.a) as f) as dt" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case1130" value="select table_name from information_schema.TABLES where table_schema = "mysqltest" and table_name rlike "t[1-5]{1}$" order by table_name" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case1131" value="select test.a(), test.st_x(), test.st_y()" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case1132" value="select test.current_user(), test.current_user ()" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case1133" value="select test.current_user(), test.current_user ()" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case1134" value="select test.database(), test.database ()" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case1135" value="select test.database(), test.database ()" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case1136" value="select test.md5("aaa"), test.md5 ("aaa")" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case1137" value="select test.md5("aaa"), test.md5 ("aaa")" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case1138" value="select test.metaphon("Hello")" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case1139" value="select test.pi(), test.pi ()" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case1140" value="select test.pi(), test.pi ()" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case1141" value="select trim('xyz' from null) as "must_be_null"" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case1142" value="select trim(leading NULL from 'kate') as "must_be_null"" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case1143" value="select trim(null from 'kate') as "must_be_null"" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case1144" value="select trim(trailing NULL from 'xyz') as "must_be_null"" db-types="MySQL"/>
+ <sql-case id="select_by_mysql_source_test_case1145" value="select vq1.b,dt.b from v1 vq1, lateral (select vq1.b) dt" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case1" value="INSERT /*+ SET_VAR(time_zone = 'UTC') */ t1 VALUES (TIMEDIFF(NOW(), UTC_TIMESTAMP))" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case2" value="INSERT IGNORE INTO t1 SELECT 101, REPEAT('ab', @max_allowed_packet)" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case3" value="INSERT IGNORE INTO t1 SELECT REPEAT('a',11)" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case4" value="INSERT IGNORE INTO t3 VALUES( REPEAT( 'a', 65536 ), 3 )" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case5" value="INSERT INTO B VALUES ('at', repeat('a',1000), 'the', -1622540288, 'as', repeat('a',1000), 'want', 1810890752, NULL, 'v', 'just')" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case6" value="INSERT INTO D VALUES (39,40,4,repeat(' X', 42)), (43,56,4,repeat(' X', 42)), (47,12,4,repeat(' X', 42)), (71,28,4,repeat(' X', 42)), (76,54,4,repeat(' X', 42)), (83,45,4,repeat(' X', 42)), (105,53,12,NULL)" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case7" value="INSERT INTO N VALUES (1,3,repeat('a',1000)),(0,4,'tell'),(7,6,'o'),(6,7,'g'),(8,8,'can'), (9,15,repeat('a',1020)),(4,16,repeat('a',1020)),(6,18,'his'),(NULL,19,'going'), (7,22,'mean'),(8,23,'here')" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case8" value="INSERT INTO `proc` VALUES ('test','downgrade_alter_proc','PROCEDURE', 'downgrade_alter_proc', 'SQL','CONTAINS_SQL','NO','INVOKER','','', 'BEGIN\n SELECT c1, English, French FROM t1 ' 'JOIN t2 ON t1.c3 = t2.col2;\n END', 'root@localhost','1988-04-25 20:45:00', '1988-04-25 20:45: [...]
+ <sql-case id="insert_by_mysql_source_test_case9" value="INSERT INTO `t``\""e` VALUES (0), (2), (6), (10), (14), (18), (22)" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case10" value="INSERT INTO aes_ecb (a) VALUES ('a'), ('Жоро'), (REPEAT('a', 10))" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case11" value="INSERT INTO all_types VALUES ( NULL, # BOOLEAN NULL, # BIT NULL, # TINYINT NULL, # SMALLINT NULL, # MEDIUMINT NULL, # INTEGER NULL, # BIGINT NULL, # TINYINT_UNSIGNED NULL, # SMALLINT_UNSIGNED NULL, # MEDIUMINT_UNSIGNED NULL, # INTEGER_UNSIGNED NULL, # BIGINT_UNSIGNED NULL, # FLOAT NULL, # DOUBLE NULL, # DECIMAL(65, 2) NULL, # DATE NULL, # TIME NULL, # YEAR [...]
+ <sql-case id="insert_by_mysql_source_test_case12" value="INSERT INTO at ( _bit, _tin, _boo, _sms, _smu, _mes, _meu, _ins, _inu, _bis, _biu, _dec, _flo, _dou, _yea, _jsn, _chr, _vch, _bin, _vbn, _tbl, _ttx, _blb, _txt, _mbb, _mtx, _lbb, _ltx, _pnt, _enu, _set ) VALUES ( 64, 64, true, 64, 64, 64, 64, 64, 64, 64, 64, 64, 64, 64, 2005, cast('{"a": 3}' as json), "abcdefghijkl", "abcdefghijkl", x'CAFEBABE00000000000000000000000000000000000000000 [...]
+ <sql-case id="insert_by_mysql_source_test_case13" value="INSERT INTO dd_check_table(t) SELECT CONCAT(id, '-', name, '-', IFNULL(options, 'NULL'), '-', IFNULL(INSERT(se_private_data, INSTR(se_private_data, 'server_version'), 20, 'server_version=x'), 'NULL'), '-', comment, '-', engine) FROM mysql.tablespaces WHERE name = 'mysql'" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case14" value="INSERT INTO t (c) VALUES (REPEAT('1',65537))" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case15" value="INSERT INTO t (c) VALUES (REPEAT('2',65536))" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case16" value="INSERT INTO t (c) VALUES (REPEAT('3',65535))" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case17" value="INSERT INTO t SELECT * FROM (VALUES ROW(1, 11), ROW(2, 20)) AS n(a, b) ON DUPLICATE KEY UPDATE b= n.b" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case18" value="INSERT INTO t VALUES (REPEAT('a', 128)), (REPEAT('b', 128)), (REPEAT('c', 128)), (REPEAT('d', 128))" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case19" value="INSERT INTO t VALUES (REPEAT('a', 128)), (REPEAT('b', 128)), (REPEAT('c', 128)), (REPEAT('d', 128))" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case20" value="INSERT INTO t VALUES ROW(DEFAULT(a) + 1, 30)" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case21" value="INSERT INTO t VALUES ROW(DEFAULT(a), 20)" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case22" value="INSERT INTO t VALUES(1, REPEAT('2', 255)), (1, REPEAT('1', 255))" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case23" value="INSERT INTO t VALUES(1, REPEAT('2', 257)), (1, REPEAT('1', 257))" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case24" value="INSERT INTO t VALUES(1, REPEAT('2', 32750), REPEAT('1', 32750))" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case25" value="INSERT INTO t VALUES(1, REPEAT('abs',1000))" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case26" value="INSERT INTO t VALUES(2, REPEAT('ajs',1000))" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case27" value="INSERT INTO t VALUES(3, REPEAT('ajj',1000))" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case28" value="INSERT INTO t VALUES(4, REPEAT('jjs',1000))" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case29" value="INSERT INTO t VALUES(REPEAT(x'0a',1000))" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case30" value="INSERT INTO t0 SET a=1, b=20 AS n ON DUPLICATE KEY UPDATE b= n.b" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case31" value="INSERT INTO t1 (data) VALUES (repeat('a',1*1024*1024))" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case32" value="INSERT INTO t1 (data) VALUES (repeat('b',16*1024*1024-1024))" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case33" value="INSERT INTO t1 (Ñ, N) VALUES (1, 2)" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case34" value="INSERT INTO t1 SELECT 101, REPEAT('ab', @max_allowed_packet)" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case35" value="INSERT INTO t1 SELECT 102, REPEAT('ab', @max_allowed_packet)" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case36" value="INSERT INTO t1 SELECT CONCAT(REPEAT('1', 1024*1024 - 27), "\'\r dummydb dummyhost")" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case37" value="INSERT INTO t1 SELECT REPEAT('1', 2*1024*1024)" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case38" value="INSERT INTO t1 SELECT ST_GeomFromText(CONCAT('GEOMETRYCOLLECTION(POINT(1 1)', REPEAT(',POINT(1 1)', 100), ')'))" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case39" value="INSERT INTO t1 SELECT ST_GeomFromText(CONCAT('GEOMETRYCOLLECTION(POINT(1 1)', REPEAT(',POINT(1 1)', 100), ')')) FROM t1" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case40" value="INSERT INTO t1 SELECT ST_GeomFromText(CONCAT('GEOMETRYCOLLECTION(POINT(1 1)', REPEAT(',POINT(1 1)', 100), ')')) FROM t1" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case41" value="INSERT INTO t1 SET b='11', a=0 AS n ON DUPLICATE KEY UPDATE b= n.a, a= n.b" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case42" value="INSERT INTO t1 SET b='11', a=0 AS n ON DUPLICATE KEY UPDATE b= n.a, a= n.b" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case43" value="INSERT INTO t1 SET b=repeat('a',400)" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case44" value="INSERT INTO t1 SET b=repeat('a',600)" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case45" value="INSERT INTO t1 SET c1=11, c2=REPEAT('q',509)" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case46" value="INSERT INTO t1 SET j = 1, i = DEFAULT(i)" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case47" value="INSERT INTO t1 SET j = 1, i = DEFAULT(i)" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case48" value="INSERT INTO t1 VALUES ( 1, REPEAT('x', 1048576) )" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case49" value="INSERT INTO t1 VALUES ( 2, REPEAT('-', 1048576) )" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case50" value="INSERT INTO t1 VALUES ( UNHEX('0000000001030000000100000002000000000000000000000000000000000000000000' '00000000F03F0000000000000000'))" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case51" value="INSERT INTO t1 VALUES ( UNHEX('0000000001030000000100000003000000000000000000000000000000000000000000' '00000000F03F000000000000000000000000000000000000000000000000'))" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case52" value="INSERT INTO t1 VALUES ( UNHEX('0000000001040000000100000001020000000200000000000000000000000000000000' '000000000000000000F03F000000000000F03F'))" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case53" value="INSERT INTO t1 VALUES ( UNHEX('0000000001070000000100000001040000000100000001020000000200000000000000' '000000000000000000000000000000000000F03F000000000000F03F'))" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case54" value="INSERT INTO t1 VALUES ( UNHEX('0000000001070000000100000001050000000100000001010000000000000000000000' '0000000000000000'))" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case55" value="INSERT INTO t1 VALUES ( UNHEX('0000000001070000000100000001060000000100000001010000000000000000000000' '0000000000000000'))" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case56" value="INSERT INTO t1 VALUES ( UNHEX('00000000010F0000000100000001030000000100000004000000000000000000000000' '00000000000000000000000000F03F0000000000000000000000000000F03F00000000' '0000F03F00000000000000000000000000000000'))" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case57" value="INSERT INTO t1 VALUES ( UNHEX('0000000001100000000100000001030000000100000004000000000000000000000000' '00000000000000000000000000F03F0000000000000000000000000000F03F00000000' '0000F03F00000000000000000000000000000000'))" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case58" value="INSERT INTO t1 VALUES ( UNHEX('0000000001110000000100000004000000000000000000000000000000000000000000' '00000000F03F0000000000000000000000000000F03F000000000000F03F0000000000' '0000000000000000000000'))" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case59" value="INSERT INTO t1 VALUES ( UNHEX('0000000001B90B00000000000000000000000000000000000000000000000000000000' '0000000000000000000000000000'))" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case60" value="INSERT INTO t1 VALUES ( UNHEX('0000000001BA0B00000200000000000000000000000000000000000000000000000000' '00000000000000000000000000000000F03F000000000000F03F000000000000000000' '00000000000000'))" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case61" value="INSERT INTO t1 VALUES ( UNHEX('0000000001BB0B00000100000004000000000000000000000000000000000000000000' '0000000000000000000000000000000000000000F03F00000000000000000000000000' '0000000000000000000000000000000000F03F000000000000F03F0000000000000000' '0000000000000000000000000000000000000000000000000000000000000000000000' '0000000000'))" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case62" value="INSERT INTO t1 VALUES ( UNHEX('0000000001BC0B00000100000001B90B00000000000000000000000000000000000000' '0000000000000000000000000000000000000000000000'))" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case63" value="INSERT INTO t1 VALUES ( UNHEX('0000000001BD0B00000100000001BA0B00000200000000000000000000000000000000' '00000000000000000000000000000000000000000000000000F03F000000000000F03F' '00000000000000000000000000000000'))" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case64" value="INSERT INTO t1 VALUES ( UNHEX('0000000001BE0B00000100000001BB0B00000100000004000000000000000000000000' '0000000000000000000000000000000000000000000000000000000000F03F00000000' '0000000000000000000000000000000000000000000000000000F03F000000000000F0' '3F00000000000000000000000000000000000000000000000000000000000000000000' '0000000000000000000000000000'))" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case65" value="INSERT INTO t1 VALUES ( UNHEX('0000000001BF0B00000100000001B90B00000000000000000000000000000000000000' '0000000000000000000000000000000000000000000000'))" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case66" value="INSERT INTO t1 VALUES ( UNHEX('0000000001C70B00000100000001BB0B00000100000004000000000000000000000000' '0000000000000000000000000000000000000000000000000000000000F03F00000000' '0000000000000000000000000000000000000000000000000000F03F000000000000F0' '3F00000000000000000000000000000000000000000000000000000000000000000000' '0000000000000000000000000000'))" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case67" value="INSERT INTO t1 VALUES ( UNHEX('0000000001C80B00000100000001BB0B00000100000004000000000000000000000000' '0000000000000000000000000000000000000000000000000000000000F03F00000000' '0000000000000000000000000000000000000000000000000000F03F000000000000F0' '3F00000000000000000000000000000000000000000000000000000000000000000000' '0000000000000000000000000000'))" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case68" value="INSERT INTO t1 VALUES ( UNHEX('0000000001C90B00000100000001EB0300000100000004000000000000000000000000' '000000000000000000000000000000000000000000F03F000000000000000000000000' '00000000000000000000F03F000000000000F03F000000000000000000000000000000' '0000000000000000000000000000000000'))" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case69" value="INSERT INTO t1 VALUES ( UNHEX('0000000001D20700000200000000000000000000000000000000000000000000000000' '0000000000000000F03F000000000000F03F0000000000000000'))" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case70" value="INSERT INTO t1 VALUES ( UNHEX('0000000001D30700000100000004000000000000000000000000000000000000000000' '000000000000000000000000F03F000000000000000000000000000000000000000000' '00F03F000000000000F03F000000000000000000000000000000000000000000000000' '0000000000000000'))" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case71" value="INSERT INTO t1 VALUES ( UNHEX('0000000001D40700000100000001E90300000000000000000000000000000000000000' '00000000000000'))" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case72" value="INSERT INTO t1 VALUES ( UNHEX('0000000001D5070000010000000000000001EA03000002000000000000000000000000' '000000000000000000000000000000000000000000F03F000000000000F03F00000000' '00000000'))" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case73" value="INSERT INTO t1 VALUES ( UNHEX('0000000001D60700000100000001EB0300000100000004000000000000000000000000' '000000000000000000000000000000000000000000F03F000000000000000000000000' '00000000000000000000F03F000000000000F03F000000000000000000000000000000' '0000000000000000000000000000000000'))" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case74" value="INSERT INTO t1 VALUES ( UNHEX('0000000001D70700000100000001E90300000000000000000000000000000000000000' '00000000000000'))" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case75" value="INSERT INTO t1 VALUES ( UNHEX('0000000001DF0700000100000001EB0300000100000004000000000000000000000000' '000000000000000000000000000000000000000000F03F000000000000000000000000' '00000000000000000000F03F000000000000F03F000000000000000000000000000000' '0000000000000000000000000000000000'))" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case76" value="INSERT INTO t1 VALUES ( UNHEX('0000000001E00700000100000001EB0300000100000004000000000000000000000000' '000000000000000000000000000000000000000000F03F000000000000000000000000' '00000000000000000000F03F000000000000F03F000000000000000000000000000000' '0000000000000000000000000000000000'))" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case77" value="INSERT INTO t1 VALUES ( UNHEX('0000000001E10700000100000001EB0300000100000004000000000000000000000000' '000000000000000000000000000000000000000000F03F000000000000000000000000' '00000000000000000000F03F000000000000F03F000000000000000000000000000000' '0000000000000000000000000000000000'))" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case78" value="INSERT INTO t1 VALUES ( UNHEX('0000000001EA0300000200000000000000000000000000000000000000000000000000' '0000000000000000F03F000000000000F03F0000000000000000'))" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case79" value="INSERT INTO t1 VALUES ( UNHEX('0000000001EB0300000100000004000000000000000000000000000000000000000000' '000000000000000000000000F03F000000000000000000000000000000000000000000' '00F03F000000000000F03F000000000000000000000000000000000000000000000000' '0000000000000000'))" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case80" value="INSERT INTO t1 VALUES ( UNHEX('0000000001EC0300000100000001E90300000000000000000000000000000000000000' '00000000000000'))" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case81" value="INSERT INTO t1 VALUES ( UNHEX('0000000001ED030000010000000000000001EA03000002000000000000000000000000' '000000000000000000000000000000000000000000F03F000000000000F03F00000000' '00000000'))" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case82" value="INSERT INTO t1 VALUES ( UNHEX('0000000001EE0300000100000001EB0300000100000004000000000000000000000000' '000000000000000000000000000000000000000000F03F000000000000000000000000' '00000000000000000000F03F000000000000F03F000000000000000000000000000000' '0000000000000000000000000000000000'))" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case83" value="INSERT INTO t1 VALUES ( UNHEX('0000000001EF0300000100000001E90300000000000000000000000000000000000000' '00000000000000'))" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case84" value="INSERT INTO t1 VALUES ( UNHEX('0000000001F70300000100000001EB0300000100000004000000000000000000000000' '000000000000000000000000000000000000000000F03F000000000000000000000000' '00000000000000000000F03F000000000000F03F000000000000000000000000000000' '0000000000000000000000000000000000'))" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case85" value="INSERT INTO t1 VALUES ( UNHEX('0000000001F80300000100000001EB0300000100000004000000000000000000000000' '000000000000000000000000000000000000000000F03F000000000000000000000000' '00000000000000000000F03F000000000000F03F000000000000000000000000000000' '0000000000000000000000000000000000'))" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case86" value="INSERT INTO t1 VALUES ( UNHEX('0000000001F90300000100000001EB0300000100000004000000000000000000000000' '000000000000000000000000000000000000000000F03F000000000000000000000000' '00000000000000000000F03F000000000000F03F000000000000000000000000000000' '0000000000000000000000000000000000'))" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case87" value="INSERT INTO t1 VALUES ( repeat( 'a', 10 ), 1), ( repeat( 'b', 10 ), 2)" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case88" value="INSERT INTO t1 VALUES ( repeat( 'a', 10 ), 1), ( repeat( 'b', 10 ), 2)" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case89" value="INSERT INTO t1 VALUES ( repeat( 'a', 16384 ) )" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case90" value="INSERT INTO t1 VALUES (1, REPEAT("a", 8192))" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case91" value="INSERT INTO t1 VALUES (1, REPEAT('a', 10))" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case92" value="INSERT INTO t1 VALUES (1, REPEAT('a',59), REPEAT('a',512))" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case93" value="INSERT INTO t1 VALUES (1,CONCAT(REPEAT('_', 250), "qq")), (1,CONCAT(REPEAT('_', 250), "zz")), (1,CONCAT(REPEAT('_', 250), "aa")), (1,CONCAT(REPEAT('_', 250), "ff"))" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case94" value="INSERT INTO t1 VALUES (1,REPEAT(CONCAT('A',CAST(CHAR(0) AS BINARY),'B'), 40000))" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case95" value="INSERT INTO t1 VALUES (10, REPEAT('a', CEIL(RAND(10) * 300))), (11, REPEAT('b', CEIL(RAND() * 300))), (12, REPEAT('c', CEIL(RAND() * 300))), (13, REPEAT('d', CEIL(RAND() * 300))), (14, REPEAT('e', CEIL(RAND() * 300))), (15, REPEAT('f', CEIL(RAND() * 300))), (16, REPEAT('g', CEIL(RAND() * 300))), (17, REPEAT('h', CEIL(RAND() * 300))), (18, REPEAT(&ap [...]
+ <sql-case id="insert_by_mysql_source_test_case96" value="INSERT INTO t1 VALUES (101, REPEAT('ab', @max_allowed_packet))" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case97" value="INSERT INTO t1 VALUES (101, REPEAT('ab', @max_allowed_packet))" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case98" value="INSERT INTO t1 VALUES (2, REPEAT("b", 8192))" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case99" value="INSERT INTO t1 VALUES (2, REPEAT('a',59), REPEAT('a',512))" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case100" value="INSERT INTO t1 VALUES (3, REPEAT("c", 8192))" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case101" value="INSERT INTO t1 VALUES (DEFAULT(i))" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case102" value="INSERT INTO t1 VALUES (DEFAULT(i))" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case103" value="INSERT INTO t1 VALUES (REPEAT("a",100))" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case104" value="INSERT INTO t1 VALUES (REPEAT('1',200))" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case105" value="INSERT INTO t1 VALUES (REPEAT('2', 1800))" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case106" value="INSERT INTO t1 VALUES (REPEAT('A', 50000)), (REPEAT('A', 50000))" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case107" value="INSERT INTO t1 VALUES (REPEAT('ManyMegaByteBlck', 2097152))" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case108" value="INSERT INTO t1 VALUES (REPEAT('ManyMegaByteBlck', 262144))" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case109" value="INSERT INTO t1 VALUES (REPEAT('ManyMegaByteBlck', 32768))" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case110" value="INSERT INTO t1 VALUES (REPEAT('ManyMegaByteBlck', 4194304))" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case111" value="INSERT INTO t1 VALUES (REPEAT('a', 499999), 3), (REPEAT('b', 500000), 4)" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case112" value="INSERT INTO t1 VALUES (REPEAT('a', 500000), 0), (REPEAT('b', 500000), 1), (REPEAT('c', 500000), 2)" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case113" value="INSERT INTO t1 VALUES (REPEAT('x', 4096), REPEAT('x', 4096), REPEAT('x', 4096), REPEAT('x', 4096), REPEAT('x', 4096), REPEAT('x', 4096), REPEAT('x', 4096), REPEAT('x', 4096), REPEAT('x', 4096), REPEAT('x', 4096), 1, REPEAT('x', 4096), REPEAT('x', 4096), REPEAT('x', 4096), REPEAT('x', 4096) [...]
+ <sql-case id="insert_by_mysql_source_test_case114" value="INSERT INTO t1 VALUES (REPEAT('x', 4096), REPEAT('x', 4096), REPEAT('x', 4096), REPEAT('x', 4096), REPEAT('x', 4096), REPEAT('x', 4096), REPEAT('x', 4096), REPEAT('x', 4096), REPEAT('x', 4096), REPEAT('x', 4096), 2, REPEAT('x', 4096), REPEAT('x', 4096), REPEAT('x', 4096), REPEAT('x', 4096) [...]
+ <sql-case id="insert_by_mysql_source_test_case115" value="INSERT INTO t1 VALUES (REPEAT('x', 4096), REPEAT('x', 4096), REPEAT('x', 4096), REPEAT('x', 4096), REPEAT('x', 4096), REPEAT('x', 4096), REPEAT('x', 4096), REPEAT('x', 4096), REPEAT('x', 4096), REPEAT('x', 4096), 3, REPEAT('x', 4096), REPEAT('x', 4096), REPEAT('x', 4096), REPEAT('x', 4096) [...]
+ <sql-case id="insert_by_mysql_source_test_case116" value="INSERT INTO t1 VALUES (REPEAT(0x1125,200000), REPEAT(0x1125,200000)), ('', ''), ('', '')" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case117" value="INSERT INTO t1 VALUES (REPEAT(0x1125,200000), REPEAT(0x1125,200000)), ('', ''), ('', '')" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case118" value="INSERT INTO t1 VALUES (REPEAT(_ucs2 0x201f, 10))" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case119" value="INSERT INTO t1 VALUES (REPEAT(_ucs2 0x2020, 10))" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case120" value="INSERT INTO t1 VALUES (REPEAT(_ucs2 0x2021, 10))" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case121" value="INSERT INTO t1 VALUES (b'')" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case122" value="INSERT INTO t1 VALUES (b'', b'')" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case123" value="INSERT INTO t1 VALUES (concat(repeat('MySQL',100),'1'),repeat('0',257))" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case124" value="INSERT INTO t1 VALUES (concat(repeat('MySQL',100),'2'),repeat('0',257))" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case125" value="INSERT INTO t1 VALUES (concat(repeat('MySQL',100),'3'),repeat('0',257))" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case126" value="INSERT INTO t1 VALUES (repeat('1', 1300),'one'), (repeat('1', 1300),'two')" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case127" value="INSERT INTO t1 VALUES (repeat('1', 1300),'one'), (repeat('1', 1300),'two')" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case128" value="INSERT INTO t1 VALUES('a','aa',REPEAT('a', 256)),('a','aa',REPEAT('a',256))" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case129" value="INSERT INTO t1 VALUES(1,repeat('a',1000)),(2,repeat('def',600))" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case130" value="INSERT INTO t1 VALUES(REPEAT("a",128), 'b')" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case131" value="INSERT INTO t1 VALUES(REPEAT("a",128), 'b')" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case132" value="INSERT INTO t1 VALUES(REPEAT("a",128), 'b')" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case133" value="INSERT INTO t1 VALUES(REPEAT(_utf8 x'e0ae85',43), 'b')" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case134" value="INSERT INTO t1 VALUES(REPEAT(_utf8 x'e0ae85',43), 'b')" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case135" value="INSERT INTO t1 VALUES(REPEAT(_utf8 x'e0ae85',43), 'b')" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case136" value="INSERT INTO t1 VALUES(_utf16 0x1EC2), (_utf16 0x1EC3), (_utf16 0x1EC5), (_utf16 0x1EC0), (_utf16 0x1EC7), (_Utf16 0x1EBF)" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case137" value="INSERT INTO t1 VALUES(default(a), default(b))" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case138" value="INSERT INTO t1 VALUES(default(a),default(b), default(c), default(d), default(e), default(f))" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case139" value="INSERT INTO t1 VALUES(default(col1),default(col2))" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case140" value="INSERT INTO t1 set data=repeat('a',18*1024*1024)" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case141" value="INSERT INTO t1 values(AES_ENCRYPT(@ENCSTR, @KEYS, @IV))" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case142" value="INSERT INTO t2 (a, b) VALUES (REPEAT('A', 512), REPEAT('B', 512))" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case143" value="INSERT INTO t2 (a, b) VALUES (REPEAT('a', 10000), REPEAT('b', 10000))" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case144" value="INSERT INTO t2 (a, b) VALUES (REPEAT('a', 512), REPEAT('b', 512))" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case145" value="INSERT INTO t2 VALUES ( NULL, repeat('x', 600), 3, repeat('y', 600), repeat('z', 600) )" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case146" value="INSERT INTO t2 VALUES ('MFDLE',1,'no',1358168064), ('v',2,'really',154664960), (repeat('mcrxjxxfpo',100),3,repeat('mcrxjxxfpo',100),1), ('o',4,'CEJHM',3), ('j',5,'CRDLM',174915584), ('m',6,'that\'s',7), ('YVMBM',7,'is',4), ('h',8,'as',8), ('y',9,'not [...]
+ <sql-case id="insert_by_mysql_source_test_case147" value="INSERT INTO t2 VALUES( REPEAT( 'a', 5000 ) )" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case148" value="INSERT INTO t2 VALUES( REPEAT( 'a', 5000 ) )" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case149" value="INSERT INTO t2 VALUES( REPEAT( 'b', 5000 ) )" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case150" value="INSERT INTO t3 VALUES( REPEAT( 'a', 65534 ), 1 )" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case151" value="INSERT INTO t3 VALUES( REPEAT( 'a', 65535 ), 2 )" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case152" value="INSERT INTO t4 SELECT c31, CONCAT(c32, REPEAT('a', @max_allowed_packet-1)) FROM t3" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case153" value="INSERT INTO test.proc VALUES ('sp','bug24805140','PROCEDURE','bug24805140','SQL', 'CONTAINS_SQL','NO','DEFINER','out a int','', 'begin select requesting_trx_id from ' 'information_schema.INNODB_LOCK_WAITS limit 1 into a; end', 'root@localhost','2016-10-05 21:44:21', '2016-10-05 21:44: [...]
+ <sql-case id="insert_by_mysql_source_test_case154" value="INSERT into at(_bin,_blb) VALUES('c8eb4b15cb0948bb','c8eb4b15cb0948bb')" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case155" value="insert ignore t1 values (1, repeat('a',210), repeat('b', 310))" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case156" value="insert ignore t1 values (2, repeat(0xD0B1,215), repeat(0xD0B1, 310))" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case157" value="insert into (select * from t1) values (5)" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case158" value="insert into city 'blah'" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case159" value="insert into t1 (a) select b from t2 on duplicate key update a=default(b)" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case160" value="insert into t1 (b) values (repeat('a',100)),(repeat('b',100)),(repeat('c',100))" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case161" value="insert into t1 (b) values (repeat('z',100))" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case162" value="insert into t1 (binarycol) values (repeat('x',256))" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case163" value="insert into t1 (charcol) values (repeat('x',256))" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case164" value="insert into t1 (tinyblobcol) values (repeat('x',256))" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case165" value="insert into t1 (tinytextcol) values (repeat('x',256))" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case166" value="insert into t1 (varbinarycol) values (repeat('x',256))" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case167" value="insert into t1 (varcharcol) values (repeat('x',256))" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case168" value="insert into t1 values (1, concat(repeat('1', 300), '2')), (1, concat(repeat('1', 300), '2')), (1, concat(repeat('0', 300), '1')), (2, concat(repeat('1', 300), '2')), (2, concat(repeat('1', 300), '2')), (2, concat(repeat('0', 300), '1'))" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case169" value="insert into t1 values (1,repeat('a',255)),(2,repeat('b',255))" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case170" value="insert into t1 values (1,repeat('a',255)),(2,repeat('b',255))" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case171" value="insert into t1 values (repeat("1",200))" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case172" value="insert into t1 values (repeat('a', 1022), 0), (repeat(_utf8 0xc3b7, 4), 0)" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case173" value="insert into t1 values (repeat('a',333)), (repeat('b',333))" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case174" value="insert into t1 values (repeat('b',20))" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case175" value="insert into t1 values (repeat(0x0000201f, 10))" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case176" value="insert into t1 values (repeat(0x00002020, 10))" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case177" value="insert into t1 values (repeat(0x00002021, 10))" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case178" value="insert into t1 values (repeat(0x201f, 10))" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case179" value="insert into t1 values (repeat(0x201f, 10))" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case180" value="insert into t1 values (repeat(0x2020, 10))" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case181" value="insert into t1 values (repeat(0x2020, 10))" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case182" value="insert into t1 values (repeat(0x2021, 10))" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case183" value="insert into t1 values (repeat(0x2021, 10))" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case184" value="insert into t1 values(repeat('a',65530))" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case185" value="insert into t2 select x3.a, -- 3 concat('val-', x3.a + 3*x4.a), -- 12 concat('val-', @a:=x3.a + 3*x4.a + 12*C.a), -- 120 concat('val-', @a + 120*D.a) from t1 x3, t1 x4, t1 C, t1 D where x3.a < 3 and x4.a < 4 and D.a < 4 order by x3.a, x4.a, C.a, D.a" db-types="MySQL"/>
+ <sql-case id="insert_by_mysql_source_test_case186" value="insert into t5 select * from `äöüÄÖÜ` flush logs" db-types="MySQL"/>
+ <sql-case id="update_by_mysql_source_test_case1" value="UPDATE (VALUES ROW(1),ROW(2)) AS dt(a) LEFT JOIN performance_schema.setup_instruments ON dt.a=enabled SET enabled = 'YES' WHERE name = 'wait/lock/metadata/sql/mdl'" db-types="MySQL"/>
+ <sql-case id="update_by_mysql_source_test_case2" value="UPDATE /*+ SET_VAR(time_zone = 'UTC') */ t1 SET f1 = TIMEDIFF(NOW(), UTC_TIMESTAMP)" db-types="MySQL"/>
+ <sql-case id="update_by_mysql_source_test_case3" value="UPDATE IGNORE t1 SET c12= REPEAT('ab', @max_allowed_packet)" db-types="MySQL"/>
+ <sql-case id="update_by_mysql_source_test_case4" value="UPDATE IGNORE t1 set data=repeat('a',18*1024*1024)" db-types="MySQL"/>
+ <sql-case id="update_by_mysql_source_test_case5" value="UPDATE IGNORE t1, t2 SET c12= REPEAT('ab', @max_allowed_packet), c22= 'ab'" db-types="MySQL"/>
+ <sql-case id="update_by_mysql_source_test_case6" value="UPDATE t1 LEFT JOIN t2 USING(id) SET t2.c = REPEAT('1', 70000) WHERE t1.id = 1" db-types="MySQL"/>
+ <sql-case id="update_by_mysql_source_test_case7" value="UPDATE t1 SET b=default(b)" db-types="MySQL"/>
+ <sql-case id="update_by_mysql_source_test_case8" value="UPDATE t1 SET b=repeat('a', 600) where a=11" db-types="MySQL"/>
+ <sql-case id="update_by_mysql_source_test_case9" value="UPDATE t1 SET b=repeat('a', 800) where a=10" db-types="MySQL"/>
+ <sql-case id="update_by_mysql_source_test_case10" value="UPDATE t1 SET c12= REPEAT('ab', @max_allowed_packet)" db-types="MySQL"/>
+ <sql-case id="update_by_mysql_source_test_case11" value="UPDATE t1 SET c12= REPEAT('ab', @max_allowed_packet)" db-types="MySQL"/>
+ <sql-case id="update_by_mysql_source_test_case12" value="UPDATE t1 set data=repeat('a',18*1024*1024)" db-types="MySQL"/>
+ <sql-case id="update_by_mysql_source_test_case13" value="UPDATE t1 set data=repeat('c',17*1024*1024)" db-types="MySQL"/>
+ <sql-case id="update_by_mysql_source_test_case14" value="UPDATE t1, t2 SET c12= REPEAT('ab', @max_allowed_packet), c22= 'ab'" db-types="MySQL"/>
+ <sql-case id="update_by_mysql_source_test_case15" value="UPDATE t2 SET c = REPEAT('1', 70000)" db-types="MySQL"/>
+ <sql-case id="update_by_mysql_source_test_case16" value="UPDATE t3 SET c32= CONCAT(c32, REPEAT('a', @max_allowed_packet-1))" db-types="MySQL"/>
+ <sql-case id="update_by_mysql_source_test_case17" value="update t1 set b=repeat('a',256)" db-types="MySQL"/>
+ <sql-case id="update_by_mysql_source_test_case18" value="update t1 set b=repeat('e',200) where a=1" db-types="MySQL"/>
+ <sql-case id="update_by_mysql_source_test_case19" value="update t1 set b=repeat(left(b,1),10) where a between 32 and 43" db-types="MySQL"/>
+ <sql-case id="update_by_mysql_source_test_case20" value="update t1 set b=repeat(left(b,1),2) where a between 64 and 66" db-types="MySQL"/>
+ <sql-case id="update_by_mysql_source_test_case21" value="update t1 set b=repeat(left(b,1),200) where a=1" db-types="MySQL"/>
+ <sql-case id="update_by_mysql_source_test_case22" value="update t1 set b=repeat(left(b,1),255) where a between 1 and 5" db-types="MySQL"/>
+ <sql-case id="update_by_mysql_source_test_case23" value="update t1 set b=repeat(left(b,1),65) where a between 67 and 70" db-types="MySQL"/>
+ <sql-case id="delete_by_mysql_source_test_case1" value="DELETE /*+ SET_VAR(time_zone = 'UTC') */ FROM t1 WHERE f1 = TIMEDIFF(NOW(), UTC_TIMESTAMP)" db-types="MySQL"/>
+ <sql-case id="delete_by_mysql_source_test_case2" value="DELETE FROM t1 WHERE _id < 8" db-types="MySQL"/>
+ <sql-case id="delete_by_mysql_source_test_case3" value="DELETE FROM t1 WHERE _id < 8" db-types="MySQL"/>
+ <sql-case id="delete_by_mysql_source_test_case4" value="DELETE FROM t1 WHERE c12 <=> REPEAT('ab', @max_allowed_packet)" db-types="MySQL"/>
+ <sql-case id="delete_by_mysql_source_test_case5" value="DELETE FROM t1 WHERE c12 <=> REPEAT('ab', @max_allowed_packet)" db-types="MySQL"/>
+ <sql-case id="delete_by_mysql_source_test_case6" value="DELETE FROM t1, t2 USING t1 INNER JOIN t2 WHERE t1.c11 = t2.c21 AND t2.c22 <=> REPEAT('ab', @max_allowed_packet)" db-types="MySQL"/>
+ <sql-case id="delete_by_mysql_source_test_case7" value="DELETE IGNORE FROM t1, t2 USING t1 INNER JOIN t2 WHERE t1.c11 = t2.c21 AND t2.c22 <=> REPEAT('ab', @max_allowed_packet)" db-types="MySQL"/>
+ <sql-case id="delete_by_mysql_source_test_case8" value="DELETE t1 PARTITION (pNeg), t3 FROM t1, t3 FLUSH STATUS" db-types="MySQL"/>
+ <sql-case id="delete_by_mysql_source_test_case9" value="delete from (select * from t1)" db-types="MySQL"/>
+ <sql-case id="delete_by_mysql_source_test_case10" value="delete from (select * from t1) as t1, t1 as t2" db-types="MySQL"/>
+ <sql-case id="delete_by_mysql_source_test_case11" value="delete from mysql.user where user=_binary'mysqltest_1'" db-types="MySQL"/>
+ <sql-case id="delete_by_mysql_source_test_case12" value="delete from mysql.user where user=_binary'mysqltest_1'" db-types="MySQL"/>
</sql-cases>