pgsql: Defend against JOINs having more than 32K columns altogether.

Поиск
Список
Период
Сортировка
От tgl@postgresql.org (Tom Lane)
Тема pgsql: Defend against JOINs having more than 32K columns altogether.
Дата
Msg-id 20080405015842.D010F7558E7@cvs.postgresql.org
обсуждение исходный текст
Список pgsql-committers
Log Message:
-----------
Defend against JOINs having more than 32K columns altogether.  We cannot
currently support this because we must be able to build Vars referencing
join columns, and varattno is only 16 bits wide.  Perhaps this should be
improved in future, but considering that it never came up before, I'm not
sure the problem is worth much effort.  Per bug #4070 from Marcello
Ceschia.

The problem seems largely academic in 8.0 and 7.4, because they have
(different) O(N^2) performance issues with such wide joins, but
back-patch all the way anyway.

Tags:
----
REL8_1_STABLE

Modified Files:
--------------
    pgsql/src/backend/parser:
        parse_relation.c (r1.116.2.2 -> r1.116.2.3)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/parser/parse_relation.c?r1=1.116.2.2&r2=1.116.2.3)
    pgsql/src/include/access:
        attnum.h (r1.21 -> r1.21.2.1)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/include/access/attnum.h?r1=1.21&r2=1.21.2.1)

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

Предыдущее
От: tgl@postgresql.org (Tom Lane)
Дата:
Сообщение: pgsql: Defend against JOINs having more than 32K columns altogether.
Следующее
От: tgl@postgresql.org (Tom Lane)
Дата:
Сообщение: pgsql: Defend against JOINs having more than 32K columns altogether.