Bug #876: Bugs Inserts Arrays 
Author Message
 Bug #876: Bugs Inserts Arrays

Quote:

> Sample Code
> create table teste(serie integer,aula text[][]);
> //its 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

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate

message can get through to the mailing list cleanly



Mon, 04 Jul 2005 09:58:23 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. BUGS idapi BUGS idapi BUGS idapi BUGS

2. Bugs, Bugs, Bugs ...

3. BUG BUG BUG: VB5+DAO 3.51

4. WAS BUG, BUG, BUG

5. BUGS BUGS BUGS (Disappointed with Borland!)

6. unknown error 876

7. INPUT ARRAY BUG? MIPS platform

8. Sun Storage Array BUG

9. remote UDT array arg...Curious Bug...

10. ESQL/C 5.01 Bug with SELECT and arrays used in WHERE qualification

11. Foxpro 2.5/DOS array bug

12. SQL Server Bug or Query Bug?


 
Powered by phpBB® Forum Software