| Summary: | Sort fails in database created as Evolution address data source | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | Joseph Sylvester <jgsylvesterjr> |
| Component: | Database | Assignee: | Not Assigned <libreoffice-bugs> |
| Status: | NEW --- | QA Contact: | |
| Severity: | normal | ||
| Priority: | medium | CC: | dr, iplaw67, lionel, serval2412 |
| Version: | 3.3.0 RC1 | ||
| Hardware: | Other | ||
| OS: | Linux (All) | ||
| Whiteboard: | |||
| i915 platform: | i915 features: | ||
| Attachments: | database exhibiting issue behaviour | ||
Do you reproduce this pb with 3.4.4 (the current version) ? Forget my previous message, i reproduce it on 3.4.4 [This is an automated message.] This bug was filed before the changes to Bugzilla on 2011-10-16. Thus it started right out as NEW without ever being explicitly confirmed. The bug is changed to state NEEDINFO for this reason. To move this bug from NEEDINFO back to NEW please check if the bug still persists with the 3.5.0 beta1 or beta2 prereleases. Details on how to test the 3.5.0 beta1 can be found at: http://wiki.documentfoundation.org/QA/BugHunting_Session_3.5.0.-1 more detail on this bulk operation: http://nabble.documentfoundation.org/RFC-Operation-Spamzilla-tp3607474p3607474.html Isn't this an old bug from OOo days, where LDAP/Evolution datasources couldn't be sorted ? Alex It could be. I am no longer on Linux, so I cannot test thsi. I belive it was fixed before I left Linux. On pc Debian x86-64 with LO 4.2 sources updated 2 weeks ago, I could reproduce this. (I tried "Evolution local") I noticed this log: warn:dbaccess:12055:1:dbaccess/source/core/api/SingleSelectQueryComposer.cxx:978: We have column labels for *some* columns but not all 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.
Created attachment 47889 [details] database exhibiting issue behaviour When attempting to sort a table column XXX, the Sort A-Z and Sort Z-A commands produce the following error: "Error setting the source criteria. The column XXX must be visible as a column. SQL status: 01000, Error code 1000." This failure occurs (apparently only) in a database created as an Evolution addres data source. To reporoduce this problem, Using Wizard->Address Data Source..., select Evolution as the external addrss data source. Map the various field assignments (Family name, given name, etc.). An .odb database will be created. Open this database, and open the Evolution table. In my case, the table name is "Personal". Select a column, any column. Select Sort A-Z or Sort Z-A. This produces the error "Error setting the source criteria. The column XXX must be visible as a column. SQL status: 01000, Error code 1000." Additional informationation: If a general sort is executed, the sort does not seem to work at all. There is no change is the displayed data.