Incorrect results

Bug #1668453 reported by jtgrassie
6
This bug affects 1 person
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.

Revision history for this message
jtgrassie (jtgrassie) wrote :

This is on 10.1.21. Tested on two separate machines.

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.