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

Bug importing csv - values changed during import #3467

Open
ik8sqi opened this Issue Dec 5, 2018 · 0 comments

Comments

2 participants
@ik8sqi

ik8sqi commented Dec 5, 2018

Details

Import the file attached. There are no errors reported, but the data is being changed during the import. Look for example at the line in the .csv:
2999998464,3000000511,2017370,2017370,,0,0

after importing, that line is not present in the database. You have instead dropped the first digit "2" resulting in this modified record being imported:
999998464,3000000511,2017370,2017370,,0,0

The issue only occurs when importing the .csv as a whole - hundreds of thousands of rows are imported with incorrect values. If instead I try to import a .csv containing only that one single line with the 2999998464, it gets imported correctly.

Steps to reproduce

Import this .csv into a sqlite database.

Operating system

macOS Mojave 10.14.1

SQLiteStudio version

3.2.1

geoip.zip

@pawelsalawa pawelsalawa added the bug label Dec 5, 2018

@pawelsalawa pawelsalawa added this to the 3.2.2 milestone Dec 5, 2018

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment