BUG #1165: ECPG can't parse dynamic SQL with indicator
От | PostgreSQL Bugs List |
---|---|
Тема | BUG #1165: ECPG can't parse dynamic SQL with indicator |
Дата | |
Msg-id | 20040615005220.721A4CF48A5@www.postgresql.com обсуждение исходный текст |
Ответы |
Re: BUG #1165: ECPG can't parse dynamic SQL with indicator
|
Список | pgsql-bugs |
The following bug has been logged online: Bug reference: 1165 Logged by: ISHIDA Akio Email address: iakio@mono-space.net PostgreSQL version: 7.4 Operating system: Linux miracle 2.4.9-31.22ml Description: ECPG can't parse dynamic SQL with indicator Details: $ cat indtest.pgc int main() { exec sql begin declare section; int i, i_ind; exec sql end declare section; exec sql execute stmt using :i; /* good */ exec sql execute stmt using :i :i_ind; /* error */ } ==== version 7.3.6 ==== $ pgsql736/bin/ecpg --version ecpg (PostgreSQL 7.3.6) 2.10.0 $ pgsql736/bin/ecpg indtest.pgc (No error) ==== version 7.4.2 ==== $ pgsql742/bin/ecpg --version ecpg (PostgreSQL 7.4.2) 3.1.1 $ pgsql742/bin/ecpg indtest.pgc indtest.pgc:7: ERROR: syntax error at or near ":i_ind" This problem was reported in Japanese mailing list. http://ml.postgresql.jp/pipermail/pgsql-jp/2004-June/008332.html It is a patch.(but I'm not good at using bison) --- src/interfaces/ecpg/preproc/preproc.y.org Mon Jun 14 11:24:25 2004 +++ src/interfaces/ecpg/preproc/preproc.y Fri Jun 11 12:54:10 2004 @@ -5304,6 +5304,7 @@ add_variable_to_head(&argsinsert, new_variable($1, ECPGmake_simple_type(ECPGt_const, length), 0), &no_indicator); } } + | civarind { $$ = EMPTY; } ;
В списке pgsql-bugs по дате отправления: