summaryrefslogtreecommitdiff
path: root/src/interfaces/ecpg/test/test_code100.pgc
diff options
context:
space:
mode:
authorMichael Meskes <meskes@postgresql.org>2006-08-02 13:51:32 +0000
committerMichael Meskes <meskes@postgresql.org>2006-08-02 13:51:32 +0000
commit36e8d4e7807505891fa463cc66c2223d845374a9 (patch)
treef28fe7aad0d3daddcbec0f57ccc0f75f14371c5d /src/interfaces/ecpg/test/test_code100.pgc
parent1fa6be6f69dc7723f67c24480c06663fba585d15 (diff)
downloadpostgresql-36e8d4e7807505891fa463cc66c2223d845374a9.tar.gz
Removed old test files
Diffstat (limited to 'src/interfaces/ecpg/test/test_code100.pgc')
-rw-r--r--src/interfaces/ecpg/test/test_code100.pgc51
1 files changed, 0 insertions, 51 deletions
diff --git a/src/interfaces/ecpg/test/test_code100.pgc b/src/interfaces/ecpg/test/test_code100.pgc
deleted file mode 100644
index 1307abeab7..0000000000
--- a/src/interfaces/ecpg/test/test_code100.pgc
+++ /dev/null
@@ -1,51 +0,0 @@
-// $PostgreSQL: pgsql/src/interfaces/ecpg/test/test_code100.pgc,v 1.3 2003/11/29 22:41:18 pgsql Exp $
-
-exec sql include sqlca;
-#include <stdio.h>
-
-int main(int argc, char **argv)
-{ exec sql begin declare section;
- int index;
- exec sql end declare section;
-
-
- // ECPGdebug(1,stdout);
-
- exec sql connect to mm;
- if (sqlca.sqlcode) printf("%ld:%s\n",sqlca.sqlcode,sqlca.sqlerrm.sqlerrmc);
-
- exec sql create table test (
- "index" numeric(3) primary key,
- "payload" int4 NOT NULL);
- if (sqlca.sqlcode) printf("%ld:%s\n",sqlca.sqlcode,sqlca.sqlerrm.sqlerrmc);
- exec sql commit work;
- if (sqlca.sqlcode) printf("%ld:%s\n",sqlca.sqlcode,sqlca.sqlerrm.sqlerrmc);
-
- for (index=0;index<10;++index)
- { exec sql insert into test
- (payload, index)
- values (0, :index);
- if (sqlca.sqlcode) printf("%ld:%s\n",sqlca.sqlcode,sqlca.sqlerrm.sqlerrmc);
- }
- exec sql commit work;
- if (sqlca.sqlcode) printf("%ld:%s\n",sqlca.sqlcode,sqlca.sqlerrm.sqlerrmc);
-
- exec sql update test
- set payload=payload+1 where index=-1;
- if (sqlca.sqlcode!=100) printf("%ld:%s\n",sqlca.sqlcode,sqlca.sqlerrm.sqlerrmc);
-
- exec sql delete from test where index=-1;
- if (sqlca.sqlcode!=100) printf("%ld:%s\n",sqlca.sqlcode,sqlca.sqlerrm.sqlerrmc);
-
- exec sql insert into test (select * from test where index=-1);
- if (sqlca.sqlcode!=100) printf("%ld:%s\n",sqlca.sqlcode,sqlca.sqlerrm.sqlerrmc);
-
- exec sql drop table test;
- if (sqlca.sqlcode) printf("%ld:%s\n",sqlca.sqlcode,sqlca.sqlerrm.sqlerrmc);
- exec sql commit work;
- if (sqlca.sqlcode) printf("%ld:%s\n",sqlca.sqlcode,sqlca.sqlerrm.sqlerrmc);
-
- exec sql disconnect;
- if (sqlca.sqlcode) printf("%ld:%s\n",sqlca.sqlcode,sqlca.sqlerrm.sqlerrmc);
- return 0;
-}