aboutsummaryrefslogtreecommitdiff
path: root/src/backend/executor
diff options
context:
space:
mode:
authorAmit Langote <amitlan@postgresql.org>2024-11-08 16:29:38 +0900
committerAmit Langote <amitlan@postgresql.org>2024-11-08 17:19:35 +0900
commita0cdfc8893673d1325f077b79f551aa105f360b8 (patch)
treeaf394a467fbb7d6d8713973dc4b756cae3c5e157 /src/backend/executor
parentb6484ca9535e947a068da01015620dfde0b9b488 (diff)
downloadpostgresql-a0cdfc8893673d1325f077b79f551aa105f360b8.tar.gz
postgresql-a0cdfc8893673d1325f077b79f551aa105f360b8.zip
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 different partitions due to the partitioning collation. In such cases, a partitionwise join would yield different results from a non-partitionwise join, so disallow it in such cases. Reported-by: Tender Wang <tndrwang@gmail.com> Author: Jian He <jian.universality@gmail.com> Reviewed-by: Tender Wang <tndrwang@gmail.com> Reviewed-by: Junwang Zhao <zhjwpku@gmail.com> Discussion: https://postgr.es/m/CAHewXNno_HKiQ6PqyLYfuqDtwp7KKHZiH1J7Pqyz0nr+PS2Dwg@mail.gmail.com Backpatch-through: 12
Diffstat (limited to 'src/backend/executor')
0 files changed, 0 insertions, 0 deletions