Issue 124507 - Combo Box causing crash
Summary: Combo Box causing crash
Status: CLOSED DUPLICATE of issue 123157
Alias: None
Product: Writer
Classification: Application
Component: code (show other issues)
Version: 3.4.0 Beta (OOo)
Hardware: PC Windows 7
: P3 Major (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact: Edwin Sharp
URL:
Keywords: crash, regression
Depends on:
Blocks: 14842
  Show dependency tree
 
Reported: 2014-03-25 10:57 UTC by Edwin Sharp
Modified: 2014-03-25 16:13 UTC (History)
1 user (show)

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

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description Edwin Sharp 2014-03-25 10:57:49 UTC 
1. File - New - Text Document
2. View - Toolbars - Form Controls
3. Click Combo Box and draw in document
4. Data source: Bibliography - Table / Query: biblio - Next
5. Click biblio - Next
6. Click Author - Next
7. No, I only want to save the value in the form. - Finish
8. Design Mode Off

-> Crash

AOO410m14(Build:9760)  -  Rev. 1573601
2014-03-03 17:47:48 (Mo, 03 Mrz 2014)
OK with OpenOffice.org 2.4.3
Comment 1 mroe 2014-03-25 11:27:03 UTC 
Can confirm this issue how described.

Recovery of the document will also always result in a crash.


AOO410m14(Build:9760) - Rev. 1573601
214-02-28 10:30 - Linux i686
Comment 2 Oliver-Rainer Wittmann 2014-03-25 11:47:41 UTC 
I am having a closer look
Comment 3 Oliver-Rainer Wittmann 2014-03-25 11:59:34 UTC 
I can also confirm this crash.

I reproduced it under Windows 7 with OOo 3.4 Beta, AOO 3.4.0, AOO 4.0.1 and AOO 4.1.0 Beta. It does not crash with OOo 3.3.0
--> adjusting version field
Comment 4 mroe 2014-03-25 12:41:00 UTC 
I looked into the definition of the formular and the control.

So I found the problem is located at the SQL statement of the control:

SELECT DISTINCT "Author" FROM "biblio"

With this SQL command you can reproduce the problem manually. And it would also result in a crash if you open the query window with this command and try to run the query. (It could be that it runs once without crash.)

Tried with OOo 3.4/Ubuntu.
Comment 5 Oliver-Rainer Wittmann 2014-03-25 14:36:12 UTC 
My investigation reveals the following:
A sorting of the resulting rows from the query - corresponding SQL statement is given by mroe - is triggered. The sorting algorithm wants to know the type of the columns on which the sorting should be performed. An internal data structure containing the indexes for the sorting columns based on the full table with all columns, but the resulting set does contain only one column. In the given use case it is the column "Author". Thus, an invalid index access occurred in the sorting code which leads to a crash.
Comment 6 Ariel Constenla-Haile 2014-03-25 16:13:39 UTC 
Dup.

*** This issue has been marked as a duplicate of issue 123157 ***