Hide Forgot
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>
Attachment: Added: QT_Ingres10_Push.vdb
Link: Added: This issue Cloned to SOA-3456
Link: Added: This issue is related to SOA-3454
See SOA-3454.