Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Done
-
1.0.7
-
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.
- 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
;