Bug with int2
От | Feng Tian |
---|---|
Тема | Bug with int2 |
Дата | |
Msg-id | CAFWGqntMsAAmeaQgBE40z6at9KrNHRxh__Y36mA5BdXsQXXU=Q@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: Bug with int2
Re: Bug with int2 Re: Bug with int2 |
Список | pgsql-hackers |
<div dir="ltr"><div style="font-size:12.8px">I run into the following. Seems this is a bug for -32768, which should bea valid smallint value.</div><div style="font-size:12.8px"><br /></div><div style="font-size:12.8px">Test was run on 9.4.5.</div><divstyle="font-size:12.8px"><br /></div><div style="font-size:12.8px">Thanks,</div><div style="font-size:12.8px">Feng</div><divstyle="font-size:12.8px"><br /></div><div style="font-size:12.8px">ftian=# select32767::int2; </div><div style="font-size:12.8px"> int2 </div><div style="font-size:12.8px">-------</div><divstyle="font-size:12.8px"> 32767</div><div style="font-size:12.8px">(1 row)</div><divstyle="font-size:12.8px"><br /></div><div style="font-size:12.8px">ftian=# select -32767::int2;</div><div style="font-size:12.8px"> ?column? </div><divstyle="font-size:12.8px">----------</div><div style="font-size:12.8px"> -32767</div><divstyle="font-size:12.8px">(1 row)</div><div style="font-size:12.8px"><br /></div><div style="font-size:12.8px">ftian=#select 32768::int2; </div><div style="font-size:12.8px">ERROR: smallint out of range</div><div style="font-size:12.8px">ftian=# select -32768::int2;</div><divstyle="font-size:12.8px">ERROR: smallint out of range</div><div style="font-size:12.8px">ftian=# </div></div>
В списке pgsql-hackers по дате отправления: