Issue 61611 - Address book: Sorting a column in a query returns double records.
Summary: Address book: Sorting a column in a query returns double records.
Status: CLOSED FIXED
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOo 2.0
Hardware: All All
: P3 Trivial (vote)
Target Milestone: OOo 2.0.3
Assignee: marc.neumann
QA Contact: issues@dba
URL:
Keywords: regression
: 63559 (view as issue list)
Depends on:
Blocks:
 
Reported: 2006-02-04 18:23 UTC by iscrow
Modified: 2006-06-01 11:51 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 iscrow 2006-02-04 18:23:23 UTC 
I created a database connected to my Mozilla Thunderbird address book with the
"Address Book Source" wizard under File/Templates.

I then created a simple query based on one of the tables that returns just some
of the fields. If I sort one any of the fields, the query returns double the
records in the table. I get two copies of each record. For example:

my Business Addresses table contains the following:

address1      company1
address3      company3
address2      company2

Then I create the following query:

SELECT "Address 1", "Company" FROM "Business Addresses" "Business Addresses"
ORDER BY "Company" ASC

The query returns the following:

address1      company1
address2      company2
address3      company3
address1      company1
address2      company2
address3      company3
Comment 1 marc.neumann 2006-02-06 08:46:24 UTC 
Hi,

I can reproduce this, reassign it to the right developer and set target.

The same with mozilla address book

Bye Marc
Comment 2 marc.neumann 2006-02-06 09:05:28 UTC 
change summary
Comment 3 Frank Schönheit 2006-02-22 12:37:49 UTC 
fs: targeting to Later in agreement with MSC. Doesn't really justify 2.0.3
target ...
Comment 4 marc.neumann 2006-03-24 08:58:30 UTC 
*** Issue 63559 has been marked as a duplicate of this issue. ***
Comment 5 volkont 2006-03-24 14:27:50 UTC 
Hi,

I'd like ask to target this issue to at least to 2.0.4 or even better again to
2.0.3 if possible in any way.
The issue obviously is not critical, but quite annoying as most users sort the
address book entries by name. Also creating an address list in calc via a base
query will return double the records. Certainly it's not a problem to delete the
duplicates, as these appear unsorted at the end of the table ... but it's annoying.

The issue seems to be related to the Mozilla driver and is new in OOo 2.0.x. It
does not appear in OOo 1.1.5, so maybe there is a way to adjust that driver to
work with OOo 2.0.x ... just my 2cents ...

Volko
Comment 6 Frank Schönheit 2006-03-27 08:09:37 UTC 
> I'd like ask to target this issue to at least to 2.0.4 or even better again to
2.0.3
> if possible in any way.

Well, sometimes you get what you ask for :)
Comment 7 Frank Schönheit 2006-03-27 08:30:21 UTC 
adding keyword "regression"
Comment 8 Frank Schönheit 2006-03-29 06:36:33 UTC 
fs-> msc: please verify in CWS dba203b

re-open issue and reassign to msc
Comment 9 Frank Schönheit 2006-03-29 06:36:37 UTC 
reassign to msc
Comment 10 Frank Schönheit 2006-03-29 06:36:40 UTC 
reset resolution to FIXED
Comment 11 marc.neumann 2006-03-30 08:23:18 UTC 
verified in cws dba203b

You can found more information about this CWS in the EIS tool at
http://eis.services.openoffice.org/EIS2/cws.SearchCWS
Comment 12 marc.neumann 2006-06-01 11:51:18 UTC 
Hi,

this is fixed in the current master. The current master is available at
http://download.openoffice.org/680/index.html

I close this issue now.

Bye Marc