List:General Discussion« Previous MessageNext Message »
From:Victoria Reznichenko Date:October 24 2003 2:49pm
Subject:Re: MySQL 4.1 subqueries!
View as plain text  
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




Thread
MySQL 4.1 subqueries!Simon Gentile23 Oct
  • Re: MySQL 4.1 subqueries!Director General: NEFACOMP23 Oct
  • Re: MySQL 4.1 subqueries!Victoria Reznichenko24 Oct