From: | dominik(dot)kosiorek(at)infobright(dot)com |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #13934: wrong result of split_part with char value |
Date: | 2016-02-08 15:11:07 |
Message-ID: | 20160208151107.2662.82302@wrigleys.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 13934
Logged by: Dominik Kosiorek
Email address: dominik(dot)kosiorek(at)infobright(dot)com
PostgreSQL version: 9.2.2
Operating system: Ubuntu 14
Description:
create table string1postgres(
a1 int,
a2 char(65),
a3pattern char(15),
a4field int
)
insert into string1postgres values(72,'abcd defg poir abcde m ert g d c v b
gthb',' ',1);
select split_part(a2,a3pattern,a4field) from string1postgres;
-------------------
the result of split part is:
-------------------
abcd defg poir abcde m ert g d c v b gthb
-------------------
instead of:
-------------------
abcd
-------------------
This defect is only with char type. On varchar result is correct.
From | Date | Subject | |
---|---|---|---|
Next Message | bear2k | 2016-02-08 16:32:22 | BUG #13935: Duplicate row in pg_constraint table which is not accessible via indexes |
Previous Message | Amit Kapila | 2016-02-08 14:24:31 | Re: Re: BUG #13685: Archiving while idle every archive_timeout with wal_level hot_standby |