You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Myrna van Lunteren (JIRA)" <ji...@apache.org> on 2013/12/10 23:00:07 UTC

[jira] [Comment Edited] (DERBY-6281) test failure in lang/TriggerGeneral.sql

    [ https://issues.apache.org/jira/browse/DERBY-6281?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13844695#comment-13844695 ] 

Myrna van Lunteren edited comment on DERBY-6281 at 12/10/13 9:58 PM:
---------------------------------------------------------------------

This test failed again, same branch, with ibm 1.7 SR6, with a largish bunch of extra SYSDEPENDS locks, causing the diff to look very confused.
See: http://people.apache.org/~myrnavl/derby_test_results/v10_10/windows/testlog/ibm17/1548790-derbyall_diff.txt

The essence of the diff is that we have 21 extra lines, in the expected output none of these SYSDEPENDS locks are present:
==============
ij> select type, mode, tablename from syscs_diag.lock_table order by tablename,
type;
TYPE |MODE|TABLENAME
---------------------------------------------------------------------------------------------------------
ROW  |X   |PARENT
TABLE|IX  |PARENT
ROW  |X   |SYSDEPENDS
ROW  |X   |SYSDEPENDS
ROW  |X   |SYSDEPENDS
ROW  |X   |SYSDEPENDS
ROW  |X   |SYSDEPENDS
ROW  |X   |SYSDEPENDS
ROW  |X   |SYSDEPENDS
ROW  |X   |SYSDEPENDS
ROW  |X   |SYSDEPENDS
ROW  |X   |SYSDEPENDS
ROW  |X   |SYSDEPENDS
ROW  |X   |SYSDEPENDS
ROW  |X   |SYSDEPENDS
ROW  |X   |SYSDEPENDS
ROW  |X   |SYSDEPENDS
ROW  |X   |SYSDEPENDS
ROW  |X   |SYSDEPENDS
ROW  |X   |SYSDEPENDS
ROW  |X   |SYSDEPENDS
ROW  |X   |SYSDEPENDS
TABLE  |IX   |SYSDEPENDS
ROW  |X   |T1
TABLE|IX  |T1
==============
The expected output is:
==============
ij> select type, mode, tablename from syscs_diag.lock_table order by tablename,
type;
TYPE |MODE|TABLENAME
---------------------------------------------------------------------------------------------------------------------
ROW  |X   |PARENT
TABLE|IX  |PARENT
ROW  |X   |T1
TABLE|IX  |T1
==============


was (Author: myrna):
This test failed again, same branch, with ibm 1.7 SR6, with a largish bunch of extra SYSDEPENDS locks, causing the diff to look very confused.
See: http://people.apache.org/~myrnavl/derby_test_results/v10_10/windows/testlog/ibm17/1548790-derbyall_diff.txt

The essence of the diff is that we have 21 extra lines, in the expected output none of these SYSDEPENDS locks are present:
==============
ij> select type, mode, tablename from syscs_diag.lock_table order by tablename,
type;
TYPE |MODE|TABLENAME
---------------------------------------------------------------------------------------------------------
ROW  |X   |PARENT
TABLE|IX  |PARENT
ROW  |X   |SYSDEPENDS
ROW  |X   |SYSDEPENDS
ROW  |X   |SYSDEPENDS
ROW  |X   |SYSDEPENDS
ROW  |X   |SYSDEPENDS
ROW  |X   |SYSDEPENDS
ROW  |X   |SYSDEPENDS
ROW  |X   |SYSDEPENDS
ROW  |X   |SYSDEPENDS
ROW  |X   |SYSDEPENDS
ROW  |X   |SYSDEPENDS
ROW  |X   |SYSDEPENDS
ROW  |X   |SYSDEPENDS
ROW  |X   |SYSDEPENDS
ROW  |X   |SYSDEPENDS
ROW  |X   |SYSDEPENDS
ROW  |X   |SYSDEPENDS
ROW  |X   |SYSDEPENDS
ROW  |X   |SYSDEPENDS
ROW  |X   |SYSDEPENDS
TABLE  |IX   |SYSDEPENDS
==============


> test failure in lang/TriggerGeneral.sql 
> ----------------------------------------
>
>                 Key: DERBY-6281
>                 URL: https://issues.apache.org/jira/browse/DERBY-6281
>             Project: Derby
>          Issue Type: Bug
>          Components: Test
>    Affects Versions: 10.10.1.3
>         Environment: windows 2008 (on vmware), ibm17
>            Reporter: Myrna van Lunteren
>
> the triggerGeneral test showed two lines extra in the output:
> *** Start: triggerGeneral jdk1.7.0 derbyall:derbylang 2013-06-22 21:31:08 ***
> 573a574,575
> > ROW  |X   |SYSDEPENDS                                                                                                                      
> > TABLE|IX  |SYSDEPENDS                                                                                                                      
> Test Failed.
> See: http://people.apache.org/~myrnavl/derby_test_results/v10_10/windows/testlog/ibm17/1495788-derbyall_diff.txt
> This appears different from DERBY-5943.



--
This message was sent by Atlassian JIRA
(v6.1.4#6159)