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

Unknown column in field list

    XMLWordPrintable

    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: