sqlite-parser
sqlite-parser copied to clipboard
Trailing spaces in table or column names deleted
It's probably more an academic problem than a real life issue ... trailing spaces from table or column names do not make it into the AST, e.g.
select "a " from "b "
leads to
{
"type": "statement",
"variant": "list",
"statement": [
{
"type": "statement",
"variant": "select",
"result": [
{
"type": "identifier",
"variant": "column",
"name": "a"
}
],
"from": {
"type": "identifier",
"variant": "table",
"name": "b"
}
}
]
}
Although it doesn't make too much sense to define identifiers with trailing spaces it works in sqlite, therefore the created AST should reflect this.