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

crash in Item_field::used_tables

        Details

        • Type: Bug
        • Status: Closed
        • Priority: Major
        • Resolution: Fixed
        • Affects Version/s: 5.5.36, 10.0.10
        • Fix Version/s: 5.5.38, 10.0.11
        • Component/s: None
        • Labels:
          None

          Description

          mysqld.exe!Item_field::used_tables()[item.cc:2768]
mysqld.exe!Item::const_item()[item.h:1048]
mysqld.exe!Item_in_subselect::const_item()[item_subselect.h:606]
mysqld.exe!st_select_lex::optimize_unflattened_subqueries()[sql_lex.cc:3457]
mysqld.exe!JOIN::optimize_constant_subqueries()[opt_subselect.cc:4986]
mysqld.exe!JOIN::optimize_inner()[sql_select.cc:1118]
mysqld.exe!JOIN::optimize()[sql_select.cc:1013]
mysqld.exe!st_select_lex::optimize_unflattened_subqueries()[sql_lex.cc:3489]
mysqld.exe!mysql_update()[sql_update.cc:369]
mysqld.exe!mysql_execute_command()[sql_parse.cc:3334]
mysqld.exe!mysql_parse()[sql_parse.cc:6457]
mysqld.exe!dispatch_command()[sql_parse.cc:1311]
mysqld.exe!do_command()[sql_parse.cc:1012]
mysqld.exe!threadpool_process_request()[threadpool_common.cc:233]
mysqld.exe!io_completion_callback()[threadpool_win.cc:568]

          How to repeat:

          drop table if exists `r`;
create table `r`(`c` int)engine=innodb;
select exists(select 1 from `r`
group by `c` in (select `c` from `r`));

            Gliffy Diagrams

              Attachments

                Activity

                Ascending order - Click to sort in descending order
                Hide
                Permalink
                elenst Elena Stepanova added a comment -

                Shane, thank you.

                Show
                elenst Elena Stepanova added a comment - Shane, thank you.
                Hide
                Permalink
                Jorge Silva Jorge Manuel Silva added a comment -

                I can also reproduce this in 10.0.9 with myisam and aria engines, so this doesn't seem to be innodb related.

                Show
                Jorge Silva Jorge Manuel Silva added a comment - I can also reproduce this in 10.0.9 with myisam and aria engines, so this doesn't seem to be innodb related.
                Hide
                Permalink
                sanja Oleksandr Byelkin added a comment -

                Sent for review

                Show
                sanja Oleksandr Byelkin added a comment - Sent for review

                  People

                  • Assignee:
                    sanja Oleksandr Byelkin
                    Reporter:
                    sbester1 sbester1
                  • Votes:
                    0 Vote for this issue
                    Watchers:
                    5 Start watching this issue

                    Dates

                    • Created:
                      Updated:
                      Resolved: