BUG #13754: Postgres possibly accepts a typo as valid input

Поиск
Список
Период
Сортировка
От ryan.vilim@gmail.com
Тема BUG #13754: Postgres possibly accepts a typo as valid input
Дата
Msg-id 20151103195949.2747.55003@wrigleys.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #13754: Postgres possibly accepts a typo as valid input
Список pgsql-bugs
The following bug has been logged on the website:

Bug reference:      13754
Logged by:          Ryan Vilim
Email address:      ryan.vilim@gmail.com
PostgreSQL version: 9.4.1
Operating system:   Mac
Description:

I recently found that postgres will accept the

SELECT -144mycol

to be equivalent to

SELECT -144 AS mycol.

As long as the first bits work out to be numbers it accepts it. For example,
it will also interpret

SELECT FLOOR(-144.4)*4mycol

as

SELECT FLOOR(144.4)*4 as mycol

I haven't been able to find any other references to this being standard SQL.
I think it might be a bug in postgres.

Ryan

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

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: BUG #13750: Autovacuum slows down with large numbers of tables. More workers makes it slower.
Следующее
От: Haribabu Kommi
Дата:
Сообщение: Re: BUG #13741: vacuumdb does not accept valid password