[DERBY-6662] DatabaseMetaData.usesLocalFiles() returns true for in-memory databases

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 10.11.1.1
• Fix Version/s: 10.10.2.1, 10.11.1.3, 10.12.1.1
• Component/s: JDBC
• Urgency: Normal
• Issue & fix info: Newcomer, Repro attached
• Bug behavior facts: Deviation from standard
• Assignee: Myrna van Lunteren
• Reporter: Richard N. Hillegas
• Created: 14/Jul/14 18:45
• Updated: 09/Sep/16 09:54
• Resolved: 29/Sep/14 16:45

Description

DatabaseMetaData.usesLocalFiles() returns true for in-memory databases. And it also returns true for DatabaseMetaData.usesLocalFilePerTable(). The following script shows this:

connect 'jdbc:derby:memory:db;create=true';

call syscs_util.syscs_register_tool( 'databaseMetaData', true );

values usesLocalFiles();

values usesLocalFilePerTable();

I think that these methods should return false because an in-memory database does not store tables in files.

Issue Links

• relates to: DERBY-6759 Derby 10.10 backport issue (fall 2014)