Details
-
Enhancement
-
Resolution: Won't Do
-
Blocker
-
3.1.3.Final
Description
Support for the SQL COUNT() function would be very useful. Something along the lines of the functionality described at http://www.w3schools.com/sql/sql_func_count.asp would work well.
SQL COUNT(column_name) Syntax
The COUNT(column_name) function returns the number of values (NULL
values will not be counted) of the specified column:
SELECT COUNT(column_name) FROM table_name
SQL COUNT(*) Syntax
The COUNT(*) function returns the number of records in a table:
SELECT COUNT(*) FROM table_name
SQL COUNT(DISTINCT column_name) Syntax
The COUNT(DISTINCT column_name) function returns the number of
distinct values of the specified column:
SELECT COUNT(DISTINCT column_name) FROM table_name
The workaround for this is for the application to fetch all the values of one column and count the number of records itself. Not a great option when there are a large number of rows.
Attachments
Issue Links
- is blocked by
-
MODE-2209 New query engine does not properly enforce permissions
-
- Resolved
-
