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

            Activity

              People

              Assignee:
              psergey Sergei Petrunia
              Reporter:
              ajaygoel555 Ajay Kumar
              Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: