Uploaded image for project: 'VCL'
  1. VCL
  2. VCL-1129

update queries that have ORDER BY on a field that is not in the SELECT list

    XMLWordPrintableJSON

    Details

    • Type: Improvement
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: 2.5.2
    • Component/s: web gui (frontend)
    • Labels:
      None

      Description

      Newer versions of MariaDB require any fields used in ORDER BY clauses to be included in the fields that are part of the SELECT clause.  Any queries that don't match this need to be updated.

      One query the one that gets an initial list of computers in isAvailable. RAM, procspeed, procnumber, and network are not in the SELECT clause.

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              jfthomps Josh Thompson
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated: