SQL Stops correcting / working when I have a pivot.

CrispinProctor

Hi Folks,

My sql prompt 4.0.3.12 seems to stop working when I have a pivot in my code.
Another "odd" thing that happens is scrolling with the arrow keys is slow, as is typing. Holding down shift and using the arrow keys makes the cursor stumble across without highlighting the code. When you stop, it seems to catchup and highlight everything.

Snippets also stop working.

If I remove the pivot, it's all good again. Code is not really large, it's only 68 lines long. Without pivot, I have had a couple thousand and it's fine.

Anyone else have this?

CHeers,
Crispin

Anu D

Thanks for your feedback, and sorry you found this issue.

I have reproduced the symptoms you reported and it seems that the presence of PIVOT or UNPIVOT will stop SQL Prompt working as you described.

I have logged this as a bug with SQL Prompt, and it will hopefully be fixed in a future release.

For your reference the bug tracking code for the issue is SP-2885.

The only workaround I can really offer for the time being, is to comment out the words PIVOT or UNPIVOT, as this seems to kick SQL Prompt into life again.

Thanks for taking the time to let us know about this.

CrispinProctor

Thanks for the reply. I'll wait for an update.