sqlite-parser icon indicating copy to clipboard operation
sqlite-parser copied to clipboard

Trailing spaces in table or column names deleted

Open kibtidec opened this issue 8 years ago • 0 comments

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.

kibtidec avatar Nov 13 '16 18:11 kibtidec