Bug or Not a Bug? – (part 1)

(EDIT: this article was published with a ‘part 1′ suffix in the title.  There will not be a’ part 2′. Read comments and you will understand why)

SELECT * FROM `first`;
/* returns
a
——
1
2
3
*/

CREATE TABLE IF NOT EXISTS `second`(`a` INT) SELECT * FROM `third`;

SELECT * FROM `first`;
/* returns
a
——
1
2
3
7
8
9
*/

Think about it!  Of course some special conditions will need to exist for this to be reproducible.

More details will appear here in a couple of days.