Sorry - I don't get emails on comments so I didn't see this until today. I'm using 2.0.11
On Wednesday, July 29, 2015 at 9:57:18 AM UTC-5, Luigi Dell'Aquila wrote: > > Hi Bill, > > which version are you using? I think I fixed something like this in last > 2.1 release candidate > > Luigi > > > 2015-07-28 20:47 GMT+02:00 Bill Blondin <[email protected] > <javascript:>>: > >> In further testing, there's actually a bug here. >> >> If I specify the property name in the projection, I don't get the null >> properties back. e.g. SELECT @rid, Street1, Street2, City, State, Postal >> FROM Address WHERE (@rid=#14:1) will omit Street2 from the response if it >> is null. >> >> If use wildcard, then I get the null properties back. e.g. SELECT FROM >> Address WHERE (@rid = #14:1) >> >> >> >> On Tuesday, July 28, 2015 at 1:40:19 PM UTC-5, Bill Blondin wrote: >>> >>> I figured out what is causing the issue - when I inserted the record, I >>> omitted explicitly setting the property value to NULL. Instead, I left the >>> property out of the insert completely, so when reading, it assumed the >>> property simply doesn't exist, and therefore does not return the property. >>> >>> I suppose this is correct behavior, even if it is a bit strange? >>> >>> >>> On Tuesday, July 28, 2015 at 12:41:26 PM UTC-5, Bill Blondin wrote: >>>> >>>> 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 >>>> >>> -- >> >> --- >> You received this message because you are subscribed to the Google Groups >> "OrientDB" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected] <javascript:>. >> For more options, visit https://groups.google.com/d/optout. >> > > -- --- You received this message because you are subscribed to the Google Groups "OrientDB" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
