It's hit and miss. At work I'm running a lubuntu install from 2012 that flawlessly upgraded up until now, sometimes skipping releases, sometimes not, switching desktop environment and window managers a few times along the way. Arch Linux on the other hand always has some minor breakage every now and then. Not with the package manager, but just something about the system being broken.