MariaDB 10.4

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

select version();


version()


10.4.26-MariaDB-1:10.4.26+maria~deb10-log


create table t(i int not null, j int not null, primary key (i,j))
insert into t values (1 ,	3),
(2 ,	3),
(3 ,	6),
(4 ,	5),
(5 ,	6),
(6 ,	8),
(7 ,	10),
(8 ,	9)

Records: 8  Duplicates: 0  Warnings: 0


with recursive path as ( select i,j from t where i=1 union all select t.i, t.j from t join path where path.j=t.i) select * from path


i
j


1
3

3
6

6
8

8
9