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

LP:914224 - different derived tables has refernce on the sema SELECT_LEX structure

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Not a Bug
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:

      Description

      (gdb) frame 1
      #1 0x000000000069a948 in execute_sqlcom_select (thd=0x1b51408, all_tables=0x1bd0db0) at sql_parse.cc:5196
      (gdb) p all_tables->alias
      $1 = 0x1bd0d70 "t1"
      (gdb) p all_tables->select_lex
      $2 = (st_select_lex *) 0x1b53c28
      (gdb) p all_tables->next_global->next_global->alias
      $3 = 0x1bd1c28 "t2"
      (gdb) p all_tables->next_global->next_global->select_lex
      $4 = (st_select_lex *) 0x1b53c28
      (gdb) p thd->query()
      $5 = 0x1bcfc70 "select * from (select 1 as a) as t1 join (select * from test.t3) as t2"
      (gdb)

      the test suite is:
      create table t3 (a int);
      select * from (select 1 as a) as t1 join (select * from test.t3) as t2;
      drop table t3;

        Gliffy Diagrams

          Attachments

            Activity

            Hide
            sanja Oleksandr Byelkin added a comment -

            Re: different derived tables has refernce on the sema SELECT_LEX structure
            It was my mistake the TABLE_LIST::select_lex shoudle be the same (in is where table is used).

            Show
            sanja Oleksandr Byelkin added a comment - Re: different derived tables has refernce on the sema SELECT_LEX structure It was my mistake the TABLE_LIST::select_lex shoudle be the same (in is where table is used).
            Hide
            ratzpo Rasmus Johansson added a comment -

            Launchpad bug id: 914224

            Show
            ratzpo Rasmus Johansson added a comment - Launchpad bug id: 914224

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved: