Jeremy,
I'm not a C/C++ coder so couldn't really help unless a binary was available.
At the same time, I understand that you'd be wasting your time building
binaries unless you were happy that the code was at a certain level of
completion (with regard to 4.1 specific features).
Your call. If a 4.1 binary was available then I'd spend time testing it with
a J2EE app under JBoss on Windows XP -- otherwise i'll just have to wait.
95% of the subselects I do are simple correlated subqueries like this:
select <columns>
from tableA
where exists (
select 1
from tableB
where tableB.myCol = tableA.myCol
)
or
select <columns> from tableA
where exists (
select 1
from tableB
where tableB.myCol = tableA.myCol
and tableB.someCol in ('A','B','C')
)
Regards,
Greg.
----- Original Message -----
From: "Jeremy Zawodny" <[EMAIL PROTECTED]>
To: "Greg Matthews" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Sunday, November 10, 2002 9:00 PM
Subject: Re: MySql 4.1 Sub Selects
> On Sun, Nov 10, 2002 at 05:51:43PM +1100, Greg Matthews wrote:
> >
> > It would be a huge help to get hold of MySql 4.1.
> >
> > What's "shaken out" mean? Is 4.1 still mid-development, or is it in
> > alpha, more or less finished, and needs debugging?
> >
> > Is there anyway soon that someone could build and release some
> > binaries? I'd be happy to do testing if 4.1 is in a semi-usable
> > state.
>
> I can build them and make 'em available. But I won't support them.
> If they crash for you, they crash. But they'd certainly be helpful
> for testing new features, if that's what you're intending.
> --
> Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo!
> <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/
>
> MySQL 3.23.51: up 96 days, processed 2,007,545,749 queries (241/sec. avg)
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
