Re: MySQL/InnoDB-5.0.2 is released

2004-12-03 Thread Heikki Tuuri
Walt, - Original Message - From: "kernel" <[EMAIL PROTECTED]> Newsgroups: mailing.database.myodbc Sent: Thursday, December 02, 2004 11:01 PM Subject: Re: MySQL/InnoDB-5.0.2 is released "MySQL to return wrong results if a SELECT uses two indexes at the same time&qu

Re: MySQL/InnoDB-5.0.2 is released

2004-12-02 Thread kernel
"MySQL to return wrong results if a SELECT uses two indexes at the same time" Does mysql 5.0.x have the ability to use more than one index per table on a select ? We had to rewrite a simple "select id from table_a where last_name like 'smith%' and first_name like 'john%'" to "select id from

MySQL/InnoDB-5.0.2 is released

2004-12-02 Thread Heikki Tuuri
Hi! InnoDB is the MySQL table type that supports FOREIGN KEY constraints, row-level locking, Oracle-style consistent, non-locking SELECTs, multiple tablespaces, and a non-free online hot backup tool. Release 5.0.2 is a snapshot of the 5.0 development branch of MySQL. Unfortunately, this snapsho