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

"Reference not supported" with nested GROUP BY's on the same table and column

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Duplicate
    • 10.2.5, 10.2.6, 10.2
    • N/A
    • Optimizer
    • Windows 7, x64

    Description

      I had a very complex query (it was quite a complex view which used another pretty complex view).
      It worked as expected in 10.1.*. I have tried it in 10.2.5 and 10.2.6 and throws the following error:
      "Reference '[FIELD NAME]' not supported (forward reference in item list)".

      I'm attaching the smallest example I have found which reproduces the issue (it's a useless construct for any other purpose).

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              Estructure Estructure
              Votes:
              0 Vote for this issue
              Watchers:
              3 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.