Details
-
Bug
-
Status: Open (View Workflow)
-
Minor
-
Resolution: Unresolved
-
10.3(EOL), 10.4(EOL), 10.5, 10.6, 10.7(EOL), 10.8(EOL), 10.9(EOL), 10.10(EOL), 10.11
-
None
Description
--source include/have_innodb.inc
|
|
INSTALL SONAME 'ha_oqgraph'; |
|
CREATE TABLE oq_backing (origid INT UNSIGNED NOT NULL, destid INT UNSIGNED NOT NULL, PRIMARY KEY (origid, destid), KEY (destid)) ENGINE=InnoDB; |
CREATE TABLE oq (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='oq_backing' origid='origid' destid='destid'; |
SELECT * FROM oq WHERE latch = 1 AND destid = 35976; |
ALTER TABLE oq_backing ADD KEY ind1 (origid, destid); |
SELECT * FROM oq WHERE latch = 0; |
10.3 0ca3aaa7 |
SELECT * FROM oq WHERE latch = 0;
|
latch origid destid weight seq linkid
|
Warnings:
|
Warning 1082 InnoDB: Table test/oq_backing contains 3 indexes inside InnoDB, which is different from the number of indexes 2 defined in the MariaDB
|
bug.ref2 'innodb' [ fail ] Found warnings/errors in server log file!
|
Test ended at 2022-12-21 15:20:57
|
line
|
2022-12-21 15:20:56 9 [ERROR] InnoDB: Table test/oq_backing contains 3 indexes inside InnoDB, which is different from the number of indexes 2 defined in the MariaDB Have you mixed up .frm files from different installations? See https://mariadb.com/kb/en/innodb-troubleshooting/
|