I'd love to do a "upgrade gotchas", but I haven't experienced enough. Maybe someone that's done a bunch or has a large environment can write me one!

The CREATE AGGREGATE seems more like a BI enhancement, but maybe I'm wrong. Haven't really thought of any I needed yet.

There's definitely some gotchas and a nice list above from Noel.