Bug 79264 - Editing text triggers false record modified warning
Summary: Editing text triggers false record modified warning
Status: NEEDINFO
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Database (show other bugs)
Version: 4.2.4.2 release
Hardware: x86-64 (AMD64) Linux (All)
: medium minor
Assignee: Not Assigned
QA Contact:
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2014-05-26 14:39 UTC by Wil Hepworth
Modified: 2015-01-03 17:38 UTC (History)
2 users (show)

See Also:
i915 platform:
i915 features:


Attachments

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.