Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.0.10
-
None
-
CentOS 6
Description
I created an OQGraph table and pointed it to an existing MyISAM table that already contains data. Upon querying the OQGraph table I see
MariaDB [MidSchipDB_unstable]> SELECT * FROM version_history; |
ERROR 1017 (HY000): Can't find file: './MidSchipDB_unstable/db_history@=Cܹ' (errno: 2 "No such file or directory") |
My setup is:
MariaDB [MidSchipDB_unstable]> SHOW CREATE TABLE db_history \G |
Table: db_history |
Create Table: CREATE TABLE `db_history` ( |
`version` varchar(10) NOT NULL, |
`updateJSON` mediumtext,
|
`prevVersion` varchar(10) NOT NULL, |
`nodeID` bigint(20) unsigned NOT NULL DEFAULT '0', |
`prevNodeID` bigint(20) unsigned NOT NULL DEFAULT '0', |
PRIMARY KEY (`prevNodeID`,`nodeID`), |
KEY `prevVersion` (`prevVersion`) USING BTREE, |
KEY `version` (`version`) USING BTREE, |
KEY `nodeID` (`nodeID`) |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 |
1 row in set (0.00 sec) |
|
MariaDB [MidSchipDB_unstable]> SELECT COUNT(*) FROM db_history; |
+----------+ |
| COUNT(*) | |
+----------+ |
| 129 |
|
+----------+ |
1 row in set (0.00 sec) |
MariaDB [MidSchipDB_unstable]> CREATE TABLE IF NOT EXISTS version_history ( |
-> latch VARCHAR(32) 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
|
-> data_table='db_history' |
-> origid='prevNodeID' |
-> destid='nodeID'; |
Query OK, 0 rows affected (0.01 sec) |
Attachments
Issue Links
- relates to
-
MDEV-6014 Merge fixed OQGRAPH into 10.0 tree
- Closed