[Libreoffice-bugs] [Bug 137042] SQL Error -607, when changing Field type of a table (Firebird)
bugzilla-daemon at bugs.documentfoundation.org
bugzilla-daemon at bugs.documentfoundation.org
Sat Oct 17 20:48:04 UTC 2020
https://bugs.documentfoundation.org/show_bug.cgi?id=137042
--- Comment #1 from Richard Demattio <rich.libre at demattio.co.at> ---
I testesd this time with LO 7.1.1.0,
Build
https://gerrit.libreoffice.org/gitweb?p=core.git;a=log;h=17cbc559be6936777904e5cf8a517cac89045264
I could not reproduce the message "SQL_BOOLEAN does not exist" with the daily
build, but I could reproduce a crash this time, when I tried to change the
type..
TESTCASE: based on a table with two fields I did the following in design view:
1.) Add new field "test1" VARCHAR
2.) add new field "Test2" INTEGER
3.) change Type of "test1" to BOOLEAN
Error code: 1
firebird_sdbc error:
*unsuccessful metadata update
*ALTER TABLE tla_Kontaktarten failed
*action cancelled by trigger (1) to preserve data integrity
*Cannot update index segment used by an Integrity Constraint
caused by
'ALTER TABLE "tla_Kontaktarten" ALTER COLUMN "Typ" TYPE BOOLEAN'
/tinderbox/buildslave/source/libo-master/connectivity/source/drivers/firebird/Util.cxx:68
4.) I confirmed (nevertheless)
The change happened, although the errormessage said, it failed
5.) I again changed "test1" back to VARCHAR
... CRASH (two times ... reproducable)
--
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/20201017/e87f782b/attachment.htm>
More information about the Libreoffice-bugs
mailing list