https://bugs.freedesktop.org/show_bug.cgi?id=82372
Priority: medium
Bug ID: 82372
Assignee: [email protected]
Summary: Base: Query builder deletes columns not visible that
do not have constraint (unexpected loss of data)
Severity: major
Classification: Unclassified
OS: All
Reporter: [email protected]
Hardware: Other
Status: UNCONFIRMED
Version: 4.3.0.4 release
Component: Database
Product: LibreOffice
Created attachment 104322
--> https://bugs.freedesktop.org/attachment.cgi?id=104322&action=edit
this is a screen shot showing what will be saved and what will be lost
This bug probably is a functionality that has adverse implications not
considered. In query builder, can make column not visible by checking box on
grid. See screen shot. Bug: when the box is not checked and the query is
saved, the column is deleted on close. This leads to unexpected data loss.
The typical use case is the query just has a table column, so no real loss,
however the query also can contain formulas; if user wants to delete the
formula, can decide to do that deliberately. Making column not visible and
closing query builder leads to nonobvious deletion and data loss.
1. Create query.
2. Add fields.
3. Make one or more fields not visible by unchecking box.
4. Save and close.
5. On reopen, columns will be gone, including any formulas.
Expected functionality: on reopen, formulas will be available to be made
visible again without re-drafting.
Consider adding a warning when columns are made not visible and the query plan
will cause deletion of that information/column on close.
P.S. test document will just have missing columns.
P.P.S.: I believe this bug may be connected to application instability,
failure to close normally, but cannot reliably reproduce application
instability.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
