Uploaded image for project: 'Spring Data Couchbase'
  1. Spring Data Couchbase
  2. DATACOUCH-580

ambiguous reference to field _class (predicate following LIMIT)

    XMLWordPrintable

Details

    Description

      https://forums.couchbase.com/t/ambiguous-reference-to-field-class/26653 

      shagunv
      Hi,
      I am using spring spring-boot-starter-data-couchbase-reactive version 2.3.1.RELEASE. there is an issue while using @Query inside a repository interface. i am getting Ambiguous reference to field _class error.

      Below is the method which i have written
      @Query("#

      {[#n1ql|https://forums.couchbase.com/c/n1ql/16].selectEntity}

      where #

      {[#n1ql|https://forums.couchbase.com/c/n1ql/16].filter}

      AND creation >= $1 ORDER BY creation DESC LIMIT $2 OFFSET $3")
      Flux findAllByCreationGreaterThan(long creation, int limit, int offset);

      Inside the detailed exception trace i found that it is generating the below query statement :
      “statement”:“SELECT META(testbucket).id AS __id, META(testbucket).cas AS __cas, testbucket.* FROM testbucket where _class = \“com.testapp.web.model.UserOrder\” AND creation >= $1 ORDER BY creation DESC LIMIT $2 OFFSET $3 AND _class = \“com.testapp.web.model.UserOrder\””

      _class is getting appended at the end of the statement as well.
      If i don’t use @Query with order by and limit/offset it is working fine.

      How can i solve this?
      Is anything wrong in the query which i am writing.

      I checked the forum but didn’t find anything related to this issue.
      Please help me.

      Thanks
       
      https://forums.couchbase.com/t/ambiguous-reference-to-field-class/26653

      Attachments

        Activity

          People

            mikereiche Michael Reiche
            mikereiche Michael Reiche
            Spring Issues Spring Issues
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: