[Libreoffice-bugs] [Bug 129261] New: EDITING Anomalies when saving records 1) Between fields of type CLOB and fields of other types; 2) Between empty fields and non-empty fields

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 129261
           Summary: EDITING Anomalies when saving records 1) Between
                    fields of type CLOB and fields of other types; 2)
                    Between empty fields and non-empty fields
           Product: LibreOffice
           Version: 6.3.3.2 release
          Hardware: x86-64 (AMD64)
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: minor
          Priority: medium
         Component: Base
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: ostersund18647 at gmail.com

PREPARATION
Create a new Firebird embedded BASE database.
Create Table "Table1" with 3 fields :-
Field1: Type Integer, AutoValue, Primary Key
Field2: Type TEXT
Field3: Type CLOB
Create Form "Form1" and set its Form Properties/Data as :-
Content type: Table
Content: Table1
Add Text Box "Text Box 1" to Form1 and set its Field Properties/Data as :-
Data field: Field2 
Add Text Box "Text Box 2" to Form1 and set its Field Properties/Data as :-
Data field: Field3
Display Form1 and use it to add a record containing "2" in Text Box 1, and "3"
in Text Box 2.
Save the record, close the database, then re-open it.

To demonstrate ANOMALY 1 :-
Open Form1, ensuring that the Form Navigation toolbar is visible. As should be
expected, Text Box 1 contains the value "2", Text Box 2 contains the value "3",
and the "Save Record" icon in the Form Navigation toolbar is greyed out.
Use the mouse to position the cursor pointer anywhere in Text Box 1 and
left-click without doing anything else. As is to be expected, the "Save Record"
icon in the Form Navigation toolbar remains greyed out.
Attempt to close the form. As should be expected, the form closes with no
warning message.
Re-open Form1, ensuring that the Form Navigation toolbar is visible. Text Box 1
still contains the value "2", Text Box 2 still contains the value "3", and the
"Save Record" icon in the Form Navigation toolbar is greyed out.
Use the mouse to position the cursor pointer anywhere in Text Box 2 and
left-click without doing anything else. As should be expected, the "Save
Record" icon in the Form Navigation toolbar remains greyed out.
Attempt to close the form. Unlike when positioning the cursor in Text Box 1, a
warning message is displayed, incorrectly stating that "The content of the
current form has been modified". This appears even though the "Save Record"
icon in the Form Navigation toolbar is greyed out. Select "No" to close the
form.

To demonstrate ANOMALY 2 :-
Re-open Form1, ensuring that the Form Navigation toolbar is visible. Text Box 1
still contains the value "2", Text Box 2 still contains the value "3", and the
"Save Record" icon in the Form Navigation toolbar is greyed out.
Modify the value in Text Box 1 from "2" to "2x". As should be expected, the
"Save Record" icon in the Form Navigation toolbar becomes highlighted.
Modify the value in Text Box 1 back from "2x" to "2". Ideally, the "Save
Record" icon in the Form Navigation toolbar should be greyed out again, but it
actually remains highlighted.
Attempt to close the form. The form closes with no warning message, even though
the "Save Record" icon was highlighted. 

To demonstrate ANOMALY 3 :-
Re-open Form1, ensuring that the Form Navigation toolbar is visible. Text Box 1
still contains the value "2", Text Box 2 still contains the value "3", and the
"Save Record" icon in the Form Navigation toolbar is greyed out.
Modify the value in Text Box 2 from "3" to "3x". As should be expected, the
"Save Record" icon in the Form Navigation toolbar becomes highlighted.
Modify the value in Text Box 1 back from "3x" to "3". Ideally, the "Save
Record" icon in the Form Navigation toolbar should be greyed out again, but it
actually remains highlighted.
Attempt to close the form. Unlike for ANOMALY 2, a warning message is
displayed, stating that "The content of the current form has been modified".
Select "No" to close the form.

To demonstrate ANOMALY 4 :-
Re-open Form1, ensuring that the Form Navigation toolbar is visible. Text Box 1
still contains the value "2", Text Box 2 still contains the value "3", and the
"Save Record" icon in the Form Navigation toolbar is greyed out.
Modify the value in Text Box 1 from "2" to "2x". As should be expected, the
"Save Record" icon in the Form Navigation toolbar becomes highlighted.
Click on the "Save Record" icon in the Form Navigation toolbar. As should be
expected, the "Save Record" icon becomes greyed out again. The assumption is
that the record has been successfully saved.
Attempt to close the form. As is to be expected, the form closes with no
warning message.
Re-open Form1, ensuring that the Form Navigation toolbar is visible. Text Box 1
now contains the value "2x", Text Box 2 still contains the value "3", and the
"Save Record" icon in the Form Navigation toolbar is greyed out. This verifies
that the previous Save was successful
Modify the value in Text Box 2 from "3" to "3x". As should be expected, the
"Save Record" icon in the Form Navigation toolbar becomes highlighted.
Click on the "Save Record" icon in the Form Navigation toolbar. As should be
expected, the "Save Record" icon becomes greyed out again. The assumption is
that the record has been successfully saved.
Attempt to close the form. Unlike when modifying the value in Text Box 1, a
warning message is displayed, incorrectly stating that "The content of the
current form has been modified". This appears even though the "Save Record"
icon in the Form Navigation toolbar is greyed out. Select "No" to close the
form.
Re-open Form1, ensuring that the Form Navigation toolbar is visible. Text Box 1
now contains the value "2x, Text Box 2 now contains the value "3x", and the
"Save Record" icon in the Form Navigation toolbar is greyed out. This verifies
that the previous Save was successful, even though responding "No". 

To demonstrate ANOMALY 5 :-
Clear the value in Text Box 1. As should be expected, the "Save Record" icon in
the Form Navigation toolbar becomes highlighted.
Click on the "Save Record" icon in the Form Navigation toolbar. As should be
expected, the "Save Record" icon becomes greyed out again. The assumption is
that the record has been successfully saved.
Attempt to close the form. As should be expected, the form closes with no
warning message.
Re-open Form1, ensuring that the Form Navigation toolbar is visible. Text Box 1
is now empty, Text Box 2 still contains the value "3x", and the "Save Record"
icon in the Form Navigation toolbar is greyed out. This verifies that the
previous Save was successful
Clear the value in Text Box 2. As should be expected, the "Save Record" icon in
the Form Navigation toolbar becomes highlighted.
Click on the "Save Record" icon in the Form Navigation toolbar. As should be
expected, the "Save Record" icon becomes greyed out again. The assumption is
that the record has been successfully saved.
Attempt to close the form. As should be expected, the form closes with no
warning message. However, this behaviour is different to that in Anomaly 4
Re-open Form1, ensuring that the Form Navigation toolbar is visible. Text Box 1
is now empty, Text Box 2 is now empty, and the "Save Record" icon in the Form
Navigation toolbar is greyed out. This verifies that the previous Save was
successful.

To demonstrate ANOMALY 6 :-
Use the mouse to position the cursor pointer anywhere in Text Box 1 and
left-click without doing anything else. As should be expected, the "Save
Record" icon in the Form Navigation toolbar remains greyed out.
Attempt to close the form. As should be expected, the form closes with no
warning message.
Re-open Form1, ensuring that the Form Navigation toolbar is visible. Text Box 1
is still empty, Text Box 2 is still empty, and the "Save Record" icon in the
Form Navigation toolbar is greyed out.
Use the mouse to position the cursor pointer anywhere in Text Box 2 and
left-click without doing anything else. As should be expected, the "Save
Record" icon in the Form Navigation toolbar remains greyed out.
Attempt to close the form. The form closes with no warning message. This is
actually as should be expected, but is inconsistent with behaviour for Anomaly
1. 

To demonstrate ANOMALY 7 :-
Re-open Form1, ensuring that the Form Navigation toolbar is visible. Text Box 1
is still empty, Text Box 2 is still empty, and the "Save Record" icon in the
Form Navigation toolbar is greyed out.
Set the value in Text Box 1 to "2x". As should be expected, the "Save Record"
icon in the Form Navigation toolbar becomes highlighted.
Clear the value in Text Box 1 again. Ideally, the "Save Record" icon in the
Form Navigation toolbar should be greyed out again, but it actually remains
highlighted.
Attempt to close the form. The form closes with no warning message, even though
the "Save Record" icon was highlighted. This resembles the behaviour for
Anomaly 2.

To demonstrate ANOMALY 8 :-
Re-open Form1, ensuring that the Form Navigation toolbar is visible. Text Box 1
is still empty, Text Box 2 is still empty, and the "Save Record" icon in the
Form Navigation toolbar is greyed out.
Set the value in Text Box 2 to "3x". As should be expected, the "Save Record"
icon in the Form Navigation toolbar becomes highlighted.
Clear the value in Text Box 2 again. Ideally, the "Save Record" icon in the
Form Navigation toolbar should be greyed out again, but it actually remains
highlighted.
Attempt to close the form. The form closes with no warning message, even though
the "Save Record" icon was highlighted. This resembles the behaviour for
Anomalies 2 and 7, but differs from the behaviour for Anomaly 3.

I haven't done extensive testing, but I believe that all field types apart from
CLOB behave similarly to TEXT. I reported similar anomalies for fields of the
equivalent LONGVARCHAR type when using an HSQL embedded database - see bug
report #72205, which is marked as RESOLVED.

-- 
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/20191207/28ed0cb8/attachment-0001.html>