MySQL 8.0

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

CREATE TABLE test ( id INT PRIMARY KEY, val INT);
INSERT INTO test VALUES 
(1,1),
(2,19),
(3,5),
(4,9),
(5,2),
(6,30),
(7,3),
(8,14),
(9,24);
SELECT * FROM test ORDER BY val;


id
val


1
1

5
2

7
3

3
5

4
9

8
14

2
19

9
24

6
30


SET @sum := 50;
WITH RECURSIVE
cte AS ( SELECT id, CONCAT_WS(',', id) kit, val summ 
         FROM test
         UNION ALL
         SELECT test.id, CONCAT_WS(',', test.id, cte.kit), cte.summ + test.val
         FROM cte
         JOIN test ON cte.id > test.id
         WHERE cte.summ + test.val <= @sum )
SELECT kit, summ 
FROM cte
WHERE summ = @sum;


kit
summ


1,2,6
50

1,3,6,8
50

2,3,5,9
50

4,7,8,9
50

2,3,4,7,8
50

1,5,6,7,8
50

1,4,5,8,9
50

1,3,4,5,6,7
50

1,2,3,4,5,8
50

kit	summ
1,2,6	50
1,3,6,8	50
2,3,5,9	50
4,7,8,9	50
2,3,4,7,8	50
1,5,6,7,8	50
1,4,5,8,9	50
1,3,4,5,6,7	50
1,2,3,4,5,8	50