ORDER BY works with both ASC and DESC options, when used with a DATETIME_MICROS property.
ORDER BY [...] ASC works, ORDER BY [...] DESC does not work.
Executing the attached testLocalDateTimeComparison test case, produces the following result:
sql String: INSERT INTO Product SET name = ?, type = ?, start = ?, stop = ?, parameters = [CS_OPER_AUX_ORBDOR_20220318T215523_20220320T002323_F001.EEF, AUX_ORBDOR, 2022-03-18T21:55:23, 2022-03-20T00:23:23]
result: CS_OPER_AUX_ORBDOR_20220318T215523_20220320T002323_F001.EEF, AUX_ORBDOR, 2022-03-18T21:55:23, 2022-03-20T00:23:23
sql String: SELECT name, start, stop FROM Product WHERE type = ? AND start <= ? AND stop >= ? ORDER BY start DESC, parameters = [AUX_ORBDOR, 2022-03-19T00:26:24.404379, 2022-03-19T00:28:26.525650]
sql String: SELECT name, start, stop FROM Product WHERE type = ? AND start <= ? AND stop >= ? ORDER BY start ASC, parameters = [AUX_ORBDOR, 2022-03-19T00:26:24.404379, 2022-03-19T00:28:26.525650]
start = 2022-03-18T21:55:23, stop = 2022-03-20T00:23:23
ArcadeDB Version: v23.1.2 (build 9dbe3ce/1675372179356/main)
JDK Version: openjdk version "11.0.12" 2021-07-20 LTS
OS: Windows 10 Enterprise 22H2
Expected behavior
ORDER BY works with both ASC and DESC options, when used with a DATETIME_MICROS property.
Actual behavior
ORDER BY [...] ASC works, ORDER BY [...] DESC does not work.
Steps to reproduce
Executing the attached testLocalDateTimeComparison test case, produces the following result:
testLocalDateTimeOrderBy.zip