ut.7~

来自「linux 下用c++ 开发的一个小型数据库系统」· 7~ 代码 · 共 53 行

/*
 * ut.7: tests error checking
 */

/* do you check for duplicated attribute names? */
/* following should fail */
create table ned (ted char(24), ted int);

/* do you check for duplicated relation names? */
create table ned (ted char(24), jed int);	/* <-- this should succeed */
create table ned (ted char(24), jed int);

/* do you check for relations that are too large? */
create table red(ted char(200), jed char(200), red char(200), ed char(200), fred char(200), ned char(200));

/* can you destroy table nonexistent relations? */
destroy table jed;

/* can you destroy table a relation more than once? */
destroy table ned;	/* <-- this should succeed */
destroy table ned;

/* recreate table ned (this should succeed) */
create table ned (ted char(24), jed int);

/* can you create table indices on nonexistent attributes? */
/* buildindex ned(ed);*/

/* can you build indices on attributes that are already indexed? */
/* buildindex ned(ted);*/		/* <-- this should succeed */
/* buildindex ned(ted);*/

/* can you print relations that don't exist */
print table jed;

/* can you load from nonexistent files? */
load table ned from ("no-such-file");

/* can you load into nonexistent relations? */
load table ed from ("../data/soaps.data");

/* can you get help on nonexistent relations? */
help table jed;

/* the rest should all succeed */

/* what sort of condition are things left in? */
help;
help table ned;
!ls

quit;