BIND语句失效排查：总高度计算无输出，疑查询引擎问题？

我有一个长查询，相关部分如下：

SELECT DISTINCT ... (concat(?height_statue_in_meters, ' m (', ?height_statue_in_feet, ' ft)') AS ?height_of_statue) (concat(?total_height_in_meters, ' m (', ?total_height_in_feet, ' ft)') AS ?total_height) ...
WHERE { 
...
BIND(coalesce(?height_statue_m, ?height_statue_m_calc) AS ?height_statue_in_meters)
BIND(coalesce(?height_statue_ft, ?height_statue_ft_calc) AS ?height_statue_in_feet)
BIND(coalesce(?height_pedestal_m, ?height_pedestal_m_calc) AS ?height_pedestal_in_meters)
BIND(coalesce(?height_pedestal_ft, ?height_pedestal_ft_calc) AS ?height_pedestal_in_feet)
BIND(( ?height_statue_in_meters + ?height_pedestal_in_meters ) AS ?total_height_in_meters)
BIND(( ?height_statue_in_feet + ?height_pedestal_in_feet ) AS ?total_height_in_feet)
} ...

前四条BIND语句通过coalesce获取现有高度值（米/英尺）或转换计算值，?height_of_statue能正常输出正确结果，但最后两条计算总高度的BIND语句导致?total_height为空，移除concat()或调整BIND顺序都没解决问题，怀疑是查询引擎问题或自己有疏漏。

排查思路及解决方法 #

• 空值加法导致结果为空：SPARQL中只要加法表达式里有一个变量是空值，整个计算结果就会为空。哪怕?height_of_statue正常，也不代表基座高度变量一定有值（比如部分雕像没有基座数据）。可以给空值设置默认值0：

  BIND((coalesce(?height_statue_in_meters, 0) + coalesce(?height_pedestal_in_meters, 0)) AS ?total_height_in_meters)
  BIND((coalesce(?height_statue_in_feet, 0) + coalesce(?height_pedestal_in_feet, 0)) AS ?total_height_in_feet)
  

• 数据类型不匹配：检查?height_statue_in_meters和?height_pedestal_in_meters是否都是数值类型（如xsd:decimal、xsd:float）。如果其中一个是字符串类型，加法会返回空值。可以显式转换类型：

  BIND((xsd:decimal(?height_statue_in_meters) + xsd:decimal(?height_pedestal_in_meters)) AS ?total_height_in_meters)
  BIND((xsd:decimal(?height_statue_in_feet) + xsd:decimal(?height_pedestal_in_feet)) AS ?total_height_in_feet)
  

• 查询引擎变量作用域异常：少数情况下，引擎对BIND的顺序处理可能有问题。可以用子查询先确定所有基础高度值，再在外部计算总和：

  SELECT DISTINCT ... (concat(?height_statue_in_meters, ' m (', ?height_statue_in_feet, ' ft)') AS ?height_of_statue) (concat(?total_height_in_meters, ' m (', ?total_height_in_feet, ' ft)') AS ?total_height) ...
  WHERE {
    {
      SELECT ... ?height_statue_m ?height_statue_m_calc ?height_statue_ft ?height_statue_ft_calc ?height_pedestal_m ?height_pedestal_m_calc ?height_pedestal_ft ?height_pedestal_ft_calc ...
      WHERE { ... }
    }
    BIND(coalesce(?height_statue_m, ?height_statue_m_calc) AS ?height_statue_in_meters)
    BIND(coalesce(?height_statue_ft, ?height_statue_ft_calc) AS ?height_statue_in_feet)
    BIND(coalesce(?height_pedestal_m, ?height_pedestal_m_calc) AS ?height_pedestal_in_meters)
    BIND(coalesce(?height_pedestal_ft, ?height_pedestal_ft_calc) AS ?height_pedestal_in_feet)
    BIND(( ?height_statue_in_meters + ?height_pedestal_in_meters ) AS ?total_height_in_meters)
    BIND(( ?height_statue_in_feet + ?height_pedestal_in_feet ) AS ?total_height_in_feet)
  } ...
  

内容的提问来源于stack exchange，提问作者xhgf5