Bug #876: Bugs Inserts Arrays
Walter (wgpalumbo@yahoo.com.br) reports a bug with a severity of 2
The lower the number the more severe it is.
Short Description
Bugs Inserts Arrays
Long Description
Hi, Im Walter, from Brazil, and I use PG 7.2.
(excuse my english!)
The error: the last entrance (last array
dimension) determine the dimension of all arrays,
losting data information.
see the example:
all of array has 2 elements. The error: the last entrance (last array
dimension) determine the dimension of all arrays,
losting data information (the information "002" of first array is lost).
If I make a mistake, forgot it, but if not, please, report me something !
Thanks a Lot
Walter
Sample Code
create table teste(serie integer,aula text[][]);
//it�s ok when insert this
insert into teste values (1,'{{"004","009"},{"009"},{""},
{"001","002"}}');
//But when I insert this..
insert into teste values
(1,'{{"004","009","002"},{"009","001"},{""},{"001","002"}}');
^^^^^^ -> lost information ^^^^^^^^^^ -> array dimension last entrance.
No file was uploaded with this report
pgsql-bugs@postgresql.org writes:
Sample Code
create table teste(serie integer,aula text[][]);
//it�s ok when insert this
insert into teste values (1,'{{"004","009"},{"009"},{""},
{"001","002"}}');
//But when I insert this..
insert into teste values
(1,'{{"004","009","002"},{"009","001"},{""},{"001","002"}}');
^^^^^^ -> lost information ^^^^^^^^^^ -> array dimension last entrance.
Yeah, this seems to be a long-standing misbehavior. I get the same
results as far back as PG 7.0 (the oldest version I have running):
play=> select * from teste;
serie | aula
-------+-----------------------------------------------------
1 | {{"004","009"},{"009",""},{"",""},{"001","002"}}
1 | {{"004","009"},{"009","001"},{"",""},{"001","002"}}
(2 rows)
On the other hand, the last time I fixed what seemed an obvious bug in
the array-value parser, I got flak for it. Anyone want to defend the
present behavior?
regards, tom lane