[MCOL-704] backport to 1.0.9: MCOL-686 Using BETWEEN together with date functions in WHERE clause 100x slower than InfiniDB Created: 2017-05-08 Updated: 2017-05-11 Resolved: 2017-05-11 |
|
| Status: | Closed |
| Project: | MariaDB ColumnStore |
| Component/s: | None |
| Affects Version/s: | 1.0.9 |
| Fix Version/s: | 1.0.9 |
| Type: | Task | Priority: | Major |
| Reporter: | David Thompson (Inactive) | Assignee: | Daniel Lee (Inactive) |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | None | ||
| Issue Links: |
|
||||||||
| Sprint: | 2017-9, 2017-10 | ||||||||
| Comments |
| Comment by Andrew Hutchings (Inactive) [ 2017-05-08 ] | ||||
| Comment by Daniel Lee (Inactive) [ 2017-05-11 ] | ||||
|
Build verified: 1.0.9-1 Ran each query after a system restart so they disk runs for fair comparison. MariaDB [tpch10]> select count(l_linenumber) from lineitem where l_shipdate between current_date() and current_date();
---------------------
--------------------- MariaDB [tpch10]> select count(l_linenumber) from lineitem where l_shipdate between '2017-05-11' and '2017-05-11';
---------------------
--------------------- |