oqgraphv3. Read only but no updates from basetable
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
OQGRAPH |
Fix Committed
|
High
|
Antony T Curtis |
Bug Description
Moin,
MariaDB [test]> select * from information_
*******
PLUGIN_
PLUGIN_
PLUGIN_
PLUGIN_
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?)
Related branches
- Maria-captains: Pending requested
Curious. thanks for your report!
I think Antony put in a bit of caching to speed up operations, and obviously those need to be invalidated when the underlying table changes. I've assigned this issue to Antony to take a look and see what might be going on.