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

[Steven Hawkins (Closed) (JIRA)]

     [ https://issues.jboss.org/browse/TEIID-1774?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Steven Hawkins closed TEIID-1774.
---------------------------------


    
> 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