[DERBY-3626] Issue with bracketed SQL comments on a remote database connection from ij

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Duplicate
• Affects Version/s: 10.4.1.3
• Component/s: Tools
• Environment: Windows XP; java version "1.5.0_13"; Java(TM) 2 Runtime Environment, Standard Edition (build 1.5.0_13-b05); Java HotSpot(TM) Client VM (build 1.5.0_13-b05, mixed mode, sharing)
• Urgency: Normal
• Issue & fix info: Repro attached
• Assignee: Unassigned
• Reporter: Martin Zaun
• Created: 16/Apr/08 00:24
• Updated: 02/Feb/10 08:26
• Resolved: 02/Feb/10 08:26

Description

Testing DERBY-1749 (bracketed SQL comments) the function test org.apache.derbyTesting.functionTests.tests.lang.CommentTest pass. However, when taking the SQL comment test queries from the function tests and running them from ij, all but one pass.

The failing test case is the query
/* a comment */ VALUES 1 ;
which returns an error instead of the expected value "1". See examples below and attached files.

Strangely, this only happens on a remote database connection:
ij version 10.5
ij> connect 'jdbc:derby://localhost:1527/testdb;create=true';
ij> /* a comment */ VALUES 1 ;
ERROR X0Y79: Statement.executeUpdate() cannot be called with a statement that re
turns a ResultSet.
ij>

The embedded case is fine:
ij version 10.5
ij> connect 'jdbc:derby:/testdb;create=true';
ij> /* a comment */ VALUES 1 ;
1
-----------
1

1 row selected
ij>

Since it does seem to make a difference whether to run these queries embedded orremotely and from ij or a jdbc junit client, it might be useful to extend the function tests for bracketed comments to cover more configurations.

Issue Links

• blocks: DERBY-3242 ij doesn't understand bracketed comments
• blocks: DERBY-1749 Implement Bracketed SQL comments (/*...*/ comments)
• duplicates: DERBY-4338 Network client raises error "executeQuery method can not be used for update" when sql is preceded by /* */ comments