Small problem with embedded comments in a statement - Mailing list pgsql-jdbc

From Thomas Kellerer
Subject Small problem with embedded comments in a statement
Date
Msg-id efaql9$jnj$1@sea.gmane.org
Whole thread Raw
Responses Re: Small problem with embedded comments in a statement  (Kris Jurka <books@ejurka.com>)
List pgsql-jdbc
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.

pgsql-jdbc by date:

Previous
From: Markus Schaber
Date:
Subject: Re: Bind message
Next
From: Luis Vilar Flores
Date:
Subject: Re: bytea memory improvement