Обсуждение: Re: [HACKERS] smallint out of range EXECUTEing prepared statement

Поиск
Список
Период
Сортировка

Re: [HACKERS] smallint out of range EXECUTEing prepared statement

От
"David G. Johnston"
Дата:
On Wed, Jan 18, 2017 at 3:15 PM, Justin Pryzby <pryzby@telsasoft.com> wrote:
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

​​Probably.  If you show the definition of "t", or at least "t.site_id", that can be confirmed.

And, IMO, this question is more in line with the purpose of the -general list.

David J.