Tianyin Xu wrote:
> Ok, I agree that "2147483647" is not a reasonable setting. But what's the
> definition of "reasonable"? I just want to study the impact of the setting
> so I test the big number first.
Please don't top-post.
Those values are not wrong. They just don't match what our current
testing framework expects. Whether the generated plans are sensible or
not is entirely another question; the queries should still return the
same resultsets. Ordering of tuples within the resultset shouldn't
matter, but the test framework is not smart enough to compare them
that way.
> When you give users the flexibility of configurations, you cannot say all
> the values mismatching with your expectations are not allowed. In fact the
> system allowed such settings.
Sure.
--
Álvaro Herrera http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services