search

frostyfan109 / tranql

A Translator Query Language
https://researchsoftwareinstitute.github.io/data-translator/apps/tranql
MIT License
0 stars 1 forks source link

Weird query planner result #95

Closed frostyfan109 closed 5 years ago

frostyfan109 commented 5 years ago

When I run this query:

        SELECT drug_exposure->chemical_substance
         FROM '/schema'

I get the expected drug_exposure->chemical_substance and chemical_substance->drug_exposure from the implicit_conversion schema, but I also end up with a third statement: chemical_substance->chemical_substance from the robokop schema. I can't tell if this is unexpected behavior or intentional, and why it's happening.

frostyfan109 commented 5 years ago

It turns out it is (half) working. The chemical_substance->chemical_substance statement is the implicit conversion casting drug_exposure to chemical_substance, which then allows for the transition to be made.

The duplicates probably shouldn't be happening, but they aren't hurting anything so they can stay for now.