1 /* create table t1 with two fields,
2 * insert 10 rows into the table ,
3 * select with nonexisting fields.It Should be failed in Mysql, Passed in postgres and oracle
10 AbsSqlConnection
*con
= createConnection();
11 rv
= con
->connect("root","manager");
14 AbsSqlStatement
*stmt
= createStatement();
15 stmt
->setConnection(con
);
18 strcpy(statement
,"CREATE TABLE t1(f1 INT,f2 INT);");
19 if(strcmp(getenv("DSN"),"db2")==0)
20 strcpy(statement
,"CREATE TABLE t1(f1 INT,f2 INT)");
23 rv
= stmt
->prepare(statement
);
31 rv
= stmt
->execute(rows
);
39 printf("Table created\n");
43 strcpy(statement
,"INSERT INTO t1 VALUES(?,?);");
44 if(strcmp(getenv("DSN"),"db2")==0)
45 strcpy(statement
,"INSERT INTO t1 VALUES(?,?)");
50 rv
= stmt
->prepare(statement
);
66 rv
= con
->beginTrans();
70 stmt
->setIntParam(1,f1var
);
71 stmt
->setIntParam(2,f2var
);
73 rv
= stmt
->execute(rows
);
79 printf("%d rows inserted\n",count
);
83 //*******************************************
85 strcpy(statement
,"SELECT F3 ,f2 FROM t1;");
86 if(strcmp(getenv("DSN"),"db2")==0)
87 strcpy(statement
,"SELECT F3 ,f2 FROM t1");
88 rv
= stmt
->prepare(statement
);
92 printf("Test script passed\n");
94 strcpy(statement
,"DROP TABLE t1;");
95 if(strcmp(getenv("DSN"),"db2")==0)
96 strcpy(statement
,"DROP TABLE t1");
97 rv
= stmt
->prepare(statement
);
98 rv
= stmt
->execute(rows
);
99 if(rv
==OK
)printf("Table dropped\n");
108 if(strcmp(getenv("DSN"),"oracle")==0 || strcmp(getenv("DSN"),"psql")==0 || strcmp(getenv("DSN"),"sybase")==0 )
110 printf("Test script Passed\n");
111 strcpy(statement
,"DROP TABLE t1;");
112 if(strcmp(getenv("DSN"),"db2")==0)
113 strcpy(statement
,"DROP TABLE t1");
114 rv
= stmt
->prepare(statement
);
115 rv
= stmt
->execute(rows
);
116 if(rv
==OK
){printf("Table dropped\n");}
125 printf("Test script failed\n");
126 strcpy(statement
,"DROP TABLE t1;");
127 if(strcmp(getenv("DSN"),"db2")==0)
128 strcpy(statement
,"DROP TABLE t1");
129 rv
= stmt
->prepare(statement
);
130 rv
= stmt
->execute(rows
);
131 if(rv
==OK
)printf("Table dropped\n");