search

zhm / node-pg-query-native

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

does not handle the recurring functions #11

Open sinkog opened 5 years ago

sinkog commented 5 years ago

console.log(JSON.stringify(parser.parse('SELECT (x.cv).void,(x.cv).vonum,c.cegkod FROM x_function(12,56,hstore(\'alma\',5)) x (cv::voucher) JOIN ceg c ON c.cegkod=(x.cv).invpartnerid').query)); return: [] but if a function has a known return type then returns the expected value console.log(JSON.stringify(parser.parse('SELECT (x.cv).void,(x.cv).vonum,c.cegkod FROM x_function(12,56,hstore(\'alma\',5)) x JOIN ceg c ON c.cegkod=(x.cv).invpartnerid').query)); return: [{"SelectStmt":....}] is correct

lfittl commented 5 years ago

@sinkog This is most likely a bug in libpg_query (the underlying parser library) - do you mind opening an issue there so I have it on my radar?

sinkog commented 5 years ago

If another lib is causing a problem as to whether you see it, then be calm. The question is whether the directory can be defined specifically for the error, ie can it be reproduced? If so, is it just a mistake for developers to forward it? If you know the concretized error, please report it or let me know what the problem is, to take the case further. If I do not mind you I know you better, you know more about your libraries, and even the possible hidden contexts, and I do not yet have good experience with Javacript, and how can I say the project that I'm going to do is enough .