Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.6, 10.11, 11.4, 11.8, 12.0, 12.1
Description
CREATE TABLE t (a INT,b INT,PRIMARY KEY(a),INDEX (b))Engine=InnoDB; |
ALTER TABLE t CHANGE COLUMN a a BINARY (0); |
SELECT * FROM t WHERE b>-1; |
Leads to:
CS 12.1.0 6a2afb42ba86188ccda0972f9c2df363f34e10a0 (Optimized) Build 09/06/2025 |
Core was generated by `/test/MD090625-mariadb-12.1.0-linux-x86_64-opt/bin/mariadbd --no-defaults --max'.
|
Program terminated with signal SIGFPE, Arithmetic exception.
|
#0 0x000063b3feb57e72 in get_max_range_rowid_filter_elems_for_table (cont_type=SORTED_ARRAY_CONTAINER, thd=<optimized out>, tab=<optimized out>)at /test/12.1_opt/sql/rowid_filter.cc:337
|
 |
[Current thread is 1 (LWP 2997047)]
|
(gdb) bt
|
#0 0x000063b3feb57e72 in get_max_range_rowid_filter_elems_for_table (cont_type=SORTED_ARRAY_CONTAINER, thd=<optimized out>, tab=<optimized out>)at /test/12.1_opt/sql/rowid_filter.cc:337
|
#1 TABLE::init_cost_info_for_usable_range_rowid_filters (this=0x70e304027f08, thd=0x70e304000c68) at /test/12.1_opt/sql/rowid_filter.cc:387
|
#2 0x000063b3fe9b469e in make_join_statistics (join=join@entry=0x70e3040192b8, tables_list=@0x70e304017990: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x70e304019a70, last = 0x70e304019a70, elements = 1}, <No data fields>}, keyuse_array=keyuse_array@entry=0x70e304019610)at /test/12.1_opt/sql/sql_select.cc:6209
|
#3 0x000063b3fe9b06d1 in JOIN::optimize_inner (this=this@entry=0x70e3040192b8)at /test/12.1_opt/sql/sql_select.cc:2726
|
#4 0x000063b3fe9adb64 in JOIN::optimize (this=this@entry=0x70e3040192b8)at /test/12.1_opt/sql/sql_select.cc:2006
|
#5 0x000063b3fe9a7b82 in mysql_select (thd=thd@entry=0x70e304000c68, tables=<optimized out>, fields=@0x70e304017a30: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x70e304017d70, last = 0x70e304019cf0, elements = 2}, <No data fields>}, conds=<optimized out>, og_num=<optimized out>, order=<optimized out>, group=0x0, having=0x0, proc_param=0x0, select_options=<optimized out>, result=0x70e304019290, unit=0x70e304005080, select_lex=0x70e304017778)at /test/12.1_opt/sql/sql_select.cc:5376
|
#6 0x000063b3fe9a78a9 in handle_select (thd=thd@entry=0x70e304000c68, lex=lex@entry=0x70e304004fa0, result=result@entry=0x70e304019290, setup_tables_done_option=setup_tables_done_option@entry=0)at /test/12.1_opt/sql/sql_select.cc:634
|
#7 0x000063b3fe974e4e in execute_sqlcom_select (thd=thd@entry=0x70e304000c68, all_tables=0x70e304017dc0) at /test/12.1_opt/sql/sql_parse.cc:6166
|
#8 0x000063b3fe973337 in mysql_execute_command (thd=thd@entry=0x70e304000c68, is_called_from_prepared_stmt=false) at /test/12.1_opt/sql/sql_parse.cc:3954
|
#9 0x000063b3fe96bc41 in mysql_parse (thd=thd@entry=0x70e304000c68, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x70e40c2f4420)at /test/12.1_opt/sql/sql_parse.cc:7882
|
#10 0x000063b3fe96a15f in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x70e304000c68, packet=packet@entry=0x70e304008a59 "SELECT * FROM t WHERE b>-1", packet_length=packet_length@entry=26, blocking=true)at /test/12.1_opt/sql/sql_parse.cc:1877
|
#11 0x000063b3fe96c051 in do_command (thd=thd@entry=0x70e304000c68, blocking=true) at /test/12.1_opt/sql/sql_parse.cc:1416
|
#12 0x000063b3fea98c6d in do_handle_one_connection (connect=<optimized out>, connect@entry=0x63b43c0ccca8, put_in_cache=true)at /test/12.1_opt/sql/sql_connect.cc:1414
|
#13 0x000063b3fea98a2f in handle_one_connection (arg=arg@entry=0x63b43c0ccca8)at /test/12.1_opt/sql/sql_connect.cc:1326
|
#14 0x000063b3fee33e29 in pfs_spawn_thread (arg=0x63b43c0f2618)at /test/12.1_opt/storage/perfschema/pfs.cc:2198
|
#15 0x000070e40f89caa4 in start_thread (arg=<optimized out>)at ./nptl/pthread_create.c:447
|
#16 0x000070e40f929c3c in clone3 ()at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:78
|
Bug Detection Matrix |
Rel o/d Build Commit UniqueID observed
|
CS 10.6 dbg 090625 888663ce12647c5aefee5e18accd80843d726741 SIGFPE|get_max_range_rowid_filter_elems_for_table|TABLE::init_cost_info_for_usable_range_rowid_filters|make_join_statistics|JOIN::optimize_inner
|
CS 10.6 opt 090625 888663ce12647c5aefee5e18accd80843d726741 SIGFPE|get_max_range_rowid_filter_elems_for_table|TABLE::init_cost_info_for_usable_range_rowid_filters|make_join_statistics|JOIN::optimize_inner
|
CS 10.11 dbg 090625 11d1ac7285221ab4df7d9ef7cc8ee949b01c9b32 SIGFPE|get_max_range_rowid_filter_elems_for_table|TABLE::init_cost_info_for_usable_range_rowid_filters|make_join_statistics|JOIN::optimize_inner
|
CS 10.11 opt 090625 11d1ac7285221ab4df7d9ef7cc8ee949b01c9b32 SIGFPE|get_max_range_rowid_filter_elems_for_table|TABLE::init_cost_info_for_usable_range_rowid_filters|make_join_statistics|JOIN::optimize_inner
|
CS 11.4 dbg 090625 8c6cbb336081a5e1ad781df4a9778b61e3b4d73f SIGFPE|get_max_range_rowid_filter_elems_for_table|TABLE::init_cost_info_for_usable_range_rowid_filters|make_join_statistics|JOIN::optimize_inner
|
CS 11.4 opt 090625 8c6cbb336081a5e1ad781df4a9778b61e3b4d73f SIGFPE|get_max_range_rowid_filter_elems_for_table|TABLE::init_cost_info_for_usable_range_rowid_filters|make_join_statistics|JOIN::optimize_inner
|
CS 11.8 dbg 090625 67e6fdee05ead4974fe632e91c38941ade369b0c SIGFPE|get_max_range_rowid_filter_elems_for_table|TABLE::init_cost_info_for_usable_range_rowid_filters|make_join_statistics|JOIN::optimize_inner
|
CS 11.8 opt 090625 67e6fdee05ead4974fe632e91c38941ade369b0c SIGFPE|get_max_range_rowid_filter_elems_for_table|TABLE::init_cost_info_for_usable_range_rowid_filters|make_join_statistics|JOIN::optimize_inner
|
CS 12.0 dbg 090625 f1102da37a3dcdc8b92e0205f0a8bd878704b168 SIGFPE|get_max_range_rowid_filter_elems_for_table|TABLE::init_cost_info_for_usable_range_rowid_filters|make_join_statistics|JOIN::optimize_inner
|
CS 12.0 opt 090625 f1102da37a3dcdc8b92e0205f0a8bd878704b168 SIGFPE|get_max_range_rowid_filter_elems_for_table|TABLE::init_cost_info_for_usable_range_rowid_filters|make_join_statistics|JOIN::optimize_inner
|
CS 12.1 dbg 090625 6a2afb42ba86188ccda0972f9c2df363f34e10a0 SIGFPE|get_max_range_rowid_filter_elems_for_table|TABLE::init_cost_info_for_usable_range_rowid_filters|make_join_statistics|JOIN::optimize_inner
|
CS 12.1 opt 090625 6a2afb42ba86188ccda0972f9c2df363f34e10a0 SIGFPE|get_max_range_rowid_filter_elems_for_table|TABLE::init_cost_info_for_usable_range_rowid_filters|make_join_statistics|JOIN::optimize_inner
|
ES 10.5 dbg 070525 0d368ec0042a81d9549fc939fb742f82350b20ab SIGFPE|get_max_range_rowid_filter_elems_for_table|TABLE::init_cost_info_for_usable_range_rowid_filters|make_join_statistics|JOIN::optimize_inner
|
ES 10.5 dbg 090625 0d368ec0042a81d9549fc939fb742f82350b20ab SIGFPE|get_max_range_rowid_filter_elems_for_table|TABLE::init_cost_info_for_usable_range_rowid_filters|make_join_statistics|JOIN::optimize_inner
|
ES 10.5 opt 070525 0d368ec0042a81d9549fc939fb742f82350b20ab SIGFPE|get_max_range_rowid_filter_elems_for_table|TABLE::init_cost_info_for_usable_range_rowid_filters|make_join_statistics|JOIN::optimize_inner
|
ES 10.5 opt 090625 0d368ec0042a81d9549fc939fb742f82350b20ab SIGFPE|get_max_range_rowid_filter_elems_for_table|TABLE::init_cost_info_for_usable_range_rowid_filters|make_join_statistics|JOIN::optimize_inner
|
ES 10.6 dbg 070525 6111fbaf7bdcb6f1170f556ffd05d6e1a4159f62 SIGFPE|get_max_range_rowid_filter_elems_for_table|TABLE::init_cost_info_for_usable_range_rowid_filters|make_join_statistics|JOIN::optimize_inner
|
ES 10.6 dbg 090625 6111fbaf7bdcb6f1170f556ffd05d6e1a4159f62 SIGFPE|get_max_range_rowid_filter_elems_for_table|TABLE::init_cost_info_for_usable_range_rowid_filters|make_join_statistics|JOIN::optimize_inner
|
ES 10.6 opt 070525 6111fbaf7bdcb6f1170f556ffd05d6e1a4159f62 SIGFPE|get_max_range_rowid_filter_elems_for_table|TABLE::init_cost_info_for_usable_range_rowid_filters|make_join_statistics|JOIN::optimize_inner
|
ES 10.6 opt 090625 6111fbaf7bdcb6f1170f556ffd05d6e1a4159f62 SIGFPE|get_max_range_rowid_filter_elems_for_table|TABLE::init_cost_info_for_usable_range_rowid_filters|make_join_statistics|JOIN::optimize_inner
|
ES 11.4 dbg 070525 9cd12544ebfd0d52d2158af66b5aced58121cf1f SIGFPE|get_max_range_rowid_filter_elems_for_table|TABLE::init_cost_info_for_usable_range_rowid_filters|make_join_statistics|JOIN::optimize_inner
|
ES 11.4 dbg 090625 9cd12544ebfd0d52d2158af66b5aced58121cf1f SIGFPE|get_max_range_rowid_filter_elems_for_table|TABLE::init_cost_info_for_usable_range_rowid_filters|make_join_statistics|JOIN::optimize_inner
|
ES 11.4 opt 070525 9cd12544ebfd0d52d2158af66b5aced58121cf1f SIGFPE|get_max_range_rowid_filter_elems_for_table|TABLE::init_cost_info_for_usable_range_rowid_filters|make_join_statistics|JOIN::optimize_inner
|
ES 11.4 opt 090625 9cd12544ebfd0d52d2158af66b5aced58121cf1f SIGFPE|get_max_range_rowid_filter_elems_for_table|TABLE::init_cost_info_for_usable_range_rowid_filters|make_join_statistics|JOIN::optimize_inner
|