Search result is empty When I do a search, I got an empty result even though the result shouldn't be null.
I even get a null result if I don't filter anything. However fulltext search works, only facets corresponding to a field seems to not work.

I copied a production database to a test server. Everything works fine on production, but I can make the test copy works.

I've seen there is some issue with facets if the user doesn't have the permission to create temporary table. I checked that, and I think I have the permission.

Any idea ? (I use drupal commerce)
The problem was due to different behavior between mysql 5.6 and 5.7. I thought I had the same environment between production and test but I was wrong. I use a docker image for mysql but didn't specify a version so I ended up with two different versions on the two systems, even though the provisioning looked the same.