Bug #106406 import csv with comma as decimal separator truncate the numbers
Submitted: 8 Feb 2022 13:45 Modified: 26 Mar 8:46
Reporter: Valerio Messina Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Workbench Severity:S1 (Critical)
Version:8.0.41 OS:Any
Assigned to: CPU Architecture:Any
Tags: data loss

File: Maximum allowed size is 50MB.
Description:
Privacy:

If the data you need to attach is more than 50MB, you should create a compressed archive of the data, split it to 50MB chunks, and upload each of them as a separate attachment.

To split a large file:

[8 Feb 2022 13:47] Valerio Messina
the field separator does not matter

Attachment: MySQL_Workbench_8.0.28_import.png (image/png, text), 16.03 KiB.

[9 Feb 2022 16:15] Valerio Messina
here the table definition with three field defined as DOUBLE

Attachment: MySQL_Workbench_8.0.28_tableDef.png (image/png, text), 157.43 KiB.

[9 Feb 2022 16:20] Valerio Messina
an example of CSV using comma as decimal separator

Attachment: DB_PSA_ANSI_lite.csv.7z (application/octet-stream, text), 550 bytes.

[10 Feb 2022 13:20] Ashwini Patil
8.0.28 test results

Attachment: 106406_test_results.PNG (image/png, text), 98.79 KiB.

[10 Feb 2022 17:18] Valerio Messina
Import dialog

Attachment: MySQL_Workbench_8.0.28_decimalImport1.png (image/png, text), 25.30 KiB.

[10 Feb 2022 17:18] Valerio Messina
Import dialog

Attachment: MySQL_Workbench_8.0.28_decimalImport0.png (image/png, text), 17.79 KiB.

[10 Feb 2022 18:04] Valerio Messina
about dialog

Attachment: MySQL_Workbench_8.0.28_about.png (image/png, text), 18.02 KiB.

[10 Feb 2022 18:17] Valerio Messina
here the result of the import, ID changed to 3904/5 to keep near

Attachment: MySQL_Workbench_8.0.28_decimalImport2.png (image/png, text), 99.48 KiB.