Fix SQL Mode Compatibility issue with facets

Thomas Seiberrequested to merge
issue/search_api-3436123:3436123-sql-mode-compatibility into 8.x-1.x

Closes #3436123

Merge request reports