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

does not handle the recurring functions

Open sinkog opened this issue 7 years ago • 2 comments

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

sinkog avatar Sep 22 '18 13:09 sinkog

@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?

lfittl avatar Sep 22 '18 15:09 lfittl

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 .

sinkog avatar Sep 24 '18 19:09 sinkog