Re: [Firebird-test] Testing Firbird --- SI-T1.0.0.366 Firebird Be

[Mark O'D. <mar...@lu...>]

Konstantin Kuznetsov wrote:

>Hi all!
>
>>Could you post the errors/results for our review...  a number of the
>>errors are due to Claudio V's improved error reporting, so they are not
>>real errors.
>>
>I thing your mean display data that appears on screen.
>Next some screan shots. Dont know how get file report.
>
>
> r c_sql_join_4
>Running global test C_SQL_JOIN_4 ... *** failed ****
>Test C_SQL_JOIN_4 failed on 22-AUG-2001:
>        initialized by FSG
>        on 16-OCT-2000 with boilerplate QA_BP
>

Welcome to the joys of decipering TCS, it looks pretty much like mine 
did, when I extracted the scripts and
ran them and looked at the output and expected output, the difference is 
the new stuff is sorted on City, then something then something else. 
 Hence in the new one the results are in order Atlanta, Boston, Chicago...
The same test is run a few times (isql embedded etc), when you look at 
the raw output, you can see it's just the sort order that is different.

>
>-------------------
>3 a 3,8
>
>>Braves               Atlanta               Georgia
>>Red Sox              Boston                Massachusetts
>>Cubs                 Chicago               Illinois
>>White Sox            Chicago               Illinois
>>
>skip table
>4 c 10,11
>tbl
>6 a 13,19
>tbl
>7,20 d 21
>tbl
>++++++++++++++++++++++++++++++++++++++++++++++++++
>27 a 27,32
>28 c 34,35
>< Braves          Atlanta                   Georgia
>---------------------------------------------
>
>>Royals          Kansas City               Missouri
>>Dodgers         Los Angeles               California
>>
>++++++++++++++++++++++++++++++++++++++++++++++++++
>30 a 37,43
>...
>
>>Mariners        Seattle                   Washington
>>
>++++++++++++++++++++++++++++++++++++++++++++++++++
>31,45 c 45
>
>++++++++++++++++++++++++++++++++++++++++++++++++++
>47,48 c 47,48
><
>------
>52 a 52,57
>
>53 c 59,60
>< Braves          Atlanta                   Georgia
>---------------------------------------------
>
>>Royals          Kansas City               Missouri
>>Dodgers         Los Angeles               California
>>
>++++++++++++++++++++++++++++++++++++++++++++++++++
>55 a 62,68
>++++++++++++++++++++++++++++++++++++++++++++++++++
>56,70 d 70
>< Cubs
>
>71 a 70
>________________________
>tcs> r dsql_domain_08
>Running global test DSQL_DOMAIN_08 ... *** failed ****
>Test DSQL_DOMAIN_08 failed on 22-AUG-2001:
>        initialized by DSMIRNOV
>        on 4-NOV-1999 with boilerplate RD_VECTOR
>
>
>-------------------
>1 c 1
>---------------------------------------------
>++++++++++++++++++++++++++++++++++++++++++++++++++
>7 c 7
>< -Token unknown - line 4, char 15
>---------------------------------------------
>
>>-Token unknown - line 3, char 17
>>
>++++++++++++++++++++++++++++++++++++++++++++++++++
>

This rings a bell too, and the error, but I can't remember what I found 
when I looked at it in detail... ok I looked again, if you look at the 
script and error one stmt should fail, it does, so the test works correctly.

I assume the difference in error position has resulted from some work 
Claudio did on improving the error hadling to corretly identify the line 
and column, apparently it used to be wrong in some cases.


The sequence is:

create domain dom08a_1 as smallint;
commit;
show domain dom08a_1;

/* the next statement should fail */

alter domain dom08a_1
 add constraint not null;
commit;


The expected output is:


SQL> SQL> SQL> DOM08A_1                        SMALLINT Nullable
SQL> SQL> CON> CON> CON> Statement failed, SQLCODE = -104

Dynamic SQL Error
-SQL error code = -104
-Token unknown - line 4, char 15
-not


The only difference is it now reports the error at:

-Token unknown - line 3, char 17


The 'not' is in column 17, buggered if I can figure out the correct line 
number :-), tcs is a bit messy, but 15's not correct.  So it looks 
pretty reasonable.  But having produced an error, the correct results of 
the test has been obtained.

[snip]

>Who can know of his place?
>From c_dsql_ri_alt_add
>tcs.script
>
>rm -f sh_test.h
>gbak -r ./tests/sov3v4files/atlas.gbak
>/export/home/interbase/TSC.10/tcs/scripts
>ri_views /export/home/interbase/TSC.10/tcs/scripts/atlas.gdb
>cp  /TCS/sh_test.h sh_test.h
>cat >  al
>
>There I can find programm or script "ri_views "?
>I have not such thing!
>
I had that as well, ri_views is created by either the test directly 
before it or  the first one in the series.  It is deleted by the last 
one in the series I think.

I extracted the data using Franks extract kit, and then ran these using 
the trial dejagnu test kit, which made it a little easier to get at the 
intermediate files.

So all in all, your looking pretty good, there :-).

Cheers

Mark



-- 
Your database needs YOU!
http://firebird.sourceforge.net
GPL: free software today - and still free tomorrow