The script of database are uploaded to:
support.mysql.com/pub/mysql/secret
The name is sqlreg_italo.sql.gz
I'am testing with MySQL 4.0.18-pro on Debian Linux Box.
Kernel 2.4 and 2.6
There is an error in MySQL optimizer !!!
test:
mysql SET FOREIGN_KEY_CHECKS=0;
Query OK, 0 rows affected
If there's a bug in the optimiser, you'll find it's in the higher
levels of the codebase. InnoDB doesn't have any SQL optimisation code
in it, so any bugs in this area aren't in InnoDB.
Regards,
Chris
Dyego Souza Dantas Leal wrote:
The script of database are uploaded to:
PROTECTED]
Lähetetty: Tuesday, March 02, 2004 2:39 PM
Aihe: InnoDB or MySQL error ?
The script of the database is attached.
The name is sqlreg_italo.sql.gz
I'am testing with MySQL 4.0.18-pro on Debian Linux Box.
Kernel 2.4 and 2.6
There is an error in MySQL optimizer !!!
test
Heikki:
Hi,
I would like to explain what is going on with the straight_join
when it is used with my database.
Suppose the command bellow:
explain select table1 left join table2 on A=B left join table3 on
C=D where ID = 1;
When it is executed on one of our servers, mySql uses
Dyego,
- Alkuperäinen viesti -
Lähettäjä: Dyego Souza Dantas Leal [EMAIL PROTECTED]
Vastaanottaja: Heikki Tuuri [EMAIL PROTECTED]
Kopio: [EMAIL PROTECTED]
Lähetetty: Tuesday, March 02, 2004 3:09 PM
Aihe: Re[2]: InnoDB or MySQL error ?
Heikki:
Hi,
I would like to explain what
