CREATE TABLE INT2_TBL(f1 int2); INSERT INTO INT2_TBL(f1) VALUES ('0'); INSERT INTO INT2_TBL(f1) VALUES ('1234'); INSERT INTO INT2_TBL(f1) VALUES ('-1234'); INSERT INTO INT2_TBL(f1) VALUES ('32767'); INSERT INTO INT2_TBL(f1) VALUES ('-32767'); CREATE TABLE int2_tbl(f1 int2); INSERT INTO int2_tbl SELECT * FROM INT2_TBL;