The following known issues have not been fixed in MySQL 4.0 for various reasons, and are not classified as critical.
Fixed in MySQL 4.1.10: Using
you can get a crash or wrong result if you use an alias to
RAND() function. This
will not be fixed in 4.0 because the fix may break
compatability with some applications.
Fixed in MySQL 4.1: In
DELETE with many tables,
you can't refer to tables to be deleted through an alias.
When using the
function (or any function adding spaces to the right) in a
query that had to be resolved by using a temporary table,
all resulting strings had rightmost spaces removed (that
RPAD() did not work).