Test Case: ---------- exec sql begin declare section;    short s ;    unsigned short us; exec sql end   declare section; exec sql create table test(s smallint, us smallint); exec sql commit; s = 1; us =32000; exec sql insert into test values( :s, :us ) ;  <== error
Test Case:
----------
exec sql begin declare section;
   short s ;
   unsigned short us;
exec sql end   declare section;
exec sql create table test(s smallint, us smallint);
exec sql commit;
s = 1; us =32000;
exec sql insert into test values( :s, :us ) ;  <== error

Error Message: "i4toi2: '-600309759' causes int2 underflow"

Masaaki Sakaida

jmcatamney/gpdb,Chibin/gpdb,ovr/postgres-xl,lpetrov-pivotal/gpdb,Chibin/gpdb,yuanzhao/gpdb,foyzur/gpdb,yuanzhao/gpdb,postmind-net/postgres-xl,50wu/gpdb,0x0FFF/gpdb,arcivanov/postgres-xl,0x0FFF/gpdb,foyzur/gpdb,xuegang/gpdb,kmjungersen/PostgresXL,edespino/gpdb,foyzur/gpdb,ahachete/gpdb,kaknikhil/gpdb,ahachete/gpdb,ovr/postgres-xl,cjcjameson/gpdb,ahachete/gpdb,tangp3/gpdb,xuegang/gpdb,rvs/gpdb,lintzc/gpdb,arcivanov/postgres-xl,cjcjameson/gpdb,yazun/postgres-xl,rubikloud/gpdb,kaknikhil/gpdb,ashwinstar/gpdb,yuanzhao/gpdb,arcivanov/postgres-xl,janebeckman/gpdb,Quikling/gpdb,oberstet/postgres-xl,atris/gpdb,zeroae/postgres-xl,rvs/gpdb,zaksoup/gpdb,Chibin/gpdb,Quikling/gpdb,tangp3/gpdb,techdragon/Postgres-XL,Quikling/gpdb,ashwinstar/gpdb,zaksoup/gpdb,cjcjameson/gpdb,0x0FFF/gpdb,CraigHarris/gpdb,0x0FFF/gpdb,tangp3/gpdb,cjcjameson/gpdb,50wu/gpdb,xinzweb/gpdb,chrishajas/gpdb,50wu/gpdb,techdragon/Postgres-XL,tangp3/gpdb,ovr/postgres-xl,CraigHarris/gpdb,greenplum-db/gpdb,yazun/postgres-xl,Postgres-XL/Postgres-XL,lintzc/gpdb,arcivanov/postgres-xl,jmcatamney/gpdb,CraigHarris/gpdb,greenplum-db/gpdb,rubikloud/gpdb,kaknikhil/gpdb,Quikling/gpdb,50wu/gpdb,rubikloud/gpdb,randomtask1155/gpdb,0x0FFF/gpdb,tpostgres-projects/tPostgres,xinzweb/gpdb,oberstet/postgres-xl,lintzc/gpdb,pavanvd/postgres-xl,randomtask1155/gpdb,xuegang/gpdb,foyzur/gpdb,randomtask1155/gpdb,lpetrov-pivotal/gpdb,pavanvd/postgres-xl,xuegang/gpdb,atris/gpdb,rvs/gpdb,arcivanov/postgres-xl,ovr/postgres-xl,yazun/postgres-xl,kaknikhil/gpdb,edespino/gpdb,adam8157/gpdb,oberstet/postgres-xl,janebeckman/gpdb,jmcatamney/gpdb,techdragon/Postgres-XL,jmcatamney/gpdb,yuanzhao/gpdb,atris/gpdb,zeroae/postgres-xl,foyzur/gpdb,greenplum-db/gpdb,Postgres-XL/Postgres-XL,zaksoup/gpdb,CraigHarris/gpdb,kaknikhil/gpdb,lpetrov-pivotal/gpdb,ahachete/gpdb,chrishajas/gpdb,rubikloud/gpdb,rvs/gpdb,janebeckman/gpdb,xuegang/gpdb,atris/gpdb,tpostgres-projects/tPostgres,greenplum-db/gpdb,zaksoup/gpdb,ashwinstar/gpdb,ahachete/gpdb,foyzur/gpdb,greenplum-db/gpdb,janebeckman/gpdb,xinzweb/gpdb,rvs/gpdb,zeroae/postgres-xl,xinzweb/gpdb,CraigHarris/gpdb,yuanzhao/gpdb,Postgres-XL/Postgres-XL,lisakowen/gpdb,yuanzhao/gpdb,cjcjameson/gpdb,yuanzhao/gpdb,Quikling/gpdb,zaksoup/gpdb,royc1/gpdb,Chibin/gpdb,royc1/gpdb,rvs/gpdb,chrishajas/gpdb,Chibin/gpdb,royc1/gpdb,0x0FFF/gpdb,edespino/gpdb,Quikling/gpdb,0x0FFF/gpdb,Chibin/gpdb,zeroae/postgres-xl,kmjungersen/PostgresXL,lintzc/gpdb,rvs/gpdb,randomtask1155/gpdb,lisakowen/gpdb,snaga/postgres-xl,foyzur/gpdb,lisakowen/gpdb,tpostgres-projects/tPostgres,kmjungersen/PostgresXL,Quikling/gpdb,jmcatamney/gpdb,lintzc/gpdb,janebeckman/gpdb,royc1/gpdb,xinzweb/gpdb,atris/gpdb,randomtask1155/gpdb,lisakowen/gpdb,cjcjameson/gpdb,ahachete/gpdb,janebeckman/gpdb,ahachete/gpdb,lintzc/gpdb,adam8157/gpdb,arcivanov/postgres-xl,CraigHarris/gpdb,kaknikhil/gpdb,edespino/gpdb,tangp3/gpdb,lintzc/gpdb,postmind-net/postgres-xl,lintzc/gpdb,royc1/gpdb,janebeckman/gpdb,adam8157/gpdb,kaknikhil/gpdb,kmjungersen/PostgresXL,Chibin/gpdb,royc1/gpdb,0x0FFF/gpdb,foyzur/gpdb,jmcatamney/gpdb,CraigHarris/gpdb,oberstet/postgres-xl,ovr/postgres-xl,cjcjameson/gpdb,xinzweb/gpdb,zaksoup/gpdb,50wu/gpdb,tangp3/gpdb,pavanvd/postgres-xl,atris/gpdb,rubikloud/gpdb,Quikling/gpdb,chrishajas/gpdb,chrishajas/gpdb,greenplum-db/gpdb,lintzc/gpdb,pavanvd/postgres-xl,edespino/gpdb,xinzweb/gpdb,randomtask1155/gpdb,Quikling/gpdb,ahachete/gpdb,Quikling/gpdb,ashwinstar/gpdb,50wu/gpdb,ashwinstar/gpdb,chrishajas/gpdb,royc1/gpdb,CraigHarris/gpdb,yuanzhao/gpdb,tangp3/gpdb,kaknikhil/gpdb,tpostgres-projects/tPostgres,lisakowen/gpdb,Chibin/gpdb,lpetrov-pivotal/gpdb,rubikloud/gpdb,atris/gpdb,Chibin/gpdb,lisakowen/gpdb,Chibin/gpdb,royc1/gpdb,greenplum-db/gpdb,adam8157/gpdb,adam8157/gpdb,cjcjameson/gpdb,xuegang/gpdb,xuegang/gpdb,kaknikhil/gpdb,cjcjameson/gpdb,snaga/postgres-xl,Postgres-XL/Postgres-XL,xinzweb/gpdb,rvs/gpdb,rvs/gpdb,ashwinstar/gpdb,randomtask1155/gpdb,yazun/postgres-xl,rvs/gpdb,lpetrov-pivotal/gpdb,postmind-net/postgres-xl,lpetrov-pivotal/gpdb,xuegang/gpdb,chrishajas/gpdb,ashwinstar/gpdb,yuanzhao/gpdb,randomtask1155/gpdb,postmind-net/postgres-xl,edespino/gpdb,jmcatamney/gpdb,janebeckman/gpdb,adam8157/gpdb,tangp3/gpdb,techdragon/Postgres-XL,rubikloud/gpdb,techdragon/Postgres-XL,janebeckman/gpdb,snaga/postgres-xl,greenplum-db/gpdb,zaksoup/gpdb,lpetrov-pivotal/gpdb,pavanvd/postgres-xl,adam8157/gpdb,zaksoup/gpdb,cjcjameson/gpdb,50wu/gpdb,50wu/gpdb,yazun/postgres-xl,lpetrov-pivotal/gpdb,kmjungersen/PostgresXL,postmind-net/postgres-xl,xuegang/gpdb,tpostgres-projects/tPostgres,lisakowen/gpdb,atris/gpdb,lisakowen/gpdb,adam8157/gpdb,edespino/gpdb,kaknikhil/gpdb,Postgres-XL/Postgres-XL,zeroae/postgres-xl,chrishajas/gpdb,jmcatamney/gpdb,rubikloud/gpdb,edespino/gpdb,janebeckman/gpdb,ashwinstar/gpdb,edespino/gpdb,edespino/gpdb,CraigHarris/gpdb,snaga/postgres-xl,yuanzhao/gpdb,oberstet/postgres-xl,snaga/postgres-xl