Re: Unexpected subquery behaviour

2004-05-31 Thread Victoria Reznichenko
Monday, May 31, 2004, 12:28:20 PM, you wrote: J> I'm sorry, but I'm using Windows. There is no 4.1.2 version available yet Ok. Could you create a repeatable test case? You can upload structure of tables and data for testing to ftp://ftp.mysql.com/pub/mysql/upload/ and let me know a file name. J

Re: Unexpected subquery behaviour

2004-05-31 Thread Victoria Reznichenko
Jaime <[EMAIL PROTECTED]> wrote: > > I'm using subqueries in MySQL 4.1.1 alpha. I use three subqueries and then want to > get those combinations matching a given constraints. It is a very simple task, but I > get less results than I expected. In fact, I tried to execute the same query in > ORAC

Unexpected subquery behaviour

2004-05-31 Thread Jaime
Hi all! I'm using subqueries in MySQL 4.1.1 alpha. I use three subqueries and then want to get those combinations matching a given constraints. It is a very simple task, but I get less results than I expected. In fact, I tried to execute the same query in ORACLE and I get 23 results (in MySQL I