Issue 9645

Summary:

crash using database fields insertion dialog

Product:

Base

Reporter:

sophia <jerome.bouat>

Component:

code

Assignee:

Frank Schönheit <frank.schoenheit>

Status:

CLOSED FIXED

QA Contact:

issues@dba <issues>

Severity:

Trivial

Priority:

CC:

issues, oooqa

Version:

OOo 1.0.1

Keywords:

oooqa

Target Milestone:

---

Hardware:

OS:

Linux, all

Issue Type:

DEFECT

Latest Confirmation in:

---

Developer Difficulty:

---

Attachments:

Description	Flags
OOCalc database	none
OOWriter document where I want to insert a field	none

Description sophia 2002-11-28 16:59:47 UTC

I was using OOCalc as a database
by filling rows.
I opened a read only letter
and saved it as a new OOWriter document.
I tried to insert a mailing field from my previous database.
I used the menu 'insertion'->'champ'->'autres' (french)
and got the frame named 'Champs'.
I selected the 'Base de donnÃ©es' tab.
I selected the 'Enregistrement suivant'
as a 'type de champs'.
Then I double clicked on a query
of my database
and OOCalc and OOWriter crashed.
I reproduce it always.
Sometimes the following message is logged in console:
Segmentation fault
sometimes nothing is dumped.

Comment 1 prgmgr 2002-12-01 18:31:53 UTC

Sophia, thank you for using and supporting OOo.

Please attach the files required to reproduce this issue.

This is what I've translated from your instructions so far.

1.  Create a Bibliography DB using Calc.
2.  Insert->Field->Other
3.  Go to the Database tab
4.  Select Next Record in the Type field.
5.  Click Insert.


I tried creating a simple Calc file and used it as a data source in 
OOo 643c and OOo 1.0.1.  I am unable to reproduce the problem.  
However, I'm not clear on the steps I need to take.

Comment 2 sophia 2002-12-01 21:06:07 UTC

6. open my database tree
7. double click on a query leaf

I could reproduce it.

Comment 3 sophia 2002-12-01 21:07:14 UTC

Created attachment 3847 [details]
OOCalc database

Comment 4 sophia 2002-12-01 21:08:58 UTC

Created attachment 3848 [details]
OOWriter document where I want to insert a field

Comment 5 prgmgr 2002-12-01 21:27:26 UTC

Thanks for the attachments and update Sophia.

I must be doing something different.

Unable to duplicate on OOo 1.0.1 and OOo 643c.

Comment 6 sophia 2002-12-01 22:01:56 UTC

Did you create a query ?

I used the following query to produce the bug:
SELECT "Lettre candidature", "CivilitÃ©", "DRH", "Raison sociale",
"Adresse1", "Adresse2", "CP", "Ville", "Cedex" FROM "liste organismes"
"liste_organismes" WHERE ( ( "DRH" <> '' ) )

Once you created this query
in the database node
(menu 'affichage'->'sources de donnÃ©es'),
then you have the double click
as previously described on this query
in the 'Champs' frame
(verify you selected at first
'next record').

I think this problem
is not only for this query
because I produced the bug
with other queries too.

Comment 7 prgmgr 2002-12-02 03:37:18 UTC

Sophia, thanks for your continued patience.  I just want to make it 
clear, you are doing fine, I just am having issues on my side.

I think I've reproduced the issue on 1.0.1.  643c does not crash.

1.  Add "organismes.sxc" as a Data Source.
2.  Create a query using the SQL provided by Sophia.  

    Note I removed the double instance of "liste organismes"
    from the query because I think that was a typo.
3.  Insert->Fields->Other
4.  Go to Database tab.
5.  Choose "Next Record" as Type.
6.  Choose the query that was entered in step 2.
7.  Double click on "Next Record" or click on Insert.

OOo should crash at this point.

Duplicated on RH 8.0, RH OOo 1.0.1.
Unable to duplicate on Win2K server SP3, OOo 643c.
Unable to duplicate on RH 8.0, OOo 643c.

Comment 8 sophia 2002-12-02 12:02:03 UTC

procedure diff:

c
< 6.  Choose the query that was entered in step 2.
---
> 6. Double click on the query that was entered in step 2.
d
< Double click on "Next Record" or click on Insert.


The bug appear on step 6.

Comment 9 ocke.janssen 2003-01-02 13:07:07 UTC

Fixed in a src643C

Comment 10 Frank Schönheit 2003-05-20 11:40:23 UTC

closing

Comment 11 hans_werner67 2004-02-02 12:52:05 UTC

change subcomponent to 'none'