Details

      Description

      This query gives Unknown column 't12.a' in 'field list' error after upgrade to 10.2.26 from 10.2.25.

      SELECT
          t12.a
      FROM
          `t1` AS t11,
          `t2` AS t12,
          `t3` AS t8
      JOIN `t4` AS t10
      LEFT JOIN `t5` AS t9
      ON
          t9.`a` = t10.`a`
      WHERE
          t10.`a` = t11.`a` AND t10.`a` = t12.`a` AND t8.`a` = t11.`a`;
      

      Sample data:

      create table t1 (a int);
      insert into t1 values (7), (2), (9);
      create table t2 (a int);
      insert into t2 values (5), (1), (7);
      create table t3 (a int);
      insert into t3 values (2), (7), (3);
      create table t4 (a int);
      insert into t4 values (2), (7), (3);
      create table t5 (a int);
      insert into t5 values (2), (7), (3);
      

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                igor Igor Babaev
                Reporter:
                BB Silver Asu
              • Votes:
                1 Vote for this issue
                Watchers:
                8 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: