List:General Discussion« Previous MessageNext Message »
From:Greg Matthews Date:November 10 2002 10:29am
Subject:Re: MySql 4.1 Sub Selects
View as plain text  
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" <Jeremy@stripped>
To: "Greg Matthews" <greg55@stripped>
Cc: <mysql@stripped>
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!
> <Jeremy@stripped>  |  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 <mysql-thread124555@stripped>
> To unsubscribe, e-mail
<mysql-unsubscribe-greg55=ozemail.com.au@stripped>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>

Thread
MySql 4.1 Sub SelectsGreg Matthews10 Nov
  • Re: MySql 4.1 Sub SelectsJeremy Zawodny10 Nov
  • Re: MySql 4.1 Sub SelectsGreg Matthews10 Nov
    • Re: MySql 4.1 Sub SelectsJeremy Zawodny10 Nov
  • Re: MySql 4.1 Sub SelectsJocelyn Fournier10 Nov
  • Re: MySql 4.1 Sub SelectsGreg Matthews10 Nov
    • Re: MySql 4.1 Sub SelectsJeremy Zawodny10 Nov
  • Re: MySql 4.1 Sub SelectsHarald Fuchs10 Nov
  • Re: MySql 4.1 Sub SelectsGreg Matthews10 Nov
  • Re: MySql 4.1 Sub SelectsMichael T. Babcock11 Nov
  • Re: MySql 4.1 Sub SelectsGreg Matthews11 Nov
RE: MySql 4.1 Sub Selectsdaniel11 Nov
  • re: RE: MySql 4.1 Sub SelectsVictoria Reznichenko11 Nov
    • RE: RE: MySql 4.1 Sub SelectsDan Rossi11 Nov
      • Re: RE: MySql 4.1 Sub Selects and not stored proceduresGreg Matthews11 Nov
        • RE: RE: MySql 4.1 Sub Selects and not stored proceduresArthur Fuller11 Nov
          • Re: RE: MySql 4.1 Sub Selects and not stored proceduresGreg Matthews11 Nov
        • Re: MySql 4.1 Sub Selects and not stored proceduresDan Nelson11 Nov
        • Re: RE: MySql 4.1 Sub Selects and not stored proceduresJohn Ragan11 Nov
      • Re: MySql 4.1 Sub SelectsMichael T. Babcock11 Nov
re[2]: MySql 4.1 Sub SelectsRichard Morton11 Nov
  • Re: re[2]: MySql 4.1 Sub SelectsLenz Grimmer11 Nov