Note: This bug is displayed in read-only format because the product is no longer active in Red Hat Bugzilla.

Bug 1329178

Summary: Impala - result set is not sorted if ORDER BY is defined in query
Product: [JBoss] JBoss Data Virtualization 6 Reporter: Juraj Duráni <jdurani>
Component: TeiidAssignee: Van Halbert <vhalbert>
Status: CLOSED CURRENTRELEASE QA Contact: Filip Elias <felias>
Severity: medium Docs Contact:
Priority: medium    
Version: 6.3.0CC: aszczucz, blafond, jolee, jstastny, mbaluch, thauser, vhalbert
Target Milestone: ER3   
Target Release: 6.3.0   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2016-08-24 11:37:01 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:

Description Juraj Duráni 2016-04-21 10:35:36 UTC 
Query:
SELECT g_1.StringNum AS c_0 FROM Source.SmallA AS g_1 WHERE g_1.IntKey <= 50 UNION ALL SELECT g_0.StringNum AS c_0 FROM Source.SmallB AS g_0 WHERE g_0.IntKey > 50 ORDER BY c_0

Result: as you can see, nulls are not next to each other
|StringNum|
|-24|
|<null>|
|-14|
|-13|
|-12|
|-11|
|-10|
|-9|
|-8|
|<null>|
|-6
|-5|
|...|

Expected result: this is result of simple query SELECT stringnum FROM source.smalla ORDER BY 1
|StringNum|
|-1|
|-10|
|-11|
|-12|
|-13|
|-14|
|-15|
|...|
Comment 1 JBoss JIRA Server 2016-04-21 16:21:16 UTC 
Steven Hawkins <shawkins> updated the status of jira TEIID-4160 to Resolved
Comment 2 Juraj Duráni 2016-04-25 05:48:22 UTC 
Setting flag blocker? because related JIRA is a blocker.
Comment 3 JBoss JIRA Server 2016-06-03 20:34:40 UTC 
Steven Hawkins <shawkins> updated the status of jira TEIID-4160 to Closed