worker[01] Using MTR_BUILD_THREAD 300, with reserved ports 19000..19029

INSTALL SONAME 'ha_spider';

Warnings:

Warning	1105	Cannot enable tc-log at run-time. XA features of SPIDER are disabled

CREATE TABLE t (c INT) ENGINE=Spider PARTITION BY KEY(c) (PARTITION p);

UNINSTALL SONAME IF EXISTS 'ha_spider';

Warnings:

Warning	1620	Plugin is busy and will be uninstalled on shutdown

INSERT INTO t SELECT 1;

main.test                                [ fail ]

        Test ended at 2024-06-19 13:34:35

CURRENT_TEST: main.test

mysqltest: At line 5: query 'INSERT INTO t SELECT 1' failed: ER_UNKNOWN_STORAGE_ENGINE (1286): Unknown storage engine 'SPIDER'

11.2.5-dbg>INSTALL SONAME 'ha_spider';

Query OK, 0 rows affected (0.754 sec)

11.2.5-dbg>CREATE TABLE t (c INT) ENGINE=Spider PARTITION BY KEY(c) (PARTITION p);

Query OK, 0 rows affected (0.005 sec)

11.2.5-dbg>UNINSTALL SONAME IF EXISTS 'ha_spider';

Query OK, 0 rows affected, 1 warning (0.001 sec)

11.2.5-dbg>SHOW WARNINGS;

+---------+------+----------------------------------------------------+

| Level   | Code | Message                                            |

+---------+------+----------------------------------------------------+

| Warning | 1620 | Plugin is busy and will be uninstalled on shutdown |

+---------+------+----------------------------------------------------+

1 row in set (0.000 sec)

11.2.5-dbg>INSERT INTO t SELECT 1;

ERROR 1286 (42000): Unknown storage engine 'SPIDER'

22ba7e4ff823f71d99cba78ef58a867931874bad is the first bad commit

commit 22ba7e4ff823f71d99cba78ef58a867931874bad

Merge: a960e95febd 5ba542e9eec

Author: Marko Mäkelä <marko.makela@mariadb.com>

Date:   Thu May 30 16:04:00 2024 +0300

    Merge 10.6 into 10.11

modified   sql/sql_parse.cc

@@ -7446,6 +7446,10 @@ check_stack_overrun(THD *thd, long margin, uchar *buf __attribute__((unused)))

 {

   long stack_used;

   DBUG_ASSERT(thd == current_thd);

+#ifdef __SANITIZE_ADDRESS__

+  return 0;

+#endif

+

   if ((stack_used= available_stack_size(thd->thread_stack, &stack_used)) >=

       (long) (my_thread_stack_size - margin))

   {

b4897145d8b upstream/bb-10.11-mdev-34421 MDEV-34421 Check the SQL command when resolving storage engine

[Revision 2350d2bf166740ccbd13be2f429f4ee18e31ad78]

Author: Yuchen Pei <ycp@mariadb.com>

Date: 2024-06-21 Fri 19:37:00 +08

MDEV-34421 Check the SQL command when resolving storage engine

ENGINE_SUBSTITUTION only applies to CREATE TABLE and ALTER TABLE, and

Storage_engine_name::resolve_storage_engine_with_error() could be

called when executing any sql command.

--source include/have_partition.inc

SET sql_mode='';

INSTALL SONAME 'ha_spider';

CREATE SERVER s FOREIGN DATA WRAPPER MYSQL OPTIONS (HOST 'LOCALHOST', DATABASE 'test', USER 'Spider', PASSWORD '', SOCKET '../socket.sock');

CREATE TABLE t (pKEY INT NOT NULL, PRIMARY KEY(pKEY)) ENGINE=Spider COMMENT='TABLE "t"' PARTITION BY KEY(pKEY) (PARTITION pt1 COMMENT='SRV "s"', PARTITION pt2 COMMENT='SRV "s"', PARTITION pt3 COMMENT='SRV "s"');

UNINSTALL SONAME IF EXISTS "ha_spider";

SELECT * FROM t ORDER BY id;

SET sql_mode='';

INSTALL PLUGIN Spider SONAME 'ha_spider.so';

CREATE TABLE t (a INT,KEY(a)) ENGINE=Spider;

UNINSTALL SONAME IF EXISTS 'ha_spider';

ALTER TABLE t ENGINE=Spider PARTITION BY KEY(a) (PARTITION p0 ENGINE=Spider);

SIGSEGV|parse_engine_part_options|open_table_from_share|ha_create_table|mysql_alter_table

UBSAN|member access within null pointer of type 'struct handlerton'|sql/create_options.cc|parse_engine_part_options|open_table_from_share|ha_create_table|mysql_alter_table

UBSAN|member access within null pointer of type 'struct handlerton'|sql/create_options.cc|parse_engine_part_options|open_table_from_share|open_table|open_and_process_table