This Bugzilla instance is a read-only archive of historic NetBeans bug reports. To report a bug in NetBeans please follow the project's instructions for reporting issues.

Bug 203283 - Highlight all reserved words in MySQL
Summary: Highlight all reserved words in MySQL
Status: NEW
Alias: None
Product: db
Classification: Unclassified
Component: SQL Editor (show other bugs)
Version: 7.2
Hardware: All All
: P4 normal (vote)
Assignee: Libor Fischmeistr
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2011-10-07 08:53 UTC by fruit
Modified: 2013-08-01 12:52 UTC (History)
0 users

See Also:
Issue Type: ENHANCEMENT
Exception Reporter:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description fruit 2011-10-07 08:53:33 UTC
Environment: NetBeans 7.1-beta, Linux (Fedora 14)

Hi,

It would be great to highlight all MySQL 5.5 reserved words in SQL editor.

Here is official reserved word list: http://dev.mysql.com/doc/mysqld-version-reference/en/mysqld-version-reference-reservedwords-5-5.html


The current SQL editor does not highlights the following words: ACCESSIBLE, ANALYZE, BIGINT, CHANGE, DATABASES, DAY_HOUR, DAY_MICROSECOND, DAY_MINUTE, DAY_SECOND, DELAYED, DISTINCTROW, DIV, DUAL, ENCLOSED, ESCAPED, EXPLAIN, FLOAT4, FLOAT8, FORCE, FULLTEXT, HIGH_PRIORITY, HOUR_MICROSECOND, HOUR_MINUTE, HOUR_SECOND, IGNORE_SERVER_IDS, INDEX, INFILE, INT1, INT2, INT3, INT4, INT8, KEYS, KILL, LINEAR, LINES, LOAD, LOCK, LONG, LONGBLOB, LONGTEXT, LOW_PRIORITY, MASTER_HEARTBEAT_PERIOD, MASTER_SSL_VERIFY_SERVER_CERT, MAXVALUE, MEDIUMBLOB, MEDIUMTEXT, MIDDLEINT, MINUTE_MICROSECOND, MINUTE_SECOND, NO_WRITE_TO_BINLOG, OPTIMIZE, OPTIONALLY, OUTFILE, PURGE, RANGE, READ_WRITE, REGEXP, RELEASE, RENAME, REQUIRE, RLIKE, SCHEMAS, SECOND_MICROSECOND, SEPARATOR, SHOW, SLOW, SPATIAL, SQL_BIG_RESULT, SQL_CALC_FOUND_ROWS, SQL_SMALL_RESULT, SSL, STARTING, STRAIGHT_JOIN, TERMINATED, TINYBLOB, TINYINT, TINYTEXT, UNDO, UNLOCK, UNSIGNED, USE, UTC_DATE, UTC_TIME, UTC_TIMESTAMP, VARBINARY, VARCHARACTER, XOR, YEAR_MONTH, ZEROFILL.

Thanks
Comment 1 Miloslav Metelka 2012-06-11 09:11:39 UTC
The maintainer of the SQL Lexer must extend it to recognize these reserved words. Reassigning to db module.