On the tightness of an SDP relaxation for homogeneous QCQP with three real or four complex homogeneous constraints