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

Wrong result in sub query, unless we add space or comment

    XMLWordPrintable

Details

    • Bug
    • Status: Confirmed (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.6, 10.11, 11.4, 11.8, 12.1, 10.11.14
    • 10.11, 11.4, 11.8, 12.1
    • Optimizer
    • RedHat 8, tried on mariadb 10.1.41, 10.11.10 and 10.11.14

    Description

      Subquery results are incorrect unless we add space or comment.

      Added self contained test case to this bug report.

      If anywhere between the lines 55 after the parenthesis and before "a.student_id" at line 61 we add a space or comment, the result changes as the expected result for "incorrect_behaviour".

      The field "correct_behaviour" has a comment already in place to show the dynamic.

      Can't explain this case.

      Attachments

        Activity

          People

            psergei Sergei Petrunia
            Beni David Bénicy
            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.