[Bug] set enable_projection to false will cause select stmt analyze failed

[caiconghui]

Search before asking

• [X] I had searched in the issues and found no similar issues.

Version

master and lts

What's Wrong?

set enable_projection=false; select count() from (select a, b from table001 order by b limit 1) a

then throw exception like the following ERROR 1105 (HY000): errCode = 2, detailMessage = couldn't resolve slot descriptor 0

What You Expected?

work

How to Reproduce?

No response

Anything Else?

No response

Are you willing to submit PR?

• [ ] Yes I am willing to submit a PR!

Code of Conduct

• [X] I agree to follow this project's Code of Conduct

[caiconghui]

mysql> show columns from baseall; +-------+----------------+------+-------+---------+---------+ | Field | Type | Null | Key | Default | Extra | +-------+----------------+------+-------+---------+---------+ | k0 | BOOLEAN | Yes | true | NULL | | | k1 | TINYINT | Yes | true | NULL | | | k2 | SMALLINT | Yes | true | NULL | | | k3 | INT | Yes | true | NULL | | | k4 | BIGINT | Yes | true | NULL | | | k5 | DECIMAL(9,3) | Yes | true | NULL | | | k6 | CHAR(5) | Yes | true | NULL | | | k10 | DATE | Yes | true | NULL | | | k11 | DATETIME | Yes | true | NULL | | | k7 | VARCHAR(20) | Yes | true | NULL | | | k8 | DOUBLE | Yes | false | NULL | MAX | | k9 | FLOAT | Yes | false | NULL | SUM | | k12 | VARCHAR(65533) | Yes | false | NULL | REPLACE | | k13 | LARGEINT | Yes | false | NULL | REPLACE | +-------+----------------+-----

select count() from (select k0, k1 from baseall order by k1 limit 1) a