Unsupported query shapes

[stuhood]

This discussion acts as a collection point for query shapes that ParadeDB does not support yet. If you've reached this discussion via an error message, then we're very sorry for the trouble!

Please look for other queries with similar "shapes" to the query that you were trying to run.

• If you find similar queries, please upvote them (and potentially add details in a comment) to help the team decide how to prioritize them.
• If you don't find a similar query, please add a new one with:
  1. the query and its EXPLAIN directly in the description
  2. any additional files needed to reproduce (if possible!) attached

Thank you!

[stuhood]

Using unnest on a parent partitioned table does not get the custom scan, which means scores/snippets are not supported:

-- EXPLAIN ANALYZE
SELECT
  id,
  array_length(pdb.snippet_positions(message),1) AS num,
  UNNEST(pdb.snippets(message, max_num_chars => 15)),
  pdb.score(b.id)
FROM benchmark_logs as b
WHERE message @@@ 'research about' AND country @@@ 'Canada'
LIMIT 10;

ddl.sql