'common_sub_expression_eliminate' failed on unnested structs field

[ahirner]

Describe the bug

After filter pushdown in #10935 the optimizer does seem misunderstand struct fields.

To Reproduce

Create a table with a list of structs:

CREATE TABLE d AS VALUES(1,[named_struct('a', 1, 'b', 2)]),(2,[named_struct('a', 3, 'b', 4), named_struct('a', 5, 'b', 6)]);

Observe failure:

> select * from (select column1, unnest(column2) as o from d) where o['a'] = 1;
Optimizer rule 'common_sub_expression_eliminate' failed
caused by
Error during planning: The expression to get an indexed field is only valid for `List`, `Struct`, `Map` or `Null` types, got List(Field { name: "item", data_type: Struct([Field { name: "a", data_type: Int64, nullable: true, dict_id: 0, dict_is_ordered: false, metadata: {} }, Field { name: "b", data_type: Int64, nullable: true, dict_id: 0, dict_is_ordered: false, metadata: {} }]), nullable: true, dict_id: 0, dict_is_ordered: false, metadata: {} })

Expected behavior

> select * from (select column1, unnest(column2) as o from d) where o['a'] = 1;
+---------+--------------+
| column1 | o            |
+---------+--------------+
| 1       | {a: 1, b: 2} |
+---------+--------------+

Additional context

Maybe duplicate of #10989

[jayzhan211]

I believe it is the same issue of #10989 , but we can keep this opened until it is solved

[alamb]

I verified this test case works after #10991

sql
     Running `target/debug/datafusion-cli`
DataFusion CLI v39.0.0
> CREATE TABLE d AS VALUES(1,[named_struct('a', 1, 'b', 2)]),(2,[named_struct('a', 3, 'b', 4), named_struct('a', 5, 'b', 6)]);

0 row(s) fetched.
Elapsed 0.031 seconds.

> select * from (select column1, unnest(column2) as o from d) where o['a'] = 1;
+---------+--------------+
| column1 | o            |
+---------+--------------+
| 1       | {a: 1, b: 2} |
+---------+--------------+
1 row(s) fetched.
Elapsed 0.025 seconds.