Bug #97281 Histogram creation and removal staments with syntax errors in Workbench
| Submitted: | 18 Oct 2019 7:40 | Modified: | 14 Jan 2020 7:32 |
|---|---|---|---|
| Reporter: | Georgi Sotirov | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Workbench: SQL Editor | Severity: | S3 (Non-critical) |
| Version: | 8.0.18 | OS: | Windows |
| Assigned to: | CPU Architecture: | x86 |
[18 Oct 2019 7:40]
Georgi Sotirov
[18 Oct 2019 7:45]
Georgi Sotirov
ANALYZE TABLE with UPDATE or DROP shows syntax error in Workbench
Attachment: wb_analyze_table_histogram_error.png (image/png, text), 12.61 KiB.
[22 Oct 2019 6:22]
MySQL Verification Team
Hello Georgi Sotirov, Thank you for the report. Verified as described. Regards, Ashwini Patil
[22 Oct 2019 6:26]
MySQL Verification Team
8.0.18 test results
Attachment: 97281_results.docx (application/vnd.openxmlformats-officedocument.wordprocessingml.document, text), 383.35 KiB.
[28 Oct 2019 19:05]
Christine Cole
Posted by developer: Fixed as of the upcoming MySQL Workbench 8.0.19 release, and here's the changelog entry: A syntax error was generated for valid ANALYZE TABLE statements with either the UPDATE HISTOGRAM or DROP HISTOGRAM clause. Thank you for the bug report.
[14 Jan 2020 7:32]
Georgi Sotirov
Verified fixed in Workbench 8.0.19 released yesterday.
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.055 sec. using MySQL 8.4.7-u6-cloud
Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the
respective copyright holders.
It is not reviewed in advance
by Oracle and does not necessarily represent the opinion of
Oracle or any other party.