Re: [D] Camel case column name in sql query being automatically set to lowercase [datafusion]

["SanjayKondapalli (via GitHub)" <gi...@apache.org>]

GitHub user SanjayKondapalli closed a discussion: Camel case column name in sql query being automatically set to lowercase

I've noticed that the column names in sql queries get automatically set in lower case. For example, testId becomes testid. This is causing some issues with the sql query executing on the data. 

Ex error msg: SchemaError(FieldNotFound { field: Column { relation: None, name: "testid"}, valid_fields" [Column { relation: Some(Bare{ table: "tableName" }), name: "testId"}] })

Is there some sort of option that can turn this off or is this a bug? I noticed that there's a config option datafusion.sql_parser.enable_ident_normalization, but I'm unsure what this does. Any help would be greatly appreciated!

GitHub link: https://github.com/apache/datafusion/discussions/6187

----
This is an automatically sent email for github@datafusion.apache.org.
To unsubscribe, please send an email to: github-unsubscribe@datafusion.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: github-unsubscribe@datafusion.apache.org
For additional commands, e-mail: github-help@datafusion.apache.org