maria-developers team mailing list archive

[Ian Gilfillan <ian@xxxxxxxxxxx>]

Hi

I have been struggling to get OQGRAPH working with MariaDB 10.0.7. The 
system has been hanging and crashing frequently. I will post as bugs if 
I can recreate them, but this question is simply, how can I update the data?

On a new install of MariaDB 10.0.7 and OQGRAPH
- I create the sample tables at 
https://mariadb.com/kb/en/oqgraph-examples/#creating-a-table-with-weight
- I then update the oq2_backing table. The changes reflect on the 
oq2_backing table, not the oq2_graph table:

UPDATE oq2_backing SET weight=4 WHERE origid=2 AND destid=6;

SELECT * FROM oq2_backing;
+--------+--------+--------+
| origid | destid | weight |
+--------+--------+--------+
|      1 |      2 |      1 |
|      2 |      3 |      1 |
|      2 |      6 |      4 |
|      3 |      4 |      3 |
|      4 |      5 |      1 |
|      5 |      6 |      2 |
+--------+--------+--------+


SELECT * FROM oq2_graph;
+-------+--------+--------+--------+------+--------+
| latch | origid | destid | weight | seq  | linkid |
+-------+--------+--------+--------+------+--------+
| NULL  |      1 |      2 |      1 | NULL |   NULL |
| NULL  |      2 |      3 |      1 | NULL |   NULL |
| NULL  |      2 |      6 |     10 | NULL |   NULL |
| NULL  |      3 |      4 |      3 | NULL |   NULL |
| NULL  |      4 |      5 |      1 | NULL |   NULL |
| NULL  |      5 |      6 |      2 | NULL |   NULL |
+-------+--------+--------+--------+------+--------+


How can I make changes that reflect on the table?

thanks,
ian