Branch data     Line data    Source code

       1                 :             : #include <stdio.h>
       2                 :             : #include <stdlib.h>
       3                 :             : #include <string.h>
       4                 :             : 
       5                 :             : EXEC SQL INCLUDE ../regression;
       6                 :             : 
       7                 :           2 : int main(void) {
       8                 :             :   EXEC SQL BEGIN DECLARE SECTION;
       9                 :           2 :     char var[25] = "public";
      10                 :             :   EXEC SQL END DECLARE SECTION;
      11                 :             : 
      12                 :           2 :   ECPGdebug(1, stderr);
      13                 :           2 :   EXEC SQL CONNECT TO REGRESSDB1;
      14                 :             : 
      15                 :             :   EXEC SQL WHENEVER SQLWARNING SQLPRINT;
      16                 :             :   EXEC SQL WHENEVER SQLERROR SQLPRINT;
      17                 :             : 
      18                 :           2 :   EXEC SQL SET search_path TO :var;
      19   [ -  +  -  + ]:           2 :   EXEC SQL SHOW search_path INTO :var;
      20   [ -  +  -  + ]:           2 :   printf("Var: Search path: %s\n", var);
      21                 :             : 
      22                 :           2 :   EXEC SQL SET search_path TO 'public';
      23   [ -  +  -  + ]:           2 :   EXEC SQL SHOW search_path INTO :var;
      24   [ -  +  -  + ]:           2 :   printf("Var: Search path: %s\n", var);
      25                 :             : 
      26                 :           2 :   EXEC SQL SET standard_conforming_strings TO on;
      27   [ -  +  -  + ]:           2 :   EXEC SQL SHOW standard_conforming_strings INTO :var;
      28   [ -  +  -  + ]:           2 :   printf("Var: Standard conforming strings: %s\n", var);
      29                 :             : 
      30                 :           2 :   EXEC SQL SET TIME ZONE PST8PDT;
      31   [ -  +  -  + ]:           2 :   EXEC SQL SHOW TIME ZONE INTO :var;
      32   [ -  +  -  + ]:           2 :   printf("Time Zone: %s\n", var);
      33                 :             : 
      34                 :           2 :   EXEC SQL SET TRANSACTION ISOLATION LEVEL read committed;
      35   [ -  +  -  + ]:           2 :   EXEC SQL SHOW TRANSACTION ISOLATION LEVEL INTO :var;
      36   [ -  +  -  + ]:           2 :   printf("Transaction isolation level: %s\n", var);
      37                 :             : 
      38                 :           2 :   EXEC SQL DISCONNECT ALL;
      39   [ -  +  -  + ]:           2 : 
      40                 :           2 :   return 0;
      41                 :             : }