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

Create Events on Columnstore

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Done
    • 1.0.7
    • Icebox
    • MariaDB Server
    • None
    • Mariadb Columnstore 1.0.7,
      Red Hat 4.8.5-11 (GCC),
      /usr/local/mariadb/columnstore/mysql/bin/mysql Ver 15.1 Distrib 10.1.21-MariaDB

    Description

      Mariadb Columnstore supports creation of a simple event with just inserting current date, hour and second to a columnstore table. However, if I try to insert future dates as shown below, it doesn't insert.

      1. event_scheduler is ON

      create table eventtest
      (
      Id int,
      dates date,
      hours int,
      minutes int
      )engine=columnstore;

      create event testing
      on schedule every 1 minute
      do
      insert into eventtest(id,dates,hours,minutes)
      select 1 as id,t.dates,t.hours,t.minutes
      from
      (
      select current_date as dates,10 as hours, 0 as minutes union
      select adddate(current_date,1) as dates,10 as hours, 0 as minutes union
      select adddate(current_date,2) as dates,10 as hours, 0 as minutes union
      select adddate(current_date,3) as dates,10 as hours, 0 as minutes union
      select adddate(current_date,4) as dates,10 as hours, 0 as minutes union
      select adddate(current_date,5) as dates,10 as hours, 0 as minutes union
      select adddate(current_date,6) as dates,10 as hours, 0 as minutes union
      select adddate(current_date,7) as dates,10 as hours, 0 as minutes union
      select adddate(current_date,8) as dates,10 as hours, 0 as minutes
      ) t left join
      dataset.eventtest et on cast(t.dates as date) = cast(et.dates as date) and t.hours = et.hours
      where et.dates is null
      ;

      Attachments

        Activity

          People

            dthompson David Thompson (Inactive)
            bobypeter BOBY PETER
            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.