| From: | Dmitry Dolgov <9erthalion6(at)gmail(dot)com> |
|---|---|
| To: | exclusion(at)gmail(dot)com, pgsql-bugs(at)lists(dot)postgresql(dot)org |
| Subject: | Re: BUG #16325: Assert failure on partitioning by int for a text value with a collation |
| Date: | 2020-03-28 12:53:03 |
| Message-ID: | 20200328125303.4me6vetvzgebobw5@localhost |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
> On Sat, Mar 28, 2020 at 05:43:05AM +0000, PG Bug reporting form wrote:
>
>
> The following query:
> create table parted (i int) partition by list (i);
> create table part_coll partition of parted for values in ('1' collate
> "POSIX");
>
> leads to an assert failure with the following stack trace:
Thanks for reporting! Looks like transformPartitionBoundValue needs to
check that the source collumn is collatable, then we get more expected
result:
=# create table part_coll partition of parted for values in ('1' collate "POSIX");
ERROR: 42804: collations are not supported by type integer
| Attachment | Content-Type | Size |
|---|---|---|
| part_value_collations.patch | text/x-diff | 2.3 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | 56224665 | 2020-03-29 01:49:15 | apparent wraparound on postgresql 12 |
| Previous Message | PG Bug reporting form | 2020-03-28 05:43:05 | BUG #16325: Assert failure on partitioning by int for a text value with a collation |