db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Knut Anders Hatlen (JIRA)" <j...@apache.org>
Subject [jira] Closed: (DERBY-3626) Issue with bracketed SQL comments on a remote database connection from ij
Date Tue, 02 Feb 2010 08:26:20 GMT

     [ https://issues.apache.org/jira/browse/DERBY-3626?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Knut Anders Hatlen closed DERBY-3626.
-------------------------------------

    Resolution: Duplicate

The problem has later been reported as DERBY-4338 and fixed. Closing this issue as a duplicate.

> 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
>          Components: Tools
>    Affects Versions: 10.4.1.3
>         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
>         Attachments: comments_test_fail.sql, comments_test_ok.sql
>
>
> 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.


Mime
View raw message