test/dbapi/Index/index1.c

   1 //create table t1(f1 int,f2 int)
   2 //create index idx1 on t1(f1)
   3 //create index idx2 on t1(f2)
   4 //insert null records for f2 and check whether the system is stable after that.
   5
   6 #include<CSql.h>
   7 #include"common.h"
   8 int main()
   9 {
  10     Connection conn;
  11     DbRetVal rv=conn.open("root","manager");
  12     if(rv != OK) return 1;
  13     DatabaseManager *dbmgr=conn.getDatabaseManager();
  14     if(dbmgr == NULL) { printf("Authentication Failed\n"); return 2; }
  15
  16     if( creatTable(dbmgr) !=0 ) { conn.close(); return 3; }
  17     if( createIndex(dbmgr) != 0 ) { dbmgr->dropTable("t1"); conn.close(); return 4; }
  18     int flag = insertTuplef2NUL(dbmgr,conn);
  19     if( flag != 0 ) { dbmgr->dropTable("t1"); conn.close(); return 5; }
  20     dbmgr->dropTable("t1");
  21     conn.close();
  22     return 0;
  23 }