Search doesn't work on Postgresql

[hadolen]

Search doesn't work on Postgresql when search by string.

An exception has been thrown during the rendering of a template ("An exception occurred while executing 'SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id0 FROM (SELECT p0_.id AS id0, p0_.title AS title1, p0_.description AS description2 FROM place p0_ WHERE p0_.id IN (?) OR p0_.title LIKE ? OR p0_.description LIKE ?) dctrn_result) dctrn_table' with params ["Good", "%Good%", "%Good%"]:

SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input syntax for integer: "Good"") in @EasyAdmin/default/list.html.twig at line 18.

[Pierstoval]

I thought it was fixed some time ago and we decided to make searches only on text and string fields? /cc @javiereguiluz @ogizanagi

The issue comes from the fact that, with PostgreSQL you cannot make a field comparison with datas with different types. And right now, it checks that place.id is in ["Good", "%Good%", "%Good%"] , thus place.id is an integer and every datas in the array are string, so the DBMS does not allow this.

[javiereguiluz]

Given this query:

[...] WHERE p0_.id IN (?) OR p0_.title LIKE ? OR p0_.description LIKE ? ...
with params ["Good", "%Good%", "%Good%"]

I interpret it as follows:

[...] WHERE p0_.id IN ("Good") OR p0_.title LIKE "%Good%" OR p0_.description LIKE "%Good%"

That's why I don't understand your comment @Pierstoval: id field seems to be using the right non-text comparison.

[Pierstoval]

In this query:

[...] WHERE p0_.id IN ("Good") OR p0_.title LIKE "%Good%" OR p0_.description LIKE "%Good%"

It seems that p0_.id's definition is INT whereas IN ("Good") compares it with a string.

[javiereguiluz]

@Pierstoval I understand your comment now. Sorry for that. I'm looking into this.

[javiereguiluz]

I'm trying to fix this bug in #381. Please review the proposed changes. Thanks!