db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Daniel John Debrunner <...@debrunners.com>
Subject Re: [jira] Commented: (DERBY-104) Get rid of the Max lenght of 18 for constraint names
Date Fri, 06 May 2005 13:47:41 GMT
Bernt M. Johnsen (JIRA) wrote:
>      [ http://issues.apache.org/jira/browse/DERBY-104?page=comments#action_64618 ]
> Bernt M. Johnsen commented on DERBY-104:
> ----------------------------------------
> There seems to be no (practical) limit on cursor names:
>  get cursor zzzz as 'select * from tab';
> where zzzz is 10000 characters long works prefectly in ij (same goes for next etc).

Just to be clear that GET CURSOR is a feature of ij only, it is not SQL.
It's an interface to the JDBC cursor mechanism, so any limit on cursor
names would come from the JDBC spec.

I think it was a mistake for ij to have these special commands that
allowed testing of JDBC features from ij. Some, like this one, look like
SQL and thus users have sometimes been suprised that they were not
supported by the engine itself.

I think a better approach would have been to write tests that used JDBC
directly (.java tests), this also mimics how actual applications would
use those features.


View raw message