pietermartin / sqlg

TinkerPop graph over sql
MIT License
240 stars 51 forks source link

upgrade to version 3 got the default multiplicity wrongs. #486

Closed pietermartin closed 1 year ago

pietermartin commented 1 year ago

The upgrade to version 3's sql defaulted the lower multiplicity to -1 for ARRAY types and upper to 0 for non ARRAY types.

update sqlg_schema."V_property"
set "lowerMultiplicity" = 0
where "lowerMultiplicity" = -1;

update sqlg_schema."V_property"
set "upperMultiplicity" = 1
where "upperMultiplicity" = 0;

Need to execute the above sql to fix it.

This is only being noticed now because Sqlg validates multiplicity on ensureXXXExists methods