Be the star of a SQL Prompt case study. Learn more.

bug:Case and when become a word.

zhiyounetzhiyounet Posts: 10 New member
edited March 16, 2017 11:14PM in SQL Prompt
select round(case when 1 = 1 then 1
else 0
end,4);

Use the new formatting tool:
select round( casewhen1= 1 then 1
else 0
end, 4
);

Case and when become a word.

Comments

  • James RJames R Posts: 104 Silver 4
    Hi zhiyounet,

    Thanks for your post!
    This sql text collapse bug is a known issue. We have a a fix for it locally which will be contained in our next 7.5 beta release.

    Hope this helps!
    James
    Software Engineer
    Redgate Software
  • James RJames R Posts: 104 Silver 4
    Hi zhiyounet,

    We have just released a new stable build (7.5.0) which contains a fix for this bug! See here for more information.

    Please let us know if this fixes your issue.

    Thanks,
    James
    Software Engineer
    Redgate Software
  • zhiyounetzhiyounet Posts: 10 New member
    Thank you, the problem has been resolved
Sign In or Register to comment.