Uploaded image for project: 'FTS'
  1. FTS
  2. FTS-816

MySQL 5.7: ORDER BY clause is not in SELECT list

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: fts 3.5.7
    • Fix Version/s: fts 3.6.0
    • Component/s: MySQL
    • Security Level: Public Data (This ticket is visible to anyone on the internet and will be indexed by search engines)
    • Labels:
      None

      Description

      It seems MySQL 5.7 has introduced a new constraint:

      Expression #1 of ORDER BY clause is not in SELECT list, references column 'fts3.j.priority' which is not in SELECT list; this is incompatible with DISTINCT
      

        Attachments

          Activity

            People

            • Assignee:
              aalvarez Alejandro Alvarez Ayllon
              Reporter:
              aalvarez Alejandro Alvarez Ayllon
              Component Watchers:
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: