When attempting to reindex - the usual error. The limitation is 65535. By others calculations it is number of varchar attributes * 255.
However, in my case, the sql create statement for the flat table has only 198 attributes, and many of them are integers, yet we receive this error.
I do not understand, as if the calculation is 255 * number of varchar attributes, we would not be at this limit.
Could an sql engineer or someone who understands fully this issue comment on why we could see this error with our number of attributes.