Hi,
Yesterday I pull source from PG-Devel repository (Head) and was playing
around with ECPG. I got following two issues while parsing my script files
through ECPG preprocessor which I think are potential bugs;
1- I get this error message from preprocessor,
*ERROR: cursor "m_name_cursor" already defined *
Below is the code snippet, error message is thrown on the last line of this
snippet;
...
...
EXEC SQL DECLARE m_name_cursor CURSOR FOR SELECT name,id FROM m_table3;
EXEC SQL OPEN m_name_cursor;
EXEC SQL CLOSE m_name_cursor;
/* Declaring cursor with the same name */
EXEC SQL DECLARE m_name_cursor CURSOR FOR SELECT name,id FROM m_table4;
2- Preprocessor throws this error;
*ERROR: syntax error at or near "-"*
Below is the code snippet, the error is thrown on the last line of the
snippet;
...
...
const char *stmt1 = "SELECT abs(?)";
EXEC SQL PREPARE mystmt1 FROM :stmt1;
EXEC SQL EXECUTE mystmt1 INTO :result USING -.55566;
Regards,
Ahmed