extra single quotation in sql when using EntityRepository::findBy

Details

Type: Bug
Status: In Progress
Priority: Major
Resolution: Unresolved
Affects Version/s: None
Fix Version/s: 2.4
Component/s: None
Security Level: All
Labels:
None

Description

I'm using symfony 2.1 with mysql.

I have following code:

$related = 
$this->getDoctrine()->getRepository('MyWebBundle:LineRelated')
->findBy(array('line' => $lines), array('count' => 'DESC'), 20);

that generate the sql like this:

SELECT *
FROM line_related t0 
WHERE t0.line_id IN ('6059', 126352, '5677', '6058') 
ORDER BY t0.count DESC 
LIMIT 20

please notice that the sql has extra single quotation around the number 6059,5677 and 6058. which make the sql very slow.

I did a test, when using single quotation,the sql takes 300ms,when using without single quotation,the sql takes 1 ms.

Options
- Sort By Name
- Sort By Date
- Ascending
- Descending
- Download All

Attachments

DDC2214Test.php

27/Dec/12 7:41 PM

3 kB

Fabio B. Silva

Activity

Ascending order - Click to sort in descending order

scourgen made changes - 26/Dec/12 7:53 AM

Field	Original Value	New Value
Description	I'm using symfony 2.1 with mysql. I have following code: {code} $related = $this->getDoctrine()->getRepository('ZuoWebBundle:LineRelated')->findBy(array('line' => $lines), array('count' => 'DESC'), 20); {code} that generate the sql like this: {code:sql} SELECT SQL_NO_CACHE * FROM line_related t0 WHERE t0.line_id IN ('6059', 126352, '5677', '6058') ORDER BY t0.count DESC LIMIT 20 {code} please notice that the sql has extra single quotation around the number 6059,5677 and 6058. which make the sql very slow. I did a test, when using single quotation,the sql takes 300ms,when using without single quotation,the sql takes 1 ms.	I'm using symfony 2.1 with mysql. I have following code: {code} $related = $this->getDoctrine()->getRepository('MyWebBundle:LineRelated')->findBy(array('line' => $lines), array('count' => 'DESC'), 20); {code} that generate the sql like this: {code:sql} SELECT SQL_NO_CACHE * FROM line_related t0 WHERE t0.line_id IN ('6059', 126352, '5677', '6058') ORDER BY t0.count DESC LIMIT 20 {code} please notice that the sql has extra single quotation around the number 6059,5677 and 6058. which make the sql very slow. I did a test, when using single quotation,the sql takes 300ms,when using without single quotation,the sql takes 1 ms.

scourgen made changes - 26/Dec/12 7:55 AM

Description

I'm using symfony 2.1 with mysql.

I have following code:

{code}
$related = $this->getDoctrine()->getRepository('MyWebBundle:LineRelated')->findBy(array('line' => $lines), array('count' => 'DESC'), 20);
{code}

that generate the sql like this:

{code:sql}
SELECT SQL_NO_CACHE * FROM line_related t0 WHERE t0.line_id IN ('6059', 126352, '5677', '6058') ORDER BY t0.count DESC LIMIT 20
{code}

please notice that the sql has extra single quotation around the number 6059,5677 and 6058. which make the sql very slow.

I did a test, when using single quotation,the sql takes 300ms,when using without single quotation,the sql takes 1 ms.

I'm using symfony 2.1 with mysql.

I have following code:

{code}
$related =
$this->getDoctrine()->getRepository('MyWebBundle:LineRelated')
->findBy(array('line' => $lines), array('count' => 'DESC'), 20);
{code}

that generate the sql like this:

{code:sql}
SELECT *
FROM line_related t0
WHERE t0.line_id IN ('6059', 126352, '5677', '6058')
ORDER BY t0.count DESC
LIMIT 20
{code}

please notice that the sql has extra single quotation around the number 6059,5677 and 6058. which make the sql very slow.

I did a test, when using single quotation,the sql takes 300ms,when using without single quotation,the sql takes 1 ms.

Fabio B. Silva made changes - 27/Dec/12 7:41 PM

Attachment

DDC2214Test.php [ 11366 ]

Marco Pivetta made changes - 28/Dec/12 9:17 AM

Assignee

Benjamin Eberlei [ beberlei ]

Marco Pivetta [ ocramius ]

Marco Pivetta made changes - 06/Jan/13 2:29 PM