oqgraph-dev team mailing list archive

[Launchpad Bug Tracker <796647@xxxxxxxxxxxxxxxxxx>]

You have been subscribed to a public bug by Arjen Lentz (arjen-lentz):

Moin,
MariaDB [test]> select * from  information_schema.PLUGINS where PLUGIN_NAME="OQGRAPH"\G
*************************** 1. row ***************************
           PLUGIN_NAME: OQGRAPH
        PLUGIN_VERSION: 3.0
         PLUGIN_STATUS: ACTIVE
           PLUGIN_TYPE: STORAGE ENGINE
   PLUGIN_TYPE_VERSION: 50300.0
        PLUGIN_LIBRARY: ha_oqgraph.so
PLUGIN_LIBRARY_VERSION: 0.0
         PLUGIN_AUTHOR: Arjen Lentz & Antony T Curtis, Open Query
    PLUGIN_DESCRIPTION: Open Query Graph Computation Engine (http://openquery.com/graph)
        PLUGIN_LICENSE: GPL
       PLUGIN_MATURITY: Unknown
   PLUGIN_AUTH_VERSION: Unknown
MariaDB [test]> select version();
+---------------------+
| version()           |
+---------------------+
| 5.3.0-MariaDB-alpha |
+---------------------+

Its great you can use persistent tables to store the graph. A drawback with version v3 is if you chenge the base/persistent table it is ignored by the memory-table. Dropping/creating the memory-table is a workaround.
MariaDB [test]> desc base;
+--------+---------+------+-----+---------+-------+
| Field  | Type    | Null | Key | Default | Extra |
+--------+---------+------+-----+---------+-------+
| von    | int(11) | NO   | PRI | NULL    |       |
| nach   | int(11) | NO   | PRI | NULL    |       |
| weight | double  | NO   |     | NULL    |       |
+--------+---------+------+-----+---------+-------+
MariaDB [test]> desc graph; 
+--------+----------------------+------+-----+---------+-------+
| Field  | Type                 | Null | Key | Default | Extra |
+--------+----------------------+------+-----+---------+-------+
| latch  | smallint(5) unsigned | YES  | MUL | NULL    |       |
| origid | bigint(20) unsigned  | YES  |     | NULL    |       |
| destid | bigint(20) unsigned  | YES  |     | NULL    |       |
| weight | double               | YES  |     | NULL    |       |
| seq    | bigint(20) unsigned  | YES  |     | NULL    |       |
| linkid | bigint(20) unsigned  | YES  |     | NULL    |       |
+--------+----------------------+------+-----+---------+-------+

3 rows in the basetable:
MariaDB [test]> SELECT * FROM base;
+-----+------+--------+
| von | nach | weight |
+-----+------+--------+
|   3 |    5 |      2 |
|   5 |    4 |      1 |
|   5 |    6 |      1 |
+-----+------+--------+

and in the graph-table
MariaDB [test]> SELECT * from graph;
+-------+--------+--------+--------+------+--------+
| latch | origid | destid | weight | seq  | linkid |
+-------+--------+--------+--------+------+--------+
|  NULL |      3 |      5 |      2 | NULL |   NULL |
|  NULL |      5 |      4 |      1 | NULL |   NULL |
|  NULL |      5 |      6 |      1 | NULL |   NULL |
+-------+--------+--------+--------+------+--------+

but:
MariaDB [test]> insert into base values(6,3,1);
MariaDB [test]> SELECT * FROM base;
+-----+------+--------+
| von | nach | weight |
+-----+------+--------+
|   3 |    5 |      2 |
|   5 |    4 |      1 |
|   5 |    6 |      1 |
|   6 |    3 |      1 |
+-----+------+--------+

MariaDB [test]> SELECT * from graph;
+-------+--------+--------+--------+------+--------+
| latch | origid | destid | weight | seq  | linkid |
+-------+--------+--------+--------+------+--------+
|  NULL |      3 |      5 |      2 | NULL |   NULL |
|  NULL |      5 |      4 |      1 | NULL |   NULL |
|  NULL |      5 |      6 |      1 | NULL |   NULL |
+-------+--------+--------+--------+------+--------+

Is this going to be fixed?
Or a design-issue?

Regards
Erkan
(btw: why do I need keys on the base-table?)

** Affects: oqgraph
     Importance: Undecided
     Assignee: Antony T Curtis (atcurtis)
         Status: New

-- 
oqgraphv3. Read only but no updates from basetable
https://bugs.launchpad.net/bugs/796647
You received this bug notification because you are a member of OQgraph developers, which is subscribed to the bug report.