--disable_query_log

--disable_result_log

--source ../t/test_init.inc

--enable_result_log

--enable_query_log

CREATE DATABASE auto_test_local;

USE auto_test_local;

CREATE TABLE m1 (c1 INT) ENGINE=SPIDER PARTITION BY LIST COLUMNS (c1) (PARTITION p1 DEFAULT ENGINE=SPIDER);

--error 1429

SHOW TABLE STATUS;

--error 1429

CREATE TEMPORARY TABLE m2 ENGINE=SPIDER PARTITION BY LIST COLUMNS (c1) (PARTITION p1 DEFAULT ENGINE=SPIDER);

--error 1429

SHOW TABLE STATUS;

SELECT SLEEP(10);

--error 1429

SHOW TABLE STATUS;

DROP DATABASE auto_test_local;

--disable_query_log

--disable_result_log

--source ../t/test_deinit.inc

--enable_result_log

--enable_query_log

INSTALL PLUGIN spider SONAME 'ha_spider.so';

CREATE TABLE t1 (c0 INT,UNIQUE (c0) USING HASH) ENGINE=SPIDER;

INSERT DELAYED INTO t1 VALUES (0);

invalid;

SELECT SLEEP (1);

SIGSEGV|spider_db_connect|spider_db_conn_queue_action|spider_db_before_query|spider_db_set_names_internal

DROP DATABASE test;

CREATE DATABASE test;

USE test;

INSTALL PLUGIN spider SONAME 'ha_spider.so';

SET sql_mode='';

SET SESSION enforce_storage_engine=spider;

CREATE TABLE t1 (id INT) ENGINE=SEQUENCE;

SET SESSION profiling=ON;

SELECT * FROM t2;

SHOW CREATE TABLE t1;

SET GLOBAL table_open_cache=-1;

CREATE TEMPORARY TABLE t1 (a INT) ENGINE=MyISAM;

SHOW CREATE TABLE t1;

SELECT partition_name, table_rows FROM information_schema.PARTITIONS WHERE table_name='t1';

SELECT * FROM t1;

SELECT SLEEP;

Core was generated by `/test/MD140222-mariadb-10.9.0-linux-x86_64-opt/bin/mysqld --no-defaults --core-'.

Program terminated with signal SIGSEGV, Segmentation fault.

#0  __strcmp_avx2 () at ../sysdeps/x86_64/multiarch/strcmp-avx2.S:101

[Current thread is 1 (Thread 0x1514fc1e0700 (LWP 542695))]

(gdb) bt

#0  __strcmp_avx2 () at ../sysdeps/x86_64/multiarch/strcmp-avx2.S:101

#1  0x00001515041633d4 in spider_db_mbase::connect (this=0x1513a807b360, tgt_host=<optimized out>, tgt_username=0x1513a80324f8 "\300y\f\250\023\025", tgt_password=0x6e753c0073656c62 <error: Cannot access memory at address 0x6e753c0073656c62>, tgt_port=3306, tgt_socket=0x1513a804f4f8 "/tmp/mysql.sock", server_name=0x1513a801afe8 "PX\n\250\023\025", connect_retry_count=0, connect_retry_interval=1000) at /test/10.9_opt/storage/spider/spd_db_mysql.cc:1947

#2  0x00001515040f0319 in spider_db_connect (share=0x1513a8051c78, conn=conn@entry=0x1513a80e4858, link_idx=0) at /test/10.9_opt/storage/spider/spd_db_conn.cc:149

#3  0x00001515040f0fe8 in spider_db_conn_queue_action (conn=0x1513a80e4858) at /test/10.9_opt/storage/spider/spd_db_conn.cc:264

#4  0x00001515040f72b0 in spider_db_before_query (conn=0x1513a80e4858, need_mon=<optimized out>) at /test/10.9_opt/storage/spider/spd_db_conn.cc:587

#5  0x00001515040f74c2 in spider_db_set_names_internal (trx=0x1513a809c0b8, share=0x1513a806e218, conn=conn@entry=0x1513a80e4858, all_link_idx=0, need_mon=0x1513a8045da8) at /test/10.9_opt/storage/spider/spd_db_conn.cc:814

#6  0x00001515040f7679 in spider_db_set_names (spider=<optimized out>, conn=conn@entry=0x1513a80e4858, link_idx=link_idx@entry=0) at /test/10.9_opt/storage/spider/spd_db_conn.cc:858

#7  0x0000151504168b27 in spider_mbase_handler::show_table_status (this=0x1513a8057950, link_idx=<optimized out>, sts_mode=1, flag=<optimized out>) at /test/10.9_opt/storage/spider/spd_db_mysql.cc:14047

#8  0x00001515041231a1 in spider_get_sts (share=0x1513a806e218, link_idx=0, tmp_time=tmp_time@entry=1645424679, spider=spider@entry=0x1513a8041150, sts_interval=sts_interval@entry=0, sts_mode=sts_mode@entry=1, sts_sync=sts_sync@entry=0, sts_sync_level=1, flag=82) at /test/10.9_opt/storage/spider/spd_table.cc:7260

#9  0x0000151504156c8d in ha_spider::info (this=0x1513a8041150, flag=18) at /test/10.9_opt/storage/spider/ha_spider.cc:7091

#10 0x000055a73226878a in make_join_statistics (keyuse_array=0x1513a8012228, tables_list=@0x1513a8010b58: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x1513a80124c0, last = 0x1513a80124c0, elements = 1}, <No data fields>}, join=0x1513a8011f08) at /test/10.9_opt/sql/sql_select.cc:5236

#11 JOIN::optimize_inner (this=0x1513a8011f08) at /test/10.9_opt/sql/sql_select.cc:2466

#12 0x000055a73226af83 in JOIN::optimize (this=this@entry=0x1513a8011f08) at /test/10.9_opt/sql/sql_select.cc:1808

#13 0x000055a73226b06e in mysql_select (thd=0x1513a8000c58, tables=0x1513a8010f18, fields=@0x1513a8010be0: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x1513a8010ed0, last = 0x1513a8010ed0, elements = 1}, <No data fields>}, conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=<optimized out>, result=0x1513a8011ee0, unit=0x1513a8004ea8, select_lex=0x1513a8010940) at /test/10.9_opt/sql/sql_select.cc:4993

#14 0x000055a73226b877 in handle_select (thd=thd@entry=0x1513a8000c58, lex=lex@entry=0x1513a8004dd0, result=result@entry=0x1513a8011ee0, setup_tables_done_option=setup_tables_done_option@entry=0) at /test/10.9_opt/sql/sql_select.cc:543

#15 0x000055a7321ec301 in execute_sqlcom_select (thd=0x1513a8000c58, all_tables=0x1513a8010f18) at /test/10.9_opt/sql/sql_parse.cc:6252

#16 0x000055a7321fa62e in mysql_execute_command (thd=0x1513a8000c58, is_called_from_prepared_stmt=<optimized out>) at /test/10.9_opt/sql/sql_parse.cc:3943

#17 0x000055a7321e7086 in mysql_parse (thd=0x1513a8000c58, rawbuf=<optimized out>, length=<optimized out>, parser_state=<optimized out>) at /test/10.9_opt/sql/sql_parse.cc:8027

#18 0x000055a7321f3235 in dispatch_command (command=COM_QUERY, thd=0x1513a8000c58, packet=<optimized out>, packet_length=<optimized out>, blocking=<optimized out>) at /test/10.9_opt/sql/sql_class.h:1362

#19 0x000055a7321f5427 in do_command (thd=0x1513a8000c58, blocking=blocking@entry=true) at /test/10.9_opt/sql/sql_parse.cc:1402

#20 0x000055a732314d77 in do_handle_one_connection (connect=<optimized out>, put_in_cache=true) at /test/10.9_opt/sql/sql_connect.cc:1418

#21 0x000055a7323150bd in handle_one_connection (arg=arg@entry=0x55a734c35908) at /test/10.9_opt/sql/sql_connect.cc:1312

#22 0x000055a73268e7b1 in pfs_spawn_thread (arg=0x55a7345af108) at /test/10.9_opt/storage/perfschema/pfs.cc:2201

#23 0x00001515239ea609 in start_thread (arg=<optimized out>) at pthread_create.c:477

#24 0x00001515235d8293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95

SIGSEGV|ha_spider::index_read_map_internal|ha_spider::index_read_map|handler::ha_index_read_map|handler::check_duplicate_long_entry_key

INSTALL PLUGIN spider SONAME 'ha_spider.so';

CREATE TABLE t1 (c0 INT,UNIQUE (c0) USING HASH) ENGINE=SPIDER;

INSERT DELAYED INTO t1 VALUES (0);

invalid;

SELECT SLEEP (1);

DROP TABLE t1;

mysqld: ../nptl/pthread_mutex_lock.c:81: __pthread_mutex_lock: Assertion `mutex->__data.__owner == 0' failed.

Core was generated by `/test/MD160322-mariadb-10.4.25-linux-x86_64-opt/bin/mysqld --no-defaults --core'.

Program terminated with signal SIGABRT, Aborted.

#0  __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50

[Current thread is 1 (Thread 0x14a190191700 (LWP 3430199))]

(gdb) bt

#0  __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50

#1  0x000014a1b83bd859 in __GI_abort () at abort.c:79

#2  0x000014a1b83bd729 in __assert_fail_base (fmt=0x14a1b8553588 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=0x14a1b88dd62d "mutex->__data.__owner == 0", file=0x14a1b88dd5fa "../nptl/pthread_mutex_lock.c", line=81, function=<optimized out>) at assert.c:92

#3  0x000014a1b83cefd6 in __GI___assert_fail (assertion=assertion@entry=0x14a1b88dd62d "mutex->__data.__owner == 0", file=file@entry=0x14a1b88dd5fa "../nptl/pthread_mutex_lock.c", line=line@entry=81, function=function@entry=0x14a1b88dd790 <__PRETTY_FUNCTION__.10174> "__pthread_mutex_lock") at assert.c:101

#4  0x000014a1b88d1164 in __GI___pthread_mutex_lock (mutex=mutex@entry=0x14a108060ca0) at ../nptl/pthread_mutex_lock.c:81

#5  0x000014a1a008626b in inline_mysql_mutex_lock (src_file=0x14a1a0118228 "/test/10.4_opt/storage/spider/spd_db_conn.cc", src_line=8300, that=0x14a108060ca0) at /test/10.4_opt/include/mysql/psi/mysql_thread.h:704

#6  spider_db_direct_delete (spider=spider@entry=0x14a108038e90, table=<optimized out>, delete_rows=delete_rows@entry=0x14a19018e2d8) at /test/10.4_opt/storage/spider/spd_db_conn.cc:8300

#7  0x000014a1a00d3317 in ha_spider::direct_delete_rows (this=0x14a108038e90, delete_rows=0x14a19018e2d8) at /test/10.4_opt/storage/spider/ha_spider.cc:11331

#8  0x000055b4dd049df3 in mysql_delete (thd=thd@entry=0x14a108000c48, table_list=0x14a1080100b0, conds=<optimized out>, order_list=order_list@entry=0x14a108005458, limit=18446744073709551615, options=0, result=0x0) at /test/10.4_opt/sql/sql_delete.cc:654

#9  0x000055b4dccdb0ea in mysql_execute_command (thd=0x14a108000c48) at /test/10.4_opt/sql/sql_parse.cc:4792

#10 0x000055b4dcce1257 in mysql_parse (thd=0x14a108000c48, rawbuf=<optimized out>, length=<optimized out>, parser_state=<optimized out>, is_com_multi=<optimized out>, is_next_command=<optimized out>) at /test/10.4_opt/sql/sql_parse.cc:7995

#11 0x000055b4dcce38cd in dispatch_command (command=COM_QUERY, thd=0x14a108000c48, packet=<optimized out>, packet_length=<optimized out>, is_com_multi=<optimized out>, is_next_command=<optimized out>) at /test/10.4_opt/sql/sql_class.h:1201

#12 0x000055b4dcce5f3e in do_command (thd=0x14a108000c48) at /test/10.4_opt/sql/sql_parse.cc:1373

#13 0x000055b4dcddbd3e in do_handle_one_connection (connect=connect@entry=0x55b4e0f6aad8) at /test/10.4_opt/sql/sql_connect.cc:1420

#14 0x000055b4dcddbe6f in handle_one_connection (arg=0x55b4e0f6aad8) at /test/10.4_opt/sql/sql_connect.cc:1316

#15 0x000014a1b88ce609 in start_thread (arg=<optimized out>) at pthread_create.c:477

#16 0x000014a1b84ba133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95

Core was generated by `/test/MD160322-mariadb-10.4.25-linux-x86_64-dbg/bin/mysqld --no-defaults --core'.

Program terminated with signal SIGSEGV, Segmentation fault.

#0  0x00005567e7dc0e1b in check_vcol_forward_refs (field=field@entry=

    0x153324015818, vcol=0x1533240158f0, 

    check_constraint=check_constraint@entry=false)

    at /test/10.4_dbg/sql/table.cc:3506

[Current thread is 1 (Thread 0x153369fa0700 (LWP 2924855))]

(gdb) bt

#0  0x00005567e7dc0e1b in check_vcol_forward_refs (field=field@entry=0x153324015818, vcol=0x1533240158f0, check_constraint=check_constraint@entry=false) at /test/10.4_dbg/sql/table.cc:3506

#1  0x00005567e7dc5add in parse_vcol_defs (thd=thd@entry=0x153324000d90, mem_root=0x153324006768, table=table@entry=0x153324014928, error_reported=error_reported@entry=0x153369f9d540, mode=mode@entry=VCOL_INIT_DEPENDENCY_FAILURE_IS_WARNING) at /test/10.4_dbg/sql/table.cc:1304

#2  0x00005567e7c7f1d4 in Delayed_insert::get_local_table (this=this@entry=0x153324082740, client_thd=client_thd@entry=0x153324000d90) at /test/10.4_dbg/sql/sql_insert.cc:2673

#3  0x00005567e7c87f6e in delayed_get_table (table_list=0x153324013320, grl_protection_request=0x153369f9d690, thd=0x153324000d90) at /test/10.4_dbg/sql/sql_insert.cc:2502

#4  open_and_lock_for_insert_delayed (thd=thd@entry=0x153324000d90, table_list=table_list@entry=0x153324013320) at /test/10.4_dbg/sql/sql_insert.cc:573

#5  0x00005567e7c88655 in mysql_insert (thd=thd@entry=0x153324000d90, table_list=0x153324013320, fields=@0x153324005ba0: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x5567e9297cc0 <end_of_list>, last = 0x153324005ba0, elements = 0}, <No data fields>}, values_list=@0x153324005be8: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x153324013f38, last = 0x153324013f38, elements = 1}, <No data fields>}, update_fields=@0x153324005bd0: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x5567e9297cc0 <end_of_list>, last = 0x153324005bd0, elements = 0}, <No data fields>}, update_values=@0x153324005bb8: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x5567e9297cc0 <end_of_list>, last = 0x153324005bb8, elements = 0}, <No data fields>}, duplic=DUP_ERROR, ignore=false) at /test/10.4_dbg/sql/sql_insert.cc:759

#6  0x00005567e7cc4f3f in mysql_execute_command (thd=thd@entry=0x153324000d90) at /test/10.4_dbg/sql/sql_parse.cc:4598

#7  0x00005567e7cccd01 in mysql_parse (thd=thd@entry=0x153324000d90, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x153369f9f490, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /test/10.4_dbg/sql/sql_parse.cc:7995

#8  0x00005567e7ccf75d in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x153324000d90, packet=packet@entry=0x15332401a361 "INSERT DELAYED INTO t1 VALUES (0)", packet_length=packet_length@entry=33, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /test/10.4_dbg/sql/sql_class.h:1201

#9  0x00005567e7cd3050 in do_command (thd=0x153324000d90) at /test/10.4_dbg/sql/sql_parse.cc:1373

#10 0x00005567e7e12457 in do_handle_one_connection (connect=connect@entry=0x5567eaa53150) at /test/10.4_dbg/sql/sql_connect.cc:1420

#11 0x00005567e7e12576 in handle_one_connection (arg=0x5567eaa53150) at /test/10.4_dbg/sql/sql_connect.cc:1316

#12 0x00001533907d4609 in start_thread (arg=<optimized out>) at pthread_create.c:477

#13 0x00001533903c0133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95

ERROR 1478 (HY000): Table storage engine 'SPIDER' does not support the create option 'TEMPORARY'