1149716 - Partition INSERT logic problem causing partitions to not be used

Status: RESOLVED FIXED

(Socorro :: Database, task)

Description

[Selena Deckelmann :selenamarie :selena]

We have several tables affected by a partition INSERT logic problem - the correct partitions are not being selected. Therefore all data was being inserted into the parent table. 

This bug will fix this issue across multiple tables. 

A separate bug will be filed for fixing existing data.

Comment 1

[[github robot]]

Commits pushed to master at https://github.com/mozilla/socorro

https://github.com/mozilla/socorro/commit/8d343f60804d298cb831877f57a1784f9f61beab
Fixes bug 1149716 fix partition INSERT logic for all partitioned-by-date tables

https://github.com/mozilla/socorro/commit/7dfd3ddde4fd46ee0bbc793d59e6fb7ee3ca042c
Migration for bug 1149716

https://github.com/mozilla/socorro/commit/3c5c2181d67e1a4c47995e10a746d4506614be49
Fixes bug 1149716 scripts for fixing partitions

https://github.com/mozilla/socorro/commit/921139ca566dabc31b419589474746aa9681f341
Merge pull request #2706 from selenamarie/bug1149716-partitioning-problems

Bug1149716 partitioning problems