Toad World® Forums

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


#1

TDM_SQL_parsing_bug.png

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.


#2

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.

Regards,

Lukas


#3

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.