[Libreoffice-bugs] [Bug 112491] SDBC-mismatch on alter field-properties in embedded Firebird database when editing primary key

[bugzilla-daemon at bugs.documentfoundation.org]

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

Drew Jensen <drewjensen.inbox at gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|RESOLVED                    |NEW
         Resolution|INSUFFICIENTDATA            |---

--- Comment #7 from Drew Jensen <drewjensen.inbox at gmail.com> ---
Reopening this.  

Alex Thurgood had no problem recreating it. Who cares if the error message is a
bit different, the fact remains the code is broken in every build of Base right
up to the first drop, yesterday, of the binaries for 6.2 Alpha0.

It shouldn't be up to the user to post an example for something this simple,
and obviously wrong, in fact the fact it is in the wild for so long calls the
entire QA process (and the commitment of TDF to produce a quality product) into
question.

As for the difference in error messages - if anyone had tried for real that is
really easy to understand.

With the HSQLdb engine data changes actually are written to DISC. // pause here
for a second

OK, now here is what happened. Since the system had to DROP and then ADD the
column back and since that can't be run as a single transaction the DROP column
worked, the ADD column failed.

After clearing the error message box the Table Editor is now displaying a
layout for the table that DOES NOT match the table on disc (for firebird it is
the table in memory and here that is going to come in handy).

OK - so you try to close the table editor an guess what it prompts the user to
save the table design again - if the user says yes a different error is
triggered, it is the error reported by the OP in this issue.

If the ODB used HSQLdb that is it, the table has been altered by dropping the
column and it must be added back by the user - in the case of firebird just
don't save the file and the change is discarded, along with an other changes
like data added to different tables and such (all would be lost).

-- 
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/20180525/15efd8a1/attachment.html>