Piwik_Archive_Single::preFetchBlob can select extra unnecessary blobs #3311

Closed
diosmosis opened this Issue Aug 9, 2012 · 2 comments

1 participant

@diosmosis
Piwik Open Source Analytics member

The preFetchBlob method in Piwik_Archive_Single uses LIKE '$name%' to select subtable blobs w/ the main blob. Sometimes this can result in selecting the wrong blobs. For example, selecting blobs for 'Actions_actions' will select blobs for 'Actions_actions_url*' as well. This shouldn't happen.

@diosmosis
Piwik Open Source Analytics member

(In [7095]) Fixes #3311, use more granular SELECT in Piwik_Archive_Single::preFetchBlob & add test to make sure extra blobs are not selected.

@diosmosis
Piwik Open Source Analytics member

(In [7099]) Refs #3311, clarify test case.

@diosmosis diosmosis added this to the 1.9 -- Piwik 1.9 milestone Jul 8, 2014
@diosmosis diosmosis self-assigned this Jul 8, 2014
This issue was closed.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment