546382 - Design Flaw in mozIStorageAggregateFunction?

Status: REOPENED

(Core :: SQLite and Embedded Database Bindings, defect, P5)

Description

[Hish]

User-Agent:       Mozilla/5.0 (Windows; U; Windows NT 6.1; en-US; rv:1.9.1.7) Gecko/20100104 Lightning/1.0b2pre SeaMonkey/2.0.2
Build Identifier: Mozilla/5.0 (Windows; U; Windows NT 6.1; en-US; rv:1.9.1.7) Gecko/20100104 Lightning/1.0b2pre SeaMonkey/2.0.2

It seems that each aggregate function can only be called once in a select statement.

Example: 
https://developer.mozilla.org/En/MozIStorageAggregateFunction#JavaScript line #27:
let stmt = dbConn.createStatement("SELECT stdDev(value) FROM some_table");  

When instead I would do a query like SELECT stdDev(row1), stdDev(row2) FROM some_table then both rows would be collected in the same aggregate function.

So, instead of having something like 
dbConn.createAggregateFunction("stdDev", 1, standardDeviationFunc);
it would make more sense to register a class instead of a function like
dbConn.createAggregateFunction("stdDev", 1, standardDeviationClass);

This way an instance could be created for each occurance.

Reproducible: Always

Comment 1

[BMO Automation]

Per policy at https://wiki.mozilla.org/Bug_Triage/Projects/Bug_Handling/Bug_Husbandry#Inactive_Bugs. If this bug is not an enhancement request or a bug not present in a supported release of Firefox, then it may be reopened.