From: Edmund Bacon <ebacon@onesystem.com>
To: pgsql-interfaces <pgsql-interfaces@postgresql.org>
Cc: Jürgen Cappel <email@juergen-cappel.de>
Subject: Re: ECPG Segfault and variable usage question.
Date: Fri, 13 Feb 2004 09:07:34 -0700
Message-ID: <1076688454.19238.12.camel@elb_lx.onesystem.ca> (raw)
In-Reply-To: <JEEKIPNAKJNCFLMOBKHGAEEEDCAA.email@juergen-cappel.de>
References: <JEEKIPNAKJNCFLMOBKHGAEEEDCAA.email@juergen-cappel.de>
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@onesystem.com>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: ebacon@onesystem.com, email@juergen-cappel.de
Subject: Re: ECPG Segfault and variable usage question.
In-Reply-To: <1076688454.19238.12.camel@elb_lx.onesystem.ca>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox