The columns specified in the PATH function must be from the same table, have the same data type and that type must be Integer ...

The columns specified in the PATH function must be from the same table, have the same data type and that type must be Integer or Text. It is incorrect to reference the same column twice. The columns '%{table1/}'[%{column1/}] and '%{table2/}'[%{column2/}] do not satisfy these requirements.