SYSCS_BULK_INSERT fails with syntax error at PROPERTIES clause. ---------------------------------------------------------------
Key: DERBY-1660 URL: http://issues.apache.org/jira/browse/DERBY-1660 Project: Derby Issue Type: Bug Components: SQL Affects Versions: 10.2.0.0 Reporter: Sunitha Kambhampati Assigned To: Sunitha Kambhampati Priority: Minor Fix For: 10.2.0.0 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. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira