BUG #1444: ::int2 parser bug

Started by Ioseph Kimabout 21 years ago2 messagesbugs

pgsql-kr@postgresql.or.kr

about 21 years ago

The following bug has been logged online:

Bug reference: 1444
Logged by: Ioseph Kim
Email address: pgsql-kr@postgresql.or.kr
PostgreSQL version: 7.4x ~
Operating system: ALL
Description: ::int2 parser bug
Details:

select int2(-32768);

int2
--------
-32768

--------------------------

select -32768::int2;

ERROR: integer out of range
--------------------------

select '-32768'::int2;

int2
--------
-32768

--------------------------

It seems to bug.

This bug occured ::int4 parsing too.

Tom Lane

tgl@sss.pgh.pa.us

about 21 years ago

In reply to: Ioseph Kim (#1)

Re: BUG #1444: ::int2 parser bug

"Ioseph Kim" <pgsql-kr@postgresql.or.kr> writes:

select -32768::int2;
ERROR: integer out of range

This is not a bug, because the interpretation is -(32768::int2)
which indeed is out of range.

regards, tom lane