[DERBY-1660] SYSCS_BULK_INSERT fails with syntax error at PROPERTIES clause.

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 10.2.1.6
• Fix Version/s: 10.2.1.6
• Component/s: SQL
• Assignee: Sunitha Kambhampati
• Reporter: Sunitha Kambhampati
• Created: 10/Aug/06 16:19
• Updated: 11/Aug/06 17:12
• Resolved: 11/Aug/06 17:09

Description

Calling procedure SYSCS_BULK_INSERT fails in 10.2 , throwing a syntax error when it sees the PROPERTIES clause.
SystemProcedures.SYSCS_BULK_INSERT uses the following sql query.
String binsertSql =
"insert into " + entityName +
" PROPERTIES insertMode=bulkInsert " +
"select * from new " + vtiName +
"(" +
"'" + schemaName + "'" + ", " +
"'" + tableName + "'" + ", " +
"'" + vtiArg + "'" + ")" +
" as t";
I think because of the optimizer overrides in 10.2, this query does not work.

Instead of the PROPERTIES clause, we should now use --DERBY-PROPERTIES.