[ES|QL] _score is always 0 when DSL filter is being applied #123967
Description
Elasticsearch Version
8.18
Installed Plugins
No response
Java Version
23.0.2
OS Version
22.6.0 Darwin Kernel Version
Problem Description
_score is always 0 when DSL filter is being applied. This is extremely important for kibana as prefiltering is always added.
Steps to Reproduce
Check this:
POST _query/async { "query": "FROM movies METADATA _score | WHERE Title: \"Shakespeare\" | sort _score DESC | KEEP Title, _score", "locale": "en", "include_ccs_metadata": true, "filter": { "bool": { "must": [], "filter": [], "should": [], "must_not": [] } } } This returns:
#! No limit defined, adding default limit of [1000] { "is_running": false, "took": 4, "is_partial": false, "columns": [ { "name": "Title", "type": "text" }, { "name": "_score", "type": "double" } ], "values": [ [ "Shakespeare in Love", 0 ], [ "Shakespeare in Love", 0 ], [ "Shakespeare in Love", 0 ] ] } If I remove the DSL:
POST _query/async { "query": "FROM movies METADATA _score | WHERE Title: \"Shakespeare\" | sort _score DESC | KEEP Title, _score", "locale": "en", "include_ccs_metadata": true } #! No limit defined, adding default limit of [1000] { "is_running": false, "took": 4, "is_partial": false, "columns": [ { "name": "Title", "type": "text" }, { "name": "_score", "type": "double" } ], "values": [ [ "Shakespeare in Love", 7.960540771484375 ], [ "Shakespeare in Love", 7.960540771484375 ], [ "Shakespeare in Love", 7.960540771484375 ] ] } Logs (if relevant)
No response