[TCK Challenge]: The TCK is making the BETWEEN mandatory, however, it is not native supported by MongoDB

[otaviojava]

Specification

https://github.com/jakartaee/data/blob/78d53408461c0f5962d4fee7a2d780d226f71c0d/spec/src/main/asciidoc/query-language.asciidoc

Assertion

https://github.com/jakartaee/data/blob/78d53408461c0f5962d4fee7a2d780d226f71c0d/tck/src/main/java/ee/jakarta/tck/data/standalone/entity/EntityTests.java

TCK Version

1.0.0-RC1

Implementation being tested

Eclipse JNoSQL

Challenge Scenario

Something else

Full Description

Natively, MongoDB does not support the "between" keyword, making the

`UnsupportedOperation BETWEEN is not natively supported from mongoDB"

However, the TCK returns as an error:

[ERROR]   MyEntityTests>EntityTests.testQueryWithNot:1395 » UnsupportedOperation The condition BETWEEN is not natively supported from mongoDB
[ERROR]   MyEntityTests>EntityTests.testDataRepository:432 » UnsupportedOperation BETWEEN is not natively supported from mongoDB
[ERROR]   MyEntityTests>EntityTests.testDefaultMethod:455 » UnsupportedOperation The condition BETWEEN is not natively supported from mongoDB
[ERROR]   MyEntityTests>EntityTests.testDescendingSort:464 » UnsupportedOperation The condition BETWEEN is not natively supported from mongoDB
[ERROR]   MyEntityTests>EntityTests.testBasicRepository:135 » UnsupportedOperation The condition BETWEEN is not natively supported from mongoDB
[ERROR]   MyEntityTests>EntityTests.testCommonInterfaceQueries:398 » UnsupportedOperation The condition BETWEEN is not natively supported from mongoDB

Additional Context

No response

Is there an existing challenge for this?

• [X] I have searched the existing issues

[njr-11]

We need some more background information to determine if this challenge makes sense.

Does JNoSQL support GreaterThanEqual, And, and LessThanEqual keywords for Mongo? If it can support countByIdGreaterThanEqualAndIdLessThanEqual could it interpretcountByIdBetween the same?