mysql 4.x for debian?

Hello, what is the status of MySQL 4.x for debian? Does MySQL AB plan to release deb paketes or will MySQL AB support or encourage the debian pakete maintainers? Best regards Gunnar - Before posting, please check: http://

Re: optimizer bug: SELECT * FROM tbl_name,tbl_name2 ... ORDER BY key_

Hi all, >I gave not enough info about indexes. Use SHOW INDEX FROM table_name sorry, now 2nd try with more info. >> This bug was reported to fixed in 3.23.38. >> But the mysql versions 3.23.49 and in 4.0.2 >> both look like as the bug is in them again. >> >> Example: >> The following query

optimizer bug: SELECT * FROM tbl_name,tbl_name2 ... ORDER BY key_part1 LIMIT # uses filesort!

Hi, this bug was reported to fixed in 3.23.38. But the mysql vesions 3.23.49 and in 4.0.2 both look like the bug is in them again. Example: The following query should use the index on dog.dog_timestamp_cr but uses filesort instead. mysql> EXPLAIN SELECT dog.dog_id, dog.dog_name, sire.dog_na

Can this be done without UNION?

Hi all, I have a problem whith a very simple query. My problem is: it doesn't use indexes. It does full table scans instead. The only way I found to make it fast was using UNION. Can somebody please tell me, how I can make it fast (using indexes) without using UNION? My query: SELECT * FROM