You've already forked mariadb-columnstore-engine
mirror of
https://github.com/mariadb-corporation/mariadb-columnstore-engine.git
synced 2025-08-08 14:22:09 +03:00
bfe49a8345
This fixes discrepance with the server, which assigns DATE type to last_day()'s result. Now we also assigns DATE result type and, also, use proper dataconvert::Day data structure to return date. Tests agree with InnoDB. Also, this patch includes test for MCOL-5669, to show we fixed it.
22 lines
924 B
Plaintext
22 lines
924 B
Plaintext
--source ../include/have_columnstore.inc
|
|
--disable_warnings
|
|
DROP DATABASE IF EXISTS mcol_5670;
|
|
--enable_warnings
|
|
CREATE DATABASE mcol_5670;
|
|
USE mcol_5670;
|
|
|
|
|
|
# using lastday with DATE type
|
|
create table my_colstore_tab(`yyyymmdd` date DEFAULT NULL) engine=COLUMNSTORE;
|
|
insert into my_colstore_tab values(date('2024-03-18'));
|
|
insert into my_colstore_tab values(date(date('2024-03-18')-interval 1 year));
|
|
select day(s.yyyymmdd) as OK_1, last_day(s.yyyymmdd) as OK_2, day(last_day(s.yyyymmdd)) as OK_3 from my_colstore_tab s;
|
|
|
|
# using lastday with DATETIME type
|
|
create table my_colstore_tab2(`yyyymmdd` datetime DEFAULT NULL) engine=COLUMNSTORE;
|
|
insert into my_colstore_tab2 values('2024-03-18 13:40:31');
|
|
insert into my_colstore_tab2 values('2024-03-18 13:40:31'-interval 1 year);
|
|
select day(s.yyyymmdd) as OK_1, last_day(s.yyyymmdd) as OK_2, day(last_day(s.yyyymmdd)) as OK_3 from my_colstore_tab2 s;
|
|
|
|
DROP DATABASE mcol_5670;
|