We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Describe the bug When I parse the following SQL witch use COLLATE utf8mb4_general_ci , it will throw an error:
COLLATE utf8mb4_general_ci
[SyntaxError]: Expected "#", "--", "/*", ";", "FOR", "GO", "INTERSECT", "INTO", "LIMIT", "LOCK", "MINUS", "ORDER", "UNION", "WINDOW", [ \t\n\r], [A-Za-z0-9_$\x80-�], or end of input but "." found.
Database Engine MySQL
To Reproduce -the SQL that be parsed
const { Parser } = require('node-sql-parser'); const parser = new Parser(); const sql = ` SELECT users.id FROM users LEFT JOIN orders ON users.id COLLATE utf8mb4_general_ci = orders.user_id; `; const ast = parser.astify(sql);
-the node-sql-parser version 5.3.5 -the node version
Expected behavior This is a valid SQL statement and should be parsed correctly.
The text was updated successfully, but these errors were encountered:
taozhi8833998
Successfully merging a pull request may close this issue.
Describe the bug
When I parse the following SQL witch use
COLLATE utf8mb4_general_ci
, it will throw an error:Database Engine
MySQL
To Reproduce
-the SQL that be parsed
-the node-sql-parser version
5.3.5
-the node version
Expected behavior
This is a valid SQL statement and should be parsed correctly.
The text was updated successfully, but these errors were encountered: