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

[David G. Johnston]

On Wed, Jan 18, 2017 at 3:15 PM, Justin Pryzby <pry...@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.