Skip to content

v0.1.15

Latest

Choose a tag to compare

@github-actions github-actions released this 17 Jul 14:13

Added

  • limit in SQL Query now support negative number, which return last n rows instead top n rows for positive number, the common SQL
SELECT * FROM (
    SELECT * 
    FROM your_table 
    ORDER BY ts DESC 
    LIMIT 10
) AS subquery
ORDER BY ts ASC;

can be simplify to

SELECT * FROM your_table ORDER BY ts ASC LIMIT -10;

Fix

  • Fix performance regression of large object query.