[perf] Add more perf sqls
@@ -25,7 +25,18 @@ perfs:
query: SELECT substring(cast(number as text) from 3) from numbers_mt(100000) where number > 100 order by number desc limit 10
- name: Group By
- query: SELECT max(number) as max,sum(number) as sum FROM numbers_mt(1000000) GROUP BY number % 3, number % 4, number % 5 ORDER BY max
+ query: SELECT max(number) as max,sum(number) as sum FROM numbers_mt(10000000) GROUP BY number % 3, number % 4, number % 5 ORDER BY max
+ - name: Filter Eq
+ query: SELECT cout() FROM numbers_mt(100000000) where number = 10000
+
+ - name: Filter Neq
+ query: SELECT cout() FROM numbers_mt(100000000) where number != 10000
+
+ - name: Filter Gt
+ query: SELECT cout() FROM numbers_mt(100000000) where number > 10000
+
+ - name: Filter GtLt
+ query: SELECT cout() FROM numbers_mt(100000000) where number > 10000 and number <= 100000000
