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 "Daniel John Debrunner (JIRA)" <ji...@apache.org> on 2007/07/10 22:44:04 UTC
[jira] Commented: (DERBY-2916) Change/error? in 'Ordered null
semantics' output from 'SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS()' in
lang/wisconsin.java
[ https://issues.apache.org/jira/browse/DERBY-2916?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12511567 ]
Daniel John Debrunner commented on DERBY-2916:
----------------------------------------------
It's probably one of my DERBY-2775 changes, but I don't know what that portion of the query plan really means.
There was a chance before my changes that the nullability of a result column at runtime could be changed incorrectly by having multiple nodes referring to the same DataTypeDescriptor object and one node changing the nullability would change it for all other nodes that referenced the same object. That potential bug goes away with the changes, so that change in plan (but not results) may be a result of that.
> 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
> Affects Versions: 10.4.0.0
> Environment: OS: All
> JVM: All
> Reporter: Ole Solberg
> 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.