No updating expression allowed Basex

Question

I am using BaseX version 8.6.6 i am getting the error while updating database

expression must all be updating or return empty sequence

below is the code:

declare  %private %updating function local:ingest-job()
{
  
let $contentpath := 'D:\2019\bloomsbury-ingest-content\TEI.zip'
let $archive := file:read-binary($contentpath)

for $entry in archive:entries($archive)[fn:ends-with(., '.xml')]
let $rootNode := fn:name(fn:parse-xml(archive:extract-text($archive, $entry))/*)
return
  let $docId := fn:parse-xml(archive:extract-text($archive, $entry))/*/@xml:id/string()[$rootNode='TEI']
  let $cid := fn:replace($docId,'[a-zA-z-]','')
  let $jobID := fn:concat($cid,'-',fn:string(fn:format-dateTime(fn:current-dateTime(), '[Y0001][M01][D01][H01][m01][s01][f01]')))
  let $jobChunk := <job>
    <job-info>
      <id>{$jobID}</id>
      <cid>{$cid}</cid>
    </job-info>
  </job>
  return (
    db:add('testdb', $jobChunk, fn:concat('/jobs/',$jobID,'.xml')),
    db:output(<result><status>Success</status><message>Job created</message><jobid>{$jobID}</jobid></result>))
};

<results>{local:ingest-job()}</results>

current output:

<result>
  <status>Success</status>
  <message>Job created</message>
  <jobid>9781784604387-2019102816303069</jobid>
</result>
<result>
  <status>Success</status>
  <message>Job created</message>
  <jobid>9781784604417-2019102816303069</jobid>
</result>

expected output:

<results>
<result>
  <status>Success</status>
  <message>Job created</message>
  <jobid>9781784604387-2019102816303069</jobid>
</result>
<result>
  <status>Success</status>
  <message>Job created</message>
  <jobid>9781784604417-2019102816303069</jobid>
</result>
</results>

what is going wrong here?

Answer 1

As the error message indicates you are mixing updating and non-updating expressions here. You avoid doing this within your function by using db:output(), but you do it in the main part:

<results>{local:ingest-job()}</results>

This constructs the results element and within it you have an updating function. The XQUF spec does not allow this and as BaseX tries to be standards compliant you are not allowed to do that.

You have several options how to avoid that:

1. You only transform/add the nodes in main memory using transform expressions.
2. You simply call local:ingest-job() instead of <results>{local:ingest-job()}</results>. This way you have no non-updating expression. However, then you will have no surrounding results element.
3. You turn on MIXUPDATES

These options are also described within the BaseX wiki.