Incorrect results
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
OQGRAPH |
New
|
Undecided
|
Unassigned |
Bug Description
For a query showing all possible destinations:
select g.*,a.text from graph g join atom a on a.id=g.linkid where g.latch='dijkstras' and g.origid=27;
+------
| latch | origid | destid | weight | seq | linkid | text |
+------
| dijkstras | 27 | NULL | 2 | 3 | 183 | rubber |
| dijkstras | 27 | NULL | 1 | 2 | 116 | tyres |
| dijkstras | 27 | NULL | 0 | 1 | 27 | wheels |
+------
Then querying for the path between 27 and 183:
select g.*,a.text from graph g join atom a on a.id=g.linkid where g.latch='dijkstras' and g.origid=27 and g.destid=183;
Empty set (0.00 sec)
No results.
Query cache disabled, restarted database, same problem.
This is on 10.1.21. Tested on two separate machines.