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

JOIN::prepare gets unusable "conds" as argument

Details

    • 10.0.34

    Description

      If put something like dbug_print_items in the beginning of JOIN::prepare it catches passing unusable conds.
      One case was on second execution MDEV-14786 but there are other

      Attachments

        Issue Links

          Activity

            create table t1 (i int, row_start timestamp(6) not null default now(),
                             row_end timestamp(6) not null default '2038-01-19 04:14:07.999999');
            create view v1 as select i from t1 where i < 5 and (row_end =
            TIMESTAMP'2030-01-01 0:0:0' or row_end is null);
            create procedure pr(x int) select i from v1;
            #set debug_dbug='d,where';
            call pr(1);
            call pr(2);
            drop procedure pr;
            drop view v1;
            drop table t1;
            

            sanja Oleksandr Byelkin added a comment - create table t1 (i int, row_start timestamp(6) not null default now(), row_end timestamp(6) not null default '2038-01-19 04:14:07.999999'); create view v1 as select i from t1 where i < 5 and (row_end = TIMESTAMP'2030-01-01 0:0:0' or row_end is null); create procedure pr(x int) select i from v1; #set debug_dbug='d,where'; call pr(1); call pr(2); drop procedure pr; drop view v1; drop table t1;

            github branch: bb-5.5-MDEV-14786

            revision-id: 47bb2dcbcc8c3cdca43baf6259f2434a746c7b03 (mariadb-5.5.58-42-g47bb2dcbcc8)
            parent(s): c0e964dcf1787a101f6e9c115751c0d02b0fac1b
            author: Oleksandr Byelkin
            committer: Oleksandr Byelkin
            timestamp: 2018-01-21 23:48:32 +0100
            message:

            MDEV-14786: Server crashes in Item_cond::transform on 2nd execution of SP querying from a view

            MDEV-14957: JOIN::prepare gets unusable "conds" as argument

            Do not touch merged derived (it is irreversible)

            Fix first argument of in_optimizer for calls possible before fix_fields()

            sanja Oleksandr Byelkin added a comment - github branch: bb-5.5- MDEV-14786 revision-id: 47bb2dcbcc8c3cdca43baf6259f2434a746c7b03 (mariadb-5.5.58-42-g47bb2dcbcc8) parent(s): c0e964dcf1787a101f6e9c115751c0d02b0fac1b author: Oleksandr Byelkin committer: Oleksandr Byelkin timestamp: 2018-01-21 23:48:32 +0100 message: MDEV-14786 : Server crashes in Item_cond::transform on 2nd execution of SP querying from a view MDEV-14957 : JOIN::prepare gets unusable "conds" as argument Do not touch merged derived (it is irreversible) Fix first argument of in_optimizer for calls possible before fix_fields() —

            People

              sanja Oleksandr Byelkin
              sanja Oleksandr Byelkin
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

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