Обсуждение: BUG #7703: Error with partitioning with distinct over aggregate
The following bug has been logged on the website: Bug reference: 7703 Logged by: Maksym Boguk Email address: maxim.boguk@gmail.com PostgreSQL version: 9.2.1 Operating system: Any Description: = Simple test case: test=3D# create table test (id serial); NOTICE: CREATE TABLE will create implicit sequence "test_id_seq" for serial column "test.id" CREATE TABLE test=3D# create index test_id_key on test(id); CREATE INDEX test=3D# create table test_part_1 (like test including all) INHERITS (test); NOTICE: merging column "id" with inherited definition CREATE TABLE test=3D# explain analyze select distinct min(id) from test; ERROR: failed to re-find MinMaxAggInfo record PS: without partioning or without index over id - no error. Tested 9.0.* versions is not affected by bug, but 9.2.1 and 9.1.6 is.
maxim.boguk@gmail.com writes: > test=# create table test (id serial); > NOTICE: CREATE TABLE will create implicit sequence "test_id_seq" for serial > column "test.id" > CREATE TABLE > test=# create index test_id_key on test(id); > CREATE INDEX > test=# create table test_part_1 (like test including all) INHERITS (test); > NOTICE: merging column "id" with inherited definition > CREATE TABLE > test=# explain analyze select distinct min(id) from test; > ERROR: failed to re-find MinMaxAggInfo record Fixed, thanks for the report. regards, tom lane
On Tue, Nov 27, 2012 at 5:01 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote: > maxim.boguk@gmail.com writes: >> test=# create table test (id serial); >> NOTICE: CREATE TABLE will create implicit sequence "test_id_seq" for serial >> column "test.id" >> CREATE TABLE >> test=# create index test_id_key on test(id); >> CREATE INDEX >> test=# create table test_part_1 (like test including all) INHERITS (test); >> NOTICE: merging column "id" with inherited definition >> CREATE TABLE >> test=# explain analyze select distinct min(id) from test; >> ERROR: failed to re-find MinMaxAggInfo record > > Fixed, thanks for the report. > > regards, tom lane Thank you very much. PS: I know that the query sounds stupid, but most CMS/ORM unfortunately could produce unlimited amount of strange/stupid queries. -- Maxim Boguk Senior Postgresql DBA http://www.postgresql-consulting.ru/