[Libreoffice-bugs] [Bug 137042] SQL Error -607, when changing Field type of a table (Firebird)

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #13 from Julien Nabet <serval2412 at yahoo.fr> ---
(In reply to Richard Demattio from comment #12)
> ...
> Maybe you tried to execute all the SQL statements  in one step.
> This does not work!
> ...
Thank you for your feedback but I did try one by one and it failed for me.

Anyway, I gave a try with your DB and tested from
"
    - now I entered design mode again by "<right klick> / Edit"
      - and set "Entry required" to "YES"
      - and klicked the save icon for the table
~~~~~~~~~~~~~~~~~~~~~~~      
I got the Warning: "The column "Unit" could not be changed. 
                    Should the column be deleted and the new format appended?"
and on "More" I got the additional information:
Error code: 1

firebird_sdbc error:
*UPDATE operation is not allowed for system table RDB$RELATION_FIELDS
caused by
'UPDATE RDB$RELATION_FIELDS SET RDB$NULL_FLAG = 1 WHERE RDB$FIELD_NAME = 'Unit'
AND RDB$RELATION_NAME = 'BUG137042''

/tinderbox/buildslave/source/libo-70/connectivity/source/drivers/firebird/Util.cxx:68
=> OK, I got the same

then:
I said "yes" to the warning message
but got:
*Cannot make field Unit of table BUG137042 NOT NULL because there are NULLs
present
caused by
'ALTER TABLE "BUG137042" ADD "Unit" VARCHAR(5) NOT NULL'

I think the change of message is due to some recent commits on I did master
sources.
About this new problem, it seems LO is stucked because it removed a column
where there was a value but when trying to add the column, it has no value
whereas it's required.
I don't know how and even if it can be fixed.

-- 
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/20201103/15cef031/attachment-0001.htm>