search

aprismatic / prismadb

Prisma/DB public releases and documentation.
34 stars 1 forks source link

Unable to GROUP BY #6

Open saklanipankaj opened 5 years ago

saklanipankaj commented 5 years ago

SELECT COUNT(a) FROM t1 GROUP BY b;

ERROR: 42703: column "b" does not exist Unable to use GROUP BY, instead a column not found error is thrown

cheziyi commented 5 years ago

What is the schema of the table like?

saklanipankaj commented 5 years ago

Field | Type | Null | Key | Default | Extra | Encryption -------+------+------+-----+---------+-------+--------------------------------- a | int4 | YES | | | | Addition, Multiplication, Range b | int8 | YES | | | | Addition, Multiplication, Range (2 rows)

cheziyi commented 5 years ago

We currently do not support GROUP BY for encrypted columns. We do plan to add support for GROUP BY for columns with RANGE encryption, but it's on a low priority for now.