Issue 118089

Summary:	Extra Row on query to Outlook contacts
Product:	Base	Reporter:	michael.junker
Component:	code	Assignee:	AOO issues mailing list <issues>
Status:	UNCONFIRMED ---	QA Contact:
Severity:	Normal
Priority:	P3	CC:	issues
Version:	OOo 3.3
Target Milestone:	---
Hardware:	PC
OS:	Windows 7
Issue Type:	DEFECT	Latest Confirmation in:	---
Developer Difficulty:	---

Description michael.junker 2011-05-28 06:19:15 UTC

After creation of an addressbook data source to Outlook a OO-Database is
available. Querying this db with 

SELECT "OP Kontakte"."Vorname" AS "Vorname", "OP Kontakte"."Nachname" AS "Nachname", "OP Kontakte"."Anzeigename" AS "Anzeigename", "OP Kontakte"."Spitzname" AS "Spitzname", "OP Kontakte"."E-Mail" AS "E-Mail", "OP Kontakte"."E-Mail (2)" AS "E-Mail (2)", "OP Kontakte"."Mail-Format" AS "Mail-Format", "OP Kontakte"."Telefon (gesch.)" AS "Telefon (gesch.)", "OP Kontakte"."Telefon" AS "Telefon", "OP Kontakte"."Fax" AS "Fax", "OP Kontakte"."Pager" AS "Pager", "OP Kontakte"."Handy" AS "Handy", "OP Kontakte"."Adresse 1" AS "Adresse 1", "OP Kontakte"."Adresse 2" AS "Adresse 2", "OP Kontakte"."Stadt" AS "Stadt", "OP Kontakte"."Bundesland" AS "Bundesland", "OP Kontakte"."PLZ" AS "PLZ", "OP Kontakte"."Land" AS "Land", "OP Kontakte"."Geschäftsadresse" AS "Geschäftsadresse", "OP Kontakte"."Geschäftsadresse 2" AS "Geschäftsadresse 2", "OP Kontakte"."Stadt (gesch.)" AS "Stadt (gesch.)", "OP Kontakte"."Bundesland (gesch.)" AS "Bundesland (gesch.)", "OP Kontakte"."PLZ (gesch.)" AS "PLZ (gesch.)", "OP Kontakte"."Land (gesch.)" AS "Land (gesch.)", "OP Kontakte"."Titel" AS "Titel", "OP Kontakte"."Abteilung" AS "Abteilung", "OP Kontakte"."Firma" AS "Firma", "OP Kontakte"."Web-Seite (gesch.)" AS "Web-Seite (gesch.)", "OP Kontakte"."Web-Seite (privat)" AS "Web-Seite (privat)", "OP Kontakte"."Geburtsjahr" AS "Geburtsjahr", "OP Kontakte"."Geburtsmonat" AS "Geburtsmonat", "OP Kontakte"."Geburtstag" AS "Geburtstag", "OP Kontakte"."benutzerdef. 1" AS "benutzerdef. 1", "OP Kontakte"."benutzerdef. 2" AS "benutzerdef. 2", "OP Kontakte"."benutzerdef. 3" AS "benutzerdef. 3", "OP Kontakte"."benutzerdef. 4" AS "benutzerdef. 4", "OP Kontakte"."Bemerkungen" AS "Bemerkungen" FROM "OP Kontakte" "OP Kontakte" WHERE ( "OP Kontakte"."Firma" = '-Firma-' )

results in two rows found. The first rows shows the expected result. The second row shows all field empty exect "Mail-Format" wich shows ´'unknown'. This row does not meet the search criteria "OP Kontakte"."Firma" = '-Firma-'.

This problem was observed on a german version of oo and outlook.

Comment 1 Oliver-Rainer Wittmann 2012-06-13 12:17:31 UTC

getting rid of value "enhancement" for field "severity".
For enhancement the field "issue type" shall be used.