db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Daniel John Debrunner <...@apache.org>
Subject Re: some comments on collation wiki page
Date Tue, 03 Apr 2007 18:15:38 GMT
Army wrote:

> On the other hand, if the statement is changed to:
>    // Default schema APP.
>    PreparedStatement ps = conn.prepareStatement(
>        "select tablename, tabletype from sys.systables where " +
>        "CAST (tablename as varchar(128)) = ?");
> then it might be better to take "current schema" to mean the time of 
> *execution.*  That way the the above statement will run correctly 
> regardless of the current schema.  If "current schema" was determined at 
> compile time, the above statement would only work if "current schema" 
> was a non-system schema.

I'm a little lost by this. What do these two terms mean to you?

  "run correctly"
  "would only work if"


View raw message