🪲 random appears to be evaluated once

[joocer]

was seeing what happens for opteryx for https://buttondown.email/jaffray/archive/the-case-of-a-curious-sql-query/

SELECT count(*) 
FROM GENERATE_SERIES(1000) AS one_thousand 
CROSS JOIN GENERATE_SERIES(1000) AS one_thousand_b 
WHERE random() < 0.5

AFTER COST OPTIMIZATION
└─ EXIT
   └─ PROJECT (COUNT(*))
      └─ AGGREGATE (COUNT(*))
         └─ FILTER (False)
            └─ CROSS JOIN
               ├─ GENERATE SERIES (1000) AS one_thousand
               └─ GENERATE SERIES (1000) AS one_thousand_b