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 &apos;a&apos; FROM COUNTRY)= &apos;Australi&apos;" 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 &apos;1&apos; IN (&apos;1&apos;, INET_NTOA(0))" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case5" value="SELECT &apos;1&apos; IN (&apos;1&apos;, INET_NTOA(0))" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case6" value="SELECT &apos;1&apos; IN (&apos;1&apos;, SUBSTRING(-9223372036854775809, 1))" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case7" value="SELECT &apos;1&apos; RLIKE RPAD(&apos;1&apos;, 10000, &apos;(&apos;)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case8" value="SELECT &apos;a&apos; = AES_DECRYPT(AES_ENCRYPT(&apos;a&apos;, &apos;a&apos;), &apos;a&apos;, REPEAT(&apos;a&apos;,100))" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case9" value="SELECT &apos;a&apos; = AES_DECRYPT(AES_ENCRYPT(&apos;a&apos;, &apos;a&apos;), &apos;a&apos;, REPEAT(&apos;a&apos;,16))" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case10" value="SELECT &apos;c373e9f5ad0791a0dab5444553544200&apos; IN(SELECT t1.FOLDERID FROM t1 WHERE t1.PARENTID=&apos;2f6161e879db43c1a5b82c21ddc49089&apos; AND t1.FOLDERNAME = &apos;Level1&apos;)" 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)),(&apos;&apos;),(-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 &lt;&gt; 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&apos;31&apos; | NULL) + 0" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case27" value="SELECT (_binary x&apos;31&apos; | x&apos;31&apos;)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case28" value="SELECT (_binary x&apos;31&apos; | x&apos;31&apos;) + 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 ((&apos;a&apos;,&apos;c&apos;),(&apos;a&apos;,&apos;b&apos;)) 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, &quot;30&quot;)) 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, &quot;20&quot;) 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(&apos;[]&apos;, &apos;$[*]&apos; COLUMNS (p CHAR(1) CHARACTER SET &quot;utf8&quot; PATH &apos;$.a&apos;)) AS t" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case46" value="SELECT * FROM json_table(&apos;[]&apos;, &apos;$[*]&apos; COLUMNS (p CHAR(1) CHARACTER SET &apos;utf8&apos; PATH &apos;$.a&apos;)) AS t" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case47" value="SELECT * FROM json_table(&apos;[]&apos;, &apos;$[*]&apos; COLUMNS (p CHAR(1) CHARACTER SET `utf8` PATH &apos;$.a&apos;)) AS t" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case48" value="SELECT * FROM json_table(&apos;[]&apos;, &apos;$[*]&apos; COLUMNS (p CHAR(1) CHARACTER SET utf8 PATH &apos;$.a&apos;)) AS t" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case49" value="SELECT * FROM json_table(&apos;[]&apos;, &apos;$[*]&apos; COLUMNS (p NATIONAL CHAR(1) PATH &apos;$.a&apos;)) AS t" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case50" value="SELECT * FROM json_table(&apos;[]&apos;, &apos;$[*]&apos; COLUMNS (p NCHAR PATH &apos;$.a&apos;)) AS t" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case51" value="SELECT * FROM json_table(&apos;[]&apos;, &apos;$[*]&apos; COLUMNS (p NCHAR(1) PATH &apos;$.a&apos;)) AS t" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case52" value="SELECT * FROM json_table(&apos;[]&apos;, &apos;$[*]&apos; COLUMNS (p NVARCHAR(1) PATH &apos;$.a&apos;)) 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 &gt; 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 &lt;ANY (VALUES ROW(1))" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case67" value="SELECT * FROM t0 WHERE a &lt;ANY (VALUES ROW(1), ROW(2))" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case68" value="SELECT * FROM t0 WHERE a &gt;ALL (VALUES ROW(1))" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case69" value="SELECT * FROM t0 WHERE a &gt;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 = &apos;test1&apos; AND t2.b = &apos;20161213&apos; WHERE t1.a = &apos;test1&apos;" 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(&apos;reportDate&apos;, _binary&apos;2009-01-09&apos; COLLATE &apos;binary&apos;)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case83" value="SELECT * FROM t1 WHERE c1 &lt;=  REPEAT( SUBSTR( UPPER(&apos;Rdlpikti&apos;) , 1 , 2 ), 8)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case84" value="SELECT * FROM t1 WHERE c1 &lt;=  REPEAT( SUBSTR( UPPER(&apos;Rdlpikti&apos;) , 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 = &apos;materialization=off,semijoin=off&apos;) */ * FROM t1 AS ta, lateral (select 1 WHERE ta.a IN (SELECT b FROM t2 AS tb                WHERE tb.b &gt;= 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 = &apos;+04:00&apos;) */ TIMEDIFF(NOW(), UTC_TIMESTAMP)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case94" value="SELECT /*+ SET_VAR(time_zone = &apos;UTC&apos;) */ 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&lt;&gt;NOW(), &apos;[{&quot;a&quot;:&quot;3&quot;},{&quot;a&quot;:2},{&quot;b&quot;:1},{&quot;a&quot;:0}]&apos;, &apos;&apos;) , &apos;$[*]&apos; columns (id for ordinality, jpath varchar(100) path &apos;$.a&apos;, jexst int exists path &apos;$.b [...]
+    <sql-case id="select_by_mysql_source_test_case96" value="SELECT 0 &amp; (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(&apos;B&apos;))" 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(&apos;B&apos;))" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case101" value="SELECT 1 FROM t WHERE insert(a &amp; 0x111111,&apos;&apos;,&apos;&apos;,&apos;&apos;)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case102" value="SELECT 1 FROM t WHERE insert(a &amp; NULL,&apos;&apos;,&apos;&apos;,&apos;&apos;)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case103" value="SELECT 1 FROM t1 GROUP BY SUBSTRING(SYSDATE() FROM &apos;K&apos; FOR &apos;jxW&lt;&apos;)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case104" value="SELECT 1 FROM t1 GROUP BY TRIM(LEADING RAND() FROM &apos;&apos;)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case105" value="SELECT 1 FROM t1 GROUP BY insert(a,&apos;1&apos;,&apos;11&apos;,&apos;1&apos;)" 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) &lt;&gt; 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 &gt; 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&apos;312E35&apos; | x&apos;312E35&apos;)" 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 &quot;keypart_reference_from_where_clause&quot;" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case181" value="SELECT ADDDATE(&apos;8112-06-20&apos;, REPEAT(&apos;1&apos;, 32))" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case182" value="SELECT ADDTIME(UTC_DATE, &apos;23:28:14.014837&apos;) 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&apos;Жоро&apos;, &apos;a&apos;), &apos;a&apos;) = _UTF8&apos;Жоро&apos;" 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(&apos;a&apos;, &apos;a&apos;) = AES_ENCRYPT(&apos;a&apos;, &apos;a&apos;, REPEAT(&apos;a&apos;, 16))" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case208" value="SELECT AES_ENCRYPT(&apos;a&apos;, &apos;a&apos;) = AES_ENCRYPT(&apos;a&apos;, &apos;a&apos;, REPEAT(&apos;b&apos;, 16))" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case209" value="SELECT AES_ENCRYPT(&apos;a&apos;, &apos;a&apos;) = AES_ENCRYPT(&apos;a&apos;, REPEAT(&apos;a&apos;,1000))" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case210" value="SELECT AES_ENCRYPT(&apos;a&apos;, &apos;a&apos;) = AES_ENCRYPT(REPEAT(&apos;a&apos;,1000), &apos;a&apos;)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case211" value="SELECT BIN(MID(REPEAT(&apos;b&apos;,64),21,229))" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case212" value="SELECT BIN(RIGHT(REPEAT(&apos;b&apos;,64),30))" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case213" value="SELECT BIN(SUBSTRING(REPEAT(&apos;b&apos;,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(&apos;&quot;&apos;,CONCAT(&apos;&quot;;&quot;&apos;,repeat(&apos;a&apos;,60), repeat(&apos;b&apos;,60), repeat(&apos;c&apos;,60), repeat (&apos;d&apos;,100)),&apos;&quot;&apos;)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case226" value="SELECT CONCAT(&apos;&quot;&apos;,CONCAT(&apos;&quot;;&quot;&apos;,repeat(&apos;a&apos;,60), repeat(&apos;b&apos;,60), repeat(&apos;c&apos;,60), repeat (&apos;d&apos;,100)),&apos;&quot;&apos;)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case227" value="SELECT CONCAT(&apos;&quot;&apos;,CONCAT_WS(&apos;&quot;;&quot;&apos;,repeat(&apos;a&apos;,60), repeat(&apos;b&apos;,60), repeat(&apos;c&apos;,60), repeat (&apos;d&apos;,100)),&apos;&quot;&apos;)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case228" value="SELECT CONCAT(&apos;&quot;&apos;,CONCAT_WS(&apos;&quot;;&quot;&apos;,repeat(&apos;a&apos;,60), repeat(&apos;b&apos;,60), repeat(&apos;c&apos;,60), repeat (&apos;d&apos;,100)),&apos;&quot;&apos;)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case229" value="SELECT CONCAT(&apos;&quot;&apos;,CONCAT_WS(&apos;&quot;;&quot;&apos;,repeat(&apos;a&apos;,60),repeat(&apos;b&apos;,60),repeat(&apos;c&apos;,60),repeat(&apos;d&apos;,100)), &apos;&quot;&apos;)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case230" value="SELECT CONCAT(i,&apos;:&apos;,j) as ij, CONCAT(j,&apos;:&apos;,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(&apos;&quot;&apos;,CONCAT_WS(&apos;&quot;;&quot;&apos;,repeat(&apos;a&apos;,60), repeat(&apos;b&apos;,60), repeat(&apos;c&apos;,60), repeat (&apos;d&apos;,100)),&apos;&quot;&apos;)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case232" value="SELECT CONCAT_WS(&apos;&quot;&apos;,CONCAT_WS(&apos;&quot;;&quot;&apos;,repeat(&apos;a&apos;,60), repeat(&apos;b&apos;,60), repeat(&apos;c&apos;,60), repeat (&apos;d&apos;,100)),&apos;&quot;&apos;)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case233" value="SELECT COUNT(*) = 1 FROM information_schema.processlist WHERE state = &apos;Waiting for locking service lock&apos; 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( &apos;{}&apos;,&apos;$[0][1]&apos; 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(&apos;a&apos;,256)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case238" value="SELECT COUNTRY FROM t1 WHERE trim(leading  &apos;A&apos; FROM COUNTRY) = &apos;ustralia&apos; AND trim(trailing &apos;a&apos; FROM COUNTRY) = &apos;Australi&apos;" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case239" value="SELECT COUNTRY FROM t1 WHERE trim(leading &apos;A&apos; FROM  COUNTRY) = &apos;ustralia&apos;" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case240" value="SELECT CRC32(INSERT(&apos;foodyear&apos;, 1, 4, &apos;good&apos;))" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case241" value="SELECT CURRENT_TIME(6) RLIKE &apos;^[0-9]{2}:[0-9]{2}:[0-9]{2}.[0-9]{6}$&apos;" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case242" value="SELECT CURRENT_TIMESTAMP(6) RLIKE &apos;^[0-9]{4}-[0-9]{2}-[0-9]{2} [0-9]{2}:[0-9]{2}:[0-9]{2}.[0-9]{6}$&apos;" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case243" value="SELECT DATEDIFF((_binary &apos;12012-05-19 09:06:07&apos; | _binary &apos;12012-05-19 09:06:07&apos;), &apos;2012-05-21 09:06:07&apos;)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case244" value="SELECT DATEDIFF((_binary &apos;2012-05-19 09:06:07&apos; | _binary &apos;2012-05-19 09:06:07&apos;), &apos;2012-05-21 09:06:07&apos;)" 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( &apos;xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx&apos;, NULL, NULL ), ROW( NULL, NULL, &apos;&quot;yyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyy&quot;&apos; ) ) 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 &lt; 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) &gt; 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 &apos;0000-00-00 00:00:00.000000&apos;)" 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(&apos;1&apos;,32))IS NOT FALSE" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case259" value="SELECT GET_LOCK(REPEAT(&apos;a&apos;, 64), 0) = 1 AS expect_1" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case260" value="SELECT GET_LOCK(REPEAT(&apos;a&apos;, 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(&apos;&apos;, 42, TRIM(BOTH c1 FROM x&apos;ff&apos;))) FROM t1" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case266" value="SELECT HEX(LPAD(&apos;&apos;, 42, TRIM(x&apos;ffff&apos; FROM c1))) FROM t1" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case267" value="SELECT HEX(_bin &amp; _bin), HEX(_bin &amp; _vbn), HEX(_vbn &amp; _bin), HEX(_vbn &amp; _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 &lt;&lt; (_binary 0x38 | 0x38))" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case271" value="SELECT HEX(_binary 0x0003 &lt;&lt; (_binary 0x38 | NULL))" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case272" value="SELECT HEX(_binary 0x0003 &lt;&lt; (_binary 0x40 | 0x40))" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case273" value="SELECT IF(GROUPING(a)=1,&apos;All Departments&apos;, a) as Department, IF(GROUPING(b)=1, &apos;All Employees&apos;, 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(&apos;a&apos;, 1, 1, YEAR(UNHEX(&apos;w&apos;)))" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case275" value="SELECT INSERT(&apos;abc&apos;, 3, 3, &apos;1234&apos;)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case276" value="SELECT INSERT(&apos;abc&apos;, 4, 3, &apos;1234&apos;)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case277" value="SELECT INSERT(&apos;abc&apos;, 5, 3, &apos;1234&apos;)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case278" value="SELECT INSERT(&apos;abc&apos;, 6, 3, &apos;1234&apos;)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case279" value="SELECT INSERT(&apos;𝌆テÀa&apos;, 2, 2, &apos;テb&apos;)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case280" value="SELECT INSERT(&apos;𝌆テÀa&apos;, 2, 2, &apos;テb&apos;)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case281" value="SELECT INSERT(1, 1, 2, _utf8mb4 x&apos;E4B8ADE69687&apos;)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case282" value="SELECT INSERT(`字段一`, 1, 1, &apos; &apos;) FROM `表一`" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case283" value="SELECT INSERT(`字段一`, 1, 1, &apos;㐊&apos;) FROM `表一`" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case284" value="SELECT INSERT(`字段一`, 1, 1, &apos;岝&apos;) FROM `表一`" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case285" value="SELECT INSERT(`字段一`, 1, 2, &apos;  &apos;) FROM `表一`" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case286" value="SELECT INSERT(`字段一`, 1, 2, &apos;㐊&apos;) FROM `表一`" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case287" value="SELECT INSERT(`字段一`, 1, 2, &apos;岝岝&apos;) FROM `表一`" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case288" value="SELECT INSERT(`字段一`, 1, 3, &apos;   &apos;) FROM `表一`" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case289" value="SELECT INSERT(`字段一`, 1, 3, &apos;㐊&apos;) FROM `表一`" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case290" value="SELECT INSERT(`字段一`, 1, 3, &apos;岝岝岝&apos;) FROM `表一`" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case291" value="SELECT INSERT(`字段一`, 1, 4, &apos;    &apos;) FROM `表一`" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case292" value="SELECT INSERT(`字段一`, 1, 4, &apos;㐊&apos;) FROM `表一`" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case293" value="SELECT INSERT(`字段一`, 1, 4, &apos;岝岝岝岝&apos;) FROM `表一`" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case294" value="SELECT INSERT(`字段一`, 1, 5, &apos;     &apos;) FROM `表一`" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case295" value="SELECT INSERT(`字段一`, 1, 5, &apos;㐊&apos;) FROM `表一`" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case296" value="SELECT INSERT(`字段一`, 1, 5, &apos;岝岝岝岝岝&apos;) FROM `表一`" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case297" value="SELECT INSERT(`字段一`, 4, 1, &apos; &apos;) FROM `表一`" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case298" value="SELECT INSERT(`字段一`, 4, 1, &apos;𠀂&apos;) FROM `表一`" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case299" value="SELECT INSERT(`字段一`, 4, 1, &apos;𠻠&apos;) FROM `表一`" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case300" value="SELECT INSERT(`字段一`, 4, 2, &apos;  &apos;) FROM `表一`" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case301" value="SELECT INSERT(`字段一`, 4, 2, &apos;𠀂𠀂&apos;) FROM `表一`" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case302" value="SELECT INSERT(`字段一`, 4, 2, &apos;𠻠&apos;) FROM `表一`" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case303" value="SELECT INSERT(`字段一`, 5, 1, &apos; &apos;) FROM `表一`" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case304" value="SELECT INSERT(`字段一`, 5, 1, &apos;𠀂&apos;) FROM `表一`" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case305" value="SELECT INSERT(`字段一`, 5, 1, &apos;𠻠&apos;) FROM `表一`" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case306" value="SELECT INSERT(a, 1, 1, x&apos;ff&apos;) 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(&apos;a&apos;, 64)) = 0 AS expect_1" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case310" value="SELECT IS_FREE_LOCK(REPEAT(&apos;a&apos;, 65))" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case311" value="SELECT IS_USED_LOCK(REPEAT(&apos;a&apos;, 64)) = CONNECTION_ID() AS expect_1" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case312" value="SELECT IS_USED_LOCK(REPEAT(&apos;a&apos;, 65))" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case313" value="SELECT JSON_ARRAY(JSON_ARRAYAGG(CAST(&apos;&apos; AS JSON)) OVER (), &apos;&apos;)" 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(&apos;a&apos;, @@max_allowed_packet-10)))" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case317" value="SELECT MAKETIME(((1)&lt;=&gt; (2*JSON_OBJECTAGG(&apos;1&apos;,1)OVER())),&apos;1&apos;,1)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case318" value="SELECT MAKETIME(((1)&lt;=&gt; (JSON_OBJECTAGG(&apos;1&apos;,1)OVER())),&apos;1&apos;,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 &lt;&gt; 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(&apos;b&apos;,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&apos;44&apos; IN _utf8mb4&apos;abcdef&apos;)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case325" value="SELECT POSITION(x&apos;64&apos; IN _utf8mb4&apos;abcdef&apos;)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case326" value="SELECT POSITION(x&apos;ff&apos; IN _utf8mb4&apos;abcdef&apos;)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case327" value="SELECT REGEXP_INSTR(e, &apos;pattern&apos;) FROM (VALUES ROW(&apos;Find pattern&apos;), ROW(NULL), ROW(&apos;Find pattern&apos;)) AS v(e)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case328" value="SELECT REGEXP_LIKE(e, &apos;pattern&apos;) FROM (VALUES ROW(&apos;Find pattern&apos;), ROW(NULL), ROW(&apos;Find pattern&apos;)) AS v(e)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case329" value="SELECT REGEXP_REPLACE(e, &apos;pattern&apos;, &apos;xyz&apos;) FROM (VALUES ROW(&apos;Find pattern&apos;), ROW(NULL), ROW(&apos;Find pattern&apos;)) AS v(e)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case330" value="SELECT REGEXP_SUBSTR(e, &apos;pattern&apos;) FROM (VALUES ROW(&apos;Find pattern&apos;), ROW(NULL), ROW(&apos;Find pattern&apos;)) AS v(e)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case331" value="SELECT RELEASE_LOCK(REPEAT(&apos;a&apos;, 64)) = 1 AS expect_1" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case332" value="SELECT RELEASE_LOCK(REPEAT(&apos;a&apos;, 65))" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case333" value="SELECT REPEAT( &apos;#&apos;, tire ) AS A, REPEAT( &apos;#&apos;, tire % 999 ) AS B, tire FROM `t1`" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case334" value="SELECT REPEAT(&apos;0&apos;, -2)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case335" value="SELECT REPEAT(&apos;0&apos;, 2)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case336" value="SELECT REPEAT(&apos;0&apos;, CAST(0 AS UNSIGNED))" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case337" value="SELECT REPEAT(&apos;1&apos;, DAY(FROM_UNIXTIME(-1)))" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case338" value="SELECT REPEAT(&apos;T&apos;, 16777211)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case339" value="SELECT REPEAT(0x1111, 40000000) &gt;&gt; 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 &apos;&apos; 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( &apos;MULTIPOLYGON(((&apos;, REPEAT (&apos;-0.00000000001234567890123456789012 -0.123456789012345678,&apos;, 1000), &apos;-0.00000000001234567890123456789012 -0.123456789012345678&apos;, &apos;)))&apos; ))) AS a" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case356" value="SELECT ST_AsWKB(ST_GeomFromText(&apos;POINT(0 0)&apos;)) 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(&apos;POINT(0 0)&apos;)) 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(&apos;POINT(0 0)&apos;)) 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(&apos;POINT(0 0)&apos;)) IN (SELECT b FROM t1) AS result" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case360" value="SELECT ST_GeomFromText(&apos;POINT(0 0)&apos;) IN (SELECT b FROM t) AS result" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case361" value="SELECT ST_GeomFromText(&apos;POINT(0 0)&apos;) IN (SELECT b FROM t) AS result" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case362" value="SELECT ST_GeomFromText(&apos;POINT(0 0)&apos;) IN (SELECT b FROM t1) AS result" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case363" value="SELECT ST_GeomFromText(&apos;POINT(0 0)&apos;) IN (SELECT b FROM t1) AS result" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case364" value="SELECT SUBTIME((_binary &apos;12007-12-31 23:59:59.999999&apos; | _binary &apos;12007-12-31 23:59:59.999999&apos;),&apos;1 1:1:1.000002&apos;)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case365" value="SELECT SUBTIME((_binary &apos;2012-05-19 09:06:07&apos; | _binary &apos;2012-05-19 09:06:07&apos;),&apos;1 1:1:1.000002&apos;)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case366" value="SELECT SUBTIME(UTC_DATE, &apos;04:44:03.014042&apos;) 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(&apos;2006-04-26&apos;), 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(&apos;0000-00-00 00:00:00.00000&apos;, 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(&apos;a&apos;, &apos;a&apos;, REPEAT(&apos;a&apos;, 1024)))" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case377" value="SELECT TRACE NOT RLIKE &apos;&quot;final_filtering_effect&quot;: 1&apos; AS OK FROM INFORMATION_SCHEMA.OPTIMIZER_TRACE" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case378" value="SELECT TRACE RLIKE &apos;disjuntive_predicate_present&apos; AS OK FROM INFORMATION_SCHEMA.OPTIMIZER_TRACE" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case379" value="SELECT TRACE RLIKE &apos;disjuntive_predicate_present&apos; AS OK FROM INFORMATION_SCHEMA.OPTIMIZER_TRACE" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case380" value="SELECT TRACE RLIKE &apos;have_both_agg_distinct_and_min_max&apos; AS OK FROM INFORMATION_SCHEMA.OPTIMIZER_TRACE" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case381" value="SELECT TRACE RLIKE &apos;have_both_agg_distinct_and_min_max&apos; AS OK FROM INFORMATION_SCHEMA.OPTIMIZER_TRACE" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case382" value="SELECT TRACE RLIKE &apos;have_both_agg_distinct_and_min_max&apos; AS OK FROM INFORMATION_SCHEMA.OPTIMIZER_TRACE" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case383" value="SELECT TRACE RLIKE &apos;have_both_agg_distinct_and_min_max&apos; AS OK FROM INFORMATION_SCHEMA.OPTIMIZER_TRACE" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case384" value="SELECT TRACE RLIKE &apos;have_both_agg_distinct_and_min_max&apos; AS OK FROM INFORMATION_SCHEMA.OPTIMIZER_TRACE" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case385" value="SELECT TRACE RLIKE &apos;minmax_keypart_in_disjunctive_query&apos; AS OK FROM INFORMATION_SCHEMA.OPTIMIZER_TRACE" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case386" value="SELECT TRACE RLIKE &apos;minmax_keypart_in_disjunctive_query&apos; AS OK FROM INFORMATION_SCHEMA.OPTIMIZER_TRACE" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case387" value="SELECT TRACE RLIKE &apos;minmax_keypart_in_disjunctive_query&apos; AS OK FROM INFORMATION_SCHEMA.OPTIMIZER_TRACE" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case388" value="SELECT TRACE RLIKE &apos;minmax_keypart_in_disjunctive_query&apos; AS OK FROM INFORMATION_SCHEMA.OPTIMIZER_TRACE" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case389" value="SELECT TRACE RLIKE &apos;minmax_keypart_in_disjunctive_query&apos; AS OK FROM INFORMATION_SCHEMA.OPTIMIZER_TRACE" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case390" value="SELECT TRACE RLIKE &apos;minmax_keypart_in_disjunctive_query&apos; AS OK FROM INFORMATION_SCHEMA.OPTIMIZER_TRACE" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case391" value="SELECT TRACE RLIKE &apos;minmax_keypart_in_disjunctive_query&apos; AS OK FROM INFORMATION_SCHEMA.OPTIMIZER_TRACE" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case392" value="SELECT TRACE RLIKE &apos;minmax_keypart_in_disjunctive_query&apos; AS OK FROM INFORMATION_SCHEMA.OPTIMIZER_TRACE" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case393" value="SELECT TRACE RLIKE &apos;minmax_keypart_in_disjunctive_query&apos; AS OK FROM INFORMATION_SCHEMA.OPTIMIZER_TRACE" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case394" value="SELECT TRACE RLIKE &apos;minmax_keypart_in_disjunctive_query&apos; AS OK FROM INFORMATION_SCHEMA.OPTIMIZER_TRACE" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case395" value="SELECT TRACE RLIKE &apos;minmax_keypart_in_disjunctive_query&apos; AS OK FROM INFORMATION_SCHEMA.OPTIMIZER_TRACE" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case396" value="SELECT TRACE RLIKE &apos;minmax_keypart_in_disjunctive_query&apos; AS OK FROM INFORMATION_SCHEMA.OPTIMIZER_TRACE" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case397" value="SELECT TRACE RLIKE &apos;minmax_keypart_in_disjunctive_query&apos; AS OK FROM INFORMATION_SCHEMA.OPTIMIZER_TRACE" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case398" value="SELECT TRIM(BOTH &apos;y&apos; FROM s) FROM t1" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case399" value="SELECT TRIM(BOTH x&apos;F09F8DA3&apos; FROM _utf8mb4 x&apos;F09F8DA3F09F8DA3&apos;)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case400" value="SELECT TRIM(BOTH x&apos;f0&apos; FROM _utf8mb4 x&apos;F09F8DA3F09F8DA3&apos;)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case401" value="SELECT TRIM(LEADING &apos;\t&apos; FROM MID(argument,LOCATE(&apos;Query&apos;,argument)+5)) FROM test_log WHERE (argument LIKE &apos;%BY %&apos; OR argument LIKE &apos;%AS %&apos; OR argument LIKE &apos;%PASSWORD %&apos;) AND argument NOT LIKE &apos;%Prepare%&apos;" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case402" value="SELECT TRIM(LEADING &apos;y&apos; FROM s) FROM t1" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case403" value="SELECT TRIM(TRAILING &apos;y&apos; FROM s) FROM t1" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case404" value="SELECT TRIM(_latin2 x&apos;a3&apos; from _latin1 &quot;hello&quot;)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case405" value="SELECT TRIM(leading _utf8mb4 x&apos;F09F8DA3&apos; from _gb18030 x&apos;9439B9376181308B33&apos;)" 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 &apos;2001-07-06&apos; AND LEAST(FROM_DAYS(col_timestamp_key), col_timestamp_5) OR CONVERT_TZ(MAKETIME(24, 5, 7), &apos;Japan&apos;, &apos;Japan&apos;) IS NULL OR CURRENT_TIMESTAMP() IS NOT NULL OR col_datetime_not_null_key &gt;= 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(&quot;aA1#&quot;, 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 &amp; 2147483647 FROM at" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case414" value="SELECT _bin &amp; x&apos;cafebabe&apos; 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&apos;cafebabe&apos; 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&apos;cafebabe&apos; FROM at" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case419" value="SELECT _binary &apos;1&apos; + 0" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case420" value="SELECT _binary &apos;12&apos; &lt;&lt; 1" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case421" value="SELECT _binary &apos;12&apos; | &apos;12&apos;" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case422" value="SELECT _binary &apos;12&apos; | 0x0001" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case423" value="SELECT _binary &apos;12&apos; | 1" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case424" value="SELECT _binary &apos;12&apos; | _binary &apos;12&apos;" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case425" value="SELECT _bis &amp; 2147483647 FROM at" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case426" value="SELECT _bis &amp; x&apos;cafebabe&apos; 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&apos;cafebabe&apos; 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&apos;cafebabe&apos; FROM at" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case431" value="SELECT _bit &amp; 2147483647 FROM at" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case432" value="SELECT _bit &amp; x&apos;cafebabe&apos; 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&apos;cafebabe&apos; 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&apos;cafebabe&apos; FROM at" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case437" value="SELECT _biu &amp; 2147483647 FROM at" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case438" value="SELECT _biu &amp; x&apos;cafebabe&apos; 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&apos;cafebabe&apos; 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&apos;cafebabe&apos; FROM at" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case443" value="SELECT _blb &amp; 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 &amp; 2147483647 FROM at" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case447" value="SELECT _boo &amp; x&apos;cafebabe&apos; 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&apos;cafebabe&apos; 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&apos;cafebabe&apos; FROM at" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case452" value="SELECT _chr &amp; 2147483647 FROM at" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case453" value="SELECT _chr &amp; x&apos;cafebabe&apos; 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&apos;cafebabe&apos; 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&apos;cafebabe&apos; FROM at" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case458" value="SELECT _dat &amp; 2147483647 FROM at" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case459" value="SELECT _dat &amp; x&apos;cafebabe&apos; 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&apos;cafebabe&apos; 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&apos;cafebabe&apos; FROM at" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case464" value="SELECT _dec &amp; 2147483647 FROM at" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case465" value="SELECT _dec &amp; x&apos;cafebabe&apos; 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&apos;cafebabe&apos; 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&apos;cafebabe&apos; FROM at" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case470" value="SELECT _dou &amp; 2147483647 FROM at" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case471" value="SELECT _dou &amp; x&apos;cafebabe&apos; 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&apos;cafebabe&apos; 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&apos;cafebabe&apos; FROM at" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case476" value="SELECT _dtt &amp; 2147483647 FROM at" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case477" value="SELECT _dtt &amp; x&apos;cafebabe&apos; 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&apos;cafebabe&apos; 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&apos;cafebabe&apos; FROM at" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case482" value="SELECT _enu &amp; 2147483647 FROM at" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case483" value="SELECT _enu &amp; x&apos;cafebabe&apos; 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&apos;cafebabe&apos; 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&apos;cafebabe&apos; FROM at" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case488" value="SELECT _flo &amp; 2147483647 FROM at" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case489" value="SELECT _flo &amp; x&apos;cafebabe&apos; 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&apos;cafebabe&apos; 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&apos;cafebabe&apos; 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 &amp; 2147483647 FROM at" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case499" value="SELECT _ins &amp; x&apos;cafebabe&apos; 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&apos;cafebabe&apos; 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&apos;cafebabe&apos; FROM at" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case504" value="SELECT _inu &amp; 2147483647 FROM at" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case505" value="SELECT _inu &amp; x&apos;cafebabe&apos; 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&apos;cafebabe&apos; 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&apos;cafebabe&apos; FROM at" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case510" value="SELECT _jsn &amp; 2147483647 FROM at" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case511" value="SELECT _jsn &amp; x&apos;cafebabe&apos; 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&apos;cafebabe&apos; 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&apos;cafebabe&apos; FROM at" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case516" value="SELECT _lbb &amp; 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 &amp; 2147483647 FROM at" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case520" value="SELECT _ltx &amp; x&apos;cafebabe&apos; 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&apos;cafebabe&apos; 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&apos;cafebabe&apos; FROM at" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case525" value="SELECT _mbb &amp; 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 &amp; 2147483647 FROM at" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case529" value="SELECT _mes &amp; x&apos;cafebabe&apos; 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&apos;cafebabe&apos; 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&apos;cafebabe&apos; FROM at" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case534" value="SELECT _meu &amp; 2147483647 FROM at" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case535" value="SELECT _meu &amp; x&apos;cafebabe&apos; 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&apos;cafebabe&apos; 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&apos;cafebabe&apos; FROM at" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case540" value="SELECT _mtx &amp; 2147483647 FROM at" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case541" value="SELECT _mtx &amp; x&apos;cafebabe&apos; 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&apos;cafebabe&apos; 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&apos;cafebabe&apos; FROM at" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case546" value="SELECT _pnt &amp; 2147483647 FROM at" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case547" value="SELECT _pnt &amp; x&apos;cafebabe&apos; 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&apos;cafebabe&apos; 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&apos;cafebabe&apos; FROM at" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case552" value="SELECT _set &amp; 2147483647 FROM at" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case553" value="SELECT _set &amp; x&apos;cafebabe&apos; 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&apos;cafebabe&apos; 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&apos;cafebabe&apos; FROM at" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case558" value="SELECT _smp &amp; 2147483647 FROM at" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case559" value="SELECT _smp &amp; x&apos;cafebabe&apos; 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&apos;cafebabe&apos; 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&apos;cafebabe&apos; FROM at" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case564" value="SELECT _sms &amp; 2147483647 FROM at" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case565" value="SELECT _sms &amp; x&apos;cafebabe&apos; 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&apos;cafebabe&apos; 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&apos;cafebabe&apos; FROM at" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case570" value="SELECT _smu &amp; 2147483647 FROM at" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case571" value="SELECT _smu &amp; x&apos;cafebabe&apos; 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&apos;cafebabe&apos; 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&apos;cafebabe&apos; FROM at" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case576" value="SELECT _tbl &amp; 2147483647 FROM at" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case577" value="SELECT _tbl &amp; x&apos;cafebabe&apos; 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&apos;cafebabe&apos; 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&apos;cafebabe&apos; FROM at" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case582" value="SELECT _tim &amp; 2147483647 FROM at" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case583" value="SELECT _tim &amp; x&apos;cafebabe&apos; 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&apos;cafebabe&apos; 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&apos;cafebabe&apos; FROM at" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case588" value="SELECT _tin &amp; 2147483647 FROM at" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case589" value="SELECT _tin &amp; x&apos;cafebabe&apos; 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&apos;cafebabe&apos; 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&apos;cafebabe&apos; FROM at" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case594" value="SELECT _ttx &amp; 2147483647 FROM at" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case595" value="SELECT _ttx &amp; x&apos;cafebabe&apos; 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&apos;cafebabe&apos; 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&apos;cafebabe&apos; FROM at" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case600" value="SELECT _txt &amp; 2147483647 FROM at" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case601" value="SELECT _txt &amp; x&apos;cafebabe&apos; 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&apos;cafebabe&apos; 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&apos;cafebabe&apos; FROM at" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case606" value="SELECT _vbn &amp; 2147483647 FROM at" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case607" value="SELECT _vbn &amp; x&apos;cafebabe&apos; 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&apos;cafebabe&apos; 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&apos;cafebabe&apos; FROM at" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case612" value="SELECT _vch &amp; 2147483647 FROM at" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case613" value="SELECT _vch &amp; x&apos;cafebabe&apos; 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&apos;cafebabe&apos; 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&apos;cafebabe&apos; FROM at" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case618" value="SELECT _yea &amp; 2147483647 FROM at" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case619" value="SELECT _yea &amp; x&apos;cafebabe&apos; 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&apos;cafebabe&apos; 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&apos;cafebabe&apos; 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, &apos;w&apos; 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, &apos;w&apos; 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, &apos;w&apos; 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(&apos;1&apos; 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),&apos;x&apos;), 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` &gt; 149 AND alias1 . `p [...]
+    <sql-case id="select_by_mysql_source_test_case665" value="SELECT attrs.* FROM t_json, JSON_TABLE(json_col, &apos;$[*]&apos; COLUMNS (nickname JSON PATH &apos;$.nickname&apos;)) as attrs" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case666" value="SELECT b, b IN (&apos;20161213&apos;), b in (&apos;20161213&apos;, 0) FROM t2" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case667" value="SELECT b, b in (&apos;121314&apos;), b in (&apos;121314&apos;, 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&apos;&apos;)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case670" value="SELECT bin_to_uuid(x&apos;&apos;, true)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case671" value="SELECT bug18589_f1(REPEAT(&quot;a&quot;, 767))" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case672" value="SELECT c1 &lt;=  REPEAT( SUBSTR( UPPER(&apos;Rdlpikti&apos;) , 1 , 2 ), 8 ) FROM t1" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case673" value="SELECT c1, TRIM(BOTH &apos;𠻞&apos; FROM c1) FROM `表一`" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case674" value="SELECT c1, TRIM(LEADING &apos;𠻞&apos; FROM c1) FROM `表一`" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case675" value="SELECT c1, TRIM(TRAILING &apos;𠻞&apos; FROM c1) FROM `表一`" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case676" value="SELECT cast( &apos;2019-10-10 10:11&apos; AT TIME ZONE &apos;UTC&apos; AS DATETIME )" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case677" value="SELECT cast( &apos;2019-10-10&apos; AT TIME ZONE &apos;UTC&apos; AS DATETIME )" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case678" value="SELECT cast( 123 AT TIME ZONE &apos;UTC&apos; AS DATETIME )" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case679" value="SELECT cast( TIME&apos;10:10&apos; AT TIME ZONE &apos;UTC&apos; AS DATETIME )" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case680" value="SELECT cast( a AT TIME ZONE &apos;+00:00&apos; AS DATETIME ) FROM t1" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case681" value="SELECT cast( a AT TIME ZONE &apos;+00:00&apos; AS DATETIME ) FROM t1" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case682" value="SELECT cast( b AT TIME ZONE &apos;+00:00&apos; AS DATETIME ) FROM t1" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case683" value="SELECT cast( b AT TIME ZONE &apos;+00:00&apos; AS DATETIME ) FROM t1" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case684" value="SELECT cast(TIMESTAMP&apos;2019-10-10 10:11:12&apos; AT TIME ZONE &apos;+00:00&apos; AS DATETIME)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case685" value="SELECT cast(TIMESTAMP&apos;2019-10-10 10:11:12&apos; AT TIME ZONE &apos;UTC&apos; AS DATETIME)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case686" value="SELECT cast(TIMESTAMP&apos;2019-10-10 10:11:12+00:00&apos; AT TIME ZONE &apos;+00:00&apos; 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 &apos;2002-01-01 21:50:38.023562&apos; AND &apos;20090504151448.022774&apos; AND col_time_1_not_null_key IN (&apos;2000-07-13 21:35:51.034786&apos;, &apos;2004-10-13 19:51:18.029716&apos;, &apos;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(&apos;0000-00-00 00:00:00&apos;, DATEDIFF(&apos;2001-09-21&apos;,FROM_UNIXTIME(1018888192, CONCAT_WS(&apos;-&apos;,&apos;%s&apos;,&apos;%V&apos;,&apos;%u&apos;)))), 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 &apos;2005-09-12&apos; 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 &apos;0000-00-00 00:00:00&apos;) 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(&apos;2002-09-13&apos;), DATEDIFF(&apos;2009-12-15&apos;, 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(&apos; [...]
+    <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 )), &apos;+00:00&apos;,&apos;+04:00&apos;)) 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 &lt;&gt; 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 &lt; 10) SELECT t1.a * CONCAT(COUNT(0), &apos;.&apos;, 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  &gt; 5000, (     1 / var_fld ) , 5000 ) calc_var, IF ( var_fld  &gt; 5000, ( 00001 / var_fld ) , 5000 ) if_var, CASE  var_fld  &gt; 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 &amp; x&apos;CAFEBABE000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 [...]
+    <sql-case id="select_by_mysql_source_test_case705" value="SELECT hex(_bin ^ x&apos;CAFEBABE0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 [...]
+    <sql-case id="select_by_mysql_source_test_case706" value="SELECT hex(_bin | x&apos;CAFEBABE0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 [...]
+    <sql-case id="select_by_mysql_source_test_case707" value="SELECT hex(_blb &amp; x&apos;cafebabe&apos;) FROM at" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case708" value="SELECT hex(_blb ^ x&apos;cafebabe&apos;) FROM at" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case709" value="SELECT hex(_blb | x&apos;cafebabe&apos;) FROM at" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case710" value="SELECT hex(_lbb &amp; x&apos;cafebabe&apos;) FROM at" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case711" value="SELECT hex(_lbb ^ x&apos;cafebabe&apos;) FROM at" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case712" value="SELECT hex(_lbb | x&apos;cafebabe&apos;) FROM at" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case713" value="SELECT hex(_mbb &amp; x&apos;cafebabe&apos;) FROM at" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case714" value="SELECT hex(_mbb ^ x&apos;cafebabe&apos;) FROM at" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case715" value="SELECT hex(_mbb | x&apos;cafebabe&apos;) FROM at" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case716" value="SELECT hex(_tbl &amp; x&apos;CAFEBABE000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 [...]
+    <sql-case id="select_by_mysql_source_test_case717" value="SELECT hex(_tbl ^ x&apos;CAFEBABE0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 [...]
+    <sql-case id="select_by_mysql_source_test_case718" value="SELECT hex(_tbl | x&apos;CAFEBABE0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 [...]
+    <sql-case id="select_by_mysql_source_test_case719" value="SELECT hex(_vbn &amp; x&apos;CAFEBABE000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 [...]
+    <sql-case id="select_by_mysql_source_test_case720" value="SELECT hex(_vbn ^ x&apos;CAFEBABE0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 [...]
+    <sql-case id="select_by_mysql_source_test_case721" value="SELECT hex(_vbn | x&apos;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) &gt; 40 ORDER BY GROUPING(i),i, GROUPING(j),j)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case723" value="SELECT i, &apos;sum&apos; FROM (SELECT i, SUM(j) AS &apos;sum&apos; 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 &lt; 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) &gt; 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 &gt; 10 and j &lt; 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) &gt; 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 &apos;a&apos; AS id, REPEAT(&apos;foo bar&apos;, 100) AS body UNION ALL SELECT &apos;a&apos; AS id, REPEAT(&apos;bla bla&apos;, 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 &apos;a&apos; AS id, REPEAT(&apos;foo bar&apos;, 100) AS body UNION ALL SELECT &apos;a&apos; AS id, REPEAT(&apos;bla bla&apos;, 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( &apos;a&apos;, &apos;a&apos;, &apos;b&apos; ), 1, 0, &apos;x&apos; )" 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(&apos;a&apos;, @buf_sz_utf16 + 1), &apos;a&apos;, &apos;b&apos; ))" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case784" value="SELECT length(regexp_replace( repeat(&apos;a&apos;, @buf_sz_utf16), &apos;a&apos;, &apos;b&apos; ))" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case785" value="SELECT length(regexp_replace( repeat(&apos;a&apos;, @buf_sz_utf16), &apos;a&apos;, &apos;bb&apos; ))" 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 (&apos;1&apos;,1,&apos;1&apos;) 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, &apos;abc&apos;), &apos;abc&apos; )" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case802" value="SELECT right(a,1) FROM t1 WHERE b = repeat(&apos;0&apos;,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(&apos;0&apos;,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(&apos;0&apos;,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(&apos;0&apos;,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=&apos;M&apos; 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 (&apos;1&apos;,1,&apos;1&apos;) 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(&apos;Y&apos;)) 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 &gt; 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 &lt;&gt; 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 &amp;&amp; 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 &apos;b&apos; between &apos;a&apos; and &apos;c&apos;, &apos;B&apos; between &apos;a&apos; and &apos;c&apos;" 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  (&apos;1&apos;,&apos;2&apos;)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case843" value="select (case 1/0 when &quot;a&quot; then &quot;true&quot; END) + 0.0" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case844" value="select (case 1/0 when &quot;a&quot; then &quot;true&quot; 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 != &apos;sys&apos; and TABLE_NAME rlike &quot;v[0-4]{1}$&quot; 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 &apos;AA%&apos;" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case849" value="select * from t1 ignore index (primary) where tt like &apos;Aa%&apos;" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case850" value="select * from t1 where MATCH(a,b) AGAINST (&quot;indexes&quot; IN BOOLEAN MODE WITH QUERY EXPANSION)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case851" value="select * from t1 where str &lt;&gt; 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, &quot;monty&quot; between &quot;max&quot; and &quot;my&quot;,2=2 and &quot;monty&quot; between &quot;max&quot; and &quot;my&quot; 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),&quot;monty&quot; in (&quot;david&quot;,&quot;monty&quot;,&quot;allan&quot;), 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&apos;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(&apos;POLYGON((30 30,40 40,50 50,30 50,30 40,30 30))&apos;)" 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 &amp; _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&apos;B&apos; COLLATE latin1_bin IN _latin1&apos;abcd&apos;)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case896" value="select POSITION(_latin1&apos;B&apos; COLLATE latin1_general_ci IN _latin1&apos;abcd&apos; COLLATE latin1_bin)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case897" value="select POSITION(_latin1&apos;B&apos; IN _latin1&apos;abcd&apos; 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(&apos;*&apos;,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(&apos;&lt;a&gt;a&lt;/a&gt;&apos;,repeat(&apos;a b &apos;,1000),&apos;&apos;)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case904" value="select _latin1&apos;B&apos; COLLATE latin1_general_ci in (_latin1&apos;a&apos; COLLATE latin1_bin,_latin1&apos;b&apos;)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case905" value="select _latin1&apos;B&apos; COLLATE latin1_general_ci in (_latin1&apos;a&apos;,_latin1&apos;b&apos; COLLATE latin1_bin)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case906" value="select _latin1&apos;B&apos; between _latin1&apos;a&apos; and _latin1&apos;c&apos;" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case907" value="select _latin1&apos;B&apos; between _latin1&apos;a&apos; and _latin1&apos;c&apos; collate latin1_bin" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case908" value="select _latin1&apos;B&apos; between _latin1&apos;a&apos; and _latin2&apos;b&apos;" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case909" value="select _latin1&apos;B&apos; between _latin1&apos;a&apos; collate latin1_bin and _latin1&apos;c&apos;" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case910" value="select _latin1&apos;B&apos; between _latin2&apos;a&apos; and _latin1&apos;b&apos;" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case911" value="select _latin1&apos;B&apos; collate latin1_bin between _latin1&apos;a&apos; and _latin1&apos;c&apos;" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case912" value="select _latin1&apos;B&apos; collate latin1_bin in (_latin1&apos;a&apos;,_latin1&apos;b&apos;)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case913" value="select _latin1&apos;B&apos; collate latin1_general_ci between _latin1&apos;a&apos; collate latin1_bin and _latin1&apos;b&apos;" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case914" value="select _latin1&apos;B&apos; in (_latin1&apos;a&apos; collate latin1_bin,_latin1&apos;b&apos;)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case915" value="select _latin1&apos;B&apos; in (_latin1&apos;a&apos;,_latin1&apos;b&apos; collate latin1_bin)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case916" value="select _latin1&apos;B&apos; in (_latin1&apos;a&apos;,_latin1&apos;b&apos;)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case917" value="select _latin1&apos;B&apos; in (_latin1&apos;a&apos;,_latin2&apos;b&apos;)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case918" value="select _latin1&apos;B&apos; in (_latin2&apos;a&apos;,_latin1&apos;b&apos;)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case919" value="select _latin2&apos;B&apos; between _latin1&apos;a&apos; and _latin1&apos;b&apos;" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case920" value="select _latin2&apos;B&apos; in (_latin1&apos;a&apos;,_latin1&apos;b&apos;)" 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 =&apos;a71250b7ed780f6ef3185bfffe027983&apos;) and (a.count = b.id)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case925" value="select abs(3 &quot;three&quot;)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case926" value="select abs(3 AS &quot;three&quot;)" 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 &quot;p1&quot;)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case932" value="select atan(10 &quot;p1&quot;, 20)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case933" value="select atan(10 AS &quot;p1&quot;)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case934" value="select atan(10 AS &quot;p1&quot;, 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 &quot;p2&quot;)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case941" value="select atan(10, 20 AS &quot;p2&quot;)" 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(&apos;b&apos;,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 &quot;t[1-5]{1}$&quot; 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 &quot;t[1-5]{1}$&quot; 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 &quot;t[1-5]{1}$&quot; order by c" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case949" value="select case &apos;str&apos; when &apos;STR&apos; then &apos;str&apos; when null then &apos;null&apos; end as c01, case &apos;str&apos; when null then &apos;null&apos; when &apos;STR&apos; then &apos;str&apos; end as c02, field(null, &apos;str1&apos;, &apos;str2&apos;) as c03, field(&apos;str1&apos;,&apos;STR1&apos;, null) as c04, field(&apos;str1&apos;, null, &apos;STR1&apos;) as c05, &apos;string&apos; in (&apos;STRING&apos;, [...]
+    <sql-case id="select_by_mysql_source_test_case950" value="select case 1/0 when &quot;a&quot; then &quot;true&quot; END" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case951" value="select case 1/0 when &quot;a&quot; then &quot;true&quot; else &quot;false&quot; END" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case952" value="select collation(insert(_latin2&apos;abcd&apos;,2,3,_latin2&apos;ef&apos;)), coercibility(insert(_latin2&apos;abcd&apos;,2,3,_latin2&apos;ef&apos;))" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case953" value="select collation(repeat(_latin2&apos;a&apos;,10)), coercibility(repeat(_latin2&apos;a&apos;,10))" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case954" value="select collation(trim(BOTH _latin2&apos; &apos; FROM _latin2&apos;a&apos;)), coercibility(trim(BOTH _latin2&apos;a&apos; FROM _latin2&apos;a&apos;))" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case955" value="select collation(trim(LEADING _latin2&apos; &apos; FROM _latin2&apos;a&apos;)), coercibility(trim(LEADING _latin2&apos;a&apos; FROM _latin2&apos;a&apos;))" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case956" value="select collation(trim(TRAILING _latin2&apos; &apos; FROM _latin2&apos;a&apos;)), coercibility(trim(TRAILING _latin2&apos;a&apos; FROM _latin2&apos;a&apos;))" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case957" value="select concat(&quot;a&quot;,NULL),replace(NULL,&quot;a&quot;,&quot;b&quot;),replace(&quot;string&quot;,&quot;i&quot;,NULL),replace(&quot;string&quot;,NULL,&quot;i&quot;),insert(&quot;abc&quot;,1,1,NULL),left(NULL,1)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case958" value="select concat(c1, repeat(&apos;xx&apos;, 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 &quot;p1&quot;, 10, 16)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case960" value="select conv(255 AS &quot;p1&quot;, 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 &quot;p2&quot;, 16)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case965" value="select conv(255, 10 AS &quot;p2&quot;, 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 &quot;p3&quot;)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case969" value="select conv(255, 10, 16 AS &quot;p3&quot;)" 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(&apos;xx&apos;, 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(&apos;xx&apos;, 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(&apos;@&apos;, trim(leading &apos;.&apos; from concat(&apos;.&apos;, domain))) = &apos;@hello.de&apos;" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case980" value="select domain from t1 where concat(&apos;@&apos;, trim(leading &apos;.&apos; from concat(&apos;.&apos;, domain))) = &apos;@test.de&apos;" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case981" value="select extract(DAY_HOUR FROM &quot;1999-01-02 10:11:12&quot;)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case982" value="select extract(DAY_MICROSECOND FROM &quot;1999-01-02 10:11:12.000123&quot;)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case983" value="select extract(DAY_MINUTE FROM &quot;02 10:11:12&quot;)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case984" value="select extract(DAY_SECOND FROM &quot;225 10:11:12&quot;)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case985" value="select extract(HOUR_MICROSECOND FROM &quot;1999-01-02 10:11:12.000123&quot;)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case986" value="select extract(HOUR_MINUTE FROM &quot;10:11:12&quot;)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case987" value="select extract(HOUR_SECOND FROM &quot;10:11:12&quot;)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case988" value="select extract(MINUTE_MICROSECOND FROM &quot;1999-01-02 10:11:12.000123&quot;)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case989" value="select extract(MINUTE_SECOND FROM &quot;10:11:12&quot;)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case990" value="select extract(SECOND_MICROSECOND FROM &quot;1999-01-02 10:11:12.000123&quot;)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case991" value="select extract(YEAR_MONTH FROM &quot;1999-01-02&quot;)" 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(&apos;3&apos;) over ()" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case994" value="select hex(weight_string(&apos;a&apos; as char(-1)))" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case995" value="select i from t1 where a=repeat(_utf8 &apos;a&apos;,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 &apos;b&apos;,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(&quot;aa&quot;,100,1,&quot;b&quot;),insert(&quot;aa&quot;,1,3,&quot;b&quot;),left(&quot;aa&quot;,-1),substring(&quot;a&quot;,1,2)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case1002" value="select insert(&apos;hello&apos;, -1, -1, &apos;hi&apos;)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case1003" value="select insert(&apos;hello&apos;, -1, 1, &apos;hi&apos;)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case1004" value="select insert(&apos;hello&apos;, -18446744073709551615, -18446744073709551615, &apos;hi&apos;)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case1005" value="select insert(&apos;hello&apos;, -18446744073709551615, 1, &apos;hi&apos;)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case1006" value="select insert(&apos;hello&apos;, -18446744073709551616, -18446744073709551616, &apos;hi&apos;)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case1007" value="select insert(&apos;hello&apos;, -18446744073709551616, 1, &apos;hi&apos;)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case1008" value="select insert(&apos;hello&apos;, -18446744073709551617, -18446744073709551617, &apos;hi&apos;)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case1009" value="select insert(&apos;hello&apos;, -18446744073709551617, 1, &apos;hi&apos;)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case1010" value="select insert(&apos;hello&apos;, -4294967295, -4294967295, &apos;hi&apos;)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case1011" value="select insert(&apos;hello&apos;, -4294967295, 1, &apos;hi&apos;)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case1012" value="select insert(&apos;hello&apos;, -4294967296, -4294967296, &apos;hi&apos;)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case1013" value="select insert(&apos;hello&apos;, -4294967296, 1, &apos;hi&apos;)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case1014" value="select insert(&apos;hello&apos;, -4294967297, -4294967297, &apos;hi&apos;)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case1015" value="select insert(&apos;hello&apos;, -4294967297, 1, &apos;hi&apos;)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case1016" value="select insert(&apos;hello&apos;, 1, -1, &apos;hi&apos;)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case1017" value="select insert(&apos;hello&apos;, 1, -18446744073709551615, &apos;hi&apos;)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case1018" value="select insert(&apos;hello&apos;, 1, -18446744073709551616, &apos;hi&apos;)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case1019" value="select insert(&apos;hello&apos;, 1, -18446744073709551617, &apos;hi&apos;)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case1020" value="select insert(&apos;hello&apos;, 1, -4294967295, &apos;hi&apos;)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case1021" value="select insert(&apos;hello&apos;, 1, -4294967296, &apos;hi&apos;)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case1022" value="select insert(&apos;hello&apos;, 1, -4294967297, &apos;hi&apos;)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case1023" value="select insert(&apos;hello&apos;, 1, 18446744073709551615, &apos;hi&apos;)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case1024" value="select insert(&apos;hello&apos;, 1, 18446744073709551616, &apos;hi&apos;)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case1025" value="select insert(&apos;hello&apos;, 1, 18446744073709551617, &apos;hi&apos;)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case1026" value="select insert(&apos;hello&apos;, 1, 4294967295, &apos;hi&apos;)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case1027" value="select insert(&apos;hello&apos;, 1, 4294967296, &apos;hi&apos;)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case1028" value="select insert(&apos;hello&apos;, 1, 4294967297, &apos;hi&apos;)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case1029" value="select insert(&apos;hello&apos;, 18446744073709551615, 1, &apos;hi&apos;)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case1030" value="select insert(&apos;hello&apos;, 18446744073709551615, 18446744073709551615, &apos;hi&apos;)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case1031" value="select insert(&apos;hello&apos;, 18446744073709551616, 1, &apos;hi&apos;)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case1032" value="select insert(&apos;hello&apos;, 18446744073709551616, 18446744073709551616, &apos;hi&apos;)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case1033" value="select insert(&apos;hello&apos;, 18446744073709551617, 1, &apos;hi&apos;)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case1034" value="select insert(&apos;hello&apos;, 18446744073709551617, 18446744073709551617, &apos;hi&apos;)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case1035" value="select insert(&apos;hello&apos;, 4294967295, 1, &apos;hi&apos;)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case1036" value="select insert(&apos;hello&apos;, 4294967295, 4294967295, &apos;hi&apos;)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case1037" value="select insert(&apos;hello&apos;, 4294967296, 1, &apos;hi&apos;)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case1038" value="select insert(&apos;hello&apos;, 4294967296, 4294967296, &apos;hi&apos;)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case1039" value="select insert(&apos;hello&apos;, 4294967297, 1, &apos;hi&apos;)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case1040" value="select insert(&apos;hello&apos;, 4294967297, 4294967297, &apos;hi&apos;)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case1041" value="select insert(&apos;txs&apos;,2,1,&apos;hi&apos;),insert(&apos;is &apos;,4,0,&apos;a&apos;),insert(&apos;txxxxt&apos;,2,4,&apos;es&apos;)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case1042" value="select insert(&apos;txs&apos;,2,null,&apos;hi&apos;),insert(&apos;txs&apos;,2,1,null)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case1043" value="select insert(&apos;txs&apos;,null,null,&apos;hi&apos;),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,&apos;hi&apos;),insert(&apos;txs&apos;,null,1,&apos;hi&apos;)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case1049" value="select instr(&quot;foobar&quot; &quot;p1&quot;, &quot;bar&quot;)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case1050" value="select instr(&quot;foobar&quot; AS &quot;p1&quot;, &quot;bar&quot;)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case1051" value="select instr(&quot;foobar&quot; AS p1, &quot;bar&quot; AS p2)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case1052" value="select instr(&quot;foobar&quot; AS p1, &quot;bar&quot;)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case1053" value="select instr(&quot;foobar&quot; p1, &quot;bar&quot;)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case1054" value="select instr(&quot;foobar&quot;, &quot;bar&quot; &quot;p2&quot;)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case1055" value="select instr(&quot;foobar&quot;, &quot;bar&quot; AS &quot;p2&quot;)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case1056" value="select instr(&quot;foobar&quot;, &quot;bar&quot; AS p2)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case1057" value="select instr(&quot;foobar&quot;, &quot;bar&quot; p2)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case1058" value="select instr(&quot;foobar&quot;, @bar &quot;p2&quot;)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case1059" value="select instr(@foobar &quot;p1&quot;, &quot;bar&quot;)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case1060" value="select length(repeat(&quot;&quot;,1)) as a" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case1061" value="select length(repeat(&quot;&quot;,1024*1024*1024)) as a" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case1062" value="select length(repeat(&quot;1&quot;,1024*1024)) as a" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case1063" value="select length(repeat(&quot;1&quot;,1024*1024*1024)) as a" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case1064" value="select length(repeat(&quot;a&quot;,1000000)),length(concat(repeat(&quot;a&quot;,32000),repeat(&quot;a&quot;,32000),repeat(&quot;a&quot;,32000))),length(replace(&quot;aaaaa&quot;,&quot;a&quot;,concat(repeat(&quot;a&quot;,32000)))),length(insert(repeat(&quot;a&quot;,48000),1,1000,repeat(&quot;a&quot;,48000)))" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case1065" value="select length(repeat(&quot;a&quot;,100000000)),length(repeat(&quot;a&quot;,1000*64))" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case1066" value="select length(repeat(&quot;a&quot;,65500)),length(concat(repeat(&quot;a&quot;,32000),repeat(&quot;a&quot;,32000))),length(replace(&quot;aaaaa&quot;,&quot;a&quot;,concat(repeat(&quot;a&quot;,10000)))),length(insert(repeat(&quot;a&quot;,40000),1,30000,repeat(&quot;b&quot;,50000)))" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case1067" value="select length(repeat(&apos;a&apos;,2000))" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case1068" value="select length(v) from t1 where v=repeat(&apos;a&apos;,65530)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case1069" value="select mail_id,  if(folder.f_description!=&apos;&apos;, 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, &apos;%b %e, %Y %h:%i&apos;) 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(&quot;0&quot; in &quot;baaa&quot; in (1)),position(&quot;0&quot; in &quot;1&quot; in (1,2,3)),position(&quot;sql&quot; in (&quot;mysql&quot;))" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case1078" value="select position((&quot;1&quot; in (1,2,3)) in &quot;01&quot;)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case1079" value="select position(binary &apos;ll&apos; in &apos;hello&apos;),position(&apos;a&apos; in binary &apos;hello&apos;)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case1080" value="select repeat(&quot;a&quot;,0),repeat(&quot;ab&quot;,5+5),repeat(&quot;ab&quot;,-1),reverse(NULL)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case1081" value="select repeat(&apos;a&apos;, cast(2 as unsigned int))" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case1082" value="select repeat(&apos;a&apos;,2000)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case1083" value="select repeat(&apos;hello&apos;, -1)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case1084" value="select repeat(&apos;hello&apos;, -18446744073709551615)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case1085" value="select repeat(&apos;hello&apos;, -18446744073709551616)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case1086" value="select repeat(&apos;hello&apos;, -18446744073709551617)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case1087" value="select repeat(&apos;hello&apos;, -4294967295)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case1088" value="select repeat(&apos;hello&apos;, -4294967296)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case1089" value="select repeat(&apos;hello&apos;, -4294967297)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case1090" value="select repeat(&apos;hello&apos;, 18446744073709551615)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case1091" value="select repeat(&apos;hello&apos;, 18446744073709551616)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case1092" value="select repeat(&apos;hello&apos;, 18446744073709551617)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case1093" value="select repeat(&apos;hello&apos;, 4294967295)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case1094" value="select repeat(&apos;hello&apos;, 4294967296)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case1095" value="select repeat(&apos;hello&apos;, 4294967297)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case1096" value="select repeat(&apos;monty&apos;,5),concat(&apos;*&apos;,space(5),&apos;*&apos;)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case1097" value="select row(&apos;a&apos;,0,3) IN (row(3,2,3), row(&apos;a&apos;,&apos;0&apos;,&apos;3&apos;), row(1,3,3))" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case1098" value="select row(&apos;a&apos;,0,3) IN (row(3,2,3), row(&apos;a&apos;,&apos;a&apos;,&apos;3&apos;), row(1,3,3))" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case1099" value="select row(&apos;a&apos;,1.5,3) IN (row(1,2,3), row(&apos;a&apos;,1.5,3), row(&apos;a&apos;,&apos;a&apos;,&apos;a&apos;))" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case1100" value="select row(&apos;a&apos;,1.5,3) IN (row(3,NULL,3), row(&apos;a&apos;,1.5,3), row(1,3,3))" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case1101" value="select row(&apos;b&apos;,1.5,3) IN (row(&apos;b&apos;,NULL,3), row(&apos;a&apos;,1.5,3), row(1,3,3))" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case1102" value="select row(&apos;b&apos;,1.5,3) IN (row(&apos;b&apos;,NULL,4), row(&apos;a&apos;,1.5,3), row(1,3,3))" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case1103" value="select row(&apos;b&apos;,1.5,3) IN (row(3,NULL,3), row(&apos;a&apos;,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(),&apos; &apos;,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),&quot;%T&quot;), 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),&quot;%Y-%m-%d&quot;), utc_date())=0" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case1119" value="select strcmp(date_format(utc_timestamp(),&quot;%T&quot;), utc_time())=0" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case1120" value="select strcmp(date_format(utc_timestamp(),&quot;%Y-%m-%d&quot;), 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&gt;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&gt;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&gt;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, &apos;1234567&apos;) as &apos;insert&apos; 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 = &quot;mysqltest&quot; and table_name rlike &quot;t[1-5]{1}$&quot; 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(&quot;aaa&quot;), test.md5 (&quot;aaa&quot;)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case1137" value="select test.md5(&quot;aaa&quot;), test.md5 (&quot;aaa&quot;)" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case1138" value="select test.metaphon(&quot;Hello&quot;)" 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(&apos;xyz&apos; from null) as &quot;must_be_null&quot;" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case1142" value="select trim(leading NULL from &apos;kate&apos;) as &quot;must_be_null&quot;" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case1143" value="select trim(null from &apos;kate&apos;) as &quot;must_be_null&quot;" db-types="MySQL"/>
+    <sql-case id="select_by_mysql_source_test_case1144" value="select trim(trailing NULL from &apos;xyz&apos;) as &quot;must_be_null&quot;" 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 = &apos;UTC&apos;) */ 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(&apos;ab&apos;, @max_allowed_packet)" db-types="MySQL"/>
+    <sql-case id="insert_by_mysql_source_test_case3" value="INSERT IGNORE INTO t1 SELECT REPEAT(&apos;a&apos;,11)" db-types="MySQL"/>
+    <sql-case id="insert_by_mysql_source_test_case4" value="INSERT IGNORE INTO t3 VALUES( REPEAT( &apos;a&apos;, 65536 ), 3 )" db-types="MySQL"/>
+    <sql-case id="insert_by_mysql_source_test_case5" value="INSERT INTO B VALUES  (&apos;at&apos;, repeat(&apos;a&apos;,1000), &apos;the&apos;, -1622540288, &apos;as&apos;, repeat(&apos;a&apos;,1000), &apos;want&apos;, 1810890752, NULL, &apos;v&apos;, &apos;just&apos;)" db-types="MySQL"/>
+    <sql-case id="insert_by_mysql_source_test_case6" value="INSERT INTO D VALUES (39,40,4,repeat(&apos;  X&apos;, 42)), (43,56,4,repeat(&apos;  X&apos;, 42)), (47,12,4,repeat(&apos;  X&apos;, 42)), (71,28,4,repeat(&apos;  X&apos;, 42)), (76,54,4,repeat(&apos;  X&apos;, 42)), (83,45,4,repeat(&apos;  X&apos;, 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(&apos;a&apos;,1000)),(0,4,&apos;tell&apos;),(7,6,&apos;o&apos;),(6,7,&apos;g&apos;),(8,8,&apos;can&apos;), (9,15,repeat(&apos;a&apos;,1020)),(4,16,repeat(&apos;a&apos;,1020)),(6,18,&apos;his&apos;),(NULL,19,&apos;going&apos;), (7,22,&apos;mean&apos;),(8,23,&apos;here&apos;)" db-types="MySQL"/>
+    <sql-case id="insert_by_mysql_source_test_case8" value="INSERT INTO `proc` VALUES (&apos;test&apos;,&apos;downgrade_alter_proc&apos;,&apos;PROCEDURE&apos;, &apos;downgrade_alter_proc&apos;, &apos;SQL&apos;,&apos;CONTAINS_SQL&apos;,&apos;NO&apos;,&apos;INVOKER&apos;,&apos;&apos;,&apos;&apos;, &apos;BEGIN\n      SELECT c1, English, French FROM t1 &apos; &apos;JOIN t2 ON t1.c3 = t2.col2;\n     END&apos;, &apos;root@localhost&apos;,&apos;1988-04-25 20:45:00&apos;, &apos;1988-04-25 20:45: [...]
+    <sql-case id="insert_by_mysql_source_test_case9" value="INSERT INTO `t``\&quot;&quot;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 (&apos;a&apos;), (&apos;Жоро&apos;), (REPEAT(&apos;a&apos;, 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(&apos;{&quot;a&quot;: 3}&apos; as json), &quot;abcdefghijkl&quot;, &quot;abcdefghijkl&quot;, x&apos;CAFEBABE00000000000000000000000000000000000000000 [...]
+    <sql-case id="insert_by_mysql_source_test_case13" value="INSERT INTO dd_check_table(t) SELECT CONCAT(id, &apos;-&apos;, name, &apos;-&apos;, IFNULL(options, &apos;NULL&apos;), &apos;-&apos;, IFNULL(INSERT(se_private_data, INSTR(se_private_data, &apos;server_version&apos;), 20, &apos;server_version=x&apos;), &apos;NULL&apos;), &apos;-&apos;, comment, &apos;-&apos;, engine) FROM mysql.tablespaces WHERE name = &apos;mysql&apos;" db-types="MySQL"/>
+    <sql-case id="insert_by_mysql_source_test_case14" value="INSERT INTO t (c) VALUES (REPEAT(&apos;1&apos;,65537))" db-types="MySQL"/>
+    <sql-case id="insert_by_mysql_source_test_case15" value="INSERT INTO t (c) VALUES (REPEAT(&apos;2&apos;,65536))" db-types="MySQL"/>
+    <sql-case id="insert_by_mysql_source_test_case16" value="INSERT INTO t (c) VALUES (REPEAT(&apos;3&apos;,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(&apos;a&apos;, 128)), (REPEAT(&apos;b&apos;, 128)), (REPEAT(&apos;c&apos;, 128)), (REPEAT(&apos;d&apos;, 128))" db-types="MySQL"/>
+    <sql-case id="insert_by_mysql_source_test_case19" value="INSERT INTO t VALUES (REPEAT(&apos;a&apos;, 128)), (REPEAT(&apos;b&apos;, 128)), (REPEAT(&apos;c&apos;, 128)), (REPEAT(&apos;d&apos;, 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(&apos;2&apos;, 255)), (1, REPEAT(&apos;1&apos;, 255))" db-types="MySQL"/>
+    <sql-case id="insert_by_mysql_source_test_case23" value="INSERT INTO t VALUES(1, REPEAT(&apos;2&apos;, 257)), (1, REPEAT(&apos;1&apos;, 257))" db-types="MySQL"/>
+    <sql-case id="insert_by_mysql_source_test_case24" value="INSERT INTO t VALUES(1, REPEAT(&apos;2&apos;, 32750), REPEAT(&apos;1&apos;, 32750))" db-types="MySQL"/>
+    <sql-case id="insert_by_mysql_source_test_case25" value="INSERT INTO t VALUES(1, REPEAT(&apos;abs&apos;,1000))" db-types="MySQL"/>
+    <sql-case id="insert_by_mysql_source_test_case26" value="INSERT INTO t VALUES(2, REPEAT(&apos;ajs&apos;,1000))" db-types="MySQL"/>
+    <sql-case id="insert_by_mysql_source_test_case27" value="INSERT INTO t VALUES(3, REPEAT(&apos;ajj&apos;,1000))" db-types="MySQL"/>
+    <sql-case id="insert_by_mysql_source_test_case28" value="INSERT INTO t VALUES(4, REPEAT(&apos;jjs&apos;,1000))" db-types="MySQL"/>
+    <sql-case id="insert_by_mysql_source_test_case29" value="INSERT INTO t VALUES(REPEAT(x&apos;0a&apos;,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(&apos;a&apos;,1*1024*1024))" db-types="MySQL"/>
+    <sql-case id="insert_by_mysql_source_test_case32" value="INSERT INTO t1 (data) VALUES (repeat(&apos;b&apos;,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(&apos;ab&apos;, @max_allowed_packet)" db-types="MySQL"/>
+    <sql-case id="insert_by_mysql_source_test_case35" value="INSERT INTO t1 SELECT 102, REPEAT(&apos;ab&apos;, @max_allowed_packet)" db-types="MySQL"/>
+    <sql-case id="insert_by_mysql_source_test_case36" value="INSERT INTO t1 SELECT CONCAT(REPEAT(&apos;1&apos;, 1024*1024 - 27), &quot;\&apos;\r dummydb dummyhost&quot;)" db-types="MySQL"/>
+    <sql-case id="insert_by_mysql_source_test_case37" value="INSERT INTO t1 SELECT REPEAT(&apos;1&apos;, 2*1024*1024)" db-types="MySQL"/>
+    <sql-case id="insert_by_mysql_source_test_case38" value="INSERT INTO t1 SELECT ST_GeomFromText(CONCAT(&apos;GEOMETRYCOLLECTION(POINT(1 1)&apos;, REPEAT(&apos;,POINT(1 1)&apos;, 100), &apos;)&apos;))" db-types="MySQL"/>
+    <sql-case id="insert_by_mysql_source_test_case39" value="INSERT INTO t1 SELECT ST_GeomFromText(CONCAT(&apos;GEOMETRYCOLLECTION(POINT(1 1)&apos;, REPEAT(&apos;,POINT(1 1)&apos;, 100), &apos;)&apos;)) FROM t1" db-types="MySQL"/>
+    <sql-case id="insert_by_mysql_source_test_case40" value="INSERT INTO t1 SELECT ST_GeomFromText(CONCAT(&apos;GEOMETRYCOLLECTION(POINT(1 1)&apos;, REPEAT(&apos;,POINT(1 1)&apos;, 100), &apos;)&apos;)) FROM t1" db-types="MySQL"/>
+    <sql-case id="insert_by_mysql_source_test_case41" value="INSERT INTO t1 SET b=&apos;11&apos;, 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=&apos;11&apos;, 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(&apos;a&apos;,400)" db-types="MySQL"/>
+    <sql-case id="insert_by_mysql_source_test_case44" value="INSERT INTO t1 SET b=repeat(&apos;a&apos;,600)" db-types="MySQL"/>
+    <sql-case id="insert_by_mysql_source_test_case45" value="INSERT INTO t1 SET c1=11, c2=REPEAT(&apos;q&apos;,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(&apos;x&apos;, 1048576) )" db-types="MySQL"/>
+    <sql-case id="insert_by_mysql_source_test_case49" value="INSERT INTO t1 VALUES ( 2, REPEAT(&apos;-&apos;, 1048576) )" db-types="MySQL"/>
+    <sql-case id="insert_by_mysql_source_test_case50" value="INSERT INTO t1 VALUES ( UNHEX(&apos;0000000001030000000100000002000000000000000000000000000000000000000000&apos; &apos;00000000F03F0000000000000000&apos;))" db-types="MySQL"/>
+    <sql-case id="insert_by_mysql_source_test_case51" value="INSERT INTO t1 VALUES ( UNHEX(&apos;0000000001030000000100000003000000000000000000000000000000000000000000&apos; &apos;00000000F03F000000000000000000000000000000000000000000000000&apos;))" db-types="MySQL"/>
+    <sql-case id="insert_by_mysql_source_test_case52" value="INSERT INTO t1 VALUES ( UNHEX(&apos;0000000001040000000100000001020000000200000000000000000000000000000000&apos; &apos;000000000000000000F03F000000000000F03F&apos;))" db-types="MySQL"/>
+    <sql-case id="insert_by_mysql_source_test_case53" value="INSERT INTO t1 VALUES ( UNHEX(&apos;0000000001070000000100000001040000000100000001020000000200000000000000&apos; &apos;000000000000000000000000000000000000F03F000000000000F03F&apos;))" db-types="MySQL"/>
+    <sql-case id="insert_by_mysql_source_test_case54" value="INSERT INTO t1 VALUES ( UNHEX(&apos;0000000001070000000100000001050000000100000001010000000000000000000000&apos; &apos;0000000000000000&apos;))" db-types="MySQL"/>
+    <sql-case id="insert_by_mysql_source_test_case55" value="INSERT INTO t1 VALUES ( UNHEX(&apos;0000000001070000000100000001060000000100000001010000000000000000000000&apos; &apos;0000000000000000&apos;))" db-types="MySQL"/>
+    <sql-case id="insert_by_mysql_source_test_case56" value="INSERT INTO t1 VALUES ( UNHEX(&apos;00000000010F0000000100000001030000000100000004000000000000000000000000&apos; &apos;00000000000000000000000000F03F0000000000000000000000000000F03F00000000&apos; &apos;0000F03F00000000000000000000000000000000&apos;))" db-types="MySQL"/>
+    <sql-case id="insert_by_mysql_source_test_case57" value="INSERT INTO t1 VALUES ( UNHEX(&apos;0000000001100000000100000001030000000100000004000000000000000000000000&apos; &apos;00000000000000000000000000F03F0000000000000000000000000000F03F00000000&apos; &apos;0000F03F00000000000000000000000000000000&apos;))" db-types="MySQL"/>
+    <sql-case id="insert_by_mysql_source_test_case58" value="INSERT INTO t1 VALUES ( UNHEX(&apos;0000000001110000000100000004000000000000000000000000000000000000000000&apos; &apos;00000000F03F0000000000000000000000000000F03F000000000000F03F0000000000&apos; &apos;0000000000000000000000&apos;))" db-types="MySQL"/>
+    <sql-case id="insert_by_mysql_source_test_case59" value="INSERT INTO t1 VALUES ( UNHEX(&apos;0000000001B90B00000000000000000000000000000000000000000000000000000000&apos; &apos;0000000000000000000000000000&apos;))" db-types="MySQL"/>
+    <sql-case id="insert_by_mysql_source_test_case60" value="INSERT INTO t1 VALUES ( UNHEX(&apos;0000000001BA0B00000200000000000000000000000000000000000000000000000000&apos; &apos;00000000000000000000000000000000F03F000000000000F03F000000000000000000&apos; &apos;00000000000000&apos;))" db-types="MySQL"/>
+    <sql-case id="insert_by_mysql_source_test_case61" value="INSERT INTO t1 VALUES ( UNHEX(&apos;0000000001BB0B00000100000004000000000000000000000000000000000000000000&apos; &apos;0000000000000000000000000000000000000000F03F00000000000000000000000000&apos; &apos;0000000000000000000000000000000000F03F000000000000F03F0000000000000000&apos; &apos;0000000000000000000000000000000000000000000000000000000000000000000000&apos; &apos;0000000000&apos;))" db-types="MySQL"/>
+    <sql-case id="insert_by_mysql_source_test_case62" value="INSERT INTO t1 VALUES ( UNHEX(&apos;0000000001BC0B00000100000001B90B00000000000000000000000000000000000000&apos; &apos;0000000000000000000000000000000000000000000000&apos;))" db-types="MySQL"/>
+    <sql-case id="insert_by_mysql_source_test_case63" value="INSERT INTO t1 VALUES ( UNHEX(&apos;0000000001BD0B00000100000001BA0B00000200000000000000000000000000000000&apos; &apos;00000000000000000000000000000000000000000000000000F03F000000000000F03F&apos; &apos;00000000000000000000000000000000&apos;))" db-types="MySQL"/>
+    <sql-case id="insert_by_mysql_source_test_case64" value="INSERT INTO t1 VALUES ( UNHEX(&apos;0000000001BE0B00000100000001BB0B00000100000004000000000000000000000000&apos; &apos;0000000000000000000000000000000000000000000000000000000000F03F00000000&apos; &apos;0000000000000000000000000000000000000000000000000000F03F000000000000F0&apos; &apos;3F00000000000000000000000000000000000000000000000000000000000000000000&apos; &apos;0000000000000000000000000000&apos;))" db-types="MySQL"/>
+    <sql-case id="insert_by_mysql_source_test_case65" value="INSERT INTO t1 VALUES ( UNHEX(&apos;0000000001BF0B00000100000001B90B00000000000000000000000000000000000000&apos; &apos;0000000000000000000000000000000000000000000000&apos;))" db-types="MySQL"/>
+    <sql-case id="insert_by_mysql_source_test_case66" value="INSERT INTO t1 VALUES ( UNHEX(&apos;0000000001C70B00000100000001BB0B00000100000004000000000000000000000000&apos; &apos;0000000000000000000000000000000000000000000000000000000000F03F00000000&apos; &apos;0000000000000000000000000000000000000000000000000000F03F000000000000F0&apos; &apos;3F00000000000000000000000000000000000000000000000000000000000000000000&apos; &apos;0000000000000000000000000000&apos;))" db-types="MySQL"/>
+    <sql-case id="insert_by_mysql_source_test_case67" value="INSERT INTO t1 VALUES ( UNHEX(&apos;0000000001C80B00000100000001BB0B00000100000004000000000000000000000000&apos; &apos;0000000000000000000000000000000000000000000000000000000000F03F00000000&apos; &apos;0000000000000000000000000000000000000000000000000000F03F000000000000F0&apos; &apos;3F00000000000000000000000000000000000000000000000000000000000000000000&apos; &apos;0000000000000000000000000000&apos;))" db-types="MySQL"/>
+    <sql-case id="insert_by_mysql_source_test_case68" value="INSERT INTO t1 VALUES ( UNHEX(&apos;0000000001C90B00000100000001EB0300000100000004000000000000000000000000&apos; &apos;000000000000000000000000000000000000000000F03F000000000000000000000000&apos; &apos;00000000000000000000F03F000000000000F03F000000000000000000000000000000&apos; &apos;0000000000000000000000000000000000&apos;))" db-types="MySQL"/>
+    <sql-case id="insert_by_mysql_source_test_case69" value="INSERT INTO t1 VALUES ( UNHEX(&apos;0000000001D20700000200000000000000000000000000000000000000000000000000&apos; &apos;0000000000000000F03F000000000000F03F0000000000000000&apos;))" db-types="MySQL"/>
+    <sql-case id="insert_by_mysql_source_test_case70" value="INSERT INTO t1 VALUES ( UNHEX(&apos;0000000001D30700000100000004000000000000000000000000000000000000000000&apos; &apos;000000000000000000000000F03F000000000000000000000000000000000000000000&apos; &apos;00F03F000000000000F03F000000000000000000000000000000000000000000000000&apos; &apos;0000000000000000&apos;))" db-types="MySQL"/>
+    <sql-case id="insert_by_mysql_source_test_case71" value="INSERT INTO t1 VALUES ( UNHEX(&apos;0000000001D40700000100000001E90300000000000000000000000000000000000000&apos; &apos;00000000000000&apos;))" db-types="MySQL"/>
+    <sql-case id="insert_by_mysql_source_test_case72" value="INSERT INTO t1 VALUES ( UNHEX(&apos;0000000001D5070000010000000000000001EA03000002000000000000000000000000&apos; &apos;000000000000000000000000000000000000000000F03F000000000000F03F00000000&apos; &apos;00000000&apos;))" db-types="MySQL"/>
+    <sql-case id="insert_by_mysql_source_test_case73" value="INSERT INTO t1 VALUES ( UNHEX(&apos;0000000001D60700000100000001EB0300000100000004000000000000000000000000&apos; &apos;000000000000000000000000000000000000000000F03F000000000000000000000000&apos; &apos;00000000000000000000F03F000000000000F03F000000000000000000000000000000&apos; &apos;0000000000000000000000000000000000&apos;))" db-types="MySQL"/>
+    <sql-case id="insert_by_mysql_source_test_case74" value="INSERT INTO t1 VALUES ( UNHEX(&apos;0000000001D70700000100000001E90300000000000000000000000000000000000000&apos; &apos;00000000000000&apos;))" db-types="MySQL"/>
+    <sql-case id="insert_by_mysql_source_test_case75" value="INSERT INTO t1 VALUES ( UNHEX(&apos;0000000001DF0700000100000001EB0300000100000004000000000000000000000000&apos; &apos;000000000000000000000000000000000000000000F03F000000000000000000000000&apos; &apos;00000000000000000000F03F000000000000F03F000000000000000000000000000000&apos; &apos;0000000000000000000000000000000000&apos;))" db-types="MySQL"/>
+    <sql-case id="insert_by_mysql_source_test_case76" value="INSERT INTO t1 VALUES ( UNHEX(&apos;0000000001E00700000100000001EB0300000100000004000000000000000000000000&apos; &apos;000000000000000000000000000000000000000000F03F000000000000000000000000&apos; &apos;00000000000000000000F03F000000000000F03F000000000000000000000000000000&apos; &apos;0000000000000000000000000000000000&apos;))" db-types="MySQL"/>
+    <sql-case id="insert_by_mysql_source_test_case77" value="INSERT INTO t1 VALUES ( UNHEX(&apos;0000000001E10700000100000001EB0300000100000004000000000000000000000000&apos; &apos;000000000000000000000000000000000000000000F03F000000000000000000000000&apos; &apos;00000000000000000000F03F000000000000F03F000000000000000000000000000000&apos; &apos;0000000000000000000000000000000000&apos;))" db-types="MySQL"/>
+    <sql-case id="insert_by_mysql_source_test_case78" value="INSERT INTO t1 VALUES ( UNHEX(&apos;0000000001EA0300000200000000000000000000000000000000000000000000000000&apos; &apos;0000000000000000F03F000000000000F03F0000000000000000&apos;))" db-types="MySQL"/>
+    <sql-case id="insert_by_mysql_source_test_case79" value="INSERT INTO t1 VALUES ( UNHEX(&apos;0000000001EB0300000100000004000000000000000000000000000000000000000000&apos; &apos;000000000000000000000000F03F000000000000000000000000000000000000000000&apos; &apos;00F03F000000000000F03F000000000000000000000000000000000000000000000000&apos; &apos;0000000000000000&apos;))" db-types="MySQL"/>
+    <sql-case id="insert_by_mysql_source_test_case80" value="INSERT INTO t1 VALUES ( UNHEX(&apos;0000000001EC0300000100000001E90300000000000000000000000000000000000000&apos; &apos;00000000000000&apos;))" db-types="MySQL"/>
+    <sql-case id="insert_by_mysql_source_test_case81" value="INSERT INTO t1 VALUES ( UNHEX(&apos;0000000001ED030000010000000000000001EA03000002000000000000000000000000&apos; &apos;000000000000000000000000000000000000000000F03F000000000000F03F00000000&apos; &apos;00000000&apos;))" db-types="MySQL"/>
+    <sql-case id="insert_by_mysql_source_test_case82" value="INSERT INTO t1 VALUES ( UNHEX(&apos;0000000001EE0300000100000001EB0300000100000004000000000000000000000000&apos; &apos;000000000000000000000000000000000000000000F03F000000000000000000000000&apos; &apos;00000000000000000000F03F000000000000F03F000000000000000000000000000000&apos; &apos;0000000000000000000000000000000000&apos;))" db-types="MySQL"/>
+    <sql-case id="insert_by_mysql_source_test_case83" value="INSERT INTO t1 VALUES ( UNHEX(&apos;0000000001EF0300000100000001E90300000000000000000000000000000000000000&apos; &apos;00000000000000&apos;))" db-types="MySQL"/>
+    <sql-case id="insert_by_mysql_source_test_case84" value="INSERT INTO t1 VALUES ( UNHEX(&apos;0000000001F70300000100000001EB0300000100000004000000000000000000000000&apos; &apos;000000000000000000000000000000000000000000F03F000000000000000000000000&apos; &apos;00000000000000000000F03F000000000000F03F000000000000000000000000000000&apos; &apos;0000000000000000000000000000000000&apos;))" db-types="MySQL"/>
+    <sql-case id="insert_by_mysql_source_test_case85" value="INSERT INTO t1 VALUES ( UNHEX(&apos;0000000001F80300000100000001EB0300000100000004000000000000000000000000&apos; &apos;000000000000000000000000000000000000000000F03F000000000000000000000000&apos; &apos;00000000000000000000F03F000000000000F03F000000000000000000000000000000&apos; &apos;0000000000000000000000000000000000&apos;))" db-types="MySQL"/>
+    <sql-case id="insert_by_mysql_source_test_case86" value="INSERT INTO t1 VALUES ( UNHEX(&apos;0000000001F90300000100000001EB0300000100000004000000000000000000000000&apos; &apos;000000000000000000000000000000000000000000F03F000000000000000000000000&apos; &apos;00000000000000000000F03F000000000000F03F000000000000000000000000000000&apos; &apos;0000000000000000000000000000000000&apos;))" db-types="MySQL"/>
+    <sql-case id="insert_by_mysql_source_test_case87" value="INSERT INTO t1 VALUES ( repeat( &apos;a&apos;, 10 ), 1), ( repeat( &apos;b&apos;, 10 ), 2)" db-types="MySQL"/>
+    <sql-case id="insert_by_mysql_source_test_case88" value="INSERT INTO t1 VALUES ( repeat( &apos;a&apos;, 10 ), 1), ( repeat( &apos;b&apos;, 10 ), 2)" db-types="MySQL"/>
+    <sql-case id="insert_by_mysql_source_test_case89" value="INSERT INTO t1 VALUES ( repeat( &apos;a&apos;, 16384 ) )" db-types="MySQL"/>
+    <sql-case id="insert_by_mysql_source_test_case90" value="INSERT INTO t1 VALUES (1, REPEAT(&quot;a&quot;, 8192))" db-types="MySQL"/>
+    <sql-case id="insert_by_mysql_source_test_case91" value="INSERT INTO t1 VALUES (1, REPEAT(&apos;a&apos;, 10))" db-types="MySQL"/>
+    <sql-case id="insert_by_mysql_source_test_case92" value="INSERT INTO t1 VALUES (1, REPEAT(&apos;a&apos;,59), REPEAT(&apos;a&apos;,512))" db-types="MySQL"/>
+    <sql-case id="insert_by_mysql_source_test_case93" value="INSERT INTO t1 VALUES (1,CONCAT(REPEAT(&apos;_&apos;, 250), &quot;qq&quot;)), (1,CONCAT(REPEAT(&apos;_&apos;, 250), &quot;zz&quot;)), (1,CONCAT(REPEAT(&apos;_&apos;, 250), &quot;aa&quot;)), (1,CONCAT(REPEAT(&apos;_&apos;, 250), &quot;ff&quot;))" db-types="MySQL"/>
+    <sql-case id="insert_by_mysql_source_test_case94" value="INSERT INTO t1 VALUES (1,REPEAT(CONCAT(&apos;A&apos;,CAST(CHAR(0) AS BINARY),&apos;B&apos;), 40000))" db-types="MySQL"/>
+    <sql-case id="insert_by_mysql_source_test_case95" value="INSERT INTO t1 VALUES (10, REPEAT(&apos;a&apos;, CEIL(RAND(10) * 300))), (11, REPEAT(&apos;b&apos;, CEIL(RAND() * 300))), (12, REPEAT(&apos;c&apos;, CEIL(RAND() * 300))), (13, REPEAT(&apos;d&apos;, CEIL(RAND() * 300))), (14, REPEAT(&apos;e&apos;, CEIL(RAND() * 300))), (15, REPEAT(&apos;f&apos;, CEIL(RAND() * 300))), (16, REPEAT(&apos;g&apos;, CEIL(RAND() * 300))), (17, REPEAT(&apos;h&apos;, CEIL(RAND() * 300))), (18, REPEAT(&ap [...]
+    <sql-case id="insert_by_mysql_source_test_case96" value="INSERT INTO t1 VALUES (101, REPEAT(&apos;ab&apos;, @max_allowed_packet))" db-types="MySQL"/>
+    <sql-case id="insert_by_mysql_source_test_case97" value="INSERT INTO t1 VALUES (101, REPEAT(&apos;ab&apos;, @max_allowed_packet))" db-types="MySQL"/>
+    <sql-case id="insert_by_mysql_source_test_case98" value="INSERT INTO t1 VALUES (2, REPEAT(&quot;b&quot;, 8192))" db-types="MySQL"/>
+    <sql-case id="insert_by_mysql_source_test_case99" value="INSERT INTO t1 VALUES (2, REPEAT(&apos;a&apos;,59), REPEAT(&apos;a&apos;,512))" db-types="MySQL"/>
+    <sql-case id="insert_by_mysql_source_test_case100" value="INSERT INTO t1 VALUES (3, REPEAT(&quot;c&quot;, 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(&quot;a&quot;,100))" db-types="MySQL"/>
+    <sql-case id="insert_by_mysql_source_test_case104" value="INSERT INTO t1 VALUES (REPEAT(&apos;1&apos;,200))" db-types="MySQL"/>
+    <sql-case id="insert_by_mysql_source_test_case105" value="INSERT INTO t1 VALUES (REPEAT(&apos;2&apos;, 1800))" db-types="MySQL"/>
+    <sql-case id="insert_by_mysql_source_test_case106" value="INSERT INTO t1 VALUES (REPEAT(&apos;A&apos;, 50000)), (REPEAT(&apos;A&apos;, 50000))" db-types="MySQL"/>
+    <sql-case id="insert_by_mysql_source_test_case107" value="INSERT INTO t1 VALUES (REPEAT(&apos;ManyMegaByteBlck&apos;, 2097152))" db-types="MySQL"/>
+    <sql-case id="insert_by_mysql_source_test_case108" value="INSERT INTO t1 VALUES (REPEAT(&apos;ManyMegaByteBlck&apos;, 262144))" db-types="MySQL"/>
+    <sql-case id="insert_by_mysql_source_test_case109" value="INSERT INTO t1 VALUES (REPEAT(&apos;ManyMegaByteBlck&apos;, 32768))" db-types="MySQL"/>
+    <sql-case id="insert_by_mysql_source_test_case110" value="INSERT INTO t1 VALUES (REPEAT(&apos;ManyMegaByteBlck&apos;, 4194304))" db-types="MySQL"/>
+    <sql-case id="insert_by_mysql_source_test_case111" value="INSERT INTO t1 VALUES (REPEAT(&apos;a&apos;, 499999), 3), (REPEAT(&apos;b&apos;, 500000), 4)" db-types="MySQL"/>
+    <sql-case id="insert_by_mysql_source_test_case112" value="INSERT INTO t1 VALUES (REPEAT(&apos;a&apos;, 500000), 0), (REPEAT(&apos;b&apos;, 500000), 1), (REPEAT(&apos;c&apos;, 500000), 2)" db-types="MySQL"/>
+    <sql-case id="insert_by_mysql_source_test_case113" value="INSERT INTO t1 VALUES (REPEAT(&apos;x&apos;, 4096), REPEAT(&apos;x&apos;, 4096), REPEAT(&apos;x&apos;, 4096), REPEAT(&apos;x&apos;, 4096), REPEAT(&apos;x&apos;, 4096), REPEAT(&apos;x&apos;, 4096), REPEAT(&apos;x&apos;, 4096), REPEAT(&apos;x&apos;, 4096), REPEAT(&apos;x&apos;, 4096), REPEAT(&apos;x&apos;, 4096), 1, REPEAT(&apos;x&apos;, 4096), REPEAT(&apos;x&apos;, 4096), REPEAT(&apos;x&apos;, 4096), REPEAT(&apos;x&apos;, 4096) [...]
+    <sql-case id="insert_by_mysql_source_test_case114" value="INSERT INTO t1 VALUES (REPEAT(&apos;x&apos;, 4096), REPEAT(&apos;x&apos;, 4096), REPEAT(&apos;x&apos;, 4096), REPEAT(&apos;x&apos;, 4096), REPEAT(&apos;x&apos;, 4096), REPEAT(&apos;x&apos;, 4096), REPEAT(&apos;x&apos;, 4096), REPEAT(&apos;x&apos;, 4096), REPEAT(&apos;x&apos;, 4096), REPEAT(&apos;x&apos;, 4096), 2, REPEAT(&apos;x&apos;, 4096), REPEAT(&apos;x&apos;, 4096), REPEAT(&apos;x&apos;, 4096), REPEAT(&apos;x&apos;, 4096) [...]
+    <sql-case id="insert_by_mysql_source_test_case115" value="INSERT INTO t1 VALUES (REPEAT(&apos;x&apos;, 4096), REPEAT(&apos;x&apos;, 4096), REPEAT(&apos;x&apos;, 4096), REPEAT(&apos;x&apos;, 4096), REPEAT(&apos;x&apos;, 4096), REPEAT(&apos;x&apos;, 4096), REPEAT(&apos;x&apos;, 4096), REPEAT(&apos;x&apos;, 4096), REPEAT(&apos;x&apos;, 4096), REPEAT(&apos;x&apos;, 4096), 3, REPEAT(&apos;x&apos;, 4096), REPEAT(&apos;x&apos;, 4096), REPEAT(&apos;x&apos;, 4096), REPEAT(&apos;x&apos;, 4096) [...]
+    <sql-case id="insert_by_mysql_source_test_case116" value="INSERT INTO t1 VALUES (REPEAT(0x1125,200000), REPEAT(0x1125,200000)), (&apos;&apos;, &apos;&apos;), (&apos;&apos;, &apos;&apos;)" db-types="MySQL"/>
+    <sql-case id="insert_by_mysql_source_test_case117" value="INSERT INTO t1 VALUES (REPEAT(0x1125,200000), REPEAT(0x1125,200000)), (&apos;&apos;, &apos;&apos;), (&apos;&apos;, &apos;&apos;)" 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&apos;&apos;)" db-types="MySQL"/>
+    <sql-case id="insert_by_mysql_source_test_case122" value="INSERT INTO t1 VALUES (b&apos;&apos;, b&apos;&apos;)" db-types="MySQL"/>
+    <sql-case id="insert_by_mysql_source_test_case123" value="INSERT INTO t1 VALUES (concat(repeat(&apos;MySQL&apos;,100),&apos;1&apos;),repeat(&apos;0&apos;,257))" db-types="MySQL"/>
+    <sql-case id="insert_by_mysql_source_test_case124" value="INSERT INTO t1 VALUES (concat(repeat(&apos;MySQL&apos;,100),&apos;2&apos;),repeat(&apos;0&apos;,257))" db-types="MySQL"/>
+    <sql-case id="insert_by_mysql_source_test_case125" value="INSERT INTO t1 VALUES (concat(repeat(&apos;MySQL&apos;,100),&apos;3&apos;),repeat(&apos;0&apos;,257))" db-types="MySQL"/>
+    <sql-case id="insert_by_mysql_source_test_case126" value="INSERT INTO t1 VALUES (repeat(&apos;1&apos;, 1300),&apos;one&apos;), (repeat(&apos;1&apos;, 1300),&apos;two&apos;)" db-types="MySQL"/>
+    <sql-case id="insert_by_mysql_source_test_case127" value="INSERT INTO t1 VALUES (repeat(&apos;1&apos;, 1300),&apos;one&apos;), (repeat(&apos;1&apos;, 1300),&apos;two&apos;)" db-types="MySQL"/>
+    <sql-case id="insert_by_mysql_source_test_case128" value="INSERT INTO t1 VALUES(&apos;a&apos;,&apos;aa&apos;,REPEAT(&apos;a&apos;, 256)),(&apos;a&apos;,&apos;aa&apos;,REPEAT(&apos;a&apos;,256))" db-types="MySQL"/>
+    <sql-case id="insert_by_mysql_source_test_case129" value="INSERT INTO t1 VALUES(1,repeat(&apos;a&apos;,1000)),(2,repeat(&apos;def&apos;,600))" db-types="MySQL"/>
+    <sql-case id="insert_by_mysql_source_test_case130" value="INSERT INTO t1 VALUES(REPEAT(&quot;a&quot;,128), &apos;b&apos;)" db-types="MySQL"/>
+    <sql-case id="insert_by_mysql_source_test_case131" value="INSERT INTO t1 VALUES(REPEAT(&quot;a&quot;,128), &apos;b&apos;)" db-types="MySQL"/>
+    <sql-case id="insert_by_mysql_source_test_case132" value="INSERT INTO t1 VALUES(REPEAT(&quot;a&quot;,128), &apos;b&apos;)" db-types="MySQL"/>
+    <sql-case id="insert_by_mysql_source_test_case133" value="INSERT INTO t1 VALUES(REPEAT(_utf8 x&apos;e0ae85&apos;,43), &apos;b&apos;)" db-types="MySQL"/>
+    <sql-case id="insert_by_mysql_source_test_case134" value="INSERT INTO t1 VALUES(REPEAT(_utf8 x&apos;e0ae85&apos;,43), &apos;b&apos;)" db-types="MySQL"/>
+    <sql-case id="insert_by_mysql_source_test_case135" value="INSERT INTO t1 VALUES(REPEAT(_utf8 x&apos;e0ae85&apos;,43), &apos;b&apos;)" 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(&apos;a&apos;,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(&apos;A&apos;, 512), REPEAT(&apos;B&apos;, 512))" db-types="MySQL"/>
+    <sql-case id="insert_by_mysql_source_test_case143" value="INSERT INTO t2 (a, b) VALUES (REPEAT(&apos;a&apos;, 10000), REPEAT(&apos;b&apos;, 10000))" db-types="MySQL"/>
+    <sql-case id="insert_by_mysql_source_test_case144" value="INSERT INTO t2 (a, b) VALUES (REPEAT(&apos;a&apos;, 512), REPEAT(&apos;b&apos;, 512))" db-types="MySQL"/>
+    <sql-case id="insert_by_mysql_source_test_case145" value="INSERT INTO t2 VALUES ( NULL, repeat(&apos;x&apos;, 600), 3, repeat(&apos;y&apos;, 600), repeat(&apos;z&apos;, 600) )" db-types="MySQL"/>
+    <sql-case id="insert_by_mysql_source_test_case146" value="INSERT INTO t2 VALUES (&apos;MFDLE&apos;,1,&apos;no&apos;,1358168064), (&apos;v&apos;,2,&apos;really&apos;,154664960), (repeat(&apos;mcrxjxxfpo&apos;,100),3,repeat(&apos;mcrxjxxfpo&apos;,100),1), (&apos;o&apos;,4,&apos;CEJHM&apos;,3), (&apos;j&apos;,5,&apos;CRDLM&apos;,174915584), (&apos;m&apos;,6,&apos;that\&apos;s&apos;,7), (&apos;YVMBM&apos;,7,&apos;is&apos;,4), (&apos;h&apos;,8,&apos;as&apos;,8), (&apos;y&apos;,9,&apos;not [...]
+    <sql-case id="insert_by_mysql_source_test_case147" value="INSERT INTO t2 VALUES( REPEAT( &apos;a&apos;, 5000 ) )" db-types="MySQL"/>
+    <sql-case id="insert_by_mysql_source_test_case148" value="INSERT INTO t2 VALUES( REPEAT( &apos;a&apos;, 5000 ) )" db-types="MySQL"/>
+    <sql-case id="insert_by_mysql_source_test_case149" value="INSERT INTO t2 VALUES( REPEAT( &apos;b&apos;, 5000 ) )" db-types="MySQL"/>
+    <sql-case id="insert_by_mysql_source_test_case150" value="INSERT INTO t3 VALUES( REPEAT( &apos;a&apos;, 65534 ), 1 )" db-types="MySQL"/>
+    <sql-case id="insert_by_mysql_source_test_case151" value="INSERT INTO t3 VALUES( REPEAT( &apos;a&apos;, 65535 ), 2 )" db-types="MySQL"/>
+    <sql-case id="insert_by_mysql_source_test_case152" value="INSERT INTO t4 SELECT c31, CONCAT(c32, REPEAT(&apos;a&apos;, @max_allowed_packet-1)) FROM t3" db-types="MySQL"/>
+    <sql-case id="insert_by_mysql_source_test_case153" value="INSERT INTO test.proc VALUES (&apos;sp&apos;,&apos;bug24805140&apos;,&apos;PROCEDURE&apos;,&apos;bug24805140&apos;,&apos;SQL&apos;, &apos;CONTAINS_SQL&apos;,&apos;NO&apos;,&apos;DEFINER&apos;,&apos;out a int&apos;,&apos;&apos;, &apos;begin select requesting_trx_id from &apos; &apos;information_schema.INNODB_LOCK_WAITS limit 1 into a; end&apos;, &apos;root@localhost&apos;,&apos;2016-10-05 21:44:21&apos;, &apos;2016-10-05 21:44: [...]
+    <sql-case id="insert_by_mysql_source_test_case154" value="INSERT into at(_bin,_blb) VALUES(&apos;c8eb4b15cb0948bb&apos;,&apos;c8eb4b15cb0948bb&apos;)" db-types="MySQL"/>
+    <sql-case id="insert_by_mysql_source_test_case155" value="insert ignore t1 values (1, repeat(&apos;a&apos;,210), repeat(&apos;b&apos;, 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 &apos;blah&apos;" 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(&apos;a&apos;,100)),(repeat(&apos;b&apos;,100)),(repeat(&apos;c&apos;,100))" db-types="MySQL"/>
+    <sql-case id="insert_by_mysql_source_test_case161" value="insert into t1 (b) values (repeat(&apos;z&apos;,100))" db-types="MySQL"/>
+    <sql-case id="insert_by_mysql_source_test_case162" value="insert into t1 (binarycol) values (repeat(&apos;x&apos;,256))" db-types="MySQL"/>
+    <sql-case id="insert_by_mysql_source_test_case163" value="insert into t1 (charcol) values (repeat(&apos;x&apos;,256))" db-types="MySQL"/>
+    <sql-case id="insert_by_mysql_source_test_case164" value="insert into t1 (tinyblobcol) values (repeat(&apos;x&apos;,256))" db-types="MySQL"/>
+    <sql-case id="insert_by_mysql_source_test_case165" value="insert into t1 (tinytextcol) values (repeat(&apos;x&apos;,256))" db-types="MySQL"/>
+    <sql-case id="insert_by_mysql_source_test_case166" value="insert into t1 (varbinarycol) values (repeat(&apos;x&apos;,256))" db-types="MySQL"/>
+    <sql-case id="insert_by_mysql_source_test_case167" value="insert into t1 (varcharcol) values (repeat(&apos;x&apos;,256))" db-types="MySQL"/>
+    <sql-case id="insert_by_mysql_source_test_case168" value="insert into t1 values (1, concat(repeat(&apos;1&apos;, 300), &apos;2&apos;)), (1, concat(repeat(&apos;1&apos;, 300), &apos;2&apos;)), (1, concat(repeat(&apos;0&apos;, 300), &apos;1&apos;)), (2, concat(repeat(&apos;1&apos;, 300), &apos;2&apos;)), (2, concat(repeat(&apos;1&apos;, 300), &apos;2&apos;)), (2, concat(repeat(&apos;0&apos;, 300), &apos;1&apos;))" db-types="MySQL"/>
+    <sql-case id="insert_by_mysql_source_test_case169" value="insert into t1 values (1,repeat(&apos;a&apos;,255)),(2,repeat(&apos;b&apos;,255))" db-types="MySQL"/>
+    <sql-case id="insert_by_mysql_source_test_case170" value="insert into t1 values (1,repeat(&apos;a&apos;,255)),(2,repeat(&apos;b&apos;,255))" db-types="MySQL"/>
+    <sql-case id="insert_by_mysql_source_test_case171" value="insert into t1 values (repeat(&quot;1&quot;,200))" db-types="MySQL"/>
+    <sql-case id="insert_by_mysql_source_test_case172" value="insert into t1 values (repeat(&apos;a&apos;, 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(&apos;a&apos;,333)), (repeat(&apos;b&apos;,333))" db-types="MySQL"/>
+    <sql-case id="insert_by_mysql_source_test_case174" value="insert into t1 values (repeat(&apos;b&apos;,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(&apos;a&apos;,65530))" db-types="MySQL"/>
+    <sql-case id="insert_by_mysql_source_test_case185" value="insert into t2 select x3.a,  -- 3 concat(&apos;val-&apos;, x3.a + 3*x4.a), -- 12 concat(&apos;val-&apos;, @a:=x3.a + 3*x4.a + 12*C.a), -- 120 concat(&apos;val-&apos;, @a + 120*D.a) from t1 x3, t1 x4, t1 C, t1 D where x3.a &lt; 3 and x4.a &lt; 4 and D.a &lt; 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 = &apos;YES&apos; WHERE name = &apos;wait/lock/metadata/sql/mdl&apos;" db-types="MySQL"/>
+    <sql-case id="update_by_mysql_source_test_case2" value="UPDATE /*+ SET_VAR(time_zone = &apos;UTC&apos;) */ 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(&apos;ab&apos;, @max_allowed_packet)" db-types="MySQL"/>
+    <sql-case id="update_by_mysql_source_test_case4" value="UPDATE IGNORE t1 set data=repeat(&apos;a&apos;,18*1024*1024)" db-types="MySQL"/>
+    <sql-case id="update_by_mysql_source_test_case5" value="UPDATE IGNORE t1, t2 SET c12= REPEAT(&apos;ab&apos;, @max_allowed_packet), c22= &apos;ab&apos;" db-types="MySQL"/>
+    <sql-case id="update_by_mysql_source_test_case6" value="UPDATE t1 LEFT JOIN t2 USING(id) SET t2.c = REPEAT(&apos;1&apos;, 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(&apos;a&apos;, 600) where a=11" db-types="MySQL"/>
+    <sql-case id="update_by_mysql_source_test_case9" value="UPDATE t1 SET b=repeat(&apos;a&apos;, 800) where a=10" db-types="MySQL"/>
+    <sql-case id="update_by_mysql_source_test_case10" value="UPDATE t1 SET c12= REPEAT(&apos;ab&apos;, @max_allowed_packet)" db-types="MySQL"/>
+    <sql-case id="update_by_mysql_source_test_case11" value="UPDATE t1 SET c12= REPEAT(&apos;ab&apos;, @max_allowed_packet)" db-types="MySQL"/>
+    <sql-case id="update_by_mysql_source_test_case12" value="UPDATE t1 set data=repeat(&apos;a&apos;,18*1024*1024)" db-types="MySQL"/>
+    <sql-case id="update_by_mysql_source_test_case13" value="UPDATE t1 set data=repeat(&apos;c&apos;,17*1024*1024)" db-types="MySQL"/>
+    <sql-case id="update_by_mysql_source_test_case14" value="UPDATE t1, t2 SET c12= REPEAT(&apos;ab&apos;, @max_allowed_packet), c22= &apos;ab&apos;" db-types="MySQL"/>
+    <sql-case id="update_by_mysql_source_test_case15" value="UPDATE t2 SET c = REPEAT(&apos;1&apos;, 70000)" db-types="MySQL"/>
+    <sql-case id="update_by_mysql_source_test_case16" value="UPDATE t3 SET c32= CONCAT(c32, REPEAT(&apos;a&apos;, @max_allowed_packet-1))" db-types="MySQL"/>
+    <sql-case id="update_by_mysql_source_test_case17" value="update t1 set b=repeat(&apos;a&apos;,256)" db-types="MySQL"/>
+    <sql-case id="update_by_mysql_source_test_case18" value="update t1 set b=repeat(&apos;e&apos;,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 = &apos;UTC&apos;) */ 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 &lt; 8" db-types="MySQL"/>
+    <sql-case id="delete_by_mysql_source_test_case3" value="DELETE FROM t1 WHERE _id &lt; 8" db-types="MySQL"/>
+    <sql-case id="delete_by_mysql_source_test_case4" value="DELETE FROM t1 WHERE c12 &lt;=&gt; REPEAT(&apos;ab&apos;, @max_allowed_packet)" db-types="MySQL"/>
+    <sql-case id="delete_by_mysql_source_test_case5" value="DELETE FROM t1 WHERE c12 &lt;=&gt; REPEAT(&apos;ab&apos;, @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 &lt;=&gt; REPEAT(&apos;ab&apos;, @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 &lt;=&gt; REPEAT(&apos;ab&apos;, @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&apos;mysqltest_1&apos;" db-types="MySQL"/>
+    <sql-case id="delete_by_mysql_source_test_case12" value="delete from mysql.user where user=_binary&apos;mysqltest_1&apos;" db-types="MySQL"/>
 </sql-cases>