[SERVER-3692] --notablescan doesn't prevent scans without a predicate Created: 25/Aug/11  Updated: 29/Feb/12  Resolved: 18/Nov/11

Status: Closed
Project: Core Server
Component/s: None
Affects Version/s: None
Fix Version/s: None

Type: Bug Priority: Major - P3
Reporter: Chris Westin Assignee: Unassigned
Resolution: Duplicate Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Duplicate
duplicates SERVER-2222 notablescan mode neglects to fail som... Backlog
Operating System: ALL
Participants:

 Description   

I started up my mongod with the --notablescan option. I had the twitter tweets collection from the training coarse loaded, but I'm sure this will work with any collection.

Table scans with predicates generate errors, but table scans without predicates do not:

> db.tweets.find(

{'user.followers_count':1000}

);
error:

{ "$err" : "table scans not allowed:twitter.tweets", "code" : 10111 }

> db.tweets.find().skip(1000).limit(1);
{ "_id" : ObjectId("4e55766a89c942db6fdd8ddc"), "text" : "@LiLMAMAs0FLi yhu qoht
ah aim ma?", "in_reply_to_status_id" : NumberLong("22815133901"), "retweet_coun
t" : null, "contributors" : null, "created_at" : "Thu Sep 02 18:13:21 +0000 2010
", "geo" : null, "source" : "<a href=\"http://www.sidekick.com\" rel=\"nofollow\
">T-Mobile Sidekick</a>", "coordinates" : null, "in_reply_to_screen_name" : "LiL
MAMAs0FLi", "truncated" : false, "entities" : { "user_mentions" : [

{ "indices" : [ 0, 13 ], "screen_name" : "LiLMAMAs0FLi", "name" : "KiMMiE BAByy", "id" : 105635017 }

], "urls" : [ ], "hashtags" : [ ] },
"retweeted" : false, "place" : null, "user" :

{ "friends_count" : 46, "profile_s idebar_fill_color" : "C0DFEC", "location" : "Brooklyn New York", "verified" : fa lse, "follow_request_sent" : null, "favourites_count" : 0, "profile_sidebar_bord er_color" : "a8c7f7", "profile_image_url" : "http://a0.twimg.com/profile_images/ 896020476/Picture_038_normal.jpg", "geo_enabled" : false, "created_at" : "Tue Ma y 11 23:38:23 +0000 2010", "description" : "", "time_zone" : "Quito", "url" : nu ll, "screen_name" : "kool_aid_kid516", "notifications" : null, "profile_backgrou nd_color" : "022330", "listed_count" : 1, "lang" : "en", "profile_background_ima ge_url" : "http://s.twimg.com/a/1283397887/images/themes/theme15/bg.png", "statu ses_count" : 208, "following" : null, "profile_text_color" : "333333", "protecte d" : false, "show_all_inline_media" : false, "profile_background_tile" : false, "name" : "peter duchatellier", "contributors_enabled" : false, "profile_link_col or" : "0084B4", "followers_count" : 24, "id" : 142859223, "profile_use_backgroun d_image" : true, "utc_offset" : -18000 }

, "favorited" : false, "in_reply_to_user
_id" : 105635017, "id" : NumberLong("22819521200") }

Plain db.tweets.find(); works also, but scrolls off the screen, so I couldn't cut-and-paste it as above.


Generated at Thu Feb 08 03:03:46 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.