firebird-test — Firebird engine testing, test flight/suite discussion/information

Re: [Firebird-test] Problems with DSQL_DOMAIN_08

[Paul R. <pr...@ib...>]

Erik Kunze wrote:


 > It expects the database to be in WHERE_FILES. WHERE_EXAMPLES_40 is
 > set to ./tests/sov3v4files. Should I modify the test or copy the file
 > atlas.gbk from ./tests/sov3v4files into ./tests directory?
 >

There is obviously a mistake in the setup routine somewhere. I always 
copy the files across as that seems easier that looking for the mistake.


Paul
-- 

Paul Reeves
http://www.ibphoenix.com
Supporting users of Firebird and InterBase

[Firebird-test] Problems with DSQL_DOMAIN_08

[Erik K. <Eri...@ph...>]

Hi,

I get the following output while running TCS test DSQL_DOMAIN_08 against
FB1:

tcs> r DSQL_DOMAIN_08
Running global test DSQL_DOMAIN_08 ... *** failed ****
Test DSQL_DOMAIN_08 failed on 24-JUN-2002:
        initialized by DSMIRNOV             
        on 4-NOV-1999 with boilerplate RD_VECTOR           
-------------------
1,29 d 1
< 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
< SQL> SQL> DOM08A_1                        SMALLINT Nullable
< SQL> SQL> SQL> DOM08A_2                        NUMERIC(3, 1) Nullable
< SQL> SQL> SQL> DOM08B_1                        INTEGER Nullable
< SQL> SQL> SQL> DOM08B_2                        INTEGER Nullable
< SQL> SQL> SQL> DOM08B_3                        NUMERIC(9, 0) Nullable
< SQL> SQL> SQL> DOM08B_4                        NUMERIC(6, 2) Nullable
< SQL> SQL warning code = 301
< -DATE data type is now called TIMESTAMP
< SQL> SQL> DOM08C                          TIMESTAMP Nullable
< SQL> SQL> SQL> DOM08D_1                        CHAR(20) Nullable
< SQL> SQL> SQL> DOM08D_2                        CHAR(99) Nullable
< SQL> SQL> SQL> DOM08E_1                        VARCHAR(25) Nullable
< SQL> SQL> SQL> DOM08E_2                        VARCHAR(100) Nullable
< SQL> SQL> SQL> DOM08E_3                        VARCHAR(2) Nullable
< SQL> SQL> SQL> DOM08F_1                        DECIMAL(6, 2) Nullable
< SQL> SQL> SQL> DOM08G_1                        FLOAT Nullable
< SQL> SQL> SQL> DOM08G_2                        DOUBLE PRECISION Nullable
< SQL> SQL> SQL> DOM08G_3                        FLOAT Nullable
< SQL> SQL> SQL> DOM08H                          DOUBLE PRECISION Nullable
< SQL> SQL> SQL> DOM08I_1                        BLOB segment 80, subtype UNKNOWN Nullable
< SQL> SQL> SQL> DOM08I_2                        BLOB segment 60, subtype TEXT Nullable
++++++++++++++++++++++++++++++++++++++++++++++++++
30 a 1,68 
> gbak: ERROR: cannot open backup file ./tests/atlas.gbk
> gbak: Exiting before completion due to errors
> Statement failed, SQLCODE = -902
> 
> I/O error for file "/user1/build/SINIX-Z/tcs-1.0/tcs/scripts/atlas.gdb"
> -Error while trying to open file
> -No such file or directory
++++++++++++++++++++++++++++++++++++++++++++++++++

The test can't find atlas.gbk, because it is in ./tests/sov3v4files and
not in ./tests.

tcs> pt DSQL_DOMAIN_08
Global Test, Version 6.0.0:
-------------------
$ GBAK -c WHERE_FILES:atlas.gbk WHERE_GDB:atlas.gdb
$ isql WHERE_GDB:atlas.gdb

It expects the database to be in WHERE_FILES. WHERE_EXAMPLES_40 is set
to ./tests/sov3v4files. Should I modify the test or copy the file atlas.gbk
from ./tests/sov3v4files into ./tests directory?


-- 
   Dipl.-Ing. Erik Kunze               Phone: +49 - 89 - 32 14 07 41
   PHILOSYS Software GmbH              Fax:   +49 - 89 - 32 14 07 12
   Edisonstr. 6                        Email: Eri...@ph...
   D-85716 Unterschleissheim           WWW:   www.philosys.de/~kunze

 PGP-Key: http://blackhole.pca.dfn.de:11371/pks/lookup?op=get&search=0xD5759581

[Firebird-test] TCS failes with DECIMAL()

[Erik K. <Eri...@ph...>]

Hi,

the following tests EXT_REL_0_7_D and EXT_REL_0_8_D create a table with
a field of DECIMAL(10,10). I get wired results with this data type if the
value store is not an integer:

Test EXT_REL_0_8_D        failed on 21-JUN-2002:
        initialized by FSG
        on 16-OCT-2000 with boilerplate QA_BP
-------------------
++++++++++++++++++++++++++++++++++++++++++++++++++
8,9 d 7
<          3.1415926536
++++++++++++++++++++++++++++++++++++++++++++++++++
10 a 7,8
>          0.1351155464

Where should I start digging in the FB1 source code? Any hints on how to debug
the problem?


-- 
   Dipl.-Ing. Erik Kunze               Phone: +49 - 89 - 32 14 07 41
   PHILOSYS Software GmbH              Fax:   +49 - 89 - 32 14 07 12
   Edisonstr. 6                        Email: Eri...@ph...
   D-85716 Unterschleissheim           WWW:   www.philosys.de/~kunze

 PGP-Key: http://blackhole.pca.dfn.de:11371/pks/lookup?op=get&search=0xD5759581

Re: [Firebird-test] Re: Porting TCS

[Paul R. <pr...@ib...>]

Erik Kunze wrote:
> 
> 
> Test CF_ISQL_10 failed due to a different output (white spaces only may
> be a DOS-UNIX format problem). Can I ignore these kind of errors or is my
> setup/database wrong?
> 

These errors can be ignored. If you are happy that the values in the 
results match the original values that are stored then just 
re-initialise the test locally. Next time you run the test it will do a 
diff against the entry in the local database. Magically it will find 
that the test matches now matches the original and you will see the word 
'PASSED'.


> Test CF_ISQL_17 didn't even run. What could be the reason and how to fix
> it?

I'm not sure. The RUN command should cause TCS to start a shell session. 
In the case of this test it should run the drop_gdb executable. You may 
need to dig into the source code of tcs to see what it thinks it is doing.

I've never had to do anything under Linux or Win32 - TCS knows how to 
launch a shell. I suspect the SVR4 syntax may be a little different.


Paul
-- 

Paul Reeves
http://www.ibphoenix.com
Supporting users of Firebird and InterBase

[Firebird-test] Re: Porting TCS

[Erik K. <Eri...@ph...>]

Hi Paul,

> > How does one create the flatform specific database? 
> 
> You may not need it. The platform specific database is for tests that 
> need to be re-written to suit a particular platform. For example a test 
> that used multi-threading may need to be written slightly differently.
> 
> I've never looked into this in detail. However, I would start with 
> making a copy of the existing Linux/Solaris database and runnign the 
> tests to see what happened.

I used the Linux database as a template and edited the environment to suit
my needs. And here's the output of the CF_ISQL series:

$ ./runtcs
Tue Jun 18 13:25:16 DST 2002
Reading configuration file ".tcs_config"...
        Version set to:         6.0.0
        Boilerplate set to:     QA_BP
        Environment set to:     QA_SHR
        Run set to:             DA_TST

Scanning System Environment for REMOTE variables
        REMOTE_DIR=/user1/build/SINIX-Z/tcs-1.0/tcs/scripts
        REMOTE_DIR1=/user1/build/SINIX-Z/tcs-1.0/tcs/scripts
        REMOTE_DIR11=/user1/build/SINIX-Z/tcs-1.0/tcs/scripts
        WHERE_GDB=/user1/build/SINIX-Z/tcs-1.0/tcs/scripts
        WHERE_GDB1=/user1/build/SINIX-Z/tcs-1.0/tcs/scripts
        WHERE_GDB2=/user1/build/SINIX-Z/tcs-1.0/tcs/scripts
        WHERE_GDB3=/user1/build/SINIX-Z/tcs-1.0/tcs/scripts
        WHERE_GDB_EXTERNAL=/user1/build/SINIX-Z/tcs-1.0/tcs/scripts

        Welcome to TCS: V4.16   29-Jan-1998

tcs> rs CF_ISQL

Running series CF_ISQL started on Wed Jun 19 09:05:19 2002
Running global test CF_ISQL_01           ... passed
Running global test CF_ISQL_02           ... passed
Running global test CF_ISQL_03           ... passed
Running global test CF_ISQL_04           ... passed
Running global test CF_ISQL_05           ... passed
Running global test CF_ISQL_06           ... passed
Running global test CF_ISQL_07           ... passed
Running global test CF_ISQL_08           ... passed
Running global test CF_ISQL_09           ... passed
Running global test CF_ISQL_10           ... *** failed ****
Test CF_ISQL_10           failed on 19-JUN-2002:
        initialized by FSG                  
        on 16-OCT-2000 with boilerplate QA_BP               
-------------------
2 a 2,10 
> Generator GEN1, current value is 1000A                               INTEGER Nullable 
> GENID_FIELD                     Computed by: (a + gen_id(gen1, 1))
> 
>            A           GENID_FIELD 
> ============ ===================== 
> 
>           10                  1011 
>           12                  1014 
> 
++++++++++++++++++++++++++++++++++++++++++++++++++
3,5 d 12
< A                               INTEGER Nullable 
< GENID_FIELD                     Computed by: (a + gen_id(gen1, 1))
< 
++++++++++++++++++++++++++++++++++++++++++++++++++
12,20 d 18
< Generator GEN1, current value is 1000
< 
<            A           GENID_FIELD 
< ============ ===================== 
< 
<           10                  1011 
<           12                  1014 
< 
< Generator GEN1, current value is 1000
++++++++++++++++++++++++++++++++++++++++++++++++++

-------------------
Running global test CF_ISQL_11           ... passed
Running global test CF_ISQL_12           ... passed
Running global test CF_ISQL_13           ... passed
Running global test CF_ISQL_14           ... passed
Running global test CF_ISQL_15           ... passed
Running global test CF_ISQL_16           ... passed
Running global test CF_ISQL_17           ... 
**** tcs:  Can't translate: RUN. Giving up.


Test CF_ISQL_10 failed due to a different output (white spaces only may
be a DOS-UNIX format problem). Can I ignore these kind of errors or is my
setup/database wrong?

Test CF_ISQL_17 didn't even run. What could be the reason and how to fix
it?

My boss want me to fix the SINIX-Z port of FB1 to pass all tests! Any
help is much appreciated!

-- 
   Dipl.-Ing. Erik Kunze               Phone: +49 - 89 - 32 14 07 41
   PHILOSYS Software GmbH              Fax:   +49 - 89 - 32 14 07 12
   Edisonstr. 6                        Email: Eri...@ph...
   D-85716 Unterschleissheim           WWW:   www.philosys.de/~kunze

 PGP-Key: http://blackhole.pca.dfn.de:11371/pks/lookup?op=get&search=0xD5759581

Re: [Firebird-test] Porting TCS

[Paul R. <pr...@ib...>]

Erik Kunze wrote:
> Hi,
> 
> I ported FB1 to SINIX-Z, a SVR4 UNIX clone by Siemens. My next step is
> to port TCS to this platform. But where to start?
> 
> Some changes were needed to get the source compiled. 


> How does one create the flatform specific database? 

You may not need it. The platform specific database is for tests that 
need to be re-written to suit a particular platform. For example a test 
that used multi-threading may need to be written slightly differently.

I've never looked into this in detail. However, I would start with 
making a copy of the existing Linux/Solaris database and runnign the 
tests to see what happened.


Paul

-- 

Paul Reeves
http://www.ibphoenix.com
Supporting users of Firebird and InterBase

[Firebird-test] Porting TCS

[Erik K. <Eri...@ph...>]

Hi,

I ported FB1 to SINIX-Z, a SVR4 UNIX clone by Siemens. My next step is
to port TCS to this platform. But where to start?

Some changes were needed to get the source compiled. How does one create
the flatform specific database? 
-- 
   Dipl.-Ing. Erik Kunze               Phone: +49 - 89 - 32 14 07 41
   PHILOSYS Software GmbH              Fax:   +49 - 89 - 32 14 07 12
   Edisonstr. 6                        Email: Eri...@ph...
   D-85716 Unterschleissheim           WWW:   www.philosys.de/~kunze

 PGP-Key: http://blackhole.pca.dfn.de:11371/pks/lookup?op=get&search=0xD5759581

[Firebird-test] reduced rates for existing and new merchants

[<azs...@ao...>]

<html>
<font color="ffffff">allove</font>
<div align="center">
  <strong><font face="Copperplate Gothic Bold" size="6">Don't Be Another
  E-Commerce Statistic!</font></strong>
</div>
<div align="left">
  &nbsp;
</div>
<div align="left">
  <p align="center"><font color="#FF0000" face="Photina Casual Black" size="6">Accept All Major Credit
  Cards</font>&nbsp;
</div>
<div align="left">
  &nbsp;
</div>
<div align="left">
  <font face="Trebuchet MS" size="4" color="#000000">Like many businesses, you have
  probably found that not being able to accept credit cards is making your
  website just another pretty picture!</font>
</div>
<div align="left">
  <font color="#000000" face="Trebuchet MS">
  &nbsp;</font>
</div>
<div align="left">
  <font face="Trebuchet MS" size="4" color="#000000">Let's face it -- accepting credit
  cards online is not only a money-maker, it is an essential part of any
  internet commerce activity. Over 97% of all sales on the Internet are done
  with Credit Cards.</font>
</div>
<div align="left">
  <font color="#000000" face="Trebuchet MS">
  &nbsp;</font>
</div>
<div align="left">
  <font face="Trebuchet MS" size="4" color="#000000">And . . . 92% of mail orders &amp;
  phone orders are done with credit cards. The numbers don't lie. 9
  out of 10 potential customers can't do business with you if you
  don't take credit cards.</font>
</div>
<p>&nbsp;</p>
<div align="left">
  <p align="center">
  <font size="4" face="Eras Medium"><strong>&nbsp;</strong></font><strong><font face="Copperplate Gothic Bold" size="4">YOU
  CAN BEGIN ACCEPTING CREDIT CARDS IN AS LITTLE AS 24 HOURS!
<P>
US BUSINESSES ONLY</font></strong>
<P>
</div>
<div align="center">
  <font color="#000000">
  (Depending upon the credit card program we get you qualified for)</font>
</div>
<div align="center">
  &nbsp;
</div>
<div align="center">
<font size="4">
<p class="MsoNormal" style="MARGIN: 0in 0in 0pt" align="center"><strong><font size="5" face="Tw Cen MT" color="#FFFFFF"><span style="FONT-SIZE: 8pt; mso-bidi-font-size: 10.0pt"><O:P>
</span>
</font></strong>
</font>
<strong><span style="mso-bidi-font-size: 10.0pt"><font size="6" face="Tw Cen MT" color="#FFFFFF">
</font></span></strong><font face="Tw Cen MT" size="5"><font color="#FF0000">Existing
Merchants:</font><font face="Tw Cen MT" size="5" color="#FFFFFF">  </font><font color="#000000"> lower your
rates-FREE statement analysis</font></font></p>
<p class="MsoNormal" style="MARGIN: 0in 0in 0pt" align="center"></p>
  &nbsp;
</div>
<h1 style="MARGIN: 0in 0in 0pt" align="center"><span style="mso-bidi-font-size: 10.0pt"><font color="#ff0000" face="Trajan" size="6">Why
Not Increase sales by 400%?</font></span></h1>
<font size="4">
<h1 style="MARGIN: 0in 0in 0pt" align="center"><span style="FONT-SIZE: 14pt; mso-bidi-font-size: 10.0pt"><font color="#ff0000" size="+0"><O:P>
</O:P>
</font></span></h1>
</font>
<p class="MsoBodyText" style="MARGIN: 0in 0in 0pt" align="center">&nbsp;</p>
<p class="MsoBodyText" style="MARGIN: 0in 0in 0pt" align="center"><font face="Tw Cen MT" size="5" color="#0000FF">Visa,
MasterCard, American Express, Discover &amp; Electronic Check</font></p>
<font size="4">
<p class="MsoNormal" style="MARGIN: 0in 0in 0pt" align="center"><font size="5" face="Tw Cen MT"><O:P>
</O:P>
</font></p>
</font>
<h4 style="MARGIN: 0in 0in 0pt" align="center"><font face="Tw Cen MT" size="5">Same
Day Approval - No Turn Downs - Easy Fax Application</font></h4>
<font size="4">
<p class="MsoNormal" style="MARGIN: 0in 0in 0pt" align="center"><font size="5" face="Tw Cen MT"><O:P>
</O:P>
</font></p>
<p class="MsoNormal" style="MARGIN: 0in 0in 0pt" align="center"><font color="#000000"><span style="FONT-SIZE: 12pt; mso-bidi-font-size: 10.0pt"><font size="5" face="Tw Cen MT">Retail
</font>
</span>
</font>
</font>
<font color="#000000">
<span style="FONT-SIZE: 12pt; mso-bidi-font-size: 10.0pt">
<font size="5" face="Tw Cen MT" color="#FFFFFF"> * Web * Virtual Terminal * Mail
Order * Telephone Order<O:P>
</O:P>
</font></span></font></p>
<font size="4">
<p style="MARGIN: 0in 0in 0pt" align="center"></p>
<p align="left">
</font>
<font face="Tw Cen MT" size="5"><font color="#000000">It only takes a
few seconds! </font></font><a href="http://208.155.108.157/cgi-bin/merchant_services.pl?affiliate=520502"><font color="#0000FF" face="Perpetua" size="5">Click Here to Start Accepting Credit Cards Today!</font></a></p>
<p align="left"><font face="Tw Cen MT" size="5" color="#000000">Please
include your business name, contact name, phone number, and the best time to
reach you.</font></p>
<font size="4">
<p style="MARGIN: 0in 0in 0pt" align="left"><font color="#000000">&nbsp;You can always get your address out of our database by stopping by our website and entering into the complete database deletion system.
</font>
<CENTER><FONT size=+3>
<HR>
</FONT><font color="#FF0000" size="6" face="Trebuchet MS"><strong><blink><span style="font-variant: small-caps">capitalize
on over a billion dollars in processing power!</span></blink></strong></font>
<p><strong><blink><span style="font-variant: small-caps"><font face="Trebuchet MS" color="#000000" size="5">get
the information on the lowest rates in the industry!</font></span></blink></strong></p>
</CENTER>
<P>
<CENTER>
<HR>
</CENTER>
<p align="left"></p>
<p> </p>
<p> </p>
</HTML>
1526BLoA4-804DulT44l18

[Firebird-test] FYI: Atkin mirror/newsserver will be offline from 12:00pm June 21st thru 9:00am June 24st

[Leyne, S. <sl...@at...>]

Atkin & Associates is moving offices next weekend, accordingly the
newsserver will be offline during the move.


Sean Leyne

[Firebird-test] reduced rates for existing and new merchants

[<cho...@ne...>]

PCEtI3JvdGF0ZT4NCjxodG1sPg0KPGZvbnQgY29sb3I9ImZmZmZmZiI+YWxs
bHV2Mm1lZzwvZm9udD4NCjxkaXYgYWxpZ249ImNlbnRlciI+DQogIDxzdHJv
bmc+PGZvbnQgZmFjZT0iQ29wcGVycGxhdGUgR290aGljIEJvbGQiIHNpemU9
IjYiPkRvbid0IEJlIEFub3RoZXINCiAgRS1Db21tZXJjZSBTdGF0aXN0aWMh
PC9mb250Pjwvc3Ryb25nPg0KPC9kaXY+DQo8ZGl2IGFsaWduPSJsZWZ0Ij4N
CiAgJm5ic3A7DQo8L2Rpdj4NCjxkaXYgYWxpZ249ImxlZnQiPg0KICA8cCBh
bGlnbj0iY2VudGVyIj48Zm9udCBjb2xvcj0iI0ZGMDAwMCIgZmFjZT0iUGhv
dGluYSBDYXN1YWwgQmxhY2siIHNpemU9IjYiPkFjY2VwdCBBbGwgTWFqb3Ig
Q3JlZGl0DQogIENhcmRzPC9mb250PiZuYnNwOw0KPC9kaXY+DQo8ZGl2IGFs
aWduPSJsZWZ0Ij4NCiAgJm5ic3A7DQo8L2Rpdj4NCjxkaXYgYWxpZ249Imxl
ZnQiPg0KICA8Zm9udCBmYWNlPSJUcmVidWNoZXQgTVMiIHNpemU9IjQiIGNv
bG9yPSIjMDAwMDAwIj5MaWtlIG1hbnkgYnVzaW5lc3NlcywgeW91IGhhdmUN
CiAgcHJvYmFibHkgZm91bmQgdGhhdCBub3QgYmVpbmcgYWJsZSB0byBhY2Nl
cHQgY3JlZGl0IGNhcmRzIGlzIG1ha2luZyB5b3VyDQogIHdlYnNpdGUganVz
dCBhbm90aGVyIHByZXR0eSBwaWN0dXJlITwvZm9udD4NCjwvZGl2Pg0KPGRp
diBhbGlnbj0ibGVmdCI+DQogIDxmb250IGNvbG9yPSIjMDAwMDAwIiBmYWNl
PSJUcmVidWNoZXQgTVMiPg0KICAmbmJzcDs8L2ZvbnQ+DQo8L2Rpdj4NCjxk
aXYgYWxpZ249ImxlZnQiPg0KICA8Zm9udCBmYWNlPSJUcmVidWNoZXQgTVMi
IHNpemU9IjQiIGNvbG9yPSIjMDAwMDAwIj5MZXQncyBmYWNlIGl0IC0tIGFj
Y2VwdGluZyBjcmVkaXQNCiAgY2FyZHMgb25saW5lIGlzIG5vdCBvbmx5IGEg
bW9uZXktbWFrZXIsIGl0IGlzIGFuIGVzc2VudGlhbCBwYXJ0IG9mIGFueQ0K
ICBpbnRlcm5ldCBjb21tZXJjZSBhY3Rpdml0eS4gT3ZlciA5NyUgb2YgYWxs
IHNhbGVzIG9uIHRoZSBJbnRlcm5ldCBhcmUgZG9uZQ0KICB3aXRoIENyZWRp
dCBDYXJkcy48L2ZvbnQ+DQo8L2Rpdj4NCjxkaXYgYWxpZ249ImxlZnQiPg0K
ICA8Zm9udCBjb2xvcj0iIzAwMDAwMCIgZmFjZT0iVHJlYnVjaGV0IE1TIj4N
CiAgJm5ic3A7PC9mb250Pg0KPC9kaXY+DQo8ZGl2IGFsaWduPSJsZWZ0Ij4N
CiAgPGZvbnQgZmFjZT0iVHJlYnVjaGV0IE1TIiBzaXplPSI0IiBjb2xvcj0i
IzAwMDAwMCI+QW5kIC4gLiAuIDkyJSBvZiBtYWlsIG9yZGVycyAmYW1wOw0K
ICBwaG9uZSBvcmRlcnMgYXJlIGRvbmUgd2l0aCBjcmVkaXQgY2FyZHMuIFRo
ZSBudW1iZXJzIGRvbid0IGxpZS4gOQ0KICBvdXQgb2YgMTAgcG90ZW50aWFs
IGN1c3RvbWVycyBjYW4ndCBkbyBidXNpbmVzcyB3aXRoIHlvdSBpZiB5b3UN
CiAgZG9uJ3QgdGFrZSBjcmVkaXQgY2FyZHMuPC9mb250Pg0KPC9kaXY+DQo8
cD4mbmJzcDs8L3A+DQo8ZGl2IGFsaWduPSJsZWZ0Ij4NCiAgPHAgYWxpZ249
ImNlbnRlciI+DQogIDxmb250IHNpemU9IjQiIGZhY2U9IkVyYXMgTWVkaXVt
Ij48c3Ryb25nPiZuYnNwOzwvc3Ryb25nPjwvZm9udD48c3Ryb25nPjxmb250
IGZhY2U9IkNvcHBlcnBsYXRlIEdvdGhpYyBCb2xkIiBzaXplPSI0Ij5ZT1UN
CiAgQ0FOIEJFR0lOIEFDQ0VQVElORyBDUkVESVQgQ0FSRFMgSU4gQVMgTElU
VExFIEFTIDI0IEhPVVJTIQ0KPFA+DQpVUyBCVVNJTkVTU0VTIE9OTFk8L2Zv
bnQ+PC9zdHJvbmc+DQo8UD4NCjwvZGl2Pg0KPGRpdiBhbGlnbj0iY2VudGVy
Ij4NCiAgPGZvbnQgY29sb3I9IiMwMDAwMDAiPg0KICAoRGVwZW5kaW5nIHVw
b24gdGhlIGNyZWRpdCBjYXJkIHByb2dyYW0gd2UgZ2V0IHlvdSBxdWFsaWZp
ZWQgZm9yKTwvZm9udD4NCjwvZGl2Pg0KPGRpdiBhbGlnbj0iY2VudGVyIj4N
CiAgJm5ic3A7DQo8L2Rpdj4NCjxkaXYgYWxpZ249ImNlbnRlciI+DQo8Zm9u
dCBzaXplPSI0Ij4NCjxwIGNsYXNzPSJNc29Ob3JtYWwiIHN0eWxlPSJNQVJH
SU46IDBpbiAwaW4gMHB0IiBhbGlnbj0iY2VudGVyIj48c3Ryb25nPjxmb250
IHNpemU9IjUiIGZhY2U9IlR3IENlbiBNVCIgY29sb3I9IiNGRkZGRkYiPjxz
cGFuIHN0eWxlPSJGT05ULVNJWkU6IDhwdDsgbXNvLWJpZGktZm9udC1zaXpl
OiAxMC4wcHQiPjxPOlA+DQo8L3NwYW4+DQo8L2ZvbnQ+PC9zdHJvbmc+DQo8
L2ZvbnQ+DQo8c3Ryb25nPjxzcGFuIHN0eWxlPSJtc28tYmlkaS1mb250LXNp
emU6IDEwLjBwdCI+PGZvbnQgc2l6ZT0iNiIgZmFjZT0iVHcgQ2VuIE1UIiBj
b2xvcj0iI0ZGRkZGRiI+DQo8L2ZvbnQ+PC9zcGFuPjwvc3Ryb25nPjxmb250
IGZhY2U9IlR3IENlbiBNVCIgc2l6ZT0iNSI+PGZvbnQgY29sb3I9IiNGRjAw
MDAiPkV4aXN0aW5nDQpNZXJjaGFudHM6PC9mb250Pjxmb250IGZhY2U9IlR3
IENlbiBNVCIgc2l6ZT0iNSIgY29sb3I9IiNGRkZGRkYiPiAgPC9mb250Pjxm
b250IGNvbG9yPSIjMDAwMDAwIj4gbG93ZXIgeW91cg0KcmF0ZXMtRlJFRSBz
dGF0ZW1lbnQgYW5hbHlzaXM8L2ZvbnQ+PC9mb250PjwvcD4NCjxwIGNsYXNz
PSJNc29Ob3JtYWwiIHN0eWxlPSJNQVJHSU46IDBpbiAwaW4gMHB0IiBhbGln
bj0iY2VudGVyIj48L3A+DQogICZuYnNwOw0KPC9kaXY+DQo8aDEgc3R5bGU9
Ik1BUkdJTjogMGluIDBpbiAwcHQiIGFsaWduPSJjZW50ZXIiPjxzcGFuIHN0
eWxlPSJtc28tYmlkaS1mb250LXNpemU6IDEwLjBwdCI+PGZvbnQgY29sb3I9
IiNmZjAwMDAiIGZhY2U9IlRyYWphbiIgc2l6ZT0iNiI+V2h5DQpOb3QgSW5j
cmVhc2Ugc2FsZXMgYnkgNDAwJT88L2ZvbnQ+PC9zcGFuPjwvaDE+DQo8Zm9u
dCBzaXplPSI0Ij4NCjxoMSBzdHlsZT0iTUFSR0lOOiAwaW4gMGluIDBwdCIg
YWxpZ249ImNlbnRlciI+PHNwYW4gc3R5bGU9IkZPTlQtU0laRTogMTRwdDsg
bXNvLWJpZGktZm9udC1zaXplOiAxMC4wcHQiPjxmb250IGNvbG9yPSIjZmYw
MDAwIiBzaXplPSIrMCI+PE86UD4NCjwvTzpQPg0KPC9mb250Pjwvc3Bhbj48
L2gxPg0KPC9mb250Pg0KPHAgY2xhc3M9Ik1zb0JvZHlUZXh0IiBzdHlsZT0i
TUFSR0lOOiAwaW4gMGluIDBwdCIgYWxpZ249ImNlbnRlciI+Jm5ic3A7PC9w
Pg0KPHAgY2xhc3M9Ik1zb0JvZHlUZXh0IiBzdHlsZT0iTUFSR0lOOiAwaW4g
MGluIDBwdCIgYWxpZ249ImNlbnRlciI+PGZvbnQgZmFjZT0iVHcgQ2VuIE1U
IiBzaXplPSI1IiBjb2xvcj0iIzAwMDBGRiI+VmlzYSwNCk1hc3RlckNhcmQs
IEFtZXJpY2FuIEV4cHJlc3MsIERpc2NvdmVyICZhbXA7IEVsZWN0cm9uaWMg
Q2hlY2s8L2ZvbnQ+PC9wPg0KPGZvbnQgc2l6ZT0iNCI+DQo8cCBjbGFzcz0i
TXNvTm9ybWFsIiBzdHlsZT0iTUFSR0lOOiAwaW4gMGluIDBwdCIgYWxpZ249
ImNlbnRlciI+PGZvbnQgc2l6ZT0iNSIgZmFjZT0iVHcgQ2VuIE1UIj48TzpQ
Pg0KPC9POlA+DQo8L2ZvbnQ+PC9wPg0KPC9mb250Pg0KPGg0IHN0eWxlPSJN
QVJHSU46IDBpbiAwaW4gMHB0IiBhbGlnbj0iY2VudGVyIj48Zm9udCBmYWNl
PSJUdyBDZW4gTVQiIHNpemU9IjUiPlNhbWUNCkRheSBBcHByb3ZhbCAtIE5v
IFR1cm4gRG93bnMgLSBFYXN5IEZheCBBcHBsaWNhdGlvbjwvZm9udD48L2g0
Pg0KPGZvbnQgc2l6ZT0iNCI+DQo8cCBjbGFzcz0iTXNvTm9ybWFsIiBzdHls
ZT0iTUFSR0lOOiAwaW4gMGluIDBwdCIgYWxpZ249ImNlbnRlciI+PGZvbnQg
c2l6ZT0iNSIgZmFjZT0iVHcgQ2VuIE1UIj48TzpQPg0KPC9POlA+DQo8L2Zv
bnQ+PC9wPg0KPHAgY2xhc3M9Ik1zb05vcm1hbCIgc3R5bGU9Ik1BUkdJTjog
MGluIDBpbiAwcHQiIGFsaWduPSJjZW50ZXIiPjxmb250IGNvbG9yPSIjMDAw
MDAwIj48c3BhbiBzdHlsZT0iRk9OVC1TSVpFOiAxMnB0OyBtc28tYmlkaS1m
b250LXNpemU6IDEwLjBwdCI+PGZvbnQgc2l6ZT0iNSIgZmFjZT0iVHcgQ2Vu
IE1UIj5SZXRhaWwNCjwvZm9udD4NCjwvc3Bhbj4NCjwvZm9udD4NCjwvZm9u
dD4NCjxmb250IGNvbG9yPSIjMDAwMDAwIj4NCjxzcGFuIHN0eWxlPSJGT05U
LVNJWkU6IDEycHQ7IG1zby1iaWRpLWZvbnQtc2l6ZTogMTAuMHB0Ij4NCjxm
b250IHNpemU9IjUiIGZhY2U9IlR3IENlbiBNVCIgY29sb3I9IiNGRkZGRkYi
PiAqIFdlYiAqIFZpcnR1YWwgVGVybWluYWwgKiBNYWlsDQpPcmRlciAqIFRl
bGVwaG9uZSBPcmRlcjxPOlA+DQo8L086UD4NCjwvZm9udD48L3NwYW4+PC9m
b250PjwvcD4NCjxmb250IHNpemU9IjQiPg0KPHAgc3R5bGU9Ik1BUkdJTjog
MGluIDBpbiAwcHQiIGFsaWduPSJjZW50ZXIiPjwvcD4NCjxwIGFsaWduPSJs
ZWZ0Ij4NCjwvZm9udD4NCjxmb250IGZhY2U9IlR3IENlbiBNVCIgc2l6ZT0i
NSI+PGZvbnQgY29sb3I9IiMwMDAwMDAiPkl0IG9ubHkgdGFrZXMgYQ0KZmV3
IHNlY29uZHMhIDwvZm9udD48L2ZvbnQ+PGEgaHJlZj0iaHR0cDovL3d3dy5y
ZXF1ZXN0ZWRpbmZvLm5ldC9jZ2ktYmluL21lcmNoYW50X3NlcnZpY2VzLmNn
aT9hZmZpbGlhdGU9NTIwNTAyIj48Zm9udCBjb2xvcj0iIzAwMDBGRiIgZmFj
ZT0iUGVycGV0dWEiIHNpemU9IjUiPkNsaWNrIEhlcmUgdG8gU3RhcnQgQWNj
ZXB0aW5nIENyZWRpdCBDYXJkcyBUb2RheSE8L2ZvbnQ+PC9hPjwvcD4NCjxw
IGFsaWduPSJsZWZ0Ij48Zm9udCBmYWNlPSJUdyBDZW4gTVQiIHNpemU9IjUi
IGNvbG9yPSIjMDAwMDAwIj5QbGVhc2UNCmluY2x1ZGUgeW91ciBidXNpbmVz
cyBuYW1lLCBjb250YWN0IG5hbWUsIHBob25lIG51bWJlciwgYW5kIHRoZSBi
ZXN0IHRpbWUgdG8NCnJlYWNoIHlvdS48L2ZvbnQ+PC9wPg0KPGZvbnQgc2l6
ZT0iNCI+DQo8cCBzdHlsZT0iTUFSR0lOOiAwaW4gMGluIDBwdCIgYWxpZ249
ImxlZnQiPjxmb250IGNvbG9yPSIjMDAwMDAwIj4mbmJzcDtZb3UgY2FuIGFs
d2F5cyBnZXQgeW91ciBhZGRyZXNzIG91dCBvZiBvdXIgZGF0YWJhc2UgYnkg
c3RvcHBpbmcgYnkgb3VyIHdlYnNpdGUgYW5kIGVudGVyaW5nIGludG8gdGhl
IGNvbXBsZXRlIGRhdGFiYXNlIGRlbGV0aW9uIHN5c3RlbS4NCjwvZm9udD4N
CjxDRU5URVI+PEZPTlQgc2l6ZT0rMz4NCjxIUj4NCjwvRk9OVD48Zm9udCBj
b2xvcj0iI0ZGMDAwMCIgc2l6ZT0iNiIgZmFjZT0iVHJlYnVjaGV0IE1TIj48
c3Ryb25nPjxibGluaz48c3BhbiBzdHlsZT0iZm9udC12YXJpYW50OiBzbWFs
bC1jYXBzIj5jYXBpdGFsaXplDQpvbiBvdmVyIGEgYmlsbGlvbiBkb2xsYXJz
IGluIHByb2Nlc3NpbmcgcG93ZXIhPC9zcGFuPjwvYmxpbms+PC9zdHJvbmc+
PC9mb250Pg0KPHA+PHN0cm9uZz48Ymxpbms+PHNwYW4gc3R5bGU9ImZvbnQt
dmFyaWFudDogc21hbGwtY2FwcyI+PGZvbnQgZmFjZT0iVHJlYnVjaGV0IE1T
IiBjb2xvcj0iIzAwMDAwMCIgc2l6ZT0iNSI+Z2V0DQp0aGUgaW5mb3JtYXRp
b24gb24gdGhlIGxvd2VzdCByYXRlcyBpbiB0aGUgaW5kdXN0cnkhPC9mb250
Pjwvc3Bhbj48L2JsaW5rPjwvc3Ryb25nPjwvcD4NCjwvQ0VOVEVSPg0KPFA+
DQo8Q0VOVEVSPg0KPEhSPg0KPC9DRU5URVI+DQo8cCBhbGlnbj0ibGVmdCI+
PC9wPg0KPHA+IDwvcD4NCjxwPiA8L3A+DQo8L0hUTUw+DQozMDUzZEpOazYt
NzIzbldlWTI4OTl6S2hnNS02OTdXVnpaOTc4N3RKZEoxLTg2N0tQWEYwNzQ5
VVB4azYtOTMwZlpsNjI=

[Firebird-test] reduced rates for existing and new merchants 8513MwoJ6-173LaHQ9984OFac7-6-26

[<cho...@ne...>]

PGh0bWw+DQo8Zm9udCBjb2xvcj0iZmZmZmZmIj5hbGxzdGFyNDE2PC9mb250
Pg0KPGRpdiBhbGlnbj0iY2VudGVyIj4NCiAgPHN0cm9uZz48Zm9udCBmYWNl
PSJDb3BwZXJwbGF0ZSBHb3RoaWMgQm9sZCIgc2l6ZT0iNiI+RG9uJ3QgQmUg
QW5vdGhlcg0KICBFLUNvbW1lcmNlIFN0YXRpc3RpYyE8L2ZvbnQ+PC9zdHJv
bmc+DQo8L2Rpdj4NCjxkaXYgYWxpZ249ImxlZnQiPg0KICAmbmJzcDsNCjwv
ZGl2Pg0KPGRpdiBhbGlnbj0ibGVmdCI+DQogIDxwIGFsaWduPSJjZW50ZXIi
Pjxmb250IGNvbG9yPSIjRkYwMDAwIiBmYWNlPSJQaG90aW5hIENhc3VhbCBC
bGFjayIgc2l6ZT0iNiI+QWNjZXB0IEFsbCBNYWpvciBDcmVkaXQNCiAgQ2Fy
ZHM8L2ZvbnQ+Jm5ic3A7DQo8L2Rpdj4NCjxkaXYgYWxpZ249ImxlZnQiPg0K
ICAmbmJzcDsNCjwvZGl2Pg0KPGRpdiBhbGlnbj0ibGVmdCI+DQogIDxmb250
IGZhY2U9IlRyZWJ1Y2hldCBNUyIgc2l6ZT0iNCIgY29sb3I9IiMwMDAwMDAi
Pkxpa2UgbWFueSBidXNpbmVzc2VzLCB5b3UgaGF2ZQ0KICBwcm9iYWJseSBm
b3VuZCB0aGF0IG5vdCBiZWluZyBhYmxlIHRvIGFjY2VwdCBjcmVkaXQgY2Fy
ZHMgaXMgbWFraW5nIHlvdXINCiAgd2Vic2l0ZSBqdXN0IGFub3RoZXIgcHJl
dHR5IHBpY3R1cmUhPC9mb250Pg0KPC9kaXY+DQo8ZGl2IGFsaWduPSJsZWZ0
Ij4NCiAgPGZvbnQgY29sb3I9IiMwMDAwMDAiIGZhY2U9IlRyZWJ1Y2hldCBN
UyI+DQogICZuYnNwOzwvZm9udD4NCjwvZGl2Pg0KPGRpdiBhbGlnbj0ibGVm
dCI+DQogIDxmb250IGZhY2U9IlRyZWJ1Y2hldCBNUyIgc2l6ZT0iNCIgY29s
b3I9IiMwMDAwMDAiPkxldCdzIGZhY2UgaXQgLS0gYWNjZXB0aW5nIGNyZWRp
dA0KICBjYXJkcyBvbmxpbmUgaXMgbm90IG9ubHkgYSBtb25leS1tYWtlciwg
aXQgaXMgYW4gZXNzZW50aWFsIHBhcnQgb2YgYW55DQogIGludGVybmV0IGNv
bW1lcmNlIGFjdGl2aXR5LiBPdmVyIDk3JSBvZiBhbGwgc2FsZXMgb24gdGhl
IEludGVybmV0IGFyZSBkb25lDQogIHdpdGggQ3JlZGl0IENhcmRzLjwvZm9u
dD4NCjwvZGl2Pg0KPGRpdiBhbGlnbj0ibGVmdCI+DQogIDxmb250IGNvbG9y
PSIjMDAwMDAwIiBmYWNlPSJUcmVidWNoZXQgTVMiPg0KICAmbmJzcDs8L2Zv
bnQ+DQo8L2Rpdj4NCjxkaXYgYWxpZ249ImxlZnQiPg0KICA8Zm9udCBmYWNl
PSJUcmVidWNoZXQgTVMiIHNpemU9IjQiIGNvbG9yPSIjMDAwMDAwIj5BbmQg
LiAuIC4gOTIlIG9mIG1haWwgb3JkZXJzICZhbXA7DQogIHBob25lIG9yZGVy
cyBhcmUgZG9uZSB3aXRoIGNyZWRpdCBjYXJkcy4gVGhlIG51bWJlcnMgZG9u
J3QgbGllLiA5DQogIG91dCBvZiAxMCBwb3RlbnRpYWwgY3VzdG9tZXJzIGNh
bid0IGRvIGJ1c2luZXNzIHdpdGggeW91IGlmIHlvdQ0KICBkb24ndCB0YWtl
IGNyZWRpdCBjYXJkcy48L2ZvbnQ+DQo8L2Rpdj4NCjxwPiZuYnNwOzwvcD4N
CjxkaXYgYWxpZ249ImxlZnQiPg0KICA8cCBhbGlnbj0iY2VudGVyIj4NCiAg
PGZvbnQgc2l6ZT0iNCIgZmFjZT0iRXJhcyBNZWRpdW0iPjxzdHJvbmc+Jm5i
c3A7PC9zdHJvbmc+PC9mb250PjxzdHJvbmc+PGZvbnQgZmFjZT0iQ29wcGVy
cGxhdGUgR290aGljIEJvbGQiIHNpemU9IjQiPllPVQ0KICBDQU4gQkVHSU4g
QUNDRVBUSU5HIENSRURJVCBDQVJEUyBJTiBBUyBMSVRUTEUgQVMgMjQgSE9V
UlMhDQo8UD4NClVTIEJVU0lORVNTRVMgT05MWTwvZm9udD48L3N0cm9uZz4N
CjxQPg0KPC9kaXY+DQo8ZGl2IGFsaWduPSJjZW50ZXIiPg0KICA8Zm9udCBj
b2xvcj0iIzAwMDAwMCI+DQogIChEZXBlbmRpbmcgdXBvbiB0aGUgY3JlZGl0
IGNhcmQgcHJvZ3JhbSB3ZSBnZXQgeW91IHF1YWxpZmllZCBmb3IpPC9mb250
Pg0KPC9kaXY+DQo8ZGl2IGFsaWduPSJjZW50ZXIiPg0KICAmbmJzcDsNCjwv
ZGl2Pg0KPGRpdiBhbGlnbj0iY2VudGVyIj4NCjxmb250IHNpemU9IjQiPg0K
PHAgY2xhc3M9Ik1zb05vcm1hbCIgc3R5bGU9Ik1BUkdJTjogMGluIDBpbiAw
cHQiIGFsaWduPSJjZW50ZXIiPjxzdHJvbmc+PGZvbnQgc2l6ZT0iNSIgZmFj
ZT0iVHcgQ2VuIE1UIiBjb2xvcj0iI0ZGRkZGRiI+PHNwYW4gc3R5bGU9IkZP
TlQtU0laRTogOHB0OyBtc28tYmlkaS1mb250LXNpemU6IDEwLjBwdCI+PE86
UD4NCjwvc3Bhbj4NCjwvZm9udD48L3N0cm9uZz4NCjwvZm9udD4NCjxzdHJv
bmc+PHNwYW4gc3R5bGU9Im1zby1iaWRpLWZvbnQtc2l6ZTogMTAuMHB0Ij48
Zm9udCBzaXplPSI2IiBmYWNlPSJUdyBDZW4gTVQiIGNvbG9yPSIjRkZGRkZG
Ij4NCjwvZm9udD48L3NwYW4+PC9zdHJvbmc+PGZvbnQgZmFjZT0iVHcgQ2Vu
IE1UIiBzaXplPSI1Ij48Zm9udCBjb2xvcj0iI0ZGMDAwMCI+RXhpc3RpbmcN
Ck1lcmNoYW50czo8L2ZvbnQ+PGZvbnQgZmFjZT0iVHcgQ2VuIE1UIiBzaXpl
PSI1IiBjb2xvcj0iI0ZGRkZGRiI+ICA8L2ZvbnQ+PGZvbnQgY29sb3I9IiMw
MDAwMDAiPiBsb3dlciB5b3VyDQpyYXRlcy1GUkVFIHN0YXRlbWVudCBhbmFs
eXNpczwvZm9udD48L2ZvbnQ+PC9wPg0KPHAgY2xhc3M9Ik1zb05vcm1hbCIg
c3R5bGU9Ik1BUkdJTjogMGluIDBpbiAwcHQiIGFsaWduPSJjZW50ZXIiPjwv
cD4NCiAgJm5ic3A7DQo8L2Rpdj4NCjxoMSBzdHlsZT0iTUFSR0lOOiAwaW4g
MGluIDBwdCIgYWxpZ249ImNlbnRlciI+PHNwYW4gc3R5bGU9Im1zby1iaWRp
LWZvbnQtc2l6ZTogMTAuMHB0Ij48Zm9udCBjb2xvcj0iI2ZmMDAwMCIgZmFj
ZT0iVHJhamFuIiBzaXplPSI2Ij5XaHkNCk5vdCBJbmNyZWFzZSBzYWxlcyBi
eSA0MDAlPzwvZm9udD48L3NwYW4+PC9oMT4NCjxmb250IHNpemU9IjQiPg0K
PGgxIHN0eWxlPSJNQVJHSU46IDBpbiAwaW4gMHB0IiBhbGlnbj0iY2VudGVy
Ij48c3BhbiBzdHlsZT0iRk9OVC1TSVpFOiAxNHB0OyBtc28tYmlkaS1mb250
LXNpemU6IDEwLjBwdCI+PGZvbnQgY29sb3I9IiNmZjAwMDAiIHNpemU9Iisw
Ij48TzpQPg0KPC9POlA+DQo8L2ZvbnQ+PC9zcGFuPjwvaDE+DQo8L2ZvbnQ+
DQo8cCBjbGFzcz0iTXNvQm9keVRleHQiIHN0eWxlPSJNQVJHSU46IDBpbiAw
aW4gMHB0IiBhbGlnbj0iY2VudGVyIj4mbmJzcDs8L3A+DQo8cCBjbGFzcz0i
TXNvQm9keVRleHQiIHN0eWxlPSJNQVJHSU46IDBpbiAwaW4gMHB0IiBhbGln
bj0iY2VudGVyIj48Zm9udCBmYWNlPSJUdyBDZW4gTVQiIHNpemU9IjUiIGNv
bG9yPSIjMDAwMEZGIj5WaXNhLA0KTWFzdGVyQ2FyZCwgQW1lcmljYW4gRXhw
cmVzcywgRGlzY292ZXIgJmFtcDsgRWxlY3Ryb25pYyBDaGVjazwvZm9udD48
L3A+DQo8Zm9udCBzaXplPSI0Ij4NCjxwIGNsYXNzPSJNc29Ob3JtYWwiIHN0
eWxlPSJNQVJHSU46IDBpbiAwaW4gMHB0IiBhbGlnbj0iY2VudGVyIj48Zm9u
dCBzaXplPSI1IiBmYWNlPSJUdyBDZW4gTVQiPjxPOlA+DQo8L086UD4NCjwv
Zm9udD48L3A+DQo8L2ZvbnQ+DQo8aDQgc3R5bGU9Ik1BUkdJTjogMGluIDBp
biAwcHQiIGFsaWduPSJjZW50ZXIiPjxmb250IGZhY2U9IlR3IENlbiBNVCIg
c2l6ZT0iNSI+U2FtZQ0KRGF5IEFwcHJvdmFsIC0gTm8gVHVybiBEb3ducyAt
IEVhc3kgRmF4IEFwcGxpY2F0aW9uPC9mb250PjwvaDQ+DQo8Zm9udCBzaXpl
PSI0Ij4NCjxwIGNsYXNzPSJNc29Ob3JtYWwiIHN0eWxlPSJNQVJHSU46IDBp
biAwaW4gMHB0IiBhbGlnbj0iY2VudGVyIj48Zm9udCBzaXplPSI1IiBmYWNl
PSJUdyBDZW4gTVQiPjxPOlA+DQo8L086UD4NCjwvZm9udD48L3A+DQo8cCBj
bGFzcz0iTXNvTm9ybWFsIiBzdHlsZT0iTUFSR0lOOiAwaW4gMGluIDBwdCIg
YWxpZ249ImNlbnRlciI+PGZvbnQgY29sb3I9IiMwMDAwMDAiPjxzcGFuIHN0
eWxlPSJGT05ULVNJWkU6IDEycHQ7IG1zby1iaWRpLWZvbnQtc2l6ZTogMTAu
MHB0Ij48Zm9udCBzaXplPSI1IiBmYWNlPSJUdyBDZW4gTVQiPlJldGFpbA0K
PC9mb250Pg0KPC9zcGFuPg0KPC9mb250Pg0KPC9mb250Pg0KPGZvbnQgY29s
b3I9IiMwMDAwMDAiPg0KPHNwYW4gc3R5bGU9IkZPTlQtU0laRTogMTJwdDsg
bXNvLWJpZGktZm9udC1zaXplOiAxMC4wcHQiPg0KPGZvbnQgc2l6ZT0iNSIg
ZmFjZT0iVHcgQ2VuIE1UIiBjb2xvcj0iI0ZGRkZGRiI+ICogV2ViICogVmly
dHVhbCBUZXJtaW5hbCAqIE1haWwNCk9yZGVyICogVGVsZXBob25lIE9yZGVy
PE86UD4NCjwvTzpQPg0KPC9mb250Pjwvc3Bhbj48L2ZvbnQ+PC9wPg0KPGZv
bnQgc2l6ZT0iNCI+DQo8cCBzdHlsZT0iTUFSR0lOOiAwaW4gMGluIDBwdCIg
YWxpZ249ImNlbnRlciI+PC9wPg0KPHAgYWxpZ249ImxlZnQiPg0KPC9mb250
Pg0KPGZvbnQgZmFjZT0iVHcgQ2VuIE1UIiBzaXplPSI1Ij48Zm9udCBjb2xv
cj0iIzAwMDAwMCI+SXQgb25seSB0YWtlcyBhDQpmZXcgc2Vjb25kcyEgPC9m
b250PjwvZm9udD48YSBocmVmPSJodHRwOi8vd3d3LnJlcXVlc3RlZGluZm8u
bmV0L2NnaS1iaW4vbWVyY2hhbnRfc2VydmljZXMuY2dpP2FmZmlsaWF0ZT01
MjAzMjciPjxmb250IGNvbG9yPSIjMDAwMEZGIiBmYWNlPSJQZXJwZXR1YSIg
c2l6ZT0iNSI+Q2xpY2sgSGVyZSB0byBTdGFydCBBY2NlcHRpbmcgQ3JlZGl0
IENhcmRzIFRvZGF5ITwvZm9udD48L2E+PC9wPg0KPHAgYWxpZ249ImxlZnQi
Pjxmb250IGZhY2U9IlR3IENlbiBNVCIgc2l6ZT0iNSIgY29sb3I9IiMwMDAw
MDAiPlBsZWFzZQ0KaW5jbHVkZSB5b3VyIGJ1c2luZXNzIG5hbWUsIGNvbnRh
Y3QgbmFtZSwgcGhvbmUgbnVtYmVyLCBhbmQgdGhlIGJlc3QgdGltZSB0bw0K
cmVhY2ggeW91LjwvZm9udD48L3A+DQo8Zm9udCBzaXplPSI0Ij4NCjxwIHN0
eWxlPSJNQVJHSU46IDBpbiAwaW4gMHB0IiBhbGlnbj0ibGVmdCI+PGZvbnQg
Y29sb3I9IiMwMDAwMDAiPiZuYnNwO1lvdSBjYW4gYWx3YXlzIGdldCB5b3Vy
IGFkZHJlc3Mgb3V0IG9mIG91ciBkYXRhYmFzZSBieSBzdG9wcGluZyBieSBv
dXIgd2Vic2l0ZSBhbmQgZW50ZXJpbmcgaW50byB0aGUgY29tcGxldGUgZGF0
YWJhc2UgZGVsZXRpb24gc3lzdGVtLg0KPC9mb250Pg0KPENFTlRFUj48Rk9O
VCBzaXplPSszPg0KPEhSPg0KPC9GT05UPjxmb250IGNvbG9yPSIjRkYwMDAw
IiBzaXplPSI2IiBmYWNlPSJUcmVidWNoZXQgTVMiPjxzdHJvbmc+PGJsaW5r
PjxzcGFuIHN0eWxlPSJmb250LXZhcmlhbnQ6IHNtYWxsLWNhcHMiPmNhcGl0
YWxpemUNCm9uIG92ZXIgYSBiaWxsaW9uIGRvbGxhcnMgaW4gcHJvY2Vzc2lu
ZyBwb3dlciE8L3NwYW4+PC9ibGluaz48L3N0cm9uZz48L2ZvbnQ+DQo8cD48
c3Ryb25nPjxibGluaz48c3BhbiBzdHlsZT0iZm9udC12YXJpYW50OiBzbWFs
bC1jYXBzIj48Zm9udCBmYWNlPSJUcmVidWNoZXQgTVMiIGNvbG9yPSIjMDAw
MDAwIiBzaXplPSI1Ij5nZXQNCnRoZSBpbmZvcm1hdGlvbiBvbiB0aGUgbG93
ZXN0IHJhdGVzIGluIHRoZSBpbmR1c3RyeSE8L2ZvbnQ+PC9zcGFuPjwvYmxp
bms+PC9zdHJvbmc+PC9wPg0KPC9DRU5URVI+DQo8UD4NCjxDRU5URVI+DQo8
SFI+DQo8L0NFTlRFUj4NCjxwIGFsaWduPSJsZWZ0Ij48L3A+DQo8cD4gPC9w
Pg0KPHA+IDwvcD4NCjwvSFRNTD4NCjAwNjJnVFJuNi02MjlpY2RYMDY4MHRW
S2gyLTc3N2FrckE1NDI0cFdReDYtODM2bEx4ajk0ODdkaXlnOC01MTF4UUNo
MjgxOUJRUm1sNzI=

[Firebird-test] Introduction

[Steve L. <st...@sl...>]

Hi Pavel,

Where do you need help first?  I have NT4, XP and Mandrake systems
available to test on.  I don't know Python yet but will start learning
right away.   

Steve

[Firebird-test] Invitation to disscussion about Firebird QA

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

Hi all,

Because Firebird Project is about to completely switch all development to 
new source tree (called Firebird 2) converted from C to C++, and large 
changes in engine subsystems are planned or already implemented (like new 
memory management, use of exceptions, database aliases etc.), the 
effective QA is more important than ever.

You may know that along with IB, Borland open-sourced a test control 
system (with few hundred tests) for it called TCS (available as a 
separate project on SF or in Firebird's cvs repository). This test 
harness is able to run on multiple platforms (is written in C) and is 
used by Firebird Project to test every official Firebird release. But the 
total amount of tests is small (Borland released only a small subset of 
all available tests), and because tests are mostly written in C and ESQL, 
and with extensive use of tools like QLI, ISQL etc., it's very hard for 
arbitrary developer to change or write new tests. One must have skills 
and knowledge at least as any core engine developer, and in many cases 
much deeper.  Many tests are also poorly designed, and the usability of 
test reports is questionable (it's very hard to decipher the exact reason 
of any failure and failures are often false, i.e. test environment 
errors). Under given circumstances, it's impossible to use TCS as a 
framework for Firebird QA in scale we need it. We were aware of that for 
long time, and after months of internal R&D it finally seems that we have 
a solution ready for use.

As a core test framework, we'd like try to use the QMTest - an open 
source test tool written in Python by CodeSourcery (available at 
http://www.codesourcery.com). QMTest has a CLI and Web interface, is able 
to perform distributed testing, tests and test resources are stored in 
XML files suitable for cvs and much more. The most important thing for us 
is that's able to run on any platform where Python is available (AFAIK 
all platforms supported by Firebird) and that test could be written in 
any language. We'd like to use Python with kinterbasdb or gvib for access 
to FB (both are also open source packages) for core SQL tests, but some 
test could (or must) be written in other languages like Java, C/C++, 
Delphi/Kylix etc.

Because we're about to build the whole new suite of tests, we would 
greatly appreciate ANY help. If you're willing to share your expertise 
about automatic testing, Python, Java, C/C++, SQL, or even better, if 
you're willing to DESIGN (Python is not necessary, just SQL) or WRITE 
some tests (mostly in Python, but Python is beautiful and simple 
language, and writing tests is not hard, just boring :), please join us 
in Firebird-test mailing list (subscription details:  
http://www.firebirdsql.org/fbnew/index.php?op=lists#fb-test)

Best regards
Pavel Cisar
There is nothing wrong with InterBase
that Firebird can't fix for you
http://www.firebirdsql.org

Re: [Firebird-test] Ere's somethin to test

[Paul R. <pr...@ib...>]

Nigel Weeks wrote:
> I've come up with a schema for a Firebird powered Web-based RPG.

[snipped]

> 
> I love feedback!!
> 

Firebird-test is dedicated to discussion related to the Test Control 
Suite. It is used for testing the Firebird engine.

If you have suggestions for enhancing the suite in any way then please 
submit them to this list.


Paul
-- 

Paul Reeves
http://www.ibphoenix.com
Supporting users of Firebird and InterBase

[Firebird-test] Ere's somethin to test

[Nigel W. <nw...@ut...>]

I've come up with a schema for a Firebird powered Web-based RPG.

Have a look through, and see if you'd play it.

I intend(someday), to use progressive layering of DIV's in the browser to
produce a primitive 3d image of the orcaan world(background first and small,
working towards the front)

Anyhow, it's the schema that needs optimising.

If you wouldn't mind running it on a spare FB machine, and pipe the output
to a file, I'd love to know how long it takes people to generate it.

I'm working on a dataset for it soon(so I've got something to render in the
browser)

I love feedback!!

Nige


begin 666 schema.sql
M+RH*3W)C86%N('-C:&5M82 H1FER96)I<F0@4&]W97)E9"D*+2TM+2TM+2TM
M+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2T*3W)C86%N(&ES(&$@
M=FER='5A;"!W;W)L9"P@;6%P<&5D(&%S(&$@=&AR964@9&EM96YS:6]N86P@
M;6%Z90I4:&5R92!I<R!A('-U<F9A8V4@;V8@=&AE('=O<FQD+"!I;F-L=61I
M;F<@=&5X='5R97,H9W)A<W,L(')O8VLI+" *;V)J96-T<RAB=6EL9&EN9W,L
M('1R965S*2P@86YD('!E;W!L92AO=&AE<B!U<V5R<RP@;W(@<WES=&5M(&]R
M8VET97,I"D%L<V\@;VX@3W)C86%N+"!T:&5R92!A<F4@='5N;F5L<RP@=V%R
M<',L(&%N9"!T<F%P<RX*3V)J96-T:79E+B!&:6YD('1R96%S=7)E+"!G970@
M<')O<&5R='DL(&%S<V5T<RP@;&]V97)S+"!E=&,L(&%N9"!T<GD@=&\@=&%K
M92!O=F5R('1H92!P;&%C90H*5&AI<R!M=7-T(&YO="!B92!U<V5D('=I=&AO
M=70@<&5R;6ES<VEO;BX*06YY(&5N:&%N8V5M96YT<R!M=7-T(&)E('-U8FUI
M='1E9"!T;R!T:&4@875T:&]R"@I#;W!Y<FEG:'0@*$,I($YI9V5L(%=E96MS
M"FYW965K<T!U=&%S+F5D=2YA=0HM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM
M+2TM+2TM+2TM+2TM+2TM+0HJ+PI3150@4U1!5#L*"D-/3DY%0U0@(G1W:7-T
M97(Z+W4Q+V1B+V]R8V%A;BYG9&(B.PI#3TU-250["@I$4D]0($1!5$%"05-%
M.PI#3TU-250["D-214%412!$051!0D%312 B='=I<W1E<CHO=3$O9&(O;W)C
M86%N+F=D8B(["D-/34U)5#L*"E-%3$5#5" G3W)C86%N(%1A8FQE)R!&4D]-
M(')D8B1D871A8F%S93L*0U)%051%(%1!0DQ%('1B;%]/<F-A86X@* H@(&EN
M=%],;V,@3E5-15))0R@Q-2PP*2!.3U0@3E5,3"P@+RH@5&AE(%5N:7%U92!L
M;V-A=&EO;B J+PH@(&EN=%]8($1/54),12!04D5#25-)3TXL("\J(%1H92!8
M('!O<VET:6]N(&]F('1H92!L;V-A=&EO;BAI9B!S<&5C:69I960I("HO"B @
M:6YT7UD@1$]50DQ%(%!214-)4TE/3BP@+RH@5&AE(%D@<&]S:71I;VX@;V8@
M=&AE(&QO8V%T:6]N*&EF('-P96-I9FEE9"D@*B\*("!I;G1?6B!.54U%4DE#
M*#$U+# I($1%1D%53%0@,"!.3U0@3E5,3"P@+RH@5&AE(&QA>65R('1H92!L
M;V-A=&EO;B!I<R!O;B J+PH@(" @4%))34%262!+15D@*&EN=%],;V,I"BD[
M"D-214%412!!4T,@24Y$15@@24Y$7T%30U]/4D-?3$]#($].('1B;%]/<F-A
M86X@*&EN=%],;V,I.PI#4D5!5$4@1$530R!)3D1%6"!)3D1?1$530U]/4D-?
M3$]#($].('1B;%]/<F-A86X@*&EN=%],;V,I.PH*4T5,14-4("=,;V-A=&EO
M;B!0<F]P97)T:65S)R!&4D]-(')D8B1D871A8F%S93L*0U)%051%(%1!0DQ%
M('1L:W!?3&]C4')O<" H"B @:6YT7TQO8R!.54U%4DE#*#$U+# I($Y/5"!.
M54Q,+ H@('-T<E]0<F]P(%9!4D-(05(H,3 I($Y/5"!.54Q,+ H@('-T<E]6
M86P@5D%20TA!4B@S,"D@3D]4($Y53$PL"B @("!04DE-05)9($M%62 H:6YT
M7TQO8RP@<W1R7U!R;W I+ H@(" @1D]214E'3B!+15D@*&EN=%],;V,I(%)%
M1D5214Y#15,@=&)L7V]R8V%A;BAI;G1?3&]C*2!/3B!54$1!5$4@0T%30T%$
M10HI.PI#4D5!5$4@05-#($E.1$58($E.1%]!4T-?4%)/4%],3T,@3TX@=&QK
M<%],;V-0<F]P("AI;G1?3&]C*3L*0U)%051%($1%4T,@24Y$15@@24Y$7T1%
M4T-?4%)/4%],3T,@3TX@=&QK<%],;V-0<F]P("AI;G1?3&]C*3L*0U)%051%
M($%30R!)3D1%6"!)3D1?05-#7U!23U!?4%)/4"!/3B!T8FQ?3W)C86%N("AI
M;G1?3&]C*3L*0U)%051%($1%4T,@24Y$15@@24Y$7T1%4T-?4%)/4%]04D]0
M($].('1B;%]/<F-A86X@*&EN=%],;V,I.PH*4T5,14-4("=/<F-A86X@4&%T
M:',G($923TT@<F1B)&1A=&%B87-E.PI#4D5!5$4@5$%"3$4@=&QN:U]/<F-0
M871H("@*("!I;G1?0TQO8R!.54U%4DE#("@Q-2PP*2!.3U0@3E5,3"P@+RH@
M5&AE(&-U<G)E;G0@3&]C871I;VX@*B\*("!I;G1?3DQO8R!.54U%4DE#("@Q
M-2PP*2!.3U0@3E5,3"P@+RH@5&AE($YE>'0@3&]C871I;VX@*B\*("!I;G1?
M5FES($E.5$5'15(@1$5&055,5" Q($Y/5"!.54Q,+" O*B!)9B!T:&4@9&5S
M=&EN871I;VX@:7,@=FES:6)L92 J+PH@(&EN=%]$:7(@24Y414=%4BP@+RH@
M5&AE(&1I<F5C=&EO;B H,#UU;FMN;W=N+" Q/6YO<G1H+#(]96%S="PS<V]U
M=&@L-'=E<W0I("HO"B @:6YT7U1Y<&4@24Y414=%4BP@+RH@4&%T:"!4>7!E
M("@P/75N8VAA<G1E9"P@,3UC:&%R=&5D+" R/7=A<G L(#,]='5N;F5L*2 J
M+PH@(&EN=%]);&QU;2!)3E1%1T52+" O*B!I;&QU;6EN871I;VX@*# ]<W5N
M+" Q/61A<'!L961L:6=H="P@,CUD965P<VAA9&]W<RP@,SUB;&%C:RD@*B\*
M("!I;G1?4V%F92!)3E1%1T52+" O*B!3869E='D@:6YD97@@*# ]<V%F92P@
M,3UR87)E('1R;W5B;&4L(#(]9G)E<75E;G0@=')O=6)L92P@,SU"861I92!H
M86YG;W5T*B\*(" @(%!224U!4ED@2T59("AI;G1?0TQO8RP@:6YT7TY,;V,I
M+ H@(" @1D]214E'3B!+15D@*&EN=%]#3&]C*2!2149%4D5.0T53('1B;%]O
M<F-A86XH:6YT7TQO8RD@3TX@55!$051%($-!4T-!1$4L"B @("!&3U)%24=.
M($M%62 H:6YT7TY,;V,I(%)%1D5214Y#15,@=&)L7V]R8V%A;BAI;G1?3&]C
M*2!/3B!54$1!5$4@0T%30T%$10HI.PI#4D5!5$4@05-#($E.1$58($E.1%]!
M4T-?4$%42%]#3$]#($].('1L;FM?3W)C4&%T:" H:6YT7T-,;V,I.PI#4D5!
M5$4@1$530R!)3D1%6"!)3D1?1$530U]0051(7T-,3T,@3TX@=&QN:U]/<F-0
M871H("AI;G1?0TQO8RD["D-214%412!!4T,@24Y$15@@24Y$7T%30U]0051(
M7TY,3T,@3TX@=&QN:U]/<F-0871H("AI;G1?3DQO8RD["D-214%412!$15-#
M($E.1$58($E.1%]$15-#7U!!5$A?3DQ/0R!/3B!T;&YK7T]R8U!A=&@@*&EN
M=%].3&]C*3L*0U)%051%($%30R!)3D1%6"!)3D1?05-#7U!!5$A?1$E2($].
M('1L;FM?3W)C4&%T:" H:6YT7T1I<BD["D-214%412!$15-#($E.1$58($E.
M1%]$15-#7U!!5$A?1$E2($].('1L;FM?3W)C4&%T:" H:6YT7T1I<BD["@I3
M14Q%0U0@)TET96US(&9O<B!C;VQL96-T:6]N("<@1E)/32!R9&(D9&%T86)A
M<V4["D-214%412!404),12!T8FQ?271E;2 H"B @:6YT7TET96T@3E5-15))
M0R@Q-2PP*2!.3U0@3E5,3"P*("!S=')?3F%M92!605)#2$%2*#4P*2!.3U0@
M3E5,3"P*("!S=')?1&5S8R!605)#2$%2*#(P,"DL"B @<W1R7U!O=V5R(%9!
M4D-(05(H-3 I+ H@(" @4%))34%262!+15D@*$EN=%])=&5M*0HI.PI#4D5!
M5$4@05-#($E.1$58($E.1%]!4T-?251%35])1"!/3B!T8FQ?271E;2 H:6YT
M7TET96TI.PI#4D5!5$4@1$530R!)3D1%6"!)3D1?1$530U])5$5-7TE$($].
M('1B;%])=&5M("AI;G1?271E;2D["D-214%412!!4T,@24Y$15@@24Y$7T%3
M0U])5$5-7TY!344@3TX@=&)L7TET96T@*'-T<E].86UE*3L*0U)%051%($1%
M4T,@24Y$15@@24Y$7T1%4T-?251%35].04U%($].('1B;%])=&5M("AS=')?
M3F%M92D["@I314Q%0U0@)TET96T@3&]C871I;VYS)R!&4D]-(')D8B1D871A
M8F%S93L*0U)%051%(%1!0DQ%('1B;%])=&5M0V]L;" H"B @:6YT7TQO8R!.
M54U%4DE#*#$U+# I($Y/5"!.54Q,+ H@(&EN=%])=&5M($Y5345224,H,34L
M,"D@3D]4($Y53$PL"B @:6YT7T5A8V@@24Y414=%4BP@+RH@2&]W(&UA;GD@
M82!U<V5R(&-A;B!T86ME*# ]971E<FYA;"AW871E<BDL(#$];VYE+W=O<FQD
M+" R/6]N92]U<V5R+" S/6]N92]U<V5R+V1A>2 I("HO"B @("!04DE-05)9
M($M%62 H:6YT7TQO8RP@:6YT7TET96TI"BD["@I314Q%0U0@)TET96T@57-E
M9"<@1E)/32!R9&(D9&%T86)A<V4["B\J(%1H:7,@:7,@=&\@<F5C;W)D('1H
M92!T86MI;F<@;V8@;V)J96-T<RX*4V]M92!O8FIE8W1S(&5X:7-T('!E<B!U
M<V5R*'1O;VP@8F5L="DL( IS;VUE('!E<B!W;W)L9" H2V5Y('1O('1H92!M
M;W5N=&%I;B!P<FEN8V5S<R<@8VAA<W1I='D@8F5L="DL( IS;VUE(&5T97)N
M86QL>2!R97!L96YI<V@@*'=A=&5R('-P<FEN9RD@*B\*0U)%051%(%1!0DQ%
M('1L;FM?271E;55S960@* H@(&EN=%],;V,@3E5-15))0R@Q-2PP*2!.3U0@
M3E5,3"P@+RH@5VAE<F4@=VAA<R!I="HO"B @:6YT7TET96T@3E5-15))0R@Q
M-2PP*2!.3U0@3E5,3"P@+RH@5&AE(&ET96T@=&AA="!W87,@=&%K96X@*B\*
M("!I;G1?54E$($Y5345224,H,34L,"D@3D]4($Y53$PL("\J($)Y('=H;R!W
M87,@:70@=&%K96X@*B\*("!D=&U?4W1A;7 @5$E-15-404U0($Y/5"!.54Q,
M+" O*B!!;F0@5VAE;B J+PH@(" @4%))34%262!+15D@*&EN=%],;V,L(&EN
M=%])=&5M+"!I;G1?54E$+"!D=&U?4W1A;7 I"BD["@I314Q%0U0@)U5S97)S
M(%1A8FQE)R!&4D]-(')D8B1D871A8F%S93L*0U)%051%(%1!0DQ%('1B;%]5
M<V5R("@*("!I;G1?54E$($Y5345224,H,34L,"D@3D]4($Y53$PL"B @<W1R
M7U5.86UE(%9!4D-(05(H,3 I($Y/5"!.54Q,+ H@('-T<E]516UA:6P@5D%2
M0TA!4B@U,"D@3D]4($Y53$PL"B @<W1R7U502&%S:"!605)#2$%2*#0P*2!.
M3U0@3E5,3"P*(" @(%!224U!4ED@2T59("AI;G1?54E$*0HI.PH*4T5,14-4
M("=5<V5R(%-T87-H)R!&4D]-(')D8B1D871A8F%S93L*0U)%051%(%1!0DQ%
M('1L:W!?55-T87-H("@*("!I;G1?54E$($Y5345224,H,34L,"D@3D]4($Y5
M3$PL"B @:6YT7U-T;W)E($E.5$5'15(@3D]4($Y53$PL("\J(# ]<&]C:V5T
M+" Q/7!O=6-H+" R/7!A8VL@*B\*("!I;G1?271E;2!605)#2$%2*#4P*2!.
M3U0@3E5,3"P@+RH@5&AE(&]B:F5C="!I;B!S=&]R86=E("HO"B @("!04DE-
M05)9($M%62 H:6YT7U5)1"P@:6YT7U-T;W)E*2P*(" @($9/4D5)1TX@2T59
M("AI;G1?271E;2D@4D5&15)%3D-%4R!T8FQ?271E;2 H:6YT7TET96TI($].
M(%501$%412!#05-#041%"BD["@H*4T5,14-4("=5<V5R($QO8V%T:6]N<R<@
M1E)/32!R9&(D9&%T86)A<V4["D-214%412!404),12!T;&YK7U5,;V,@* H@
M(&EN=%]5240@3E5-15))0R@Q-2PP*2!.3U0@3E5,3"P*("!I;G1?0TQO8R!.
M54U%4DE#*#$U+# I($Y/5"!.54Q,+ H@(" @4%))34%262!+15D@*&EN=%]5
M240L(&EN=%]#3&]C*2P*(" @($9/4D5)1TX@2T59("AI;G1?54E$*2!2149%
M4D5.0T53('1B;%]U<V5R*&EN=%]5240I($].(%501$%412!#05-#041%+ H@
M(" @1D]214E'3B!+15D@*&EN=%]#3&]C*2!2149%4D5.0T53('1B;%]O<F-A
M86XH:6YT7TQO8RD@3TX@55!$051%($-!4T-!1$4**3L*"E-%3$5#5" G57-E
M<B!,;V-A=&EO;B!(:7-T;W)Y)R!&4D]-(')D8B1D871A8F%S93L*0U)%051%
M(%1!0DQ%('1L:W!?54QO8TAI<W0@* H@(&EN=%]5240@3E5-15))0R@Q-2PP
M*2!.3U0@3E5,3"P*("!I;G1?0TQO8R!.54U%4DE#*#$U+# I($Y/5"!.54Q,
M+ H@(&1T;5]3=&%M<"!424U%4U1!35 @1$5&055,5" G;F]W)R!.3U0@3E5,
M3"P*("!S=')?3F]T92!605)#2$%2*#$P,"DL"B @("!04DE-05)9($M%62 H
M:6YT7U5)1"P@:6YT7T-,;V,L(&1T;5]3=&%M<"DL"B @("!&3U)%24=.($M%
M62 H:6YT7U5)1"D@4D5&15)%3D-%4R!T8FQ?=7-E<BAI;G1?54E$*2!/3B!5
M4$1!5$4@0T%30T%$12P*(" @($9/4D5)1TX@2T59("AI;G1?0TQO8RD@4D5&
M15)%3D-%4R!T8FQ?;W)C86%N*&EN=%],;V,I($].(%501$%412!#05-#041%
M( HI.PH*4T5,14-4("=/<F-A86X@:&%S(&)E96X@8G5I;'0G($923TT@<F1B
+)&1A=&%B87-E.PH`
`
end

[Firebird-test] test

[Raul F. <rfr...@te...>]

[Firebird-test] test

[Raul F. <rfr...@te...>]

Re: [Firebird-test] need help

[Svein E. <sve...@kr...>]

Hi Steve!

Normally one would consider version 6 to be more mature than version 1, but
that is not the case when comparing Interbase to Firebird. The Firebird
team contains many persons that formerly was involved with Interbase, but
then most of them quit at a turbulent time a couple of years ago. Firebird
evolved from the sources of IB 6.0 when they originally were open-sourced -
and after doing a lot of bug-fixing came out with version 1.0.

Firebird is a solid database, we switched from Interbase to Firebird when
it was version 0.9.4 and does not regret that move. I guess IB 6.5 is a
good product too, but don't really know much about it.

You asked your question at firebird-test on sourcefourge - the second mail
sent to this list this month. I would recommend you to rather ask your
question at ib-...@ya... where there is plenty of people able
to answer any question you may come up with.

If you use Delphi or Borland C++ for development, I would strongly
recommend using Interbase Objects - it is a pleasure to work with and wins
the Delphi Informant "Best Database Connectivity" award every year. 

HTH,
Set

Re: [Firebird-test] need help

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

On Mon, 29 Apr 2002 08:48:22 -0400
<im...@yo...> wrote:

> I am in need of some advice/help. We are planning on switching to IB or
> Firebird as a replacement for SQL Server. I've spent the last week doing
> some research on which version to use and which dev console to use.
> I still have some questions to ask and I was wondering if there was anyone
> who could help?
> 
> I Have 3 main areas that I need help in. First, what are the pros and cons
> of using IB 6 open source and Firebird? I have tried both and I've read
> the paper on Firebird. It does seem to have some advantages, but is it as
> or more reliable than IB 6? If I had to choose between the two I would have
> to choose the reliability.
Use the source luke :) (firebird)
The firebird have the forced writes turned ON !!! the borland 
had thouse things turned OFF!!! .The speed was good on the borland part 
but if the electrical power goes off ,or the system is rebooted  then YOUR DB MAY BE CORRUPTED (CRASHED).

What is the difference between "certified" Borland version 
and the FireBird? Whell they should answer to that but from what i see from outside
they do some extra testing there at borland but even so the Firebird runs a set of 
tests to (when they build the engine) Even at the MySql or Posgres they run some kind of internal tests .
To sum up :use the version of the firebird that is stable enough and look at the bugs on sourceforge .
Pay a developer to do a test :write a small application in delphi,perl,etc that stress the database
one day or one week and do that from 2-10 computers .Put some fire in the firebird engine :)
If the database is too big (2-10 gigs) split-it in smallers files (firebird is smart and there is a sql  api for this when create the db)
They did a smart stuff with the 64bit/IO that permits to increase the database file to the sizes greater than 2G.
Don't know how it works(din't test it yet) how stable it is.
Another think :use stored procedures everywere (they are precompiled ) and speeds up the queries .
 
> Second, I've tried some demos for dev environments. QuickDesk, WorkBench,
> and
> IBExpert. Of the tree, I like QuickDesk but it seems to have a few bugs (?).
> IBExpert and QuickDesk seem to be modeled form each other( what's up with
> that?).
> Which one came first? Anyway, again reliability is more important above the
> bells and whistles.

IBExpert is the good way (there is a personal edition) .You can do debugging on 
stored procedures http://www.hksoftware.net/download/
(The guy who did the QuickDesk has gone to another firm Hksoftware and took the source code with him 
so the IBExpert is the more mature product still)
There is in the command line ISQL(in the interbase bin dir) and it does all the stuff the gui do 
but is to much hardwork and life is too short :(
On the open source side i like IBAccess(www.ibaccess.org) is very basic but works 




> And lastly, we have a project that we are going to be switching over to one
> of the two databases. The project currently uses SQL Server and I will need
> to switch all of the objects over. I've read a lot of the documentation for
> IB6 but I still have a few questions before I start to re-write all of this
> code. If I put together a document of some questions, is there any one who
> will help me with the answers?

A Small comparision between firebird (ib) an mssql
http://www.cvalde.com/document/comparison_ib6_mssql7.htm
some  good tools :

http://www.ibphoenix.com/sql2gdb.html
http://www.clevercomponents.com/ (here is the ib datapump i have used for a 1G+ database that was damaged ..it was a ib6.0 db..those things happen)
 

> Thank You.
> 
> Steve Downey
> 
> IM...@vo...
> 
> 
> 
> _______________________________________________
> Firebird-test mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-test

[Firebird-test] need help

[<im...@yo...>]

I am in need of some advice/help. We are planning on switching to IB or
Firebird as a replacement for SQL Server. I've spent the last week doing
some research on which version to use and which dev console to use.
I still have some questions to ask and I was wondering if there was anyone
who could help?

I Have 3 main areas that I need help in. First, what are the pros and cons
of using IB 6 open source and Firebird? I have tried both and I've read
the paper on Firebird. It does seem to have some advantages, but is it as
or more reliable than IB 6? If I had to choose between the two I would have
to choose the reliability.

Second, I've tried some demos for dev environments. QuickDesk, WorkBench,
and
IBExpert. Of the tree, I like QuickDesk but it seems to have a few bugs (?).
IBExpert and QuickDesk seem to be modeled form each other( what's up with
that?).
Which one came first? Anyway, again reliability is more important above the
bells and whistles.

And lastly, we have a project that we are going to be switching over to one
of the two databases. The project currently uses SQL Server and I will need
to switch all of the objects over. I've read a lot of the documentation for
IB6 but I still have a few questions before I start to re-write all of this
code. If I put together a document of some questions, is there any one who
will help me with the answers?


Thank You.

Steve Downey

IM...@vo...

Re: [Firebird-test] select MAX() not used INDEXES to run

[Robbi <ess...@gm...>]

Hi Carlo,

a first hint: this is normal IB/FB behaviour AFAIK (for MIN,MAX, COUNT,
...?)!
It is reasoned by the multi generation architecture. The MGA can hold
several generations of records with always the same index identifier. But at
the moment I cann't explain you more details.

Robbi


""Carlo Pires"" <ca...@ug...> schrieb im Newsbeitrag
news:a3bc4n$sdq$1...@ne......
> Hi,
>
> I'm testing firebird with a table with 65000 records. When I try to:
>
> select MAX(COD_VALUE) from TABLE_TEST;
>
> The plan used by firebird is NATURAL. This is strange to me because I have
a
> index for field COD_VALUE. I had to implement a stored procedure + a
> descending index for field COD_VALUE to get, more quickly, the max value
for
> COD_VALUE.
>
> Know anyone about this? I'm wrong ?
>
> -Carlo
>
>
>
> _______________________________________________
> Firebird-test mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-test
>

Re: [Firebird-test] select MAX() not used INDEXES to run

[Ann W. H. <aha...@ib...>]

>On 31 Jan 2002, at 14:29, Carlo Pires wrote:
> >
> > select MAX(COD_VALUE) from TABLE_TEST;
> >
> > The plan used by firebird is NATURAL. This is strange to me because I 
> have a
> > index for field COD_VALUE. I had to implement a stored procedure + a
> > descending index for field COD_VALUE

First, for Carlo,

     Why did you need a stored procedure?

At 02:19 PM 2/1/2002 +0100, Pavel Cisar wrote:

>Yes, it's know behaviour :-) It's because index keys in IB/FB are
>stored as difference from previous key, so index is traversable only
>in one direction. You'll have to go through whole ASC index to find
>max value, so index is not used (too much I/O). Hence the rule
>ASC for MIN and DESC for MAX :-)

It's not just compression.  The first key on each index page is
uncompressed, so you just have to walk one page in order.  Another
part of the problem is that the index can hold values that are not
applicable to the current transaction, so you have to verify that
the actual record is ok, not just the index entry.  And here we
get into the tricky bit.

To avoid deadlocks, each transaction is guaranteed only one
page lock.  It can take more, but must be prepared to give up
all but one.  Reading the data page means that the lock on the
index page must be available if some other transaction wants it.
If another transaction grabs it, then the one looking for the
MAX value has to start over from the top of the index.

This problem is reasonably easy to solve in SuperServer where
there is one cache manager who can "know" if a page is still
OK.  In classic, I know of no good solution.


Regards,


Ann

[Firebird-test] SQL UPPER & Unicode_FSS

[Sergey B. <ja...@es...>]

Hello!

Anybody knows why UPPER function doesn't work on the Unicode_FSS charset?
Any ASCII strings processed correctly rather strings in the Unicode_FSS
charset.

How it can be cured?

Sergey Bervinov

[Firebird-test] STORED PROCEDURE

[Vinicius <vin...@ya...>]

how can i do this

select * from TABLE1 , STOREDPROCEDURE( TABLE1.FIELD )

the erro is : not fecth row - or not fecth record, something like this

HELP ME

Vinicius

Re: [Firebird-test] select MAX() not used INDEXES to run

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

Hi,

On 31 Jan 2002, at 14:29, Carlo Pires wrote:

> Hi,
> 
> I'm testing firebird with a table with 65000 records. When I try to:
> 
> select MAX(COD_VALUE) from TABLE_TEST;
> 
> The plan used by firebird is NATURAL. This is strange to me because I have a
> index for field COD_VALUE. I had to implement a stored procedure + a
> descending index for field COD_VALUE to get, more quickly, the max value for
> COD_VALUE.
> 
> Know anyone about this? I'm wrong ?

Yes, it's know behaviour :-) It's because index keys in IB/FB are 
stored as difference from previous key, so index is traversable only 
in one direction. You'll have to go through whole ASC index to find 
max value, so index is not used (too much I/O). Hence the rule 
ASC for MIN and DESC for MAX :-)

It's a trade off -> more keys on page -> shallow index tree -> faster 
index traversal, but limited index usage for MIN and MAX use.

Best regards

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