Add test for HIERARCHYID

Assure we can get this type from server.