[Libreoffice-bugs] [Bug 131295] New: Error while saving the table design

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 131295
           Summary: Error while saving the table design
           Product: LibreOffice
           Version: 6.2.8.2 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Base
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: damian.hofmann at gmx.ch

================================================================
Error code: 1

firebird_sdbc error:
*unsuccessful metadata update
*ALTER TABLE test failed
*SQL error code = -607
*Invalid command
*Specified domain or source column SQL_INT64 does not exist
caused by
'ALTER TABLE "test" ADD "name" SQL_INT64'
================================================================


Steps to reproduce:

1. in LO Base
2. create a table 'test' with an INTEGER column 'id' (primary key) and a
NUMERIC (sic) column 'name'
3. Save and exit the table designer
4. Open table again in the table designer
5. Change "Field Type" for 'name' from NUMERIC to VARCHAR
6. "Save"
7. Confirm "The column "name" could not be changed. Should the column instead
be deleted and the new format appended?"

Result:

The error above occurs. Note how the error massage says, that it tried to add a
column of type SQL_INT64, but VARCHAR was selected by the user for the new
column type.

Secondary finding: After the error, the column 'name' doesn't exist anymore. It
apparently has been dropped. AFAIK, Firebird supports transactional DDL.
Therefore, if an error occurs, I'd expect the database to be rolled back to
it's original state. 



Tested with firebird. Not tested with HSQLDB.


About LibreOffice
Version: 6.2.8.2 (x64)
Build ID: f82ddfca21ebc1e222a662a32b25c0c9d20169ee
CPU threads: 8; OS: Windows 10.0; UI render: GL; VCL: win; 
Locale: de-CH (de_CH); UI-Language: en-US

-- 
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/20200311/762b733f/attachment.htm>