Bug 195360 - Add support for grouping and aggregation functions like sum(), count() in queries
Summary: Add support for grouping and aggregation functions like sum(), count() in que...
Status: CONFIRMED
Alias: None
Product: KEXI
Classification: Applications
Component: Queries (show other bugs)
Version: 3.1.0
Platform: unspecified All
: NOR wishlist
Target Milestone: ---
Assignee: Kexi Bugs
URL: https://invent.kde.org/office/kexi/-/...
Keywords: bounty
Depends on:
Blocks:
 
Reported: 2009-06-05 18:56 UTC by keyro90
Modified: 2023-04-05 14:23 UTC (History)
3 users (show)

See Also:
Latest Commit:
Version Fixed In:
Sentry Crash Report:

Attachments
Add an attachment

Note You need to log in before you can comment on or make changes to this bug.
Description keyro90 2009-06-05 18:56:52 UTC 
Version:            (using KDE 3.5.10)
OS:                Linux
Installed from:    Debian stable Packages

Hi!
I use Kexi to interact with MySQL server and its databases.
I love it, however in Kexi it's impossible creating queries with operators SUM() COUNT() etc. like :

    SELECT SUM(hour)
    FROM table;

Because the program warns me with a message : "Syntax error before ")"" and the same query in mysql-server functions perfectly.
How can solve this problem?
Thanks.
Andrea G.
Comment 1 Jarosław Staniek 2009-09-19 20:53:59 UTC 
Kexi parses the SQL itself and so don't pass the SQL commands directly, but rebuild them (needed for scripts portability and for bindings with the GUI). Currently the Kexi parser does not support groupping and aggregation.

This is planned for 2.x. I am sorry for the delay.
Comment 2 Jarosław Staniek 2009-09-19 21:03:04 UTC 
By the way I have marked the report as a wish for 2.x.
It won't be implemented (by the core team) for 1.x series.
Comment 3 Jarosław Staniek 2014-08-05 09:36:33 UTC 
Added "grouping" to the title since it is inseparable from aggregation.
Comment 4 Jarosław Staniek 2015-08-26 06:46:54 UTC 
Founding possible at https://github.com/staniek/kexi/issues/3 (click Post a bounty on it)
Comment 6 Adam Pigg 2019-01-29 18:27:02 UTC 
Out of interest, there are several supported aggregate functions in KReport/Kexi Reports.
Comment 7 Jarosław Staniek 2019-01-29 22:30:33 UTC 
Yes, that's good note. Ultimate though is that, when aggregations feature come to KEXI queries (and forms), they can be harmonized the Reports' aggregations.