How can we help you today? How can we help you today?

Format Case Confuses Functions with Keywords

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).
AndyJost
0

Comments

1 comment

Sort by
  • 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.
    Anu D
    0

Add comment

Please sign in to leave a comment.