ArcadeDB Version: v23.1.1 (build aa687e4/1673895089679/main)

JDK Version: openjdk 11.0.17 2022-10-18

OS: MacOS 12.6

I know this is a tall order, but it was confusing for me that the ORDER BY clause had no effect on the results in the results table of the studio. It seems the (data)table sorts the data by itself and does not keep the order of the JSON response (console results and JSON result in studio appear correctly sorted).

Expected behavior

Results in table panel of the studio sorted according to ORDER BY of query.

Actual behavior

Results in table panel of studio sorted by some field (first column?).

Steps to reproduce

CREATE DOCUMENT TYPE doc;
INSERT INTO doc SET chr = 'a', val = 3;
INSERT INTO doc SET chr = 'b', val = 2;
INSERT INTO doc SET chr = 'c', val = 3;
INSERT INTO doc SET chr = 'c', val = 4;
INSERT INTO doc SET chr = 'c', val = 2;
INSERT INTO doc SET chr = 'z', val = 0;
SELECT chr, val FROM doc ORDER BY chr DESC, val DESC;