character varying array bug in 7.4.1
От | Esh, Andrew |
---|---|
Тема | character varying array bug in 7.4.1 |
Дата | |
Msg-id | B38A3B4F283DBA419282705B57A2425B2E24DF@aime2k02.adaptec.com обсуждение исходный текст |
Ответы |
Re: character varying array bug in 7.4.1
|
Список | pgsql-bugs |
Could someone tell me if this bug is trivially reproducible or already solv= ed before I do a lot of needless documentation on it? I upgraded from 7.1beta5 to 7.4.1 recently, and I noticed that many of my c= haracter varying arrays were getting a trailing space inserted into their l= ast value. This appears to be the result of white space being misplaced dur= ing the INSERT/UPDATE command. If there is a space before the close-curly-b= race, it gets appended to the last quoted value. When there is no space bet= ween the close-quotes and the close-curly-brace, the correct value is inser= ted. This behavior did not occur in 7.1beta5. Here's a test I did to show the problem: test=3D> update nametable set names =3D '{ "arf" }' where id =3D 1; UPDATE 1 golem=3D> select id, names from nametable where id =3D 1; id | names=20 ----+------------------ 1 | {"arf "} (1 row) golem=3D> update nametable set names =3D '{"arf"}' where id =3D 1; UPDATE 1 golem=3D> select id, names from nametable where id =3D 1; id | names=20 ----+------------------ 1 | {arf} (1 row) I'll be glad to document this further if needed. --- Andrew C. Esh mail:Andrew_Esh[at]adaptec.com Adaptec, Inc. 2905 Northwest Blvd., Suite 20 763-557-9005 (main) Plymouth, MN 55441-2644 USA 763-551-6418 (direct)
В списке pgsql-bugs по дате отправления: