On Mon, Jun 09, 2003 at 12:46:32PM -0500, Christopher Knight wrote:
Im have a problem / misunderstanding with the 4.1 release. Im having issues
with indexes related to 'IN' vs '=' in subselects.
assume the subselect returns 1 value
select SQL_NO_CACHE user_id from table_a where user_id in
How's your application written? i.e. J2EE?
We've managed to put a layer in between the application and MySql that translates
subselects on the fly into inner joins.
This allowed us to quite painlessly move from MS SQL to MySql.
EXISTS can be refactored into an inner join.
NOT EXISTS can be
Thanks Greg for the hint but I also wanted to know when is MySQL version 4.1
to be expected to show up in binaries ?
Ahmed
- Original Message -
From: [EMAIL PROTECTED]
To: Ahmed Farouk [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Thursday, January 02, 2003 11:46 PM
Subject: Re: subselects
Ahmed,
- Original Message -
From: Ahmed Farouk [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Thursday, January 02, 2003 9:52 PM
Subject: subselects
Hi All
I know that this maybe a repeated question here but I just need to
know
the updates.
I am asking about the new
Alexander,
Monday, June 03, 2002, 9:46:40 AM, you wrote:
AB 1. I am reading 'internals' list and I see some words about subselect in 'bk
AB commit into 4.1 tree' messages...
AB Seems like we can expect subselect in 4.1 branch !?? :)
Yeah, sub-selects is in our TODO for 4.1, look at:
Hi.
On Tue, Oct 02, 2001 at 04:44:08PM +0100, [EMAIL PROTECTED] wrote:
[...]
I would like to use Subselects with mySQL but they are not supported
until 3.24.
Sub-selects are scheduled for 4.1, as far as I know (also see end of
page http://www.mysql.com/doc/M/y/MySQL-PostgreSQL_features.html)
As far as I know. There is no 3.24.xx coming out, but instead 4.0 in a few
days or weeks according to various posting on this list.
But I know be wrong!
Hope this help
Daniel
-Original Message-
From: John Seers [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 02, 2001 11:44
To: