Fixes #5800 cast user guid to an int
adds warning for those using a string value with the operand "IN" for metadata pairs