Toad World® Forums

SQL parsing bug: collapse nodes are added without any visible logic


#1

TDM_SQL_parsing_bug2.png

I don’t see any logic in how TDM adds collapse nodes for SQL text. The correct behavior for the same text can be observed in Notepad++ :

Notepad_plus_plus_SQL_parsing.png


#2

Hello Sergei,

TDM supports a large number of database platforms and versions and each one of them might have slightly different SQL syntax. Unfortunately, the syntax analyzer TDM uses is not able to perfectly place the collapse nodes since it only focuses on general SQL syntax. If this function really matters to you, the workaround would be to write your SQL code in text editors that handle this feature better and then copy the final code into TDM.

Regards

Lukas