[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

Julien Nabet <serval2412 at yahoo.fr> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |serval2412 at yahoo.fr

--- Comment #7 from Julien Nabet <serval2412 at yahoo.fr> ---
On pc Debian x86-64 with master sources updated today, here what I got with an
embedded Firebird:
- I create a table with "id"/INTEGER as primary key + "f1" as BOOLEAN field
- save + quit editing
=> OK
- reopen to edit the table and change BOOLEAN to VARCHAR + click save (arrow
icon at the left)
=> message: "the column "f1" could not be changed. Should the column instead be
deleted and the new format appended?
Console logs show:
warn:connectivity.firebird:15955:15955:connectivity/source/drivers/firebird/Statement.cxx:114:
isc_dsql_execute failed
warn:connectivity.firebird:15955:15955:connectivity/source/drivers/firebird/Util.cxx:57:
firebird_sdbc error:
*unsuccessful metadata update
*ALTER TABLE Table3 failed
*Cannot change datatype for f1.  Conversion from base type BOOLEAN to VARCHAR
is not supported.
caused by
'ALTER TABLE "Table3" ALTER COLUMN "f1" TYPE VARCHAR(100)'

- click Yes
=> UI shows back BOOLEAN instead of VARCHAR
- click Save icon + quit editing
- editing again, the field shows now VARCHAR (!!)

So for me no crash but a pb of UI refresh, it shouldn't display "BOOLEAN" just
before final editing quit.

-- 
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/20201101/baee3c41/attachment.htm>