[
https://issues.apache.org/jira/browse/DERBY-6336?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14093876#comment-14093876
]
Knut Anders Hatlen commented on DERBY-6336:
-------------------------------------------
Failed again with the extra diagnostics.
http://download.java.net/javadesktop/derby/request_5594417/javadb-task-3909544.html
The full plan looks like this (uses an index scan instead of the expected table
scan):
{noformat}
Statement Name:
null
Statement Text:
select count(c1 + c2) from t where c1 = 1
Parse Time: 0
Bind Time: 0
Optimize Time: 0
Generate Time: 0
Compile Time: 0
Execute Time: 0
Begin Compilation Timestamp : null
End Compilation Timestamp : null
Begin Execution Timestamp : null
End Execution Timestamp : null
Statement Execution Plan Text:
Project-Restrict ResultSet (5):
Number of opens = 2
Rows seen = 2
Rows filtered = 0
restriction = false
projection = true
constructor time (milliseconds) = 0
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
restriction time (milliseconds) = 0
projection time (milliseconds) = 0
optimizer estimated row count: 1.00
optimizer estimated cost: 1542.90
Source result set:
Scalar Aggregate ResultSet:
Number of opens = 2
Rows input = 2500
constructor time (milliseconds) = 0
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
optimizer estimated row count: 85.00
optimizer estimated cost: 1542.90
Index Key Optimization = false
Source result set:
Project-Restrict ResultSet (4):
Number of opens = 2
Rows seen = 2500
Rows filtered = 0
restriction = false
projection = true
constructor time (milliseconds) = 0
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
restriction time (milliseconds) = 0
projection time (milliseconds) = 0
optimizer estimated row count: 85.00
optimizer estimated cost: 1542.90
Source result set:
Index Row to Base Row ResultSet for T:
Number of opens = 2
Rows seen = 2500
Columns accessed from heap = {0, 1}
constructor time (milliseconds) = 0
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
optimizer estimated row count: 85.00
optimizer estimated cost: 1542.90
Index Scan ResultSet for T using index IDX at
read committed isolation level using instantaneous share row locking chosen by
the optimizer
Number of opens = 2
Rows seen = 2500
Rows filtered = 0
Fetch Size = 16
constructor time (milliseconds) = 0
open time (milliseconds) = 0
next time (milliseconds) = 0
close time (milliseconds) = 0
next time in milliseconds/row = 0
scan information:
Bit set of columns fetched=All
Number of columns fetched=2
Number of deleted rows visited=0
Number of pages visited=15
Number of rows qualified=1250
Number of rows visited=1251
Scan type=btree
Tree height=2
start position:
>= on first 1 column(s).
Ordered null semantics on the
following columns:
stop position:
> on first 1 column(s).
Ordered null semantics on the
following columns:
qualifiers:
None
optimizer estimated row count: 85.00
optimizer estimated cost: 1542.90
{noformat}
> AssertionFailedError in
> testStalePlansOnLargeTable(org.apache.derbyTesting.functionTests.tests.lang.StalePlansTest)
> -------------------------------------------------------------------------------------------------------------------
>
> Key: DERBY-6336
> URL: https://issues.apache.org/jira/browse/DERBY-6336
> Project: Derby
> Issue Type: Bug
> Components: Test
> Affects Versions: 10.11.1.1
> Environment: Windows 2008, ibm 1.7 SR5.
> Reporter: Myrna van Lunteren
> Attachments: d6336-more-info.diff
>
>
> Saw this in nightly testing of trunk (10.11 alpha at revision 1520189):
> testStalePlansOnLargeTable(org.apache.derbyTesting.functionTests.tests.lang.StalePlansTest)junit.framework.AssertionFailedError
> at
> org.apache.derbyTesting.functionTests.tests.lang.StalePlansTest.testStalePlansOnLargeTable(StalePlansTest.java:252)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:76)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at
> org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:117)
> at
> org.apache.derbyTesting.junit.BaseJDBCTestCase.runBareOverridable(BaseJDBCTestCase.java:439)
> at
> org.apache.derbyTesting.junit.BaseJDBCTestCase.runBare(BaseJDBCTestCase.java:456)
> 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)
> at
> org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
> 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)
> at
> org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
--
This message was sent by Atlassian JIRA
(v6.2#6252)
