[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:
Dependency
depends on PHPBB3-11037 Cache drivers require globals Unverified Fix
GitHub Pull Request URL: https://github.com/phpbb/phpbb/pull/2460

 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



 Comments   
Comment by Joas Schilling [ 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 [ 06/Oct/14 ]

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

Generated at Wed Aug 15 03:59:45 UTC 2018 using JIRA 7.9.2#79002-sha1:3bb15b68ecd99a30eb364c4c1a393359bcad6278.