BUG #13934: wrong result of split_part with char value

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.

Responses

Browse pgsql-bugs by date

  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