Hello,
When running the following query:
String sql = "select * from table1\n" +
"--select * from table2;\n" +
"--select * from table3";
I get an error:
org.postgresql.util.PSQLException: Multiple ResultSets were returned by the query.
But as the second and third SELECT are behing a comment, they should be ignored,
right? Actually when removing the semicolon after table2, then everything works
fine.
Is this a bug in the JDBC driver, or is this intended behaviour?
Best regards
Thomas
P.S.: before you ask why I run such a SQL statement: I'm maintaining an
open-source query tool and sometimes unwanted statements are simply un-commented
from within the editor, but the application still sends the whole string that
the user supplied.