I have fixed a couple of things in SERVICE+VALUES (formatting of output,
the machinery for turning algebra to query syntax)
The OpAsQuery process of turning algebra back into queries for SERVICE
works when VALUES was part of a group (only lightly tested) but when
used on the query itself, a different query is generated.
Some of the structure is lost on the conversion and optimization process
so a little more analysis of the algebra structure is needed to detech
the case of a
The case that does not work is if GROUP BY is used in a subquery of the
SERVICE block. The VALUES block gets moved across the GROUP BY.
Andy