最近在升级,从Nebula2.5.1升级到3.4.1,有一个语句发现不能用了,请问如何改写?
match (v:ai_ti) where v.ai_ti.name == '1677642430002' and v.ai_ti.device_model == 'Model' and [n IN split(v.ai_ti.system_version,'.') | TOINTEGER(n)] <= [9, 5, 7] return id(v) as VertexID \
| go from $-.VertexID over to_mid where $$.mid.name IS NOT EMPTY yield DISTINCT to_mid._dst as vid, $$.mid.name as name, $$.mid.epv as epv, $$.mid.wpv as wpv, 'ai_ti' as from_label
因为需要逐位比较system_version大小,所以用了match,没有发现好办法改写,在2.5.1这种写法是没问题的
match (v:ai_ti) where v.name == '1677642430002' and v.device_model == 'Model' and [n IN split(v.system_version,'.') | TOINTEGER(n)] <= [9, 5, 7] return id(v) as VertexID \
| go from $-.VertexID over to_mid where $$.mid.name IS NOT EMPTY yield DISTINCT to_mid._dst as vid, $$.mid.name as name, $$.mid.epv as epv, $$.mid.wpv as wpv, 'ai_ti' as from_label