[Libreoffice-bugs] [Bug 137801] New: LO base with Firebird: WARNING, when adding a field to a table of type BLOB

[bugzilla-daemon at bugs.documentfoundation.org]

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: libreoffice-bugs at lists.freedesktop.org
          Reporter: rich.libre at demattio.co.at

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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20201027/78642607/attachment.htm>