All constraint equations are based on small rotation theory. Therefore, their use in large-rotation analyses (NLGEOM) should be restricted to cases where the directions of the DOF included in constraint equations do not change significantly.
The presence of constraint equations can produce unexpected reaction and nodal force results. Please see The General Postprocessor (POST1) in the Basic Analysis Guide for a related discussion.
The constant terms in the constraint equations are considered as boundary conditions. Hence, they result in harmonically varying loads when included in a harmonic analysis.