MySQL 5.0.25

2006-07-26 Thread Rick Robinson
I know the general philosophy with regards to releases, but the bug fix lists within MySQL 5.0.23, 24, and 25 seem substantial enough to merit a new binary release for MySQL. Does anyone else feel similarly on this? I'm really looking forward to MySQL 5.0.25...how about it? Best regards,

Where is release 5.0.23

2006-07-10 Thread Rick Robinson
The documentation shows MySQL 5.0.23 as released on July 4 - but I do not see it on any mirror anywhere? Does anyone know where MySQL 5.0.23 is? Is it released, as the doc says? Is it being held until release 5.0.24? Thanks for any update. Regards, R -- MySQL General Mailing List For

MySQL 5.0.x

2005-07-14 Thread Rick Robinson
Just a question on upcoming MySQL 5.0.x releases...what the heck is going on? I see doc notes for 5.0.8, 5.0.9, and 5.0.10 all concurrently. Is the plan to merge all these together for a single 5.0.10 release? Or will there be a 5.0.11 that merges all these? Just curious, as it seems that

RE: Use of limit with IN on subquery

2004-12-04 Thread Rick Robinson
Hi Shawn- This worked great. Perfect. Thanks very much for your help. If I can ever be of help, let me know - I owe you one. And thanks Michael and Roger for your help too. Best regards, Rick From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, December 03, 2004 2:14 PMTo:

Use of limit with IN on subquery

2004-12-03 Thread Rick Robinson
Hi all- I'm using MySQL 4.1.7, trying to do a subquery that's apparently unsupported - I'm hoping someone can provide a quick alternative for me. I have a simple table Z with 3 columns, k1, k2, and total_amt, where k1 and k2 make up the primary key. I want to create a report that lists the the

RE: Use of limit with IN on subquery

2004-12-03 Thread Rick Robinson
-Original Message- From: Roger Baklund [mailto:[EMAIL PROTECTED] Sent: Friday, December 03, 2004 10:32 AM To: Mysql Cc: [EMAIL PROTECTED] Subject: Re: Use of limit with IN on subquery Rick Robinson wrote: Hi all- I'm using MySQL 4.1.7, trying to do a subquery that's apparently unsupported

RE: Use of limit with IN on subquery

2004-12-03 Thread Rick Robinson
with IN on subquery Rick Robinson wrote: I'm using MySQL 4.1.7, trying to do a subquery that's apparently unsupported - I'm hoping someone can provide a quick alternative for me. I have a simple table Z with 3 columns, k1, k2, and total_amt, where k1 and k2 make up the primary key. I want to create

RE: Correlated subquery help

2004-12-02 Thread Rick Robinson
of (k1,k2) is a primary key? I dont have 4.1+ installed to test on but if you remove 'limit 10' and run it don't you get the same list as if you ran 'select k1,k2,total_amt from Z' ? - Original Message - From: Rick Robinson [EMAIL PROTECTED] To: Mysql [EMAIL PROTECTED] Sent: Wednesday

Correlated subquery help

2004-12-01 Thread Rick Robinson
Hi all- I'm using MySQL 4.1.7, trying to do a subquery that's apparently unsupported - I'm hoping someone can provide a quick alternative for me. I have a simple table Z with 3 columns, k1, k2, and total_amt, where k1 and k2 make up the primary key. I want to create a report that lists the the

Where is 4.1.7 max 32 bit binary for Solaris?

2004-11-02 Thread Rick Robinson
Is there any plan to release a 32-bit binary 4.1.7 MySQL max for Solaris 9 and Solaris 8? I see all the other binaries for Solaris for everything - any reason to exclude the 32 bit? Thx, R

Where is 4.1.7 max 32 bit binary for Solaris?

2004-10-27 Thread Rick Robinson
Is there any plan to release a 32-bit binary 4.1.7 MySQL max for Solaris 9 and Solaris 8? I see all the other binaries for Solaris for everything - any reason to exclude the 32 bit? Thx, R

Where is 4.1.6 max 32 bit binary for Solaris?

2004-10-26 Thread Rick Robinson
Is there any plan to release a 32-bit binary 4.1.6 MySQL max for Solaris 9 and Solaris 8? I see all the other binaries for Solaris for everything - any reason to exclude the 32 bit? Thx, R

Where is 4.1.6 max 32 bit binary for Solaris?

2004-10-25 Thread Rick Robinson
Is there any plan to release a 32-bit binary 4.1.6 MySQL max for Solaris 9 and Solaris 8? I see all the other binaries for Solaris for everything - any reason to exclude the 32 bit? Thx, R

Where is 4.1.6 max 32 bit binary for Solaris?

2004-10-21 Thread Rick Robinson
Is there any plan to release a 32-bit binary 4.1.6 MySQL max for Solaris 9 and Solaris 8? I see all the other binaries for Solaris for everything - any reason to exclude the 32 bit? Thx, R

Prepared statements C API 4.1.3

2004-08-27 Thread Rick Robinson
Is anyone using the new prepared statements C API in MySQL 4.1.3 with success? I see a number of people having issues - I'd like to hear about someone (anyone) actually using them successfully (platforms, compilers, issues, un-documented/mis-documented usage, etc.). I haven't been able to get it

4.1.3 and prepared statements

2004-08-26 Thread Rick Robinson
Title: 4.1.3 and prepared statements Hi all- Is the MySQL C API for prepared statements working at all in 4.1.3? I'm trying to do a relatively simple select test, and I consistently get an error on execute = MySQL client run out of memory. But it's a singleton select of one column and the

RE: 4.1.3 and prepared statements

2004-08-26 Thread Rick Robinson
); cout done endl; return 0; } /code _ From: Rick Robinson [mailto:[EMAIL PROTECTED] Sent: Thursday, August 26, 2004 6:24 PM To: Mysql Subject: 4.1.3 and prepared statements Hi all- Is the MySQL C API for prepared statements working at all in 4.1.3? I'm trying to do

MySQL 4.1.3 and time zone tables

2004-07-06 Thread Rick Robinson
Is there supposed to be data loaded into the mysql.time_zone* tables? There is none in the Solaris binaries nor the Win32 binaries. Is this a bug? Does anyone know? Thanks, Rick

4.1.3 and time zones

2004-07-02 Thread Rick Robinson
Hi all- I just downloaded and installed 4.1.3 on a WinXP environment. Does anyone happen to have the data that should be loaded into all the new time zone catalog tables? And the doc that describes the convert_tz() function and a little more on general use of the time zone capability? My time

Possible problem with outer join in 4.1.2

2004-06-11 Thread Rick Robinson
Hi all- I'm not certain if this is a bug in MySQL, a bug in Oracle, or a possible miscoding of my outer join, but I have a scenario in which I've replicated a table set up and query from an Oracle application and I'm not getting the same result set. The following script sets up the representative

RE: Possible problem with outer join in 4.1.2

2004-06-11 Thread Rick Robinson
Yours, Shawn Green Database Administrator Unimin Corporation - Spruce Pine Rick Robinson [EMAIL PROTECTED]To: Mysql [EMAIL PROTECTED] cc

MySQL 4.1.2 for Win32 issue?

2004-06-01 Thread Rick Robinson
I saw the announcement regarding some sort of issue with getting MySQL 4.1.2 ready for the Win32 platform - so what is the specific problem? I'm not saying that I could fix it, but I bet many others on the list could contribute nad/or fix it if the details of the problem were known. I'm looking

Compatibility question

2004-02-27 Thread Rick Robinson
Is a statically linked 3.23.x MySQL client compatible with a 4.1.x server? (Assuming the use of old-passwords). Thanks, R

MySQL Administrator

2004-02-10 Thread Rick Robinson
Is there a rough estimate as to when it will be available? The screenshots look awesome. Thx, R

Myisampack missing from 4.1.1 Win32 binaries

2004-02-06 Thread Rick Robinson
Hello all- Is the myisampack utility supposed to be included in the 4.1.1 binaries for Windows? It's not there - I couldn't find any explicit reference in the doc about whether this is deliberate or maybe it was just missed? Thanks, Rick

5.0 binary question

2003-12-29 Thread Rick Robinson
I downloaded the 5.0 preview alpha binary for Win32 and installed it - so far, so good. But I don't see anything in the doc on the stored procedure capability (how-to/syntax) and I can't create one within 5.0 (using SQL99 syntax - at least I think/hope so). Is stored procedure capability not

RE: 5.0 binary question

2003-12-29 Thread Rick Robinson
- sp-error.test Best regards, Mikhail. - Original Message - From: Rick Robinson [EMAIL PROTECTED] To: Mysql [EMAIL PROTECTED] Sent: Tuesday, December 30, 2003 12:14 AM Subject: 5.0 binary question I downloaded the 5.0 preview alpha binary for Win32 and installed it - so far, so good

RE: MySQL C API

2003-09-10 Thread Rick Robinson
Håkan- The prepared statement capability isn't available until 4.1 (I believe). Best of luck, Regards, Rick -Original Message- From: Håkan Medin [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 10, 2003 4:31 AM To: [EMAIL PROTECTED] Subject: MySQL C API Hello All, I am trying to

Mysql 4.1.1

2003-08-16 Thread Rick Robinson
When will 4.1.1 be officially available in a packaged download? Just curious. Thx, Rick -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Non-blocking via C API?

2003-07-18 Thread Rick Robinson
I've been through the mysql doc for the C API in both mysql 4.0 and 4.1, but I don't see anything that explicitly supports non-blocking and/or cancel-able operations. For example, the mysql_real_query API doesn't take a timeout value and doesn't have any way to issue an asynchronous request. The

RE: Date query optimization

2003-07-02 Thread Rick Robinson
Hi Karl- I often use a unix timestamp value for my dates (an unsigned mediumint is adequate) and index that. However, using date/time functions in the where clause does have a significant impact on the execution times, even when the index is used and the EXPLAIN output appears the same. See

RE: SOLVED! (was: Re: What is wrong with this query?)

2002-12-24 Thread Rick Robinson
It's not a true daemon...Mike's comment on using a wait or waitpid is valid. If you're interested, read up on daemon processes in APUE (chap. 13) from Stevens. Your process is still associated with a terminal and is not the process group leader and is not the session leader. I highly recommend

High volume HEAP table

2002-08-18 Thread Rick Robinson
Hi all, I'm testing using a HEAP table to maintain transient state in a high volume TP environment. So far, it looks promising, and I want to ask anyone about similar experiences and solicit some input. Some background: * I have one table; the row length is ~200 bytes and the table will

MySQL 4.1

2002-03-13 Thread Rick Robinson
When is MySQL 4.1 coming out? The web site says a 4.1 alpha in December/January - is that December of 2002 or the Dec that just passed? I think it would be great if a tenative MySQL release schedule was published and updated monthly (or so) with progress info included. Thanks, Rick