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

Dependent query cannot recognize expr in more than 1 nesting level

    XMLWordPrintable

Details

    • Bug
    • Status: Confirmed (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.5, 10.6, 10.9
    • 10.11, 11.1, 11.2
    • None
    • None

    Description

      repro: https://dbfiddle.uk/1BpvGW2V

      here is the same repro working for MySQL: https://dbfiddle.uk/wa8Kc48N
      and for PostgreSQL: https://dbfiddle.uk/6Z-IfLMx

      The failing query patten is important to be supported. In complex queries, it allows to deduplicate subqueries used later more than one without having to put them in the main select.

      I would be grateful if it can be fixed.

      Attachments

        Activity

          People

            sanja Oleksandr Byelkin
            mv Michael
            Votes:
            0 Vote for this issue
            Watchers:
            3 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.