[
https://issues.apache.org/jira/browse/DERBY-5486?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13144430#comment-13144430
]
Knut Anders Hatlen commented on DERBY-5486:
-------------------------------------------
It looks to me as if the tests failed because the sequence returned the same
value twice. That sounds like a bug to me. I'm able to reproduce it on trunk by
running these two ij sessions:
ij version 10.9
ij> connect 'jdbc:derby:db;create=true';
ij> create sequence s;
0 rows inserted/updated/deleted
ij> values next value for s;
1
-----------
-2147483648
1 row selected
ij>
At this point, kill the ij process. Should not be a clean shutdown. Then
restart ij and retrieve the next value from the sequence:
ij version 10.9
ij> connect 'jdbc:derby:db';
ij> values next value for s;
1
-----------
-2147483648
1 row selected
ij>
Here, we got the same value as we did the first time, but we should have got a
new value.
> Upgrade tests should verify that DERBY-4437 was backed out of 10.8.2.2
> ----------------------------------------------------------------------
>
> Key: DERBY-5486
> URL: https://issues.apache.org/jira/browse/DERBY-5486
> Project: Derby
> Issue Type: Improvement
> Components: SQL, Test
> Reporter: Rick Hillegas
> Assignee: Rick Hillegas
> Attachments: derby-5486-01-ab-mergeFiles.diff,
> derby-5486-02-aa-removeTests.diff
>
>
> The following code in UpgradeRun needs to be reworked to verify that
> sequence/identities behave as expected when upgrading from 10.8.2.2:
> if ( lessThan( version, new int[] { 10, 8, 1, 6 } ) )
> { suite.addTest(Changes10_8_2.suite(phase)); }
> The following might do the trick:
> if (oldMinor < 7)
> suite.addTest(Changes10_7.suite(phase));
> if (oldMinor < 9)
> {
> suite.addTest(Changes10_9.suite(phase));
> suite.addTest(Changes10_8_2.suite(phase));
> }
> Thanks to Kristian for spotting this.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
