Bug #7423 | VIEWs defined as SELECT with corelated SUBQUERY are sometimes buggy | ||
---|---|---|---|
Submitted: | 20 Dec 2004 11:26 | Modified: | 15 Jun 2005 8:24 |
Reporter: | Matthias Leich | Email Updates: | |
Status: | Can't repeat | Impact on me: | |
Category: | MySQL Server | Severity: | S2 (Serious) |
Version: | 5.0 | OS: | |
Assigned to: | Oleksandr Byelkin | CPU Architecture: | Any |
[20 Dec 2004 11:26]
Matthias Leich
[15 Jun 2005 8:24]
Oleksandr Byelkin
Thank you for bugreport, but I can't repeat this bug any more: + DROP TABLE IF EXISTS BASE_VS1; + Warnings: + Note 1051 Unknown table 'BASE_VS1' + CREATE TABLE BASE_VS1 (C1 INT, C2 INT); + CREATE VIEW VS3 AS + SELECT A.C2 FROM BASE_VS1 A WHERE A.C2 IN + (SELECT B.C1 FROM BASE_VS1 B WHERE B.C1 < A.C2); + SELECT * FROM VS3; + C2
[1 Nov 2006 16:48]
Matthias Leich
I can confirm that all problems within the NIST tests related to this bug disappeared. mysql-5.0 ChangeSet@1.2290, 2006-10-24