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
          364 kB
          Ajay Kumar
        2. 10.2.png
          289 kB
          Ajay Kumar
        3. 2017-07-27 (1).png
          346 kB
          Ajay Kumar
        4. 2017-07-27 (2).png
          332 kB
          Ajay Kumar
        5. ccx-id_apiresources.sql
          2 kB
          Ajay Kumar
        6. ccx-id_apiscopes.sql
          3 kB
          Ajay Kumar

        Issue Links

          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.