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

    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

          Structure

            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:

                  Structure Helper Panel