On Sunday, September 12, 2021, Jaime Casanova <
jcasanov@systemguards.com.ec> wrote:
So, what is it? the index row size could be upto 8191 or cannot be
greater than 2704?
The wording doesn’t change between the two: The size cannot be greater the 8191 regardless of the index type being used. This check is first, probably because it is cheaper, and just normal abstraction layering, but it doesn’t preclude individual indexes imposing their own constraint, as evidenced by the lower maximum of 2704 in this specific setup.
It may be non-ideal from a UX perspective to have a moving target in the error messages, but they are consistent and accurate, and doesn’t seem worthwhile to expend much effort on usability since the errors should themselves be rare.
David J.
