Does his wall bear on those original foundations? If so, what happens
if those foundations are only suitable for a single story and the
second person wants to build higher?

I don't know about the legal aspects and what is allowed and who pays for
what. However, from a technical point of view, the original foundation would
need underpinning and extending to allow the extra weight.

Christian.