首页 \ 问答 \ MongoDB Shell:“$或”查询和解释错误()(MongoDB Shell: Error with “$or” query and explain())

MongoDB Shell:“$或”查询和解释错误()(MongoDB Shell: Error with “$or” query and explain())

我正在尝试对MongoDB“$或”查询进行一些分析,并且在Mongo shell中的'explain()'命令遇到问题。 当我使用find命令运行我的查询时,它可以正常工作并返回一条记录。 当我在find()的末尾添加'explain()'时,我收到以下错误:

未捕获的异常:错误:{“$ err”:“无效的操作符:$或”,“code”:10068}

我正在尝试以下查询:

db.people.find({"query" : 
                   {"$or" : [ 
                       {"site" : "mysite", "site_id" : "587125722"}, 
                       {"user_id" : ObjectId("4fb811aae4b0b628b485a58d")}
                   ]}, 
                "$orderby" : { "global_id" : 1, "user_id" : 1}
                })

如果我将“$或”更改为“或”,explain()可以正常工作,但查询返回0结果。 我的印象是他们的语法应该是相同的,有或没有explain(),所以我做错了什么? 我使用的是2.0.4版本。 感谢任何可能提供帮助的人。


I'm trying to do some profiling of a MongoDB "$or" query and I'm having trouble with the 'explain()' command in the Mongo shell. When I run my query with the find command, it works and returns one record, as expected. When I tack on an 'explain()' at the end of the find() however, I get the following error:

uncaught exception: error: { "$err" : "invalid operator: $or", "code" : 10068 }

I'm trying the following query:

db.people.find({"query" : 
                   {"$or" : [ 
                       {"site" : "mysite", "site_id" : "587125722"}, 
                       {"user_id" : ObjectId("4fb811aae4b0b628b485a58d")}
                   ]}, 
                "$orderby" : { "global_id" : 1, "user_id" : 1}
                })

If I change the "$or" to "or", explain() works fine, but the query returns 0 results. I was under the impression that they syntax should be the same with or without explain(), so what am I doing wrong? I'm using version 2.0.4. Thanks to anyone who may be able to help.


原文:https://stackoverflow.com/questions/11640432
更新时间:2023-12-28 08:12

最满意答案

不确定它是否真的适用于本网站,因为它不是直接编程本身...

无论如何,我使用Hosting UK进行我的虚拟主机托管,.NET 4.0和SQL 2008数据库都可用,以及中等信任环境,因此您可以在应用程序中包含其他二进制文件。

我也发现他们的支持非常好。


Not sure if it's really for this site, as it's not directly programming per se...

Anyway, I use Hosting UK for my web hosting, .NET 4.0 and SQL 2008 databases are all available, and a medium trust environment so you can include other binaries in your application.

I've also found their support to be very good.

相关问答

更多

相关文章

更多

最新问答

更多
  • python的访问器方法有哪些
  • 使用Zend Framework 2中的JOIN sql检索数据(Retrieve data using JOIN sql in Zend Framework 2)
  • 透明度错误IE11(Transparency bug IE11)
  • linux的基本操作命令。。。
  • 响应navi重叠h1和nav上的h1链接不起作用(Responsive navi overlaps h1 and navi links on h1 isn't working)
  • 在C中读取文件:“r”和“a +”标志的不同行为(Reading a File in C: different behavior for “r” and “a+” flags)
  • NFC提供什么样的带宽?(What Kind of Bandwidth does NFC Provide?)
  • 元素上的盒子阴影行为(box-shadow behaviour on elements)
  • Laravel检查是否存在记录(Laravel Checking If a Record Exists)
  • 设置base64图像的大小javascript - angularjs(set size of a base64 image javascript - angularjs)
  • 想学Linux 运维 深圳有哪个培训机构好一点
  • 为什么有时不需要在lambda中捕获一个常量变量?(Why is a const variable sometimes not required to be captured in a lambda?)
  • 在Framework 3.5中使用服务器标签<%=%>设置Visible属性(Set Visible property with server tag <%= %> in Framework 3.5)
  • AdoNetAppender中的log4net连接类型无效(log4net connection type invalid in AdoNetAppender)
  • 错误:发送后无法设置标题。(Error: Can't set headers after they are sent. authentication system)
  • 等待EC2实例重启(Wait for an EC2 instance to reboot)
  • 如何在红宝石中使用正则表达式?(How to do this in regex in ruby?)
  • 使用鼠标在OpenGL GLUT中绘制多边形(Draw a polygon in OpenGL GLUT with mouse)
  • 江民杀毒软件的KSysnon.sys模块是什么东西?
  • 处理器在传递到add_xpath()或add_value()时调用了什么顺序?(What order are processors called when passed into add_xpath() or add_value()?)
  • sp_updatestats是否导致SQL Server 2005中无法访问表?(Does sp_updatestats cause tables to be inaccessible in SQL Server 2005?)
  • 如何创建一个可以与持续运行的服务交互的CLI,类似于MySQL的shell?(How to create a CLI that can interact with a continuously running service, similar to MySQL's shell?)
  • AESGCM解密失败的MAC(AESGCM decryption failing with MAC)
  • SQL查询,其中字段不包含$ x(SQL Query Where Field DOES NOT Contain $x)
  • PerSession与PerCall(PerSession vs. PerCall)
  • C#:有两个构造函数的对象:如何限制哪些属性设置在一起?(C#: Object having two constructors: how to limit which properties are set together?)
  • 平衡一个精灵(Balancing a sprite)
  • n2cms Asp.net在“文件”菜单上给出错误(文件管理器)(n2cms Asp.net give error on Files menu (File Manager))
  • Zurb Foundation 4 - 嵌套网格对齐问题(Zurb Foundation 4 - Nested grid alignment issues)
  • 湖北京山哪里有修平板计算机的