Toad World® Forums

A bug with SQL parsing: key words are analized inside text constants



In Entity Properties in SQL Preview parser considers key words inside comments. As you can see on the attached picture the from word is analyzed inside a text constant, and collapse nodes were added due to this bug.


This problem is related to the previous issue and the workaround is the same: use text editor designed for code editing and then copy/paste the final SQL code into TDM.




I disagree with you.

If your editor currently can’t even correctly identify text constants in the text of a SQL statement then you shouldn’t even try to provide collapse nodes. I suggest you remove collapse nodes from the functionality until this problem fixed. I would be better than to randomly set collapse nodes.