Make Column Names Comparison Case Insensitive

[adamsma]

My database transforms all column names to lower case. This causes a failure when comparing to generated tables with upper case letters, i.e. iris dataset. I'm not sure how this affects all the other tests but options could be:

1. in get_iris change all columns to lower case
   names(datasets_iris) <- tolower(names(datasets_iris))
2. make similar transformation to lower case for all data.frame comparisons
3. use testthat::expected_equivalent which ignores attributes
4. allow for tweak that makes column names lower case

[krlmlr]

Thanks for raising this. What database are you using?

The most straightforward way would be to use lowercase column names as a rule, and have one or two tests for case preservation, which would be omitted/skipped in your case.

[adamsma]

I'm interfacing with Trino. Ultimately, the data is stored in AWS S3, but I believe it's Trino that imposes this requirement. Currently, my workaround is I've added a trace within my test setup that adds option 1.

[krlmlr]

Thanks, interesting. Are you using odbc to interface with Trino? What's the easiest way to get access to, or deploy, an installation of Trino for testing?

This looks related to #155, can you confirm?

[krlmlr]

Amazon RedShift has the same feature/limitation. We could add a tweak that defines transformations to column names, or use only lowercase column names.

[krlmlr]

Closed in #243.

[github-actions]

This old thread has been automatically locked. If you think you have found something related to this, please open a new issue and link to this old issue if necessary.