Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-36990

SIGFPE in get_max_range_rowid_filter_elems_for_table

    XMLWordPrintable

Details

    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
      

      Attachments

        Activity

          People

            nikitamalyavin Nikita Malyavin
            saahil Saahil Alam
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.