Bug #76594 | MySQL workbench freezes | ||
---|---|---|---|
Submitted: | 4 Apr 2015 14:42 | Modified: | 16 Feb 2018 22:56 |
Reporter: | Tomas Krejci | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Workbench | Severity: | S3 (Non-critical) |
Version: | 6.2.5 | OS: | MacOS (OS X 10.10.x Yosemite) |
Assigned to: | CPU Architecture: | Any | |
Tags: | WBBugReporter |
[4 Apr 2015 14:42]
Tomas Krejci
[6 Apr 2015 10:25]
MySQL Verification Team
Thank you for the bug report. Are you able to provide (private if you wish) the long query create table?. Thanks.
[6 Apr 2015 11:15]
Tomas Krejci
SET @csv_id = ''; SET @num = 1; CREATE TABLE 100tick_data AS SELECT `csv_id`, CONVERT(`datetime`, datetime) AS `datetime`, CAST(GROUP_FIRST(`open`) AS DECIMAL(32, 16)) AS `open`, MAX(`high`) AS `high`, MIN(`low`) AS `low`, CAST(GROUP_LAST(`close`) AS DECIMAL(32, 16)) AS `close`, SUM(`volume`) AS `volume`, SUM(`number_of_trades`) AS `number_of_trades`, SUM(`bid_volume`) AS `bid_volume`, SUM(`ask_volume`) AS `ask_volume` FROM ( SELECT d1.*, @num := IF(@csv_id = `csv_id`, @num + 1, 1) AS `dummy_1`, @csv_id := csv_id AS `dummy_2`, @num AS `row_number` FROM data d1 ORDER BY `csv_id`, `datetime`) d GROUP BY `csv_id`, d.`row_number` DIV 100;
[16 Apr 2015 15:13]
MySQL Verification Team
Thank you for the feedback.
[16 Feb 2018 22:56]
Christine Cole
Posted by developer: Fixed as of the upcoming MySQL Workbench 8.0.0 release, and here's the changelog entry: If the SCHEMAS tree was refreshed during a long query, MySQL Workbench became unresponsive until the query finished. Thank you for the bug report.