You are not logged in.
- Topics: Active | Unanswered
#1 2018-08-16 02:46:55
- edwinsn
- Member
- Registered: 2010-07-02
- Posts: 1,218
The new SQLite 3.25.0 now supports window functions!
I didn't know SQL's window function before, but from what I've seen so far it seems to be very helpful, and will learn it here:
https://www.windowfunctions.com/questions/over/
IIRC, in the old versions mORMot didn't handle the 'WITH...' statement (CTE) correctly until it's reported to ab and he fixed it quickly, so I'm not sure if the special syntax of the 'window function' statements needs special attentions to be paid to it when ab's integrating the new sqlite 3.25 
Delphi XE4 Pro on Windows 7 64bit.
Lazarus trunk built with fpcupdelux on Windows with cross-compile for Linux 64bit.
Offline
#3 2018-08-16 08:44:24
- edwinsn
- Member
- Registered: 2010-07-02
- Posts: 1,218
Re: The new SQLite 3.25.0 now supports window functions!
Ah you are right!
Delphi XE4 Pro on Windows 7 64bit.
Lazarus trunk built with fpcupdelux on Windows with cross-compile for Linux 64bit.
Offline
#4 2018-09-18 06:22:40
- Leslie7
- Member
- Registered: 2015-06-25
- Posts: 248
Re: The new SQLite 3.25.0 now supports window functions!
Offline
#5 2018-09-18 06:25:28
- edwinsn
- Member
- Registered: 2010-07-02
- Posts: 1,218
Re: The new SQLite 3.25.0 now supports window functions!
And mORMot now includes SQLite 3.25.0: https://github.com/synopse/mORMot/commi … 53bf38721d
Delphi XE4 Pro on Windows 7 64bit.
Lazarus trunk built with fpcupdelux on Windows with cross-compile for Linux 64bit.
Offline
#6 2018-09-20 16:02:08
- enrcas
- Member
- Registered: 2013-06-16
- Posts: 20
Re: The new SQLite 3.25.0 now supports window functions!
>2018-09-18 06:22:40
>Good news:
>https://www.sqlite.org/windowfunctions.html
>2018-09-18 06:25:28
>And mORMot now includes SQLite 3.25.0: https://github.com/synopse/mORMot/commi … 53bf38721d
man, only 2m48s later?
you are so slow... xD 
Offline