SQLPrompt 9.5.18.11513 still misformats IS_ROLEMEMBER and makes the sql statement invalid

gvarol@corelogic.com

SQLPrompt 9.5.18.11513 formats
SELECT IS_ROLEMEMBER('db_owner')
to
SELECT [IS_ROLEMEMBER]('db_owner') 
and the sql becomes invalid

The list of sql server functions can be found at
https://docs.microsoft.com/en-us/sql/t-sql/functions/functions?view=sql-server-2017

squigley

Good Morning!

Thanks for your inquiry and sorry to hear about your issue with SQL Prompt.

Can you go into more detail on how you get this incorrect format?

I tried replicating this on my end by typing out the same SQL line, but SQL Prompt never formats it to have [] even when I try to force it manually.

gvarol@corelogic.com

gvarol@corelogic.com

Also I noticed if there is something wrong in the sql and it fails to format it stull puts square brackets ([]) around ISNULL, QUOTENAME, SCHEMA_NAME etc function, check that out too.

squigley

Thanks for those screenshots and details.

Can you confirm what version you're seeing this under? The developers have informed me that the current latest version 9.5.18 should be able to handle this better.

gvarol@corelogic.com

it's in the subject of the ticket.

Tianjiao_Li

Thanks @gvarol@corelogic.com

As I said on https://forum.red-gate.com/discussion/85883/sql-prompt-misformats-is-rolemember-function-version-9-5-16-11294 I'll reach out by email for more information.

Thanks.