Bug #110471 | Fix docs for error 1093 | ||
---|---|---|---|
Submitted: | 22 Mar 2023 20:40 | Modified: | 23 Mar 2023 4:08 |
Reporter: | Mark Callaghan | Email Updates: | |
Status: | Verified | Impact on me: | |
Category: | MySQL Server: Errors | Severity: | S3 (Non-critical) |
Version: | 8.0 | OS: | Any |
Assigned to: | CPU Architecture: | Any |
[22 Mar 2023 20:40]
Mark Callaghan
[22 Mar 2023 22:39]
Mark Callaghan
It is odd that this gets error 1093 DELETE FROM t1 WHERE deviceid=4 AND timestamp IN (SELECT MIN(timestamp) FROM t1 WHERE deviceid=4) But this works DELETE FROM t1 WHERE deviceid=4 AND timestamp IN (select * from (SELECT MIN(timestamp) FROM t1 WHERE deviceid=4) as xx);
[23 Mar 2023 4:08]
MySQL Verification Team
Hello Mark, Thank you for the report and feedback! Thanks, Umesh
[2 Feb 19:26]
Jon Stephens
If the error message is incorrect, that's a software issue. Changing category to Errors so this can be fixed.