Opened 21 months ago

Closed 19 months ago

Last modified 18 months ago

#3311 closed Bug (fixed)

Piwik_Archive_Single::preFetchBlob can select extra unnecessary blobs

Reported by: capedfuzz Owned by: capedfuzz
Priority: normal Milestone: 1.9 -- Piwik 1.9
Component: Core Keywords:
Cc: Sensitive: no

Description

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.

Change History (5)

comment:1 Changed 20 months ago by matt (mattab)

  • Milestone set to 1.8.3 - Piwik 1.8.3
  • Priority changed from normal to major

comment:2 Changed 20 months ago by matt (mattab)

  • Owner set to capedfuzz
  • Priority changed from major to critical

comment:3 Changed 19 months ago by capedfuzz (diosmosis)

  • Resolution set to fixed
  • Status changed from new to closed

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

comment:4 Changed 19 months ago by capedfuzz (diosmosis)

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

comment:5 Changed 18 months ago by matt (mattab)

  • Priority changed from critical to normal
Note: See TracTickets for help on using tickets.