NXQL Date comparison does not work with multivalued complex properties

1. install Nuxeo 6.0 (latest HF)
2. configure it with MongoDB
   • copy the attached files into NUXEO_HOME/nxserver/config folder
   • add mongodb to the template property in nuxeo.conf
   • start a docker for mongodb using:

     docker run --name nuxeo-mongo -p 27017:27017 -e MONGODB_DBNAME=nuxeo -d mongo:3.2 --storageEngine wiredTiger
     

3. start nuxeo server
4. create a document with a multivalued complex containing a monovalued date field
5. try requests like the following:

   SELECT * FROM myDocTest WHERE mydoctest:myComplex/*/myDateA BETWEEN TIMESTAMP '2018-01-01T00:00:00' AND TIMESTAMP '2020-01-01T00:00:00'
   SELECT * FROM myDocTest WHERE mydoctest:myComplex/*/myDateA > TIMESTAMP '2000-01-01T00:00:00'
   

   This gives an empty result:

   No documents match your search criteria

Doing the same with 7.10 and later versions works fine and returns the expected document.