[Firebird-test] Using SHOW instead select from system tables

[Skopalik S. <sko...@hl...>]

I was developed test script, that using SHOW isql statament instead select from RDB$... tables.
I'm think, that is more readable (and little clear) than select from system tables because
system tables may be change.
Can be used this technique is test scripts ?

	Slavek

There is a example:
/*
Author: Slavomir Skopalik (sko...@hl...)

Test ID: skopalik_0027

Test type: POSITIVE

Description: ALTER TABLE - DROP

Dependencies:
CREATE DATABASE
CREATE TABLE
SHOW TABLE

Prerequisites: NONE

Initialization script:
*/

CREATE DATABASE "test.gdb"  USER "sysdba" PASSWORD "masterkey";
CREATE TABLE test( id INTEGER NOT NULL,
                   text VARCHAR(32));
/*
Tested command:
*/
ALTER TABLE test DROP text;
SHOW TABLE test;
/*
Expected result: No Error.

Additional checks:

ID                              INTEGER Not Null

/*
Clear temp DB 
*/
DROP DATABASE;


ing. Slavomir Skopalik DEL a.s.
Olomoucka 355 Marianske udoli 783 75
Czech Republic
----------------------------------------------
Tel: 068 535 35 48
Mobil: 0602 795 874
Fax: 068 535 23 64
e-mail:sko...@hl...
http://hlubocky.del.cz