[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 #4 from Richard Demattio <rich.libre at demattio.co.at> ---
(In reply to Robert Großkopf from comment #3)
> First this error appears when changing Boolean field to Varchar:
> Conversion from base type BOOLEAN to VARCHAR is not supported.
> 
> When I confirm to delete the old Boolean field and add a new Varchar field
> it will work here. So I could not confirm the buggy behavior.
> 
> Tested with LO 7.0.2.2 on OpenSUSE 15.1 64bit rpm Linux

I agree - it is stupid, changing VARCHAR to BOOLEAN and the other way round.
Your way makes more sense.

But what I did must not lead to a crash, but should be prohibited by logic.
In general: rejecting forbidden conversions by logic will increase stability.

Such kind of inputs can happen accidentally.

-- 
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/20201018/592f47a3/attachment-0001.htm>