MIME-Version: 1.0
From: Ashutosh Sharma <ashu.coek88@gmail.com>
Date: Fri, 31 Jul 2020 10:46:00 +0530
Message-ID: 
 <CAE9k0P=dQk9X0cU2tN49S7a9tv733-e1pVdpB1P-pWJ5PdTktg@mail.gmail.com>
Subject: ecpg: issue related to preprocessor directives
To: pgsql-interfaces@postgresql.org
Content-Type: multipart/alternative; boundary="0000000000002527f005abb5e3ba"
Precedence: bulk

--0000000000002527f005abb5e3ba
Content-Type: text/plain; charset="UTF-8"

Hi All,

When the following ecpg program having preprocessor directives is compiled,
the output produced is not correct.

/* test program */
exec sql define itype 1;

int main(void)
{
    exec sql begin declare section;
    exec sql ifdef itype;
        int var1;
    exec sql elif ntype;
        numeric var1;
    exec sql else;
        float var1;
    exec sql endif;
    exec sql end declare section;
}

Here is the output produced by th ecpg pre-compiler when above program is
compiled:

int main(void)
{
/* exec sql begin declare section */

#line 8 "2.pgc"
 int var1 ;

#line 12 "2.pgc"
 float var1 ;

/* exec sql end declare section */
#line 14 "2.pgc"
}

As seen from above output, both exec sql ifdef and exec sql else block got
compiled which is wrong. If the above output is further compiled using gcc
compiler, the compilation would fail.

--
With Regards,
Ashutosh Sharma
EnterpriseDB:http://www.enterprisedb.com

--0000000000002527f005abb5e3ba
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Hi All,<br><br>When the following ecpg program having prep=
rocessor directives is compiled, the output produced is not correct.<br><br=
>/* test program */<br>exec sql define itype 1;<br><br>int main(void)<br>{<=
br>=C2=A0 =C2=A0 exec sql begin declare section;<br>=C2=A0 =C2=A0 exec sql =
ifdef itype;<br>=C2=A0 =C2=A0 =C2=A0 =C2=A0 int var1;<br>=C2=A0 =C2=A0 exec=
 sql elif ntype;<br>=C2=A0 =C2=A0 =C2=A0 =C2=A0 numeric var1;<br>=C2=A0 =C2=
=A0 exec sql else;<br>=C2=A0 =C2=A0 =C2=A0 =C2=A0 float var1;<br>=C2=A0 =C2=
=A0 exec sql endif;<br>=C2=A0 =C2=A0 exec sql end declare section;<br>}<br>=
<br>Here is the output produced by th ecpg pre-compiler when above program =
is compiled:<br><br>int main(void)<br>{<br>/* exec sql begin declare sectio=
n */<br><br>#line 8 &quot;2.pgc&quot;<br>=C2=A0int var1 ;<br><br>#line 12 &=
quot;2.pgc&quot;<br>=C2=A0float var1 ;<br><br>/* exec sql end declare secti=
on */<br>#line 14 &quot;2.pgc&quot;<br>}<br><br>As seen from above output, =
both exec sql ifdef and exec sql else block got compiled which is wrong. If=
 the above output is further=C2=A0compiled using gcc compiler, the=C2=A0com=
pilation would fail.<br><div><br></div><div><span style=3D"color:rgb(136,13=
6,136)">--</span><br style=3D"color:rgb(136,136,136)"><span style=3D"color:=
rgb(136,136,136)">With Regards,</span><br style=3D"color:rgb(136,136,136)">=
<span style=3D"color:rgb(136,136,136)">Ashutosh Sharma</span><br style=3D"c=
olor:rgb(136,136,136)"><span style=3D"color:rgb(136,136,136)">EnterpriseDB:=
</span><a href=3D"http://www.enterprisedb.com/" rel=3D"noreferrer" target=
=3D"_blank">http://www.enterprisedb.com</a><br></div></div>

--0000000000002527f005abb5e3ba--