BUG: The T-SQL formatter doesn't work when statement contains "ONLINE" clause!

Toad for SQL Server
1

Hi,

I’ve noticed that the built-in formatter doesn’t work on my “CREATE INDEX…” code (see the attached SQL). Quick investigation has shown the “ONLINE = OFF,” clause prevents proper formatting of the code. Here are two screenshots of the editor with and w/o this clause:

  1. Original statement (formatting fails)
    formatting_with_online.jpeg

  2. The “ONLINE = OFF,” clause is commented out and T-SQL is formatted properly.
    formatting_without_online.jpeg

The problem seems to affect Toad for SQL Server 6.6, as well as the latest beta 6.7.0.194 .

P.S. Just found out this is the core problem behind another issue described here!
create_index_sample.sql (276 Bytes)

2

I’ve logged this, will fix asap. (QP-1182)

Thanks for reporting.

Andre

3

Fixed.