Format Case Confuses Functions with Keywords

AndyJost

I use the case formatting in the pro edition to format reserved words as uppercase and functions as "Leave as is".

When I type "left outer join", the formatting treats "left" as a function and formats the text as "left OUTER JOIN". If I change the function formatting to uppercase, it correctly converts all three words to uppercase. Right outer join has the same issue.

I guess I really should be using the loj snippet!

Apart from that, the new UI looks great and it feels much more responsive (although I've only been using the new version for a few hours).

Anu D

Many thanks for your post.

Thanks for very clear explanation of issue I was able to reproduce it easily.

I have logged this issue as a bug whose reference number is SP-2765

Kindly let me know if you have any other issue regarding SQL prompt, I'll like to help.