test/dbapi/TableDef/fieldname2.c

   1 //Should not allow field names more than 64 character
   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
  13     tabDef.addField("abcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyzabcdefghijklabc", typeInt, 0, NULL, true);
  14     rv=dbMgr->createTable("t1", tabDef);
  15     if(rv==OK)
  16     {
  17         printf("Allowing fieldname more than 64 character\n");
  18         printf("Test Failed\n");
  19         dbMgr->dropTable("t1");
  20         return 3;
  21     }
  22     printf("Test Passed\n");
  23     conn.close();
  24     return 0;
  25 }
  26
  27 //Table is created  and allowing fieldnames with more than 64 characters
  28