We usually try to create a unique index on an IMMV for both performance and constraint reasons. However, we don't need such index for an aggregate view without GROUP BY because it has always only one row. Also, we don't need to raise NOTICE message to suggest to create an index.
This change was mistakenly introduced in cfe9491e6b2168, but it should have been a separate commit. In this commit, a typo and tests are fixed.
We usually try to create a unique index on an IMMV for both performance and constraint reasons. However, we don't need such index for an aggregate view without GROUP BY because it has always only one row. Also, we don't need to raise NOTICE message to suggest to create an index.
This change was mistakenly introduced in cfe9491e6b2168, but it should have been a separate commit. In this commit, a typo and tests are fixed.