xiedeyantu commented on PR #21236: URL: https://github.com/apache/datafusion/pull/21236#issuecomment-4182443965
> `ORDER BY` still drops the ambiguity marker when it falls back from the select-list schema to the underlying FROM schema. `order_by_to_sort_expr` clones the projected schema and then calls DFSchema::merge, but merge still never unions other_schema.ambiguous_names > > For example: > > ``` > SELECT score > FROM (SELECT * FROM t_left JOIN t_right ON t_left.id = t_right.id) sub > ORDER BY age; > ``` @xudong963 Thanks! I have fixed this issue via commit [5ab14b2](https://github.com/apache/datafusion/pull/21236/commits/5ab14b298f715615b280bd8cda7c7d2785b67f1b). -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
