Comments (6)
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.
from dbitest.
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.
from dbitest.
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?
from dbitest.
Amazon RedShift has the same feature/limitation. We could add a tweak that defines transformations to column names, or use only lowercase column names.
from dbitest.
Closed in #243.
from dbitest.
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.
from dbitest.
Related Issues (20)
- Explicitly require inheritance from DBI classes
- all_args_have_default_values and NULL default parameters HOT 1
- dbListObjects() returns "table" as first column
- Why are column name encoding issues on Windows not picked up by the tests? HOT 1
- typo in has_completed_statement HOT 2
- `get_query_n_bad` should use named parameter to `dbGetQuery` HOT 2
- Handling of timestamps without time zones HOT 3
- Release DBItest 1.7.0 HOT 2
- Do not test mangling of column names HOT 1
- Eliminate use of with_connection({...}) and other with_...({...}) functions HOT 1
- as.character conversion expected to give full decimal representation but it does not HOT 3
- overwrite_missing_table spec should use iris_in instead of iris in dbWriteTable HOT 4
- Remove uses of expect_is() to support compatibility with testthat 3e HOT 4
- Test dbAppendTable() for 0-row tables on all backends
- Test RETURNING clause
- Test dbAppendTable() for Id objects
- DBItest causes warning on testthat 3rd edition (context() is deprecated) HOT 2
- Test dbDataType() for zero-length vectors
- Specify dbQuoteIdentifier() for incomplete Id()
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from dbitest.