When I run upper case keywords on a simple select with a case statement in the select list I get the following:

SELECT CASE WHEN a = b then 'a'
ELSE 'b'
end AS test
FROM actlink

The keywords THEN and END are being missed.

Tim
Denver, CO
tgoldstein
0

Comments

3 comments

  • Andras B
    When I run upper case keywords on a simple select with a case statement in the select list I get the following:

    SELECT CASE WHEN a = b then 'a'
    ELSE 'b'
    end AS test
    FROM actlink

    The keywords THEN and END are being missed.

    Tim
    Denver, CO

    Hi Tim,

    Many thanks for reporting this bug. We have already fixed it in our internal builds, and this will work properly in the final release.

    Regards,
    Andras
    Andras B
    0
  • MladenPrajdic
    It would also be nice to have lowercase keywords.

    some people dislike them in uppercase :)
    MladenPrajdic
    0
  • Andras B
    spirit1 wrote:
    It would also be nice to have lowercase keywords.

    some people dislike them in uppercase :)

    This is certainly an interesting and unexpected request. We are releasing version 1.0 in two weeks, so we are not adding anything to this version, but I will save this request for the future. Out of curiousity, how many other people would like to have "lowercase keywords"? Just respond to this post.

    Regards,
    Andras
    Andras B
    0

Add comment

Please sign in to leave a comment.