bug: result of querying a value from an empty derived table have select case is not consistent with innodb

[adofsauron]

Have you read the Contributing Guidelines on issues?

• I have read the Contributing Guidelines on issues.

Please confirm if bug report does NOT exists already ?

• I confirm there is no existing issue for this

Describe the problem

Expected behavior

No response

How To Reproduce

No response

Environment

No response

Are you interested in submitting a PR to solve the problem?

• Yes, I will!

[adofsauron]

CASE
    ->                CASE
    ->                  WHEN r.row_id IS NOT NULL THEN
    ->                   r.exchange_rate
    ->                  ELSE
    ->                   1.0000
    ->                END AS exchange_rate,

[adofsauron]

create table t1 (age int) ;

select  1 age,  sum(age) from (  select * from t1) ta;

[adofsauron]

ACK

[adofsauron]

在innodb引擎中的结果

+------------+---------------+---------+-------------+
| inner_code | exchange_rate | balance | std_balance |
+------------+---------------+---------+-------------+
| aaaaa      |    1.00000000 |    NULL | b           |
+------------+---------------+---------+-------------+

在tianmu引擎中的结果

+------------+---------------+---------+-------------+
| inner_code | exchange_rate | balance | std_balance |
+------------+---------------+---------+-------------+
| aaaaa      |          NULL |    NULL | b           |
+------------+---------------+---------+-------------+

[adofsauron]

客户POC的查询错误已修复, 做完边界性测试和自动化测试再提交代码

[adofsauron]

修复完了就关了