Uploaded image for project: 'Core Server'
  1. Core Server
  2. SERVER-2585

Allow nested $or operator

        Details

        • Type: Improvement
        • Status: Closed
        • Priority: Major - P3
        • Resolution: Fixed
        • Affects Version/s: 1.6.0, 1.6.1, 1.6.2, 1.6.3, 1.6.4, 1.6.5, 1.7.0, 1.7.1, 1.7.2, 1.7.3, 1.7.4, 1.7.5, 1.7.6
        • Fix Version/s: 1.9.1
        • Component/s: Querying
        • Labels:
          None

          Description

          Allowing nested $or operators would dramatically simplify the logic to build queries. The work of transformation/normalizing the query so that the engine understands it should be done by the server, not the client.

            Issue Links

            is depended on by

            New Feature - A new feature of the product, which has yet to be developed. SERVER-3192 allow nesting $or within $and

            • Major - P3 - Major loss of function.
            • Closed

              Activity

              • Comments
              Ascending order - Click to sort in descending order
              5 older comments
              Hide
              Permalink
              auto auto (Inactive) added a comment -

              Author:

              {u'login': u'astaple', u'name': u'Aaron', u'email': u'aaron@10gen.com'}

              Message: SERVER-3192 SERVER-2585 allow nested or clauses in queries, opaque to indexing system
              Branch: master
              https://github.com/mongodb/mongo/commit/0b32ad4e6d5629525001add932fe78ba517cb503

              Show
              auto auto (Inactive) added a comment - Author: {u'login': u'astaple', u'name': u'Aaron', u'email': u'aaron@10gen.com'} Message: SERVER-3192 SERVER-2585 allow nested or clauses in queries, opaque to indexing system Branch: master https://github.com/mongodb/mongo/commit/0b32ad4e6d5629525001add932fe78ba517cb503
              Hide
              Permalink
              aaron Aaron Staple (Inactive) added a comment -

              We've added in matching for nested or clauses, but not index support. Index support is SERVER-3327.

              Show
              aaron Aaron Staple (Inactive) added a comment - We've added in matching for nested or clauses, but not index support. Index support is SERVER-3327 .
              Hide
              Permalink
              auto auto (Inactive) added a comment -

              Author:

              {u'login': u'astaple', u'name': u'Aaron', u'email': u'aaron@10gen.com'}

              Message: SERVER-2585 test
              Branch: master
              https://github.com/mongodb/mongo/commit/8b35cf0f945c5636df17709bf03a03f63217273f

              Show
              auto auto (Inactive) added a comment - Author: {u'login': u'astaple', u'name': u'Aaron', u'email': u'aaron@10gen.com'} Message: SERVER-2585 test Branch: master https://github.com/mongodb/mongo/commit/8b35cf0f945c5636df17709bf03a03f63217273f
              Hide
              Permalink
              xiaofeng Xiaofeng Wu added a comment -

              I have tried with 1.9.1 development release and night build with nested $or like this. I saw the message as following:
              "failed with exception: exception: 13090 nested $or/$nor not allowed", but I checked the source code(matcher.cpp), this information has been removed. I wonder if the build is not based on latest code. Please check out.

              Show
              xiaofeng Xiaofeng Wu added a comment - I have tried with 1.9.1 development release and night build with nested $or like this. I saw the message as following: "failed with exception: exception: 13090 nested $or/$nor not allowed", but I checked the source code(matcher.cpp), this information has been removed. I wonder if the build is not based on latest code. Please check out.
              Hide
              Permalink
              aaron Aaron Staple (Inactive) added a comment -

              Xiaofeng - can you send the git hash for the mongod version you are using (this is logged on mongod startup).

              Show
              aaron Aaron Staple (Inactive) added a comment - Xiaofeng - can you send the git hash for the mongod version you are using (this is logged on mongod startup).

                People

                • Votes:
                  22 Vote for this issue
                  Watchers:
                  13 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved:
                    Days since reply:
                    5 years, 7 weeks, 1 day ago
                    Date of 1st Reply: