odbtools/odbctest/mql/uino/108.一跳关系错误.mql

MATCH 
(contract:/mingdao1/contract WHERE attr15 > 34500 and attr15 < 35500)
-[:is_contract_of_project*1..1]->
(project:/mingdao1/project WHERE attr3 is not null), 
(sales:/mingdao1/staff)
-[:is_duty_sales_of_contract*1..1]->
(contract), 
(pm:/mingdao1/staff)
-[:is_admin_of_project*1..1]->
(project:/mingdao1/project WHERE attr3 is not null) 
/**
output()
match('graph.edges.len', 103)
match('graph.nodes.len', 82)
**/
;

MATCH 
(contract:/mingdao1/contract WHERE attr15 > 34500 and attr15 < 35500)
-[:is_contract_of_project*1..1]->
(project:/mingdao1/project WHERE attr3 is not null), 
(sales:/mingdao1/staff)
-[:is_duty_sales_of_contract*1..1]->
(contract:/mingdao1/contract WHERE attr15 > 34500 and attr15 < 35500), 
(pm:/mingdao1/staff)
-[:is_admin_of_project*1..1]->
(project:/mingdao1/project WHERE attr3 is not null) 
RETURN project.attr3 AS "项目名称", sales.attr1 AS "责任销售", pm.attr1 AS "项目经理名称"
with timeout = 3m
/**
output()
count(43)
**/
;

MATCH
(building_partition:/hxyy/building_partition where id='building_partition:2b4e32dd-49c2-4de8-a7e9-b91eaf5d605f')
-[:building_partition_unique_number_to_floor_superior_space_number]->
(floor:/hxyy/floor)
RETURN building_partition.id, floor.id, _.path
/**
timeout(10m)
output()
**/
;

MATCH (company:/dsq_stock/public_company)
-[:public_company_belongs_to_industry_stock_industry_category_lv3*1..1]->
(industry_lv3:/dsq_stock/stock_industry_category_lv3 WHERE name like '*游戏*'), 
(company:/dsq_stock/public_company where id like "*")
-[:public_company_to_a_stock_price*1..1]->
(price:/dsq_stock/a_stock_price WHERE trade_date = '20250718') 
RETURN company.name AS "上市公司名称", company.symbol AS "股票代码", price.close_price AS "收盘价", price.pe AS "PE" 
WITH TIMEOUT = 6m
/**
output()
count(26)
**/;

MATCH (building:/hxyy/building WHERE name = '转化医学综合楼')
-[:building_unique_number_to_building_partition_superior_space_number]->
(building_partition:/hxyy/building_partition)
-[:building_partition_unique_number_to_floor_superior_space_number]->
(floor:/hxyy/floor)
-[:floor_unique_number_to_floor_partition_superior_space_number]->
(floor_partition:/hxyy/floor_partition)
-[:floor_partition_unique_number_to_function_partition_superior_space_number]->
(function_partition:/hxyy/function_partition) 
/**
output()
**/;


MATCH (building:/hxyy/building WHERE name = '转化医学综合楼')
-[:building_unique_number_to_building_partition_superior_space_number]->
(building_partition:/hxyy/building_partition)
RETURN building.id, building_partition.id AS "building_partition.id" 
/**
timeout(100m)
output()
**/
;

MATCH
(building_partition:/hxyy/building_partition where id='building_partition:2b4e32dd-49c2-4de8-a7e9-b91eaf5d605f')
-[:building_partition_unique_number_to_floor_superior_space_number]->
(floor:/hxyy/floor)
RETURN building_partition.id, floor.id
/**
timeout(10m)
output()
**/
;

MATCH
(floor:/hxyy/floor where id='floor:9cfd6164-041b-4a61-abf8-5c6c67d91be9')
-[:floor_unique_number_to_floor_partition_superior_space_number]->
(floor_partition:/hxyy/floor_partition)
RETURN floor.id, floor_partition.id
/**
timeout(10m)
output()
**/
;

MATCH
(floor_partition:/hxyy/floor_partition where id='floor_partition:e9cba216-30e4-4d6d-88ff-fb67bea8d863')
-[:floor_partition_unique_number_to_function_partition_superior_space_number]->
(function_partition:/hxyy/function_partition) 
RETURN  floor_partition.id, function_partition.id
/**
timeout(10m)
output()
**/
;

MATCH (building:/hxyy/building WHERE name = '转化医学综合楼')
-[:building_unique_number_to_building_partition_superior_space_number]->
(building_partition:/hxyy/building_partition)
-[:building_partition_unique_number_to_floor_superior_space_number]->
(floor:/hxyy/floor)
-[:floor_unique_number_to_floor_partition_superior_space_number]->
(floor_partition:/hxyy/floor_partition)
-[:floor_partition_unique_number_to_function_partition_superior_space_number]->
(function_partition:/hxyy/function_partition) 
/**
timeout(10m)
output()
**/;

MATCH (building:/hxyy/building WHERE name = '转化医学综合楼')
-[:building_unique_number_to_building_partition_superior_space_number]->
(building_partition:/hxyy/building_partition)
-[:building_partition_unique_number_to_floor_superior_space_number]->
(floor:/hxyy/floor)
-[:floor_unique_number_to_floor_partition_superior_space_number]->
(floor_partition:/hxyy/floor_partition)
-[:floor_partition_unique_number_to_function_partition_superior_space_number]->
(function_partition:/hxyy/function_partition) 
RETURN function_partition.id AS "function_partition_id" 
WITH TIMEOUT = 6m
;

MATCH (building:/hxyy/building WHERE name = '转化医学综合楼')
-[:building_unique_number_to_building_partition_superior_space_number*1..1]->
(building_partition:/hxyy/building_partition)
-[:building_partition_unique_number_to_floor_superior_space_number*1..1]->
(floor:/hxyy/floor)
-[:floor_unique_number_to_floor_partition_superior_space_number*1..1]->
(floor_partition:/hxyy/floor_partition)
-[:floor_partition_unique_number_to_function_partition_superior_space_number*1..1]->
(function_partition:/hxyy/function_partition) 
RETURN function_partition.id AS "function_partition_id" 
INTO /t0_10010 
WITH TIMEOUT = 6m
;

{"sql":"SELECT count(t0.function_partition_id) AS \"功能区数\" FROM /t0_10010 t0 LIMIT 0, 20000"}

/**
output()
match("功能区数", 836)
**/;