Hi Ignacio,
It appears that the problem is associated with postgres. I tried the
same code with sqlite3 and it works as expected. From the errors, I
think that there is a bug in the search code that uses the ILIKE
operator for integers which gives a type conversion error in postgres.
Note that the error occurs when the integer column is included in the
list of searchable columns without regards to the type of the search
field contents.
I uploaded two versions to github, the only difference between them is
in database.yml:
https://github.com/dziesig/test_integer_search.git -- this one works (uses
sqlite3)
https://github.com/dziesig/pg_integer_search.git -- this one fails (uses
postgres)
The officers table is populated with:
President 1
Vice President 2
Secretary 3
Treasurer 4
Trustee 5
Thanks for your help,
Don Ziesig
On 09/18/2014 01:38 PM, Ignacio Huerta wrote:
Never seen this before. Can you give us a bit more information about
your model and the table plus in order to reproduce?
Regards,
Ignacio
El 14/09/14 a las #4, Donald Ziesig escribió:
Hi All!
I'm not sure if this is a bug in hobo or rails, but if I try to search
on an integer column using table-plus I get an SQL error:
PG::UndefinedFunction: ERROR: operator does not exist: integer ~~*
unknown LINE 1: ...member_positions" WHERE (((member_positions.rank
ILIKE '%2%... ^ HINT: No operator matches the given name and
argument type(s). You might need to add explicit type casts. :
SELECT COUNT(*) FROM "member_positions" WHERE
(((member_positions.rank ILIKE '%2%')))
Don Ziesig
--
You received this message because you are subscribed to the Google
Groups "Hobo Users" group.
To unsubscribe from this group and stop receiving emails from it, send
an email to [email protected]
<mailto:[email protected]>.
To post to this group, send email to [email protected]
<mailto:[email protected]>.
Visit this group at http://groups.google.com/group/hobousers.
For more options, visit https://groups.google.com/d/optout.
--
You received this message because you are subscribed to the Google Groups "Hobo
Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/hobousers.
For more options, visit https://groups.google.com/d/optout.
