String array type in ecpg.

Hi,

String array type in ecpg is strange.

> pgbash
pgbash> create table test_array(code varchar(4), name text[3]);
pgbash> insert into test_array values('c01','{"n01","n02","n03"}');
pgbash> select * from test_array;
code|name
----+-------------------
c01 |{"n01","n02","n03"}
(1 row)

--------------------( ECPG program)------------------------
# include <stdio.h>
exec sql include sqlca;

main()
{
exec sql begin declare section;
char code[5];
char name[256];
exec sql end declare section;

exec sql connect to admin user admin;

exec sql declare cur cursor for select * from test_array;
exec sql open cur;
while(1)
{
exec sql fetch cur into :code, :name;
if( sqlca.sqlcode == 100 ) break;
printf("# code=(%s) name=(%s)\n", code, name );
}
exec sql close cur;
}
------------------------------------------------------------

Results are as follows.

# code=("n02","n03"}) name=({"n01","n02","n03"})
Segmentation fault (core dumped)

Here is the patch which corrects this bug.

*** postgresql-7.1.2/src/interfaces/ecpg/lib/data.c.orig Sat May 26 20:47:53 2001
--- postgresql-7.1.2/src/interfaces/ecpg/lib/data.c Sat May 26 21:33:10 2001
***************
*** 337,342 ****
--- 337,344 ----
return (false);
break;
}
+ if (type == ECPGt_char || type == ECPGt_unsigned_char || type == ECPGt_varchar)
+ break;
if (isarray)
{
bool string = false;

--
SAKAIDA Masaaki