[DERBY-2916] Change/error? in 'Ordered null semantics' output from 'SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS()' in lang/wisconsin.java

• Type: Bug
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Affects Version/s: 10.4.1.3
• Component/s: Services, SQL
• Labels: derby_triage10_12 derby_triage10_8
• Environment: OS: All; JVM: All
• Urgency: Normal
• Bug behavior facts: Regression Test Failure
• Assignee: Unassigned
• Reporter: Ole Solberg
• Created: 10/Jul/07 19:58
• Updated: 22/Jan/15 23:54

Description

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
'

Issue Links

• is related to: DERBY-4284 All Columns become Nullable when Using left join