odbtools/odbctest/mql/matrix/entity/600复杂关系查询.mql

-- select * from /matrix/entity/car/camry
-- /**
-- output()
-- **/;


select id,wheel["sise","color","screw"] from  /matrix/entity/car/camry where wheel.screw.sise > 39
/**
output()
**/;

select id,sise from  /matrix/entity/screw
/**
output()
**/;


-- 47 matrix
-- 大于40 小于60 应该是1个对象，限定一个与camry:13有碰撞的
select id,wheel["sise","color"] from  /matrix/entity/car/camry c join ("camry:13")-[:collide*1]-(h) on c.id = h.id where wheel.screw.sise > 39
/**
output()
**/;


-- 大于40 小于60 应该是1个对象，大于60
select id,wheel["sise","color"] from  /matrix/entity/car/camry where wheel.screw.sise > 39
/**
output()
**/;


-- 大于9999有2个对象，大于10000 小于20000的有1个对象
select id,wheel["sise","color"] from  /matrix/entity/car/camry where wheel.rotations.time('2021-09-13 00:00:00','').sum(count).assert($1 > 12000)
/**
output()
**/;