Michal, The MySQL highlighter mistakenly highlights any word as function that are contained in the function list, even if they don't have the functions brackets appended. In my case with the substring "MAX(x)" the highlighter interprets 'MAX' as well as 'x' as function.
On Wed, Aug 17, 2011 at 7:59 PM, Tyron Madlener tyronx@gmail.com wrote:
Michal, The MySQL highlighter mistakenly highlights any word as function that are contained in the function list, even if they don't have the functions brackets appended. In my case with the substring "MAX(x)" the highlighter interprets 'MAX' as well as 'x' as function.
And maybe it's possible to differ between keyword and statement verbs (select insert update delete etc). That would be great.
According to mysql 5.5 source code (sql_yacc.yy), these should be all valid statement verbs:
alter analyze begin binlog_base64_event call change check checksum commit create deallocate delete describe do drop execute flush grant handler insert install kill load lock optimize keycache partition_entry preload prepare purge release rename repair replace reset resignal revoke rollback savepoint select set signal show slave start truncate uninstall unlock update use xa
On Wed, Aug 17, 2011 at 8:18 PM, Tyron Madlener tyronx@gmail.com wrote:
On Wed, Aug 17, 2011 at 7:59 PM, Tyron Madlener tyronx@gmail.com wrote:
Michal, The MySQL highlighter mistakenly highlights any word as function that are contained in the function list, even if they don't have the functions brackets appended. In my case with the substring "MAX(x)" the highlighter interprets 'MAX' as well as 'x' as function.
And maybe it's possible to differ between keyword and statement verbs (select insert update delete etc). That would be great.
According to mysql 5.5 source code (sql_yacc.yy), these should be all valid statement verbs:
alter analyze begin binlog_base64_event call change check checksum commit create deallocate delete describe do drop execute flush grant handler insert install kill load lock optimize keycache partition_entry preload prepare purge release rename repair replace reset resignal revoke rollback savepoint select set signal show slave start truncate uninstall unlock update use xa
Oh, some are wrong. Fixed list:
alter analyze begin binlog call change check checksum commit create deallocate delete describe do drop execute flush grant handler insert install kill load lock optimize cache partition prepare purge release rename repair replace reset resignal revoke rollback savepoint select set signal show slave start truncate uninstall unlock update use xa
On Wed, Aug 17, 2011 at 8:32 PM, Tyron Madlener tyronx@gmail.com wrote:
On Wed, Aug 17, 2011 at 8:18 PM, Tyron Madlener tyronx@gmail.com wrote:
On Wed, Aug 17, 2011 at 7:59 PM, Tyron Madlener tyronx@gmail.com wrote:
Michal, The MySQL highlighter mistakenly highlights any word as function that are contained in the function list, even if they don't have the functions brackets appended. In my case with the substring "MAX(x)" the highlighter interprets 'MAX' as well as 'x' as function.
And maybe it's possible to differ between keyword and statement verbs (select insert update delete etc). That would be great.
According to mysql 5.5 source code (sql_yacc.yy), these should be all valid statement verbs:
alter analyze begin binlog_base64_event call change check checksum commit create deallocate delete describe do drop execute flush grant handler insert install kill load lock optimize keycache partition_entry preload prepare purge release rename repair replace reset resignal revoke rollback savepoint select set signal show slave start truncate uninstall unlock update use xa
Oh, some are wrong. Fixed list:
alter analyze begin binlog call change check checksum commit create deallocate delete describe do drop execute flush grant handler insert install kill load lock optimize cache partition prepare purge release rename repair replace reset resignal revoke rollback savepoint select set signal show slave start truncate uninstall unlock update use xa
Ok I just added this behavior myself. We just need a new css class for this now. Maybe it makes sense to give statements verbs a different color, let's say blue? Or better just the same keyword color?
Hi
Dne Wed, 17 Aug 2011 20:45:44 +0300 Tyron Madlener tyronx@gmail.com napsal(a):
Ok I just added this behavior myself. We just need a new css class for this now. Maybe it makes sense to give statements verbs a different color, let's say blue? Or better just the same keyword color?
I think it should stay consistent with PHP parser/highlighter, so see $GLOBALS['cfg']['SQP']['fmtColor'] for possible types.
-
Michal Čihař -
Tyron Madlener