Bug 283092

Summary:	Kexi crashes on saving query design
Product:	[Applications] KEXI	Reporter:	Bryan Mitchell <bryan>
Component:	Queries	Assignee:	Jarosław Staniek <staniek>
Status:	CLOSED WAITINGFORINFO
Severity:	crash
Priority:	NOR
Version First Reported In:	2.3.3 (KOffice 2.3.3)
Target Milestone:	---
Platform:	Ubuntu
OS:	Linux
Latest Commit:		Version Fixed/Implemented In:
Sentry Crash Report:

Description Bryan Mitchell 2011-09-30 11:54:17 UTC

Version:           2.3.3 (KOffice 2.3.3) (using KDE 4.6.2) 
OS:                Linux

Kexi crashes when I try to save a new query by clicking on the SAVE icon.

Reproducible: Always

Steps to Reproduce:
Click "Create query". Enter the query details on the design form, then click on the SAVE icon.

Actual Results:  
The program crashes and shows the error message as above.

Expected Results:  
The query should have been saved.

Comment 1 Jarosław Staniek 2011-12-04 22:16:45 UTC

Thank you for the report. Could you please provide the test database or explain what table(s) did you define and what query did you try to save?

Comment 2 Bryan Mitchell 2011-12-05 10:45:28 UTC

On Sun, 2011-12-04 at 22:16 +0000, Jarosław Staniek wrote:
> https://bugs.kde.org/show_bug.cgi?id=283092
> 
> 
> Jarosław Staniek <staniek@kde.org> changed:
> 
>            What    |Removed                     |Added
> ----------------------------------------------------------------------------
>              Status|UNCONFIRMED                 |NEW
>      Ever Confirmed|0                           |1
> 
> 
> 
> 
> --- Comment #1 from Jarosław Staniek <staniek kde org>  2011-12-04 22:16:45 ---
> Thank you for the report. Could you please provide the test database or explain
> what table(s) did you define and what query did you try to save?
> 

I cannot supply the test database because it contains 400 personal names
and addresses. There are 14 fields.
The query is to sort by name as shown below:

Column		Table		Visible	  Sorting	Criteria

sheet1.enw	sheet1		   X		        
sheet1.town	sheet1             X                    'ABERDARE'
sheet1.name     sheet1             X      Ascend         'Jones'

When I add another line or column only and click on Save Kexi crashes.
The strange thing is that the query does get saved! When I click on Open
the query runs correctly.

Comment 3 Bryan Mitchell 2011-12-05 15:03:41 UTC

I cannot remember if I previously gave you the Kexi error messsage which appears after the crash. "Executable: kexi PID: 2242 Signal: Segmentation fault (11)"

Comment 4 Jarosław Staniek 2012-03-26 20:53:58 UTC

Maybe before sending it to me you could make a copy of the database and remove the table(s) but keep the query? This way you do not need to send your data.