[DERBY-5933] SQL sorting error

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 10.0.2.1, 10.1.1.0, 10.2.1.6, 10.3.1.4, 10.4.1.3, 10.5.1.1, 10.6.1.0, 10.7.1.1, 10.8.1.2, 10.9.1.0
• Fix Version/s: 10.8.3.3, 10.9.2.2, 10.10.1.1
• Component/s: SQL
• Labels: derby_triage10_10
• Environment: Windows 7 Netbeans JDBC GUI
• Urgency: Normal
• Issue & fix info: Repro attached
• Bug behavior facts: Wrong query result
• Assignee: Dag H. Wanvik
• Reporter: Vlasov Igor
• Created: 20/Sep/12 12:29
• Updated: 03/Sep/14 08:31
• Resolved: 04/Feb/13 10:39

Description

Hello
I have a simple database with 100 records.
I am running a SQL query from Netbeans GUI though JDBC

This query was generated by Hibernate ORM.

In certain circumstances the result rowset is not sorting.

When I use condition morefld2_.mf_id in (5) the result is unsortable.
When I use condition morefld2_.mf_id in (5,0) the result is sorting properly.

Issue Links

• is related to: DERBY-2526 Wrong results with queries that use the JOIN ... ON syntax to join with views or other non-base table expressions.
• is related to: DERBY-3023 Different result rows depending on the sequence of INNER JOIN and OUTER JOIN
• is related to: DERBY-4679 Several left outer joins causes unstable query with incorrect results
• is related to: DERBY-6289 Derby 10.8 backport issue (summer 2013)
• is related to: DERBY-4695 Internal assignment of tablenumer, columnnumber looks wrong in query tree, although no ill effects are seen.