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

Many window function queries returned syntax errors

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

          dleeyh Daniel Lee (Inactive) created issue -
          dleeyh Daniel Lee (Inactive) made changes -
          Field Original Value New Value
          Rank Ranked higher
          David.Hall David Hall (Inactive) made changes -
          Assignee David Hall [ david.hall ]
          David.Hall David Hall (Inactive) made changes -
          Assignee David Hall [ david.hall ] Daniel Lee [ dleeyh ]
          David.Hall David Hall (Inactive) made changes -
          Status Open [ 1 ] In Progress [ 3 ]
          David.Hall David Hall (Inactive) made changes -
          Status In Progress [ 3 ] In Testing [ 10301 ]
          David.Hall David Hall (Inactive) made changes -
          Sprint 2020-3 [ 383 ]
          David.Hall David Hall (Inactive) made changes -
          Fix Version/s 1.4.4 [ 24039 ]
          David.Hall David Hall (Inactive) made changes -
          Sprint 2020-3 [ 383 ] 2020-3, 2020-4 [ 383, 392 ]
          toddstoffel Todd Stoffel (Inactive) made changes -
          Team ColumnStore Team
          David.Hall David Hall (Inactive) made changes -
          Sprint 2020-3, 2020-4 [ 383, 392 ] 2020-3, 2020-4, 2020-5 [ 383, 392, 396 ]
          David.Hall David Hall (Inactive) made changes -
          Sprint 2020-3, 2020-4, 2020-5 [ 383, 392, 396 ] 2020-3, 2020-4 [ 383, 392 ]
          David.Hall David Hall (Inactive) made changes -
          Sprint 2020-3, 2020-4 [ 383, 392 ] 2020-3, 2020-4, 2020-5 [ 383, 392, 396 ]
          dleeyh Daniel Lee (Inactive) made changes -
          issue.field.resolutiondate 2020-03-27 14:53:28.0 2020-03-27 14:53:28.185
          dleeyh Daniel Lee (Inactive) made changes -
          Resolution Fixed [ 1 ]
          Status In Testing [ 10301 ] Closed [ 6 ]

          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.