BUG #11457: The below query crashes 9.3.5, but not 9.3.4

From: npage(at)dynamicsignal(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #11457: The below query crashes 9.3.5, but not 9.3.4
Date: 2014-09-20 00:23:14
Message-ID: 20140920002314.2558.52018@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: 11457
Logged by: Nelson Page
Email address: npage(at)dynamicsignal(dot)com
PostgreSQL version: 9.3.5
Operating system: WIndows 8.1
Description:

SELECT

"GroupBy1"."A1" AS "C1"

FROM ( SELECT Count(1) AS "A1"

FROM (SELECT

"UnionAll4"."C1"

FROM (SELECT

"UnionAll3"."C1"

FROM (SELECT

"UnionAll2"."C1"

FROM (SELECT

"UnionAll1"."activityId" AS "C1"

FROM (SELECT

"Extent1"."activityId"

FROM "ActivityBlogCampaign" AS "Extent1"

UNION ALL

SELECT

"Extent2"."activityId"

FROM "ActivitySubmitArticle" AS "Extent2") AS "UnionAll1"

UNION ALL

SELECT

"Extent3"."activityId"

FROM "ActivityCuratedPost" AS "Extent3") AS "UnionAll2"

UNION ALL

SELECT

"Extent4"."activityId"

FROM "ActivitySurvey" AS "Extent4") AS "UnionAll3"

UNION ALL

SELECT

"Extent5"."activityId"

FROM "ActivityHashTag" AS "Extent5") AS "UnionAll4"

UNION ALL

SELECT

"Extent6"."activityId"

FROM "ActivityShareArticle" AS "Extent6") AS "UnionAll5"

INNER JOIN "Activity" AS "Extent7" ON "UnionAll5"."C1" =
"Extent7"."activityId"
GROUP BY "Extent7"."activityId"

) As "GroupBy1"

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Maxim Boguk 2014-09-20 07:29:36 Re: Re: BUG #11441: Weird (and seems wrong) behavior of partial indexes with order by/limit
Previous Message Alon 2014-09-19 22:15:53 Re: BUG #11431: Failing to backup and restore a Windows postgres database, with Norwegian Bokmål locale.