Missing 'LIKE' detection on Command 'where' method

[Ashyam90]

Missing 'LIKE' detection on Command 'where' method

[alexgann]

Just a curiosity, what happens if you include the wildcards in your parameter instead of writing them into the query?

where('name like ?', '%Ferrar%');

[Ashyam90]

Right now I can't test and it's been a while since I noticed this, but I
believe it translates into the following SQL:

WHERE name like %Ferrar%

Without the quotes surrounding the expression. Likewise said, I can't test
right now, and will only be able to next week, but I believe it it as I
just stated. I can be wrong, of course; I'll test properly as soon as I'm
able to :)
On Aug 21, 2014 1:49 AM, "alexgann" [email protected] wrote:

Just a curiosity, what happens if you include the wildcards in your
parameter instead of writing them into the query?

'''
where('name like ?', '%Ferrar%');

—
Reply to this email directly or view it on GitHub
#178 (comment)
.

[odino]

I see that we might not have tests covering the case (

orientdb-odm/test/Doctrine/OrientDB/Query/QueryTest.php

Line 48 in 9d61e1a

$this->query->where('any() traverse ( any() like "%danger%" )', null, false);

this is everything I could find about LIKEs)

would you be able to provide a test case so that its easier for us to reproduce / fix?

cheers!

[alexgann]

I just tested where('name like ?', '%Ferrar%'); and it returns as it should:
SELECT FROM Car WHERE name like "%Ferrar%"

This is common Doctrine and PDO behavior. See the following: http://stackoverflow.com/questions/3755718/doctrine2-dql-use-setparameter-with-wildcard-when-doing-a-like-comparison

Hope that helps!

[odino]

Thanks man!
On Aug 21, 2014 6:22 PM, "alexgann" [email protected] wrote:

I just tested where('name like ?', '%Ferrar%'); and it returns as it
should:
SELECT FROM Car WHERE name like "%Ferrar%"

This is common Doctrine and PDO behavior. See the following:
http://stackoverflow.com/questions/3755718/doctrine2-dql-use-setparameter-with-wildcard-when-doing-a-like-comparison

Hope that helps!

—
Reply to this email directly or view it on GitHub
#178 (comment)
.