diff options
| author | Michael Meskes <meskes@postgresql.org> | 2006-08-02 13:51:32 +0000 |
|---|---|---|
| committer | Michael Meskes <meskes@postgresql.org> | 2006-08-02 13:51:32 +0000 |
| commit | 36e8d4e7807505891fa463cc66c2223d845374a9 (patch) | |
| tree | f28fe7aad0d3daddcbec0f57ccc0f75f14371c5d /src/interfaces/ecpg/test/test_code100.pgc | |
| parent | 1fa6be6f69dc7723f67c24480c06663fba585d15 (diff) | |
| download | postgresql-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.pgc | 51 |
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; -} |
