Uploaded image for project: 'Project Configurator - Development'
  1. Project Configurator - Development
  2. PCDEV-54

A subquery optimization bug in MySQL 5.5 halts the export when detecting values for custom fields

    XMLWordPrintableJSON

    Details

    • Critical Points:
      0

      Description

      See PCP-753 for a report of this problem by a customer.

      The user reported that downgrading PC to 2.1.0-J7 solved the problem. This points clearly to the change in the queries that was released with version 2.2.0.

      The problem is caused by the subquery optimization bug described here. There is also an excellent explanation in this page, in the section called "Badly optimized subqueries". It seems this bug was fixed with MySQL 5.6 (not verified).

        Attachments

          Activity

            People

            Assignee:
            pmaranon Pepe Maranon Mora
            Reporter:
            pepe.maranon José Marañón [Awnaba Software S.L.]
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: