MySQL Bugs: #50573: Support the last_value() aggregate function

Bug #50573	Support the last_value() aggregate function
Submitted:	24 Jan 2010 17:09	Modified:	24 Jan 2010 18:14
Reporter:	Mark Callaghan	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Server: General	Severity:	S4 (Feature request)
Version:	5.0,5.1	OS:	Any
Assigned to:		CPU Architecture:	Any
Tags:	aggregate, Contribution, FUNCTION, last_value

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
The Google patch added the SQL aggregate function LAST_VALUE to support online table checksum computation. It is also supported by some RDBMS products for analytical SQL. I don't know if the implementation in the Google patch provides the proper semantics for that. The code in the Google patch provides the required semantics for online table checksum.

See:
http://code.google.com/p/google-mysql-tools/wiki/OnlineDataDrift
http://code.google.com/p/google-mysql-tools/wiki/NewSqlFunctions

I want this function to be added to official MySQL.

How to repeat:
na

Suggested fix:
na

Thank you for the feature request.