Add 6 more OID typeds at portable plan

danolivo · danolivo · commit 910d7764dbab · 2019-02-02T12:15:23.000+05:00
diff --git a/tests/regress b/tests/regress
@@ -1,7 +1,7 @@
 #!/bin/bash
 
 # This script performs regress tests at a master and mirrored it into the slave.
-U=`whoami`
+U=regression
 export LC_ALL=C
 export LANGUAGE="en_US:en"
 
@@ -12,6 +12,7 @@ LD_LIBRARY_PATH=$PGINSTALL/lib
 remoteSrvName=fdwremote
 export LD_LIBRARY_PATH=$LD_LIBRARY_PATH
 export PATH=$PGINSTALL/bin:$PATH
+export PGDATABASE=regression
 
 pkill -9 postgres || true
 sleep 1
@@ -41,7 +42,7 @@ createdb -p 5433 $U
 createdb -p 5432 $U
 
 psql -p 5432 -c "CREATE EXTENSION postgres_fdw;"
-psql -p 5432 -c "CREATE SERVER $remoteSrvName FOREIGN DATA WRAPPER postgres_fdw OPTIONS (port '5433', use_remote_estimate 'on');"
+psql -p 5432 -c "CREATE SERVER $remoteSrvName FOREIGN DATA WRAPPER postgres_fdw OPTIONS (port '5433', dbname 'regression', use_remote_estimate 'on');"
 psql -p 5432 -c "CREATE USER MAPPING FOR PUBLIC SERVER $remoteSrvName;"
 
 # Prepare plan execution
@@ -59,4 +60,4 @@ rm -rf $PGINSTALL/lib/regress.so
 cp `pwd`/src/test/regress/regress.so $PGINSTALL/lib
 cp `pwd`/src/test/regress/regress.so $PGINSTALL/lib/postgresql/
 cd src/test/regress
-./pg_regress --schedule=$SCRIPTS/serial_schedule --load-extension=postgres_fdw --load-extension=pg_execplan --load-extension=pg_repeater --dbname=andrey --use-existing
+./pg_regress --schedule=$SCRIPTS/serial_schedule --load-extension=postgres_fdw --load-extension=pg_execplan --load-extension=pg_repeater --dbname=regression --use-existing
diff --git a/tests/rpl.sh b/tests/rpl.sh
@@ -78,3 +78,17 @@ psql -p 5433 -c "SELECT oid, oprname, oprnamespace FROM pg_operator WHERE oprnam
 # Test
 psql -p 5432 -c "SELECT pg_store_query_plan('../test.txt', 'SELECT id ### 1 FROM tests.ttest1;');"
 psql -p 5433 -c "SELECT pg_exec_stored_plan('../test.txt');"
+
+#ENUMOID -----------------------------------------------------------------------
+psql -p 5432 -c "CREATE TYPE mood AS ENUM ('sad', 'ok', 'happy');"
+psql -p 5432 -c "CREATE TABLE person ( name text, current_mood mood);"
+psql -p 5433 -c "CREATE TYPE mood AS ENUM ('sad', 'ok', 'happy');"
+psql -p 5433 -c "CREATE TABLE person ( name text, current_mood mood);"
+
+psql -p 5432 -c "SELECT pg_store_query_plan('../test.txt', 'INSERT INTO person VALUES (''Moe'', ''happy'');');"
+psql -p 5432 -c "SELECT pg_exec_stored_plan('../test.txt');"
+psql -p 5433 -c "SELECT pg_exec_stored_plan('../test.txt');"
+
+psql -p 5432 -c "SELECT * FROM person WHERE current_mood = 'happy';"
+psql -p 5433 -c "SELECT * FROM person WHERE current_mood = 'happy';"
+
