Formatter gone wild

Toad for Oracle & DevOps Toolkit
1

I had a file format with a SQL syntax error that I think was from a partially uncomment comment block that had a couple of the leading that right-aligned a commented line with 169382 spaces. I captured the test of the bad lines, but not the exact scenario. I was formatting and letting the formatter find the next uncommented line a couple of times. This was the end result:

blank line
-- TRANSLATE ... this line right aligned
--  this one remained

A nice Error 45 initializing SQL*Plus and an exit was the results when executing.

I’m not clamoring for a fix or deep dive research since I’ve only seen this twice over the past many months. I’m just pointing out a headache that may let someone else identify it quicker.

2

Hello chazamania,

How could I reproduce this? Please could you give me a short snippet that shows what’s happening after formatting it? Would be a great help.

Thanks,
Andre

3

Andre,

I’m still looking. This is super rare and the last time it happened I couldn’t even get the undo/redo to take it to the pre-format state that would repeat in the formatter.