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

Can't create view by using ColumnStore's windowing funcion SQL

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 1.0.7
    • 1.1.0
    • MariaDB Server
    • None
    • 2017-12, 2017-13, 2017-14, 2017-15, 2017-16, 2017-17, 2017-18

    Description

      Original SQL:
      SELECT mobile, nick_name, lead (nick_name, 1) over (PARTITION BY wm ORDER BY create_date ASC) AS next_name FROM ods_user;

      Create View SQL:
      SELECT `ods_user`.`MOBILE` AS `mobile`, `ods_user`.`NICK_NAME` AS `nick_name`, `lead`(
      `test`.`ods_user`.`NICK_NAME`,1,NULL,1) AS `next_name`
      FROM `ods_user`

      Attachments

        Activity

          People

            dleeyh Daniel Lee (Inactive)
            chenxinglong Allen Chan
            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.