CTE: Non-recursive term and recursive term should have the same schema #9794

DataFusion CLI v36.0.0
❯ WITH RECURSIVE my_cte AS(
    SELECT 1::int AS a
    UNION ALL
    SELECT a+2 FROM my_cte WHERE a<3
) SELECT * FROM my_cte;
Arrow error: Invalid argument error: Invalid comparison operation: Int64 < Int32

❯ WITH RECURSIVE my_cte AS (
    SELECT 1::bigint AS a
    UNION ALL
    SELECT a+2, 'a','c' FROM my_cte WHERE a<3
) SELECT * FROM my_cte;
+---+---+---+
| a |   |   |
+---+---+---+
| 1 |   |   |
| 3 | a | c |
+---+---+---+
2 rows in set. Query took 0.020 seconds.

❯ WITH RECURSIVE my_cte AS (
    SELECT 1 AS a
    UNION ALL
    SELECT 'abc' FROM my_cte WHERE CAST(a AS text) !='abc'
) SELECT * FROM my_cte;
+-----+
| a   |
+-----+
| 1   |
| abc |
+-----+
2 rows in set. Query took 0.012 seconds.