Another new year by Jewish calendar. What do I wish for the following year?
- World peace
- Good health to all
- Get a decent, long waited for, implementation of Window Functions (aka Analytic Functions) for MySQL.
I mean, I like GROUP_CONCAT, and the many hacks it provides: [1], [2], [3], [4], [5], [6], [7], [8], [9], [10], [11], [12]. But it makes for a poor substitution to Window Functions, and only solves a subset of issues.
My wishes in previous two years [2010], [2011] have not come true. I’m still willing to settle for two out of three.
As I said to my son last week, it is not yet time for Santa Claus π
π
Maybe in a millennium or so…
It’s 2016 and still no window functions in MySQL. π
Also, no set operators.
Also, dates work wacky and have too many datatype variations.
I never should have left the first word of Oracle databases to slum it in MySQL land.