\set SHOW_ALL_RESULTS off
-- primary = node 1 and standby = node 0
DROP TABLE  IF EXISTS t1;
NOTICE:  DB node id: 1 statement: DROP TABLE  IF EXISTS t1;
-- create a persistent table
CREATE TABLE t1(i int);
NOTICE:  DB node id: 1 statement: CREATE TABLE t1(i int);
-- wait for replicated
SELECT pg_sleep(1);
NOTICE:  DB node id: 1 statement: SELECT pg_sleep(1);
 pg_sleep 
----------
 
(1 row)

-- ordinary read only SELECT: load balance expected
SELECT * FROM t1;
NOTICE:  DB node id: 0 statement: SELECT * FROM t1;
 i 
---
 1
(1 row)

DROP TABLE t1;
NOTICE:  DB node id: 1 statement: DROP TABLE t1;
-- create temp table with the same name
CREATE TEMP TABLE t1(i int);
NOTICE:  DB node id: 1 statement: CREATE TEMP TABLE t1(i int);
-- expected read from primary
SELECT * FROM t1;
NOTICE:  DB node id: 1 statement: SELECT * FROM t1;
 i 
---
(0 rows)

