db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mark Thornton <mthorn...@optrak.co.uk>
Subject storesMixedCaseQuotedIdentifiers() should return false
Date Thu, 31 May 2007 14:42:26 GMT
This somewhat misleading function should only return true if the names 
are compared case INsensitively. With Derby 10.2.1.7 it returns true.

The JavaDoc reads:

"Retrieves whether this database treats mixed case quoted SQL 
identifiers as case insensitive and stores them in mixed case"

For comparison, this method does return true for Microsoft's SQL Server, 
but then that doesn't conform to the SQL-92 standard.

Regards,
Mark Thornton


Mime
View raw message