Nested query no longer working in ES 6.0

[creaticious (Lars)]

Hey guys,

we upgraded our system running ES5.4 to ES6.0. We used some nested querys for months that are no longer working after the upgrade...they fail with

"...[nested] nested object under path [dates] is not of nested type"

But the mentioned field has the nested type...

Here is a simplified mapping and query...the real one is way bigger but this one is also not working...

PUT products
{
    "settings" : {
        "index" : {
            "number_of_shards" : 3, 
            "number_of_replicas" : 2 
        }
    },
    "mappings": {
      "basics": {
        "properties": {
          "sku": {
            "type": "text",
            "index": "false"
          },
          "title": {
            "type": "text",
            "index": "true"
          },
          "image": {
            "type": "text",
            "index": "false"
          },
          "productmanager": {
            "type": "text",
            "index": "true"
          },
          "dates": {
            "type": "nested",
            "properties": {
              "date-origin": {
                "type": "date",
                "format": "dd.mm.YYYY"
              },
              "date-destination": {
                "type": "date",
                "format": "dd.mm.YYYY"
              },
              "instock": {
                "type": "byte"
              }              
            }
          }
        }
      }
    }
}

And the query...

GET _search
{
  "query": {
    "bool": {
      "must": [
        {
          "query_string": {
            "query": "(sku:*)"
          }
        },
        {
          "nested": {
            "path": "dates",
            "query": {
              "bool": {
                "must": [
                  {
                    "term": {
                      "dates.instock": 0
                    }
                  }
                ]
              }
            },
            "inner_hits": {}
          }
        }
      ]
    }
  }
}

So i have no idea whats wrong with it...
Are there any changes to nested types in ES6..i couldnt find anything in the docs...

Thx!!!

[dadoonet (David Pilato)]

Could you provide a full recreation script as described in

About the Elasticsearch category

The heart of the free and open Elastic Stack Elasticsearch is a distributed, RESTful search and analytics engine capable of addressing a growing number of use cases. As the heart of the Elastic Stack, it centrally stores your data for lightning fast search, fine‑tuned relevancy, and powerful analytics that scale with ease. PLEASE READ THIS SECTION IF IT'S YOUR FIRST POST Some useful links: elasticsearch reference guide elasticsearch user guide elasticsearch plugins elasticsearch cl…

It will help to better understand what you are doing.
Please, try to keep the example as simple as possible.

[creaticious (Lars)]

Sorry , i edited my post to meet the standards...

[dadoonet (David Pilato)]

Great. Could you provide as well some sample documents?
So we can replay your test?

[creaticious (Lars)]

Of course...here is a simple document...let's say i want to receive all product-dates with instock=1...
I'm always getting the error as above...

PUT products/basics/1
{
    "sku" : "12345",
    "title" : "test product",
    "image" : "test_high.jpg",
    "productmanager": "none",
    "dates":[
      {
        "date-origin": "01.01.2018",
        "date-destination": "10.01.2018",
        "instock": 1
      },
      {
        "date-origin": "20.01.2018",
        "date-destination": "30.01.2018",
        "instock": 0
      }
    ]
}