Repository navigation
Fail to parse - "select * from (table_name)" #154
Description
Activity
from (table_name)is not actually valid SQL. Note that<table primary>in the ANSI SQL grammar does not allow parentheses around<table or query name>. A quick test shows that at least MS SQL Server follows the spec here. What database are you working with?Thanks for the fast response :)
I tested against snowflake ..
Is that something that could be solve by building a dialect ?Theoretically, yes. Practically in the current implementation the selected dialect only affects the tokenizer, and the parser unconditionally tries to parse some non-standard constructs.
So a code that support such syntax could be accepted?
well - i tried :)
- added a commit that references this issue
on Oct 13, 2020
I think it's fail here - https://github.com/andygrove/sqlparser-rs/blob/master/src/parser.rs#L1797
because the code assume that inside the Parenthesis should be TableFactor::Derived or TableFactor::NestedJoin, but it's not take in account it's could be TableFactor::Table