Re: Partition by Date Column

[Mikael Ronström]

Hi Robert,
As mentioned in previous posts to the forum YEARWEEK can work
but isn't activated yet. So easiest way to activate is if you
file a bug report and I'll fix it :), it's a 1-liner.


Robert Pelletier Wrote:
-------------------------------------------------------
> I changed my partitionning scheme for database
> pruning, but it still doesn't like I'd like it
> to.
>
> I switched to using "partition by range
> (yearweek(date))".
>
> Selecting one day works with pruning. Selecting a
> range makes all the partitions to be scanned.
>
> I also have "corruption" when using "explain
> partitions select blablabla" that looks like this
> :
> r?s\?p200627,p200628,p200629
>

Not sure about this, file a bug about I presume.

Rgrds Mikael
> Any idea why? What did I do wrong?