search

TablePlus / TablePlus-Linux

TablePlus Linux issue tracker
https://tableplus.com
289 stars 30 forks source link

Importing .tsvs into a database table, empty values in the first column cause un-desired column squashing #205

Open johnpharmetika opened 1 month ago

johnpharmetika commented 1 month ago

Please answer the questions below, it helps us to track the issue.

  1. Database version (Ex: PostgreSQL 10.0): MySQL 8.4

  2. TablePlus version (the number on the welcome or about screen, Ex: build 81): 1.2.0 (254) (Trial)

  3. Linux distro (Ex: Ubuntu 18.04): Linux Mint 21.3

  4. The steps to reproduce this issue: See attached file (GitHub only supports uploading .csv, but the file is tab delineated). tsv_test2.csv

Log into your database, right click a table, choose Import from CSV, and try to load the attached file. Structure in LibreOffice: image

Structure in import screen: image

Notice the squashed data in row 2 and 3.