Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-704

backport to 1.0.9: MCOL-686 Using BETWEEN together with date functions in WHERE clause 100x slower than InfiniDB

Details

    • Task
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 1.0.9
    • 1.0.9
    • None
    • None
    • 2017-9, 2017-10

    Attachments

      Issue Links

        relates to

        Bug - A problem which impairs or prevents the functions of the product. MCOL-686 Using BETWEEN together with date functions in WHERE clause 100x slower than InfiniDB

        • Minor - Minor loss of function, or other problem where easy workaround is present.
        • Closed

        Activity

          Ascending order - Click to sort in descending order
          LinuxJedi Andrew Hutchings (Inactive) added a comment -

          Cherry picked MCOL-686 fix into a pull request for MCOL-704

          LinuxJedi Andrew Hutchings (Inactive) added a comment - Cherry picked MCOL-686 fix into a pull request for MCOL-704
          dleeyh Daniel Lee (Inactive) added a comment -

          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();
          ---------------------

          count(l_linenumber)

          ---------------------

          0

          ---------------------
          1 row in set (0.14 sec)

          MariaDB [tpch10]> select count(l_linenumber) from lineitem where l_shipdate between '2017-05-11' and '2017-05-11';
          ---------------------

          count(l_linenumber)

          ---------------------

          0

          ---------------------
          1 row in set (0.13 sec)

          dleeyh Daniel Lee (Inactive) added a comment - 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(); --------------------- count(l_linenumber) --------------------- 0 --------------------- 1 row in set (0.14 sec) MariaDB [tpch10] > select count(l_linenumber) from lineitem where l_shipdate between '2017-05-11' and '2017-05-11'; --------------------- count(l_linenumber) --------------------- 0 --------------------- 1 row in set (0.13 sec)

          People

            dleeyh Daniel Lee (Inactive)
            dthompson David Thompson (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.