Apache OpenOffice (AOO) Bugzilla – Issue 118089
Extra Row on query to Outlook contacts
Last modified: 2013-01-29 21:47:03 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.
getting rid of value "enhancement" for field "severity". For enhancement the field "issue type" shall be used.