--
-- INT4 + INT2
--
--Testcase 001:
CREATE EXTENSION sqlite_fdw;
--Testcase 002:
CREATE SERVER sqlite_svr FOREIGN DATA WRAPPER sqlite_fdw
OPTIONS (database '/tmp/sqlite_fdw_test/core.db');

--Testcase 01:
CREATE FOREIGN TABLE INT4_TBL(f1 int4 OPTIONS (key 'true')) SERVER sqlite_svr;
--Testcase 02:
CREATE FOREIGN TABLE INT4_TMP(f1 int4, f2 int4, id int OPTIONS (key 'true')) SERVER sqlite_svr; 

--Testcase 03:
DELETE FROM INT4_TMP;
--Testcase 04:
ALTER FOREIGN TABLE INT4_TMP ALTER COLUMN f1 TYPE int8;
--Testcase 05:
INSERT INTO INT4_TMP VALUES (x'7FFFFFFF'::int8 + 1, 0);
--Testcase 06:
ALTER FOREIGN TABLE INT4_TMP ALTER COLUMN f1 TYPE int4;
--Testcase 07:
SELECT * FROM INT4_TMP; -- overflow
--Testcase 08:
SELECT f1 FROM INT4_TMP; -- overflow

--Testcase 09:
DELETE FROM INT4_TMP;
--Testcase 10:
ALTER FOREIGN TABLE INT4_TMP ALTER COLUMN f1 TYPE int8;
--Testcase 11:
INSERT INTO INT4_TMP VALUES (-(x'7FFFFFFF'::int8) - 2, 0);
--Testcase 12:
ALTER FOREIGN TABLE INT4_TMP ALTER COLUMN f1 TYPE int4;
--Testcase 13:
SELECT * FROM INT4_TMP; -- overflow
--Testcase 14:
SELECT f1 FROM INT4_TMP; -- overflow

--Testcase 15:
CREATE FOREIGN TABLE INT2_TBL(f1 int2 OPTIONS (key 'true')) SERVER sqlite_svr;
--Testcase 16:
CREATE FOREIGN TABLE INT2_TMP(f1 int2, f2 int2, id int OPTIONS (key 'true')) SERVER sqlite_svr;

--Testcase 17:
DELETE FROM INT2_TMP;
--Testcase 18:
ALTER FOREIGN TABLE INT2_TMP ALTER COLUMN f1 TYPE int4;
--Testcase 19:
INSERT INTO INT2_TMP VALUES (x'7FFF'::int8 + 1, 0);
--Testcase 20:
ALTER FOREIGN TABLE INT2_TMP ALTER COLUMN f1 TYPE int2;
--Testcase 21:
SELECT * FROM INT2_TMP; -- overflow
--Testcase 22:
SELECT f1 FROM INT2_TMP; -- overflow

--Testcase 23:
DELETE FROM INT2_TMP;
--Testcase 24:
ALTER FOREIGN TABLE INT2_TMP ALTER COLUMN f1 TYPE int4;
--Testcase 25:
INSERT INTO INT2_TMP VALUES (-(x'7FFF'::int8) - 2, 0);
--Testcase 26:
ALTER FOREIGN TABLE INT2_TMP ALTER COLUMN f1 TYPE int2;
--Testcase 27:
SELECT * FROM INT2_TMP; -- overflow
--Testcase 28:
SELECT f1 FROM INT2_TMP; -- overflow

--Testcase 29:
CREATE FOREIGN TABLE INT8_TBL(q1 int8 OPTIONS (key 'true'), q2 int8 OPTIONS (key 'true')) SERVER sqlite_svr;
--Testcase 31:
ALTER FOREIGN TABLE INT8_TBL ALTER COLUMN q1 TYPE double precision;
--Testcase 32:
INSERT INTO INT8_TBL VALUES (-9223372036854775810, 0);
--Testcase 33:
ALTER FOREIGN TABLE INT8_TBL ALTER COLUMN q1 TYPE int8;
--Testcase 34:
SELECT * FROM INT8_TBL; -- NO overflow
--Testcase 35:
SELECT q1 FROM INT8_TBL; -- NO overflow
--Testcase 36:
ALTER FOREIGN TABLE INT8_TBL ALTER COLUMN q1 TYPE double precision;
--Testcase 37:
DELETE FROM INT8_TBL WHERE q1 = -9223372036854775810;
--Testcase 38:
INSERT INTO INT8_TBL VALUES (9223372036854775809, 0);
--Testcase 39:
ALTER FOREIGN TABLE INT8_TBL ALTER COLUMN q1 TYPE int8;
--Testcase 40:
SELECT * FROM INT8_TBL; -- overflow
--Testcase 41:
SELECT q1 FROM INT8_TBL; -- overflow
--Testcase 42:
ALTER FOREIGN TABLE INT8_TBL ALTER COLUMN q1 TYPE double precision;
--Testcase 43:
DELETE FROM INT8_TBL WHERE q1 = 9223372036854775809;
--Testcase 44:
INSERT INTO INT8_TBL VALUES (10 * -9223372036854775810, 0);
--Testcase 45:
ALTER FOREIGN TABLE INT8_TBL ALTER COLUMN q1 TYPE int8;
--Testcase 46:
SELECT * FROM INT8_TBL; -- overflow
--Testcase 47:
SELECT q1 FROM INT8_TBL; -- overflow
--Testcase 48:
ALTER FOREIGN TABLE INT8_TBL ALTER COLUMN q1 TYPE double precision;
--Testcase 49:
DELETE FROM INT8_TBL WHERE q1 = 10 * -9223372036854775810;
--Testcase 50:
ALTER FOREIGN TABLE INT8_TBL ALTER COLUMN q1 TYPE int8;

--Testcase 003:
DROP SERVER sqlite_svr CASCADE;
--Testcase 004:
DROP EXTENSION sqlite_fdw CASCADE;