- Removed debug message from preproc.y.

        - Fixed some bugs in exec sql var and exec sql type command.

3 files changed, 8 insertions, 31 deletions

diff --git a/src/interfaces/ecpg/test/test2.pgc b/src/interfaces/ecpg/test/test2.pgc
index 761f7bb725..ec2c790d2b 100644
--- a/src/interfaces/ecpg/test/test2.pgc
+++ b/src/interfaces/ecpg/test/test2.pgc
@@ -50,10 +50,10 @@ exec sql end declare section;
 
 	strcpy(msg, "insert");
 	exec sql insert into meskes(name, married, children) values ('Petra', '19900404', 3);
-	exec sql insert into meskes(name, born, age, married, children) values ('Michael', 19660117, 34, '19900404', 3);
-	exec sql insert into meskes(name, born, age) values ('Carsten', 19910103,9);
-	exec sql insert into meskes(name, born, age) values ('Marc', 19930907, 6);
-	exec sql insert into meskes(name, born, age) values ('Chris', 19970923, 2);
+	exec sql insert into meskes(name, born, age, married, children) values ('Michael', 19660117, 35, '19900404', 3);
+	exec sql insert into meskes(name, born, age) values ('Carsten', 19910103,10);
+	exec sql insert into meskes(name, born, age) values ('Marc', 19930907, 8);
+	exec sql insert into meskes(name, born, age) values ('Chris', 19970923, 4);
 
 	strcpy(msg, "commit");
 	exec sql commit;
diff --git a/src/interfaces/ecpg/test/test3.pgc b/src/interfaces/ecpg/test/test3.pgc
index fab3aeb6d3..6f0afccc75 100644
--- a/src/interfaces/ecpg/test/test3.pgc
+++ b/src/interfaces/ecpg/test/test3.pgc
@@ -45,10 +45,10 @@ exec sql end declare section;
 
 	strcpy(msg, "insert");
 	exec sql insert into meskes(name, married, children) values (:wifesname, '19900404', 3);
-	exec sql insert into meskes(name, born, age, married, children) values ('Michael', 19660117, 34, '19900404', 3);
-	exec sql insert into meskes(name, born, age) values ('Carsten', 19910103, 9);
-	exec sql insert into meskes(name, born, age) values ('Marc', 19930907, 6);
-	exec sql insert into meskes(name, born, age) values ('Chris', 19970923, 2);
+	exec sql insert into meskes(name, born, age, married, children) values ('Michael', 19660117, 35, '19900404', 3);
+	exec sql insert into meskes(name, born, age) values ('Carsten', 19910103, 10);
+	exec sql insert into meskes(name, born, age) values ('Marc', 19930907, 8);
+	exec sql insert into meskes(name, born, age) values ('Chris', 19970923, 4);
 
 	strcpy(msg, "commit");
 	exec sql commit;
diff --git a/src/interfaces/ecpg/test/test_text.pgc b/src/interfaces/ecpg/test/test_text.pgc
deleted file mode 100644
index 146b922f00..0000000000
--- a/src/interfaces/ecpg/test/test_text.pgc
+++ /dev/null
@@ -1,23 +0,0 @@
-// $Id: test_text.pgc,v 1.1 2001/01/31 16:12:34 meskes Exp $
-
-exec sql include sqlca;
-#include <stdio.h>
-
-int main(int argc, char **argv)
-{  exec sql begin declare section;
-   int index;
-   char lab[15];
-   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 select 'a1234567890'::text into :lab;
-   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;
-}