pgsql: Disallow partitionwise join when collations don't match

2024-11-08 Thread Amit Langote
Disallow partitionwise join when collations don't match If the collation of any join key column doesn’t match the collation of the corresponding partition key, partitionwise joins can yield incorrect results. For example, rows that would match under the join key collation might be located in diffe

pgsql: Disallow partitionwise join when collations don't match

2024-11-08 Thread Amit Langote
Disallow partitionwise join when collations don't match If the collation of any join key column doesn’t match the collation of the corresponding partition key, partitionwise joins can yield incorrect results. For example, rows that would match under the join key collation might be located in diffe

pgsql: Disallow partitionwise join when collations don't match

2024-11-08 Thread Amit Langote
Disallow partitionwise join when collations don't match If the collation of any join key column doesn’t match the collation of the corresponding partition key, partitionwise joins can yield incorrect results. For example, rows that would match under the join key collation might be located in diffe

pgsql: Disallow partitionwise join when collations don't match

2024-11-08 Thread Amit Langote
Disallow partitionwise join when collations don't match If the collation of any join key column doesn’t match the collation of the corresponding partition key, partitionwise joins can yield incorrect results. For example, rows that would match under the join key collation might be located in diffe

pgsql: Disallow partitionwise join when collations don't match

2024-11-08 Thread Amit Langote
Disallow partitionwise join when collations don't match If the collation of any join key column doesn’t match the collation of the corresponding partition key, partitionwise joins can yield incorrect results. For example, rows that would match under the join key collation might be located in diffe

pgsql: Disallow partitionwise join when collations don't match

2024-11-08 Thread Amit Langote
Disallow partitionwise join when collations don't match If the collation of any join key column doesn’t match the collation of the corresponding partition key, partitionwise joins can yield incorrect results. For example, rows that would match under the join key collation might be located in diffe

pgsql: Disallow partitionwise join when collations don't match

2024-11-08 Thread Amit Langote
Disallow partitionwise join when collations don't match If the collation of any join key column doesn’t match the collation of the corresponding partition key, partitionwise joins can yield incorrect results. For example, rows that would match under the join key collation might be located in diffe