From: | maxim(dot)boguk(at)gmail(dot)com |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #7703: Error with partitioning with distinct over aggregate |
Date: | 2012-11-25 23:21:23 |
Message-ID: | E1TclVr-0005Sv-Kc@wrigleys.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 7703
Logged by: Maksym Boguk
Email address: maxim(dot)boguk(at)gmail(dot)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.
From | Date | Subject | |
---|---|---|---|
Next Message | wilson | 2012-11-26 13:59:44 | BUG #7706: Can slave database supports creating temporary tables? |
Previous Message | Bruce Momjian | 2012-11-23 22:44:21 | Re: BUG #7683: pg_upgrade missing configuration file |