-- 
-- Hot Standby tests
--
-- standby_allowed.sql
--

-- SELECT

select count(*) from hs1;

select count(*) from hs2;

select count(*) from hs3;

-- Transactions

begin;
select count(*) from hs1;
end;

begin transaction read only;
select count(*) from hs1;
end;

begin transaction isolation level serializable;
select count(*) from hs1;
select count(*) from hs1;
select count(*) from hs1;
commit;

begin;
select count(*) from hs1;
commit;

begin;
select count(*) from hs1;
abort;

start transaction;
select count(*) from hs1;
commit;

begin;
select count(*) from hs1;
rollback;

begin;
select count(*) from hs1;
savepoint s;
select count(*) from hs2;
commit;

begin;
select count(*) from hs1;
savepoint s;
select count(*) from hs2;
release savepoint s;
select count(*) from hs2;
savepoint s;
select count(*) from hs2;
rollback to savepoint s;
select count(*) from hs2;
commit;

-- SET parameters

-- has no effect on read only transactions, but we can still set it
set synchronous_commit = on;
show synchronous_commit;
reset synchronous_commit;

discard temp;

discard all;

-- CURSOR commands

BEGIN;

DECLARE hsc CURSOR FOR select * from hs3;

FETCH next from hsc;

fetch first from hsc;

fetch last from hsc;

fetch 1 from hsc;

CLOSE hsc;

COMMIT;

-- Prepared plans

PREPARE hsp AS select count(*) from hs1;

EXECUTE hsp;

DEALLOCATE hsp;

-- LOCK

LOCK hs1;

-- LOAD
-- should work, easier if there is no test for that...

discard all;
