[
https://issues.apache.org/jira/browse/DERBY-2916?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12751217#action_12751217
]
Dag H. Wanvik commented on DERBY-2916:
--------------------------------------
Thanks for this analysis, Knut. Your characterization of the issue seems
correct to me.
I don't know what it would take for the optimizer to pick up the optimization
again, but your theory
warrants investigation, I think.
> Change/error? in 'Ordered null semantics' output from
> 'SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS()' in lang/wisconsin.java
> -----------------------------------------------------------------------------------------------------------------------
>
> Key: DERBY-2916
> URL: https://issues.apache.org/jira/browse/DERBY-2916
> Project: Derby
> Issue Type: Bug
> Components: Test
> Affects Versions: 10.4.1.3
> Environment: OS: All
> JVM: All
> Reporter: Ole Solberg
> Assignee: Daniel John Debrunner
> Priority: Minor
>
> SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS() on
> 'Statement Text:
> select * from TENKTUP1
> left outer join TENKTUP2 on
> (
> TENKTUP1.unique1 = TENKTUP2.unique1
> )
> left outer join ONEKTUP on
> (
> TENKTUP2.unique2 = ONEKTUP.unique2
> )
> left outer join BPRIME on
> (
> ONEKTUP.onePercent = BPRIME.onePercent
> )
> '
> now returns extra "0" in
> ' Ordered null semantics on the following columns:
> 0
> stop position:
> > on first 1 column(s).
> Ordered null semantics on the following columns:
> 0
> '
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
