[Firebird-test] SQL compliance tests

[Pavel C. <pc...@us...>]

Hi all,

For those who'd like help us develop new tests, here is a brief how-to 
(more detailed one is in development :) for test designers.

What we need most right now are SQL compliance tests. Actually, it's not
necessary to write them, just design them. That mean:

1) Get FB/IB SQL reference guide.

2) Design really simple test cases, i.e. only single aspect of single 
command is tested in each test. Test consists from required input 
(database content), single SQL command and result check. Result check is
an actual result (i.e. from SELECT statement, error code etc.) and 
verification from database content (for INSERT statement and the likes). 
DDL commands are checked against system tables. Check may query more than
one table. This design may be written in plain, structured text (name, 
description, required input (ISqL script is best), tested statement, 
expected result - if any, commands and their expected output for result 
check (captured output from ISQL is enough).

3) Start from simple cases to more complex.

4) Send each test design in separate message to firebird-test mailing 
list for peer review and to get them implemented by test developers.

Best regards
Pavel Cisar
http://www.ibphoenix.com
For all your upto date Firebird and
InterBase information