aboutsummaryrefslogtreecommitdiffstats
path: root/yql/essentials/tests/postgresql/initscripts/int2_tbl.sql
blob: ccb86462df501422719ea6071d338e3a7239d42d (plain) (blame)
1
2
3
4
5
6
7
8
9
10
11
12
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;