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

crash in get_mm_leaf with xor on binary col

        Details

        • Type: Bug
        • Status: Closed
        • Priority: Major
        • Resolution: Fixed
        • Affects Version/s: 10.1.5
        • Fix Version/s: 10.1.6
        • Component/s: Optimizer, Partitioning
        • Labels:
          None
        • Environment:
          Win x64

          Description

          Version: '10.1.5-MariaDB'  mariadb.org binary distribution
[ERROR] mysqld got exception 0xc0000005 ;

mysqld.exe!get_mm_leaf()[opt_range.cc:8374]
mysqld.exe!get_mm_parts()[opt_range.cc:8280]
mysqld.exe!get_func_mm_tree()[opt_range.cc:7823]
mysqld.exe!get_full_func_mm_tree()[opt_range.cc:7931]
mysqld.exe!Item_func::get_mm_tree()[opt_range.cc:8222]
mysqld.exe!prune_partitions()[opt_range.cc:4063]
mysqld.exe!JOIN::optimize_inner()[sql_select.cc:1260]
mysqld.exe!JOIN::optimize()[sql_select.cc:1023]
mysqld.exe!mysql_select()[sql_select.cc:3310]
mysqld.exe!handle_select()[sql_select.cc:373]
mysqld.exe!execute_sqlcom_select()[sql_parse.cc:5797]
mysqld.exe!mysql_execute_command()[sql_parse.cc:2938]
mysqld.exe!mysql_parse()[sql_parse.cc:7178]
mysqld.exe!dispatch_command()[sql_parse.cc:1473]
mysqld.exe!do_command()[sql_parse.cc:1093]
mysqld.exe!threadpool_process_request()[threadpool_common.cc:233]
mysqld.exe!io_completion_callback()[threadpool_win.cc:568]

          How To Repeat:
          ----------------------

          Start server: mysqld.exe --no-defaults --console

          drop table if exists t1;
create table t1(a binary(80))engine=innodb partition by key(a) partitions 3;
select 1 from t1 where a xor 'a';

            Gliffy Diagrams

              Attachments

                Activity

                Hide
                Permalink
                elenst Elena Stepanova added a comment -

                Thanks for the report and the test case.
                It's a recent regression, introduced by the following commit:

                commit 3709c7fc6d46c624c24523907eb2a0ad8a1e5062
Author: Alexander Barkov <bar@mariadb.org>
Date:   Tue Jun 2 15:42:01 2015 +0400

    MDEV-8222 "string_field LIKE int_const" returns a wrong result in case of UCS2
    MDEV-8257 Erroneous "Impossible where" when mixing decimal comparison and LIKE
                Show
                elenst Elena Stepanova added a comment - Thanks for the report and the test case. It's a recent regression, introduced by the following commit: commit 3709c7fc6d46c624c24523907eb2a0ad8a1e5062 Author: Alexander Barkov <bar@mariadb.org> Date: Tue Jun 2 15:42:01 2015 +0400 MDEV-8222 "string_field LIKE int_const" returns a wrong result in case of UCS2 MDEV-8257 Erroneous "Impossible where" when mixing decimal comparison and LIKE

                  People

                  • Assignee:
                    bar Alexander Barkov
                    Reporter:
                    sbester1 sbester1
                  • Votes:
                    0 Vote for this issue
                    Watchers:
                    3 Start watching this issue

                    Dates

                    • Created:
                      Updated:
                      Resolved: