Bug 780982 (SOA-3453)

Summary: EDS Ingres as source - ORDER BY on TimeValue not properly ordering results as expected
Product: [JBoss] JBoss Enterprise SOA Platform 5 Reporter: Warren Gibson <wgibson>
Component: EDSAssignee: Van Halbert <vhalbert>
Status: CLOSED WONTFIX QA Contact:
Severity: high Docs Contact:
Priority: high    
Version: 5.2.0.ER4   
Target Milestone: ---   
Target Release: ---   
Hardware: Unspecified   
OS: Unspecified   
URL: http://jira.jboss.org/jira/browse/SOA-3453
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2011-11-15 17:46:09 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:
Attachments:
Description Flags
QT_Ingres10_Push.vdb none

Description Warren Gibson 2011-10-06 16:58:30 UTC 
project_key: SOA

EDS Query Testing is getting unexpected results on 68 queries involving ORDER BY on TimeValue.  When an ORDER BY is placed on TimeValue the returned results are not ordered as expected.  

An example query is:  SELECT BQT1.SmallA.TimeValue FROM BQT1.SmallA  ORDER BY TimeValue

The returned results are:

TimeValue
05:00:00
05:00:00
06:00:00
06:00:00
07:00:00
08:00:00
08:00:00
09:00:00
09:00:00
10:00:00
10:00:00
11:00:00
11:00:00
12:00:00
12:00:00
13:00:00
13:00:00
14:00:00
14:00:00
15:00:00
16:00:00
16:00:00
17:00:00
17:00:00
18:00:00
18:00:00
19:00:00
19:00:00
20:00:00
20:00:00
21:00:00
21:00:00
22:00:00
22:00:00
23:00:00
00:00:00
00:00:00
00:00:00
01:00:00
01:00:00
01:00:00
02:00:00
02:00:00
03:00:00
03:00:00
04:00:00
04:00:00
<null>
<null>
<null>
Comment 1 Warren Gibson 2011-10-06 16:59:13 UTC 
Attachment: Added: QT_Ingres10_Push.vdb
Comment 2 Van Halbert 2011-10-06 17:13:02 UTC 
Link: Added: This issue Cloned to SOA-3456
Comment 3 Van Halbert 2011-10-11 13:00:23 UTC 
Link: Added: This issue is related to SOA-3454
Comment 4 Van Halbert 2011-10-11 13:00:44 UTC 
See SOA-3454.