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

Поиск
Список
Период
Сортировка
От npage@dynamicsignal.com
Тема BUG #11457: The below query crashes 9.3.5, but not 9.3.4
Дата
Msg-id 20140920002314.2558.52018@wrigleys.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #11457: The below query crashes 9.3.5, but not 9.3.4  (Michael Paquier <michael.paquier@gmail.com>)
Список pgsql-bugs
The following bug has been logged on the website:

Bug reference:      11457
Logged by:          Nelson Page
Email address:      npage@dynamicsignal.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"

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Alon
Дата:
Сообщение: Re: BUG #11431: Failing to backup and restore a Windows postgres database, with Norwegian Bokmål locale.
Следующее
От: Michael Paquier
Дата:
Сообщение: Re: BUG #11457: The below query crashes 9.3.5, but not 9.3.4