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=# 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
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.
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
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
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
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 recordFixed, 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/
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs