#6413·paradedb

Unsupported query with count(*) OVER()

Author: ahmafiCreated Sep 19, 2026Updated Sep 19, 2026
Labelsbug

What happens?

sql
 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