BUG #7703: Error with partitioning with distinct over aggregate
| От | maxim.boguk@gmail.com |
|---|---|
| Тема | BUG #7703: Error with partitioning with distinct over aggregate |
| Дата | |
| Msg-id | E1TclVr-0005Sv-Kc@wrigleys.postgresql.org обсуждение исходный текст |
| Ответы |
Re: BUG #7703: Error with partitioning with distinct over aggregate
|
| Список | pgsql-bugs |
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.
В списке pgsql-bugs по дате отправления: