odbtools/odbctest/mql/uino72/996.match.mql

MATCH (person:/univ_demo/person WHERE person_sort = '事业编' AND status in ('在职', '报到中'))
-[:person_to_org*1..1]->
(org:/univ_demo/org WHERE dept_sort_name = '学术期刊'), 
(person:/univ_demo/person WHERE person_sort = '事业编' AND status in ('在职', '报到中'))
-[:person_to_tech_duty*1..1]->
(tech_duty:/univ_demo/tech_duty WHERE duty = '教授' AND last_flag = '是')
RETURN person.id, org.id, tech_duty.id
-- RETURN person.name AS "person_name", person.account AS "person_account", org.name AS "org_name", person.sz_g AS "sz_g", tech_duty.duty AS "tech_duty", tech_duty.duty_level AS "duty_level", person.person_sort AS "person_sort", person.status AS "status", tech_duty.name AS "_univ_demo_tech_duty_name_0" WITH TIMEOUT = 6m
/**
output()
count(3)
**/
;


MATCH (person:/univ_demo/person WHERE person_sort = '事业编' AND status in ('在职', '报到中'))-[:person_to_org*1..1]->(org:/univ_demo/org WHERE dept_sort_name = '学术期刊'), (person:/univ_demo/person WHERE person_sort = '事业编' AND status in ('在 
职', '报到中'))-[:person_to_tech_duty*1..1]->(tech_duty:/univ_demo/tech_duty WHERE duty = '教授' AND last_flag = '是') 
/**
output()
match("graph.edges.len",6,"graph.nodes.len",8)
**/
;