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            0 : main(void)
      12              : {
      13              :         EXEC SQL BEGIN DECLARE SECTION;
      14            0 :                 int id;
      15              :         EXEC SQL END DECLARE SECTION;
      16              : 
      17            0 :         ECPGdebug(1, stderr);
      18            0 :         EXEC SQL connect to REGRESSDB1;
      19            0 : 
      20            0 :         EXEC SQL SET AUTOCOMMIT TO ON;
      21            0 :         EXEC SQL WHENEVER SQLWARNING SQLPRINT;
      22              :         EXEC SQL WHENEVER SQLERROR SQLPRINT;
      23              : 
      24            0 :         EXEC SQL CREATE TABLE cta_test (id int);
      25            0 :         EXEC SQL INSERT INTO cta_test values (100);
      26            0 : 
      27            0 :         EXEC SQL CREATE TABLE IF NOT EXISTS cta_test1 AS SELECT * FROM cta_test;
      28            0 :         EXEC SQL SELECT id INTO :id FROM cta_test1;
      29            0 :         printf("ID = %d\n", id);
      30              : 
      31            0 :         EXEC SQL CREATE TABLE cta_test2 AS SELECT * FROM cta_test WITH NO DATA;
      32            0 :         EXEC SQL SELECT count(id) INTO :id FROM cta_test2;
      33            0 :         printf("ID = %d\n", id);
      34              : 
      35            0 :         EXEC SQL DROP TABLE cta_test;
      36            0 :         EXEC SQL DROP TABLE cta_test1;
      37            0 :         EXEC SQL DROP TABLE cta_test2;
      38            0 :         EXEC SQL DISCONNECT all;
      39            0 : 
      40            0 :         return 0;
      41            0 : }