Issue 123157

Summary: CRASH when Exiting "Design mode" in form with SQL database connection
Product: Base Reporter: Andrea Pescetti <pescetti>
Component: codeAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Normal    
Priority: P2 CC: elish, issues, rainerbielefeld_ooo_qa
Version: 3.4.0Keywords: crash, regression
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: DEFECT Latest Confirmation in: 4.1.0-beta
Developer Difficulty: ---
Attachments:
Description Flags
Exit draft mode, OpenOffice crashes none

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
   CRASH

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
Crash

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. ***