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

Identity server Db Select Statement order by issue.

    XMLWordPrintable

Details

    Description

      Please have a look at the attached screenshots, it will be easy to reproduce.

      when i run this Query, it return wrong results when i run this query on 10.2.7

      but return right results when i run on 10.1.x.

      SELECT `api`.`Id`, `api`.`Description`, `api`.`DisplayName`, `api`.`Enabled`, `api`.`Name`
      		 
      FROM `ApiResources` AS `api`
      		 
      WHERE EXISTS (
      		 
          SELECT 1
      		 
          FROM `ApiScopes` AS `x`
      		 
          WHERE `x`.`Name` IN ('openid', 'profile', 'ccx2api', 'ccx2lmapi') AND (`api`.`Id` = `x`.`ApiResourceId`))
      		 
      ORDER BY `api`.`Id`

      Attachments

        1. 10.1.png
          10.1.png
          364 kB
        2. 10.2.png
          10.2.png
          289 kB
        3. 2017-07-27 (1).png
          2017-07-27 (1).png
          346 kB
        4. 2017-07-27 (2).png
          2017-07-27 (2).png
          332 kB
        5. ccx-id_apiresources.sql
          2 kB
        6. ccx-id_apiscopes.sql
          3 kB

        Issue Links

          is duplicated by

          Bug - A problem which impairs or prevents the functions of the product. MDEV-12959 ORDER BY is mixing up rows

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-13994 Bad join results with orderby_uses_equalities=on

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-13694 Wrong result upon GROUP BY with orderby_uses_equalities=on

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-13704 Nested query does not give same result as subquery and an outer query

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-13994 Bad join results with orderby_uses_equalities=on

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Activity

            People

              psergei Sergei Petrunia
              ajaygoel555 Ajay Kumar
              Votes:
              0 Vote for this issue
              Watchers:
              6 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.