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. Dan.
