https://bugs.documentfoundation.org/show_bug.cgi?id=145552
Bug ID: 145552
Summary: Unable to copy a table with a photo column from a Base
HSQLDB embedded database to a Base database connected
to MySQL.
Product: LibreOffice
Version: 7.2.2.2 release
Hardware: All
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Base
Assignee: [email protected]
Reporter: [email protected]
Description:
When trying to copy a table with a photo column from an embedded database into
a MySQL directly connected database, an error message appears : No
corresponding column type could be found for column 'Photo'.
Steps to Reproduce:
1. Open Base and create a new database (embedded HSQLDB)
2. Use Wizard to Create Table
3. category : Business / Sample Tables : Employees
4. select fields : LastName and Photo
5. Set type and formats : click Next
6. Set primary key : Automatically add a primary key / check AutoValue
7. click Finish
8. Open Base and connect to an existing database : MySQL / connect directly
9. Setup a connection to a MySQL database (database name and server/port). As
an example, use the sample MySQL database name sakila
10. Copy/Paste the table from the embedded Base to the MySQL connected Base.
Actual Results:
Error message : No corresponding column type could be found for column
'Photo'.
Expected Results:
I expect the table Employees to be copied into the MySQL connected Base.
Reproducible: Always
User Profile Reset: No
Additional Info:
It seems that Base does not support fields defined as "photo" in the Table
creation Wizard (appearing as image(logvarbin)) when the backend database is
MySQL.
--
You are receiving this mail because:
You are the assignee for the bug.
