Branch data     Line data    Source code

       1                 :             : #include <stdlib.h>
       2                 :             : #include <string.h>
       3                 :             : #include <stdlib.h>
       4                 :             : #include <stdio.h>
       5                 :             : 
       6                 :             : exec sql include ../regression;
       7                 :             : 
       8                 :             : exec sql whenever sqlerror sqlprint;
       9                 :             : 
      10                 :             : int
      11                 :           2 : main(void)
      12                 :             : {
      13                 :             :     EXEC SQL BEGIN DECLARE SECTION;
      14                 :             :         int id;
      15                 :             :     EXEC SQL END DECLARE SECTION;
      16                 :             : 
      17                 :           2 :     ECPGdebug(1, stderr);
      18                 :           2 :     EXEC SQL connect to REGRESSDB1;
      19         [ -  + ]:           2 : 
      20                 :           2 :     EXEC SQL SET AUTOCOMMIT TO ON;
      21         [ -  + ]:           2 :     EXEC SQL WHENEVER SQLWARNING SQLPRINT;
      22                 :             :     EXEC SQL WHENEVER SQLERROR SQLPRINT;
      23                 :             : 
      24                 :           2 :     EXEC SQL CREATE TABLE cta_test (id int);
      25   [ -  +  -  + ]:           2 :     EXEC SQL INSERT INTO cta_test values (100);
      26   [ -  +  -  + ]:           2 : 
      27                 :           2 :     EXEC SQL CREATE TABLE IF NOT EXISTS cta_test1 AS SELECT * FROM cta_test;
      28   [ -  +  -  + ]:           2 :     EXEC SQL SELECT id INTO :id FROM cta_test1;
      29   [ -  +  -  + ]:           2 :     printf("ID = %d\n", id);
      30                 :             : 
      31                 :           2 :     EXEC SQL CREATE TABLE cta_test2 AS SELECT * FROM cta_test WITH NO DATA;
      32   [ -  +  -  + ]:           2 :     EXEC SQL SELECT count(id) INTO :id FROM cta_test2;
      33   [ -  +  -  + ]:           2 :     printf("ID = %d\n", id);
      34                 :             : 
      35                 :           2 :     EXEC SQL DROP TABLE cta_test;
      36   [ -  +  -  + ]:           2 :     EXEC SQL DROP TABLE cta_test1;
      37   [ -  +  -  + ]:           2 :     EXEC SQL DROP TABLE cta_test2;
      38   [ -  +  -  + ]:           2 :     EXEC SQL DISCONNECT all;
      39   [ -  +  -  + ]:           2 : 
      40                 :           2 :     return 0;
      41                 :             : }