[ http://issues.apache.org/jira/browse/DERBY-1660?page=all ]
Mike Matrigali updated DERBY-1660: ---------------------------------- committed the patch with the test for this issue: svn 430799 > 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 > > Attachments: bulkinsert.diff.txt, bulkinsert.test.diff.txt, > bulkinsert.test.stat.txt > > > 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
