Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

Small problem with embedded comments in a statement



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.




Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group