Uploaded image for project: 'phpBB3'
  1. phpBB3
  2. PHPBB3-11224

SQL cache destroy does not destroy queries to tables joined

    Details

    • Type: Bug
    • Status: Unverified Fix
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 3.1.0-dev
    • Fix Version/s: 3.0.13-RC1, 3.1.0-RC5
    • Component/s: Caching (ACM)
    • Labels:
      None

      Description

      In driver/sql_generic, we have a regex to search for table names in the save() function:
      if (!preg_match('/FROM \\(?(`?
      w+`?(?:
      w+)?(?:, ?`?
      w+`?(?: \\w+)?)*)
      )?/', $query, $regs))

      This should search for joined tables as well

        Issue Links

          Activity

          Hide
          nickvergessen Joas Schilling added a comment -

          Is this new in 3.1 or also the same in 3.0?

          Show
          nickvergessen Joas Schilling added a comment - Is this new in 3.1 or also the same in 3.0?
          Hide
          nicofuma nicofuma added a comment -

          it seems to be the same in 3.0

          Show
          nicofuma nicofuma added a comment - it seems to be the same in 3.0
          Hide
          nickvergessen Joas Schilling added a comment -
          Show
          nickvergessen Joas Schilling added a comment - 3.1 branch: https://github.com/phpbb/phpbb/pull/3016

            People

            • Assignee:
              nicofuma nicofuma
              Reporter:
              EXreaction EXreaction [X] (Inactive)
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development