[Libreoffice-bugs] [Bug 141821] New: Lacks some features when pasting table object 'copy table'

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=141821

            Bug ID: 141821
           Summary: Lacks some features when pasting table object 'copy
                    table'
           Product: LibreOffice
           Version: 7.1.2.2 release
          Hardware: All
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: enhancement
          Priority: medium
         Component: Base
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: ludwigdiehl at gmail.com

Description:
If you try to copy a table object from one database (spreadsheet for instance)
to a another database (mysql databse for instance), it would be a lot easier if
the field type could be set for a group of fields instead of each one,
specially if the table has many fields. Besides, by default "Text [ENUM]" type
is selected automatically for text data, however, it never works for Mysql,
instead you should select "Memo [Text]" type for it to work. I suggest all
fields are set to Memo [Text] by default. Finally, it would be great if error
report had more details.

Steps to Reproduce:
1.right click on a table object (from a spreadsheet)
2.click "copy"
3.right click on another database(mysql)
4.click Paste (definition and data) on the selected database
5.click button to add all fields
6.click "Next"
7.click "create"

Actual Results:
You have an error in your SQL syntax; check the manual that corresponds to your
MariaDB server version for the right syntax to use near '"Abreviado"
ENUM,"DESCRIPCION" ENUM,"PIA" ENUM,"PIM" ENUM,"NIVEL" DECIMAL,"EN...' at line 1
/home/abuild/rpmbuild/BUILD/libreoffice-7.1.1.2/connectivity/source/drivers/mysqlc/mysqlc_general.cxx:119

Expected Results:
Created the table correctly.


Reproducible: Always


User Profile Reset: No



Additional Info:
Version: 7.1.1.2 / LibreOffice Community
Build ID: 10(Build:2)
CPU threads: 2; OS: Linux 5.3; UI render: default; VCL: kf5
Locale: en-US (en_US.UTF-8); UI: en-US
Calc: threaded

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210422/254c9ecb/attachment.htm>