Advanced Recordset functions not working

Given I have an Advanced Recordset tool on the design surfcae

When the SQL is "SELECT SUM(sales) AS Count FROM Table"

Then my variable list has a Field called SUM and a field called Count added to the Table recordset

Given I click Generate Outputs

Then nothing happens and not outputs are generated.

Given I then amend the SQL to "SELECT sales FROM Table"

When I click Generate Outputs

Then Still nothing happens

Given I create a new Advanced Recordset tool on the design surface

When I copy the SQL statement to the new tool

and When I click Generate Outputs

Then Outputs are generated