[Libreoffice-bugs] [Bug 137042] New: SQL Error -607, when changing Field type of a table

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 137042
           Summary: SQL Error -607, when changing Field type of a table
           Product: LibreOffice
           Version: 7.0.1.2 release
          Hardware: x86-64 (AMD64)
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Base
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: rich.libre at demattio.co.at

Description:
I tried to change a previously defined boolean type column to varchar(30) and
got the error "SQL_BOOLEAN does not exist".


Steps to Reproduce:
1.I tried to change the field type of a table column from BOOLEAN to
VARCHAR(30)
2.I was asked to confirm, that the column will be deleted and readded as new
type
3.I confirmed and got an error message: - see below

Actual Results:
Errormessage:
firebird_sdbc error:
*unsuccessful metadata update
*ALTER TABLE tlg_Nutzbarkeit failed
*SQL error code = -607
*Invalid command
*Specified domain or source column SQL_BOOLEAN does not exist
caused by
'ALTER TABLE "tlg_Nutzbarkeit" ADD "frei" SQL_BOOLEAN'

/home/buildslave/source/libo-core/connectivity/source/drivers/firebird/Util.cxx:68

Expected Results:
it should work.



Reproducible: Always


User Profile Reset: No


OpenGL enabled: Yes

Additional Info:
It is possible to select that "Yes/no[boolean]" type in the "table design
view".
(I did it this way earlier.)

Similar behaviour, when I tried to change a column type from other type to
varchar.

Changing via "SQL ALTER TABLE ..." works

-- 
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/20200926/2ab2352f/attachment-0001.htm>