Unsupported query with count(*) OVER()
Author: ahmafiCreated Sep 19, 2026Updated Sep 19, 2026
Labelsbug
What happens?
SELECT
count(*) OVER () AS "full_count",
"id",
"title",
"slug",
pdb.score ("id") AS "score"
FROM
"products"
WHERE
(
("products"."shop_id" = '019fecbb-46be-794b-a38f-a9a8174c0983')
AND (("products"."deleted_at" IS NULL))
AND ("products"."active" = true)
AND (
(
(
"products"."title" ||| 'cake'
)
OR ("products"."description_text" ||| 'cake')
)
)
)
GROUP BY
"products"."id"
ORDER BY
score DESC,
"products"."created_at" DESC,
"products"."id" DESC
LIMIT
10
OFFSET
0;Error: Unsupported query shape. Please report at https://github.com/paradedb/paradedb/issues/new/choose
To Reproduce
I think this should happen in any dataset.
OS:
x64
ParadeDB Version (e.g. output of SELECT * FROM paradedb.version_info();):
0.25.3
Are you using ParadeDB Docker, Helm, or the extension(s) standalone?
ParadeDB pg_search Extension
Full Name:
Amirhossein
Affiliation:
None
Did you include all relevant data sets for reproducing the issue?
N/A - The reproduction does not require a data set
Did you include the code required to reproduce the issue?
- Yes, I have
Did you include all relevant configurations (e.g., CPU architecture, PostgreSQL version, Linux distribution) to reproduce the issue?
- Yes, I have
Source: paradedb/paradedb