Tests for FK

[Roman Simakov]

Hi,

We developed a few QM tests for FK testing. They include test cases when
master record is active and detail records reference to it. Yesterday,
2008-06-30, we committed the patch improving this handling and fixing
the error discussed 2008-04-12 in firebird-devel by report Sean Leyne.
We tested them on new Firebird HEAD. Test cases are a new directory in
functional.qms and not changed other tests. Only new files.
We think these tests will be useful and we'd like to commit them into QA
repository. I could commit them using my developer account.
I can send you them before commit but I think it's not critical if you
review them after commit.

Any opinions?

Best Regards,
Roman Simakov

-------------------------------------------------------------------------
Sponsored by: SourceForge.net Community Choice Awards: VOTE NOW!
Studies have shown that voting for your favorite open source project,
along with a healthy diet, reduces your potential for chronic lameness
and boredom. Vote Now at http://www.sourceforge.net/community/cca08
_______________________________________________
Firebird-test mailing list
Firebird-test@...
https://lists.sourceforge.net/lists/listinfo/firebird-test

[Philippe Makowski]

Roman Simakov  [08-07-01 11.23] :
> I can send you them before commit but I think it's not critical if you
> review them after commit.
I see that they are committed, nice

Just two point :

can you use :
#Create second connection - update detail table
con_detail = kdb.connect(
     dsn=dsn.encode(),
     user=user_name.encode(),
     password=user_password.encode()
)

instead of :
#Create second connection - update detail table
con_detail = kdb.connect(
     dsn=dsn,
     user='SYSDBA',
     password='masterkey'
)


And seems that a lot of tests are ok for target before 2.5
so can you change target for all tests that are also ok for 2.x ?

Thanks
--
Philippe Makowski
http://www.ibphoenix.com
Supporting users of Firebird
Tel [phone]



-------------------------------------------------------------------------
Sponsored by: SourceForge.net Community Choice Awards: VOTE NOW!
Studies have shown that voting for your favorite open source project,
along with a healthy diet, reduces your potential for chronic lameness
and boredom. Vote Now at http://www.sourceforge.net/community/cca08
_______________________________________________
Firebird-test mailing list
Firebird-test@...
https://lists.sourceforge.net/lists/listinfo/firebird-test

[Roman Simakov]

Hello, Philippe!

Many thanks for your comments about this tests.

I'm posting this message instead of Vyacheslav. His original message was
banned by  SPAM-bot of sourceforge :) (What he must do in this case?)

> Roman Simakov  [08-07-01 11.23] :
>  
>> > I can send you them before commit but I think it's not critical if
>> you > review them after commit.
>>    
> I see that they are committed, nice
>
> Just two point :
>
> can you use :
> #Create second connection - update detail table
> con_detail = kdb.connect(
>      dsn=dsn.encode(),
>      user=user_name.encode(),
>      password=user_password.encode()
> )
>
> instead of :
> #Create second connection - update detail table
> con_detail = kdb.connect(
>      dsn=dsn,
>      user='SYSDBA',
>      password='masterkey'
> )
>
>  

Done.

> And seems that a lot of tests are ok for target before 2.5
> so can you change target for all tests that are also ok for 2.x ?
>  

Done. But I think in this case we will have a set of separate test cases
for 2.x
engine and we can't see full image about FK functionality.
And what about full test suite for reference integrity in firebird? This
features are not checked full in QM test now.
I think we can develop tests for full checking this features. But this
problem is very important and I think it would be very good to discuss
all possible test cases. Can anybody help as with it? May be use SQL
standard to gather test cases? Are there other ideas?

> Thanks
> -- Philippe Makowski

Regards
Vyacheslav Ozherelyev
Red Soft Corporation

-------------------------------------------------------------------------
Sponsored by: SourceForge.net Community Choice Awards: VOTE NOW!
Studies have shown that voting for your favorite open source project,
along with a healthy diet, reduces your potential for chronic lameness
and boredom. Vote Now at http://www.sourceforge.net/community/cca08
_______________________________________________
Firebird-test mailing list
Firebird-test@...
https://lists.sourceforge.net/lists/listinfo/firebird-test

[Philippe Makowski]

Hello,
>
> I'm posting this message instead of Vyacheslav. His original message was
> banned by  SPAM-bot of sourceforge :) (What he must do in this case?)
>
sorry I don't know, I don't manage the list

>> Roman Simakov  [08-07-01 11.23] :
>>  
> Done. But I think in this case we will have a set of separate test cases
> for 2.x
> engine and we can't see full image about FK functionality.
Why are you telling that ?
I don't understand
tests are cumulative, so test tagged for 2.1 apply to 2.1 and 2.5

> And what about full test suite for reference integrity in firebird? This
> features are not checked full in QM test now.
why not
> I think we can develop tests for full checking this features. But this
> problem is very important and I think it would be very good to discuss
> all possible test cases. Can anybody help as with it? May be use SQL
> standard to gather test cases? Are there other ideas?
SQL standard are a good starting point yes

It lead to another idea that was on air, to have a new example database that could be use
for doc and for tests
Maybe we could start by this


-------------------------------------------------------------------------
Sponsored by: SourceForge.net Community Choice Awards: VOTE NOW!
Studies have shown that voting for your favorite open source project,
along with a healthy diet, reduces your potential for chronic lameness
and boredom. Vote Now at http://www.sourceforge.net/community/cca08
_______________________________________________
Firebird-test mailing list
Firebird-test@...
https://lists.sourceforge.net/lists/listinfo/firebird-test