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>