Listing hosts via host_collection based search query yields to wrong results in Red Hat Satellite 6

Issue

• Common host between host_collections is not excluded while listing the hosts via hammer as displayed below:

  # hammer host list --search 'host_collection = test1 and host_collection != test2'
  ---|-------------|------------------|------------|--------------|----------------------
  ID | NAME        | OPERATING SYSTEM | HOST GROUP | CONTENT VIEW | LIFECYCLE ENVIRONMENT
  ---|-------------|------------------|------------|--------------|----------------------
  58 | host1       |                  |            |              |                      
  57 | host2       |                  |            |              |                      
  ---|-------------|------------------|------------|--------------|----------------------
  

  • Note: In the above example, host2 is a common host in both host_collections test1 and test2 and is still listed despite it being part of the excluded host collection.