[PHPBB3-11224] SQL cache destroy does not destroy queries to tables joined Created: 26/Nov/12  Updated: 22/Jan/17  Resolved: 01/Oct/14

Status: Closed
Project: phpBB3
Component/s: Caching (ACM)
Affects Version/s: 3.1.0-dev
Fix Version/s: 3.0.13-RC1, 3.1.0-RC5

Type: Bug Priority: Minor
Reporter: EXreaction [X] (Inactive) Assignee: nicofuma
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
depends on PHPBB3-11037 Cache drivers require globals Unverified Fix
GitHub Pull Request URL: https://github.com/phpbb/phpbb/pull/2460


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

This should search for joined tables as well

Comment by Joas Schilling [X] (Inactive) [ 02/Mar/14 ]

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

Comment by nicofuma [ 14/May/14 ]

it seems to be the same in 3.0

Comment by Joas Schilling [X] (Inactive) [ 06/Oct/14 ]

3.1 branch: https://github.com/phpbb/phpbb/pull/3016

Generated at Sat Feb 16 08:14:55 UTC 2019 using Jira 7.12.3#712004-sha1:5ef91d760d7124da5ebec5c16a948a4a807698df.