allurefx commented on issue #18101: URL: https://github.com/apache/datafusion/issues/18101#issuecomment-3417752313
Actually, this turned out to be related to the global normalization flag. After the select with alias failed, I tried DataFrame::with_column_renamed() and had the same issue. Basically, the problem was with column case. E.g., as part of the renaming I was trying to change names like Age to age, but this was getting ignored because the sql_parser.enable_ident_normalization = true by default apparently and that was treating Age and age the same and was consequently ignoring the name change request. That was causing queries with "age" to fail because the saved name was still "Age." Setting sql_parser.enable_ident_normalization = false fixed the issue. My suggestion is to not silently ignore with NOOP behavior in cases like this because it could be hard to pin down. -- 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]
