zhm / node-pg-query-native

PostgreSQL Query Parser for Node.js
BSD 3-Clause "New" or "Revised" License
29 stars 17 forks source link

Parser throw error when met keyword "row" #7

Open dogHere opened 6 years ago

dogHere commented 6 years ago

This will throw error:

select  row_number() over(
    partition by id
    order by
      create_time
  )  row
from  sometable

as

{
  "error": {
    "fileName": "scan.l",
    "lineNumber": 1116,
    "cursorPosition": 89,
    "functionName": "scanner_yyerror",
    "context": null
  },
  "query": []
}

But this will be well:

select  row_number() over(
    partition by id
    order by
      create_time
  )  as row
from  sometable