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

View stop working after upgrade from 10.1.15 to 10.3.7

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 10.3.7, 10.3(EOL)
    • 10.3.8
    • Views
    • None

    Description

      After upgrade MariaDB from 10.1.15 to 10.3.7 one view stop working:
      CREATE OR REPLACE VIEW first_view AS SELECT o.order_pk FROM second_view AS o LEFT JOIN third_view AS d ON o.order_pk=d.order_pk;
      Now return
      Unknown column 'd.order_pk' in 'on clause'

      If i change LEFT JOIN to RIGHT JOIN no errors.

      I have 10.1.15 in the same cluster and this view works fine.

      Attachments

        Issue Links

          Activity

            cyber_neo Zakharov Sergey created issue -
            elenst Elena Stepanova made changes -
            Field Original Value New Value
            Affects Version/s 10.3.7 [ 23005 ]
            elenst Elena Stepanova made changes -
            Component/s Views [ 10111 ]
            elenst Elena Stepanova made changes -
            Labels need_feedback
            elenst Elena Stepanova made changes -
            Labels need_feedback
            elenst Elena Stepanova made changes -
            Assignee Alice Sherepa [ alice ]
            alice Alice Sherepa made changes -
            Attachment 16420.sql [ 45720 ]
            alice Alice Sherepa made changes -
            Assignee Alice Sherepa [ alice ] Oleksandr Byelkin [ sanja ]
            alice Alice Sherepa made changes -
            Status Open [ 1 ] Confirmed [ 10101 ]
            alice Alice Sherepa made changes -
            Fix Version/s 10.3 [ 22126 ]
            alice Alice Sherepa made changes -
            Affects Version/s 10.3 [ 22126 ]
            alice Alice Sherepa made changes -
            Assignee Oleksandr Byelkin [ sanja ] Igor Babaev [ igor ]
            igor Igor Babaev (Inactive) made changes -
            Status Confirmed [ 10101 ] In Progress [ 3 ]
            alice Alice Sherepa made changes -
            alice Alice Sherepa made changes -
            alice Alice Sherepa made changes -
            igor Igor Babaev (Inactive) made changes -
            Assignee Igor Babaev [ igor ] Oleksandr Byelkin [ sanja ]
            Status In Progress [ 3 ] In Review [ 10002 ]
            sanja Oleksandr Byelkin made changes -
            Status In Review [ 10002 ] Stalled [ 10000 ]
            sanja Oleksandr Byelkin made changes -
            Assignee Oleksandr Byelkin [ sanja ] Igor Babaev [ igor ]
            igor Igor Babaev (Inactive) made changes -
            Fix Version/s 10.3.8 [ 23113 ]
            Fix Version/s 10.3 [ 22126 ]
            Resolution Fixed [ 1 ]
            Status Stalled [ 10000 ] Closed [ 6 ]
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 87723 ] MariaDB v4 [ 154482 ]

            People

              igor Igor Babaev (Inactive)
              cyber_neo Zakharov Sergey
              Votes:
              1 Vote for this issue
              Watchers:
              8 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.