[HACKERS] smallint out of range EXECUTEing prepared statement

Поиск
Список
Период
Сортировка
От Justin Pryzby
Тема [HACKERS] smallint out of range EXECUTEing prepared statement
Дата
Msg-id 20170118221530.GH3033@telsasoft.com
обсуждение исходный текст
Ответ на Re: [HACKERS] ALTER TABLE .. ALTER COLUMN .. ERROR: attribute .. has wrong type  (Justin Pryzby <pryzby@telsasoft.com>)
Список pgsql-hackers
Is this expected behavior ?

ts=# SELECT * FROM t WHERE site_id=32768 LIMIT 1;
(0 rows)

ts=# PREPARE x AS SELECT * FROM t WHERE site_id=$1 LIMIT 1;
PREPARE
ts=# EXECUTE x(32768);
ERROR:  smallint out of range

ts=# PREPARE y AS SELECT * FROM t WHERE site_id::int=$1 LIMIT 1;
PREPARE
ts=# EXECUTE y(32768);
(0 rows)

Note, we also sometimes get small/int out of range when SELECTing from a view,
and we end up as a workaround putting a ::big/int cast into the view or
multiplying by 1.

Thanks,
Justin



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

Предыдущее
От: David Rowley
Дата:
Сообщение: Re: [HACKERS] PoC: Grouped base relation
Следующее
От: "David G. Johnston"
Дата:
Сообщение: Re: [HACKERS] smallint out of range EXECUTEing prepared statement