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

Bug: Error when formatting "alias = " as "AS alias"

When I try to format the following valid SQL with no space before "FROM":
SELECT principal_id =ISNULL(principal_id,0)FROM sys.objects
SQL prompt fails after converting the SQL into this invalid SQL (still no space before FROM):
SELECT ISNULL(principal_id,0) AS principal_idFROM sys.objects;
henrik_ffc
0

Comments

2 comments

Sort by
  • FredericoJ
    Hi @henrik_ffc ,

    Thank you for reporting this.

    We've recreated the problem locally and have generated an internal bug ticket (reference: SP-6449).

    Best regards,

    Frederico
    FredericoJ
    0
  • krzysztofkroczak
    Hi @henrik_ffc,

    The problem which you described is repaired in the newest version of prompt 8.0.7

    Best regards.
    Krzysztof
    krzysztofkroczak
    0

Add comment

Please sign in to leave a comment.