test/dbapi/TableDef/fieldcasesensitive.c

   1 //Create table with fieldname as "EMP" and "emp". it should succeed.
   2 #include<CSql.h>
   3 int main()
   4 {
   5     Connection conn;
   6     DbRetVal rv = conn.open("root", "manager");
   7     if (rv != OK) return 1;
   8     DatabaseManager *dbMgr = conn.getDatabaseManager();
   9     if (dbMgr == NULL) { printf("Auth failed\n"); return 2;}
  10
  11     TableDef tabDef;
  12     tabDef.addField("EMP", typeInt, 0, NULL, true);
  13     rv=(DbRetVal)tabDef.addField("emp", typeInt);
  14     if(rv!=0)
  15     {
  16         printf("Test Failed with return value %d\n",rv);
  17         return rv;
  18     }
  19
  20     dbMgr->createTable("t1", tabDef);
  21     printf("Table created\n");
  22     printf("test Passed\n");
  23     dbMgr->dropTable("t1");
  24     conn.close();
  25     return 0;
  26 }
  27
  28