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

Sleep function not supported in ColumnStore

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Won't Do
    • 1.4
    • Icebox
    • N/A
    • None

    Description

      The sleep() function is not yet implemented in CS:

      MariaDB [test]> create table c1 (a int)engine=columnstore;
      Query OK, 0 rows affected (0.286 sec)
       
      MariaDB [test]> insert into c1 values (1), (2), (3);
      Query OK, 3 rows affected (0.244 sec)
      Records: 3  Duplicates: 0  Warnings: 0
       
      MariaDB [test]> select sleep(a) from c1;
      ERROR 1178 (42000): The storage engine for the table doesn't support IDB-1001: Function 'sleep' can only be used in the outermost select or order by clause and cannot be used in conjunction with an aggregate function.
      
      

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              tntnatbry Gagan Goel (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              4 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.