thank you in advance for your time.
After migration to 13.10 , we face one issue about stats.
There is a column which is char(16) and it contains values of :
and so on.....
The problem is the following,
We took stats on this column , but when we check the histograms , it was keeping only the first 8 bits , meaning, 00000000,and not
the whole value,this had a bad influence on how to do some joins and so on?
Has anyone faced a similar problem?Proposions?
Thank you very much.
Check the column definition, seems to be UNICODE:
Only the first 16 bytes of any stats (pre-TD14) will be stored and 8 chars UTF-16 need exactly 16 byte.
Btw, if it's a numeric string, why it's not a numeric datatype?
And if it's non-numeric, why it's always 8 leading zeroes?
Xmm.... thanks for your answer....
It must be unicode,I will have to check it tomorrow.
For the other 2 questions, I have just joined on this project...so, I have to be ready to face and other cases like this.
Thank you very much for your quick answer.