Details
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)
Gliffy Diagrams
Attachments
Issue Links
- relates to
-
MDEV-6014 Merge fixed OQGRAPH into 10.0 tree
-
- Closed
-
Activity
- All
- Comments
- Work Log
- History
- Activity
- Transitions
The culprit is the combination of length of the schema name and the table name. So, to reproduce the bug with the provided create table statements, it is important that you have a schema with the same name MidSchipDB_unstable, or a different name of the same length.