As same as the UNIQUE sub-query, before we convert the sub-query to RelNode. we use the Metadata to optimize it.
EXISTS sub-query, If the sub-query is guaranteed to produce at least one row, just return TRUE. If the sub-query is guaranteed to produce no row, just return FALSE.
We can optimize it to: