Re: [Firebird-test] Is this what you are looking for

[marius p. <ma...@re...>]

If want to contribute with tests 
could we split in two the areas of testing so i don't write 
again the same test .
> 
> > Is this the type of thing you are looking for?
> 
> Almost there :-) In future, divide test to next sections: id, 
> description, dependencies, test type (positive / negative, yours is 
> negative), input, tested command, result, additional checks
> 
> For example:
> 
> Test ID: LANDRUM_001 (your name + your own sequence number)
> 
> Test type: NEGATIVE (i.e. must fail / return an error code)
> 
> Description:
> Check for proper enforcement of PK constraint - uniqueness of PK value.
> 
> Dependencies: (What tests must be run before this test. Use test IDs or 
> description)
> 
> - Table creation
> - Direct data insert
> 
> Prerequisites:
> 
> - New database (you can also refer to a database/script used in another 
> test by test ID)
> 
> - Initialization script:
> 
> CREATE TABLE FB_TEST(FB_ID INTEGER NOT NULL,
> FB_DATA VARCHAR(20),
> CONSTRAINT FB_ID_PK PRIMARY KEY (FB_ID));
>  
> INSERT INTO FB_TEST(FB_ID, FB_DATA)
> VALUES(1, 'RECORD ONE');
>  
> INSERT INTO FB_TEST(FB_ID, FB_DATA)
> VALUES(2, 'RECORD TWO');
> 
> Tested command:
>  
> INSERT INTO FB_TEST(FB_ID, FB_DATA)
>  VALUES(2, 'RECORD TWO');
> 
> Expected result:
>  
>  /*RESULT
>  Statement failed, SQLCODE = -803
>  violation of PRIMARY or UNIQUE KEY constraint "FB_ID_PK" on table 
> "FB_TEST"
>  */
> 
> Additional checks: NONE
>  
> 
> Thank you for your assistance!
> Pavel Cisar
> http://www.ibphoenix.com
> For all your upto date Firebird and
> InterBase information
> 
> 
> 
> -------------------------------------------------------
> This sf.net email is sponsored by:ThinkGeek
> Welcome to geek heaven.
> http://thinkgeek.com/sf
> _______________________________________________
> Firebird-test mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-test