Three wishes for a new year

September 16, 2012

Another new year by Jewish calendar. What do I wish for the following year?

  1. World peace
  2. Good health to all
  3. 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...

  • dbaday

    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.

Powered by Wordpress and MySQL. Theme by