Missed optimization opportunities of "FALSE and any_expr"

-- Create table t1 with 1 row and t2 with 10,000,000 rows

CREATE TABLE t1(c0 INT8);

CREATE TABLE t2(c0 INT8);

INSERT INTO t1 VALUES(1);

INSERT INTO t2 SELECT seq FROM seq_1_to_10000000;

-- The optimizer can rewrite such a SQL statement to "SELECT FALSE" directly

SELECT false AND (SELECT MIN(c0) FROM t2)<0;

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

| false AND (SELECT MIN(c0) FROM t2)<0 |

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

|                                    0 |

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

1 row in set (0.002 sec)

SELECT (SELECT MIN(c0) FROM t2)<0 AND false;

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

| (SELECT MIN(c0) FROM t2)<0 AND false |

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

|                                    0 |

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

1 row in set (1.793 sec)

-- The executor can short-circuit when determining that one expression is false after scanning one table, and skip scanning another table.

SELECT (SELECT MIN(c0) FROM t1)<0 AND (SELECT MIN(c0) FROM t2)<0;

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

| (SELECT MIN(c0) FROM t1)<0 AND (SELECT MIN(c0) FROM t2)<0 |

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

|                                                         0 |

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

1 row in set (0.016 sec)

SELECT (SELECT MIN(c0) FROM t2)>0 AND (SELECT MIN(c0) FROM t1)<0;

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

| (SELECT MIN(c0) FROM t2)>0 AND (SELECT MIN(c0) FROM t1)<0 |

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

|                                                         0 |

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

1 row in set (1.657 sec)