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

View not created while porting database from 11.4 to 11.8

    XMLWordPrintable

Details

    Description

      After porting database (by script) from 11.4.2 into fresh new 11.8.6 database some of views were not recreated. That was because new system found an error in select while the old version runs the query fine. I've reduced the query to the minimum:

      SELECT * from DP j
      WHERE 
        not exists (
          select 0 from src
                where src.dp_id = j.dp_id 
          union all
          select 0 from dev
                where j.dp_id = src.dp_id
      )
      
      

      and it still output:

      SQL Error (1054): Unknown column 'j.dp_id' in 'WHERE'
      The essential is 'union all' construct. It runs without error If only the first or the second part in not exists subquery left.
      That worked in Oracle, that worked in 11.4.2, not working in 11.8.6. Does it mean that such SQL statement isn't legal anymore?

      Attachments

        Issue Links

          Activity

            People

              serg Sergei Golubchik
              balta Tadas Balaišis
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

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