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

Reply via email to