TablePlus-Linux icon indicating copy to clipboard operation
TablePlus-Linux copied to clipboard

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

Open johnpharmetika opened this issue 1 year ago • 0 comments

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.

johnpharmetika avatar Jun 08 '24 17:06 johnpharmetika