--
-- Transactions (GPDB-specific tests)
--

CREATE TEMPORARY TABLE temptest (a int);
INSERT INTO temptest VALUES (generate_series(1, 10));

CREATE TEMPORARY SEQUENCE tempseq;

SET SESSION CHARACTERISTICS AS TRANSACTION READ ONLY;

-- Make sure COPY works with temp tables during a READ ONLY transaction.
COPY temptest TO '@abs_builddir@/results/xacttemp.data';
DELETE FROM temptest;
COPY temptest FROM '@abs_builddir@/results/xacttemp.data';
SELECT * from temptest;

-- Ensure temporary sequences function correctly as well.
SELECT nextval('tempseq');
SELECT setval('tempseq', 5);
SELECT nextval('tempseq');