require 'mongoid'

Mongoid.connect_to 'query_not_causing_weird_stuff'

class Player
  include Mongoid::Document

  field :name, type: String, default: ''
  field :position, type: String, default: ''
  field :team, type: String, default: ''
  field :number, type: Integer
end

Player.delete_all

Player.create!(team: 'Falcons', position: 'QB', name: 'Vidur', number: 37)
Player.create!(team: 'Falcons', position: 'WR', name: 'Jonathon', number: 47)
Player.create!(team: 'Falcons', position: 'LB', name: 'David', number: 22)

players_on_team = Player.where(team: 'Falcons')

print players_on_team.where(position: 'WR').pluck(:name) # expect ['Jonathon']
print players_on_team.not.where(position: 'WR').pluck(:name) # expect ['Vidur', 'David']
print players_on_team.where(position: 'WR').pluck(:name) # expect ['Jonathon'] actual ['Vidur', 'David']