Bug #75048 SQL Editor syntax error for modify column varchar

• Submitted: 29 Nov 2014 17:53
• Modified: 19 Sep 2015 1:40
• Reporter: David Marcus
• Status: Closed
• Category: MySQL Workbench: SQL Editor
• Severity: S3 (Non-critical)
• Version: 6.2.3, 6.2.4
• OS: Windows (Microsoft Windows 7 Home Premium)
• CPU Architecture: Any
• Tags: regression, WBBugReporter

[29 Nov 2014 17:53] David Marcus

Description:
The SQL Editor gives a syntax error for "alter table Foo modify column Bar varchar(10)". Version 6.1.7 does not give a syntax error.

How to repeat:
Enter 

alter table Foo modify Bar varchar(10)
 
in the SQL Editor. The editor puts the red squiggly line under "varchar" and says "Syntax error: unexpected 'varchar' (varchar)".

[29 Nov 2014 17:54] David Marcus

Workbench log file

Attachment: wb.log (application/octet-stream, text), 18.59 KiB.

[29 Nov 2014 18:29] MySQL Verification Team

Please try version 6.2.4. Thanks.

[29 Nov 2014 18:55] David Marcus

6.2.4 has the same problem.

[30 Nov 2014 8:54] MySQL Verification Team

Thank you for the feedback.

Confirmed that valid statement shows syntax error in SQL editor(no issues if executed)

create database if not exists test;
use test;
drop table if exists foo;
create table foo (str varchar(300));
alter table foo modify str varchar(500);
show create table foo;

Thanks,
Umesh

[30 Nov 2014 8:55] MySQL Verification Team

Screenshot..6.1.7

Attachment: 75048_6_1_7.png (image/png, text), 32.34 KiB.

[30 Nov 2014 8:55] MySQL Verification Team

Screenshot..6.2.4

Attachment: 75048_6_2_4.png (image/png, text), 43.41 KiB.

[20 Dec 2014 7:32] MySQL Verification Team

Bug #75278 marked as duplicate of this

[30 Jun 2015 4:38] Rayvin Stark

I met the same error in Workbench 6.3(version 6.3.3.0 build 592 64 bit).Have this problem been solved ? Thank you

[26 Jul 2015 10:15] Paul Weiss

Occurring for me in 6.3.4.0 on Microsoft Windows 7 Home Premium SP 1, 64-bit. Seem related, if not identical to bug #74183.

[13 Aug 2015 2:23] SOO WOON Jo

This bug occur in 6.3.4.0 build828 on Windows 8.1 Professional, but that query run successfully.
Maybe, it is only fault of displaying on workbench editor.

[19 Sep 2015 1:40] Philip Olson

Posted by developer:
 
Fixed as of the upcoming MySQL Workbench 6.3.5 release, and here's the changelog entry (note: this entry was combined with bug #77549):

The SQL parser and grammar was updated; some queries would emit bogus
errors, although they would execute with success. For example, queries
with syntax such as "ALTER TABLE foo MODIFY COLUMN bar
VARCHAR(10)" and "ALTER TABLE foo MODIFY bar INT NOT NULL".

Thank you for the bug report.