Problem when deparsing 'EXCEPT'

[primeapple]

Hi there,

I just found another bug in deparse. (Btw, @lfittl , i'm probably going to find some more, since I'm testing this a lot currently. Do you want me to continue submitting bugreports or should I stop to not fill your issues list up?)

This bug is when you use a query that contains the EXCEPT keyword and then try to deparse the query. This problem seems to be something deeper, since it does NOT throw an exception.

Example:

PgQuery.parse("SELECT a FROM x EXCEPT SELECT a FROM Y").deparse
=> ""
PgQuery.parse("SELECT a FROM x UNION (SELECT a from Z EXCEPT SELECT a FROM Y)").deparse
=> "SELECT \"a\" FROM \"x\" UNION "

I hope you can trace this issue down quickly! Have a great time!

[herwinw]

Btw, @lfittl , i'm probably going to find some more, since I'm testing this a lot currently. Do you want me to continue submitting bugreports or should I stop to not fill your issues list up?

I would say to just keep them coming. I'm pretty sure the deparse module is far from complete (there are a few PRs open to improve it).

[lfittl]

@primeapple Please do - I apologize for the backlog here, I'm very much aware of the contributions and hoping to review/merge things in the next days, as well as tackle open issues :)

[lfittl]

Fixed by 823155c