apache / apache/datafusion-sqlparser-rs
Cannot parse table alias or cte alias in Postgres dialect
- 主要語言
- Rust
- 星號
- 3.5k
- 分支
- 772
- 平均合併
- 4 天 9 小時
- 30 天內合併 PR
- 17
描述
Sorry for bothering you.
I'm using sqlparser = "0.40.0"
This is my code:
```rust
use sqlparser::dialect::PostgreSqlDialect;
use sqlparser::parser::{Parser, ParserError};
fn main() {
let dialect = PostgreSqlDialect {};
let sql1 = r#"
WITH existing AS (SELECT test_table.id FROM test_tables AS test_table WHERE (a = 12) AND (b = 34)),
inserted AS (INSERT INTO test_tables AS test_table (id, a, b, c) VALUES (DEFAULT, 56, 78, 90) ON CONFLICT (a, b)
DO UPDATE SET c = EXCLUDED.c WHERE (test_table.c != EXCLUDED.c)) SELECT c FROM existing"#;
let sql2 = "INSERT INTO test_tables AS test_table (id, a) VALUES (DEFAULT, 123) ON CONFLICT DO NOTHING RETURNING id";
let ast1 = Parser::parse_sql(&dialect, sql1);
match ast1 {
Ok(_) => {
}
Err(e) => {
println!("fail ast1: {}", e);
}
}
let ast2 = Parser::parse_sql(&dialect, sql2);
match ast2 {
Ok(_) => {
}
Err(e) => {
println!("fail ast2: {}", e);
}
}
}
```
error output:
```bash
fail ast1: sql parser error: Expected SELECT, VALUES, or a subquery in the query body, found: AS at Line: 3, Column 43
fail ast2: sql parser error: Expected SELECT, VALUES, or a subquery in the query body, found: AS at Line: 1, Column 25
```
Thank you!
貢獻指南
這個儲存庫沒有索引到貢獻指南
研究方向
從 reproducer 中的 PostgreSqlDialect 和 Parser::parse_sql 呼叫開始,同時執行 sql1 和 sql2,以確認別名解析錯誤。追蹤 INSERT 陳述式和 CTE 查詢主體如何處理別名;完成條件是兩個 PostgreSQL 陳述式都能成功解析,且不再出現回報的錯誤。
由索引模型根據 Issue 內容生成。
評估
- 技術堆疊
- postgresql, rust
- 領域
- databases
- Issue 類型
- 缺陷
- 難度
- 3/5
- 預估耗時
- 1-2 天
- 活躍度
- 停滯
- 描述清晰度
- 基本清楚
- 新手友好度
- 42/100