Bug #120067 Faulty workbench scheme display

• Submitted: 15 Mar 14:20
• Reporter: Nick Cole
• Status: Open
• Category: MySQL Workbench
• Severity: S7 (Test Cases)
• Version: 8.0.46
• OS: Windows (Microsoft Windows 11)
• CPU Architecture: Any
• Tags: WBBugReporter

[15 Mar 14:20] Nick Cole

Description:
----[For better reports, please attach the log file after submitting. You can find it in C:\Users\nscni\AppData\Roaming\MySQL\Workbench\log\wb.log]
Selected the schema to import to, but the table shown in the schema is not part of the import dropdown.  Imported file is csv, to preload the database, but it reports Error 1, error in my(?) SQl code.  The code is generated by the workbench routine.  

Running: mysql.exe --defaults-file="C:\Users\nscni\AppData\Local\Temp\tmp7_hdnhz3.cnf"  --protocol=tcp --host=127.0.0.1 --user=nick --port=3306 --default-character-set=utf8 --comments --database=nextsteps  < "C:\\DATA\\MySQL\\MySQL Server 8.0\\Data\\nextsteps\\members.csv"
ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '3,NXXXXX,CXXX,00/00/1900,f,08/03/2012,34 Lilybank Terrace,,DXXXXX,DD,00000 00000' at line 1

How to repeat:
Logged in to user account.  Selected and connected to the database.  Schema and and queries operate fine.  Go to Data Import to preload table.  Fields exactly the same as csv file.  No headings just the data.  Start import, fails with error 1.  Data redacted in description.

Suggested fix:
IMPROVE diagnostics so they mean something.  Explain specific terms like 'self-contained file', 'dump file', 'schema objects', etc.  That way we can help ourselves.