mvzink opened a new issue, #1694:
URL: https://github.com/apache/datafusion-sqlparser-rs/issues/1694
In addition to `SESSION` and `LOCAL` qualifiers, MySQL allows `GLOBAL` for
modifying system variables:
```
mysql> SET GLOBAL max_connections = 1000;
Query OK, 0 rows affected (0.00 sec)
```
sqlparser currently interprets `global` as a variable name and fails to
parse:
```
$ echo -n "SET GLOBAL max_connections = 1000;" | cargo run --example cli -
--mysql
Finished `dev` profile [unoptimized + debuginfo] target(s) in 0.02s
Running `target/debug/examples/cli - --mysql`
Parsing from stdin using MySqlDialect
2025-01-31T00:44:22.858Z DEBUG [sqlparser::parser] Parsing sql 'SET GLOBAL
max_connections = 1000;'...
Error during parsing: ParserError("Expected: equals sign or TO, found:
max_connections at Line: 1, Column: 12")
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
