wugeer opened a new issue, #1471: URL: https://github.com/apache/datafusion-sqlparser-rs/issues/1471
Hive supports `!` as a synonym for `not`, but the current project's Hive dialect supports the `select !a` syntax. https://cwiki.apache.org/confluence/pages/viewpage.action?pageId=27362046#LanguageManualUDF-LogicalOperators  The reproduction steps are as follows: ```bash echo "select not (false), !a" > ok.sql cargo run --features json_example --example cli ok.sql --hive Finished `dev` profile [unoptimized + debuginfo] target(s) in 0.02s Running `target/debug/examples/cli ok.sql --hive` Parsing from file 'ok.sql' using HiveDialect 2024-10-12T07:25:23.412Z DEBUG [sqlparser::parser] Parsing sql 'select not (false), !a '... 2024-10-12T07:25:23.412Z DEBUG [sqlparser::parser] parsing expr 2024-10-12T07:25:23.412Z DEBUG [sqlparser::parser] parsing expr 2024-10-12T07:25:23.412Z DEBUG [sqlparser::parser] parsing expr 2024-10-12T07:25:23.412Z DEBUG [sqlparser::parser] prefix: Value(Boolean(false)) 2024-10-12T07:25:23.412Z DEBUG [sqlparser::dialect] get_next_precedence_full() TokenWithLocation { token: RParen, location: Location { line: 1, column: 18 } } 2024-10-12T07:25:23.412Z DEBUG [sqlparser::parser] next precedence: 0 2024-10-12T07:25:23.412Z DEBUG [sqlparser::parser] prefix: Nested(Value(Boolean(false))) 2024-10-12T07:25:23.412Z DEBUG [sqlparser::dialect] get_next_precedence_full() TokenWithLocation { token: Comma, location: Location { line: 1, column: 19 } } 2024-10-12T07:25:23.412Z DEBUG [sqlparser::parser] next precedence: 0 2024-10-12T07:25:23.412Z DEBUG [sqlparser::parser] prefix: UnaryOp { op: Not, expr: Nested(Value(Boolean(false))) } 2024-10-12T07:25:23.413Z DEBUG [sqlparser::dialect] get_next_precedence_full() TokenWithLocation { token: Comma, location: Location { line: 1, column: 19 } } 2024-10-12T07:25:23.413Z DEBUG [sqlparser::parser] next precedence: 0 2024-10-12T07:25:23.413Z DEBUG [sqlparser::parser] parsing expr Error during parsing: ParserError("Expected: an expression, found: ! at Line: 1, Column: 21") ``` -- 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]
