Bug 79264

Summary: Editing text triggers false record modified warning
Product: LibreOffice Reporter: Wil Hepworth <wilhepworth>
Component: DatabaseAssignee: Not Assigned <libreoffice-bugs>
Status: NEEDINFO --- QA Contact:
Severity: minor    
Priority: medium CC: iplaw67, serval2412
Version: 4.2.4.2 release   
Hardware: x86-64 (AMD64)   
OS: Linux (All)   
Whiteboard:
i915 platform: i915 features:

Description Wil Hepworth 2014-05-26 14:39:49 UTC
I have a table which contains a TEXT field.  Editing this text field causes odd behaviour when edited.  If the text is changed to a non-zero length string, attempting to close the form triggers the unsaved changes dialog.  If the text is set to a zero length string, this is not triggered.  If a non-zero length string is entered and then navigate to another record, the dialog is not issued.

I am using SQLite (3.8.4.3-1) and the ODBC connector (http://www.ch-werner.de/sqliteodbc/ - 0.997).


HOW TO REPRODUCE

Create table
CREATE TABLE tblProject (
	id INTEGER PRIMARY KEY AUTOINCREMENT,
	description TEXT NOT NULL,
	comments TEXT
);

Create two records with nothing in the comments.

Create a form bound to tblProject and a control bound to comments,

Enter a non-zero length string, save the record and close the form.  This will trigger the dialog.

Repeat the previous step, but before closing, navigate to another record.  No dialog is triggered.

Open the record with the non-zero length string.  Change the text to zero length, save the record and close the form.  No dialog is triggered.
Comment 1 Julien Nabet 2014-10-11 15:02:39 UTC
Perhaps I missed something but on pc Debian x86-64 with 4.3.2 Debian package, I don't reproduce this. (Mysql + jdbc)

Could you give a try to last stable LO version 4.3.2?
Comment 2 Alex Thurgood 2015-01-03 17:38:44 UTC
Adding self to CC if not already on

Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.