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 "Yip Ng (JIRA)" <ji...@apache.org> on 2006/11/06 23:12:38 UTC
[jira] Created: (DERBY-2048) LangScripts JUnit test fails in
views.sql
LangScripts JUnit test fails in views.sql
-----------------------------------------
Key: DERBY-2048
URL: http://issues.apache.org/jira/browse/DERBY-2048
Project: Derby
Issue Type: Bug
Components: Test
Affects Versions: 10.3.0.0
Environment: Windows XP
Reporter: Yip Ng
LangScripts JUnit test fails in views.sql
There was 1 failure:
1) views(org.apache.derbyTesting.functionTests.tests.lang.LangScripts )junit.fram
ework.ComparisonFailure: Output at line 104 expected:<...T1' because VIEW 'SV[1]' is dependent on th...> but was:<...T1' because VIEW 'SV[2]' is dependent on th...>
at org.apache.derbyTesting.functionTests.util.CanonTestCase.compareCanon(CanonTestCase.java:100)
at org.apache.derbyTesting.functionTests.util.ScriptTestCase.runTest(ScriptTestCase.java:117)
at org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:76)
at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
at junit.extensions.TestSetup.run(TestSetup.java:25)
FAILURES!!!
Tests run: 2016, Failures: 1, Errors: 0
Some observations:
If org.apache.derbyTesting.functionTests.harness.RunTest is used to run views.sql, then it have 2 newline diffs.
If org.apache.derbyTesting.functionTests.tests.lang.LangScripts is used to run, then the ordering of one of the outputs differs.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] Updated: (DERBY-2048) LangScripts JUnit test fails in
views.sql
Posted by "Yip Ng (JIRA)" <ji...@apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-2048?page=all ]
Yip Ng updated DERBY-2048:
--------------------------
Attachment: derby2048-trunk-diff02.txt
Attaching derby2048-trunk-diff02.txt with Dan's suggestion on clarifying the method name and javadoc comments.
> LangScripts JUnit test fails in views.sql
> -----------------------------------------
>
> Key: DERBY-2048
> URL: http://issues.apache.org/jira/browse/DERBY-2048
> Project: Derby
> Issue Type: Bug
> Components: Test
> Affects Versions: 10.3.0.0
> Environment: Windows XP
> Reporter: Yip Ng
> Assigned To: Yip Ng
> Attachments: derby2048-trunk-diff01.txt, derby2048-trunk-diff02.txt, derby2048-trunk-stat01.txt
>
>
> LangScripts JUnit test fails in views.sql
> There was 1 failure:
> 1) views(org.apache.derbyTesting.functionTests.tests.lang.LangScripts )junit.fram
> ework.ComparisonFailure: Output at line 104 expected:<...T1' because VIEW 'SV[1]' is dependent on th...> but was:<...T1' because VIEW 'SV[2]' is dependent on th...>
> at org.apache.derbyTesting.functionTests.util.CanonTestCase.compareCanon(CanonTestCase.java:100)
> at org.apache.derbyTesting.functionTests.util.ScriptTestCase.runTest(ScriptTestCase.java:117)
> at org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:76)
> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
> at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
> at junit.extensions.TestSetup.run(TestSetup.java:25)
> FAILURES!!!
> Tests run: 2016, Failures: 1, Errors: 0
> Some observations:
> If org.apache.derbyTesting.functionTests.tests.lang.LangScripts is used to run views.sql as a single test, then it ran smoothly without a problem.
> .
> Time: 7.109
> OK (1 test)
> But if views.sql is run as part of a suite, then the ordering diff occurs.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] Updated: (DERBY-2048) LangScripts JUnit test fails in
views.sql
Posted by "Yip Ng (JIRA)" <ji...@apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-2048?page=all ]
Yip Ng updated DERBY-2048:
--------------------------
Attachment: derby2048-trunk-stat01.txt
derby2048-trunk-diff01.txt
Attaching proposal patch derby2048-trunk-diff01.txt to fix the ordering diff problem.
Add an additional cleanup step(compression) to cleanDatabase() method in java/testing/org/apache/derbyTesting/junit/CleanDatabaseTestSetup.java.
After objects removal is performed via removeObjects(), object compression is performed in the new compressObjects() method on the SYS.SYSDEPENDS to compact the system table. (Currently it only compress this system table.)
JUnit suite passes.
> LangScripts JUnit test fails in views.sql
> -----------------------------------------
>
> Key: DERBY-2048
> URL: http://issues.apache.org/jira/browse/DERBY-2048
> Project: Derby
> Issue Type: Bug
> Components: Test
> Affects Versions: 10.3.0.0
> Environment: Windows XP
> Reporter: Yip Ng
> Assigned To: Yip Ng
> Attachments: derby2048-trunk-diff01.txt, derby2048-trunk-stat01.txt
>
>
> LangScripts JUnit test fails in views.sql
> There was 1 failure:
> 1) views(org.apache.derbyTesting.functionTests.tests.lang.LangScripts )junit.fram
> ework.ComparisonFailure: Output at line 104 expected:<...T1' because VIEW 'SV[1]' is dependent on th...> but was:<...T1' because VIEW 'SV[2]' is dependent on th...>
> at org.apache.derbyTesting.functionTests.util.CanonTestCase.compareCanon(CanonTestCase.java:100)
> at org.apache.derbyTesting.functionTests.util.ScriptTestCase.runTest(ScriptTestCase.java:117)
> at org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:76)
> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
> at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
> at junit.extensions.TestSetup.run(TestSetup.java:25)
> FAILURES!!!
> Tests run: 2016, Failures: 1, Errors: 0
> Some observations:
> If org.apache.derbyTesting.functionTests.tests.lang.LangScripts is used to run views.sql as a single test, then it ran smoothly without a problem.
> .
> Time: 7.109
> OK (1 test)
> But if views.sql is run as part of a suite, then the ordering diff occurs.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] Resolved: (DERBY-2048) LangScripts JUnit test fails in
views.sql
Posted by "Yip Ng (JIRA)" <ji...@apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-2048?page=all ]
Yip Ng resolved DERBY-2048.
---------------------------
Fix Version/s: 10.3.0.0
Resolution: Fixed
I think this jira is resolved since I haven't seen the ordering diff again after this patch was applied to the trunk.
> LangScripts JUnit test fails in views.sql
> -----------------------------------------
>
> Key: DERBY-2048
> URL: http://issues.apache.org/jira/browse/DERBY-2048
> Project: Derby
> Issue Type: Bug
> Components: Test
> Affects Versions: 10.3.0.0
> Environment: Windows XP
> Reporter: Yip Ng
> Assigned To: Yip Ng
> Fix For: 10.3.0.0
>
> Attachments: derby2048-trunk-diff01.txt, derby2048-trunk-diff02.txt, derby2048-trunk-stat01.txt
>
>
> LangScripts JUnit test fails in views.sql
> There was 1 failure:
> 1) views(org.apache.derbyTesting.functionTests.tests.lang.LangScripts )junit.fram
> ework.ComparisonFailure: Output at line 104 expected:<...T1' because VIEW 'SV[1]' is dependent on th...> but was:<...T1' because VIEW 'SV[2]' is dependent on th...>
> at org.apache.derbyTesting.functionTests.util.CanonTestCase.compareCanon(CanonTestCase.java:100)
> at org.apache.derbyTesting.functionTests.util.ScriptTestCase.runTest(ScriptTestCase.java:117)
> at org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:76)
> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
> at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
> at junit.extensions.TestSetup.run(TestSetup.java:25)
> FAILURES!!!
> Tests run: 2016, Failures: 1, Errors: 0
> Some observations:
> If org.apache.derbyTesting.functionTests.tests.lang.LangScripts is used to run views.sql as a single test, then it ran smoothly without a problem.
> .
> Time: 7.109
> OK (1 test)
> But if views.sql is run as part of a suite, then the ordering diff occurs.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] Commented: (DERBY-2048) LangScripts JUnit test fails in
views.sql
Posted by "Yip Ng (JIRA)" <ji...@apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-2048?page=comments#action_12447914 ]
Yip Ng commented on DERBY-2048:
-------------------------------
Ah yes, it cleans up more than just user tables. My mistake. =) From what I see from the clean up code in the Derby JUnit utility class, it does a pretty good job of cleaning up all the user schema objects. So it puzzled me why there would be an ordering diff.
It so happens that the ordering diff is on an error message that is directly related to the system table SYS.SYSDEPENDS. The stored dependency entries that get populated are from the JUnit infrastructure (and not the script itself) during CleanDatabaseTestSetup.setUp() and its tearDown() method when it attempts to clean the database objects via its removeObjects() method and it made use of metadata calls to accomplish this. Those metadata calls made to Derby are the following and their associated stored dependencies are populated in SYS.SYSDEPENDS (32 entries):
getCrossReference
getSchemas
getProcedures40
When those SPSDescriptors get prepared via its prepareAndRelease() method in the generate phase, the stored dependency entries are cleared out based on the dependent UUID first and then are populated again in SYS.SYSDEPENDS. So based on this observation, there are row insertions and deletions in SYS.SYSDEPENDS in each setUp() and tearDown(). So the ordering of those rows when fetched in an unordered way may depend on how the store subsystem manages free space.
> LangScripts JUnit test fails in views.sql
> -----------------------------------------
>
> Key: DERBY-2048
> URL: http://issues.apache.org/jira/browse/DERBY-2048
> Project: Derby
> Issue Type: Bug
> Components: Test
> Affects Versions: 10.3.0.0
> Environment: Windows XP
> Reporter: Yip Ng
>
> LangScripts JUnit test fails in views.sql
> There was 1 failure:
> 1) views(org.apache.derbyTesting.functionTests.tests.lang.LangScripts )junit.fram
> ework.ComparisonFailure: Output at line 104 expected:<...T1' because VIEW 'SV[1]' is dependent on th...> but was:<...T1' because VIEW 'SV[2]' is dependent on th...>
> at org.apache.derbyTesting.functionTests.util.CanonTestCase.compareCanon(CanonTestCase.java:100)
> at org.apache.derbyTesting.functionTests.util.ScriptTestCase.runTest(ScriptTestCase.java:117)
> at org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:76)
> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
> at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
> at junit.extensions.TestSetup.run(TestSetup.java:25)
> FAILURES!!!
> Tests run: 2016, Failures: 1, Errors: 0
> Some observations:
> If org.apache.derbyTesting.functionTests.tests.lang.LangScripts is used to run views.sql as a single test, then it ran smoothly without a problem.
> .
> Time: 7.109
> OK (1 test)
> But if views.sql is run as part of a suite, then the ordering diff occurs.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] Updated: (DERBY-2048) LangScripts JUnit test fails in
views.sql
Posted by "Yip Ng (JIRA)" <ji...@apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-2048?page=all ]
Yip Ng updated DERBY-2048:
--------------------------
Description:
LangScripts JUnit test fails in views.sql
There was 1 failure:
1) views(org.apache.derbyTesting.functionTests.tests.lang.LangScripts )junit.fram
ework.ComparisonFailure: Output at line 104 expected:<...T1' because VIEW 'SV[1]' is dependent on th...> but was:<...T1' because VIEW 'SV[2]' is dependent on th...>
at org.apache.derbyTesting.functionTests.util.CanonTestCase.compareCanon(CanonTestCase.java:100)
at org.apache.derbyTesting.functionTests.util.ScriptTestCase.runTest(ScriptTestCase.java:117)
at org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:76)
at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
at junit.extensions.TestSetup.run(TestSetup.java:25)
FAILURES!!!
Tests run: 2016, Failures: 1, Errors: 0
Some observations:
If org.apache.derbyTesting.functionTests.tests.lang.LangScripts is used to run views.sql as a single test, then it ran smoothly without a problem.
.
Time: 7.109
OK (1 test)
But if views.sql is run as part of a suite, then the ordering diff occurs.
was:
LangScripts JUnit test fails in views.sql
There was 1 failure:
1) views(org.apache.derbyTesting.functionTests.tests.lang.LangScripts )junit.fram
ework.ComparisonFailure: Output at line 104 expected:<...T1' because VIEW 'SV[1]' is dependent on th...> but was:<...T1' because VIEW 'SV[2]' is dependent on th...>
at org.apache.derbyTesting.functionTests.util.CanonTestCase.compareCanon(CanonTestCase.java:100)
at org.apache.derbyTesting.functionTests.util.ScriptTestCase.runTest(ScriptTestCase.java:117)
at org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:76)
at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
at junit.extensions.TestSetup.run(TestSetup.java:25)
FAILURES!!!
Tests run: 2016, Failures: 1, Errors: 0
Some observations:
If org.apache.derbyTesting.functionTests.harness.RunTest is used to run views.sql, then it have 2 newline diffs.
If org.apache.derbyTesting.functionTests.tests.lang.LangScripts is used to run, then the ordering of one of the outputs differs.
> LangScripts JUnit test fails in views.sql
> -----------------------------------------
>
> Key: DERBY-2048
> URL: http://issues.apache.org/jira/browse/DERBY-2048
> Project: Derby
> Issue Type: Bug
> Components: Test
> Affects Versions: 10.3.0.0
> Environment: Windows XP
> Reporter: Yip Ng
>
> LangScripts JUnit test fails in views.sql
> There was 1 failure:
> 1) views(org.apache.derbyTesting.functionTests.tests.lang.LangScripts )junit.fram
> ework.ComparisonFailure: Output at line 104 expected:<...T1' because VIEW 'SV[1]' is dependent on th...> but was:<...T1' because VIEW 'SV[2]' is dependent on th...>
> at org.apache.derbyTesting.functionTests.util.CanonTestCase.compareCanon(CanonTestCase.java:100)
> at org.apache.derbyTesting.functionTests.util.ScriptTestCase.runTest(ScriptTestCase.java:117)
> at org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:76)
> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
> at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
> at junit.extensions.TestSetup.run(TestSetup.java:25)
> FAILURES!!!
> Tests run: 2016, Failures: 1, Errors: 0
> Some observations:
> If org.apache.derbyTesting.functionTests.tests.lang.LangScripts is used to run views.sql as a single test, then it ran smoothly without a problem.
> .
> Time: 7.109
> OK (1 test)
> But if views.sql is run as part of a suite, then the ordering diff occurs.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] Commented: (DERBY-2048) LangScripts JUnit test fails in
views.sql
Posted by "Daniel John Debrunner (JIRA)" <ji...@apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-2048?page=comments#action_12447624 ]
Daniel John Debrunner commented on DERBY-2048:
----------------------------------------------
CleanDatabaseTestSetup cleans up more than user tables, it drops procedures, functions, views, synonyms and schemas.
Please enhance it though to drop any remaining objects or clean up the database even more. :-)
> LangScripts JUnit test fails in views.sql
> -----------------------------------------
>
> Key: DERBY-2048
> URL: http://issues.apache.org/jira/browse/DERBY-2048
> Project: Derby
> Issue Type: Bug
> Components: Test
> Affects Versions: 10.3.0.0
> Environment: Windows XP
> Reporter: Yip Ng
>
> LangScripts JUnit test fails in views.sql
> There was 1 failure:
> 1) views(org.apache.derbyTesting.functionTests.tests.lang.LangScripts )junit.fram
> ework.ComparisonFailure: Output at line 104 expected:<...T1' because VIEW 'SV[1]' is dependent on th...> but was:<...T1' because VIEW 'SV[2]' is dependent on th...>
> at org.apache.derbyTesting.functionTests.util.CanonTestCase.compareCanon(CanonTestCase.java:100)
> at org.apache.derbyTesting.functionTests.util.ScriptTestCase.runTest(ScriptTestCase.java:117)
> at org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:76)
> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
> at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
> at junit.extensions.TestSetup.run(TestSetup.java:25)
> FAILURES!!!
> Tests run: 2016, Failures: 1, Errors: 0
> Some observations:
> If org.apache.derbyTesting.functionTests.tests.lang.LangScripts is used to run views.sql as a single test, then it ran smoothly without a problem.
> .
> Time: 7.109
> OK (1 test)
> But if views.sql is run as part of a suite, then the ordering diff occurs.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] Commented: (DERBY-2048) LangScripts JUnit test fails in
views.sql
Posted by "Yip Ng (JIRA)" <ji...@apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-2048?page=comments#action_12447618 ]
Yip Ng commented on DERBY-2048:
-------------------------------
Just took a brief look at LangScripts, I noticed that it uses a test decorator CleanDatabaseTestSetup which cleans up user tables only. So for SQL scripts that perform alot of DDLs (create table, drop table, etc.), I think this might affect the outcome of certain scripts master output, e.g. fetching rows from system tables in an unordered way. This may be one reason that contribute to the stated problem of this jira and may be problematic in general for adding future test scripts since each testcase in the suite is not starting with an initial database state (like the legacy way) but the database state of the previous script execution.
> LangScripts JUnit test fails in views.sql
> -----------------------------------------
>
> Key: DERBY-2048
> URL: http://issues.apache.org/jira/browse/DERBY-2048
> Project: Derby
> Issue Type: Bug
> Components: Test
> Affects Versions: 10.3.0.0
> Environment: Windows XP
> Reporter: Yip Ng
>
> LangScripts JUnit test fails in views.sql
> There was 1 failure:
> 1) views(org.apache.derbyTesting.functionTests.tests.lang.LangScripts )junit.fram
> ework.ComparisonFailure: Output at line 104 expected:<...T1' because VIEW 'SV[1]' is dependent on th...> but was:<...T1' because VIEW 'SV[2]' is dependent on th...>
> at org.apache.derbyTesting.functionTests.util.CanonTestCase.compareCanon(CanonTestCase.java:100)
> at org.apache.derbyTesting.functionTests.util.ScriptTestCase.runTest(ScriptTestCase.java:117)
> at org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:76)
> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
> at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
> at junit.extensions.TestSetup.run(TestSetup.java:25)
> FAILURES!!!
> Tests run: 2016, Failures: 1, Errors: 0
> Some observations:
> If org.apache.derbyTesting.functionTests.tests.lang.LangScripts is used to run views.sql as a single test, then it ran smoothly without a problem.
> .
> Time: 7.109
> OK (1 test)
> But if views.sql is run as part of a suite, then the ordering diff occurs.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] Assigned: (DERBY-2048) LangScripts JUnit test fails in
views.sql
Posted by "Yip Ng (JIRA)" <ji...@apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-2048?page=all ]
Yip Ng reassigned DERBY-2048:
-----------------------------
Assignee: Yip Ng
> LangScripts JUnit test fails in views.sql
> -----------------------------------------
>
> Key: DERBY-2048
> URL: http://issues.apache.org/jira/browse/DERBY-2048
> Project: Derby
> Issue Type: Bug
> Components: Test
> Affects Versions: 10.3.0.0
> Environment: Windows XP
> Reporter: Yip Ng
> Assigned To: Yip Ng
>
> LangScripts JUnit test fails in views.sql
> There was 1 failure:
> 1) views(org.apache.derbyTesting.functionTests.tests.lang.LangScripts )junit.fram
> ework.ComparisonFailure: Output at line 104 expected:<...T1' because VIEW 'SV[1]' is dependent on th...> but was:<...T1' because VIEW 'SV[2]' is dependent on th...>
> at org.apache.derbyTesting.functionTests.util.CanonTestCase.compareCanon(CanonTestCase.java:100)
> at org.apache.derbyTesting.functionTests.util.ScriptTestCase.runTest(ScriptTestCase.java:117)
> at org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:76)
> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
> at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
> at junit.extensions.TestSetup.run(TestSetup.java:25)
> FAILURES!!!
> Tests run: 2016, Failures: 1, Errors: 0
> Some observations:
> If org.apache.derbyTesting.functionTests.tests.lang.LangScripts is used to run views.sql as a single test, then it ran smoothly without a problem.
> .
> Time: 7.109
> OK (1 test)
> But if views.sql is run as part of a suite, then the ordering diff occurs.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] Updated: (DERBY-2048) LangScripts JUnit test fails in
views.sql
Posted by "Yip Ng (JIRA)" <ji...@apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-2048?page=all ]
Yip Ng updated DERBY-2048:
--------------------------
Derby Info: [Patch Available]
> LangScripts JUnit test fails in views.sql
> -----------------------------------------
>
> Key: DERBY-2048
> URL: http://issues.apache.org/jira/browse/DERBY-2048
> Project: Derby
> Issue Type: Bug
> Components: Test
> Affects Versions: 10.3.0.0
> Environment: Windows XP
> Reporter: Yip Ng
> Assigned To: Yip Ng
> Attachments: derby2048-trunk-diff01.txt, derby2048-trunk-stat01.txt
>
>
> LangScripts JUnit test fails in views.sql
> There was 1 failure:
> 1) views(org.apache.derbyTesting.functionTests.tests.lang.LangScripts )junit.fram
> ework.ComparisonFailure: Output at line 104 expected:<...T1' because VIEW 'SV[1]' is dependent on th...> but was:<...T1' because VIEW 'SV[2]' is dependent on th...>
> at org.apache.derbyTesting.functionTests.util.CanonTestCase.compareCanon(CanonTestCase.java:100)
> at org.apache.derbyTesting.functionTests.util.ScriptTestCase.runTest(ScriptTestCase.java:117)
> at org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:76)
> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
> at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
> at junit.extensions.TestSetup.run(TestSetup.java:25)
> FAILURES!!!
> Tests run: 2016, Failures: 1, Errors: 0
> Some observations:
> If org.apache.derbyTesting.functionTests.tests.lang.LangScripts is used to run views.sql as a single test, then it ran smoothly without a problem.
> .
> Time: 7.109
> OK (1 test)
> But if views.sql is run as part of a suite, then the ordering diff occurs.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] Updated: (DERBY-2048) LangScripts JUnit test fails in
views.sql
Posted by "Daniel John Debrunner (JIRA)" <ji...@apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-2048?page=all ]
Daniel John Debrunner updated DERBY-2048:
-----------------------------------------
Derby Info: (was: [Patch Available])
Committed revision 472613 - Thanks Yip
> LangScripts JUnit test fails in views.sql
> -----------------------------------------
>
> Key: DERBY-2048
> URL: http://issues.apache.org/jira/browse/DERBY-2048
> Project: Derby
> Issue Type: Bug
> Components: Test
> Affects Versions: 10.3.0.0
> Environment: Windows XP
> Reporter: Yip Ng
> Assigned To: Yip Ng
> Attachments: derby2048-trunk-diff01.txt, derby2048-trunk-diff02.txt, derby2048-trunk-stat01.txt
>
>
> LangScripts JUnit test fails in views.sql
> There was 1 failure:
> 1) views(org.apache.derbyTesting.functionTests.tests.lang.LangScripts )junit.fram
> ework.ComparisonFailure: Output at line 104 expected:<...T1' because VIEW 'SV[1]' is dependent on th...> but was:<...T1' because VIEW 'SV[2]' is dependent on th...>
> at org.apache.derbyTesting.functionTests.util.CanonTestCase.compareCanon(CanonTestCase.java:100)
> at org.apache.derbyTesting.functionTests.util.ScriptTestCase.runTest(ScriptTestCase.java:117)
> at org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:76)
> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
> at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
> at junit.extensions.TestSetup.run(TestSetup.java:25)
> FAILURES!!!
> Tests run: 2016, Failures: 1, Errors: 0
> Some observations:
> If org.apache.derbyTesting.functionTests.tests.lang.LangScripts is used to run views.sql as a single test, then it ran smoothly without a problem.
> .
> Time: 7.109
> OK (1 test)
> But if views.sql is run as part of a suite, then the ordering diff occurs.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] Commented: (DERBY-2048) LangScripts JUnit test fails in
views.sql
Posted by "Daniel John Debrunner (JIRA)" <ji...@apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-2048?page=comments#action_12448243 ]
Daniel John Debrunner commented on DERBY-2048:
----------------------------------------------
Cool, interesting approach. Might be better to be clear that objects is really tables here, ie. compressTables(), COMPRESS_OBJECTS, since only tables are the only objects that can be compressed.
> LangScripts JUnit test fails in views.sql
> -----------------------------------------
>
> Key: DERBY-2048
> URL: http://issues.apache.org/jira/browse/DERBY-2048
> Project: Derby
> Issue Type: Bug
> Components: Test
> Affects Versions: 10.3.0.0
> Environment: Windows XP
> Reporter: Yip Ng
> Assigned To: Yip Ng
> Attachments: derby2048-trunk-diff01.txt, derby2048-trunk-stat01.txt
>
>
> LangScripts JUnit test fails in views.sql
> There was 1 failure:
> 1) views(org.apache.derbyTesting.functionTests.tests.lang.LangScripts )junit.fram
> ework.ComparisonFailure: Output at line 104 expected:<...T1' because VIEW 'SV[1]' is dependent on th...> but was:<...T1' because VIEW 'SV[2]' is dependent on th...>
> at org.apache.derbyTesting.functionTests.util.CanonTestCase.compareCanon(CanonTestCase.java:100)
> at org.apache.derbyTesting.functionTests.util.ScriptTestCase.runTest(ScriptTestCase.java:117)
> at org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:76)
> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
> at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
> at junit.extensions.TestSetup.run(TestSetup.java:25)
> FAILURES!!!
> Tests run: 2016, Failures: 1, Errors: 0
> Some observations:
> If org.apache.derbyTesting.functionTests.tests.lang.LangScripts is used to run views.sql as a single test, then it ran smoothly without a problem.
> .
> Time: 7.109
> OK (1 test)
> But if views.sql is run as part of a suite, then the ordering diff occurs.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] Commented: (DERBY-2048) LangScripts JUnit test fails in
views.sql
Posted by "Daniel John Debrunner (JIRA)" <ji...@apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-2048?page=comments#action_12447582 ]
Daniel John Debrunner commented on DERBY-2048:
----------------------------------------------
Tests that are in LangScripts (or all of nist) only run in under JUnit, thus the ordering diff is the issue.
> LangScripts JUnit test fails in views.sql
> -----------------------------------------
>
> Key: DERBY-2048
> URL: http://issues.apache.org/jira/browse/DERBY-2048
> Project: Derby
> Issue Type: Bug
> Components: Test
> Affects Versions: 10.3.0.0
> Environment: Windows XP
> Reporter: Yip Ng
>
> LangScripts JUnit test fails in views.sql
> There was 1 failure:
> 1) views(org.apache.derbyTesting.functionTests.tests.lang.LangScripts )junit.fram
> ework.ComparisonFailure: Output at line 104 expected:<...T1' because VIEW 'SV[1]' is dependent on th...> but was:<...T1' because VIEW 'SV[2]' is dependent on th...>
> at org.apache.derbyTesting.functionTests.util.CanonTestCase.compareCanon(CanonTestCase.java:100)
> at org.apache.derbyTesting.functionTests.util.ScriptTestCase.runTest(ScriptTestCase.java:117)
> at org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:76)
> at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
> at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
> at junit.extensions.TestSetup.run(TestSetup.java:25)
> FAILURES!!!
> Tests run: 2016, Failures: 1, Errors: 0
> Some observations:
> If org.apache.derbyTesting.functionTests.harness.RunTest is used to run views.sql, then it have 2 newline diffs.
> If org.apache.derbyTesting.functionTests.tests.lang.LangScripts is used to run, then the ordering of one of the outputs differs.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira