duckpgq-extension icon indicating copy to clipboard operation
duckpgq-extension copied to clipboard

Allow multiple MATCH statements within a single query

Open Dtenwolde opened this issue 1 year ago • 1 comments

There can only be one MATCH statement in a single query. It should be possible to have multiple MATCH statements, of which the results can be joined using the cross-product. This would be similar to a subquery

https://github.com/cwida/duckpgq-experiments/issues/27

Dtenwolde avatar Feb 12 '24 11:02 Dtenwolde

Right now we save the result of the TransformMatchNode in parse_data, which can only store one node. However, a query can contain more than 1, in which case this method fails. A suggestion was made to not store the data in parse_data, but serialize the node and add it as a BLOB argument to the node in the logical query plan (something along these lines). Then we later deserialize the node whenever we reach it.

Dtenwolde avatar Mar 12 '24 12:03 Dtenwolde