Issue Details (XML | Word | Printable)

Key: CORE-2823
Type: Sub-task Sub-task
Status: Resolved Resolved
Resolution: Fixed
Priority: Major Major
Assignee: Adriano dos Santos Fernandes
Reporter: Adriano dos Santos Fernandes
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
Firebird Core
CORE-1688

Support the ORDER BY subclause for current aggregate functions (except LIST)

Created: 23/Jan/10 01:56 AM   Updated: 23/Jan/10 03:01 AM
Component/s: Engine
Affects Version/s: None
Fix Version/s: 3.0 Alpha 1

Time Tracking:
Not Specified

Planning Status: Unspecified


 Description  « Hide
With the ORDER BY subclause (with or without PARTITION BY), aggregate functions should do cumulative aggregation over the rows it passes.

DISTINCT will not be supported (Oracle and PgSQL) doesn't support it too. LIST will also be out from this initial implementation.

 All   Comments   Work Log   Change History   Version Control   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Repository Revision Date User Message
Firebird #47950 Sat Jan 23 03:02:53 GMT+00:00 2010 asfernandes Feature CORE-2823 - Support the ORDER BY subclause for current aggregate functions (except LIST)
Files Changed
MODIFY /firebird/trunk/builds/win32/msvc8/engine_embed.vcproj
MODIFY /firebird/trunk/builds/win32/msvc9/engine_embed.vcproj
ADD /firebird/trunk/src/jrd/recsrc/OrderedWindowStream.cpp
MODIFY /firebird/trunk/src/jrd/gds.cpp
MODIFY /firebird/trunk/src/jrd/exe.h
MODIFY /firebird/trunk/builds/posix/make.shared.variables
MODIFY /firebird/trunk/builds/win32/msvc8/engine_classic.vcproj
MODIFY /firebird/trunk/src/dsql/pass1.cpp
MODIFY /firebird/trunk/builds/win32/msvc9/engine_classic.vcproj
MODIFY /firebird/trunk/src/dsql/node.h
MODIFY /firebird/trunk/src/jrd/par.cpp
MODIFY /firebird/trunk/src/dsql/parse.y
MODIFY /firebird/trunk/src/dsql/dsql.h
MODIFY /firebird/trunk/src/jrd/recsrc/WindowedStream.cpp
MODIFY /firebird/trunk/src/jrd/recsrc/RecordSource.h
MODIFY /firebird/trunk/src/dsql/gen.cpp
MODIFY /firebird/trunk/builds/win32/msvc8/engine.vcproj
MODIFY /firebird/trunk/builds/win32/msvc9/engine.vcproj

Repository Revision Date User Message
Firebird #57983 Thu Apr 25 16:30:58 GMT+00:00 2013 asfernandes Document window functions: CORE-2090, CORE-2133, CORE-2823, CORE-2830, CORE-2869, CORE-3619, CORE-3620, CORE-3621.
Files Changed
MODIFY /firebird/trunk/doc/WhatsNew
ADD /firebird/trunk/doc/sql.extensions/README.window_functions.txt