--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;

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/