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

[SqlLite] munit check fails on insert, but works on select #1782

Open
benkio opened this issue Nov 24, 2022 · 0 comments
Open

[SqlLite] munit check fails on insert, but works on select #1782

benkio opened this issue Nov 24, 2022 · 0 comments

Comments

@benkio
Copy link

benkio commented Nov 24, 2022

Hi,
I created a simple project to reproduce the error. Just run test to see the problem
doobiesqlite.tar.gz

I have a simple table with just a column of type BIGINT and a case class with a Long field
When I check the SELECT it works fine, but the INSERT fails with

  INSERT INTO test VALUES (?)
  ✓ SQL Compiles and TypeChecks
  ✕ P01 Long  →  VARCHAR (VARCHAR)
    Long is not coercible to VARCHAR (VARCHAR) according to the JDBC
    specification. Expected schema type was BIGINT.

It seems that the BIGINT turn out to be a VARCHAR for some reason.

PS Sqllite doesn't have BIGINT, but it's automatically mapped to INTEGER

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