Bug 780982 (SOA-3453) - EDS Ingres as source - ORDER BY on TimeValue not properly ordering results as expected
Summary: EDS Ingres as source - ORDER BY on TimeValue not properly ordering results as...
Keywords:
Status: CLOSED WONTFIX
Alias: SOA-3453
Product: JBoss Enterprise SOA Platform 5
Classification: JBoss
Component: EDS
Version: 5.2.0.ER4
Hardware: Unspecified
OS: Unspecified
high
high
Target Milestone: ---
: ---
Assignee: Van Halbert
QA Contact:
URL: http://jira.jboss.org/jira/browse/SOA...
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2011-10-06 16:58 UTC by Warren Gibson
Modified: 2011-11-15 17:46 UTC (History)
0 users

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2011-11-15 17:46:09 UTC
Type: Bug


Attachments (Terms of Use)
QT_Ingres10_Push.vdb (218.20 KB, application/octet-stream)
2011-10-06 16:59 UTC, Warren Gibson
no flags Details


Links
System ID Private Priority Status Summary Last Updated
Red Hat Bugzilla 780983 0 high CLOSED EDS Ingres as source - WHERE CLAUSE is not returning expected results in some cases 2021-02-22 00:41:40 UTC
Red Hat Issue Tracker SOA-3453 0 None None None Never
Red Hat Issue Tracker TEIID-1774 0 None None None Never

Internal Links: 780983

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.


Note You need to log in before you can comment on or make changes to this bug.