MariaDB 10.5

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

select version();


version()


10.5.17-MariaDB-1:10.5.17+maria~deb11


create table ranges (id serial, mindate date, maxdate date);
insert into ranges (mindate,maxdate) values (20110101,20110110),(20110213,20110215),(20111019,20111210);

Records: 3  Duplicates: 0  Warnings: 0


select * from ranges;


id
mindate
maxdate


1
2011-01-01
2011-01-10

2
2011-02-13
2011-02-15

3
2011-10-19
2011-12-10


with recursive expanded_ranges as (
    select id, mindate dt
    from ranges
    union all
    select expanded_ranges.id, expanded_ranges.dt+interval 1 day
    from expanded_ranges
    join ranges on expanded_ranges.id=ranges.id and dt<maxdate
)
select * from expanded_ranges
order by id, dt;


id
dt


1
2011-01-01

1
2011-01-02

1
2011-01-03

1
2011-01-04

1
2011-01-05

1
2011-01-06

1
2011-01-07

1
2011-01-08

1
2011-01-09

1
2011-01-10

2
2011-02-13

2
2011-02-14

2
2011-02-15

3
2011-10-19

3
2011-10-20

3
2011-10-21

3
2011-10-22

3
2011-10-23

3
2011-10-24

3
2011-10-25

3
2011-10-26

3
2011-10-27

3
2011-10-28

3
2011-10-29

3
2011-10-30

3
2011-10-31

3
2011-11-01

3
2011-11-02

3
2011-11-03

3
2011-11-04

3
2011-11-05

3
2011-11-06

3
2011-11-07

3
2011-11-08

3
2011-11-09

3
2011-11-10

3
2011-11-11

3
2011-11-12

3
2011-11-13

3
2011-11-14

3
2011-11-15

3
2011-11-16

3
2011-11-17

3
2011-11-18

3
2011-11-19

3
2011-11-20

3
2011-11-21

3
2011-11-22

3
2011-11-23

3
2011-11-24

3
2011-11-25

3
2011-11-26

3
2011-11-27

3
2011-11-28

3
2011-11-29

3
2011-11-30

3
2011-12-01

3
2011-12-02

3
2011-12-03

3
2011-12-04

3
2011-12-05

3
2011-12-06

3
2011-12-07

3
2011-12-08

3
2011-12-09

3
2011-12-10

id	mindate	maxdate
1	2011-01-01	2011-01-10
2	2011-02-13	2011-02-15
3	2011-10-19	2011-12-10

id	dt
1	2011-01-01
1	2011-01-02
1	2011-01-03
1	2011-01-04
1	2011-01-05
1	2011-01-06
1	2011-01-07
1	2011-01-08
1	2011-01-09
1	2011-01-10
2	2011-02-13
2	2011-02-14
2	2011-02-15
3	2011-10-19
3	2011-10-20
3	2011-10-21
3	2011-10-22
3	2011-10-23
3	2011-10-24
3	2011-10-25
3	2011-10-26
3	2011-10-27
3	2011-10-28
3	2011-10-29
3	2011-10-30
3	2011-10-31
3	2011-11-01
3	2011-11-02
3	2011-11-03
3	2011-11-04
3	2011-11-05
3	2011-11-06
3	2011-11-07
3	2011-11-08
3	2011-11-09
3	2011-11-10
3	2011-11-11
3	2011-11-12
3	2011-11-13
3	2011-11-14
3	2011-11-15
3	2011-11-16
3	2011-11-17
3	2011-11-18
3	2011-11-19
3	2011-11-20
3	2011-11-21
3	2011-11-22
3	2011-11-23
3	2011-11-24
3	2011-11-25
3	2011-11-26
3	2011-11-27
3	2011-11-28
3	2011-11-29
3	2011-11-30
3	2011-12-01
3	2011-12-02
3	2011-12-03
3	2011-12-04
3	2011-12-05
3	2011-12-06
3	2011-12-07
3	2011-12-08
3	2011-12-09
3	2011-12-10