oqgraph-dev team mailing list archive

[Andrew McDonnell <bugs@xxxxxxxxxxxxxxxxxxx>]

Hi

what should a no_search latch return?

Given the data below, there is only one directed link between vertexes 1,2 and
one directed link between vertexes 2,1

So by my logic if you are looking for 'things' with a destid of vertex 2 and
and source vertext of 1 then only one row should be returned?

INSERT INTO graph_base(from_id, to_id) VALUES (1,2), (2,1);
INSERT INTO graph_base(from_id, to_id) VALUES (1,3), (3,1);
INSERT INTO graph_base(from_id, to_id) VALUES (3,4), (4,3);
INSERT INTO graph_base(from_id, to_id) VALUES (5,6), (6,5);

SELECT * FROM graph WHERE latch='no_search' and destid=2 and origid=1;

yields

latch	origid	destid	weight	seq	linkid
no_search	1	2	1	3	1
no_search	1	2	1	2	3
no_search	1	2	1	1	2


(And simlar for the integer latch equivalent)

latch	origid	destid	weight	seq	linkid
0	1	2	1	3	1
0	1	2	1	2	3
0	1	2	1	1	2

--Andrew