IMO this is a rather serious bug:

{
exec sql begin declare section;
	long i;
exec sql end declare section;
	...
	{
		exec sql begin declare section;
        		short i;
		exec sql end declare section;
		...
	}
	...
	some DB access into i;

The code produced by ecpg now lists i with size 2 bytes, i.e. it still
thinks i is a short.

I believe I have found a way to work around this and disregard variable
definitions as soon as they are no longer valid.

To my big surprise though I noticed that ORACLE's proc suffers from the same
bug. I hope it's okay with you that I don't care about compatibility and fix
this. :-)

Michael

-- 
Dr. Michael Meskes, Project-Manager    | topsystem Systemhaus GmbH
meskes@topsystem.de                    | Europark A2, Adenauerstr. 20
meskes@debian.org                      | 52146 Wuerselen
Go SF49ers! Go Rhein Fire!             | Tel: (+49) 2405/4670-44
Use Debian GNU/Linux!                  | Fax: (+49) 2405/4670-10

Thu, 12 Feb 1998 09:15:58 +0100 (CET)
Michael Meskes <meskes@topsystem.de>
preprocessor bug?
> To my big surprise though I noticed that ORACLE's proc suffers from the same
> bug. I hope it's okay with you that I don't care about compatibility and fix
> this. :-)

Fix it, please.

-- 
Bruce Momjian
maillist@candle.pha.pa.us

Thu, 12 Feb 1998 09:26:41 -0500 (EST)
Bruce Momjian <maillist@candle.pha.pa.us>
Re: [HACKERS] preprocessor bug?