Simon Gentile <smg595@stripped> wrote:
> in version 4.1 states it supports subqueries like
>
> SELECT * FROM t1 WHERE (1,2,3) IN (SELECT a,b,c FROM
> t2);
>
> it doesn't support 'IN'
>
> [Dissertation] ERROR 1235: This version of MySQL
> doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery'
Worked fine for me:
mysql> select * from t2 where (1,2,3) in (select a,b,c from t1);
+------+
| id |
+------+
| 2 |
| 3 |
+------+
2 rows in set (0.02 sec)
Could you provide a test case?
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Victoria Reznichenko
/ /|_/ / // /\ \/ /_/ / /__ Victoria.Reznichenko@stripped
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com
