Issue 118089 - Extra Row on query to Outlook contacts
Summary: Extra Row on query to Outlook contacts
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOo 3.3
Hardware: PC Windows 7
: P3 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2011-05-28 06:19 UTC by michael.junker
Modified: 2013-01-29 21:47 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
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.