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"
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. |