Uploaded image for project: 'eZ Publish / Platform'
  1. eZ Publish / Platform
  2. EZP-13384

Insert queries that contain "create temporary" in values are executed on MySQL slave

    XMLWordPrintable

Details

    Description

      The problem is this code in eZMySQLDB:

      // Send temporary create queries to slave server
      if ( preg_match( "/create\s+temporary/i", $sql ) )
      {
          $isWriteQuery = false;
      }
      

      It matches create\s+temporary anywhere in $sql, not just at the start.

      Attachments

        Activity

          People

            cyberwolf cyberwolf
            cyberwolf cyberwolf
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: