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

Many window function queries returned syntax errors

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 1.4.1
    • 1.4.4
    • MariaDB Server
    • None
    • 2020-3, 2020-4, 2020-5

    Description

      Build tested: 1.4.1-1

      [dlee@cs-tst-01 centos7]$ cat gitversionInfo.txt
      engine commit:
      3e7a964

      Test suite: autopilot.windowFunctions

      There are a total of 6576 queries in the test suite. 2976 of them failed with a syntax error. All these queries got executed successfully in 1.2.5-1 and 1.4.0-1.

      select o_custkey, regr_syy(o_custkey,o_orderkey) OVER (PARTITION BY 55 ORDER BY o_custkey ,o_orderkey ROWS BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING) from orders order by 1, 2;
      ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'OVER (PARTITION BY 55 ORDER BY o_custkey ,o_orderkey ROWS BETWEEN CURRENT ROW AN' at line 1

      All returned errors complain about "near the OVER keyword"

      Attachments

        Activity

          People

            dleeyh Daniel Lee (Inactive)
            dleeyh Daniel Lee (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.