[ http://issues.apache.org/jira/browse/DERBY-522?page=comments#action_12331731 ]
Kathey Marsden commented on DERBY-522: -------------------------------------- I know there is code in ij that strips of the comments for client. It would be great if it could be changed to not strip off the comments for a 10.2 client. Then you will see that there are actually lots of test cases checked in in many of the sql files. I think ij should remain the same and strip off the comments for 10.1 clients even when this is ported to 10.1, so as not to cause trouble with old clients. I wonder about comments before Stored procedures that return result sets. Do those work ok? > ERROR X0Y79 raised when adding comments using "--" before sql queries with > Network Client > ----------------------------------------------------------------------------------------- > > Key: DERBY-522 > URL: http://issues.apache.org/jira/browse/DERBY-522 > Project: Derby > Type: Bug > Components: Network Client > Versions: 10.1.2.0, 10.1.1.0, 10.2.0.0 > Reporter: Kathey Marsden > Assignee: A B > Fix For: 10.2.0.0, 10.1.2.0 > Attachments: CommentBeforeSelect.java, d522.patch, d522.stat > > Comments before a select statement Throws exception with Network Client > For Example a statement like the one below in the attached program with throw > an exception. > stmt.execute("-- This is a comment \n Select c11 from TAB1"); > org.apache.derby.client.am.SqlException: Statement.executeUpdate() cannot be > called with a statement that returns a ResultSet. > at > org.apache.derby.client.am.Statement.completeSqlca(Statement.java:1354) > at > org.apache.derby.client.am.Statement.completeExecuteImmediate(Statement.java:964) > at > org.apache.derby.client.net.NetStatementReply.parseEXCSQLIMMreply(NetStatementReply.java:199) > at > org.apache.derby.client.net.NetStatementReply.readExecuteImmediate(NetStatementReply.java:50) > at > org.apache.derby.client.net.StatementReply.readExecuteImmediate(StatementReply.java:44) > at > org.apache.derby.client.net.NetStatement.readExecuteImmediate_(NetStatement.java:123) > at > org.apache.derby.client.am.Statement.readExecuteImmediate(Statement.java:960) > at > org.apache.derby.client.am.Statement.flowExecute(Statement.java:1587) > at org.apache.derby.client.am.Statement.executeX(Statement.java:631) > at org.apache.derby.client.am.Statement.execute(Statement.java:622) > at > CommentBeforeSelect.createAndPopulateTable(CommentBeforeSelect.java:70) > at CommentBeforeSelect.main(CommentBeforeSelect.java:35) > $ > To reproduce run the attached program > java CommentBeforeSelect -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira
