From Komodo bug http://bugs.activestate.com/show_bug.cgi?id=100627 :
The SQL editor only recognizes "CREATE TABLE tabelname ( ..." as a foldable section.
I'ld expect that a multi-line CREATE VIEW viewname AS ... ; also be recognized as a foldable section.
A little experiment show that the recognizer requires a '(' somewhere on the same line as
CREATE VIEW and a somewhere down a (balancing) closing ")" . That is not correct (may be allowable in some implementations, but certainly not all) SQL syntax.
Because VIEW, PROCEDURE, INDEX and TRIGGER statements can be quite large folding would be a very nice "summarizing" tool.
This patch implements that, and also makes sure each call to LexerSQL::Fold encompasses the line after the last ';' before startPos, and ends at the next ';' after the requested end-position, because find resolution is done on non-comment non-string ';'s.
Log in to post a comment.