文件lexer_quotes在mysql计算节点上出现的错误

[jd-zhang]

*Issue migrated from trac ticket # 899 www.kunlunbase.com *

component: computing nodes | priority: major

2022-07-12 17:44:11: vito@zettadb.com created the issue

---

多个语句当做成一个语句

select """;
select """";
select """"";

+-------------------------+
| ?column?                |
+-------------------------+
| ";
select "";
select "" |
+-------------------------+
1 row in set (0.00 sec)

select ''';
select '''';
select *'*;

+-------------------------+
| ?column?                |
+-------------------------+
| ';
select '';
select '' |
+-------------------------+
1 row in set (0.00 sec)

select """'''"";
select """'''\"'";
select *'"""*;

+--------------------------------+
| ?column?                       |
+--------------------------------+
| "'''";
select "'";
select '''" |
+--------------------------------+
1 row in set (0.00 sec)

列名不同,空值与0的不同
select '\n','\t','\0','\1','\a','\j';

+----------+----------+----------+----------+----------+----------+
| ?column? | ?column? | ?column? | ?column? | ?column? | ?column? |
+----------+----------+----------+----------+----------+----------+
|
        |               | \0       | \1       | a        | j        |
+----------+----------+----------+----------+----------+----------+
1 row in set (0.00 sec)

预期:

+---+---+---+---+---+---+
|   |   |   | 1 | a | j |
+---+---+---+---+---+---+
|
 |       |   | 1 | a | j |
+---+---+---+---+---+---+

create view "t""1" as select*from t1;
drop view "t""1";

ERROR 1149 (42000): syntax error at or near ""t""1"" at character: 13

FILE:  scan.l    LINE: 1488     FUNCTION:  scanner_yyerror