https://bugs.documentfoundation.org/show_bug.cgi?id=137801
Bug ID: 137801
Summary: LO base with Firebird: WARNING, when adding a field to
a table of type BLOB
Product: LibreOffice
Version: 7.1.0.0.alpha0+ Master
Hardware: All
OS: Linux (All)
Status: UNCONFIRMED
Severity: minor
Priority: medium
Component: Base
Assignee: [email protected]
Reporter: [email protected]
Description:
in design mode: adding a field (no matter of what type) to a table with a BLOB
field produces a WARNING about the existing BLOB field.
It is possible to initially create the table with the BLOB field in design
mode.
Steps to Reproduce:
1. create a simple table with some fields (I took two)
and save the table and the database
2. add a BLOB field and save the table and the database again
(in my testcase it was the third field "f3")
3. add another field, no matter of what type (in my case it was field "f4")
~~~~~~~~~~~~~~~~~~~~~~~~~~~+
--> the warning comes about the THIRD field, not the newly added one!
keep in mind: I did not try to change the datatype although the error message
below is saying this.
Actual Results:
Error code: 1
firebird_sdbc error:
*unsuccessful metadata update
*ALTER TABLE Table1 failed
*Cannot change datatype for column f3. Changing datatype is not supported for
BLOB or ARRAY columns.
caused by
'ALTER TABLE "Table1" ALTER COLUMN "f3" TYPE BLOB'
/tinderbox/buildslave/source/libo-master/connectivity/source/drivers/firebird/Util.cxx:68
Expected Results:
no warning
Reproducible: Always
User Profile Reset: No
Additional Info:
reproduced also on LO 7.0.3.1
https://gerrit.libreoffice.org/gitweb?p=core.git;a=log;h=d7547858d014d4cf69878db179d326fc3483e082
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
