node-pg-query-native icon indicating copy to clipboard operation
node-pg-query-native copied to clipboard

Parser throw error when met keyword "row"

Open dogHere opened this issue 7 years ago • 0 comments

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

dogHere avatar Apr 05 '18 05:04 dogHere