Details
-
Bug
-
Resolution: Won't Do
-
Major
-
None
-
8.12.11.6_4
-
None
Description
Examples of queries which don't behave as expected when running against MongoDB:
SELECT BQT1.SmallA.TimeValue FROM BQT1.SmallA WHERE BQT1.SmallA.TimeValue > '17:00:00'
returns ALL timevalues which are not null
SELECT BQT1.SmallA.TimeValue FROM BQT1.SmallA WHERE BQT1.SmallA.TimeValue < '17:00:00'
returns NO timevalues even though there are some less than 17:00
SELECT BQT1.SmallA.TimeValue FROM BQT1.SmallA WHERE BQT1.SmallA.TimeValue = '15:00:00'
returns nothing
SELECT BQT1.SmallA.IntKey FROM BQT1.SmallA WHERE BQT1.SmallA.TimeValue IN (convert('05:00:00', time), convert('15:00:00', time))
returns nothing