| Summary: | EDITING: error on SQL execution on a view | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | Benoit Lathiere <benoit.lathiere> |
| Component: | Base | Assignee: | Not Assigned <libreoffice-bugs> |
| Status: | RESOLVED NOTABUG | ||
| Severity: | normal | CC: | robert |
| Priority: | medium | ||
| Version: | 3.6.3.2 release | ||
| Hardware: | Other | ||
| OS: | All | ||
| Whiteboard: | BSA | ||
| Crash report or crash signature: | Regression By: | ||
| Attachments: | screenshot during the crash of the query. | ||
I've got the same problem with the 3.6.4.1 version of Libreoffice.Base (still on Win764). So what should the query show at the second column, when you have grouped the first column? Example: firstname lastname Bob Hunter Mary Hunter And now grouped by lastname, not by firstname lastname firstname Hunter ???? What your screenshot shows isn't a crash. It shows only, that the query is wrong. And this is, what the popup shows: You have a field in the query, which isn't grouped or has any function, which could be aggregated with a grouped field. The database could not answer. This isn't a bug of Base. It's the normal behavior of the internal HSQLDB, that you could not query one field with a grouped by clause and another field without any function, which could be connected with "grouped by". |
Created attachment 70394 [details] screenshot during the crash of the query. Problem description: Steps to reproduce: 1. create a regular table (lastname, firstname, age, address, ...) (with or without) a primary key, and an index (on the lastname by example..), 2. "group by" and display lastname, 3. and display another column (firtname by example), 4. save/run the query of the view. Current behavior: crash when several colums displayed. (no crash when only the grouped column is displayed). Expected behavior: rows without doublons on the grouped columns. Platform (if different from the browser): Browser: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:17.0) Gecko/17.0 Firefox/17.0