/* DROP might fail */

EXEC SQL AT test0 DROP TABLE test_thread;

EXEC SQL AT test0 COMMIT WORK;

EXEC SQL AT test0 CREATE TABLE test_thread(messagecharacter(40));

EXEC SQL AT test0 CREATE TABLE test_thread(messageTEXT);

EXEC SQL AT test0 COMMIT WORK;

EXEC SQL DISCONNECT test0;

pthread_create(&thread1, NULL, (void *) ins1, NULL);

pthread_create(&thread2, NULL, (void *) ins2, NULL);

pthread_join(thread1, NULL);

pthread_join(thread2, NULL);

EXEC SQL CONNECT TO:dbname AS test3;

EXEC SQL AT test3 SELECT COUNT(*) INTO :rows FROM test_thread;

EXEC SQL AT test3 COMMIT WORK;

EXEC SQL DISCONNECT test3;

if (rows == iterations)

printf("Success.\n");

printf("\nSuccess.\n");

else

printf("Failure.\n");

printf("\nFailure.\n");

return 0;

}