Unable to GROUP BY

[saklanipankaj]

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]

What is the schema of the table like?

[saklanipankaj]

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

[cheziyi]

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.