dbeaver / dbeaver/dbeaver

Import CSV - Error no integer size determination

Open
#11,767 4 comments 0 reactions 3 assignees Claimed by @E1izabeth View on GitHub
sp:2 xf:datatransfer
Dominant language
Java
Stars
51.8k
Forks
4.4k
Avg merge
3d 8h
Merged PRs (30d)
188

Description

Hello everyone,

It looks like the size of integer fields are not auto determined as the size of varchar filed is, the default integer size is used which can lead to issue during import.
Attached a file containing csv data lead to an issue while using csv import functionality.

I'm using SQLServer as SGBD.

[test.log](https://github.com/dbeaver/dbeaver/files/6157235/test.log)

![image](https://user-images.githubusercontent.com/3603542/111486897-2d212f80-8738-11eb-82fd-1e2e3b7513e4.png)

This error happened

Data transfer failed during batch insert
(you can disable batch insert in order to skip particular rows).

Reason:
SQL Error [8115] [S0002]: Une erreur de dépassement arithmétique s'est produite lors de la conversion de expression en type de données int.

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.