When querying a vertex with a null property value (e.g. Address.City where City is null), it appears that the null value is stripped from the response, even if the property is explicitly stated in the projection.
e.g.
SELECT Street1, Street2, City FROM Address WHERE @rid=#14:0
If City is null, the response will only include Street1 and Street2 property values.
How can I force the query to return a null for the City property?
I have tried IfNull(City, null) which doesn't trick it to return a null. I can do IfNull(City, '') but empty string and null are not the same thing, so this solution is less than acceptable.
Thanks
Bill