| [ < ] | [ > ] | [ << ] | [ Up ] | [ >> ] | [Top] | [Contents] | [Index] | [ ? ] |
The following known errors or bugs are not fixed in MySQL 4.0 because fixing them would involve changing a lot of code that could introduce other even worse bugs. The bugs are also classified as "not fatal" or "bearable."
In a UNION, the first SELECT determines the type,
max_length, and NULL properties for the resulting
columns. This issue is resolved in MySQL 4.1.1; the property values are based
on the rows from all UNION parts.
In DELETE with many tables, you can't refer to tables to be
deleted through an alias. This is fixed in 4.1.
You cannot mix UNION ALL and UNION DISTINCT in the same query.
If you use ALL for one UNION, it is used for all
of them.
This document was generated on July, 26 2004 using texi2html 1.70.
