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>