matthiasblaesing commented on issue #5159:
URL: https://github.com/apache/netbeans/issues/5159#issuecomment-1367362546

   This is a problem for lexers as MySQL decided to introduce a language not 
compatible with SQL. SQL-99 defines a string as delimited by single quotes, 
where the quote can be escaped by doubling it. See here:
   
   https://ronsavage.github.io/SQL/sql-99.bnf.html#character%20string%20literal
   https://ronsavage.github.io/SQL/sql-99.bnf.html#quote%20symbol
   
   So from an SQL grammar perspective the first value set holds a string 
literal, that ends directly before the t and is which is followed by the 
identifier `t`. The second value set does not hold any string, but the two 
identifiers `Test` and `This won\'t either`.
   
   I think I looked into this in the past and did not come up with a clean 
solution. If you can come up how to implement a lexer, that handles both cases 
without breaking existing samples, I'm happy to hear it, but I doubt it.


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

For further information about the NetBeans mailing lists, visit:
https://cwiki.apache.org/confluence/display/NETBEANS/Mailing+lists

Reply via email to