Boolean logic is failing using JSON_EXTRACT function with multiple RECURSIVE CTE's

CREATE OR REPLACE FUNCTION bug_demo() 

RETURNS BOOL CONTAINS SQL DETERMINISTIC 

RETURN (WITH RECURSIVE cte1 AS (SELECT 0 AS num), 

cte2 AS (SELECT JSON_EXTRACT('[{"foo": "bar"}]', '$[0].foo') AS value FROM cte1), 

cte3 AS (SELECT value = '"bar"' AS baz FROM cte2) SELECT baz FROM cte3); 

SELECT bug_demo(), bug_demo(), bug_demo();

+------------+------------+------------+

| bug_demo() | bug_demo() | bug_demo() |

+------------+------------+------------+

|          1 |          0 |          0 |

+------------+------------+------------+