[MDEV-28199] spider/bugfix.mdev_26582, spider/bugfix.mdev_27184, spider/bugfix.mdev_27240 MTR tests fail Created: 2022-03-30  Updated: 2022-03-30

Status: Open
Project: MariaDB Server
Component/s: Storage Engine - Spider, Tests
Affects Version/s: 10.5.15
Fix Version/s: None

Type: Bug Priority: Major
Reporter: Timofey Turenko Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: None


 Description   

tested only with 10.5.15

CURRENT_TEST: spider/bugfix.mdev_26582
mysqltest: At line 17: query 'INSERT INTO t VALUES (0)' failed with wrong errno 1227: 'Access denied; you need (at least one of) the SUPER privilege(s) for this operation', instead of 1429...
 
The result from queries just before the failure was:
#
# MDEV-26582 SIGSEGV in spider_db_bulk_insert and spider_db_connect and spider_db_before_query, and hang in "End of update loop" / "Reset for next command" query states
#
CREATE DATABASE IF NOT EXISTS auto_test_local;
USE auto_test_local;
CREATE TABLE t (i CHAR) ENGINE=SPIDER;
INSERT INTO t VALUES (0);


Generated at Thu Feb 08 09:58:51 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.