Issue 118089

Summary: Extra Row on query to Outlook contacts
Product: Base Reporter: michael.junker
Component: codeAssignee: 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.