Elsa

Results 28 comments of Elsa

preprocessor, planner: inline processing by default for single-consumer cte

/run-mysql-test tidb-test=pr/1976

preprocessor, planner: inline processing by default for single-consumer cte

/run-mysql-test tidb-test=pr/1976

preprocessor, planner: inline processing by default for single-consumer cte

/run-mysql-test tidb-test=pr/1976

preprocessor, planner: inline processing by default for single-consumer cte

/run-mysql-test tidb-test=pr/1976

preprocessor, planner: inline processing by default for single-consumer cte

/run-mysql-test tidb-test=pr/1976

The results of condition = and <= have no implication to each other

The

The results of condition = and <= have no implication to each other

# Reproduce step ``` mysql> create table table_3_utf8_undef (`col_char(20)_key_signed` char(20)); Query OK, 0 rows affected (0.09 sec) mysql> insert into table_3_utf8_undef values ('1'); Query OK, 1 row affected (0.01 sec)...

The results of condition = and <= have no implication to each other

Still have the same problem in v6.5 ``` mysql> SELECT `col_double_key_signed` FROM `table_7_utf8_undef` WHERE( (-col_double_key_signed) SELECT `col_double_key_signed` FROM `table_7_utf8_undef` WHERE( (-col_double_key_signed) =ANY(SELECT `col_char(20)_key_signed` FROM `table_3_utf8_undef`)) ; +-----------------------+ | col_double_key_signed |...

Optimizer: Refactor and simplify outer to inner join conversion rule #50971

/test mysql-test

Optimizer: Refactor and simplify outer to inner join conversion rule #50971

BTW, your linked issue is incorrect. Could you please link a correct issue? If there is no related issue, it will better to create a new issue for this PR...