Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Regression: INSERT of non-lowercased columns fails in 5.5.0 #29

Open
gharris1727 opened this issue Mar 4, 2021 · 0 comments
Open

Regression: INSERT of non-lowercased columns fails in 5.5.0 #29

gharris1727 opened this issue Mar 4, 2021 · 0 comments

Comments

@gharris1727
Copy link

Version 5.5.0 includes this change: 67f9cfd which altered the addBatch function.

This causes all inserts with non-lowercased columns to fail. For example in omnisql, this sequence of statements succeeds:

CREATE TABLE test ( isCapitalized BOOLEAN NOT NULL );
INSERT INTO test ( isCapitalized ) VALUES ( 'true' );
SELECT isCapitalized FROM test ;
isCapitalized
true

I then executed these statements via the JDBC driver as part of a batched insert.
Expected behavior: the JDBC driver mimics the behavior of omnisql, and the insert is successful.
Actual behavior: the JDBC driver throws this exception:

java.sql.SQLException: Column isCapitalized does not exist
	at com.omnisci.jdbc.OmniSciPreparedStatement.addBatch(OmniSciPreparedStatement.java:394)
	...

I confirmed that all prior versions 4.7.1-5.4.0 can successfully execute this insert, and the regression is only present in 5.5.0.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant