Skip Menu |

This queue is for tickets about the SQL-Statement CPAN distribution.

Report information
The Basics
Id: 100684
Status: rejected
Priority: 0/
Queue: SQL-Statement

People
Owner: Nobody in particular
Requestors: sharyanto [...] cpan.org
Cc:
AdminCc:

Bug Information
Severity: (no value)
Broken in: (no value)
Fixed in: (no value)



Subject: 'SELECT SUM(f) FROM t' works but 'SELECT SUM(f)/2 FROM t' fails with: Can't find table containing column named 'sum'
'SELECT SUM(f) FROM t' works but 'SELECT SUM(f)/2 FROM t' fails with: Can't find table containing column named 'sum'. Same with other aggregate function like COUNT() or AVG(). Same happens with other expressions like 2*SUM(f), AVG(f)+100, and so on.
This is a known issue - see RT#80423. Please contribute to existing tickets.