What is the syntax for DELETE in OQGRAPH?

I am trying out OQGRAPH and one of the things I need to be able to do is DELETE an edge that is no longer valid. I could not find an example of the syntax of DELETE but the obvious syntax didn't seem to work. Here is what I did.

mysql> CREATE TABLE graph (
latch SMALLINT UNSIGNED NULL,
origid BIGINT UNSIGNED NULL,
destid BIGINT UNSIGNED NULL,
weight DOUBLE NULL,
seq BIGINT UNSIGNED NULL,
linkid BIGINT UNSIGNED NULL,
KEY (latch, origid, destid) USING HASH,
KEY (latch, destid, origid) USING HASH
) ENGINE=OQGRAPH;

mysql> INSERT INTO graph (origid,destid) VALUES
(1,2),(2,1),
(1,3),(3,1),
(3,4),(4,3),
(3,5),(5,3),
(5,6),(6,5);

Then I tried to delete one of the edges using the origid and destid and I get the following error message:

mysql> DELETE FROM graph WHERE origid=1 AND destid=2;
ERROR 1032 (HY000): Can't find record in 'graph'

Is there some other syntax that I should be using for DELETE?

it's a bug.

Hi Dan,

Antony was looking at this, and found a typo in the code that equates to a bug in this scenario. Thanks for catching. Fix soon.

Which package are you using, or are you compiling?

Regards,
Arjen.

Any progress on this? DELETE

Any progress on this? DELETE is basically unusable.

mysql> select @@version;
+------------------------------+
| @@version |
+------------------------------+
| 5.0.86-d10-ourdelta-sail-log |
+------------------------------+
1 row in set (0.00 sec)

old

That was the trial build, 5.0.87 has been out for a while now, have you tried that?

I Have the same problem under

I Have the same problem under 5.0.87-d10-ourdelta-sail66

I'm having the same issue

I'm having the same issue running under Maria 5.1.42 with the graph engine built from source. Is the fix present in the source on Launchpad?

OQGRAPH build

I am using the OurDelta 5.0.86-d10-Sail sources/binaries with OQGRAPH Engine.

On a related note, I tried doing TRUNCATE TABLE and got an error as well.

yep but not quite

Not actually related. We've changed things so truncate maps to delete now, and works.
Shodld be in the next builds.