Skip site navigation (1) Skip section navigation (2)

Re: ECPG Segfault and variable usage question.

From: Edmund Bacon <ebacon(at)onesystem(dot)com>
To: pgsql-interfaces <pgsql-interfaces(at)postgresql(dot)org>
Cc: Jürgen Cappel <email(at)juergen-cappel(dot)de>
Subject: Re: ECPG Segfault and variable usage question.
Date: 2004-02-13 16:07:34
Message-ID: 1076688454.19238.12.camel@elb_lx.onesystem.ca (view raw or flat)
Thread:
Lists: pgsql-interfaces
An added data point for this bug

I have seen a similar problem, although it seems to only manifest itself
in long (1000+ line) source files.   It seems to have something to do
with using macros rather than explicit constants to define array
dimensions.  I'd be willing to bet that the below code example would
compile by adding

#define CL_2   (2*CHAR_LENGTH)
...
   char var[CL_2];
...

There seem to be 2 work arounds: either use a shorter macro name, or
break long files into smaller pieces.

On Thu, 2004-02-12 at 12:00, Jürgen Cappel wrote:

> Hello,
> 
> this is a code snippet that causes ECPG to segfault. It's quite tricky
> to produce, as changing the variable name from 'var' to 'myvar' already
> causes things to compile fine ...
> 
> 
> #define CHAR_LENGTH 25
> myfunction ()
> {
>     EXEC SQL BEGIN DECLARE SECTION;
>     char   var[2*CHAR_LENGTH];
>     EXEC SQL END DECLARE SECTION;
> 
>     EXEC SQL DECLARE mycursor CURSOR FOR
> 	 SELECT att1, att2
> 	 FROM mytable
> 	 WHERE att1 LIKE :var ESCAPE '\\';
>     EXEC SQL OPEN mycursor;
> }
> 
> Stack trace was obtained using a snapshot from about 2 weeks ago, ECPG from
> the 7.4.1 release segfaults also.
> 
> #0  0x4015fdcb in chunk_free () from /lib/libc.so.6
> #1  0x4015fc53 in free () from /lib/libc.so.6
> #2  0x080685b7 in dump_variables (list=0x80c1408, mode=1) at variable.c:405
> #3  0x08066d56 in output_statement (
>     stmt=0x80c14f8 "declare mycursor  cursor  for select  att1  , att2
> from mytable where att1  like  ? escape '\\\\'  ", mode=0, con=0x0) at
> output.c:126
> #4  0x0804af02 in yyparse () at preproc.y:780
> #5  0x0806671d in main (argc=8, argv=0xbffff264) at ecpg.c:409
> #6  0x401089ed in __libc_start_main () from /lib/libc.so.6
> 
> 
> Another problem that's giving me headaches trying to find a workaround for
> is the following use of variables as data sources in INSERT/UPDATE
> statements:
> 
> 	:myarray[index[10]]
> 
> Any comments, suggestions, hints ?   Thanks a lot,
> 
> Jürgen
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend

-- 
Edmund Bacon <ebacon(at)onesystem(dot)com>

In response to

Responses

pgsql-interfaces by date

Next:From: Michael MeskesDate: 2004-02-15 13:42:25
Subject: Re: ECPG Segfault and variable usage question.
Previous:From: L J BayukDate: 2004-02-13 03:01:40
Subject: Re: libpgtcl.dll for tcl 8.4?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group