[teiid-issues] [JBoss JIRA] (TEIID-1774) Ingres as source - ORDER BY on TimeValue not properly ordering results as expected

[Warren Gibson (Commented) (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-1774?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12632934#comment-12632934 ] 

Warren Gibson commented on TEIID-1774:
--------------------------------------

I built the timetest (x time) sample also.  All the metadata for the BQT TimeValue column is the same as the timetest (x time) example.  The standard BQT test data contains 00:00:00 in some rows.  After testing further I find the order gets confused and starts sequencing again following a 00:00:00 TimeValue.   Not sure why.  

Example:   

22	22:00:00
46	22:00:00
47	23:00:00
48	00:00:00
24	00:00:00
0	00:00:00
1	01:00:00
49	01:00:00
25	01:00:00
2	02:00:00
26	02:00:00
3	03:00:00


                
> Ingres as source - ORDER BY on TimeValue not properly ordering results as expected
> ----------------------------------------------------------------------------------
>
>                 Key: TEIID-1774
>                 URL: https://issues.jboss.org/browse/TEIID-1774
>             Project: Teiid
>          Issue Type: Bug
>          Components: Misc. Connectors
>    Affects Versions: 7.4.1
>            Reporter: Warren Gibson
>            Assignee: Steven Hawkins
>
> 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>

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira