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

henrik_ffc

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;

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

krzysztofkroczak

Hi @henrik_ffc,

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

Best regards.
Krzysztof