Issue 123157 - CRASH when Exiting "Design mode" in form with SQL database connection
Summary: CRASH when Exiting "Design mode" in form with SQL database connection
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: 3.4.0
Hardware: All All
: P2 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Keywords: crash, regression
: 124507 (view as issue list)
Depends on:
Reported: 2013-09-01 15:26 UTC by Andrea Pescetti
Modified: 2014-03-25 16:14 UTC (History)
3 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: 4.1.0-beta
Developer Difficulty: ---

Exit draft mode, OpenOffice crashes (9.09 KB, application/vnd.oasis.opendocument.text)
2013-09-01 15:26 UTC, Andrea Pescetti
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description Andrea Pescetti 2013-09-01 15:26:35 UTC
Created attachment 81425 [details]
Exit draft mode, OpenOffice crashes

1. Open the attached document. It is a simple form, with a drop-down list taking values in the "biblio" database (from the "author" filed). "Draft mode" is set to on.

2. Close Draft mode.

3. OpenOffice crashes.

Crash: OpenOffice 4.0 Italian, Linux 64 bit RPM.
Comment 1 Rainer Bielefeld 2013-09-01 16:41:10 UTC
Reproducible with  "AOO 4.1.0-Dev – English  UI / German locale - [AOO410m1(Build:9750)  -  Rev. 1516435  2013-08-24]" on German WIN7 Home
Premium (64bit)", own separate user profile:

1. Open attachment from AOO Start center
2. Menu 'View -> Toolbars -> Form Controls' to make toolbar visible if necessary
3. Click 'Design Mode' in Toolbar

a) Already Reproducible  with 
* server installation of  " AOO 4.0.0-Dev  – English UI / German locale [AOO400m1(Build:9700) - Rev. 1457992 - Rev.1457606]" on German WIN7 Home Premium (64bit)", own separate user profile
* 3.4.0

b) Was still ok with 2.0.2. 3.3.0, so rather old REGRESSION

c) currently I can't imagine what in the particular document causes the crash
Comment 2 Rainer Bielefeld 2013-09-01 16:55:55 UTC
Reason for the crash is in control field "data" SQL query:
'SELECT  DISTINCT "Author" FROM "biblio"'. 

After deletion of that control field contents and saved, closed and reopened document no longer will crash. Copy / paste of that contents will cause the crash again.
Comment 3 Rainer Bielefeld 2013-09-01 17:14:59 UTC
Query string "SELECT  DISTINCT "Author"" does not cause the crash in a new document, but "SELECT  DISTINCT "Author" FROM "biblio"" also will cause a crash in a newly created document with list box
Comment 4 Ariel Constenla-Haile 2013-09-01 17:22:33 UTC
It is the query that crashes.
Open the Bibliographic database
Create the following query in SQL view: SELECT DISTINCT "Author" FROM "biblio"
Execute the query

No Writer bug.
Comment 5 Ariel Constenla-Haile 2014-03-25 16:13:39 UTC
*** Issue 124507 has been marked as a duplicate of this issue. ***