--source include/have_innodb.inc

INSTALL SONAME 'ha_oqgraph';

SET innodb_snapshot_isolation= ON;

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

INSERT INTO oq_backing (origid, destid) VALUES (170, 241);

XA START 'x';

SELECT * FROM oq_backing;

--connect (con2,localhost,root,,)

INSERT INTO oq_backing (origid, destid) VALUES (23632, 49079);

--connection default

INSERT IGNORE INTO oq_backing (origid, destid) SELECT origid, destid FROM oq;

# Cleanup

XA END 'x';

XA ROLLBACK 'x';

DROP TABLE oq, oq_backing;

UNINSTALL SONAME 'ha_oqgraph';

mariadbd: /data/bld/10.6-asan/sql/sql_error.h:1066: uint Diagnostics_area::sql_errno() const: Assertion `m_status == DA_ERROR' failed.

250216 22:45:10 [ERROR] /share8t/bld/10.6-asan/sql/mariadbd got signal 6 ;

#9  0x00007f1646e53eb2 in __GI___assert_fail (assertion=0x55975ce2cfa0 "m_status == DA_ERROR", file=0x55975ce2cee0 "/data/bld/10.6-asan/sql/sql_error.h", line=1066, function=0x55975ce2cfe0 "uint Diagnostics_area::sql_errno() const") at ./assert/assert.c:101

#10 0x000055975aa5a274 in Diagnostics_area::sql_errno (this=0x62b0000c31f0) at /data/bld/10.6-asan/sql/sql_error.h:1066

#11 0x000055975b5d6f7e in ha_rollback_trans (thd=0x62b0000bd218, all=true) at /data/bld/10.6-asan/sql/handler.cc:2337

#12 0x000055975b1f43a5 in trans_rollback_implicit (thd=0x62b0000bd218) at /data/bld/10.6-asan/sql/transaction.cc:445

#13 0x000055975ad491ab in mysql_execute_command (thd=0x62b0000bd218, is_called_from_prepared_stmt=false) at /data/bld/10.6-asan/sql/sql_parse.cc:6251

#14 0x000055975ad5595a in mysql_parse (thd=0x62b0000bd218, rawbuf=0x62d0000a0438 "INSERT IGNORE INTO oq_backing (origid, destid) SELECT origid, destid FROM oq", length=76, parser_state=0x7f1637fcea90) at /data/bld/10.6-asan/sql/sql_parse.cc:8209

#15 0x000055975ad2ad4d in dispatch_command (command=COM_QUERY, thd=0x62b0000bd218, packet=0x629000276219 "INSERT IGNORE INTO oq_backing (origid, destid) SELECT origid, destid FROM oq", packet_length=76, blocking=true) at /data/bld/10.6-asan/sql/sql_parse.cc:1908

#16 0x000055975ad27a81 in do_command (thd=0x62b0000bd218, blocking=true) at /data/bld/10.6-asan/sql/sql_parse.cc:1421

#17 0x000055975b1ac517 in do_handle_one_connection (connect=0x608000014ab8, put_in_cache=true) at /data/bld/10.6-asan/sql/sql_connect.cc:1386

#18 0x000055975b1ac076 in handle_one_connection (arg=0x608000014a38) at /data/bld/10.6-asan/sql/sql_connect.cc:1298

#19 0x000055975be26414 in pfs_spawn_thread (arg=0x617000007e98) at /data/bld/10.6-asan/storage/perfschema/pfs.cc:2201

#20 0x00007f1646ea81c4 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442

#21 0x00007f1646f2885c in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:81

INSERT IGNORE INTO oq_backing (origid, destid) SELECT origid, destid FROM oq;

Warnings:

Warning	1062	Duplicate entry '170-241' for key 'PRIMARY'