Bug #43257 length() function missing syntax-color

• Submitted: 27 Feb 2009 11:57
• Modified: 3 Mar 2009 13:58
• Reporter: Kjell Arne Rekaa
• Status: Won't fix
• Category: MySQL Query Browser
• Severity: S3 (Non-critical)
• Version: 1.2.17
• OS: Any
• CPU Architecture: Any

[27 Feb 2009 11:57] Kjell Arne Rekaa

Description:
When using s SELECT like e.g:

SELECT substr(url,8,(locate("/", url,9)-8)) URL, 
  FROM mytable WHERE length(othercolumn)>0;

SELECT, substr, locate, FROM and WHERE are are sytax-colored blue.
This is not the case for the length() function.

How to repeat:
E.g:
create table mytable (id int(11), url varchar(20), othercolumn varchar(20));
insert into mytable values (1,'www.tull.no', '1'), (2,'this.not.url','2456');
select * from mytable where length(othercolumn) >2;

[27 Feb 2009 12:13] MySQL Verification Team

Thank you for the bug report.

[3 Mar 2009 13:58] 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 add this feature request anymore.

More informations about MySQL Workbench you will find here:

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