BUG #13273: A query that returns wrongly labeled result instead of syntax error

Поиск
Список
Период
Сортировка
От v-brody@seznam.cz
Тема BUG #13273: A query that returns wrongly labeled result instead of syntax error
Дата
Msg-id 20150511224630.2714.40796@wrigleys.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #13273: A query that returns wrongly labeled result instead of syntax error  (Thomas Munro <thomas.munro@enterprisedb.com>)
Список pgsql-bugs
The following bug has been logged on the website:

Bug reference:      13273
Logged by:          Missing comma in SELECT list results in wrong label without error
Email address:      v-brody@seznam.cz
PostgreSQL version: 9.4.1
Operating system:   CentOS Linux
Description:

Following query (notice the missing comma between top-level "x" and "y")
returns 1 (which is "x" value) under label "y" without any warning.

select
    "x" "y"
from
(
    select
        "a" as "x", "b" as "y"
    from
    (
        select 1 as "a", 2 as "b"
    ) "subquery1"
) "subquery2";

Expected behavior: syntax error

Environment:
PostgreSQL 9.4.1 on Linux version 2.6.32-504.16.2.el6.x86_64

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Prepare/Execute silently discards prohibited ORDER BY values
Следующее
От: Thomas Munro
Дата:
Сообщение: Re: BUG #13273: A query that returns wrongly labeled result instead of syntax error