Postgres Bug - Aggregate with order by

Hello my name is Andrew,

I believe that I've found a bug within postgres where an aggregate function is not accepted when an order by clause is specified, here is a short example:



postgres=# select version();
                                                           version
-----------------------------------------------------------------------------------------------------------------------------
 PostgreSQL 14.2 (Debian 14.2-1.pgdg110+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 10.2.1-6) 10.2.1 20210110, 64-bit
(1 row)

postgres=# create table test_table(i int);
CREATE TABLE

postgres=# insert into test_table values (1);
INSERT 0 1

postgres=# select COUNT(i) from test_table;
 count
-------
     1
(1 row)

postgres=# select COUNT(i) from test_table order by i;
ERROR:  column "test_table.i" must appear in the GROUP BY clause or be used in an aggregate function
LINE 1: select COUNT(i) from test_table order by i;
                                                 ^