[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 #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>