SELECT vs INSERT INTO SELECT different number of rows with recursive cte
I would like to ask for clarification if this behavior is "by design" or is it a bug.
The idea is that recursive CTE returns 6 rows, but when combined with INSERT INTO ... SELECT it has only 4 rows.
Usage of MERGE or any blocking operators like
TOP (100) PERCENT/
ORDER BY 1 OFFSET 0 ROWS will cause that both SELECT and INSERT INTO SELECT have the same 6 rows.