Issue with bracketed SQL comments on a remote database connection from ij
-------------------------------------------------------------------------
Key: DERBY-3626
URL: https://issues.apache.org/jira/browse/DERBY-3626
Project: Derby
Issue Type: Bug
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)
Reporter: Martin Zaun
Priority: Minor
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.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
