diff options
Diffstat (limited to 'src/interfaces/ecpg/test/sql/show.pgc')
| -rw-r--r-- | src/interfaces/ecpg/test/sql/show.pgc | 6 |
1 files changed, 5 insertions, 1 deletions
diff --git a/src/interfaces/ecpg/test/sql/show.pgc b/src/interfaces/ecpg/test/sql/show.pgc index 8eb71a7262a..d3a888d5095 100644 --- a/src/interfaces/ecpg/test/sql/show.pgc +++ b/src/interfaces/ecpg/test/sql/show.pgc @@ -6,7 +6,7 @@ EXEC SQL INCLUDE ../regression; int main(int argc, char* argv[]) { EXEC SQL BEGIN DECLARE SECTION; - char var[25]; + char var[25] = "public"; EXEC SQL END DECLARE SECTION; ECPGdebug(1, stderr); @@ -15,6 +15,10 @@ int main(int argc, char* argv[]) { EXEC SQL WHENEVER SQLWARNING SQLPRINT; EXEC SQL WHENEVER SQLERROR SQLPRINT; + EXEC SQL SET search_path TO :var; + EXEC SQL SHOW search_path INTO :var; + printf("Var: Search path: %s\n", var); + EXEC SQL SET search_path TO 'public'; EXEC SQL SHOW search_path INTO :var; printf("Var: Search path: %s\n", var); |