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              : }