Summary: | EDITING: Query on Mac OS X Addressbook doesn't display data for fields other than CHAR datatype | ||
---|---|---|---|
Product: | LibreOffice | Reporter: | robert |
Component: | Database | Assignee: | Not Assigned <libreoffice-bugs> |
Status: | NEW --- | QA Contact: | |
Severity: | normal | ||
Priority: | medium | CC: | dr, iplaw67, lionel, serval2412 |
Version: | 3.5.3 release | ||
Hardware: | Other | ||
OS: | Mac OS X (All) | ||
Whiteboard: | |||
i915 platform: | i915 features: | ||
Attachments: | Shows birthdate (German: Geburtstag) as timestamp in tables and text in queries |
Description
robert
2012-06-03 01:13:11 UTC
Created attachment 62456 [details]
Shows birthdate (German: Geburtstag) as timestamp in tables and text in queries
The data itself are present in the query - sort by date i.e. works fine. There is just no display of the values. Formatting of the column is not possible, the only value shown in format-Dialog is "Text" and "@" Hmm, I don't have a birthday field in my OSX address book to be able to compare... Alex At least, not in the French version of Contacts.app and this consequently does not appear in my LO MacAb ODB connection. Alex (In reply to comment #4) > At least, not in the French version of Contacts.app and this consequently > does not appear in my LO MacAb ODB connection. > > Alex Contacts.app V7.1(1170) Is this some kind of personalized field that you added, or is it the default ? OK, I could reproduce the problem with any of the Creation or Modification date fields. These are also indicated as timestamp, yet they show up blank in a query. How to reproduce : 1) Create an ODB file that connects to the Mac addressbook using the db creation wizard. 2) Open the ODB and the GUI query designer wizard. 3) Choose FirstName, Creation and Modification as the fields for display. 4) Validate or run query - only the FirstName field shows any data despite data being available in the Table view mode. The SQL that is displayed : SELECT "Address Book"."Prénom" AS "Prénom", "Address Book"."Creation" AS "Creation", "Address Book"."Modification" AS "Modification" FROM "Address Book" "Address Book" Note that despite specifically querying on 3 fields, 2 of which are timestamp type, only one timestamp field gets displayed and no data is shown for this field. Adding Lionel, Julien to CC. Alex Is this a problem with the Mork driver ? Alex I tested in LO 4.1.1.2 I can not create a connection to a MacAB with LO-dev 4.2, it systematically causes a crash of the whole app, but will report that separately. Alex It also won't show a query that uses the ABPersonFlags field. These are defined as INT in Table design mode and yet do not show up in a query, so the problem seems to be that the Query parser or the returned display fails to handle anything other than CHAR datatype. Alex Changed title to reflect findings I tried to compare these files: http://opengrok.libreoffice.org/xref/core/connectivity/source/drivers/mork/MDatabaseMetaData.cxx#894 http://opengrok.libreoffice.org/xref/core/connectivity/source/drivers/macab/MacabDatabaseMetaData.cxx#807 http://opengrok.libreoffice.org/xref/core/connectivity/source/drivers/flat/EDatabaseMetaData.cxx#70 But don't get the logic for the moment. Alex: are you sure it's Mork driver which is used for Mac address book? (not Macab driver?) (In reply to comment #12) > Alex: are you sure it's Mork driver which is used for Mac address book? (not > Macab driver?) I expect it is hte MacAB driver :) (In reply to comment #13) > > I expect it is hte MacAB driver :) Lionel, I expect you're right, sorry :-) Alex Adding self to CC if not already on |
Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.