Timeline for db_select condition with subquery causes PDOexception
Current License: CC BY-SA 3.0
6 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Sep 17, 2016 at 10:42 | history | edited | Elin Y. | CC BY-SA 3.0 |
deleted 4 characters in body
|
| Aug 1, 2014 at 18:20 | vote | accept | Elin Y. | ||
| Oct 28, 2013 at 18:13 | comment | added | Elin Y. |
Ok, it was not directly relevant. To test it I just added the LIMIT back and got another error this time: PDOException: SQLSTATE[42000]: Syntax error or access violation: 1235 This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery':...
|
|
| Oct 28, 2013 at 18:07 | comment | added | Elin Y. |
I removed the LIMIT to be able to use IN instead of >, since I needed all values returned by the subquery, not only the smallest one.
|
|
| Oct 28, 2013 at 18:02 | comment | added | Clive♦ |
Not sure how relevant this is, but I noticed you remove the LIMIT from the subquery. Interestingly, the Restrictions on Subqueries would've caused that to fail even if PDO had got the syntax right. Not something I've come across before
|
|
| Oct 28, 2013 at 17:57 | history | answered | Elin Y. | CC BY-SA 3.0 |