Bug #47819 The word "type" is highlighted as a reserved word
Submitted: 5 Oct 2009 2:03 Modified: 20 Oct 2009 6:20
Reporter: Rob Gatzke Email Updates:
Status: Won't fix Impact on me:
None 
Category:MySQL Query Browser Severity:S3 (Non-critical)
Version:1.2.17 OS:Windows (Vista 64-bit)
Assigned to: CPU Architecture:Any
Tags: highlighting, reserved, reserved word, syntax, type, word

[5 Oct 2009 2:03] Rob Gatzke
Description:
Using MySQL Query Browser 1.2.17, I noticed that it was ok to name a column "type" even though it was highlighted blue (as a reserved word).

How to repeat:
DROP DATABASE IF EXISTS db_test;
CREATE DATABASE db_test;

USE db_test;

CREATE TABLE tbl
(
  type CHAR(3),
  num INT(4)
);

INSERT INTO tbl(type, num) VALUES('abc',1234);
[5 Oct 2009 6:08] Valeriy Kravchuk
Thank you for the problem report.
[20 Oct 2009 6:20] Susanne Ebrecht
Many thanks for writing a bug report. We are on the way to implement full functionality
of
MySQL Query Browser into MySQL Workbench. We won't fix this anymore.

Lots of functionalities of MySQL Query Browser are already implemented in Workbench 5.2
which will get GA soon.

More informations about MySQL Workbench you will find here:

http://dev.mysql.com/workbench/