Description
With ClickHouseDialect, a tuple element access followed by a named field prints without spaces around the second dot. The printed SQL parses back as a different query, with no error.
Reproduction
use sqlparser::dialect::ClickHouseDialect;
use sqlparser::parser::Parser;
let sql = "SELECT t.1.name";
let ast = Parser::parse_sql(&ClickHouseDialect {}, sql).unwrap();
let printed = ast[0].to_string();
println!("{printed}"); // SELECT t . 1.name
let reparsed = Parser::parse_sql(&ClickHouseDialect {}, &printed).unwrap();
println!("{}", reparsed[0]); // SELECT t . 1. AS name
| Step |
Result |
| Input |
SELECT t.1.name |
| Parsed |
CompoundFieldAccess { root: t, access_chain: [Dot(1), Dot(name)] } (correct) |
| Printed |
SELECT t . 1.name |
| Re-parsed |
SELECT t . 1. AS name: the number 1. with alias name |
Expected
The printed output keeps the access chain, e.g. SELECT t . 1 . name, and parses back to the same AST.
Context
ClickHouse's lexer tokenizes t.1.name as t . 1 . name (see the "chained tuple access" disambiguation in src/Parsers/Lexer.cpp), so the initial parse is correct and only Display is wrong.
Follow-up to #2574 (tuple element access). Found with the fuzz_parse_roundtrip fuzz target.
Description
With
ClickHouseDialect, a tuple element access followed by a named field prints without spaces around the second dot. The printed SQL parses back as a different query, with no error.Reproduction
SELECT t.1.nameCompoundFieldAccess { root: t, access_chain: [Dot(1), Dot(name)] }(correct)SELECT t . 1.nameSELECT t . 1. AS name: the number1.with aliasnameExpected
The printed output keeps the access chain, e.g.
SELECT t . 1 . name, and parses back to the same AST.Context
ClickHouse's lexer tokenizes
t.1.nameast . 1 . name(see the "chained tuple access" disambiguation insrc/Parsers/Lexer.cpp), so the initial parse is correct and onlyDisplayis wrong.Follow-up to #2574 (tuple element access). Found with the
fuzz_parse_roundtripfuzz target.